222: ,aei_information27
223: ,aei_information28
224: ,aei_information29
225: ,aei_information30
226: FROM per_assignment_extra_info
227: WHERE assignment_extra_info_id = p_assignment_extra_info_id;
228:
229: l_procedure VARCHAR2(100);
230: l_message_name VARCHAR2(255);
227: WHERE assignment_extra_info_id = p_assignment_extra_info_id;
228:
229: l_procedure VARCHAR2(100);
230: l_message_name VARCHAR2(255);
231: l_assignment_id per_assignment_extra_info.assignment_id%type;
232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
228:
229: l_procedure VARCHAR2(100);
230: l_message_name VARCHAR2(255);
231: l_assignment_id per_assignment_extra_info.assignment_id%type;
232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
229: l_procedure VARCHAR2(100);
230: l_message_name VARCHAR2(255);
231: l_assignment_id per_assignment_extra_info.assignment_id%type;
232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
230: l_message_name VARCHAR2(255);
231: l_assignment_id per_assignment_extra_info.assignment_id%type;
232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
231: l_assignment_id per_assignment_extra_info.assignment_id%type;
232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;
261: l_aei_information30 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;
261: l_aei_information30 per_assignment_extra_info.aei_information1%type;
262: BEGIN
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;
261: l_aei_information30 per_assignment_extra_info.aei_information1%type;
262: BEGIN
263:
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;
261: l_aei_information30 per_assignment_extra_info.aei_information1%type;
262: BEGIN
263:
264:
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;
261: l_aei_information30 per_assignment_extra_info.aei_information1%type;
262: BEGIN
263:
264:
265: l_procedure := g_package ||'check_asg_extra_info_update';
513: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type) IS
514: CURSOR cur_check_unique_record_ins
515: IS
516: SELECT 1
517: FROM PER_ASSIGNMENT_EXTRA_INFO
518: WHERE assignment_id = p_assignment_id
519: AND aei_information1 = p_aei_information1
520: AND aei_information2 = p_aei_information2
521: AND aei_information_category = p_aei_information_category;
522:
523: CURSOR cur_check_unique_record_upd
524: IS
525: SELECT 1
526: FROM PER_ASSIGNMENT_EXTRA_INFO
527: WHERE aei_information1 = p_aei_information1
528: AND aei_information2 = p_aei_information2
529: AND aei_information_category = p_aei_information_category
530: AND assignment_id = p_assignment_id