CREATE OR REPLACE PACKAGE MYSQLAPP
IS
-- 文字列リストの P_INDEX 番目の要素を戻す
FUNCTION ELT(
P_INDEX IN BINARY_INTEGER,
P_V001 IN VARCHAR2, P_V002 IN VARCHAR2 := NULL, P_V003 IN VARCHAR2 := NULL, P_V004 IN VARCHAR2 := NULL, P_V005 IN VARCHAR2 := NULL,
P_V006 IN VARCHAR2 := NULL, P_V007 IN VARCHAR2 := NULL, P_V008 IN VARCHAR2 := NULL, P_V009 IN VARCHAR2 := NULL, P_V010 IN VARCHAR2 := NULL,
P_V011 IN VARCHAR2 := NULL, P_V012 IN VARCHAR2 := NULL, P_V013 IN VARCHAR2 := NULL, P_V014 IN VARCHAR2 := NULL, P_V015 IN VARCHAR2 := NULL,
P_V016 IN VARCHAR2 := NULL, P_V017 IN VARCHAR2 := NULL, P_V018 IN VARCHAR2 := NULL, P_V019 IN VARCHAR2 := NULL, P_V020 IN VARCHAR2 := NULL,
P_V021 IN VARCHAR2 := NULL, P_V022 IN VARCHAR2 := NULL, P_V023 IN VARCHAR2 := NULL, P_V024 IN VARCHAR2 := NULL, P_V025 IN VARCHAR2 := NULL,
P_V026 IN VARCHAR2 := NULL, P_V027 IN VARCHAR2 := NULL, P_V028 IN VARCHAR2 := NULL, P_V029 IN VARCHAR2 := NULL, P_V030 IN VARCHAR2 := NULL,
P_V031 IN VARCHAR2 := NULL, P_V032 IN VARCHAR2 := NULL, P_V033 IN VARCHAR2 := NULL, P_V034 IN VARCHAR2 := NULL, P_V035 IN VARCHAR2 := NULL,
P_V036 IN VARCHAR2 := NULL, P_V037 IN VARCHAR2 := NULL, P_V038 IN VARCHAR2 := NULL, P_V039 IN VARCHAR2 := NULL, P_V040 IN VARCHAR2 := NULL,
P_V041 IN VARCHAR2 := NULL, P_V042 IN VARCHAR2 := NULL, P_V043 IN VARCHAR2 := NULL, P_V044 IN VARCHAR2 := NULL, P_V045 IN VARCHAR2 := NULL,
P_V046 IN VARCHAR2 := NULL, P_V047 IN VARCHAR2 := NULL, P_V048 IN VARCHAR2 := NULL, P_V049 IN VARCHAR2 := NULL, P_V050 IN VARCHAR2 := NULL,
P_V051 IN VARCHAR2 := NULL, P_V052 IN VARCHAR2 := NULL, P_V053 IN VARCHAR2 := NULL, P_V054 IN VARCHAR2 := NULL, P_V055 IN VARCHAR2 := NULL,
P_V056 IN VARCHAR2 := NULL, P_V057 IN VARCHAR2 := NULL, P_V058 IN VARCHAR2 := NULL, P_V059 IN VARCHAR2 := NULL, P_V060 IN VARCHAR2 := NULL,
P_V061 IN VARCHAR2 := NULL, P_V062 IN VARCHAR2 := NULL, P_V063 IN VARCHAR2 := NULL, P_V064 IN VARCHAR2 := NULL, P_V065 IN VARCHAR2 := NULL,
P_V066 IN VARCHAR2 := NULL, P_V067 IN VARCHAR2 := NULL, P_V068 IN VARCHAR2 := NULL, P_V069 IN VARCHAR2 := NULL, P_V070 IN VARCHAR2 := NULL,
P_V071 IN VARCHAR2 := NULL, P_V072 IN VARCHAR2 := NULL, P_V073 IN VARCHAR2 := NULL, P_V074 IN VARCHAR2 := NULL, P_V075 IN VARCHAR2 := NULL,
P_V076 IN VARCHAR2 := NULL, P_V077 IN VARCHAR2 := NULL, P_V078 IN VARCHAR2 := NULL, P_V079 IN VARCHAR2 := NULL, P_V080 IN VARCHAR2 := NULL,
P_V081 IN VARCHAR2 := NULL, P_V082 IN VARCHAR2 := NULL, P_V083 IN VARCHAR2 := NULL, P_V084 IN VARCHAR2 := NULL, P_V085 IN VARCHAR2 := NULL,
P_V086 IN VARCHAR2 := NULL, P_V087 IN VARCHAR2 := NULL, P_V088 IN VARCHAR2 := NULL, P_V089 IN VARCHAR2 := NULL, P_V090 IN VARCHAR2 := NULL,
P_V091 IN VARCHAR2 := NULL, P_V092 IN VARCHAR2 := NULL, P_V093 IN VARCHAR2 := NULL, P_V094 IN VARCHAR2 := NULL, P_V095 IN VARCHAR2 := NULL,
P_V096 IN VARCHAR2 := NULL, P_V097 IN VARCHAR2 := NULL, P_V098 IN VARCHAR2 := NULL, P_V099 IN VARCHAR2 := NULL, P_V100 IN VARCHAR2 := NULL,
P_V101 IN VARCHAR2 := NULL, P_V102 IN VARCHAR2 := NULL, P_V103 IN VARCHAR2 := NULL, P_V104 IN VARCHAR2 := NULL, P_V105 IN VARCHAR2 := NULL,
P_V106 IN VARCHAR2 := NULL, P_V107 IN VARCHAR2 := NULL, P_V108 IN VARCHAR2 := NULL, P_V109 IN VARCHAR2 := NULL, P_V110 IN VARCHAR2 := NULL,
P_V111 IN VARCHAR2 := NULL, P_V112 IN VARCHAR2 := NULL, P_V113 IN VARCHAR2 := NULL, P_V114 IN VARCHAR2 := NULL, P_V115 IN VARCHAR2 := NULL,
P_V116 IN VARCHAR2 := NULL, P_V117 IN VARCHAR2 := NULL, P_V118 IN VARCHAR2 := NULL, P_V119 IN VARCHAR2 := NULL, P_V120 IN VARCHAR2 := NULL,
P_V121 IN VARCHAR2 := NULL, P_V122 IN VARCHAR2 := NULL, P_V123 IN VARCHAR2 := NULL, P_V124 IN VARCHAR2 := NULL, P_V125 IN VARCHAR2 := NULL,
P_V126 IN VARCHAR2 := NULL, P_V127 IN VARCHAR2 := NULL, P_V128 IN VARCHAR2 := NULL, P_V129 IN VARCHAR2 := NULL, P_V130 IN VARCHAR2 := NULL,
P_V131 IN VARCHAR2 := NULL, P_V132 IN VARCHAR2 := NULL, P_V133 IN VARCHAR2 := NULL, P_V134 IN VARCHAR2 := NULL, P_V135 IN VARCHAR2 := NULL,
P_V136 IN VARCHAR2 := NULL, P_V137 IN VARCHAR2 := NULL, P_V138 IN VARCHAR2 := NULL, P_V139 IN VARCHAR2 := NULL, P_V140 IN VARCHAR2 := NULL,
P_V141 IN VARCHAR2 := NULL, P_V142 IN VARCHAR2 := NULL, P_V143 IN VARCHAR2 := NULL, P_V144 IN VARCHAR2 := NULL, P_V145 IN VARCHAR2 := NULL,
P_V146 IN VARCHAR2 := NULL, P_V147 IN VARCHAR2 := NULL, P_V148 IN VARCHAR2 := NULL, P_V149 IN VARCHAR2 := NULL, P_V150 IN VARCHAR2 := NULL,
P_V151 IN VARCHAR2 := NULL, P_V152 IN VARCHAR2 := NULL, P_V153 IN VARCHAR2 := NULL, P_V154 IN VARCHAR2 := NULL, P_V155 IN VARCHAR2 := NULL,
P_V156 IN VARCHAR2 := NULL, P_V157 IN VARCHAR2 := NULL, P_V158 IN VARCHAR2 := NULL, P_V159 IN VARCHAR2 := NULL, P_V160 IN VARCHAR2 := NULL,
P_V161 IN VARCHAR2 := NULL, P_V162 IN VARCHAR2 := NULL, P_V163 IN VARCHAR2 := NULL, P_V164 IN VARCHAR2 := NULL, P_V165 IN VARCHAR2 := NULL,
P_V166 IN VARCHAR2 := NULL, P_V167 IN VARCHAR2 := NULL, P_V168 IN VARCHAR2 := NULL, P_V169 IN VARCHAR2 := NULL, P_V170 IN VARCHAR2 := NULL,
P_V171 IN VARCHAR2 := NULL, P_V172 IN VARCHAR2 := NULL, P_V173 IN VARCHAR2 := NULL, P_V174 IN VARCHAR2 := NULL, P_V175 IN VARCHAR2 := NULL,
P_V176 IN VARCHAR2 := NULL, P_V177 IN VARCHAR2 := NULL, P_V178 IN VARCHAR2 := NULL, P_V179 IN VARCHAR2 := NULL, P_V180 IN VARCHAR2 := NULL,
P_V181 IN VARCHAR2 := NULL, P_V182 IN VARCHAR2 := NULL, P_V183 IN VARCHAR2 := NULL, P_V184 IN VARCHAR2 := NULL, P_V185 IN VARCHAR2 := NULL,
P_V186 IN VARCHAR2 := NULL, P_V187 IN VARCHAR2 := NULL, P_V188 IN VARCHAR2 := NULL, P_V189 IN VARCHAR2 := NULL, P_V190 IN VARCHAR2 := NULL,
P_V191 IN VARCHAR2 := NULL, P_V192 IN VARCHAR2 := NULL, P_V193 IN VARCHAR2 := NULL, P_V194 IN VARCHAR2 := NULL, P_V195 IN VARCHAR2 := NULL,
P_V196 IN VARCHAR2 := NULL, P_V197 IN VARCHAR2 := NULL, P_V198 IN VARCHAR2 := NULL, P_V199 IN VARCHAR2 := NULL, P_V200 IN VARCHAR2 := NULL,
P_V201 IN VARCHAR2 := NULL, P_V202 IN VARCHAR2 := NULL, P_V203 IN VARCHAR2 := NULL, P_V204 IN VARCHAR2 := NULL, P_V205 IN VARCHAR2 := NULL,
P_V206 IN VARCHAR2 := NULL, P_V207 IN VARCHAR2 := NULL, P_V208 IN VARCHAR2 := NULL, P_V209 IN VARCHAR2 := NULL, P_V210 IN VARCHAR2 := NULL,
P_V211 IN VARCHAR2 := NULL, P_V212 IN VARCHAR2 := NULL, P_V213 IN VARCHAR2 := NULL, P_V214 IN VARCHAR2 := NULL, P_V215 IN VARCHAR2 := NULL,
P_V216 IN VARCHAR2 := NULL, P_V217 IN VARCHAR2 := NULL, P_V218 IN VARCHAR2 := NULL, P_V219 IN VARCHAR2 := NULL, P_V220 IN VARCHAR2 := NULL,
P_V221 IN VARCHAR2 := NULL, P_V222 IN VARCHAR2 := NULL, P_V223 IN VARCHAR2 := NULL, P_V224 IN VARCHAR2 := NULL, P_V225 IN VARCHAR2 := NULL,
P_V226 IN VARCHAR2 := NULL, P_V227 IN VARCHAR2 := NULL, P_V228 IN VARCHAR2 := NULL, P_V229 IN VARCHAR2 := NULL, P_V230 IN VARCHAR2 := NULL,
P_V231 IN VARCHAR2 := NULL, P_V232 IN VARCHAR2 := NULL, P_V233 IN VARCHAR2 := NULL, P_V234 IN VARCHAR2 := NULL, P_V235 IN VARCHAR2 := NULL,
P_V236 IN VARCHAR2 := NULL, P_V237 IN VARCHAR2 := NULL, P_V238 IN VARCHAR2 := NULL, P_V239 IN VARCHAR2 := NULL, P_V240 IN VARCHAR2 := NULL,
P_V241 IN VARCHAR2 := NULL, P_V242 IN VARCHAR2 := NULL, P_V243 IN VARCHAR2 := NULL, P_V244 IN VARCHAR2 := NULL, P_V245 IN VARCHAR2 := NULL,
P_V246 IN VARCHAR2 := NULL, P_V247 IN VARCHAR2 := NULL, P_V248 IN VARCHAR2 := NULL, P_V249 IN VARCHAR2 := NULL, P_V250 IN VARCHAR2 := NULL,
P_V251 IN VARCHAR2 := NULL, P_V252 IN VARCHAR2 := NULL, P_V253 IN VARCHAR2 := NULL, P_V254 IN VARCHAR2 := NULL, P_V255 IN VARCHAR2 := NULL)
RETURN VARCHAR2;
-- 文字列リスト内で P_KEY のインデックス (位置) を戻す
FUNCTION FIELD(
P_KEY IN VARCHAR2,
P_V001 IN VARCHAR, P_V002 IN VARCHAR2 := NULL, P_V003 IN VARCHAR2 := NULL, P_V004 IN VARCHAR2 := NULL, P_V005 IN VARCHAR2 := NULL,
P_V006 IN VARCHAR2 := NULL, P_V007 IN VARCHAR2 := NULL, P_V008 IN VARCHAR2 := NULL, P_V009 IN VARCHAR2 := NULL, P_V010 IN VARCHAR2 := NULL,
P_V011 IN VARCHAR2 := NULL, P_V012 IN VARCHAR2 := NULL, P_V013 IN VARCHAR2 := NULL, P_V014 IN VARCHAR2 := NULL, P_V015 IN VARCHAR2 := NULL,
P_V016 IN VARCHAR2 := NULL, P_V017 IN VARCHAR2 := NULL, P_V018 IN VARCHAR2 := NULL, P_V019 IN VARCHAR2 := NULL, P_V020 IN VARCHAR2 := NULL,
P_V021 IN VARCHAR2 := NULL, P_V022 IN VARCHAR2 := NULL, P_V023 IN VARCHAR2 := NULL, P_V024 IN VARCHAR2 := NULL, P_V025 IN VARCHAR2 := NULL,
P_V026 IN VARCHAR2 := NULL, P_V027 IN VARCHAR2 := NULL, P_V028 IN VARCHAR2 := NULL, P_V029 IN VARCHAR2 := NULL, P_V030 IN VARCHAR2 := NULL,
P_V031 IN VARCHAR2 := NULL, P_V032 IN VARCHAR2 := NULL, P_V033 IN VARCHAR2 := NULL, P_V034 IN VARCHAR2 := NULL, P_V035 IN VARCHAR2 := NULL,
P_V036 IN VARCHAR2 := NULL, P_V037 IN VARCHAR2 := NULL, P_V038 IN VARCHAR2 := NULL, P_V039 IN VARCHAR2 := NULL, P_V040 IN VARCHAR2 := NULL,
P_V041 IN VARCHAR2 := NULL, P_V042 IN VARCHAR2 := NULL, P_V043 IN VARCHAR2 := NULL, P_V044 IN VARCHAR2 := NULL, P_V045 IN VARCHAR2 := NULL,
P_V046 IN VARCHAR2 := NULL, P_V047 IN VARCHAR2 := NULL, P_V048 IN VARCHAR2 := NULL, P_V049 IN VARCHAR2 := NULL, P_V050 IN VARCHAR2 := NULL,
P_V051 IN VARCHAR2 := NULL, P_V052 IN VARCHAR2 := NULL, P_V053 IN VARCHAR2 := NULL, P_V054 IN VARCHAR2 := NULL, P_V055 IN VARCHAR2 := NULL,
P_V056 IN VARCHAR2 := NULL, P_V057 IN VARCHAR2 := NULL, P_V058 IN VARCHAR2 := NULL, P_V059 IN VARCHAR2 := NULL, P_V060 IN VARCHAR2 := NULL,
P_V061 IN VARCHAR2 := NULL, P_V062 IN VARCHAR2 := NULL, P_V063 IN VARCHAR2 := NULL, P_V064 IN VARCHAR2 := NULL, P_V065 IN VARCHAR2 := NULL,
P_V066 IN VARCHAR2 := NULL, P_V067 IN VARCHAR2 := NULL, P_V068 IN VARCHAR2 := NULL, P_V069 IN VARCHAR2 := NULL, P_V070 IN VARCHAR2 := NULL,
P_V071 IN VARCHAR2 := NULL, P_V072 IN VARCHAR2 := NULL, P_V073 IN VARCHAR2 := NULL, P_V074 IN VARCHAR2 := NULL, P_V075 IN VARCHAR2 := NULL,
P_V076 IN VARCHAR2 := NULL, P_V077 IN VARCHAR2 := NULL, P_V078 IN VARCHAR2 := NULL, P_V079 IN VARCHAR2 := NULL, P_V080 IN VARCHAR2 := NULL,
P_V081 IN VARCHAR2 := NULL, P_V082 IN VARCHAR2 := NULL, P_V083 IN VARCHAR2 := NULL, P_V084 IN VARCHAR2 := NULL, P_V085 IN VARCHAR2 := NULL,
P_V086 IN VARCHAR2 := NULL, P_V087 IN VARCHAR2 := NULL, P_V088 IN VARCHAR2 := NULL, P_V089 IN VARCHAR2 := NULL, P_V090 IN VARCHAR2 := NULL,
P_V091 IN VARCHAR2 := NULL, P_V092 IN VARCHAR2 := NULL, P_V093 IN VARCHAR2 := NULL, P_V094 IN VARCHAR2 := NULL, P_V095 IN VARCHAR2 := NULL,
P_V096 IN VARCHAR2 := NULL, P_V097 IN VARCHAR2 := NULL, P_V098 IN VARCHAR2 := NULL, P_V099 IN VARCHAR2 := NULL, P_V100 IN VARCHAR2 := NULL,
P_V101 IN VARCHAR2 := NULL, P_V102 IN VARCHAR2 := NULL, P_V103 IN VARCHAR2 := NULL, P_V104 IN VARCHAR2 := NULL, P_V105 IN VARCHAR2 := NULL,
P_V106 IN VARCHAR2 := NULL, P_V107 IN VARCHAR2 := NULL, P_V108 IN VARCHAR2 := NULL, P_V109 IN VARCHAR2 := NULL, P_V110 IN VARCHAR2 := NULL,
P_V111 IN VARCHAR2 := NULL, P_V112 IN VARCHAR2 := NULL, P_V113 IN VARCHAR2 := NULL, P_V114 IN VARCHAR2 := NULL, P_V115 IN VARCHAR2 := NULL,
P_V116 IN VARCHAR2 := NULL, P_V117 IN VARCHAR2 := NULL, P_V118 IN VARCHAR2 := NULL, P_V119 IN VARCHAR2 := NULL, P_V120 IN VARCHAR2 := NULL,
P_V121 IN VARCHAR2 := NULL, P_V122 IN VARCHAR2 := NULL, P_V123 IN VARCHAR2 := NULL, P_V124 IN VARCHAR2 := NULL, P_V125 IN VARCHAR2 := NULL,
P_V126 IN VARCHAR2 := NULL, P_V127 IN VARCHAR2 := NULL, P_V128 IN VARCHAR2 := NULL, P_V129 IN VARCHAR2 := NULL, P_V130 IN VARCHAR2 := NULL,
P_V131 IN VARCHAR2 := NULL, P_V132 IN VARCHAR2 := NULL, P_V133 IN VARCHAR2 := NULL, P_V134 IN VARCHAR2 := NULL, P_V135 IN VARCHAR2 := NULL,
P_V136 IN VARCHAR2 := NULL, P_V137 IN VARCHAR2 := NULL, P_V138 IN VARCHAR2 := NULL, P_V139 IN VARCHAR2 := NULL, P_V140 IN VARCHAR2 := NULL,
P_V141 IN VARCHAR2 := NULL, P_V142 IN VARCHAR2 := NULL, P_V143 IN VARCHAR2 := NULL, P_V144 IN VARCHAR2 := NULL, P_V145 IN VARCHAR2 := NULL,
P_V146 IN VARCHAR2 := NULL, P_V147 IN VARCHAR2 := NULL, P_V148 IN VARCHAR2 := NULL, P_V149 IN VARCHAR2 := NULL, P_V150 IN VARCHAR2 := NULL,
P_V151 IN VARCHAR2 := NULL, P_V152 IN VARCHAR2 := NULL, P_V153 IN VARCHAR2 := NULL, P_V154 IN VARCHAR2 := NULL, P_V155 IN VARCHAR2 := NULL,
P_V156 IN VARCHAR2 := NULL, P_V157 IN VARCHAR2 := NULL, P_V158 IN VARCHAR2 := NULL, P_V159 IN VARCHAR2 := NULL, P_V160 IN VARCHAR2 := NULL,
P_V161 IN VARCHAR2 := NULL, P_V162 IN VARCHAR2 := NULL, P_V163 IN VARCHAR2 := NULL, P_V164 IN VARCHAR2 := NULL, P_V165 IN VARCHAR2 := NULL,
P_V166 IN VARCHAR2 := NULL, P_V167 IN VARCHAR2 := NULL, P_V168 IN VARCHAR2 := NULL, P_V169 IN VARCHAR2 := NULL, P_V170 IN VARCHAR2 := NULL,
P_V171 IN VARCHAR2 := NULL, P_V172 IN VARCHAR2 := NULL, P_V173 IN VARCHAR2 := NULL, P_V174 IN VARCHAR2 := NULL, P_V175 IN VARCHAR2 := NULL,
P_V176 IN VARCHAR2 := NULL, P_V177 IN VARCHAR2 := NULL, P_V178 IN VARCHAR2 := NULL, P_V179 IN VARCHAR2 := NULL, P_V180 IN VARCHAR2 := NULL,
P_V181 IN VARCHAR2 := NULL, P_V182 IN VARCHAR2 := NULL, P_V183 IN VARCHAR2 := NULL, P_V184 IN VARCHAR2 := NULL, P_V185 IN VARCHAR2 := NULL,
P_V186 IN VARCHAR2 := NULL, P_V187 IN VARCHAR2 := NULL, P_V188 IN VARCHAR2 := NULL, P_V189 IN VARCHAR2 := NULL, P_V190 IN VARCHAR2 := NULL,
P_V191 IN VARCHAR2 := NULL, P_V192 IN VARCHAR2 := NULL, P_V193 IN VARCHAR2 := NULL, P_V194 IN VARCHAR2 := NULL, P_V195 IN VARCHAR2 := NULL,
P_V196 IN VARCHAR2 := NULL, P_V197 IN VARCHAR2 := NULL, P_V198 IN VARCHAR2 := NULL, P_V199 IN VARCHAR2 := NULL, P_V200 IN VARCHAR2 := NULL,
P_V201 IN VARCHAR2 := NULL, P_V202 IN VARCHAR2 := NULL, P_V203 IN VARCHAR2 := NULL, P_V204 IN VARCHAR2 := NULL, P_V205 IN VARCHAR2 := NULL,
P_V206 IN VARCHAR2 := NULL, P_V207 IN VARCHAR2 := NULL, P_V208 IN VARCHAR2 := NULL, P_V209 IN VARCHAR2 := NULL, P_V210 IN VARCHAR2 := NULL,
P_V211 IN VARCHAR2 := NULL, P_V212 IN VARCHAR2 := NULL, P_V213 IN VARCHAR2 := NULL, P_V214 IN VARCHAR2 := NULL, P_V215 IN VARCHAR2 := NULL,
P_V216 IN VARCHAR2 := NULL, P_V217 IN VARCHAR2 := NULL, P_V218 IN VARCHAR2 := NULL, P_V219 IN VARCHAR2 := NULL, P_V220 IN VARCHAR2 := NULL,
P_V221 IN VARCHAR2 := NULL, P_V222 IN VARCHAR2 := NULL, P_V223 IN VARCHAR2 := NULL, P_V224 IN VARCHAR2 := NULL, P_V225 IN VARCHAR2 := NULL,
P_V226 IN VARCHAR2 := NULL, P_V227 IN VARCHAR2 := NULL, P_V228 IN VARCHAR2 := NULL, P_V229 IN VARCHAR2 := NULL, P_V230 IN VARCHAR2 := NULL,
P_V231 IN VARCHAR2 := NULL, P_V232 IN VARCHAR2 := NULL, P_V233 IN VARCHAR2 := NULL, P_V234 IN VARCHAR2 := NULL, P_V235 IN VARCHAR2 := NULL,
P_V236 IN VARCHAR2 := NULL, P_V237 IN VARCHAR2 := NULL, P_V238 IN VARCHAR2 := NULL, P_V239 IN VARCHAR2 := NULL, P_V240 IN VARCHAR2 := NULL,
P_V241 IN VARCHAR2 := NULL, P_V242 IN VARCHAR2 := NULL, P_V243 IN VARCHAR2 := NULL, P_V244 IN VARCHAR2 := NULL, P_V245 IN VARCHAR2 := NULL,
P_V246 IN VARCHAR2 := NULL, P_V247 IN VARCHAR2 := NULL, P_V248 IN VARCHAR2 := NULL, P_V249 IN VARCHAR2 := NULL, P_V250 IN VARCHAR2 := NULL,
P_V251 IN VARCHAR2 := NULL, P_V252 IN VARCHAR2 := NULL, P_V253 IN VARCHAR2 := NULL, P_V254 IN VARCHAR2 := NULL, P_V255 IN VARCHAR2 := NULL)
RETURN BINARY_INTEGER;
-- 数値型リスト内で P_KEY のインデックス (位置) を戻す
FUNCTION FIELD(
P_KEY IN NUMBER,
P_V001 IN NUMBER, P_V002 IN NUMBER := NULL, P_V003 IN NUMBER := NULL, P_V004 IN NUMBER := NULL, P_V005 IN NUMBER := NULL,
P_V006 IN NUMBER := NULL, P_V007 IN NUMBER := NULL, P_V008 IN NUMBER := NULL, P_V009 IN NUMBER := NULL, P_V010 IN NUMBER := NULL,
P_V011 IN NUMBER := NULL, P_V012 IN NUMBER := NULL, P_V013 IN NUMBER := NULL, P_V014 IN NUMBER := NULL, P_V015 IN NUMBER := NULL,
P_V016 IN NUMBER := NULL, P_V017 IN NUMBER := NULL, P_V018 IN NUMBER := NULL, P_V019 IN NUMBER := NULL, P_V020 IN NUMBER := NULL,
P_V021 IN NUMBER := NULL, P_V022 IN NUMBER := NULL, P_V023 IN NUMBER := NULL, P_V024 IN NUMBER := NULL, P_V025 IN NUMBER := NULL,
P_V026 IN NUMBER := NULL, P_V027 IN NUMBER := NULL, P_V028 IN NUMBER := NULL, P_V029 IN NUMBER := NULL, P_V030 IN NUMBER := NULL,
P_V031 IN NUMBER := NULL, P_V032 IN NUMBER := NULL, P_V033 IN NUMBER := NULL, P_V034 IN NUMBER := NULL, P_V035 IN NUMBER := NULL,
P_V036 IN NUMBER := NULL, P_V037 IN NUMBER := NULL, P_V038 IN NUMBER := NULL, P_V039 IN NUMBER := NULL, P_V040 IN NUMBER := NULL,
P_V041 IN NUMBER := NULL, P_V042 IN NUMBER := NULL, P_V043 IN NUMBER := NULL, P_V044 IN NUMBER := NULL, P_V045 IN NUMBER := NULL,
P_V046 IN NUMBER := NULL, P_V047 IN NUMBER := NULL, P_V048 IN NUMBER := NULL, P_V049 IN NUMBER := NULL, P_V050 IN NUMBER := NULL,
P_V051 IN NUMBER := NULL, P_V052 IN NUMBER := NULL, P_V053 IN NUMBER := NULL, P_V054 IN NUMBER := NULL, P_V055 IN NUMBER := NULL,
P_V056 IN NUMBER := NULL, P_V057 IN NUMBER := NULL, P_V058 IN NUMBER := NULL, P_V059 IN NUMBER := NULL, P_V060 IN NUMBER := NULL,
P_V061 IN NUMBER := NULL, P_V062 IN NUMBER := NULL, P_V063 IN NUMBER := NULL, P_V064 IN NUMBER := NULL, P_V065 IN NUMBER := NULL,
P_V066 IN NUMBER := NULL, P_V067 IN NUMBER := NULL, P_V068 IN NUMBER := NULL, P_V069 IN NUMBER := NULL, P_V070 IN NUMBER := NULL,
P_V071 IN NUMBER := NULL, P_V072 IN NUMBER := NULL, P_V073 IN NUMBER := NULL, P_V074 IN NUMBER := NULL, P_V075 IN NUMBER := NULL,
P_V076 IN NUMBER := NULL, P_V077 IN NUMBER := NULL, P_V078 IN NUMBER := NULL, P_V079 IN NUMBER := NULL, P_V080 IN NUMBER := NULL,
P_V081 IN NUMBER := NULL, P_V082 IN NUMBER := NULL, P_V083 IN NUMBER := NULL, P_V084 IN NUMBER := NULL, P_V085 IN NUMBER := NULL,
P_V086 IN NUMBER := NULL, P_V087 IN NUMBER := NULL, P_V088 IN NUMBER := NULL, P_V089 IN NUMBER := NULL, P_V090 IN NUMBER := NULL,
P_V091 IN NUMBER := NULL, P_V092 IN NUMBER := NULL, P_V093 IN NUMBER := NULL, P_V094 IN NUMBER := NULL, P_V095 IN NUMBER := NULL,
P_V096 IN NUMBER := NULL, P_V097 IN NUMBER := NULL, P_V098 IN NUMBER := NULL, P_V099 IN NUMBER := NULL, P_V100 IN NUMBER := NULL,
P_V101 IN NUMBER := NULL, P_V102 IN NUMBER := NULL, P_V103 IN NUMBER := NULL, P_V104 IN NUMBER := NULL, P_V105 IN NUMBER := NULL,
P_V106 IN NUMBER := NULL, P_V107 IN NUMBER := NULL, P_V108 IN NUMBER := NULL, P_V109 IN NUMBER := NULL, P_V110 IN NUMBER := NULL,
P_V111 IN NUMBER := NULL, P_V112 IN NUMBER := NULL, P_V113 IN NUMBER := NULL, P_V114 IN NUMBER := NULL, P_V115 IN NUMBER := NULL,
P_V116 IN NUMBER := NULL, P_V117 IN NUMBER := NULL, P_V118 IN NUMBER := NULL, P_V119 IN NUMBER := NULL, P_V120 IN NUMBER := NULL,
P_V121 IN NUMBER := NULL, P_V122 IN NUMBER := NULL, P_V123 IN NUMBER := NULL, P_V124 IN NUMBER := NULL, P_V125 IN NUMBER := NULL,
P_V126 IN NUMBER := NULL, P_V127 IN NUMBER := NULL, P_V128 IN NUMBER := NULL, P_V129 IN NUMBER := NULL, P_V130 IN NUMBER := NULL,
P_V131 IN NUMBER := NULL, P_V132 IN NUMBER := NULL, P_V133 IN NUMBER := NULL, P_V134 IN NUMBER := NULL, P_V135 IN NUMBER := NULL,
P_V136 IN NUMBER := NULL, P_V137 IN NUMBER := NULL, P_V138 IN NUMBER := NULL, P_V139 IN NUMBER := NULL, P_V140 IN NUMBER := NULL,
P_V141 IN NUMBER := NULL, P_V142 IN NUMBER := NULL, P_V143 IN NUMBER := NULL, P_V144 IN NUMBER := NULL, P_V145 IN NUMBER := NULL,
P_V146 IN NUMBER := NULL, P_V147 IN NUMBER := NULL, P_V148 IN NUMBER := NULL, P_V149 IN NUMBER := NULL, P_V150 IN NUMBER := NULL,
P_V151 IN NUMBER := NULL, P_V152 IN NUMBER := NULL, P_V153 IN NUMBER := NULL, P_V154 IN NUMBER := NULL, P_V155 IN NUMBER := NULL,
P_V156 IN NUMBER := NULL, P_V157 IN NUMBER := NULL, P_V158 IN NUMBER := NULL, P_V159 IN NUMBER := NULL, P_V160 IN NUMBER := NULL,
P_V161 IN NUMBER := NULL, P_V162 IN NUMBER := NULL, P_V163 IN NUMBER := NULL, P_V164 IN NUMBER := NULL, P_V165 IN NUMBER := NULL,
P_V166 IN NUMBER := NULL, P_V167 IN NUMBER := NULL, P_V168 IN NUMBER := NULL, P_V169 IN NUMBER := NULL, P_V170 IN NUMBER := NULL,
P_V171 IN NUMBER := NULL, P_V172 IN NUMBER := NULL, P_V173 IN NUMBER := NULL, P_V174 IN NUMBER := NULL, P_V175 IN NUMBER := NULL,
P_V176 IN NUMBER := NULL, P_V177 IN NUMBER := NULL, P_V178 IN NUMBER := NULL, P_V179 IN NUMBER := NULL, P_V180 IN NUMBER := NULL,
P_V181 IN NUMBER := NULL, P_V182 IN NUMBER := NULL, P_V183 IN NUMBER := NULL, P_V184 IN NUMBER := NULL, P_V185 IN NUMBER := NULL,
P_V186 IN NUMBER := NULL, P_V187 IN NUMBER := NULL, P_V188 IN NUMBER := NULL, P_V189 IN NUMBER := NULL, P_V190 IN NUMBER := NULL,
P_V191 IN NUMBER := NULL, P_V192 IN NUMBER := NULL, P_V193 IN NUMBER := NULL, P_V194 IN NUMBER := NULL, P_V195 IN NUMBER := NULL,
P_V196 IN NUMBER := NULL, P_V197 IN NUMBER := NULL, P_V198 IN NUMBER := NULL, P_V199 IN NUMBER := NULL, P_V200 IN NUMBER := NULL,
P_V201 IN NUMBER := NULL, P_V202 IN NUMBER := NULL, P_V203 IN NUMBER := NULL, P_V204 IN NUMBER := NULL, P_V205 IN NUMBER := NULL,
P_V206 IN NUMBER := NULL, P_V207 IN NUMBER := NULL, P_V208 IN NUMBER := NULL, P_V209 IN NUMBER := NULL, P_V210 IN NUMBER := NULL,
P_V211 IN NUMBER := NULL, P_V212 IN NUMBER := NULL, P_V213 IN NUMBER := NULL, P_V214 IN NUMBER := NULL, P_V215 IN NUMBER := NULL,
P_V216 IN NUMBER := NULL, P_V217 IN NUMBER := NULL, P_V218 IN NUMBER := NULL, P_V219 IN NUMBER := NULL, P_V220 IN NUMBER := NULL,
P_V221 IN NUMBER := NULL, P_V222 IN NUMBER := NULL, P_V223 IN NUMBER := NULL, P_V224 IN NUMBER := NULL, P_V225 IN NUMBER := NULL,
P_V226 IN NUMBER := NULL, P_V227 IN NUMBER := NULL, P_V228 IN NUMBER := NULL, P_V229 IN NUMBER := NULL, P_V230 IN NUMBER := NULL,
P_V231 IN NUMBER := NULL, P_V232 IN NUMBER := NULL, P_V233 IN NUMBER := NULL, P_V234 IN NUMBER := NULL, P_V235 IN NUMBER := NULL,
P_V236 IN NUMBER := NULL, P_V237 IN NUMBER := NULL, P_V238 IN NUMBER := NULL, P_V239 IN NUMBER := NULL, P_V240 IN NUMBER := NULL,
P_V241 IN NUMBER := NULL, P_V242 IN NUMBER := NULL, P_V243 IN NUMBER := NULL, P_V244 IN NUMBER := NULL, P_V245 IN NUMBER := NULL,
P_V246 IN NUMBER := NULL, P_V247 IN NUMBER := NULL, P_V248 IN NUMBER := NULL, P_V249 IN NUMBER := NULL, P_V250 IN NUMBER := NULL,
P_V251 IN NUMBER := NULL, P_V252 IN NUMBER := NULL, P_V253 IN NUMBER := NULL, P_V254 IN NUMBER := NULL, P_V255 IN NUMBER := NULL)
RETURN BINARY_INTEGER;
-- 倍精度浮動小数点数型リスト内で P_KEY のインデックス (位置) を戻す
FUNCTION FIELD(
P_KEY IN BINARY_DOUBLE,
P_V001 IN BINARY_DOUBLE, P_V002 IN BINARY_DOUBLE := NULL, P_V003 IN BINARY_DOUBLE := NULL, P_V004 IN BINARY_DOUBLE := NULL, P_V005 IN BINARY_DOUBLE := NULL,
P_V006 IN BINARY_DOUBLE := NULL, P_V007 IN BINARY_DOUBLE := NULL, P_V008 IN BINARY_DOUBLE := NULL, P_V009 IN BINARY_DOUBLE := NULL, P_V010 IN BINARY_DOUBLE := NULL,
P_V011 IN BINARY_DOUBLE := NULL, P_V012 IN BINARY_DOUBLE := NULL, P_V013 IN BINARY_DOUBLE := NULL, P_V014 IN BINARY_DOUBLE := NULL, P_V015 IN BINARY_DOUBLE := NULL,
P_V016 IN BINARY_DOUBLE := NULL, P_V017 IN BINARY_DOUBLE := NULL, P_V018 IN BINARY_DOUBLE := NULL, P_V019 IN BINARY_DOUBLE := NULL, P_V020 IN BINARY_DOUBLE := NULL,
P_V021 IN BINARY_DOUBLE := NULL, P_V022 IN BINARY_DOUBLE := NULL, P_V023 IN BINARY_DOUBLE := NULL, P_V024 IN BINARY_DOUBLE := NULL, P_V025 IN BINARY_DOUBLE := NULL,
P_V026 IN BINARY_DOUBLE := NULL, P_V027 IN BINARY_DOUBLE := NULL, P_V028 IN BINARY_DOUBLE := NULL, P_V029 IN BINARY_DOUBLE := NULL, P_V030 IN BINARY_DOUBLE := NULL,
P_V031 IN BINARY_DOUBLE := NULL, P_V032 IN BINARY_DOUBLE := NULL, P_V033 IN BINARY_DOUBLE := NULL, P_V034 IN BINARY_DOUBLE := NULL, P_V035 IN BINARY_DOUBLE := NULL,
P_V036 IN BINARY_DOUBLE := NULL, P_V037 IN BINARY_DOUBLE := NULL, P_V038 IN BINARY_DOUBLE := NULL, P_V039 IN BINARY_DOUBLE := NULL, P_V040 IN BINARY_DOUBLE := NULL,
P_V041 IN BINARY_DOUBLE := NULL, P_V042 IN BINARY_DOUBLE := NULL, P_V043 IN BINARY_DOUBLE := NULL, P_V044 IN BINARY_DOUBLE := NULL, P_V045 IN BINARY_DOUBLE := NULL,
P_V046 IN BINARY_DOUBLE := NULL, P_V047 IN BINARY_DOUBLE := NULL, P_V048 IN BINARY_DOUBLE := NULL, P_V049 IN BINARY_DOUBLE := NULL, P_V050 IN BINARY_DOUBLE := NULL,
P_V051 IN BINARY_DOUBLE := NULL, P_V052 IN BINARY_DOUBLE := NULL, P_V053 IN BINARY_DOUBLE := NULL, P_V054 IN BINARY_DOUBLE := NULL, P_V055 IN BINARY_DOUBLE := NULL,
P_V056 IN BINARY_DOUBLE := NULL, P_V057 IN BINARY_DOUBLE := NULL, P_V058 IN BINARY_DOUBLE := NULL, P_V059 IN BINARY_DOUBLE := NULL, P_V060 IN BINARY_DOUBLE := NULL,
P_V061 IN BINARY_DOUBLE := NULL, P_V062 IN BINARY_DOUBLE := NULL, P_V063 IN BINARY_DOUBLE := NULL, P_V064 IN BINARY_DOUBLE := NULL, P_V065 IN BINARY_DOUBLE := NULL,
P_V066 IN BINARY_DOUBLE := NULL, P_V067 IN BINARY_DOUBLE := NULL, P_V068 IN BINARY_DOUBLE := NULL, P_V069 IN BINARY_DOUBLE := NULL, P_V070 IN BINARY_DOUBLE := NULL,
P_V071 IN BINARY_DOUBLE := NULL, P_V072 IN BINARY_DOUBLE := NULL, P_V073 IN BINARY_DOUBLE := NULL, P_V074 IN BINARY_DOUBLE := NULL, P_V075 IN BINARY_DOUBLE := NULL,
P_V076 IN BINARY_DOUBLE := NULL, P_V077 IN BINARY_DOUBLE := NULL, P_V078 IN BINARY_DOUBLE := NULL, P_V079 IN BINARY_DOUBLE := NULL, P_V080 IN BINARY_DOUBLE := NULL,
P_V081 IN BINARY_DOUBLE := NULL, P_V082 IN BINARY_DOUBLE := NULL, P_V083 IN BINARY_DOUBLE := NULL, P_V084 IN BINARY_DOUBLE := NULL, P_V085 IN BINARY_DOUBLE := NULL,
P_V086 IN BINARY_DOUBLE := NULL, P_V087 IN BINARY_DOUBLE := NULL, P_V088 IN BINARY_DOUBLE := NULL, P_V089 IN BINARY_DOUBLE := NULL, P_V090 IN BINARY_DOUBLE := NULL,
P_V091 IN BINARY_DOUBLE := NULL, P_V092 IN BINARY_DOUBLE := NULL, P_V093 IN BINARY_DOUBLE := NULL, P_V094 IN BINARY_DOUBLE := NULL, P_V095 IN BINARY_DOUBLE := NULL,
P_V096 IN BINARY_DOUBLE := NULL, P_V097 IN BINARY_DOUBLE := NULL, P_V098 IN BINARY_DOUBLE := NULL, P_V099 IN BINARY_DOUBLE := NULL, P_V100 IN BINARY_DOUBLE := NULL,
P_V101 IN BINARY_DOUBLE := NULL, P_V102 IN BINARY_DOUBLE := NULL, P_V103 IN BINARY_DOUBLE := NULL, P_V104 IN BINARY_DOUBLE := NULL, P_V105 IN BINARY_DOUBLE := NULL,
P_V106 IN BINARY_DOUBLE := NULL, P_V107 IN BINARY_DOUBLE := NULL, P_V108 IN BINARY_DOUBLE := NULL, P_V109 IN BINARY_DOUBLE := NULL, P_V110 IN BINARY_DOUBLE := NULL,
P_V111 IN BINARY_DOUBLE := NULL, P_V112 IN BINARY_DOUBLE := NULL, P_V113 IN BINARY_DOUBLE := NULL, P_V114 IN BINARY_DOUBLE := NULL, P_V115 IN BINARY_DOUBLE := NULL,
P_V116 IN BINARY_DOUBLE := NULL, P_V117 IN BINARY_DOUBLE := NULL, P_V118 IN BINARY_DOUBLE := NULL, P_V119 IN BINARY_DOUBLE := NULL, P_V120 IN BINARY_DOUBLE := NULL,
P_V121 IN BINARY_DOUBLE := NULL, P_V122 IN BINARY_DOUBLE := NULL, P_V123 IN BINARY_DOUBLE := NULL, P_V124 IN BINARY_DOUBLE := NULL, P_V125 IN BINARY_DOUBLE := NULL,
P_V126 IN BINARY_DOUBLE := NULL, P_V127 IN BINARY_DOUBLE := NULL, P_V128 IN BINARY_DOUBLE := NULL, P_V129 IN BINARY_DOUBLE := NULL, P_V130 IN BINARY_DOUBLE := NULL,
P_V131 IN BINARY_DOUBLE := NULL, P_V132 IN BINARY_DOUBLE := NULL, P_V133 IN BINARY_DOUBLE := NULL, P_V134 IN BINARY_DOUBLE := NULL, P_V135 IN BINARY_DOUBLE := NULL,
P_V136 IN BINARY_DOUBLE := NULL, P_V137 IN BINARY_DOUBLE := NULL, P_V138 IN BINARY_DOUBLE := NULL, P_V139 IN BINARY_DOUBLE := NULL, P_V140 IN BINARY_DOUBLE := NULL,
P_V141 IN BINARY_DOUBLE := NULL, P_V142 IN BINARY_DOUBLE := NULL, P_V143 IN BINARY_DOUBLE := NULL, P_V144 IN BINARY_DOUBLE := NULL, P_V145 IN BINARY_DOUBLE := NULL,
P_V146 IN BINARY_DOUBLE := NULL, P_V147 IN BINARY_DOUBLE := NULL, P_V148 IN BINARY_DOUBLE := NULL, P_V149 IN BINARY_DOUBLE := NULL, P_V150 IN BINARY_DOUBLE := NULL,
P_V151 IN BINARY_DOUBLE := NULL, P_V152 IN BINARY_DOUBLE := NULL, P_V153 IN BINARY_DOUBLE := NULL, P_V154 IN BINARY_DOUBLE := NULL, P_V155 IN BINARY_DOUBLE := NULL,
P_V156 IN BINARY_DOUBLE := NULL, P_V157 IN BINARY_DOUBLE := NULL, P_V158 IN BINARY_DOUBLE := NULL, P_V159 IN BINARY_DOUBLE := NULL, P_V160 IN BINARY_DOUBLE := NULL,
P_V161 IN BINARY_DOUBLE := NULL, P_V162 IN BINARY_DOUBLE := NULL, P_V163 IN BINARY_DOUBLE := NULL, P_V164 IN BINARY_DOUBLE := NULL, P_V165 IN BINARY_DOUBLE := NULL,
P_V166 IN BINARY_DOUBLE := NULL, P_V167 IN BINARY_DOUBLE := NULL, P_V168 IN BINARY_DOUBLE := NULL, P_V169 IN BINARY_DOUBLE := NULL, P_V170 IN BINARY_DOUBLE := NULL,
P_V171 IN BINARY_DOUBLE := NULL, P_V172 IN BINARY_DOUBLE := NULL, P_V173 IN BINARY_DOUBLE := NULL, P_V174 IN BINARY_DOUBLE := NULL, P_V175 IN BINARY_DOUBLE := NULL,
P_V176 IN BINARY_DOUBLE := NULL, P_V177 IN BINARY_DOUBLE := NULL, P_V178 IN BINARY_DOUBLE := NULL, P_V179 IN BINARY_DOUBLE := NULL, P_V180 IN BINARY_DOUBLE := NULL,
P_V181 IN BINARY_DOUBLE := NULL, P_V182 IN BINARY_DOUBLE := NULL, P_V183 IN BINARY_DOUBLE := NULL, P_V184 IN BINARY_DOUBLE := NULL, P_V185 IN BINARY_DOUBLE := NULL,
P_V186 IN BINARY_DOUBLE := NULL, P_V187 IN BINARY_DOUBLE := NULL, P_V188 IN BINARY_DOUBLE := NULL, P_V189 IN BINARY_DOUBLE := NULL, P_V190 IN BINARY_DOUBLE := NULL,
P_V191 IN BINARY_DOUBLE := NULL, P_V192 IN BINARY_DOUBLE := NULL, P_V193 IN BINARY_DOUBLE := NULL, P_V194 IN BINARY_DOUBLE := NULL, P_V195 IN BINARY_DOUBLE := NULL,
P_V196 IN BINARY_DOUBLE := NULL, P_V197 IN BINARY_DOUBLE := NULL, P_V198 IN BINARY_DOUBLE := NULL, P_V199 IN BINARY_DOUBLE := NULL, P_V200 IN BINARY_DOUBLE := NULL,
P_V201 IN BINARY_DOUBLE := NULL, P_V202 IN BINARY_DOUBLE := NULL, P_V203 IN BINARY_DOUBLE := NULL, P_V204 IN BINARY_DOUBLE := NULL, P_V205 IN BINARY_DOUBLE := NULL,
P_V206 IN BINARY_DOUBLE := NULL, P_V207 IN BINARY_DOUBLE := NULL, P_V208 IN BINARY_DOUBLE := NULL, P_V209 IN BINARY_DOUBLE := NULL, P_V210 IN BINARY_DOUBLE := NULL,
P_V211 IN BINARY_DOUBLE := NULL, P_V212 IN BINARY_DOUBLE := NULL, P_V213 IN BINARY_DOUBLE := NULL, P_V214 IN BINARY_DOUBLE := NULL, P_V215 IN BINARY_DOUBLE := NULL,
P_V216 IN BINARY_DOUBLE := NULL, P_V217 IN BINARY_DOUBLE := NULL, P_V218 IN BINARY_DOUBLE := NULL, P_V219 IN BINARY_DOUBLE := NULL, P_V220 IN BINARY_DOUBLE := NULL,
P_V221 IN BINARY_DOUBLE := NULL, P_V222 IN BINARY_DOUBLE := NULL, P_V223 IN BINARY_DOUBLE := NULL, P_V224 IN BINARY_DOUBLE := NULL, P_V225 IN BINARY_DOUBLE := NULL,
P_V226 IN BINARY_DOUBLE := NULL, P_V227 IN BINARY_DOUBLE := NULL, P_V228 IN BINARY_DOUBLE := NULL, P_V229 IN BINARY_DOUBLE := NULL, P_V230 IN BINARY_DOUBLE := NULL,
P_V231 IN BINARY_DOUBLE := NULL, P_V232 IN BINARY_DOUBLE := NULL, P_V233 IN BINARY_DOUBLE := NULL, P_V234 IN BINARY_DOUBLE := NULL, P_V235 IN BINARY_DOUBLE := NULL,
P_V236 IN BINARY_DOUBLE := NULL, P_V237 IN BINARY_DOUBLE := NULL, P_V238 IN BINARY_DOUBLE := NULL, P_V239 IN BINARY_DOUBLE := NULL, P_V240 IN BINARY_DOUBLE := NULL,
P_V241 IN BINARY_DOUBLE := NULL, P_V242 IN BINARY_DOUBLE := NULL, P_V243 IN BINARY_DOUBLE := NULL, P_V244 IN BINARY_DOUBLE := NULL, P_V245 IN BINARY_DOUBLE := NULL,
P_V246 IN BINARY_DOUBLE := NULL, P_V247 IN BINARY_DOUBLE := NULL, P_V248 IN BINARY_DOUBLE := NULL, P_V249 IN BINARY_DOUBLE := NULL, P_V250 IN BINARY_DOUBLE := NULL,
P_V251 IN BINARY_DOUBLE := NULL, P_V252 IN BINARY_DOUBLE := NULL, P_V253 IN BINARY_DOUBLE := NULL, P_V254 IN BINARY_DOUBLE := NULL, P_V255 IN BINARY_DOUBLE := NULL)
RETURN BINARY_INTEGER;
END;
/
CREATE OR REPLACE PACKAGE BODY MYSQLAPP
IS
FUNCTION ELT(
P_INDEX IN BINARY_INTEGER,
P_V001 IN VARCHAR2, P_V002 IN VARCHAR2 := NULL, P_V003 IN VARCHAR2 := NULL, P_V004 IN VARCHAR2 := NULL, P_V005 IN VARCHAR2 := NULL,
P_V006 IN VARCHAR2 := NULL, P_V007 IN VARCHAR2 := NULL, P_V008 IN VARCHAR2 := NULL, P_V009 IN VARCHAR2 := NULL, P_V010 IN VARCHAR2 := NULL,
P_V011 IN VARCHAR2 := NULL, P_V012 IN VARCHAR2 := NULL, P_V013 IN VARCHAR2 := NULL, P_V014 IN VARCHAR2 := NULL, P_V015 IN VARCHAR2 := NULL,
P_V016 IN VARCHAR2 := NULL, P_V017 IN VARCHAR2 := NULL, P_V018 IN VARCHAR2 := NULL, P_V019 IN VARCHAR2 := NULL, P_V020 IN VARCHAR2 := NULL,
P_V021 IN VARCHAR2 := NULL, P_V022 IN VARCHAR2 := NULL, P_V023 IN VARCHAR2 := NULL, P_V024 IN VARCHAR2 := NULL, P_V025 IN VARCHAR2 := NULL,
P_V026 IN VARCHAR2 := NULL, P_V027 IN VARCHAR2 := NULL, P_V028 IN VARCHAR2 := NULL, P_V029 IN VARCHAR2 := NULL, P_V030 IN VARCHAR2 := NULL,
P_V031 IN VARCHAR2 := NULL, P_V032 IN VARCHAR2 := NULL, P_V033 IN VARCHAR2 := NULL, P_V034 IN VARCHAR2 := NULL, P_V035 IN VARCHAR2 := NULL,
P_V036 IN VARCHAR2 := NULL, P_V037 IN VARCHAR2 := NULL, P_V038 IN VARCHAR2 := NULL, P_V039 IN VARCHAR2 := NULL, P_V040 IN VARCHAR2 := NULL,
P_V041 IN VARCHAR2 := NULL, P_V042 IN VARCHAR2 := NULL, P_V043 IN VARCHAR2 := NULL, P_V044 IN VARCHAR2 := NULL, P_V045 IN VARCHAR2 := NULL,
P_V046 IN VARCHAR2 := NULL, P_V047 IN VARCHAR2 := NULL, P_V048 IN VARCHAR2 := NULL, P_V049 IN VARCHAR2 := NULL, P_V050 IN VARCHAR2 := NULL,
P_V051 IN VARCHAR2 := NULL, P_V052 IN VARCHAR2 := NULL, P_V053 IN VARCHAR2 := NULL, P_V054 IN VARCHAR2 := NULL, P_V055 IN VARCHAR2 := NULL,
P_V056 IN VARCHAR2 := NULL, P_V057 IN VARCHAR2 := NULL, P_V058 IN VARCHAR2 := NULL, P_V059 IN VARCHAR2 := NULL, P_V060 IN VARCHAR2 := NULL,
P_V061 IN VARCHAR2 := NULL, P_V062 IN VARCHAR2 := NULL, P_V063 IN VARCHAR2 := NULL, P_V064 IN VARCHAR2 := NULL, P_V065 IN VARCHAR2 := NULL,
P_V066 IN VARCHAR2 := NULL, P_V067 IN VARCHAR2 := NULL, P_V068 IN VARCHAR2 := NULL, P_V069 IN VARCHAR2 := NULL, P_V070 IN VARCHAR2 := NULL,
P_V071 IN VARCHAR2 := NULL, P_V072 IN VARCHAR2 := NULL, P_V073 IN VARCHAR2 := NULL, P_V074 IN VARCHAR2 := NULL, P_V075 IN VARCHAR2 := NULL,
P_V076 IN VARCHAR2 := NULL, P_V077 IN VARCHAR2 := NULL, P_V078 IN VARCHAR2 := NULL, P_V079 IN VARCHAR2 := NULL, P_V080 IN VARCHAR2 := NULL,
P_V081 IN VARCHAR2 := NULL, P_V082 IN VARCHAR2 := NULL, P_V083 IN VARCHAR2 := NULL, P_V084 IN VARCHAR2 := NULL, P_V085 IN VARCHAR2 := NULL,
P_V086 IN VARCHAR2 := NULL, P_V087 IN VARCHAR2 := NULL, P_V088 IN VARCHAR2 := NULL, P_V089 IN VARCHAR2 := NULL, P_V090 IN VARCHAR2 := NULL,
P_V091 IN VARCHAR2 := NULL, P_V092 IN VARCHAR2 := NULL, P_V093 IN VARCHAR2 := NULL, P_V094 IN VARCHAR2 := NULL, P_V095 IN VARCHAR2 := NULL,
P_V096 IN VARCHAR2 := NULL, P_V097 IN VARCHAR2 := NULL, P_V098 IN VARCHAR2 := NULL, P_V099 IN VARCHAR2 := NULL, P_V100 IN VARCHAR2 := NULL,
P_V101 IN VARCHAR2 := NULL, P_V102 IN VARCHAR2 := NULL, P_V103 IN VARCHAR2 := NULL, P_V104 IN VARCHAR2 := NULL, P_V105 IN VARCHAR2 := NULL,
P_V106 IN VARCHAR2 := NULL, P_V107 IN VARCHAR2 := NULL, P_V108 IN VARCHAR2 := NULL, P_V109 IN VARCHAR2 := NULL, P_V110 IN VARCHAR2 := NULL,
P_V111 IN VARCHAR2 := NULL, P_V112 IN VARCHAR2 := NULL, P_V113 IN VARCHAR2 := NULL, P_V114 IN VARCHAR2 := NULL, P_V115 IN VARCHAR2 := NULL,
P_V116 IN VARCHAR2 := NULL, P_V117 IN VARCHAR2 := NULL, P_V118 IN VARCHAR2 := NULL, P_V119 IN VARCHAR2 := NULL, P_V120 IN VARCHAR2 := NULL,
P_V121 IN VARCHAR2 := NULL, P_V122 IN VARCHAR2 := NULL, P_V123 IN VARCHAR2 := NULL, P_V124 IN VARCHAR2 := NULL, P_V125 IN VARCHAR2 := NULL,
P_V126 IN VARCHAR2 := NULL, P_V127 IN VARCHAR2 := NULL, P_V128 IN VARCHAR2 := NULL, P_V129 IN VARCHAR2 := NULL, P_V130 IN VARCHAR2 := NULL,
P_V131 IN VARCHAR2 := NULL, P_V132 IN VARCHAR2 := NULL, P_V133 IN VARCHAR2 := NULL, P_V134 IN VARCHAR2 := NULL, P_V135 IN VARCHAR2 := NULL,
P_V136 IN VARCHAR2 := NULL, P_V137 IN VARCHAR2 := NULL, P_V138 IN VARCHAR2 := NULL, P_V139 IN VARCHAR2 := NULL, P_V140 IN VARCHAR2 := NULL,
P_V141 IN VARCHAR2 := NULL, P_V142 IN VARCHAR2 := NULL, P_V143 IN VARCHAR2 := NULL, P_V144 IN VARCHAR2 := NULL, P_V145 IN VARCHAR2 := NULL,
P_V146 IN VARCHAR2 := NULL, P_V147 IN VARCHAR2 := NULL, P_V148 IN VARCHAR2 := NULL, P_V149 IN VARCHAR2 := NULL, P_V150 IN VARCHAR2 := NULL,
P_V151 IN VARCHAR2 := NULL, P_V152 IN VARCHAR2 := NULL, P_V153 IN VARCHAR2 := NULL, P_V154 IN VARCHAR2 := NULL, P_V155 IN VARCHAR2 := NULL,
P_V156 IN VARCHAR2 := NULL, P_V157 IN VARCHAR2 := NULL, P_V158 IN VARCHAR2 := NULL, P_V159 IN VARCHAR2 := NULL, P_V160 IN VARCHAR2 := NULL,
P_V161 IN VARCHAR2 := NULL, P_V162 IN VARCHAR2 := NULL, P_V163 IN VARCHAR2 := NULL, P_V164 IN VARCHAR2 := NULL, P_V165 IN VARCHAR2 := NULL,
P_V166 IN VARCHAR2 := NULL, P_V167 IN VARCHAR2 := NULL, P_V168 IN VARCHAR2 := NULL, P_V169 IN VARCHAR2 := NULL, P_V170 IN VARCHAR2 := NULL,
P_V171 IN VARCHAR2 := NULL, P_V172 IN VARCHAR2 := NULL, P_V173 IN VARCHAR2 := NULL, P_V174 IN VARCHAR2 := NULL, P_V175 IN VARCHAR2 := NULL,
P_V176 IN VARCHAR2 := NULL, P_V177 IN VARCHAR2 := NULL, P_V178 IN VARCHAR2 := NULL, P_V179 IN VARCHAR2 := NULL, P_V180 IN VARCHAR2 := NULL,
P_V181 IN VARCHAR2 := NULL, P_V182 IN VARCHAR2 := NULL, P_V183 IN VARCHAR2 := NULL, P_V184 IN VARCHAR2 := NULL, P_V185 IN VARCHAR2 := NULL,
P_V186 IN VARCHAR2 := NULL, P_V187 IN VARCHAR2 := NULL, P_V188 IN VARCHAR2 := NULL, P_V189 IN VARCHAR2 := NULL, P_V190 IN VARCHAR2 := NULL,
P_V191 IN VARCHAR2 := NULL, P_V192 IN VARCHAR2 := NULL, P_V193 IN VARCHAR2 := NULL, P_V194 IN VARCHAR2 := NULL, P_V195 IN VARCHAR2 := NULL,
P_V196 IN VARCHAR2 := NULL, P_V197 IN VARCHAR2 := NULL, P_V198 IN VARCHAR2 := NULL, P_V199 IN VARCHAR2 := NULL, P_V200 IN VARCHAR2 := NULL,
P_V201 IN VARCHAR2 := NULL, P_V202 IN VARCHAR2 := NULL, P_V203 IN VARCHAR2 := NULL, P_V204 IN VARCHAR2 := NULL, P_V205 IN VARCHAR2 := NULL,
P_V206 IN VARCHAR2 := NULL, P_V207 IN VARCHAR2 := NULL, P_V208 IN VARCHAR2 := NULL, P_V209 IN VARCHAR2 := NULL, P_V210 IN VARCHAR2 := NULL,
P_V211 IN VARCHAR2 := NULL, P_V212 IN VARCHAR2 := NULL, P_V213 IN VARCHAR2 := NULL, P_V214 IN VARCHAR2 := NULL, P_V215 IN VARCHAR2 := NULL,
P_V216 IN VARCHAR2 := NULL, P_V217 IN VARCHAR2 := NULL, P_V218 IN VARCHAR2 := NULL, P_V219 IN VARCHAR2 := NULL, P_V220 IN VARCHAR2 := NULL,
P_V221 IN VARCHAR2 := NULL, P_V222 IN VARCHAR2 := NULL, P_V223 IN VARCHAR2 := NULL, P_V224 IN VARCHAR2 := NULL, P_V225 IN VARCHAR2 := NULL,
P_V226 IN VARCHAR2 := NULL, P_V227 IN VARCHAR2 := NULL, P_V228 IN VARCHAR2 := NULL, P_V229 IN VARCHAR2 := NULL, P_V230 IN VARCHAR2 := NULL,
P_V231 IN VARCHAR2 := NULL, P_V232 IN VARCHAR2 := NULL, P_V233 IN VARCHAR2 := NULL, P_V234 IN VARCHAR2 := NULL, P_V235 IN VARCHAR2 := NULL,
P_V236 IN VARCHAR2 := NULL, P_V237 IN VARCHAR2 := NULL, P_V238 IN VARCHAR2 := NULL, P_V239 IN VARCHAR2 := NULL, P_V240 IN VARCHAR2 := NULL,
P_V241 IN VARCHAR2 := NULL, P_V242 IN VARCHAR2 := NULL, P_V243 IN VARCHAR2 := NULL, P_V244 IN VARCHAR2 := NULL, P_V245 IN VARCHAR2 := NULL,
P_V246 IN VARCHAR2 := NULL, P_V247 IN VARCHAR2 := NULL, P_V248 IN VARCHAR2 := NULL, P_V249 IN VARCHAR2 := NULL, P_V250 IN VARCHAR2 := NULL,
P_V251 IN VARCHAR2 := NULL, P_V252 IN VARCHAR2 := NULL, P_V253 IN VARCHAR2 := NULL, P_V254 IN VARCHAR2 := NULL, P_V255 IN VARCHAR2 := NULL)
RETURN VARCHAR2
IS BEGIN
RETURN CASE P_INDEX
WHEN 1 THEN P_V001 WHEN 2 THEN P_V002 WHEN 3 THEN P_V003 WHEN 4 THEN P_V004 WHEN 5 THEN P_V005
WHEN 6 THEN P_V006 WHEN 7 THEN P_V007 WHEN 8 THEN P_V008 WHEN 9 THEN P_V009 WHEN 10 THEN P_V010
WHEN 11 THEN P_V011 WHEN 12 THEN P_V012 WHEN 13 THEN P_V013 WHEN 14 THEN P_V014 WHEN 15 THEN P_V015
WHEN 16 THEN P_V016 WHEN 17 THEN P_V017 WHEN 18 THEN P_V018 WHEN 19 THEN P_V019 WHEN 20 THEN P_V020
WHEN 21 THEN P_V021 WHEN 22 THEN P_V022 WHEN 23 THEN P_V023 WHEN 24 THEN P_V024 WHEN 25 THEN P_V025
WHEN 26 THEN P_V026 WHEN 27 THEN P_V027 WHEN 28 THEN P_V028 WHEN 29 THEN P_V029 WHEN 30 THEN P_V030
WHEN 31 THEN P_V031 WHEN 32 THEN P_V032 WHEN 33 THEN P_V033 WHEN 34 THEN P_V034 WHEN 35 THEN P_V035
WHEN 36 THEN P_V036 WHEN 37 THEN P_V037 WHEN 38 THEN P_V038 WHEN 39 THEN P_V039 WHEN 40 THEN P_V040
WHEN 41 THEN P_V041 WHEN 42 THEN P_V042 WHEN 43 THEN P_V043 WHEN 44 THEN P_V044 WHEN 45 THEN P_V045
WHEN 46 THEN P_V046 WHEN 47 THEN P_V047 WHEN 48 THEN P_V048 WHEN 49 THEN P_V049 WHEN 50 THEN P_V050
WHEN 51 THEN P_V051 WHEN 52 THEN P_V052 WHEN 53 THEN P_V053 WHEN 54 THEN P_V054 WHEN 55 THEN P_V055
WHEN 56 THEN P_V056 WHEN 57 THEN P_V057 WHEN 58 THEN P_V058 WHEN 59 THEN P_V059 WHEN 60 THEN P_V060
WHEN 61 THEN P_V061 WHEN 62 THEN P_V062 WHEN 63 THEN P_V063 WHEN 64 THEN P_V064 WHEN 65 THEN P_V065
WHEN 66 THEN P_V066 WHEN 67 THEN P_V067 WHEN 68 THEN P_V068 WHEN 69 THEN P_V069 WHEN 70 THEN P_V070
WHEN 71 THEN P_V071 WHEN 72 THEN P_V072 WHEN 73 THEN P_V073 WHEN 74 THEN P_V074 WHEN 75 THEN P_V075
WHEN 76 THEN P_V076 WHEN 77 THEN P_V077 WHEN 78 THEN P_V078 WHEN 79 THEN P_V079 WHEN 80 THEN P_V080
WHEN 81 THEN P_V081 WHEN 82 THEN P_V082 WHEN 83 THEN P_V083 WHEN 84 THEN P_V084 WHEN 85 THEN P_V085
WHEN 86 THEN P_V086 WHEN 87 THEN P_V087 WHEN 88 THEN P_V088 WHEN 89 THEN P_V089 WHEN 90 THEN P_V090
WHEN 91 THEN P_V091 WHEN 92 THEN P_V092 WHEN 93 THEN P_V093 WHEN 94 THEN P_V094 WHEN 95 THEN P_V095
WHEN 96 THEN P_V096 WHEN 97 THEN P_V097 WHEN 98 THEN P_V098 WHEN 99 THEN P_V099 WHEN 100 THEN P_V100
WHEN 101 THEN P_V101 WHEN 102 THEN P_V102 WHEN 103 THEN P_V103 WHEN 104 THEN P_V104 WHEN 105 THEN P_V105
WHEN 106 THEN P_V106 WHEN 107 THEN P_V107 WHEN 108 THEN P_V108 WHEN 109 THEN P_V109 WHEN 110 THEN P_V110
WHEN 111 THEN P_V111 WHEN 112 THEN P_V112 WHEN 113 THEN P_V113 WHEN 114 THEN P_V114 WHEN 115 THEN P_V115
WHEN 116 THEN P_V116 WHEN 117 THEN P_V117 WHEN 118 THEN P_V118 WHEN 119 THEN P_V119 WHEN 120 THEN P_V120
WHEN 121 THEN P_V121 WHEN 122 THEN P_V122 WHEN 123 THEN P_V123 WHEN 124 THEN P_V124 WHEN 125 THEN P_V125
WHEN 126 THEN P_V126 WHEN 127 THEN P_V127 WHEN 128 THEN P_V128 WHEN 129 THEN P_V129 WHEN 130 THEN P_V130
WHEN 131 THEN P_V131 WHEN 132 THEN P_V132 WHEN 133 THEN P_V133 WHEN 134 THEN P_V134 WHEN 135 THEN P_V135
WHEN 136 THEN P_V136 WHEN 137 THEN P_V137 WHEN 138 THEN P_V138 WHEN 139 THEN P_V139 WHEN 140 THEN P_V140
WHEN 141 THEN P_V141 WHEN 142 THEN P_V142 WHEN 143 THEN P_V143 WHEN 144 THEN P_V144 WHEN 145 THEN P_V145
WHEN 146 THEN P_V146 WHEN 147 THEN P_V147 WHEN 148 THEN P_V148 WHEN 149 THEN P_V149 WHEN 150 THEN P_V150
WHEN 151 THEN P_V151 WHEN 152 THEN P_V152 WHEN 153 THEN P_V153 WHEN 154 THEN P_V154 WHEN 155 THEN P_V155
WHEN 156 THEN P_V156 WHEN 157 THEN P_V157 WHEN 158 THEN P_V158 WHEN 159 THEN P_V159 WHEN 160 THEN P_V160
WHEN 161 THEN P_V161 WHEN 162 THEN P_V162 WHEN 163 THEN P_V163 WHEN 164 THEN P_V164 WHEN 165 THEN P_V165
WHEN 166 THEN P_V166 WHEN 167 THEN P_V167 WHEN 168 THEN P_V168 WHEN 169 THEN P_V169 WHEN 170 THEN P_V170
WHEN 171 THEN P_V171 WHEN 172 THEN P_V172 WHEN 173 THEN P_V173 WHEN 174 THEN P_V174 WHEN 175 THEN P_V175
WHEN 176 THEN P_V176 WHEN 177 THEN P_V177 WHEN 178 THEN P_V178 WHEN 179 THEN P_V179 WHEN 180 THEN P_V180
WHEN 181 THEN P_V181 WHEN 182 THEN P_V182 WHEN 183 THEN P_V183 WHEN 184 THEN P_V184 WHEN 185 THEN P_V185
WHEN 186 THEN P_V186 WHEN 187 THEN P_V187 WHEN 188 THEN P_V188 WHEN 189 THEN P_V189 WHEN 190 THEN P_V190
WHEN 191 THEN P_V191 WHEN 192 THEN P_V192 WHEN 193 THEN P_V193 WHEN 194 THEN P_V194 WHEN 195 THEN P_V195
WHEN 196 THEN P_V196 WHEN 197 THEN P_V197 WHEN 198 THEN P_V198 WHEN 199 THEN P_V199 WHEN 200 THEN P_V200
WHEN 201 THEN P_V201 WHEN 202 THEN P_V202 WHEN 203 THEN P_V203 WHEN 204 THEN P_V204 WHEN 205 THEN P_V205
WHEN 206 THEN P_V206 WHEN 207 THEN P_V207 WHEN 208 THEN P_V208 WHEN 209 THEN P_V209 WHEN 210 THEN P_V210
WHEN 211 THEN P_V211 WHEN 212 THEN P_V212 WHEN 213 THEN P_V213 WHEN 214 THEN P_V214 WHEN 215 THEN P_V215
WHEN 216 THEN P_V216 WHEN 217 THEN P_V217 WHEN 218 THEN P_V218 WHEN 219 THEN P_V219 WHEN 220 THEN P_V220
WHEN 221 THEN P_V221 WHEN 222 THEN P_V222 WHEN 223 THEN P_V223 WHEN 224 THEN P_V224 WHEN 225 THEN P_V225
WHEN 226 THEN P_V226 WHEN 227 THEN P_V227 WHEN 228 THEN P_V228 WHEN 229 THEN P_V229 WHEN 230 THEN P_V230
WHEN 231 THEN P_V231 WHEN 232 THEN P_V232 WHEN 233 THEN P_V233 WHEN 234 THEN P_V234 WHEN 235 THEN P_V235
WHEN 236 THEN P_V236 WHEN 237 THEN P_V237 WHEN 238 THEN P_V238 WHEN 239 THEN P_V239 WHEN 240 THEN P_V240
WHEN 241 THEN P_V241 WHEN 242 THEN P_V242 WHEN 243 THEN P_V243 WHEN 244 THEN P_V244 WHEN 245 THEN P_V245
WHEN 246 THEN P_V246 WHEN 247 THEN P_V247 WHEN 248 THEN P_V248 WHEN 249 THEN P_V249 WHEN 250 THEN P_V250
WHEN 251 THEN P_V251 WHEN 252 THEN P_V252 WHEN 253 THEN P_V253 WHEN 254 THEN P_V254 WHEN 255 THEN P_V255
ELSE NULL
END;
END;
--
FUNCTION FIELD(
P_KEY IN VARCHAR2,
P_V001 IN VARCHAR, P_V002 IN VARCHAR2 := NULL, P_V003 IN VARCHAR2 := NULL, P_V004 IN VARCHAR2 := NULL, P_V005 IN VARCHAR2 := NULL,
P_V006 IN VARCHAR2 := NULL, P_V007 IN VARCHAR2 := NULL, P_V008 IN VARCHAR2 := NULL, P_V009 IN VARCHAR2 := NULL, P_V010 IN VARCHAR2 := NULL,
P_V011 IN VARCHAR2 := NULL, P_V012 IN VARCHAR2 := NULL, P_V013 IN VARCHAR2 := NULL, P_V014 IN VARCHAR2 := NULL, P_V015 IN VARCHAR2 := NULL,
P_V016 IN VARCHAR2 := NULL, P_V017 IN VARCHAR2 := NULL, P_V018 IN VARCHAR2 := NULL, P_V019 IN VARCHAR2 := NULL, P_V020 IN VARCHAR2 := NULL,
P_V021 IN VARCHAR2 := NULL, P_V022 IN VARCHAR2 := NULL, P_V023 IN VARCHAR2 := NULL, P_V024 IN VARCHAR2 := NULL, P_V025 IN VARCHAR2 := NULL,
P_V026 IN VARCHAR2 := NULL, P_V027 IN VARCHAR2 := NULL, P_V028 IN VARCHAR2 := NULL, P_V029 IN VARCHAR2 := NULL, P_V030 IN VARCHAR2 := NULL,
P_V031 IN VARCHAR2 := NULL, P_V032 IN VARCHAR2 := NULL, P_V033 IN VARCHAR2 := NULL, P_V034 IN VARCHAR2 := NULL, P_V035 IN VARCHAR2 := NULL,
P_V036 IN VARCHAR2 := NULL, P_V037 IN VARCHAR2 := NULL, P_V038 IN VARCHAR2 := NULL, P_V039 IN VARCHAR2 := NULL, P_V040 IN VARCHAR2 := NULL,
P_V041 IN VARCHAR2 := NULL, P_V042 IN VARCHAR2 := NULL, P_V043 IN VARCHAR2 := NULL, P_V044 IN VARCHAR2 := NULL, P_V045 IN VARCHAR2 := NULL,
P_V046 IN VARCHAR2 := NULL, P_V047 IN VARCHAR2 := NULL, P_V048 IN VARCHAR2 := NULL, P_V049 IN VARCHAR2 := NULL, P_V050 IN VARCHAR2 := NULL,
P_V051 IN VARCHAR2 := NULL, P_V052 IN VARCHAR2 := NULL, P_V053 IN VARCHAR2 := NULL, P_V054 IN VARCHAR2 := NULL, P_V055 IN VARCHAR2 := NULL,
P_V056 IN VARCHAR2 := NULL, P_V057 IN VARCHAR2 := NULL, P_V058 IN VARCHAR2 := NULL, P_V059 IN VARCHAR2 := NULL, P_V060 IN VARCHAR2 := NULL,
P_V061 IN VARCHAR2 := NULL, P_V062 IN VARCHAR2 := NULL, P_V063 IN VARCHAR2 := NULL, P_V064 IN VARCHAR2 := NULL, P_V065 IN VARCHAR2 := NULL,
P_V066 IN VARCHAR2 := NULL, P_V067 IN VARCHAR2 := NULL, P_V068 IN VARCHAR2 := NULL, P_V069 IN VARCHAR2 := NULL, P_V070 IN VARCHAR2 := NULL,
P_V071 IN VARCHAR2 := NULL, P_V072 IN VARCHAR2 := NULL, P_V073 IN VARCHAR2 := NULL, P_V074 IN VARCHAR2 := NULL, P_V075 IN VARCHAR2 := NULL,
P_V076 IN VARCHAR2 := NULL, P_V077 IN VARCHAR2 := NULL, P_V078 IN VARCHAR2 := NULL, P_V079 IN VARCHAR2 := NULL, P_V080 IN VARCHAR2 := NULL,
P_V081 IN VARCHAR2 := NULL, P_V082 IN VARCHAR2 := NULL, P_V083 IN VARCHAR2 := NULL, P_V084 IN VARCHAR2 := NULL, P_V085 IN VARCHAR2 := NULL,
P_V086 IN VARCHAR2 := NULL, P_V087 IN VARCHAR2 := NULL, P_V088 IN VARCHAR2 := NULL, P_V089 IN VARCHAR2 := NULL, P_V090 IN VARCHAR2 := NULL,
P_V091 IN VARCHAR2 := NULL, P_V092 IN VARCHAR2 := NULL, P_V093 IN VARCHAR2 := NULL, P_V094 IN VARCHAR2 := NULL, P_V095 IN VARCHAR2 := NULL,
P_V096 IN VARCHAR2 := NULL, P_V097 IN VARCHAR2 := NULL, P_V098 IN VARCHAR2 := NULL, P_V099 IN VARCHAR2 := NULL, P_V100 IN VARCHAR2 := NULL,
P_V101 IN VARCHAR2 := NULL, P_V102 IN VARCHAR2 := NULL, P_V103 IN VARCHAR2 := NULL, P_V104 IN VARCHAR2 := NULL, P_V105 IN VARCHAR2 := NULL,
P_V106 IN VARCHAR2 := NULL, P_V107 IN VARCHAR2 := NULL, P_V108 IN VARCHAR2 := NULL, P_V109 IN VARCHAR2 := NULL, P_V110 IN VARCHAR2 := NULL,
P_V111 IN VARCHAR2 := NULL, P_V112 IN VARCHAR2 := NULL, P_V113 IN VARCHAR2 := NULL, P_V114 IN VARCHAR2 := NULL, P_V115 IN VARCHAR2 := NULL,
P_V116 IN VARCHAR2 := NULL, P_V117 IN VARCHAR2 := NULL, P_V118 IN VARCHAR2 := NULL, P_V119 IN VARCHAR2 := NULL, P_V120 IN VARCHAR2 := NULL,
P_V121 IN VARCHAR2 := NULL, P_V122 IN VARCHAR2 := NULL, P_V123 IN VARCHAR2 := NULL, P_V124 IN VARCHAR2 := NULL, P_V125 IN VARCHAR2 := NULL,
P_V126 IN VARCHAR2 := NULL, P_V127 IN VARCHAR2 := NULL, P_V128 IN VARCHAR2 := NULL, P_V129 IN VARCHAR2 := NULL, P_V130 IN VARCHAR2 := NULL,
P_V131 IN VARCHAR2 := NULL, P_V132 IN VARCHAR2 := NULL, P_V133 IN VARCHAR2 := NULL, P_V134 IN VARCHAR2 := NULL, P_V135 IN VARCHAR2 := NULL,
P_V136 IN VARCHAR2 := NULL, P_V137 IN VARCHAR2 := NULL, P_V138 IN VARCHAR2 := NULL, P_V139 IN VARCHAR2 := NULL, P_V140 IN VARCHAR2 := NULL,
P_V141 IN VARCHAR2 := NULL, P_V142 IN VARCHAR2 := NULL, P_V143 IN VARCHAR2 := NULL, P_V144 IN VARCHAR2 := NULL, P_V145 IN VARCHAR2 := NULL,
P_V146 IN VARCHAR2 := NULL, P_V147 IN VARCHAR2 := NULL, P_V148 IN VARCHAR2 := NULL, P_V149 IN VARCHAR2 := NULL, P_V150 IN VARCHAR2 := NULL,
P_V151 IN VARCHAR2 := NULL, P_V152 IN VARCHAR2 := NULL, P_V153 IN VARCHAR2 := NULL, P_V154 IN VARCHAR2 := NULL, P_V155 IN VARCHAR2 := NULL,
P_V156 IN VARCHAR2 := NULL, P_V157 IN VARCHAR2 := NULL, P_V158 IN VARCHAR2 := NULL, P_V159 IN VARCHAR2 := NULL, P_V160 IN VARCHAR2 := NULL,
P_V161 IN VARCHAR2 := NULL, P_V162 IN VARCHAR2 := NULL, P_V163 IN VARCHAR2 := NULL, P_V164 IN VARCHAR2 := NULL, P_V165 IN VARCHAR2 := NULL,
P_V166 IN VARCHAR2 := NULL, P_V167 IN VARCHAR2 := NULL, P_V168 IN VARCHAR2 := NULL, P_V169 IN VARCHAR2 := NULL, P_V170 IN VARCHAR2 := NULL,
P_V171 IN VARCHAR2 := NULL, P_V172 IN VARCHAR2 := NULL, P_V173 IN VARCHAR2 := NULL, P_V174 IN VARCHAR2 := NULL, P_V175 IN VARCHAR2 := NULL,
P_V176 IN VARCHAR2 := NULL, P_V177 IN VARCHAR2 := NULL, P_V178 IN VARCHAR2 := NULL, P_V179 IN VARCHAR2 := NULL, P_V180 IN VARCHAR2 := NULL,
P_V181 IN VARCHAR2 := NULL, P_V182 IN VARCHAR2 := NULL, P_V183 IN VARCHAR2 := NULL, P_V184 IN VARCHAR2 := NULL, P_V185 IN VARCHAR2 := NULL,
P_V186 IN VARCHAR2 := NULL, P_V187 IN VARCHAR2 := NULL, P_V188 IN VARCHAR2 := NULL, P_V189 IN VARCHAR2 := NULL, P_V190 IN VARCHAR2 := NULL,
P_V191 IN VARCHAR2 := NULL, P_V192 IN VARCHAR2 := NULL, P_V193 IN VARCHAR2 := NULL, P_V194 IN VARCHAR2 := NULL, P_V195 IN VARCHAR2 := NULL,
P_V196 IN VARCHAR2 := NULL, P_V197 IN VARCHAR2 := NULL, P_V198 IN VARCHAR2 := NULL, P_V199 IN VARCHAR2 := NULL, P_V200 IN VARCHAR2 := NULL,
P_V201 IN VARCHAR2 := NULL, P_V202 IN VARCHAR2 := NULL, P_V203 IN VARCHAR2 := NULL, P_V204 IN VARCHAR2 := NULL, P_V205 IN VARCHAR2 := NULL,
P_V206 IN VARCHAR2 := NULL, P_V207 IN VARCHAR2 := NULL, P_V208 IN VARCHAR2 := NULL, P_V209 IN VARCHAR2 := NULL, P_V210 IN VARCHAR2 := NULL,
P_V211 IN VARCHAR2 := NULL, P_V212 IN VARCHAR2 := NULL, P_V213 IN VARCHAR2 := NULL, P_V214 IN VARCHAR2 := NULL, P_V215 IN VARCHAR2 := NULL,
P_V216 IN VARCHAR2 := NULL, P_V217 IN VARCHAR2 := NULL, P_V218 IN VARCHAR2 := NULL, P_V219 IN VARCHAR2 := NULL, P_V220 IN VARCHAR2 := NULL,
P_V221 IN VARCHAR2 := NULL, P_V222 IN VARCHAR2 := NULL, P_V223 IN VARCHAR2 := NULL, P_V224 IN VARCHAR2 := NULL, P_V225 IN VARCHAR2 := NULL,
P_V226 IN VARCHAR2 := NULL, P_V227 IN VARCHAR2 := NULL, P_V228 IN VARCHAR2 := NULL, P_V229 IN VARCHAR2 := NULL, P_V230 IN VARCHAR2 := NULL,
P_V231 IN VARCHAR2 := NULL, P_V232 IN VARCHAR2 := NULL, P_V233 IN VARCHAR2 := NULL, P_V234 IN VARCHAR2 := NULL, P_V235 IN VARCHAR2 := NULL,
P_V236 IN VARCHAR2 := NULL, P_V237 IN VARCHAR2 := NULL, P_V238 IN VARCHAR2 := NULL, P_V239 IN VARCHAR2 := NULL, P_V240 IN VARCHAR2 := NULL,
P_V241 IN VARCHAR2 := NULL, P_V242 IN VARCHAR2 := NULL, P_V243 IN VARCHAR2 := NULL, P_V244 IN VARCHAR2 := NULL, P_V245 IN VARCHAR2 := NULL,
P_V246 IN VARCHAR2 := NULL, P_V247 IN VARCHAR2 := NULL, P_V248 IN VARCHAR2 := NULL, P_V249 IN VARCHAR2 := NULL, P_V250 IN VARCHAR2 := NULL,
P_V251 IN VARCHAR2 := NULL, P_V252 IN VARCHAR2 := NULL, P_V253 IN VARCHAR2 := NULL, P_V254 IN VARCHAR2 := NULL, P_V255 IN VARCHAR2 := NULL)
RETURN BINARY_INTEGER
IS BEGIN
RETURN CASE P_KEY
WHEN P_V001 THEN 1 WHEN P_V002 THEN 2 WHEN P_V003 THEN 3 WHEN P_V004 THEN 4 WHEN P_V005 THEN 5
WHEN P_V006 THEN 6 WHEN P_V007 THEN 7 WHEN P_V008 THEN 8 WHEN P_V009 THEN 9 WHEN P_V010 THEN 10
WHEN P_V011 THEN 11 WHEN P_V012 THEN 12 WHEN P_V013 THEN 13 WHEN P_V014 THEN 14 WHEN P_V015 THEN 15
WHEN P_V016 THEN 16 WHEN P_V017 THEN 17 WHEN P_V018 THEN 18 WHEN P_V019 THEN 19 WHEN P_V020 THEN 20
WHEN P_V021 THEN 21 WHEN P_V022 THEN 22 WHEN P_V023 THEN 23 WHEN P_V024 THEN 24 WHEN P_V025 THEN 25
WHEN P_V026 THEN 26 WHEN P_V027 THEN 27 WHEN P_V028 THEN 28 WHEN P_V029 THEN 29 WHEN P_V030 THEN 30
WHEN P_V031 THEN 31 WHEN P_V032 THEN 32 WHEN P_V033 THEN 33 WHEN P_V034 THEN 34 WHEN P_V035 THEN 35
WHEN P_V036 THEN 36 WHEN P_V037 THEN 37 WHEN P_V038 THEN 38 WHEN P_V039 THEN 39 WHEN P_V040 THEN 40
WHEN P_V041 THEN 41 WHEN P_V042 THEN 42 WHEN P_V043 THEN 43 WHEN P_V044 THEN 44 WHEN P_V045 THEN 45
WHEN P_V046 THEN 46 WHEN P_V047 THEN 47 WHEN P_V048 THEN 48 WHEN P_V049 THEN 49 WHEN P_V050 THEN 50
WHEN P_V051 THEN 51 WHEN P_V052 THEN 52 WHEN P_V053 THEN 53 WHEN P_V054 THEN 54 WHEN P_V055 THEN 55
WHEN P_V056 THEN 56 WHEN P_V057 THEN 57 WHEN P_V058 THEN 58 WHEN P_V059 THEN 59 WHEN P_V060 THEN 60
WHEN P_V061 THEN 61 WHEN P_V062 THEN 62 WHEN P_V063 THEN 63 WHEN P_V064 THEN 64 WHEN P_V065 THEN 65
WHEN P_V066 THEN 66 WHEN P_V067 THEN 67 WHEN P_V068 THEN 68 WHEN P_V069 THEN 69 WHEN P_V070 THEN 70
WHEN P_V071 THEN 71 WHEN P_V072 THEN 72 WHEN P_V073 THEN 73 WHEN P_V074 THEN 74 WHEN P_V075 THEN 75
WHEN P_V076 THEN 76 WHEN P_V077 THEN 77 WHEN P_V078 THEN 78 WHEN P_V079 THEN 79 WHEN P_V080 THEN 80
WHEN P_V081 THEN 81 WHEN P_V082 THEN 82 WHEN P_V083 THEN 83 WHEN P_V084 THEN 84 WHEN P_V085 THEN 85
WHEN P_V086 THEN 86 WHEN P_V087 THEN 87 WHEN P_V088 THEN 88 WHEN P_V089 THEN 89 WHEN P_V090 THEN 90
WHEN P_V091 THEN 91 WHEN P_V092 THEN 92 WHEN P_V093 THEN 93 WHEN P_V094 THEN 94 WHEN P_V095 THEN 95
WHEN P_V096 THEN 96 WHEN P_V097 THEN 97 WHEN P_V098 THEN 98 WHEN P_V099 THEN 99 WHEN P_V100 THEN 100
WHEN P_V101 THEN 101 WHEN P_V102 THEN 102 WHEN P_V103 THEN 103 WHEN P_V104 THEN 104 WHEN P_V105 THEN 105
WHEN P_V106 THEN 106 WHEN P_V107 THEN 107 WHEN P_V108 THEN 108 WHEN P_V109 THEN 109 WHEN P_V110 THEN 110
WHEN P_V111 THEN 111 WHEN P_V112 THEN 112 WHEN P_V113 THEN 113 WHEN P_V114 THEN 114 WHEN P_V115 THEN 115
WHEN P_V116 THEN 116 WHEN P_V117 THEN 117 WHEN P_V118 THEN 118 WHEN P_V119 THEN 119 WHEN P_V120 THEN 120
WHEN P_V121 THEN 121 WHEN P_V122 THEN 122 WHEN P_V123 THEN 123 WHEN P_V124 THEN 124 WHEN P_V125 THEN 125
WHEN P_V126 THEN 126 WHEN P_V127 THEN 127 WHEN P_V128 THEN 128 WHEN P_V129 THEN 129 WHEN P_V130 THEN 130
WHEN P_V131 THEN 131 WHEN P_V132 THEN 132 WHEN P_V133 THEN 133 WHEN P_V134 THEN 134 WHEN P_V135 THEN 135
WHEN P_V136 THEN 136 WHEN P_V137 THEN 137 WHEN P_V138 THEN 138 WHEN P_V139 THEN 139 WHEN P_V140 THEN 140
WHEN P_V141 THEN 141 WHEN P_V142 THEN 142 WHEN P_V143 THEN 143 WHEN P_V144 THEN 144 WHEN P_V145 THEN 145
WHEN P_V146 THEN 146 WHEN P_V147 THEN 147 WHEN P_V148 THEN 148 WHEN P_V149 THEN 149 WHEN P_V150 THEN 150
WHEN P_V151 THEN 151 WHEN P_V152 THEN 152 WHEN P_V153 THEN 153 WHEN P_V154 THEN 154 WHEN P_V155 THEN 155
WHEN P_V156 THEN 156 WHEN P_V157 THEN 157 WHEN P_V158 THEN 158 WHEN P_V159 THEN 159 WHEN P_V160 THEN 160
WHEN P_V161 THEN 161 WHEN P_V162 THEN 162 WHEN P_V163 THEN 163 WHEN P_V164 THEN 164 WHEN P_V165 THEN 165
WHEN P_V166 THEN 166 WHEN P_V167 THEN 167 WHEN P_V168 THEN 168 WHEN P_V169 THEN 169 WHEN P_V170 THEN 170
WHEN P_V171 THEN 171 WHEN P_V172 THEN 172 WHEN P_V173 THEN 173 WHEN P_V174 THEN 174 WHEN P_V175 THEN 175
WHEN P_V176 THEN 176 WHEN P_V177 THEN 177 WHEN P_V178 THEN 178 WHEN P_V179 THEN 179 WHEN P_V180 THEN 180
WHEN P_V181 THEN 181 WHEN P_V182 THEN 182 WHEN P_V183 THEN 183 WHEN P_V184 THEN 184 WHEN P_V185 THEN 185
WHEN P_V186 THEN 186 WHEN P_V187 THEN 187 WHEN P_V188 THEN 188 WHEN P_V189 THEN 189 WHEN P_V190 THEN 190
WHEN P_V191 THEN 191 WHEN P_V192 THEN 192 WHEN P_V193 THEN 193 WHEN P_V194 THEN 194 WHEN P_V195 THEN 195
WHEN P_V196 THEN 196 WHEN P_V197 THEN 197 WHEN P_V198 THEN 198 WHEN P_V199 THEN 199 WHEN P_V200 THEN 200
WHEN P_V201 THEN 201 WHEN P_V202 THEN 202 WHEN P_V203 THEN 203 WHEN P_V204 THEN 204 WHEN P_V205 THEN 205
WHEN P_V206 THEN 206 WHEN P_V207 THEN 207 WHEN P_V208 THEN 208 WHEN P_V209 THEN 209 WHEN P_V210 THEN 210
WHEN P_V211 THEN 211 WHEN P_V212 THEN 212 WHEN P_V213 THEN 213 WHEN P_V214 THEN 214 WHEN P_V215 THEN 215
WHEN P_V216 THEN 216 WHEN P_V217 THEN 217 WHEN P_V218 THEN 218 WHEN P_V219 THEN 219 WHEN P_V220 THEN 220
WHEN P_V221 THEN 221 WHEN P_V222 THEN 222 WHEN P_V223 THEN 223 WHEN P_V224 THEN 224 WHEN P_V225 THEN 225
WHEN P_V226 THEN 226 WHEN P_V227 THEN 227 WHEN P_V228 THEN 228 WHEN P_V229 THEN 229 WHEN P_V230 THEN 230
WHEN P_V231 THEN 231 WHEN P_V232 THEN 232 WHEN P_V233 THEN 233 WHEN P_V234 THEN 234 WHEN P_V235 THEN 235
WHEN P_V236 THEN 236 WHEN P_V237 THEN 237 WHEN P_V238 THEN 238 WHEN P_V239 THEN 239 WHEN P_V240 THEN 240
WHEN P_V241 THEN 241 WHEN P_V242 THEN 242 WHEN P_V243 THEN 243 WHEN P_V244 THEN 244 WHEN P_V245 THEN 245
WHEN P_V246 THEN 246 WHEN P_V247 THEN 247 WHEN P_V248 THEN 248 WHEN P_V249 THEN 249 WHEN P_V250 THEN 250
WHEN P_V251 THEN 251 WHEN P_V252 THEN 252 WHEN P_V253 THEN 253 WHEN P_V254 THEN 254 WHEN P_V255 THEN 255
ELSE 0
END;
END;
--
FUNCTION FIELD(
P_KEY IN NUMBER,
P_V001 IN NUMBER, P_V002 IN NUMBER := NULL, P_V003 IN NUMBER := NULL, P_V004 IN NUMBER := NULL, P_V005 IN NUMBER := NULL,
P_V006 IN NUMBER := NULL, P_V007 IN NUMBER := NULL, P_V008 IN NUMBER := NULL, P_V009 IN NUMBER := NULL, P_V010 IN NUMBER := NULL,
P_V011 IN NUMBER := NULL, P_V012 IN NUMBER := NULL, P_V013 IN NUMBER := NULL, P_V014 IN NUMBER := NULL, P_V015 IN NUMBER := NULL,
P_V016 IN NUMBER := NULL, P_V017 IN NUMBER := NULL, P_V018 IN NUMBER := NULL, P_V019 IN NUMBER := NULL, P_V020 IN NUMBER := NULL,
P_V021 IN NUMBER := NULL, P_V022 IN NUMBER := NULL, P_V023 IN NUMBER := NULL, P_V024 IN NUMBER := NULL, P_V025 IN NUMBER := NULL,
P_V026 IN NUMBER := NULL, P_V027 IN NUMBER := NULL, P_V028 IN NUMBER := NULL, P_V029 IN NUMBER := NULL, P_V030 IN NUMBER := NULL,
P_V031 IN NUMBER := NULL, P_V032 IN NUMBER := NULL, P_V033 IN NUMBER := NULL, P_V034 IN NUMBER := NULL, P_V035 IN NUMBER := NULL,
P_V036 IN NUMBER := NULL, P_V037 IN NUMBER := NULL, P_V038 IN NUMBER := NULL, P_V039 IN NUMBER := NULL, P_V040 IN NUMBER := NULL,
P_V041 IN NUMBER := NULL, P_V042 IN NUMBER := NULL, P_V043 IN NUMBER := NULL, P_V044 IN NUMBER := NULL, P_V045 IN NUMBER := NULL,
P_V046 IN NUMBER := NULL, P_V047 IN NUMBER := NULL, P_V048 IN NUMBER := NULL, P_V049 IN NUMBER := NULL, P_V050 IN NUMBER := NULL,
P_V051 IN NUMBER := NULL, P_V052 IN NUMBER := NULL, P_V053 IN NUMBER := NULL, P_V054 IN NUMBER := NULL, P_V055 IN NUMBER := NULL,
P_V056 IN NUMBER := NULL, P_V057 IN NUMBER := NULL, P_V058 IN NUMBER := NULL, P_V059 IN NUMBER := NULL, P_V060 IN NUMBER := NULL,
P_V061 IN NUMBER := NULL, P_V062 IN NUMBER := NULL, P_V063 IN NUMBER := NULL, P_V064 IN NUMBER := NULL, P_V065 IN NUMBER := NULL,
P_V066 IN NUMBER := NULL, P_V067 IN NUMBER := NULL, P_V068 IN NUMBER := NULL, P_V069 IN NUMBER := NULL, P_V070 IN NUMBER := NULL,
P_V071 IN NUMBER := NULL, P_V072 IN NUMBER := NULL, P_V073 IN NUMBER := NULL, P_V074 IN NUMBER := NULL, P_V075 IN NUMBER := NULL,
P_V076 IN NUMBER := NULL, P_V077 IN NUMBER := NULL, P_V078 IN NUMBER := NULL, P_V079 IN NUMBER := NULL, P_V080 IN NUMBER := NULL,
P_V081 IN NUMBER := NULL, P_V082 IN NUMBER := NULL, P_V083 IN NUMBER := NULL, P_V084 IN NUMBER := NULL, P_V085 IN NUMBER := NULL,
P_V086 IN NUMBER := NULL, P_V087 IN NUMBER := NULL, P_V088 IN NUMBER := NULL, P_V089 IN NUMBER := NULL, P_V090 IN NUMBER := NULL,
P_V091 IN NUMBER := NULL, P_V092 IN NUMBER := NULL, P_V093 IN NUMBER := NULL, P_V094 IN NUMBER := NULL, P_V095 IN NUMBER := NULL,
P_V096 IN NUMBER := NULL, P_V097 IN NUMBER := NULL, P_V098 IN NUMBER := NULL, P_V099 IN NUMBER := NULL, P_V100 IN NUMBER := NULL,
P_V101 IN NUMBER := NULL, P_V102 IN NUMBER := NULL, P_V103 IN NUMBER := NULL, P_V104 IN NUMBER := NULL, P_V105 IN NUMBER := NULL,
P_V106 IN NUMBER := NULL, P_V107 IN NUMBER := NULL, P_V108 IN NUMBER := NULL, P_V109 IN NUMBER := NULL, P_V110 IN NUMBER := NULL,
P_V111 IN NUMBER := NULL, P_V112 IN NUMBER := NULL, P_V113 IN NUMBER := NULL, P_V114 IN NUMBER := NULL, P_V115 IN NUMBER := NULL,
P_V116 IN NUMBER := NULL, P_V117 IN NUMBER := NULL, P_V118 IN NUMBER := NULL, P_V119 IN NUMBER := NULL, P_V120 IN NUMBER := NULL,
P_V121 IN NUMBER := NULL, P_V122 IN NUMBER := NULL, P_V123 IN NUMBER := NULL, P_V124 IN NUMBER := NULL, P_V125 IN NUMBER := NULL,
P_V126 IN NUMBER := NULL, P_V127 IN NUMBER := NULL, P_V128 IN NUMBER := NULL, P_V129 IN NUMBER := NULL, P_V130 IN NUMBER := NULL,
P_V131 IN NUMBER := NULL, P_V132 IN NUMBER := NULL, P_V133 IN NUMBER := NULL, P_V134 IN NUMBER := NULL, P_V135 IN NUMBER := NULL,
P_V136 IN NUMBER := NULL, P_V137 IN NUMBER := NULL, P_V138 IN NUMBER := NULL, P_V139 IN NUMBER := NULL, P_V140 IN NUMBER := NULL,
P_V141 IN NUMBER := NULL, P_V142 IN NUMBER := NULL, P_V143 IN NUMBER := NULL, P_V144 IN NUMBER := NULL, P_V145 IN NUMBER := NULL,
P_V146 IN NUMBER := NULL, P_V147 IN NUMBER := NULL, P_V148 IN NUMBER := NULL, P_V149 IN NUMBER := NULL, P_V150 IN NUMBER := NULL,
P_V151 IN NUMBER := NULL, P_V152 IN NUMBER := NULL, P_V153 IN NUMBER := NULL, P_V154 IN NUMBER := NULL, P_V155 IN NUMBER := NULL,
P_V156 IN NUMBER := NULL, P_V157 IN NUMBER := NULL, P_V158 IN NUMBER := NULL, P_V159 IN NUMBER := NULL, P_V160 IN NUMBER := NULL,
P_V161 IN NUMBER := NULL, P_V162 IN NUMBER := NULL, P_V163 IN NUMBER := NULL, P_V164 IN NUMBER := NULL, P_V165 IN NUMBER := NULL,
P_V166 IN NUMBER := NULL, P_V167 IN NUMBER := NULL, P_V168 IN NUMBER := NULL, P_V169 IN NUMBER := NULL, P_V170 IN NUMBER := NULL,
P_V171 IN NUMBER := NULL, P_V172 IN NUMBER := NULL, P_V173 IN NUMBER := NULL, P_V174 IN NUMBER := NULL, P_V175 IN NUMBER := NULL,
P_V176 IN NUMBER := NULL, P_V177 IN NUMBER := NULL, P_V178 IN NUMBER := NULL, P_V179 IN NUMBER := NULL, P_V180 IN NUMBER := NULL,
P_V181 IN NUMBER := NULL, P_V182 IN NUMBER := NULL, P_V183 IN NUMBER := NULL, P_V184 IN NUMBER := NULL, P_V185 IN NUMBER := NULL,
P_V186 IN NUMBER := NULL, P_V187 IN NUMBER := NULL, P_V188 IN NUMBER := NULL, P_V189 IN NUMBER := NULL, P_V190 IN NUMBER := NULL,
P_V191 IN NUMBER := NULL, P_V192 IN NUMBER := NULL, P_V193 IN NUMBER := NULL, P_V194 IN NUMBER := NULL, P_V195 IN NUMBER := NULL,
P_V196 IN NUMBER := NULL, P_V197 IN NUMBER := NULL, P_V198 IN NUMBER := NULL, P_V199 IN NUMBER := NULL, P_V200 IN NUMBER := NULL,
P_V201 IN NUMBER := NULL, P_V202 IN NUMBER := NULL, P_V203 IN NUMBER := NULL, P_V204 IN NUMBER := NULL, P_V205 IN NUMBER := NULL,
P_V206 IN NUMBER := NULL, P_V207 IN NUMBER := NULL, P_V208 IN NUMBER := NULL, P_V209 IN NUMBER := NULL, P_V210 IN NUMBER := NULL,
P_V211 IN NUMBER := NULL, P_V212 IN NUMBER := NULL, P_V213 IN NUMBER := NULL, P_V214 IN NUMBER := NULL, P_V215 IN NUMBER := NULL,
P_V216 IN NUMBER := NULL, P_V217 IN NUMBER := NULL, P_V218 IN NUMBER := NULL, P_V219 IN NUMBER := NULL, P_V220 IN NUMBER := NULL,
P_V221 IN NUMBER := NULL, P_V222 IN NUMBER := NULL, P_V223 IN NUMBER := NULL, P_V224 IN NUMBER := NULL, P_V225 IN NUMBER := NULL,
P_V226 IN NUMBER := NULL, P_V227 IN NUMBER := NULL, P_V228 IN NUMBER := NULL, P_V229 IN NUMBER := NULL, P_V230 IN NUMBER := NULL,
P_V231 IN NUMBER := NULL, P_V232 IN NUMBER := NULL, P_V233 IN NUMBER := NULL, P_V234 IN NUMBER := NULL, P_V235 IN NUMBER := NULL,
P_V236 IN NUMBER := NULL, P_V237 IN NUMBER := NULL, P_V238 IN NUMBER := NULL, P_V239 IN NUMBER := NULL, P_V240 IN NUMBER := NULL,
P_V241 IN NUMBER := NULL, P_V242 IN NUMBER := NULL, P_V243 IN NUMBER := NULL, P_V244 IN NUMBER := NULL, P_V245 IN NUMBER := NULL,
P_V246 IN NUMBER := NULL, P_V247 IN NUMBER := NULL, P_V248 IN NUMBER := NULL, P_V249 IN NUMBER := NULL, P_V250 IN NUMBER := NULL,
P_V251 IN NUMBER := NULL, P_V252 IN NUMBER := NULL, P_V253 IN NUMBER := NULL, P_V254 IN NUMBER := NULL, P_V255 IN NUMBER := NULL)
RETURN BINARY_INTEGER
IS BEGIN
RETURN CASE P_KEY
WHEN P_V001 THEN 1 WHEN P_V002 THEN 2 WHEN P_V003 THEN 3 WHEN P_V004 THEN 4 WHEN P_V005 THEN 5
WHEN P_V006 THEN 6 WHEN P_V007 THEN 7 WHEN P_V008 THEN 8 WHEN P_V009 THEN 9 WHEN P_V010 THEN 10
WHEN P_V011 THEN 11 WHEN P_V012 THEN 12 WHEN P_V013 THEN 13 WHEN P_V014 THEN 14 WHEN P_V015 THEN 15
WHEN P_V016 THEN 16 WHEN P_V017 THEN 17 WHEN P_V018 THEN 18 WHEN P_V019 THEN 19 WHEN P_V020 THEN 20
WHEN P_V021 THEN 21 WHEN P_V022 THEN 22 WHEN P_V023 THEN 23 WHEN P_V024 THEN 24 WHEN P_V025 THEN 25
WHEN P_V026 THEN 26 WHEN P_V027 THEN 27 WHEN P_V028 THEN 28 WHEN P_V029 THEN 29 WHEN P_V030 THEN 30
WHEN P_V031 THEN 31 WHEN P_V032 THEN 32 WHEN P_V033 THEN 33 WHEN P_V034 THEN 34 WHEN P_V035 THEN 35
WHEN P_V036 THEN 36 WHEN P_V037 THEN 37 WHEN P_V038 THEN 38 WHEN P_V039 THEN 39 WHEN P_V040 THEN 40
WHEN P_V041 THEN 41 WHEN P_V042 THEN 42 WHEN P_V043 THEN 43 WHEN P_V044 THEN 44 WHEN P_V045 THEN 45
WHEN P_V046 THEN 46 WHEN P_V047 THEN 47 WHEN P_V048 THEN 48 WHEN P_V049 THEN 49 WHEN P_V050 THEN 50
WHEN P_V051 THEN 51 WHEN P_V052 THEN 52 WHEN P_V053 THEN 53 WHEN P_V054 THEN 54 WHEN P_V055 THEN 55
WHEN P_V056 THEN 56 WHEN P_V057 THEN 57 WHEN P_V058 THEN 58 WHEN P_V059 THEN 59 WHEN P_V060 THEN 60
WHEN P_V061 THEN 61 WHEN P_V062 THEN 62 WHEN P_V063 THEN 63 WHEN P_V064 THEN 64 WHEN P_V065 THEN 65
WHEN P_V066 THEN 66 WHEN P_V067 THEN 67 WHEN P_V068 THEN 68 WHEN P_V069 THEN 69 WHEN P_V070 THEN 70
WHEN P_V071 THEN 71 WHEN P_V072 THEN 72 WHEN P_V073 THEN 73 WHEN P_V074 THEN 74 WHEN P_V075 THEN 75
WHEN P_V076 THEN 76 WHEN P_V077 THEN 77 WHEN P_V078 THEN 78 WHEN P_V079 THEN 79 WHEN P_V080 THEN 80
WHEN P_V081 THEN 81 WHEN P_V082 THEN 82 WHEN P_V083 THEN 83 WHEN P_V084 THEN 84 WHEN P_V085 THEN 85
WHEN P_V086 THEN 86 WHEN P_V087 THEN 87 WHEN P_V088 THEN 88 WHEN P_V089 THEN 89 WHEN P_V090 THEN 90
WHEN P_V091 THEN 91 WHEN P_V092 THEN 92 WHEN P_V093 THEN 93 WHEN P_V094 THEN 94 WHEN P_V095 THEN 95
WHEN P_V096 THEN 96 WHEN P_V097 THEN 97 WHEN P_V098 THEN 98 WHEN P_V099 THEN 99 WHEN P_V100 THEN 100
WHEN P_V101 THEN 101 WHEN P_V102 THEN 102 WHEN P_V103 THEN 103 WHEN P_V104 THEN 104 WHEN P_V105 THEN 105
WHEN P_V106 THEN 106 WHEN P_V107 THEN 107 WHEN P_V108 THEN 108 WHEN P_V109 THEN 109 WHEN P_V110 THEN 110
WHEN P_V111 THEN 111 WHEN P_V112 THEN 112 WHEN P_V113 THEN 113 WHEN P_V114 THEN 114 WHEN P_V115 THEN 115
WHEN P_V116 THEN 116 WHEN P_V117 THEN 117 WHEN P_V118 THEN 118 WHEN P_V119 THEN 119 WHEN P_V120 THEN 120
WHEN P_V121 THEN 121 WHEN P_V122 THEN 122 WHEN P_V123 THEN 123 WHEN P_V124 THEN 124 WHEN P_V125 THEN 125
WHEN P_V126 THEN 126 WHEN P_V127 THEN 127 WHEN P_V128 THEN 128 WHEN P_V129 THEN 129 WHEN P_V130 THEN 130
WHEN P_V131 THEN 131 WHEN P_V132 THEN 132 WHEN P_V133 THEN 133 WHEN P_V134 THEN 134 WHEN P_V135 THEN 135
WHEN P_V136 THEN 136 WHEN P_V137 THEN 137 WHEN P_V138 THEN 138 WHEN P_V139 THEN 139 WHEN P_V140 THEN 140
WHEN P_V141 THEN 141 WHEN P_V142 THEN 142 WHEN P_V143 THEN 143 WHEN P_V144 THEN 144 WHEN P_V145 THEN 145
WHEN P_V146 THEN 146 WHEN P_V147 THEN 147 WHEN P_V148 THEN 148 WHEN P_V149 THEN 149 WHEN P_V150 THEN 150
WHEN P_V151 THEN 151 WHEN P_V152 THEN 152 WHEN P_V153 THEN 153 WHEN P_V154 THEN 154 WHEN P_V155 THEN 155
WHEN P_V156 THEN 156 WHEN P_V157 THEN 157 WHEN P_V158 THEN 158 WHEN P_V159 THEN 159 WHEN P_V160 THEN 160
WHEN P_V161 THEN 161 WHEN P_V162 THEN 162 WHEN P_V163 THEN 163 WHEN P_V164 THEN 164 WHEN P_V165 THEN 165
WHEN P_V166 THEN 166 WHEN P_V167 THEN 167 WHEN P_V168 THEN 168 WHEN P_V169 THEN 169 WHEN P_V170 THEN 170
WHEN P_V171 THEN 171 WHEN P_V172 THEN 172 WHEN P_V173 THEN 173 WHEN P_V174 THEN 174 WHEN P_V175 THEN 175
WHEN P_V176 THEN 176 WHEN P_V177 THEN 177 WHEN P_V178 THEN 178 WHEN P_V179 THEN 179 WHEN P_V180 THEN 180
WHEN P_V181 THEN 181 WHEN P_V182 THEN 182 WHEN P_V183 THEN 183 WHEN P_V184 THEN 184 WHEN P_V185 THEN 185
WHEN P_V186 THEN 186 WHEN P_V187 THEN 187 WHEN P_V188 THEN 188 WHEN P_V189 THEN 189 WHEN P_V190 THEN 190
WHEN P_V191 THEN 191 WHEN P_V192 THEN 192 WHEN P_V193 THEN 193 WHEN P_V194 THEN 194 WHEN P_V195 THEN 195
WHEN P_V196 THEN 196 WHEN P_V197 THEN 197 WHEN P_V198 THEN 198 WHEN P_V199 THEN 199 WHEN P_V200 THEN 200
WHEN P_V201 THEN 201 WHEN P_V202 THEN 202 WHEN P_V203 THEN 203 WHEN P_V204 THEN 204 WHEN P_V205 THEN 205
WHEN P_V206 THEN 206 WHEN P_V207 THEN 207 WHEN P_V208 THEN 208 WHEN P_V209 THEN 209 WHEN P_V210 THEN 210
WHEN P_V211 THEN 211 WHEN P_V212 THEN 212 WHEN P_V213 THEN 213 WHEN P_V214 THEN 214 WHEN P_V215 THEN 215
WHEN P_V216 THEN 216 WHEN P_V217 THEN 217 WHEN P_V218 THEN 218 WHEN P_V219 THEN 219 WHEN P_V220 THEN 220
WHEN P_V221 THEN 221 WHEN P_V222 THEN 222 WHEN P_V223 THEN 223 WHEN P_V224 THEN 224 WHEN P_V225 THEN 225
WHEN P_V226 THEN 226 WHEN P_V227 THEN 227 WHEN P_V228 THEN 228 WHEN P_V229 THEN 229 WHEN P_V230 THEN 230
WHEN P_V231 THEN 231 WHEN P_V232 THEN 232 WHEN P_V233 THEN 233 WHEN P_V234 THEN 234 WHEN P_V235 THEN 235
WHEN P_V236 THEN 236 WHEN P_V237 THEN 237 WHEN P_V238 THEN 238 WHEN P_V239 THEN 239 WHEN P_V240 THEN 240
WHEN P_V241 THEN 241 WHEN P_V242 THEN 242 WHEN P_V243 THEN 243 WHEN P_V244 THEN 244 WHEN P_V245 THEN 245
WHEN P_V246 THEN 246 WHEN P_V247 THEN 247 WHEN P_V248 THEN 248 WHEN P_V249 THEN 249 WHEN P_V250 THEN 250
WHEN P_V251 THEN 251 WHEN P_V252 THEN 252 WHEN P_V253 THEN 253 WHEN P_V254 THEN 254 WHEN P_V255 THEN 255
ELSE 0
END;
END;
--
FUNCTION FIELD(
P_KEY IN BINARY_DOUBLE,
P_V001 IN BINARY_DOUBLE, P_V002 IN BINARY_DOUBLE := NULL, P_V003 IN BINARY_DOUBLE := NULL, P_V004 IN BINARY_DOUBLE := NULL, P_V005 IN BINARY_DOUBLE := NULL,
P_V006 IN BINARY_DOUBLE := NULL, P_V007 IN BINARY_DOUBLE := NULL, P_V008 IN BINARY_DOUBLE := NULL, P_V009 IN BINARY_DOUBLE := NULL, P_V010 IN BINARY_DOUBLE := NULL,
P_V011 IN BINARY_DOUBLE := NULL, P_V012 IN BINARY_DOUBLE := NULL, P_V013 IN BINARY_DOUBLE := NULL, P_V014 IN BINARY_DOUBLE := NULL, P_V015 IN BINARY_DOUBLE := NULL,
P_V016 IN BINARY_DOUBLE := NULL, P_V017 IN BINARY_DOUBLE := NULL, P_V018 IN BINARY_DOUBLE := NULL, P_V019 IN BINARY_DOUBLE := NULL, P_V020 IN BINARY_DOUBLE := NULL,
P_V021 IN BINARY_DOUBLE := NULL, P_V022 IN BINARY_DOUBLE := NULL, P_V023 IN BINARY_DOUBLE := NULL, P_V024 IN BINARY_DOUBLE := NULL, P_V025 IN BINARY_DOUBLE := NULL,
P_V026 IN BINARY_DOUBLE := NULL, P_V027 IN BINARY_DOUBLE := NULL, P_V028 IN BINARY_DOUBLE := NULL, P_V029 IN BINARY_DOUBLE := NULL, P_V030 IN BINARY_DOUBLE := NULL,
P_V031 IN BINARY_DOUBLE := NULL, P_V032 IN BINARY_DOUBLE := NULL, P_V033 IN BINARY_DOUBLE := NULL, P_V034 IN BINARY_DOUBLE := NULL, P_V035 IN BINARY_DOUBLE := NULL,
P_V036 IN BINARY_DOUBLE := NULL, P_V037 IN BINARY_DOUBLE := NULL, P_V038 IN BINARY_DOUBLE := NULL, P_V039 IN BINARY_DOUBLE := NULL, P_V040 IN BINARY_DOUBLE := NULL,
P_V041 IN BINARY_DOUBLE := NULL, P_V042 IN BINARY_DOUBLE := NULL, P_V043 IN BINARY_DOUBLE := NULL, P_V044 IN BINARY_DOUBLE := NULL, P_V045 IN BINARY_DOUBLE := NULL,
P_V046 IN BINARY_DOUBLE := NULL, P_V047 IN BINARY_DOUBLE := NULL, P_V048 IN BINARY_DOUBLE := NULL, P_V049 IN BINARY_DOUBLE := NULL, P_V050 IN BINARY_DOUBLE := NULL,
P_V051 IN BINARY_DOUBLE := NULL, P_V052 IN BINARY_DOUBLE := NULL, P_V053 IN BINARY_DOUBLE := NULL, P_V054 IN BINARY_DOUBLE := NULL, P_V055 IN BINARY_DOUBLE := NULL,
P_V056 IN BINARY_DOUBLE := NULL, P_V057 IN BINARY_DOUBLE := NULL, P_V058 IN BINARY_DOUBLE := NULL, P_V059 IN BINARY_DOUBLE := NULL, P_V060 IN BINARY_DOUBLE := NULL,
P_V061 IN BINARY_DOUBLE := NULL, P_V062 IN BINARY_DOUBLE := NULL, P_V063 IN BINARY_DOUBLE := NULL, P_V064 IN BINARY_DOUBLE := NULL, P_V065 IN BINARY_DOUBLE := NULL,
P_V066 IN BINARY_DOUBLE := NULL, P_V067 IN BINARY_DOUBLE := NULL, P_V068 IN BINARY_DOUBLE := NULL, P_V069 IN BINARY_DOUBLE := NULL, P_V070 IN BINARY_DOUBLE := NULL,
P_V071 IN BINARY_DOUBLE := NULL, P_V072 IN BINARY_DOUBLE := NULL, P_V073 IN BINARY_DOUBLE := NULL, P_V074 IN BINARY_DOUBLE := NULL, P_V075 IN BINARY_DOUBLE := NULL,
P_V076 IN BINARY_DOUBLE := NULL, P_V077 IN BINARY_DOUBLE := NULL, P_V078 IN BINARY_DOUBLE := NULL, P_V079 IN BINARY_DOUBLE := NULL, P_V080 IN BINARY_DOUBLE := NULL,
P_V081 IN BINARY_DOUBLE := NULL, P_V082 IN BINARY_DOUBLE := NULL, P_V083 IN BINARY_DOUBLE := NULL, P_V084 IN BINARY_DOUBLE := NULL, P_V085 IN BINARY_DOUBLE := NULL,
P_V086 IN BINARY_DOUBLE := NULL, P_V087 IN BINARY_DOUBLE := NULL, P_V088 IN BINARY_DOUBLE := NULL, P_V089 IN BINARY_DOUBLE := NULL, P_V090 IN BINARY_DOUBLE := NULL,
P_V091 IN BINARY_DOUBLE := NULL, P_V092 IN BINARY_DOUBLE := NULL, P_V093 IN BINARY_DOUBLE := NULL, P_V094 IN BINARY_DOUBLE := NULL, P_V095 IN BINARY_DOUBLE := NULL,
P_V096 IN BINARY_DOUBLE := NULL, P_V097 IN BINARY_DOUBLE := NULL, P_V098 IN BINARY_DOUBLE := NULL, P_V099 IN BINARY_DOUBLE := NULL, P_V100 IN BINARY_DOUBLE := NULL,
P_V101 IN BINARY_DOUBLE := NULL, P_V102 IN BINARY_DOUBLE := NULL, P_V103 IN BINARY_DOUBLE := NULL, P_V104 IN BINARY_DOUBLE := NULL, P_V105 IN BINARY_DOUBLE := NULL,
P_V106 IN BINARY_DOUBLE := NULL, P_V107 IN BINARY_DOUBLE := NULL, P_V108 IN BINARY_DOUBLE := NULL, P_V109 IN BINARY_DOUBLE := NULL, P_V110 IN BINARY_DOUBLE := NULL,
P_V111 IN BINARY_DOUBLE := NULL, P_V112 IN BINARY_DOUBLE := NULL, P_V113 IN BINARY_DOUBLE := NULL, P_V114 IN BINARY_DOUBLE := NULL, P_V115 IN BINARY_DOUBLE := NULL,
P_V116 IN BINARY_DOUBLE := NULL, P_V117 IN BINARY_DOUBLE := NULL, P_V118 IN BINARY_DOUBLE := NULL, P_V119 IN BINARY_DOUBLE := NULL, P_V120 IN BINARY_DOUBLE := NULL,
P_V121 IN BINARY_DOUBLE := NULL, P_V122 IN BINARY_DOUBLE := NULL, P_V123 IN BINARY_DOUBLE := NULL, P_V124 IN BINARY_DOUBLE := NULL, P_V125 IN BINARY_DOUBLE := NULL,
P_V126 IN BINARY_DOUBLE := NULL, P_V127 IN BINARY_DOUBLE := NULL, P_V128 IN BINARY_DOUBLE := NULL, P_V129 IN BINARY_DOUBLE := NULL, P_V130 IN BINARY_DOUBLE := NULL,
P_V131 IN BINARY_DOUBLE := NULL, P_V132 IN BINARY_DOUBLE := NULL, P_V133 IN BINARY_DOUBLE := NULL, P_V134 IN BINARY_DOUBLE := NULL, P_V135 IN BINARY_DOUBLE := NULL,
P_V136 IN BINARY_DOUBLE := NULL, P_V137 IN BINARY_DOUBLE := NULL, P_V138 IN BINARY_DOUBLE := NULL, P_V139 IN BINARY_DOUBLE := NULL, P_V140 IN BINARY_DOUBLE := NULL,
P_V141 IN BINARY_DOUBLE := NULL, P_V142 IN BINARY_DOUBLE := NULL, P_V143 IN BINARY_DOUBLE := NULL, P_V144 IN BINARY_DOUBLE := NULL, P_V145 IN BINARY_DOUBLE := NULL,
P_V146 IN BINARY_DOUBLE := NULL, P_V147 IN BINARY_DOUBLE := NULL, P_V148 IN BINARY_DOUBLE := NULL, P_V149 IN BINARY_DOUBLE := NULL, P_V150 IN BINARY_DOUBLE := NULL,
P_V151 IN BINARY_DOUBLE := NULL, P_V152 IN BINARY_DOUBLE := NULL, P_V153 IN BINARY_DOUBLE := NULL, P_V154 IN BINARY_DOUBLE := NULL, P_V155 IN BINARY_DOUBLE := NULL,
P_V156 IN BINARY_DOUBLE := NULL, P_V157 IN BINARY_DOUBLE := NULL, P_V158 IN BINARY_DOUBLE := NULL, P_V159 IN BINARY_DOUBLE := NULL, P_V160 IN BINARY_DOUBLE := NULL,
P_V161 IN BINARY_DOUBLE := NULL, P_V162 IN BINARY_DOUBLE := NULL, P_V163 IN BINARY_DOUBLE := NULL, P_V164 IN BINARY_DOUBLE := NULL, P_V165 IN BINARY_DOUBLE := NULL,
P_V166 IN BINARY_DOUBLE := NULL, P_V167 IN BINARY_DOUBLE := NULL, P_V168 IN BINARY_DOUBLE := NULL, P_V169 IN BINARY_DOUBLE := NULL, P_V170 IN BINARY_DOUBLE := NULL,
P_V171 IN BINARY_DOUBLE := NULL, P_V172 IN BINARY_DOUBLE := NULL, P_V173 IN BINARY_DOUBLE := NULL, P_V174 IN BINARY_DOUBLE := NULL, P_V175 IN BINARY_DOUBLE := NULL,
P_V176 IN BINARY_DOUBLE := NULL, P_V177 IN BINARY_DOUBLE := NULL, P_V178 IN BINARY_DOUBLE := NULL, P_V179 IN BINARY_DOUBLE := NULL, P_V180 IN BINARY_DOUBLE := NULL,
P_V181 IN BINARY_DOUBLE := NULL, P_V182 IN BINARY_DOUBLE := NULL, P_V183 IN BINARY_DOUBLE := NULL, P_V184 IN BINARY_DOUBLE := NULL, P_V185 IN BINARY_DOUBLE := NULL,
P_V186 IN BINARY_DOUBLE := NULL, P_V187 IN BINARY_DOUBLE := NULL, P_V188 IN BINARY_DOUBLE := NULL, P_V189 IN BINARY_DOUBLE := NULL, P_V190 IN BINARY_DOUBLE := NULL,
P_V191 IN BINARY_DOUBLE := NULL, P_V192 IN BINARY_DOUBLE := NULL, P_V193 IN BINARY_DOUBLE := NULL, P_V194 IN BINARY_DOUBLE := NULL, P_V195 IN BINARY_DOUBLE := NULL,
P_V196 IN BINARY_DOUBLE := NULL, P_V197 IN BINARY_DOUBLE := NULL, P_V198 IN BINARY_DOUBLE := NULL, P_V199 IN BINARY_DOUBLE := NULL, P_V200 IN BINARY_DOUBLE := NULL,
P_V201 IN BINARY_DOUBLE := NULL, P_V202 IN BINARY_DOUBLE := NULL, P_V203 IN BINARY_DOUBLE := NULL, P_V204 IN BINARY_DOUBLE := NULL, P_V205 IN BINARY_DOUBLE := NULL,
P_V206 IN BINARY_DOUBLE := NULL, P_V207 IN BINARY_DOUBLE := NULL, P_V208 IN BINARY_DOUBLE := NULL, P_V209 IN BINARY_DOUBLE := NULL, P_V210 IN BINARY_DOUBLE := NULL,
P_V211 IN BINARY_DOUBLE := NULL, P_V212 IN BINARY_DOUBLE := NULL, P_V213 IN BINARY_DOUBLE := NULL, P_V214 IN BINARY_DOUBLE := NULL, P_V215 IN BINARY_DOUBLE := NULL,
P_V216 IN BINARY_DOUBLE := NULL, P_V217 IN BINARY_DOUBLE := NULL, P_V218 IN BINARY_DOUBLE := NULL, P_V219 IN BINARY_DOUBLE := NULL, P_V220 IN BINARY_DOUBLE := NULL,
P_V221 IN BINARY_DOUBLE := NULL, P_V222 IN BINARY_DOUBLE := NULL, P_V223 IN BINARY_DOUBLE := NULL, P_V224 IN BINARY_DOUBLE := NULL, P_V225 IN BINARY_DOUBLE := NULL,
P_V226 IN BINARY_DOUBLE := NULL, P_V227 IN BINARY_DOUBLE := NULL, P_V228 IN BINARY_DOUBLE := NULL, P_V229 IN BINARY_DOUBLE := NULL, P_V230 IN BINARY_DOUBLE := NULL,
P_V231 IN BINARY_DOUBLE := NULL, P_V232 IN BINARY_DOUBLE := NULL, P_V233 IN BINARY_DOUBLE := NULL, P_V234 IN BINARY_DOUBLE := NULL, P_V235 IN BINARY_DOUBLE := NULL,
P_V236 IN BINARY_DOUBLE := NULL, P_V237 IN BINARY_DOUBLE := NULL, P_V238 IN BINARY_DOUBLE := NULL, P_V239 IN BINARY_DOUBLE := NULL, P_V240 IN BINARY_DOUBLE := NULL,
P_V241 IN BINARY_DOUBLE := NULL, P_V242 IN BINARY_DOUBLE := NULL, P_V243 IN BINARY_DOUBLE := NULL, P_V244 IN BINARY_DOUBLE := NULL, P_V245 IN BINARY_DOUBLE := NULL,
P_V246 IN BINARY_DOUBLE := NULL, P_V247 IN BINARY_DOUBLE := NULL, P_V248 IN BINARY_DOUBLE := NULL, P_V249 IN BINARY_DOUBLE := NULL, P_V250 IN BINARY_DOUBLE := NULL,
P_V251 IN BINARY_DOUBLE := NULL, P_V252 IN BINARY_DOUBLE := NULL, P_V253 IN BINARY_DOUBLE := NULL, P_V254 IN BINARY_DOUBLE := NULL, P_V255 IN BINARY_DOUBLE := NULL)
RETURN BINARY_INTEGER
IS BEGIN
RETURN CASE P_KEY
WHEN P_V001 THEN 1 WHEN P_V002 THEN 2 WHEN P_V003 THEN 3 WHEN P_V004 THEN 4 WHEN P_V005 THEN 5
WHEN P_V006 THEN 6 WHEN P_V007 THEN 7 WHEN P_V008 THEN 8 WHEN P_V009 THEN 9 WHEN P_V010 THEN 10
WHEN P_V011 THEN 11 WHEN P_V012 THEN 12 WHEN P_V013 THEN 13 WHEN P_V014 THEN 14 WHEN P_V015 THEN 15
WHEN P_V016 THEN 16 WHEN P_V017 THEN 17 WHEN P_V018 THEN 18 WHEN P_V019 THEN 19 WHEN P_V020 THEN 20
WHEN P_V021 THEN 21 WHEN P_V022 THEN 22 WHEN P_V023 THEN 23 WHEN P_V024 THEN 24 WHEN P_V025 THEN 25
WHEN P_V026 THEN 26 WHEN P_V027 THEN 27 WHEN P_V028 THEN 28 WHEN P_V029 THEN 29 WHEN P_V030 THEN 30
WHEN P_V031 THEN 31 WHEN P_V032 THEN 32 WHEN P_V033 THEN 33 WHEN P_V034 THEN 34 WHEN P_V035 THEN 35
WHEN P_V036 THEN 36 WHEN P_V037 THEN 37 WHEN P_V038 THEN 38 WHEN P_V039 THEN 39 WHEN P_V040 THEN 40
WHEN P_V041 THEN 41 WHEN P_V042 THEN 42 WHEN P_V043 THEN 43 WHEN P_V044 THEN 44 WHEN P_V045 THEN 45
WHEN P_V046 THEN 46 WHEN P_V047 THEN 47 WHEN P_V048 THEN 48 WHEN P_V049 THEN 49 WHEN P_V050 THEN 50
WHEN P_V051 THEN 51 WHEN P_V052 THEN 52 WHEN P_V053 THEN 53 WHEN P_V054 THEN 54 WHEN P_V055 THEN 55
WHEN P_V056 THEN 56 WHEN P_V057 THEN 57 WHEN P_V058 THEN 58 WHEN P_V059 THEN 59 WHEN P_V060 THEN 60
WHEN P_V061 THEN 61 WHEN P_V062 THEN 62 WHEN P_V063 THEN 63 WHEN P_V064 THEN 64 WHEN P_V065 THEN 65
WHEN P_V066 THEN 66 WHEN P_V067 THEN 67 WHEN P_V068 THEN 68 WHEN P_V069 THEN 69 WHEN P_V070 THEN 70
WHEN P_V071 THEN 71 WHEN P_V072 THEN 72 WHEN P_V073 THEN 73 WHEN P_V074 THEN 74 WHEN P_V075 THEN 75
WHEN P_V076 THEN 76 WHEN P_V077 THEN 77 WHEN P_V078 THEN 78 WHEN P_V079 THEN 79 WHEN P_V080 THEN 80
WHEN P_V081 THEN 81 WHEN P_V082 THEN 82 WHEN P_V083 THEN 83 WHEN P_V084 THEN 84 WHEN P_V085 THEN 85
WHEN P_V086 THEN 86 WHEN P_V087 THEN 87 WHEN P_V088 THEN 88 WHEN P_V089 THEN 89 WHEN P_V090 THEN 90
WHEN P_V091 THEN 91 WHEN P_V092 THEN 92 WHEN P_V093 THEN 93 WHEN P_V094 THEN 94 WHEN P_V095 THEN 95
WHEN P_V096 THEN 96 WHEN P_V097 THEN 97 WHEN P_V098 THEN 98 WHEN P_V099 THEN 99 WHEN P_V100 THEN 100
WHEN P_V101 THEN 101 WHEN P_V102 THEN 102 WHEN P_V103 THEN 103 WHEN P_V104 THEN 104 WHEN P_V105 THEN 105
WHEN P_V106 THEN 106 WHEN P_V107 THEN 107 WHEN P_V108 THEN 108 WHEN P_V109 THEN 109 WHEN P_V110 THEN 110
WHEN P_V111 THEN 111 WHEN P_V112 THEN 112 WHEN P_V113 THEN 113 WHEN P_V114 THEN 114 WHEN P_V115 THEN 115
WHEN P_V116 THEN 116 WHEN P_V117 THEN 117 WHEN P_V118 THEN 118 WHEN P_V119 THEN 119 WHEN P_V120 THEN 120
WHEN P_V121 THEN 121 WHEN P_V122 THEN 122 WHEN P_V123 THEN 123 WHEN P_V124 THEN 124 WHEN P_V125 THEN 125
WHEN P_V126 THEN 126 WHEN P_V127 THEN 127 WHEN P_V128 THEN 128 WHEN P_V129 THEN 129 WHEN P_V130 THEN 130
WHEN P_V131 THEN 131 WHEN P_V132 THEN 132 WHEN P_V133 THEN 133 WHEN P_V134 THEN 134 WHEN P_V135 THEN 135
WHEN P_V136 THEN 136 WHEN P_V137 THEN 137 WHEN P_V138 THEN 138 WHEN P_V139 THEN 139 WHEN P_V140 THEN 140
WHEN P_V141 THEN 141 WHEN P_V142 THEN 142 WHEN P_V143 THEN 143 WHEN P_V144 THEN 144 WHEN P_V145 THEN 145
WHEN P_V146 THEN 146 WHEN P_V147 THEN 147 WHEN P_V148 THEN 148 WHEN P_V149 THEN 149 WHEN P_V150 THEN 150
WHEN P_V151 THEN 151 WHEN P_V152 THEN 152 WHEN P_V153 THEN 153 WHEN P_V154 THEN 154 WHEN P_V155 THEN 155
WHEN P_V156 THEN 156 WHEN P_V157 THEN 157 WHEN P_V158 THEN 158 WHEN P_V159 THEN 159 WHEN P_V160 THEN 160
WHEN P_V161 THEN 161 WHEN P_V162 THEN 162 WHEN P_V163 THEN 163 WHEN P_V164 THEN 164 WHEN P_V165 THEN 165
WHEN P_V166 THEN 166 WHEN P_V167 THEN 167 WHEN P_V168 THEN 168 WHEN P_V169 THEN 169 WHEN P_V170 THEN 170
WHEN P_V171 THEN 171 WHEN P_V172 THEN 172 WHEN P_V173 THEN 173 WHEN P_V174 THEN 174 WHEN P_V175 THEN 175
WHEN P_V176 THEN 176 WHEN P_V177 THEN 177 WHEN P_V178 THEN 178 WHEN P_V179 THEN 179 WHEN P_V180 THEN 180
WHEN P_V181 THEN 181 WHEN P_V182 THEN 182 WHEN P_V183 THEN 183 WHEN P_V184 THEN 184 WHEN P_V185 THEN 185
WHEN P_V186 THEN 186 WHEN P_V187 THEN 187 WHEN P_V188 THEN 188 WHEN P_V189 THEN 189 WHEN P_V190 THEN 190
WHEN P_V191 THEN 191 WHEN P_V192 THEN 192 WHEN P_V193 THEN 193 WHEN P_V194 THEN 194 WHEN P_V195 THEN 195
WHEN P_V196 THEN 196 WHEN P_V197 THEN 197 WHEN P_V198 THEN 198 WHEN P_V199 THEN 199 WHEN P_V200 THEN 200
WHEN P_V201 THEN 201 WHEN P_V202 THEN 202 WHEN P_V203 THEN 203 WHEN P_V204 THEN 204 WHEN P_V205 THEN 205
WHEN P_V206 THEN 206 WHEN P_V207 THEN 207 WHEN P_V208 THEN 208 WHEN P_V209 THEN 209 WHEN P_V210 THEN 210
WHEN P_V211 THEN 211 WHEN P_V212 THEN 212 WHEN P_V213 THEN 213 WHEN P_V214 THEN 214 WHEN P_V215 THEN 215
WHEN P_V216 THEN 216 WHEN P_V217 THEN 217 WHEN P_V218 THEN 218 WHEN P_V219 THEN 219 WHEN P_V220 THEN 220
WHEN P_V221 THEN 221 WHEN P_V222 THEN 222 WHEN P_V223 THEN 223 WHEN P_V224 THEN 224 WHEN P_V225 THEN 225
WHEN P_V226 THEN 226 WHEN P_V227 THEN 227 WHEN P_V228 THEN 228 WHEN P_V229 THEN 229 WHEN P_V230 THEN 230
WHEN P_V231 THEN 231 WHEN P_V232 THEN 232 WHEN P_V233 THEN 233 WHEN P_V234 THEN 234 WHEN P_V235 THEN 235
WHEN P_V236 THEN 236 WHEN P_V237 THEN 237 WHEN P_V238 THEN 238 WHEN P_V239 THEN 239 WHEN P_V240 THEN 240
WHEN P_V241 THEN 241 WHEN P_V242 THEN 242 WHEN P_V243 THEN 243 WHEN P_V244 THEN 244 WHEN P_V245 THEN 245
WHEN P_V246 THEN 246 WHEN P_V247 THEN 247 WHEN P_V248 THEN 248 WHEN P_V249 THEN 249 WHEN P_V250 THEN 250
WHEN P_V251 THEN 251 WHEN P_V252 THEN 252 WHEN P_V253 THEN 253 WHEN P_V254 THEN 254 WHEN P_V255 THEN 255
ELSE 0
END;
END;
END;
/