DBA Data[Home] [Help]

APPS.BEN_EXT_RSLT_DTL_BK2 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

procedure UPDATE_EXT_RSLT_DTL_A
(P_EXT_RSLT_DTL_ID in NUMBER
,P_PRMY_SORT_VAL in VARCHAR2
,P_SCND_SORT_VAL in VARCHAR2
,P_THRD_SORT_VAL in VARCHAR2
,P_TRANS_SEQ_NUM in NUMBER
,P_RCRD_SEQ_NUM in NUMBER
,P_EXT_RSLT_ID in NUMBER
,P_EXT_RCD_ID in NUMBER
,P_PERSON_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_EXT_PER_BG_ID in NUMBER
,P_VAL_01 in VARCHAR2
,P_VAL_02 in VARCHAR2
,P_VAL_03 in VARCHAR2
,P_VAL_04 in VARCHAR2
,P_VAL_05 in VARCHAR2
,P_VAL_06 in VARCHAR2
,P_VAL_07 in VARCHAR2
,P_VAL_08 in VARCHAR2
,P_VAL_09 in VARCHAR2
,P_VAL_10 in VARCHAR2
,P_VAL_11 in VARCHAR2
,P_VAL_12 in VARCHAR2
,P_VAL_13 in VARCHAR2
,P_VAL_14 in VARCHAR2
,P_VAL_15 in VARCHAR2
,P_VAL_16 in VARCHAR2
,P_VAL_17 in VARCHAR2
,P_VAL_19 in VARCHAR2
,P_VAL_18 in VARCHAR2
,P_VAL_20 in VARCHAR2
,P_VAL_21 in VARCHAR2
,P_VAL_22 in VARCHAR2
,P_VAL_23 in VARCHAR2
,P_VAL_24 in VARCHAR2
,P_VAL_25 in VARCHAR2
,P_VAL_26 in VARCHAR2
,P_VAL_27 in VARCHAR2
,P_VAL_28 in VARCHAR2
,P_VAL_29 in VARCHAR2
,P_VAL_30 in VARCHAR2
,P_VAL_31 in VARCHAR2
,P_VAL_32 in VARCHAR2
,P_VAL_33 in VARCHAR2
,P_VAL_34 in VARCHAR2
,P_VAL_35 in VARCHAR2
,P_VAL_36 in VARCHAR2
,P_VAL_37 in VARCHAR2
,P_VAL_38 in VARCHAR2
,P_VAL_39 in VARCHAR2
,P_VAL_40 in VARCHAR2
,P_VAL_41 in VARCHAR2
,P_VAL_42 in VARCHAR2
,P_VAL_43 in VARCHAR2
,P_VAL_44 in VARCHAR2
,P_VAL_45 in VARCHAR2
,P_VAL_46 in VARCHAR2
,P_VAL_47 in VARCHAR2
,P_VAL_48 in VARCHAR2
,P_VAL_49 in VARCHAR2
,P_VAL_50 in VARCHAR2
,P_VAL_51 in VARCHAR2
,P_VAL_52 in VARCHAR2
,P_VAL_53 in VARCHAR2
,P_VAL_54 in VARCHAR2
,P_VAL_55 in VARCHAR2
,P_VAL_56 in VARCHAR2
,P_VAL_57 in VARCHAR2
,P_VAL_58 in VARCHAR2
,P_VAL_59 in VARCHAR2
,P_VAL_60 in VARCHAR2
,P_VAL_61 in VARCHAR2
,P_VAL_62 in VARCHAR2
,P_VAL_63 in VARCHAR2
,P_VAL_64 in VARCHAR2
,P_VAL_65 in VARCHAR2
,P_VAL_66 in VARCHAR2
,P_VAL_67 in VARCHAR2
,P_VAL_68 in VARCHAR2
,P_VAL_69 in VARCHAR2
,P_VAL_70 in VARCHAR2
,P_VAL_71 in VARCHAR2
,P_VAL_72 in VARCHAR2
,P_VAL_73 in VARCHAR2
,P_VAL_74 in VARCHAR2
,P_VAL_75 in VARCHAR2
,P_VAL_76 in VARCHAR2
,P_VAL_77 in VARCHAR2
,P_VAL_78 in VARCHAR2
,P_VAL_79 in VARCHAR2
,P_VAL_80 in VARCHAR2
,P_VAL_81 in VARCHAR2
,P_VAL_82 in VARCHAR2
,P_VAL_83 in VARCHAR2
,P_VAL_84 in VARCHAR2
,P_VAL_85 in VARCHAR2
,P_VAL_86 in VARCHAR2
,P_VAL_87 in VARCHAR2
,P_VAL_88 in VARCHAR2
,P_VAL_89 in VARCHAR2
,P_VAL_90 in VARCHAR2
,P_VAL_91 in VARCHAR2
,P_VAL_92 in VARCHAR2
,P_VAL_93 in VARCHAR2
,P_VAL_94 in VARCHAR2
,P_VAL_95 in VARCHAR2
,P_VAL_96 in VARCHAR2
,P_VAL_97 in VARCHAR2
,P_VAL_98 in VARCHAR2
,P_VAL_99 in VARCHAR2
,P_VAL_100 in VARCHAR2
,P_VAL_101 in VARCHAR2
,P_VAL_102 in VARCHAR2
,P_VAL_103 in VARCHAR2
,P_VAL_104 in VARCHAR2
,P_VAL_105 in VARCHAR2
,P_VAL_106 in VARCHAR2
,P_VAL_107 in VARCHAR2
,P_VAL_108 in VARCHAR2
,P_VAL_109 in VARCHAR2
,P_VAL_110 in VARCHAR2
,P_VAL_111 in VARCHAR2
,P_VAL_112 in VARCHAR2
,P_VAL_113 in VARCHAR2
,P_VAL_114 in VARCHAR2
,P_VAL_115 in VARCHAR2
,P_VAL_116 in VARCHAR2
,P_VAL_117 in VARCHAR2
,P_VAL_119 in VARCHAR2
,P_VAL_118 in VARCHAR2
,P_VAL_120 in VARCHAR2
,P_VAL_121 in VARCHAR2
,P_VAL_122 in VARCHAR2
,P_VAL_123 in VARCHAR2
,P_VAL_124 in VARCHAR2
,P_VAL_125 in VARCHAR2
,P_VAL_126 in VARCHAR2
,P_VAL_127 in VARCHAR2
,P_VAL_128 in VARCHAR2
,P_VAL_129 in VARCHAR2
,P_VAL_130 in VARCHAR2
,P_VAL_131 in VARCHAR2
,P_VAL_132 in VARCHAR2
,P_VAL_133 in VARCHAR2
,P_VAL_134 in VARCHAR2
,P_VAL_135 in VARCHAR2
,P_VAL_136 in VARCHAR2
,P_VAL_137 in VARCHAR2
,P_VAL_138 in VARCHAR2
,P_VAL_139 in VARCHAR2
,P_VAL_140 in VARCHAR2
,P_VAL_141 in VARCHAR2
,P_VAL_142 in VARCHAR2
,P_VAL_143 in VARCHAR2
,P_VAL_144 in VARCHAR2
,P_VAL_145 in VARCHAR2
,P_VAL_146 in VARCHAR2
,P_VAL_147 in VARCHAR2
,P_VAL_148 in VARCHAR2
,P_VAL_149 in VARCHAR2
,P_VAL_150 in VARCHAR2
,P_VAL_151 in VARCHAR2
,P_VAL_152 in VARCHAR2
,P_VAL_153 in VARCHAR2
,P_VAL_154 in VARCHAR2
,P_VAL_155 in VARCHAR2
,P_VAL_156 in VARCHAR2
,P_VAL_157 in VARCHAR2
,P_VAL_158 in VARCHAR2
,P_VAL_159 in VARCHAR2
,P_VAL_160 in VARCHAR2
,P_VAL_161 in VARCHAR2
,P_VAL_162 in VARCHAR2
,P_VAL_163 in VARCHAR2
,P_VAL_164 in VARCHAR2
,P_VAL_165 in VARCHAR2
,P_VAL_166 in VARCHAR2
,P_VAL_167 in VARCHAR2
,P_VAL_168 in VARCHAR2
,P_VAL_169 in VARCHAR2
,P_VAL_170 in VARCHAR2
,P_VAL_171 in VARCHAR2
,P_VAL_172 in VARCHAR2
,P_VAL_173 in VARCHAR2
,P_VAL_174 in VARCHAR2
,P_VAL_175 in VARCHAR2
,P_VAL_176 in VARCHAR2
,P_VAL_177 in VARCHAR2
,P_VAL_178 in VARCHAR2
,P_VAL_179 in VARCHAR2
,P_VAL_180 in VARCHAR2
,P_VAL_181 in VARCHAR2
,P_VAL_182 in VARCHAR2
,P_VAL_183 in VARCHAR2
,P_VAL_184 in VARCHAR2
,P_VAL_185 in VARCHAR2
,P_VAL_186 in VARCHAR2
,P_VAL_187 in VARCHAR2
,P_VAL_188 in VARCHAR2
,P_VAL_189 in VARCHAR2
,P_VAL_190 in VARCHAR2
,P_VAL_191 in VARCHAR2
,P_VAL_192 in VARCHAR2
,P_VAL_193 in VARCHAR2
,P_VAL_194 in VARCHAR2
,P_VAL_195 in VARCHAR2
,P_VAL_196 in VARCHAR2
,P_VAL_197 in VARCHAR2
,P_VAL_198 in VARCHAR2
,P_VAL_199 in VARCHAR2
,P_VAL_200 in VARCHAR2
,P_VAL_201 in VARCHAR2
,P_VAL_202 in VARCHAR2
,P_VAL_203 in VARCHAR2
,P_VAL_204 in VARCHAR2
,P_VAL_205 in VARCHAR2
,P_VAL_206 in VARCHAR2
,P_VAL_207 in VARCHAR2
,P_VAL_208 in VARCHAR2
,P_VAL_209 in VARCHAR2
,P_VAL_210 in VARCHAR2
,P_VAL_211 in VARCHAR2
,P_VAL_212 in VARCHAR2
,P_VAL_213 in VARCHAR2
,P_VAL_214 in VARCHAR2
,P_VAL_215 in VARCHAR2
,P_VAL_216 in VARCHAR2
,P_VAL_217 in VARCHAR2
,P_VAL_219 in VARCHAR2
,P_VAL_218 in VARCHAR2
,P_VAL_220 in VARCHAR2
,P_VAL_221 in VARCHAR2
,P_VAL_222 in VARCHAR2
,P_VAL_223 in VARCHAR2
,P_VAL_224 in VARCHAR2
,P_VAL_225 in VARCHAR2
,P_VAL_226 in VARCHAR2
,P_VAL_227 in VARCHAR2
,P_VAL_228 in VARCHAR2
,P_VAL_229 in VARCHAR2
,P_VAL_230 in VARCHAR2
,P_VAL_231 in VARCHAR2
,P_VAL_232 in VARCHAR2
,P_VAL_233 in VARCHAR2
,P_VAL_234 in VARCHAR2
,P_VAL_235 in VARCHAR2
,P_VAL_236 in VARCHAR2
,P_VAL_237 in VARCHAR2
,P_VAL_238 in VARCHAR2
,P_VAL_239 in VARCHAR2
,P_VAL_240 in VARCHAR2
,P_VAL_241 in VARCHAR2
,P_VAL_242 in VARCHAR2
,P_VAL_243 in VARCHAR2
,P_VAL_244 in VARCHAR2
,P_VAL_245 in VARCHAR2
,P_VAL_246 in VARCHAR2
,P_VAL_247 in VARCHAR2
,P_VAL_248 in VARCHAR2
,P_VAL_249 in VARCHAR2
,P_VAL_250 in VARCHAR2
,P_VAL_251 in VARCHAR2
,P_VAL_252 in VARCHAR2
,P_VAL_253 in VARCHAR2
,P_VAL_254 in VARCHAR2
,P_VAL_255 in VARCHAR2
,P_VAL_256 in VARCHAR2
,P_VAL_257 in VARCHAR2
,P_VAL_258 in VARCHAR2
,P_VAL_259 in VARCHAR2
,P_VAL_260 in VARCHAR2
,P_VAL_261 in VARCHAR2
,P_VAL_262 in VARCHAR2
,P_VAL_263 in VARCHAR2
,P_VAL_264 in VARCHAR2
,P_VAL_265 in VARCHAR2
,P_VAL_266 in VARCHAR2
,P_VAL_267 in VARCHAR2
,P_VAL_268 in VARCHAR2
,P_VAL_269 in VARCHAR2
,P_VAL_270 in VARCHAR2
,P_VAL_271 in VARCHAR2
,P_VAL_272 in VARCHAR2
,P_VAL_273 in VARCHAR2
,P_VAL_274 in VARCHAR2
,P_VAL_275 in VARCHAR2
,P_VAL_276 in VARCHAR2
,P_VAL_277 in VARCHAR2
,P_VAL_278 in VARCHAR2
,P_VAL_279 in VARCHAR2
,P_VAL_280 in VARCHAR2
,P_VAL_281 in VARCHAR2
,P_VAL_282 in VARCHAR2
,P_VAL_283 in VARCHAR2
,P_VAL_284 in VARCHAR2
,P_VAL_285 in VARCHAR2
,P_VAL_286 in VARCHAR2
,P_VAL_287 in VARCHAR2
,P_VAL_288 in VARCHAR2
,P_VAL_289 in VARCHAR2
,P_VAL_290 in VARCHAR2
,P_VAL_291 in VARCHAR2
,P_VAL_292 in VARCHAR2
,P_VAL_293 in VARCHAR2
,P_VAL_294 in VARCHAR2
,P_VAL_295 in VARCHAR2
,P_VAL_296 in VARCHAR2
,P_VAL_297 in VARCHAR2
,P_VAL_298 in VARCHAR2
,P_VAL_299 in VARCHAR2
,P_VAL_300 in VARCHAR2
,P_GROUP_VAL_01 in VARCHAR2
,P_GROUP_VAL_02 in VARCHAR2
,P_PROGRAM_APPLICATION_ID in NUMBER
,P_PROGRAM_ID in NUMBER
,P_PROGRAM_UPDATE_DATE in DATE
,P_REQUEST_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EXT_RCD_IN_FILE_ID in NUMBER
)is
begin
hr_utility.set_location('Entering: BEN_EXT_RSLT_DTL_BK2.UPDATE_EXT_RSLT_DTL_A', 10);
Line: 328

hr_utility.set_location(' Leaving: BEN_EXT_RSLT_DTL_BK2.UPDATE_EXT_RSLT_DTL_A', 20);
Line: 329

end UPDATE_EXT_RSLT_DTL_A;
Line: 330

procedure UPDATE_EXT_RSLT_DTL_B
(P_EXT_RSLT_DTL_ID in NUMBER
,P_PRMY_SORT_VAL in VARCHAR2
,P_SCND_SORT_VAL in VARCHAR2
,P_THRD_SORT_VAL in VARCHAR2
,P_TRANS_SEQ_NUM in NUMBER
,P_RCRD_SEQ_NUM in NUMBER
,P_EXT_RSLT_ID in NUMBER
,P_EXT_RCD_ID in NUMBER
,P_PERSON_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_EXT_PER_BG_ID in NUMBER
,P_VAL_01 in VARCHAR2
,P_VAL_02 in VARCHAR2
,P_VAL_03 in VARCHAR2
,P_VAL_04 in VARCHAR2
,P_VAL_05 in VARCHAR2
,P_VAL_06 in VARCHAR2
,P_VAL_07 in VARCHAR2
,P_VAL_08 in VARCHAR2
,P_VAL_09 in VARCHAR2
,P_VAL_10 in VARCHAR2
,P_VAL_11 in VARCHAR2
,P_VAL_12 in VARCHAR2
,P_VAL_13 in VARCHAR2
,P_VAL_14 in VARCHAR2
,P_VAL_15 in VARCHAR2
,P_VAL_16 in VARCHAR2
,P_VAL_17 in VARCHAR2
,P_VAL_19 in VARCHAR2
,P_VAL_18 in VARCHAR2
,P_VAL_20 in VARCHAR2
,P_VAL_21 in VARCHAR2
,P_VAL_22 in VARCHAR2
,P_VAL_23 in VARCHAR2
,P_VAL_24 in VARCHAR2
,P_VAL_25 in VARCHAR2
,P_VAL_26 in VARCHAR2
,P_VAL_27 in VARCHAR2
,P_VAL_28 in VARCHAR2
,P_VAL_29 in VARCHAR2
,P_VAL_30 in VARCHAR2
,P_VAL_31 in VARCHAR2
,P_VAL_32 in VARCHAR2
,P_VAL_33 in VARCHAR2
,P_VAL_34 in VARCHAR2
,P_VAL_35 in VARCHAR2
,P_VAL_36 in VARCHAR2
,P_VAL_37 in VARCHAR2
,P_VAL_38 in VARCHAR2
,P_VAL_39 in VARCHAR2
,P_VAL_40 in VARCHAR2
,P_VAL_41 in VARCHAR2
,P_VAL_42 in VARCHAR2
,P_VAL_43 in VARCHAR2
,P_VAL_44 in VARCHAR2
,P_VAL_45 in VARCHAR2
,P_VAL_46 in VARCHAR2
,P_VAL_47 in VARCHAR2
,P_VAL_48 in VARCHAR2
,P_VAL_49 in VARCHAR2
,P_VAL_50 in VARCHAR2
,P_VAL_51 in VARCHAR2
,P_VAL_52 in VARCHAR2
,P_VAL_53 in VARCHAR2
,P_VAL_54 in VARCHAR2
,P_VAL_55 in VARCHAR2
,P_VAL_56 in VARCHAR2
,P_VAL_57 in VARCHAR2
,P_VAL_58 in VARCHAR2
,P_VAL_59 in VARCHAR2
,P_VAL_60 in VARCHAR2
,P_VAL_61 in VARCHAR2
,P_VAL_62 in VARCHAR2
,P_VAL_63 in VARCHAR2
,P_VAL_64 in VARCHAR2
,P_VAL_65 in VARCHAR2
,P_VAL_66 in VARCHAR2
,P_VAL_67 in VARCHAR2
,P_VAL_68 in VARCHAR2
,P_VAL_69 in VARCHAR2
,P_VAL_70 in VARCHAR2
,P_VAL_71 in VARCHAR2
,P_VAL_72 in VARCHAR2
,P_VAL_73 in VARCHAR2
,P_VAL_74 in VARCHAR2
,P_VAL_75 in VARCHAR2
,P_VAL_76 in VARCHAR2
,P_VAL_77 in VARCHAR2
,P_VAL_78 in VARCHAR2
,P_VAL_79 in VARCHAR2
,P_VAL_80 in VARCHAR2
,P_VAL_81 in VARCHAR2
,P_VAL_82 in VARCHAR2
,P_VAL_83 in VARCHAR2
,P_VAL_84 in VARCHAR2
,P_VAL_85 in VARCHAR2
,P_VAL_86 in VARCHAR2
,P_VAL_87 in VARCHAR2
,P_VAL_88 in VARCHAR2
,P_VAL_89 in VARCHAR2
,P_VAL_90 in VARCHAR2
,P_VAL_91 in VARCHAR2
,P_VAL_92 in VARCHAR2
,P_VAL_93 in VARCHAR2
,P_VAL_94 in VARCHAR2
,P_VAL_95 in VARCHAR2
,P_VAL_96 in VARCHAR2
,P_VAL_97 in VARCHAR2
,P_VAL_98 in VARCHAR2
,P_VAL_99 in VARCHAR2
,P_VAL_100 in VARCHAR2
,P_VAL_101 in VARCHAR2
,P_VAL_102 in VARCHAR2
,P_VAL_103 in VARCHAR2
,P_VAL_104 in VARCHAR2
,P_VAL_105 in VARCHAR2
,P_VAL_106 in VARCHAR2
,P_VAL_107 in VARCHAR2
,P_VAL_108 in VARCHAR2
,P_VAL_109 in VARCHAR2
,P_VAL_110 in VARCHAR2
,P_VAL_111 in VARCHAR2
,P_VAL_112 in VARCHAR2
,P_VAL_113 in VARCHAR2
,P_VAL_114 in VARCHAR2
,P_VAL_115 in VARCHAR2
,P_VAL_116 in VARCHAR2
,P_VAL_117 in VARCHAR2
,P_VAL_119 in VARCHAR2
,P_VAL_118 in VARCHAR2
,P_VAL_120 in VARCHAR2
,P_VAL_121 in VARCHAR2
,P_VAL_122 in VARCHAR2
,P_VAL_123 in VARCHAR2
,P_VAL_124 in VARCHAR2
,P_VAL_125 in VARCHAR2
,P_VAL_126 in VARCHAR2
,P_VAL_127 in VARCHAR2
,P_VAL_128 in VARCHAR2
,P_VAL_129 in VARCHAR2
,P_VAL_130 in VARCHAR2
,P_VAL_131 in VARCHAR2
,P_VAL_132 in VARCHAR2
,P_VAL_133 in VARCHAR2
,P_VAL_134 in VARCHAR2
,P_VAL_135 in VARCHAR2
,P_VAL_136 in VARCHAR2
,P_VAL_137 in VARCHAR2
,P_VAL_138 in VARCHAR2
,P_VAL_139 in VARCHAR2
,P_VAL_140 in VARCHAR2
,P_VAL_141 in VARCHAR2
,P_VAL_142 in VARCHAR2
,P_VAL_143 in VARCHAR2
,P_VAL_144 in VARCHAR2
,P_VAL_145 in VARCHAR2
,P_VAL_146 in VARCHAR2
,P_VAL_147 in VARCHAR2
,P_VAL_148 in VARCHAR2
,P_VAL_149 in VARCHAR2
,P_VAL_150 in VARCHAR2
,P_VAL_151 in VARCHAR2
,P_VAL_152 in VARCHAR2
,P_VAL_153 in VARCHAR2
,P_VAL_154 in VARCHAR2
,P_VAL_155 in VARCHAR2
,P_VAL_156 in VARCHAR2
,P_VAL_157 in VARCHAR2
,P_VAL_158 in VARCHAR2
,P_VAL_159 in VARCHAR2
,P_VAL_160 in VARCHAR2
,P_VAL_161 in VARCHAR2
,P_VAL_162 in VARCHAR2
,P_VAL_163 in VARCHAR2
,P_VAL_164 in VARCHAR2
,P_VAL_165 in VARCHAR2
,P_VAL_166 in VARCHAR2
,P_VAL_167 in VARCHAR2
,P_VAL_168 in VARCHAR2
,P_VAL_169 in VARCHAR2
,P_VAL_170 in VARCHAR2
,P_VAL_171 in VARCHAR2
,P_VAL_172 in VARCHAR2
,P_VAL_173 in VARCHAR2
,P_VAL_174 in VARCHAR2
,P_VAL_175 in VARCHAR2
,P_VAL_176 in VARCHAR2
,P_VAL_177 in VARCHAR2
,P_VAL_178 in VARCHAR2
,P_VAL_179 in VARCHAR2
,P_VAL_180 in VARCHAR2
,P_VAL_181 in VARCHAR2
,P_VAL_182 in VARCHAR2
,P_VAL_183 in VARCHAR2
,P_VAL_184 in VARCHAR2
,P_VAL_185 in VARCHAR2
,P_VAL_186 in VARCHAR2
,P_VAL_187 in VARCHAR2
,P_VAL_188 in VARCHAR2
,P_VAL_189 in VARCHAR2
,P_VAL_190 in VARCHAR2
,P_VAL_191 in VARCHAR2
,P_VAL_192 in VARCHAR2
,P_VAL_193 in VARCHAR2
,P_VAL_194 in VARCHAR2
,P_VAL_195 in VARCHAR2
,P_VAL_196 in VARCHAR2
,P_VAL_197 in VARCHAR2
,P_VAL_198 in VARCHAR2
,P_VAL_199 in VARCHAR2
,P_VAL_200 in VARCHAR2
,P_VAL_201 in VARCHAR2
,P_VAL_202 in VARCHAR2
,P_VAL_203 in VARCHAR2
,P_VAL_204 in VARCHAR2
,P_VAL_205 in VARCHAR2
,P_VAL_206 in VARCHAR2
,P_VAL_207 in VARCHAR2
,P_VAL_208 in VARCHAR2
,P_VAL_209 in VARCHAR2
,P_VAL_210 in VARCHAR2
,P_VAL_211 in VARCHAR2
,P_VAL_212 in VARCHAR2
,P_VAL_213 in VARCHAR2
,P_VAL_214 in VARCHAR2
,P_VAL_215 in VARCHAR2
,P_VAL_216 in VARCHAR2
,P_VAL_217 in VARCHAR2
,P_VAL_219 in VARCHAR2
,P_VAL_218 in VARCHAR2
,P_VAL_220 in VARCHAR2
,P_VAL_221 in VARCHAR2
,P_VAL_222 in VARCHAR2
,P_VAL_223 in VARCHAR2
,P_VAL_224 in VARCHAR2
,P_VAL_225 in VARCHAR2
,P_VAL_226 in VARCHAR2
,P_VAL_227 in VARCHAR2
,P_VAL_228 in VARCHAR2
,P_VAL_229 in VARCHAR2
,P_VAL_230 in VARCHAR2
,P_VAL_231 in VARCHAR2
,P_VAL_232 in VARCHAR2
,P_VAL_233 in VARCHAR2
,P_VAL_234 in VARCHAR2
,P_VAL_235 in VARCHAR2
,P_VAL_236 in VARCHAR2
,P_VAL_237 in VARCHAR2
,P_VAL_238 in VARCHAR2
,P_VAL_239 in VARCHAR2
,P_VAL_240 in VARCHAR2
,P_VAL_241 in VARCHAR2
,P_VAL_242 in VARCHAR2
,P_VAL_243 in VARCHAR2
,P_VAL_244 in VARCHAR2
,P_VAL_245 in VARCHAR2
,P_VAL_246 in VARCHAR2
,P_VAL_247 in VARCHAR2
,P_VAL_248 in VARCHAR2
,P_VAL_249 in VARCHAR2
,P_VAL_250 in VARCHAR2
,P_VAL_251 in VARCHAR2
,P_VAL_252 in VARCHAR2
,P_VAL_253 in VARCHAR2
,P_VAL_254 in VARCHAR2
,P_VAL_255 in VARCHAR2
,P_VAL_256 in VARCHAR2
,P_VAL_257 in VARCHAR2
,P_VAL_258 in VARCHAR2
,P_VAL_259 in VARCHAR2
,P_VAL_260 in VARCHAR2
,P_VAL_261 in VARCHAR2
,P_VAL_262 in VARCHAR2
,P_VAL_263 in VARCHAR2
,P_VAL_264 in VARCHAR2
,P_VAL_265 in VARCHAR2
,P_VAL_266 in VARCHAR2
,P_VAL_267 in VARCHAR2
,P_VAL_268 in VARCHAR2
,P_VAL_269 in VARCHAR2
,P_VAL_270 in VARCHAR2
,P_VAL_271 in VARCHAR2
,P_VAL_272 in VARCHAR2
,P_VAL_273 in VARCHAR2
,P_VAL_274 in VARCHAR2
,P_VAL_275 in VARCHAR2
,P_VAL_276 in VARCHAR2
,P_VAL_277 in VARCHAR2
,P_VAL_278 in VARCHAR2
,P_VAL_279 in VARCHAR2
,P_VAL_280 in VARCHAR2
,P_VAL_281 in VARCHAR2
,P_VAL_282 in VARCHAR2
,P_VAL_283 in VARCHAR2
,P_VAL_284 in VARCHAR2
,P_VAL_285 in VARCHAR2
,P_VAL_286 in VARCHAR2
,P_VAL_287 in VARCHAR2
,P_VAL_288 in VARCHAR2
,P_VAL_289 in VARCHAR2
,P_VAL_290 in VARCHAR2
,P_VAL_291 in VARCHAR2
,P_VAL_292 in VARCHAR2
,P_VAL_293 in VARCHAR2
,P_VAL_294 in VARCHAR2
,P_VAL_295 in VARCHAR2
,P_VAL_296 in VARCHAR2
,P_VAL_297 in VARCHAR2
,P_VAL_298 in VARCHAR2
,P_VAL_299 in VARCHAR2
,P_VAL_300 in VARCHAR2
,P_GROUP_VAL_01 in VARCHAR2
,P_GROUP_VAL_02 in VARCHAR2
,P_PROGRAM_APPLICATION_ID in NUMBER
,P_PROGRAM_ID in NUMBER
,P_PROGRAM_UPDATE_DATE in DATE
,P_REQUEST_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EXT_RCD_IN_FILE_ID in NUMBER
)is
begin
hr_utility.set_location('Entering: BEN_EXT_RSLT_DTL_BK2.UPDATE_EXT_RSLT_DTL_B', 10);
Line: 653

hr_utility.set_location(' Leaving: BEN_EXT_RSLT_DTL_BK2.UPDATE_EXT_RSLT_DTL_B', 20);
Line: 654

end UPDATE_EXT_RSLT_DTL_B;