APPS.PAY_PRT_SHD dependencies on HR_API

Line 168: hr_api.mandatory_arg_error(p_api_name => l_proc,

164: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
165: --
166: -- Ensure that all the mandatory arguments are not null
167: --
168: hr_api.mandatory_arg_error(p_api_name => l_proc,
169: p_argument => 'p_effective_date',
170: p_argument_value => p_effective_date);
171:
172: If (p_effective_date < Hr_Api.g_sot) then

Line 172: If (p_effective_date < Hr_Api.g_sot) then

168: hr_api.mandatory_arg_error(p_api_name => l_proc,
169: p_argument => 'p_effective_date',
170: p_argument_value => p_effective_date);
171:
172: If (p_effective_date < Hr_Api.g_sot) then
173: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
174: hr_utility.set_message_token('PROCEDURE', l_proc);
175: hr_utility.set_message_token('STEP','10');
176: hr_utility.raise_error;

Line 276: hr_api.mandatory_arg_error(p_api_name => l_proc,

272: --
273: BEGIN
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: -- Ensure that all the mandatory arguments are not null
276: hr_api.mandatory_arg_error(p_api_name => l_proc,
277: p_argument => 'p_base_table_name',
278: p_argument_value => p_base_table_name);
279: hr_api.mandatory_arg_error(p_api_name => l_proc,
280: p_argument => 'p_base_key_column',

Line 279: hr_api.mandatory_arg_error(p_api_name => l_proc,

275: -- Ensure that all the mandatory arguments are not null
276: hr_api.mandatory_arg_error(p_api_name => l_proc,
277: p_argument => 'p_base_table_name',
278: p_argument_value => p_base_table_name);
279: hr_api.mandatory_arg_error(p_api_name => l_proc,
280: p_argument => 'p_base_key_column',
281: p_argument_value => p_base_key_column);
282: hr_api.mandatory_arg_error(p_api_name => l_proc,
283: p_argument => 'p_base_key_value',

Line 282: hr_api.mandatory_arg_error(p_api_name => l_proc,

278: p_argument_value => p_base_table_name);
279: hr_api.mandatory_arg_error(p_api_name => l_proc,
280: p_argument => 'p_base_key_column',
281: p_argument_value => p_base_key_column);
282: hr_api.mandatory_arg_error(p_api_name => l_proc,
283: p_argument => 'p_base_key_value',
284: p_argument_value => p_base_key_value);
285: -- [ end of change 30.14 ]
286: -- Define dynamic sql text with substitution tokens

Line 412: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

408: --
409: -- ----------------------------------------------------------------------------
410: Function Return_Min_Parent_End_Date
411: (p_effective_date in date,
412: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
413: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
414: p_parent_key_value1 in number default hr_api.g_number)
415: /*
416: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

Line 413: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

409: -- ----------------------------------------------------------------------------
410: Function Return_Min_Parent_End_Date
411: (p_effective_date in date,
412: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
413: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
414: p_parent_key_value1 in number default hr_api.g_number)
415: /*
416: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
417: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

Line 414: p_parent_key_value1 in number default hr_api.g_number)

410: Function Return_Min_Parent_End_Date
411: (p_effective_date in date,
412: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
413: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
414: p_parent_key_value1 in number default hr_api.g_number)
415: /*
416: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
417: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
418: p_parent_key_value2 in number default hr_api.g_number,

Line 416: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

412: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
413: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
414: p_parent_key_value1 in number default hr_api.g_number)
415: /*
416: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
417: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
418: p_parent_key_value2 in number default hr_api.g_number,
419: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
420: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

Line 417: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

413: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
414: p_parent_key_value1 in number default hr_api.g_number)
415: /*
416: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
417: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
418: p_parent_key_value2 in number default hr_api.g_number,
419: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
420: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
421: p_parent_key_value3 in number default hr_api.g_number,

Line 418: p_parent_key_value2 in number default hr_api.g_number,

414: p_parent_key_value1 in number default hr_api.g_number)
415: /*
416: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
417: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
418: p_parent_key_value2 in number default hr_api.g_number,
419: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
420: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
421: p_parent_key_value3 in number default hr_api.g_number,
422: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

Line 419: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,

415: /*
416: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
417: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
418: p_parent_key_value2 in number default hr_api.g_number,
419: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
420: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
421: p_parent_key_value3 in number default hr_api.g_number,
422: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
423: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

Line 420: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

416: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
417: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
418: p_parent_key_value2 in number default hr_api.g_number,
419: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
420: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
421: p_parent_key_value3 in number default hr_api.g_number,
422: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
423: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
424: p_parent_key_value4 in number default hr_api.g_number,

Line 421: p_parent_key_value3 in number default hr_api.g_number,

417: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
418: p_parent_key_value2 in number default hr_api.g_number,
419: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
420: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
421: p_parent_key_value3 in number default hr_api.g_number,
422: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
423: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
424: p_parent_key_value4 in number default hr_api.g_number,
425: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

Line 422: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

418: p_parent_key_value2 in number default hr_api.g_number,
419: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
420: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
421: p_parent_key_value3 in number default hr_api.g_number,
422: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
423: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
424: p_parent_key_value4 in number default hr_api.g_number,
425: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
426: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

Line 423: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

419: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
420: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
421: p_parent_key_value3 in number default hr_api.g_number,
422: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
423: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
424: p_parent_key_value4 in number default hr_api.g_number,
425: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
426: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
427: p_parent_key_value5 in number default hr_api.g_number,

Line 424: p_parent_key_value4 in number default hr_api.g_number,

420: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
421: p_parent_key_value3 in number default hr_api.g_number,
422: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
423: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
424: p_parent_key_value4 in number default hr_api.g_number,
425: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
426: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
427: p_parent_key_value5 in number default hr_api.g_number,
428: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

Line 425: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

421: p_parent_key_value3 in number default hr_api.g_number,
422: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
423: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
424: p_parent_key_value4 in number default hr_api.g_number,
425: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
426: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
427: p_parent_key_value5 in number default hr_api.g_number,
428: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
429: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

Line 426: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

422: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
423: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
424: p_parent_key_value4 in number default hr_api.g_number,
425: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
426: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
427: p_parent_key_value5 in number default hr_api.g_number,
428: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
429: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
430: p_parent_key_value6 in number default hr_api.g_number,

Line 427: p_parent_key_value5 in number default hr_api.g_number,

423: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
424: p_parent_key_value4 in number default hr_api.g_number,
425: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
426: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
427: p_parent_key_value5 in number default hr_api.g_number,
428: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
429: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
430: p_parent_key_value6 in number default hr_api.g_number,
431: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

Line 428: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

424: p_parent_key_value4 in number default hr_api.g_number,
425: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
426: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
427: p_parent_key_value5 in number default hr_api.g_number,
428: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
429: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
430: p_parent_key_value6 in number default hr_api.g_number,
431: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
432: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

Line 429: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

425: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
426: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
427: p_parent_key_value5 in number default hr_api.g_number,
428: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
429: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
430: p_parent_key_value6 in number default hr_api.g_number,
431: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
432: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
433: p_parent_key_value7 in number default hr_api.g_number,

Line 430: p_parent_key_value6 in number default hr_api.g_number,

426: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
427: p_parent_key_value5 in number default hr_api.g_number,
428: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
429: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
430: p_parent_key_value6 in number default hr_api.g_number,
431: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
432: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
433: p_parent_key_value7 in number default hr_api.g_number,
434: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

Line 431: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

427: p_parent_key_value5 in number default hr_api.g_number,
428: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
429: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
430: p_parent_key_value6 in number default hr_api.g_number,
431: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
432: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
433: p_parent_key_value7 in number default hr_api.g_number,
434: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
435: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

Line 432: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

428: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
429: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
430: p_parent_key_value6 in number default hr_api.g_number,
431: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
432: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
433: p_parent_key_value7 in number default hr_api.g_number,
434: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
435: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_value8 in number default hr_api.g_number,

Line 433: p_parent_key_value7 in number default hr_api.g_number,

429: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
430: p_parent_key_value6 in number default hr_api.g_number,
431: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
432: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
433: p_parent_key_value7 in number default hr_api.g_number,
434: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
435: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_value8 in number default hr_api.g_number,
437: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

Line 434: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

430: p_parent_key_value6 in number default hr_api.g_number,
431: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
432: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
433: p_parent_key_value7 in number default hr_api.g_number,
434: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
435: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_value8 in number default hr_api.g_number,
437: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
438: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

Line 435: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

431: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
432: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
433: p_parent_key_value7 in number default hr_api.g_number,
434: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
435: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_value8 in number default hr_api.g_number,
437: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
438: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
439: p_parent_key_value9 in number default hr_api.g_number,

Line 436: p_parent_key_value8 in number default hr_api.g_number,

432: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
433: p_parent_key_value7 in number default hr_api.g_number,
434: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
435: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_value8 in number default hr_api.g_number,
437: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
438: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
439: p_parent_key_value9 in number default hr_api.g_number,
440: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

Line 437: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

433: p_parent_key_value7 in number default hr_api.g_number,
434: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
435: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_value8 in number default hr_api.g_number,
437: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
438: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
439: p_parent_key_value9 in number default hr_api.g_number,
440: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

Line 438: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

434: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
435: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_value8 in number default hr_api.g_number,
437: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
438: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
439: p_parent_key_value9 in number default hr_api.g_number,
440: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
442: p_parent_key_value10 in number default hr_api.g_number)

Line 439: p_parent_key_value9 in number default hr_api.g_number,

435: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_value8 in number default hr_api.g_number,
437: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
438: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
439: p_parent_key_value9 in number default hr_api.g_number,
440: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
442: p_parent_key_value10 in number default hr_api.g_number)
443: */

Line 440: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

436: p_parent_key_value8 in number default hr_api.g_number,
437: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
438: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
439: p_parent_key_value9 in number default hr_api.g_number,
440: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
442: p_parent_key_value10 in number default hr_api.g_number)
443: */
444: Return Date Is

Line 441: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

437: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
438: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
439: p_parent_key_value9 in number default hr_api.g_number,
440: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
442: p_parent_key_value10 in number default hr_api.g_number)
443: */
444: Return Date Is
445: --

Line 442: p_parent_key_value10 in number default hr_api.g_number)

438: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
439: p_parent_key_value9 in number default hr_api.g_number,
440: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
442: p_parent_key_value10 in number default hr_api.g_number)
443: */
444: Return Date Is
445: --
446: l_proc varchar2(72) := g_package||

Line 449: l_min_date date := hr_api.g_eot; -- End Of Time

445: --
446: l_proc varchar2(72) := g_package||
447: 'Return_Min_Parent_End_Date';
448: --
449: l_min_date date := hr_api.g_eot; -- End Of Time
450: l_counter integer; -- Loop counter
451: l_temp_date date;
452: --
453: l_parent_table_name varchar2(30);

Line 512: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =

508: */
509: --
510: -- Ensure that all the working parental details have been specified
511: --
512: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
513: hr_api.g_varchar2) or
514: (nvl(l_parent_key_column, hr_api.g_varchar2) =
515: hr_api.g_varchar2) or
516: (nvl(l_parent_key_value, hr_api.g_number) =

Line 513: hr_api.g_varchar2) or

509: --
510: -- Ensure that all the working parental details have been specified
511: --
512: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
513: hr_api.g_varchar2) or
514: (nvl(l_parent_key_column, hr_api.g_varchar2) =
515: hr_api.g_varchar2) or
516: (nvl(l_parent_key_value, hr_api.g_number) =
517: hr_api.g_number)) then

Line 514: (nvl(l_parent_key_column, hr_api.g_varchar2) =

510: -- Ensure that all the working parental details have been specified
511: --
512: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
513: hr_api.g_varchar2) or
514: (nvl(l_parent_key_column, hr_api.g_varchar2) =
515: hr_api.g_varchar2) or
516: (nvl(l_parent_key_value, hr_api.g_number) =
517: hr_api.g_number)) then
518: --

Line 515: hr_api.g_varchar2) or

511: --
512: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
513: hr_api.g_varchar2) or
514: (nvl(l_parent_key_column, hr_api.g_varchar2) =
515: hr_api.g_varchar2) or
516: (nvl(l_parent_key_value, hr_api.g_number) =
517: hr_api.g_number)) then
518: --
519: -- All the parental arguments have been specified therefore we must get

Line 516: (nvl(l_parent_key_value, hr_api.g_number) =

512: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
513: hr_api.g_varchar2) or
514: (nvl(l_parent_key_column, hr_api.g_varchar2) =
515: hr_api.g_varchar2) or
516: (nvl(l_parent_key_value, hr_api.g_number) =
517: hr_api.g_number)) then
518: --
519: -- All the parental arguments have been specified therefore we must get
520: -- the maximum effective end date for the given parent.

Line 517: hr_api.g_number)) then

513: hr_api.g_varchar2) or
514: (nvl(l_parent_key_column, hr_api.g_varchar2) =
515: hr_api.g_varchar2) or
516: (nvl(l_parent_key_value, hr_api.g_number) =
517: hr_api.g_number)) then
518: --
519: -- All the parental arguments have been specified therefore we must get
520: -- the maximum effective end date for the given parent.
521: --

Line 566: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

562: --
563: -- ----------------------------------------------------------------------------
564: Function Return_Min_Parent_Start_Date
565: (p_effective_date in date,
566: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
567: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
568: p_parent_key_value1 in number default hr_api.g_number)
569: /*
570: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

Line 567: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

563: -- ----------------------------------------------------------------------------
564: Function Return_Min_Parent_Start_Date
565: (p_effective_date in date,
566: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
567: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
568: p_parent_key_value1 in number default hr_api.g_number)
569: /*
570: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
571: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

Line 568: p_parent_key_value1 in number default hr_api.g_number)

564: Function Return_Min_Parent_Start_Date
565: (p_effective_date in date,
566: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
567: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
568: p_parent_key_value1 in number default hr_api.g_number)
569: /*
570: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
571: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
572: p_parent_key_value2 in number default hr_api.g_number,

Line 570: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

566: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
567: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
568: p_parent_key_value1 in number default hr_api.g_number)
569: /*
570: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
571: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
572: p_parent_key_value2 in number default hr_api.g_number,
573: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
574: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

Line 571: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

567: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
568: p_parent_key_value1 in number default hr_api.g_number)
569: /*
570: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
571: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
572: p_parent_key_value2 in number default hr_api.g_number,
573: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
574: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
575: p_parent_key_value3 in number default hr_api.g_number,

Line 572: p_parent_key_value2 in number default hr_api.g_number,

568: p_parent_key_value1 in number default hr_api.g_number)
569: /*
570: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
571: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
572: p_parent_key_value2 in number default hr_api.g_number,
573: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
574: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
575: p_parent_key_value3 in number default hr_api.g_number,
576: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

Line 573: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,

569: /*
570: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
571: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
572: p_parent_key_value2 in number default hr_api.g_number,
573: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
574: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
575: p_parent_key_value3 in number default hr_api.g_number,
576: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
577: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

Line 574: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

570: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
571: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
572: p_parent_key_value2 in number default hr_api.g_number,
573: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
574: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
575: p_parent_key_value3 in number default hr_api.g_number,
576: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
577: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
578: p_parent_key_value4 in number default hr_api.g_number,

Line 575: p_parent_key_value3 in number default hr_api.g_number,

571: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
572: p_parent_key_value2 in number default hr_api.g_number,
573: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
574: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
575: p_parent_key_value3 in number default hr_api.g_number,
576: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
577: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
578: p_parent_key_value4 in number default hr_api.g_number,
579: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

Line 576: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

572: p_parent_key_value2 in number default hr_api.g_number,
573: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
574: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
575: p_parent_key_value3 in number default hr_api.g_number,
576: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
577: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
578: p_parent_key_value4 in number default hr_api.g_number,
579: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
580: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

Line 577: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

573: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
574: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
575: p_parent_key_value3 in number default hr_api.g_number,
576: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
577: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
578: p_parent_key_value4 in number default hr_api.g_number,
579: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
580: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
581: p_parent_key_value5 in number default hr_api.g_number,

Line 578: p_parent_key_value4 in number default hr_api.g_number,

574: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
575: p_parent_key_value3 in number default hr_api.g_number,
576: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
577: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
578: p_parent_key_value4 in number default hr_api.g_number,
579: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
580: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
581: p_parent_key_value5 in number default hr_api.g_number,
582: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

Line 579: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

575: p_parent_key_value3 in number default hr_api.g_number,
576: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
577: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
578: p_parent_key_value4 in number default hr_api.g_number,
579: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
580: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
581: p_parent_key_value5 in number default hr_api.g_number,
582: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
583: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

Line 580: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

576: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
577: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
578: p_parent_key_value4 in number default hr_api.g_number,
579: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
580: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
581: p_parent_key_value5 in number default hr_api.g_number,
582: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
583: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
584: p_parent_key_value6 in number default hr_api.g_number,

Line 581: p_parent_key_value5 in number default hr_api.g_number,

577: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
578: p_parent_key_value4 in number default hr_api.g_number,
579: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
580: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
581: p_parent_key_value5 in number default hr_api.g_number,
582: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
583: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
584: p_parent_key_value6 in number default hr_api.g_number,
585: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

Line 582: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

578: p_parent_key_value4 in number default hr_api.g_number,
579: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
580: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
581: p_parent_key_value5 in number default hr_api.g_number,
582: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
583: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
584: p_parent_key_value6 in number default hr_api.g_number,
585: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
586: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

Line 583: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

579: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
580: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
581: p_parent_key_value5 in number default hr_api.g_number,
582: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
583: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
584: p_parent_key_value6 in number default hr_api.g_number,
585: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
586: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
587: p_parent_key_value7 in number default hr_api.g_number,

Line 584: p_parent_key_value6 in number default hr_api.g_number,

580: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
581: p_parent_key_value5 in number default hr_api.g_number,
582: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
583: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
584: p_parent_key_value6 in number default hr_api.g_number,
585: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
586: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
587: p_parent_key_value7 in number default hr_api.g_number,
588: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

Line 585: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

581: p_parent_key_value5 in number default hr_api.g_number,
582: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
583: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
584: p_parent_key_value6 in number default hr_api.g_number,
585: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
586: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
587: p_parent_key_value7 in number default hr_api.g_number,
588: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
589: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

Line 586: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

582: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
583: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
584: p_parent_key_value6 in number default hr_api.g_number,
585: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
586: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
587: p_parent_key_value7 in number default hr_api.g_number,
588: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
589: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_value8 in number default hr_api.g_number,

Line 587: p_parent_key_value7 in number default hr_api.g_number,

583: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
584: p_parent_key_value6 in number default hr_api.g_number,
585: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
586: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
587: p_parent_key_value7 in number default hr_api.g_number,
588: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
589: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_value8 in number default hr_api.g_number,
591: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

Line 588: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

584: p_parent_key_value6 in number default hr_api.g_number,
585: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
586: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
587: p_parent_key_value7 in number default hr_api.g_number,
588: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
589: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_value8 in number default hr_api.g_number,
591: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
592: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

Line 589: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

585: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
586: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
587: p_parent_key_value7 in number default hr_api.g_number,
588: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
589: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_value8 in number default hr_api.g_number,
591: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
592: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
593: p_parent_key_value9 in number default hr_api.g_number,

Line 590: p_parent_key_value8 in number default hr_api.g_number,

586: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
587: p_parent_key_value7 in number default hr_api.g_number,
588: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
589: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_value8 in number default hr_api.g_number,
591: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
592: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
593: p_parent_key_value9 in number default hr_api.g_number,
594: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

Line 591: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

587: p_parent_key_value7 in number default hr_api.g_number,
588: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
589: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_value8 in number default hr_api.g_number,
591: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
592: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
593: p_parent_key_value9 in number default hr_api.g_number,
594: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

Line 592: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

588: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
589: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_value8 in number default hr_api.g_number,
591: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
592: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
593: p_parent_key_value9 in number default hr_api.g_number,
594: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
596: p_parent_key_value10 in number default hr_api.g_number)

Line 593: p_parent_key_value9 in number default hr_api.g_number,

589: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_value8 in number default hr_api.g_number,
591: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
592: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
593: p_parent_key_value9 in number default hr_api.g_number,
594: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
596: p_parent_key_value10 in number default hr_api.g_number)
597: */

Line 594: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

590: p_parent_key_value8 in number default hr_api.g_number,
591: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
592: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
593: p_parent_key_value9 in number default hr_api.g_number,
594: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
596: p_parent_key_value10 in number default hr_api.g_number)
597: */
598: Return Date Is

Line 595: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

591: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
592: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
593: p_parent_key_value9 in number default hr_api.g_number,
594: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
596: p_parent_key_value10 in number default hr_api.g_number)
597: */
598: Return Date Is
599: --

Line 596: p_parent_key_value10 in number default hr_api.g_number)

592: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
593: p_parent_key_value9 in number default hr_api.g_number,
594: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
596: p_parent_key_value10 in number default hr_api.g_number)
597: */
598: Return Date Is
599: --
600: l_proc varchar2(72) := g_package||

Line 603: l_min_date date := hr_api.g_sot; -- Start Of Time

599: --
600: l_proc varchar2(72) := g_package||
601: 'Return_Min_Parent_Start_Date';
602: --
603: l_min_date date := hr_api.g_sot; -- Start Of Time
604: l_counter integer; -- Loop counter
605: l_temp_date date;
606: --
607: l_parent_table_name varchar2(30);

Line 668: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =

664: */
665: --
666: -- Ensure that all the working parental details have been specified
667: --
668: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
669: hr_api.g_varchar2) or
670: (nvl(l_parent_key_column, hr_api.g_varchar2) =
671: hr_api.g_varchar2) or
672: (nvl(l_parent_key_value, hr_api.g_number) =

Line 669: hr_api.g_varchar2) or

665: --
666: -- Ensure that all the working parental details have been specified
667: --
668: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
669: hr_api.g_varchar2) or
670: (nvl(l_parent_key_column, hr_api.g_varchar2) =
671: hr_api.g_varchar2) or
672: (nvl(l_parent_key_value, hr_api.g_number) =
673: hr_api.g_number)) then

Line 670: (nvl(l_parent_key_column, hr_api.g_varchar2) =

666: -- Ensure that all the working parental details have been specified
667: --
668: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
669: hr_api.g_varchar2) or
670: (nvl(l_parent_key_column, hr_api.g_varchar2) =
671: hr_api.g_varchar2) or
672: (nvl(l_parent_key_value, hr_api.g_number) =
673: hr_api.g_number)) then
674: --

Line 671: hr_api.g_varchar2) or

667: --
668: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
669: hr_api.g_varchar2) or
670: (nvl(l_parent_key_column, hr_api.g_varchar2) =
671: hr_api.g_varchar2) or
672: (nvl(l_parent_key_value, hr_api.g_number) =
673: hr_api.g_number)) then
674: --
675: -- All the parental arguments have been specified therefore we must get

Line 672: (nvl(l_parent_key_value, hr_api.g_number) =

668: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
669: hr_api.g_varchar2) or
670: (nvl(l_parent_key_column, hr_api.g_varchar2) =
671: hr_api.g_varchar2) or
672: (nvl(l_parent_key_value, hr_api.g_number) =
673: hr_api.g_number)) then
674: --
675: -- All the parental arguments have been specified therefore we must get
676: -- the minimum effective start date for the given parent.

Line 673: hr_api.g_number)) then

669: hr_api.g_varchar2) or
670: (nvl(l_parent_key_column, hr_api.g_varchar2) =
671: hr_api.g_varchar2) or
672: (nvl(l_parent_key_value, hr_api.g_number) =
673: hr_api.g_number)) then
674: --
675: -- All the parental arguments have been specified therefore we must get
676: -- the minimum effective start date for the given parent.
677: --

Line 741: hr_api.mandatory_arg_error(p_api_name => l_proc,

737: -- Ensure that all the required parameters exist
738: -- Note: we don't check the p_key_value argument
739: --
740: -- [ start of change 30.14 ]
741: hr_api.mandatory_arg_error(p_api_name => l_proc,
742: p_argument => 'p_effective_date',
743: p_argument_value => p_effective_date);
744: hr_api.mandatory_arg_error(p_api_name => l_proc,
745: p_argument => 'p_table_name',

Line 744: hr_api.mandatory_arg_error(p_api_name => l_proc,

740: -- [ start of change 30.14 ]
741: hr_api.mandatory_arg_error(p_api_name => l_proc,
742: p_argument => 'p_effective_date',
743: p_argument_value => p_effective_date);
744: hr_api.mandatory_arg_error(p_api_name => l_proc,
745: p_argument => 'p_table_name',
746: p_argument_value => p_table_name);
747: hr_api.mandatory_arg_error(p_api_name => l_proc,
748: p_argument => 'p_key_column',

Line 747: hr_api.mandatory_arg_error(p_api_name => l_proc,

743: p_argument_value => p_effective_date);
744: hr_api.mandatory_arg_error(p_api_name => l_proc,
745: p_argument => 'p_table_name',
746: p_argument_value => p_table_name);
747: hr_api.mandatory_arg_error(p_api_name => l_proc,
748: p_argument => 'p_key_column',
749: p_argument_value => p_key_column);
750: -- [ end of change 30.14 ]
751: -- If the p_key_value is null then we must not

Line 780: WHEN hr_api.object_locked THEN

776: -- therefore a serious integrity problem has ocurred
777: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
778: hr_utility.set_message_token('ARGUMENT', upper(p_key_column));
779: hr_utility.raise_error;
780: WHEN hr_api.object_locked THEN
781: -- The object is locked therefore we need to supply a meaningful
782: -- error message.
783: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
784: hr_utility.set_message_token('TABLE_NAME', p_table_name);

Line 863: hr_api.mandatory_arg_error(p_api_name => l_proc,

859: --
860: -- Ensure that all the required parameters exist
861: -- Note: we don't check the p_parent_key_value argument
862: --
863: hr_api.mandatory_arg_error(p_api_name => l_proc,
864: p_argument => 'p_child_table_name',
865: p_argument_value => p_child_table_name);
866: hr_api.mandatory_arg_error(p_api_name => l_proc,
867: p_argument => 'p_child_key_column',

Line 866: hr_api.mandatory_arg_error(p_api_name => l_proc,

862: --
863: hr_api.mandatory_arg_error(p_api_name => l_proc,
864: p_argument => 'p_child_table_name',
865: p_argument_value => p_child_table_name);
866: hr_api.mandatory_arg_error(p_api_name => l_proc,
867: p_argument => 'p_child_key_column',
868: p_argument_value => p_child_key_column);
869: hr_api.mandatory_arg_error(p_api_name => l_proc,
870: p_argument => 'p_parent_key_column',

Line 869: hr_api.mandatory_arg_error(p_api_name => l_proc,

865: p_argument_value => p_child_table_name);
866: hr_api.mandatory_arg_error(p_api_name => l_proc,
867: p_argument => 'p_child_key_column',
868: p_argument_value => p_child_key_column);
869: hr_api.mandatory_arg_error(p_api_name => l_proc,
870: p_argument => 'p_parent_key_column',
871: p_argument_value => p_parent_key_column);
872: hr_api.mandatory_arg_error(p_api_name => l_proc,
873: p_argument => 'p_validation_start_date',

Line 872: hr_api.mandatory_arg_error(p_api_name => l_proc,

868: p_argument_value => p_child_key_column);
869: hr_api.mandatory_arg_error(p_api_name => l_proc,
870: p_argument => 'p_parent_key_column',
871: p_argument_value => p_parent_key_column);
872: hr_api.mandatory_arg_error(p_api_name => l_proc,
873: p_argument => 'p_validation_start_date',
874: p_argument_value => p_validation_start_date);
875: --
876: -- If the p_parent_key_value is null then we must not

Line 922: WHEN hr_api.object_locked THEN

918: CLOSE l_cursor;
919: hr_utility.set_location(' Leaving:'||l_proc, 35);
920: END IF;
921: EXCEPTION
922: WHEN hr_api.object_locked THEN
923: IF l_cursor%ISOPEN THEN
924: CLOSE l_cursor;
925: END IF;
926: -- The object is locked therefore we need to supply a meaningful

Line 954: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

950: (p_effective_date in date,
951: p_base_table_name in varchar2,
952: p_base_key_column in varchar2,
953: p_base_key_value in number,
954: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
955: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
956: p_parent_key_value1 in number default hr_api.g_number,
957: /*
958: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

Line 955: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

951: p_base_table_name in varchar2,
952: p_base_key_column in varchar2,
953: p_base_key_value in number,
954: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
955: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
956: p_parent_key_value1 in number default hr_api.g_number,
957: /*
958: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
959: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

Line 956: p_parent_key_value1 in number default hr_api.g_number,

952: p_base_key_column in varchar2,
953: p_base_key_value in number,
954: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
955: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
956: p_parent_key_value1 in number default hr_api.g_number,
957: /*
958: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
959: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
960: p_parent_key_value2 in number default hr_api.g_number,

Line 958: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

954: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
955: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
956: p_parent_key_value1 in number default hr_api.g_number,
957: /*
958: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
959: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
960: p_parent_key_value2 in number default hr_api.g_number,
961: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
962: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

Line 959: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

955: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
956: p_parent_key_value1 in number default hr_api.g_number,
957: /*
958: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
959: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
960: p_parent_key_value2 in number default hr_api.g_number,
961: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
962: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
963: p_parent_key_value3 in number default hr_api.g_number,

Line 960: p_parent_key_value2 in number default hr_api.g_number,

956: p_parent_key_value1 in number default hr_api.g_number,
957: /*
958: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
959: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
960: p_parent_key_value2 in number default hr_api.g_number,
961: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
962: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
963: p_parent_key_value3 in number default hr_api.g_number,
964: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

Line 961: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,

957: /*
958: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
959: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
960: p_parent_key_value2 in number default hr_api.g_number,
961: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
962: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
963: p_parent_key_value3 in number default hr_api.g_number,
964: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
965: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

Line 962: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

958: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
959: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
960: p_parent_key_value2 in number default hr_api.g_number,
961: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
962: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
963: p_parent_key_value3 in number default hr_api.g_number,
964: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
965: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
966: p_parent_key_value4 in number default hr_api.g_number,

Line 963: p_parent_key_value3 in number default hr_api.g_number,

959: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
960: p_parent_key_value2 in number default hr_api.g_number,
961: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
962: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
963: p_parent_key_value3 in number default hr_api.g_number,
964: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
965: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
966: p_parent_key_value4 in number default hr_api.g_number,
967: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

Line 964: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

960: p_parent_key_value2 in number default hr_api.g_number,
961: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
962: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
963: p_parent_key_value3 in number default hr_api.g_number,
964: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
965: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
966: p_parent_key_value4 in number default hr_api.g_number,
967: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
968: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

Line 965: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

961: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
962: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
963: p_parent_key_value3 in number default hr_api.g_number,
964: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
965: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
966: p_parent_key_value4 in number default hr_api.g_number,
967: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
968: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
969: p_parent_key_value5 in number default hr_api.g_number,

Line 966: p_parent_key_value4 in number default hr_api.g_number,

962: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
963: p_parent_key_value3 in number default hr_api.g_number,
964: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
965: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
966: p_parent_key_value4 in number default hr_api.g_number,
967: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
968: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
969: p_parent_key_value5 in number default hr_api.g_number,
970: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

Line 967: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

963: p_parent_key_value3 in number default hr_api.g_number,
964: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
965: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
966: p_parent_key_value4 in number default hr_api.g_number,
967: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
968: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
969: p_parent_key_value5 in number default hr_api.g_number,
970: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
971: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

Line 968: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

964: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
965: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
966: p_parent_key_value4 in number default hr_api.g_number,
967: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
968: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
969: p_parent_key_value5 in number default hr_api.g_number,
970: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
971: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
972: p_parent_key_value6 in number default hr_api.g_number,

Line 969: p_parent_key_value5 in number default hr_api.g_number,

965: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
966: p_parent_key_value4 in number default hr_api.g_number,
967: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
968: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
969: p_parent_key_value5 in number default hr_api.g_number,
970: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
971: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
972: p_parent_key_value6 in number default hr_api.g_number,
973: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

Line 970: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

966: p_parent_key_value4 in number default hr_api.g_number,
967: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
968: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
969: p_parent_key_value5 in number default hr_api.g_number,
970: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
971: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
972: p_parent_key_value6 in number default hr_api.g_number,
973: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
974: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

Line 971: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

967: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
968: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
969: p_parent_key_value5 in number default hr_api.g_number,
970: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
971: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
972: p_parent_key_value6 in number default hr_api.g_number,
973: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
974: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
975: p_parent_key_value7 in number default hr_api.g_number,

Line 972: p_parent_key_value6 in number default hr_api.g_number,

968: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
969: p_parent_key_value5 in number default hr_api.g_number,
970: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
971: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
972: p_parent_key_value6 in number default hr_api.g_number,
973: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
974: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
975: p_parent_key_value7 in number default hr_api.g_number,
976: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

Line 973: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

969: p_parent_key_value5 in number default hr_api.g_number,
970: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
971: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
972: p_parent_key_value6 in number default hr_api.g_number,
973: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
974: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
975: p_parent_key_value7 in number default hr_api.g_number,
976: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
977: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

Line 974: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

970: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
971: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
972: p_parent_key_value6 in number default hr_api.g_number,
973: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
974: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
975: p_parent_key_value7 in number default hr_api.g_number,
976: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
977: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_value8 in number default hr_api.g_number,

Line 975: p_parent_key_value7 in number default hr_api.g_number,

971: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
972: p_parent_key_value6 in number default hr_api.g_number,
973: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
974: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
975: p_parent_key_value7 in number default hr_api.g_number,
976: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
977: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_value8 in number default hr_api.g_number,
979: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

Line 976: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

972: p_parent_key_value6 in number default hr_api.g_number,
973: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
974: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
975: p_parent_key_value7 in number default hr_api.g_number,
976: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
977: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_value8 in number default hr_api.g_number,
979: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
980: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

Line 977: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

973: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
974: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
975: p_parent_key_value7 in number default hr_api.g_number,
976: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
977: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_value8 in number default hr_api.g_number,
979: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
980: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
981: p_parent_key_value9 in number default hr_api.g_number,

Line 978: p_parent_key_value8 in number default hr_api.g_number,

974: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
975: p_parent_key_value7 in number default hr_api.g_number,
976: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
977: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_value8 in number default hr_api.g_number,
979: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
980: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
981: p_parent_key_value9 in number default hr_api.g_number,
982: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

Line 979: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

975: p_parent_key_value7 in number default hr_api.g_number,
976: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
977: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_value8 in number default hr_api.g_number,
979: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
980: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
981: p_parent_key_value9 in number default hr_api.g_number,
982: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

Line 980: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

976: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
977: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_value8 in number default hr_api.g_number,
979: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
980: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
981: p_parent_key_value9 in number default hr_api.g_number,
982: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
984: p_parent_key_value10 in number default hr_api.g_number,

Line 981: p_parent_key_value9 in number default hr_api.g_number,

977: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_value8 in number default hr_api.g_number,
979: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
980: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
981: p_parent_key_value9 in number default hr_api.g_number,
982: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
984: p_parent_key_value10 in number default hr_api.g_number,
985: */

Line 982: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

978: p_parent_key_value8 in number default hr_api.g_number,
979: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
980: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
981: p_parent_key_value9 in number default hr_api.g_number,
982: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
984: p_parent_key_value10 in number default hr_api.g_number,
985: */
986: p_enforce_foreign_locking in boolean,

Line 983: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

979: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
980: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
981: p_parent_key_value9 in number default hr_api.g_number,
982: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
984: p_parent_key_value10 in number default hr_api.g_number,
985: */
986: p_enforce_foreign_locking in boolean,
987: p_validation_start_date out nocopy date,

Line 984: p_parent_key_value10 in number default hr_api.g_number,

980: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
981: p_parent_key_value9 in number default hr_api.g_number,
982: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
984: p_parent_key_value10 in number default hr_api.g_number,
985: */
986: p_enforce_foreign_locking in boolean,
987: p_validation_start_date out nocopy date,
988: p_validation_end_date out nocopy date) Is

Line 1056: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =

1052: */
1053: --
1054: -- Ensure that all the working parental details have been specified
1055: --
1056: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
1057: hr_api.g_varchar2) or
1058: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1059: hr_api.g_varchar2) or
1060: (nvl(l_parent_key_value, hr_api.g_number) =

Line 1057: hr_api.g_varchar2) or

1053: --
1054: -- Ensure that all the working parental details have been specified
1055: --
1056: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
1057: hr_api.g_varchar2) or
1058: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1059: hr_api.g_varchar2) or
1060: (nvl(l_parent_key_value, hr_api.g_number) =
1061: hr_api.g_number)) then

Line 1058: (nvl(l_parent_key_column, hr_api.g_varchar2) =

1054: -- Ensure that all the working parental details have been specified
1055: --
1056: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
1057: hr_api.g_varchar2) or
1058: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1059: hr_api.g_varchar2) or
1060: (nvl(l_parent_key_value, hr_api.g_number) =
1061: hr_api.g_number)) then
1062: --

Line 1059: hr_api.g_varchar2) or

1055: --
1056: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
1057: hr_api.g_varchar2) or
1058: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1059: hr_api.g_varchar2) or
1060: (nvl(l_parent_key_value, hr_api.g_number) =
1061: hr_api.g_number)) then
1062: --
1063: -- All the parental arguments have been specified therefore we must

Line 1060: (nvl(l_parent_key_value, hr_api.g_number) =

1056: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
1057: hr_api.g_varchar2) or
1058: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1059: hr_api.g_varchar2) or
1060: (nvl(l_parent_key_value, hr_api.g_number) =
1061: hr_api.g_number)) then
1062: --
1063: -- All the parental arguments have been specified therefore we must
1064: -- attempt to lock the specified parent rows.

Line 1061: hr_api.g_number)) then

1057: hr_api.g_varchar2) or
1058: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1059: hr_api.g_varchar2) or
1060: (nvl(l_parent_key_value, hr_api.g_number) =
1061: hr_api.g_number)) then
1062: --
1063: -- All the parental arguments have been specified therefore we must
1064: -- attempt to lock the specified parent rows.
1065: --

Line 1433: p_child_table_name1 in varchar2 default hr_api.g_varchar2,

1429: (p_effective_date in date,
1430: p_base_table_name in varchar2,
1431: p_base_key_column in varchar2,
1432: p_base_key_value in number,
1433: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1434: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1435: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1436: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1437: p_child_key_column2 in varchar2 default hr_api.g_varchar2,

Line 1434: p_child_key_column1 in varchar2 default hr_api.g_varchar2,

1430: p_base_table_name in varchar2,
1431: p_base_key_column in varchar2,
1432: p_base_key_value in number,
1433: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1434: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1435: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1436: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1437: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1438: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,

Line 1435: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,

1431: p_base_key_column in varchar2,
1432: p_base_key_value in number,
1433: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1434: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1435: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1436: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1437: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1438: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1439: p_enforce_foreign_locking in boolean default true,

Line 1436: p_child_table_name2 in varchar2 default hr_api.g_varchar2,

1432: p_base_key_value in number,
1433: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1434: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1435: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1436: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1437: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1438: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1439: p_enforce_foreign_locking in boolean default true,
1440: p_validation_start_date out nocopy date,

Line 1437: p_child_key_column2 in varchar2 default hr_api.g_varchar2,

1433: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1434: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1435: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1436: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1437: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1438: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1439: p_enforce_foreign_locking in boolean default true,
1440: p_validation_start_date out nocopy date,
1441: p_validation_end_date out nocopy date) Is

Line 1438: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,

1434: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1435: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1436: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1437: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1438: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1439: p_enforce_foreign_locking in boolean default true,
1440: p_validation_start_date out nocopy date,
1441: p_validation_end_date out nocopy date) Is
1442: --

Line 1473: If NOT ((nvl(l_child_table_name, hr_api.g_varchar2) =

1469: End If;
1470: --
1471: -- Ensure that all the working child details have been specified
1472: --
1473: If NOT ((nvl(l_child_table_name, hr_api.g_varchar2) =
1474: hr_api.g_varchar2) or
1475: (nvl(l_child_key_column, hr_api.g_varchar2) =
1476: hr_api.g_varchar2)) then
1477: --

Line 1474: hr_api.g_varchar2) or

1470: --
1471: -- Ensure that all the working child details have been specified
1472: --
1473: If NOT ((nvl(l_child_table_name, hr_api.g_varchar2) =
1474: hr_api.g_varchar2) or
1475: (nvl(l_child_key_column, hr_api.g_varchar2) =
1476: hr_api.g_varchar2)) then
1477: --
1478: --

Line 1475: (nvl(l_child_key_column, hr_api.g_varchar2) =

1471: -- Ensure that all the working child details have been specified
1472: --
1473: If NOT ((nvl(l_child_table_name, hr_api.g_varchar2) =
1474: hr_api.g_varchar2) or
1475: (nvl(l_child_key_column, hr_api.g_varchar2) =
1476: hr_api.g_varchar2)) then
1477: --
1478: --
1479: -- All the child arguments have been specified therefore we must lock

Line 1476: hr_api.g_varchar2)) then

1472: --
1473: If NOT ((nvl(l_child_table_name, hr_api.g_varchar2) =
1474: hr_api.g_varchar2) or
1475: (nvl(l_child_key_column, hr_api.g_varchar2) =
1476: hr_api.g_varchar2)) then
1477: --
1478: --
1479: -- All the child arguments have been specified therefore we must lock
1480: -- the child rows (if they exist).

Line 1535: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

1531: (p_effective_date in date,
1532: p_base_table_name in varchar2,
1533: p_base_key_column in varchar2,
1534: p_base_key_value in number,
1535: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1536: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1537: p_parent_key_value1 in number default hr_api.g_number,
1538: /*
1539: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

Line 1536: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

1532: p_base_table_name in varchar2,
1533: p_base_key_column in varchar2,
1534: p_base_key_value in number,
1535: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1536: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1537: p_parent_key_value1 in number default hr_api.g_number,
1538: /*
1539: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1540: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

Line 1537: p_parent_key_value1 in number default hr_api.g_number,

1533: p_base_key_column in varchar2,
1534: p_base_key_value in number,
1535: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1536: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1537: p_parent_key_value1 in number default hr_api.g_number,
1538: /*
1539: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1540: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1541: p_parent_key_value2 in number default hr_api.g_number,

Line 1539: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

1535: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1536: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1537: p_parent_key_value1 in number default hr_api.g_number,
1538: /*
1539: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1540: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1541: p_parent_key_value2 in number default hr_api.g_number,
1542: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1543: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

Line 1540: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

1536: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1537: p_parent_key_value1 in number default hr_api.g_number,
1538: /*
1539: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1540: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1541: p_parent_key_value2 in number default hr_api.g_number,
1542: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1543: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1544: p_parent_key_value3 in number default hr_api.g_number,

Line 1541: p_parent_key_value2 in number default hr_api.g_number,

1537: p_parent_key_value1 in number default hr_api.g_number,
1538: /*
1539: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1540: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1541: p_parent_key_value2 in number default hr_api.g_number,
1542: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1543: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1544: p_parent_key_value3 in number default hr_api.g_number,
1545: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

Line 1542: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,

1538: /*
1539: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1540: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1541: p_parent_key_value2 in number default hr_api.g_number,
1542: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1543: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1544: p_parent_key_value3 in number default hr_api.g_number,
1545: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1546: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

Line 1543: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

1539: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1540: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1541: p_parent_key_value2 in number default hr_api.g_number,
1542: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1543: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1544: p_parent_key_value3 in number default hr_api.g_number,
1545: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1546: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1547: p_parent_key_value4 in number default hr_api.g_number,

Line 1544: p_parent_key_value3 in number default hr_api.g_number,

1540: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1541: p_parent_key_value2 in number default hr_api.g_number,
1542: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1543: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1544: p_parent_key_value3 in number default hr_api.g_number,
1545: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1546: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1547: p_parent_key_value4 in number default hr_api.g_number,
1548: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

Line 1545: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

1541: p_parent_key_value2 in number default hr_api.g_number,
1542: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1543: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1544: p_parent_key_value3 in number default hr_api.g_number,
1545: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1546: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1547: p_parent_key_value4 in number default hr_api.g_number,
1548: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1549: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

Line 1546: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

1542: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1543: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1544: p_parent_key_value3 in number default hr_api.g_number,
1545: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1546: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1547: p_parent_key_value4 in number default hr_api.g_number,
1548: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1549: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1550: p_parent_key_value5 in number default hr_api.g_number,

Line 1547: p_parent_key_value4 in number default hr_api.g_number,

1543: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1544: p_parent_key_value3 in number default hr_api.g_number,
1545: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1546: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1547: p_parent_key_value4 in number default hr_api.g_number,
1548: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1549: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1550: p_parent_key_value5 in number default hr_api.g_number,
1551: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

Line 1548: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

1544: p_parent_key_value3 in number default hr_api.g_number,
1545: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1546: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1547: p_parent_key_value4 in number default hr_api.g_number,
1548: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1549: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1550: p_parent_key_value5 in number default hr_api.g_number,
1551: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1552: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

Line 1549: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

1545: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1546: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1547: p_parent_key_value4 in number default hr_api.g_number,
1548: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1549: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1550: p_parent_key_value5 in number default hr_api.g_number,
1551: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1552: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1553: p_parent_key_value6 in number default hr_api.g_number,

Line 1550: p_parent_key_value5 in number default hr_api.g_number,

1546: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1547: p_parent_key_value4 in number default hr_api.g_number,
1548: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1549: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1550: p_parent_key_value5 in number default hr_api.g_number,
1551: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1552: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1553: p_parent_key_value6 in number default hr_api.g_number,
1554: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

Line 1551: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

1547: p_parent_key_value4 in number default hr_api.g_number,
1548: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1549: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1550: p_parent_key_value5 in number default hr_api.g_number,
1551: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1552: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1553: p_parent_key_value6 in number default hr_api.g_number,
1554: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1555: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

Line 1552: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

1548: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1549: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1550: p_parent_key_value5 in number default hr_api.g_number,
1551: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1552: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1553: p_parent_key_value6 in number default hr_api.g_number,
1554: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1555: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1556: p_parent_key_value7 in number default hr_api.g_number,

Line 1553: p_parent_key_value6 in number default hr_api.g_number,

1549: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1550: p_parent_key_value5 in number default hr_api.g_number,
1551: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1552: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1553: p_parent_key_value6 in number default hr_api.g_number,
1554: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1555: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1556: p_parent_key_value7 in number default hr_api.g_number,
1557: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

Line 1554: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

1550: p_parent_key_value5 in number default hr_api.g_number,
1551: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1552: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1553: p_parent_key_value6 in number default hr_api.g_number,
1554: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1555: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1556: p_parent_key_value7 in number default hr_api.g_number,
1557: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1558: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

Line 1555: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

1551: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1552: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1553: p_parent_key_value6 in number default hr_api.g_number,
1554: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1555: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1556: p_parent_key_value7 in number default hr_api.g_number,
1557: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1558: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_value8 in number default hr_api.g_number,

Line 1556: p_parent_key_value7 in number default hr_api.g_number,

1552: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1553: p_parent_key_value6 in number default hr_api.g_number,
1554: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1555: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1556: p_parent_key_value7 in number default hr_api.g_number,
1557: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1558: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_value8 in number default hr_api.g_number,
1560: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

Line 1557: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

1553: p_parent_key_value6 in number default hr_api.g_number,
1554: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1555: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1556: p_parent_key_value7 in number default hr_api.g_number,
1557: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1558: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_value8 in number default hr_api.g_number,
1560: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1561: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

Line 1558: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

1554: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1555: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1556: p_parent_key_value7 in number default hr_api.g_number,
1557: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1558: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_value8 in number default hr_api.g_number,
1560: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1561: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1562: p_parent_key_value9 in number default hr_api.g_number,

Line 1559: p_parent_key_value8 in number default hr_api.g_number,

1555: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1556: p_parent_key_value7 in number default hr_api.g_number,
1557: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1558: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_value8 in number default hr_api.g_number,
1560: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1561: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1562: p_parent_key_value9 in number default hr_api.g_number,
1563: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

Line 1560: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

1556: p_parent_key_value7 in number default hr_api.g_number,
1557: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1558: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_value8 in number default hr_api.g_number,
1560: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1561: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1562: p_parent_key_value9 in number default hr_api.g_number,
1563: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

Line 1561: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

1557: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1558: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_value8 in number default hr_api.g_number,
1560: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1561: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1562: p_parent_key_value9 in number default hr_api.g_number,
1563: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1565: p_parent_key_value10 in number default hr_api.g_number,

Line 1562: p_parent_key_value9 in number default hr_api.g_number,

1558: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_value8 in number default hr_api.g_number,
1560: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1561: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1562: p_parent_key_value9 in number default hr_api.g_number,
1563: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1565: p_parent_key_value10 in number default hr_api.g_number,
1566: */

Line 1563: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

1559: p_parent_key_value8 in number default hr_api.g_number,
1560: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1561: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1562: p_parent_key_value9 in number default hr_api.g_number,
1563: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1565: p_parent_key_value10 in number default hr_api.g_number,
1566: */
1567: p_validation_start_date out nocopy date,

Line 1564: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

1560: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1561: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1562: p_parent_key_value9 in number default hr_api.g_number,
1563: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1565: p_parent_key_value10 in number default hr_api.g_number,
1566: */
1567: p_validation_start_date out nocopy date,
1568: p_validation_end_date out nocopy date) Is

Line 1565: p_parent_key_value10 in number default hr_api.g_number,

1561: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1562: p_parent_key_value9 in number default hr_api.g_number,
1563: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1565: p_parent_key_value10 in number default hr_api.g_number,
1566: */
1567: p_validation_start_date out nocopy date,
1568: p_validation_end_date out nocopy date) Is
1569: --

Line 1588: If (l_effective_end_date <> HR_Api.g_eot) then

1584: --
1585: -- Providing the current effective end date is not the end of time
1586: -- then we must set the validation dates
1587: --
1588: If (l_effective_end_date <> HR_Api.g_eot) then
1589: --
1590: p_validation_start_date := l_effective_end_date + 1;
1591: l_validation_end_date :=
1592: Return_Min_Parent_End_Date

Line 1665: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

1661: (p_effective_date in date,
1662: p_base_table_name in varchar2,
1663: p_base_key_column in varchar2,
1664: p_base_key_value in number,
1665: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1666: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1667: p_parent_key_value1 in number default hr_api.g_number,
1668: /*
1669: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

Line 1666: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

1662: p_base_table_name in varchar2,
1663: p_base_key_column in varchar2,
1664: p_base_key_value in number,
1665: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1666: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1667: p_parent_key_value1 in number default hr_api.g_number,
1668: /*
1669: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1670: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

Line 1667: p_parent_key_value1 in number default hr_api.g_number,

1663: p_base_key_column in varchar2,
1664: p_base_key_value in number,
1665: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1666: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1667: p_parent_key_value1 in number default hr_api.g_number,
1668: /*
1669: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1670: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1671: p_parent_key_value2 in number default hr_api.g_number,

Line 1669: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

1665: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1666: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1667: p_parent_key_value1 in number default hr_api.g_number,
1668: /*
1669: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1670: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1671: p_parent_key_value2 in number default hr_api.g_number,
1672: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1673: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

Line 1670: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

1666: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1667: p_parent_key_value1 in number default hr_api.g_number,
1668: /*
1669: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1670: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1671: p_parent_key_value2 in number default hr_api.g_number,
1672: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1673: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1674: p_parent_key_value3 in number default hr_api.g_number,

Line 1671: p_parent_key_value2 in number default hr_api.g_number,

1667: p_parent_key_value1 in number default hr_api.g_number,
1668: /*
1669: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1670: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1671: p_parent_key_value2 in number default hr_api.g_number,
1672: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1673: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1674: p_parent_key_value3 in number default hr_api.g_number,
1675: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

Line 1672: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,

1668: /*
1669: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1670: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1671: p_parent_key_value2 in number default hr_api.g_number,
1672: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1673: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1674: p_parent_key_value3 in number default hr_api.g_number,
1675: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1676: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

Line 1673: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

1669: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1670: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1671: p_parent_key_value2 in number default hr_api.g_number,
1672: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1673: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1674: p_parent_key_value3 in number default hr_api.g_number,
1675: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1676: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1677: p_parent_key_value4 in number default hr_api.g_number,

Line 1674: p_parent_key_value3 in number default hr_api.g_number,

1670: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1671: p_parent_key_value2 in number default hr_api.g_number,
1672: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1673: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1674: p_parent_key_value3 in number default hr_api.g_number,
1675: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1676: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1677: p_parent_key_value4 in number default hr_api.g_number,
1678: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

Line 1675: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

1671: p_parent_key_value2 in number default hr_api.g_number,
1672: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1673: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1674: p_parent_key_value3 in number default hr_api.g_number,
1675: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1676: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1677: p_parent_key_value4 in number default hr_api.g_number,
1678: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1679: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

Line 1676: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

1672: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1673: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1674: p_parent_key_value3 in number default hr_api.g_number,
1675: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1676: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1677: p_parent_key_value4 in number default hr_api.g_number,
1678: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1679: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1680: p_parent_key_value5 in number default hr_api.g_number,

Line 1677: p_parent_key_value4 in number default hr_api.g_number,

1673: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1674: p_parent_key_value3 in number default hr_api.g_number,
1675: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1676: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1677: p_parent_key_value4 in number default hr_api.g_number,
1678: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1679: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1680: p_parent_key_value5 in number default hr_api.g_number,
1681: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

Line 1678: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

1674: p_parent_key_value3 in number default hr_api.g_number,
1675: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1676: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1677: p_parent_key_value4 in number default hr_api.g_number,
1678: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1679: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1680: p_parent_key_value5 in number default hr_api.g_number,
1681: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1682: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

Line 1679: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

1675: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1676: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1677: p_parent_key_value4 in number default hr_api.g_number,
1678: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1679: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1680: p_parent_key_value5 in number default hr_api.g_number,
1681: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1682: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1683: p_parent_key_value6 in number default hr_api.g_number,

Line 1680: p_parent_key_value5 in number default hr_api.g_number,

1676: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1677: p_parent_key_value4 in number default hr_api.g_number,
1678: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1679: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1680: p_parent_key_value5 in number default hr_api.g_number,
1681: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1682: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1683: p_parent_key_value6 in number default hr_api.g_number,
1684: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

Line 1681: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

1677: p_parent_key_value4 in number default hr_api.g_number,
1678: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1679: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1680: p_parent_key_value5 in number default hr_api.g_number,
1681: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1682: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1683: p_parent_key_value6 in number default hr_api.g_number,
1684: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1685: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

Line 1682: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

1678: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1679: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1680: p_parent_key_value5 in number default hr_api.g_number,
1681: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1682: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1683: p_parent_key_value6 in number default hr_api.g_number,
1684: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1685: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1686: p_parent_key_value7 in number default hr_api.g_number,

Line 1683: p_parent_key_value6 in number default hr_api.g_number,

1679: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1680: p_parent_key_value5 in number default hr_api.g_number,
1681: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1682: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1683: p_parent_key_value6 in number default hr_api.g_number,
1684: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1685: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1686: p_parent_key_value7 in number default hr_api.g_number,
1687: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

Line 1684: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

1680: p_parent_key_value5 in number default hr_api.g_number,
1681: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1682: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1683: p_parent_key_value6 in number default hr_api.g_number,
1684: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1685: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1686: p_parent_key_value7 in number default hr_api.g_number,
1687: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1688: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

Line 1685: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

1681: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1682: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1683: p_parent_key_value6 in number default hr_api.g_number,
1684: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1685: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1686: p_parent_key_value7 in number default hr_api.g_number,
1687: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1688: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_value8 in number default hr_api.g_number,

Line 1686: p_parent_key_value7 in number default hr_api.g_number,

1682: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1683: p_parent_key_value6 in number default hr_api.g_number,
1684: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1685: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1686: p_parent_key_value7 in number default hr_api.g_number,
1687: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1688: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_value8 in number default hr_api.g_number,
1690: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

Line 1687: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

1683: p_parent_key_value6 in number default hr_api.g_number,
1684: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1685: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1686: p_parent_key_value7 in number default hr_api.g_number,
1687: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1688: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_value8 in number default hr_api.g_number,
1690: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1691: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

Line 1688: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

1684: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1685: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1686: p_parent_key_value7 in number default hr_api.g_number,
1687: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1688: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_value8 in number default hr_api.g_number,
1690: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1691: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1692: p_parent_key_value9 in number default hr_api.g_number,

Line 1689: p_parent_key_value8 in number default hr_api.g_number,

1685: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1686: p_parent_key_value7 in number default hr_api.g_number,
1687: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1688: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_value8 in number default hr_api.g_number,
1690: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1691: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1692: p_parent_key_value9 in number default hr_api.g_number,
1693: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

Line 1690: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

1686: p_parent_key_value7 in number default hr_api.g_number,
1687: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1688: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_value8 in number default hr_api.g_number,
1690: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1691: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1692: p_parent_key_value9 in number default hr_api.g_number,
1693: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

Line 1691: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

1687: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1688: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_value8 in number default hr_api.g_number,
1690: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1691: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1692: p_parent_key_value9 in number default hr_api.g_number,
1693: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1695: p_parent_key_value10 in number default hr_api.g_number,

Line 1692: p_parent_key_value9 in number default hr_api.g_number,

1688: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_value8 in number default hr_api.g_number,
1690: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1691: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1692: p_parent_key_value9 in number default hr_api.g_number,
1693: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1695: p_parent_key_value10 in number default hr_api.g_number,
1696: */

Line 1693: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

1689: p_parent_key_value8 in number default hr_api.g_number,
1690: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1691: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1692: p_parent_key_value9 in number default hr_api.g_number,
1693: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1695: p_parent_key_value10 in number default hr_api.g_number,
1696: */
1697: p_validation_start_date out nocopy date,

Line 1694: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

1690: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1691: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1692: p_parent_key_value9 in number default hr_api.g_number,
1693: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1695: p_parent_key_value10 in number default hr_api.g_number,
1696: */
1697: p_validation_start_date out nocopy date,
1698: p_validation_end_date out nocopy date) Is

Line 1695: p_parent_key_value10 in number default hr_api.g_number,

1691: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1692: p_parent_key_value9 in number default hr_api.g_number,
1693: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1695: p_parent_key_value10 in number default hr_api.g_number,
1696: */
1697: p_validation_start_date out nocopy date,
1698: p_validation_end_date out nocopy date) Is
1699: --

Line 1722: If (l_effective_end_date <> HR_Api.g_eot) then

1718: --
1719: -- Providing the current effective end date is not the end of time
1720: -- then we must set the validation dates
1721: --
1722: If (l_effective_end_date <> HR_Api.g_eot) then
1723: --
1724: l_validation_start_date := l_effective_end_date + 1;
1725: p_validation_start_date := l_validation_start_date;
1726: --

Line 1875: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

1871: p_effective_date in date,
1872: p_base_table_name in varchar2,
1873: p_base_key_column in varchar2,
1874: p_base_key_value in number,
1875: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1876: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1877: p_parent_key_value1 in number default hr_api.g_number,
1878: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1879: p_child_key_column1 in varchar2 default hr_api.g_varchar2,

Line 1876: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

1872: p_base_table_name in varchar2,
1873: p_base_key_column in varchar2,
1874: p_base_key_value in number,
1875: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1876: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1877: p_parent_key_value1 in number default hr_api.g_number,
1878: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1879: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1880: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,

Line 1877: p_parent_key_value1 in number default hr_api.g_number,

1873: p_base_key_column in varchar2,
1874: p_base_key_value in number,
1875: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1876: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1877: p_parent_key_value1 in number default hr_api.g_number,
1878: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1879: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1880: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1881: p_child_table_name2 in varchar2 default hr_api.g_varchar2,

Line 1878: p_child_table_name1 in varchar2 default hr_api.g_varchar2,

1874: p_base_key_value in number,
1875: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1876: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1877: p_parent_key_value1 in number default hr_api.g_number,
1878: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1879: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1880: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1881: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1882: p_child_key_column2 in varchar2 default hr_api.g_varchar2,

Line 1879: p_child_key_column1 in varchar2 default hr_api.g_varchar2,

1875: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1876: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1877: p_parent_key_value1 in number default hr_api.g_number,
1878: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1879: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1880: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1881: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1882: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1883: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,

Line 1880: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,

1876: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1877: p_parent_key_value1 in number default hr_api.g_number,
1878: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1879: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1880: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1881: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1882: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1883: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1884: p_enforce_foreign_locking in boolean default true,

Line 1881: p_child_table_name2 in varchar2 default hr_api.g_varchar2,

1877: p_parent_key_value1 in number default hr_api.g_number,
1878: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1879: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1880: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1881: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1882: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1883: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1884: p_enforce_foreign_locking in boolean default true,
1885: p_validation_start_date out nocopy date,

Line 1882: p_child_key_column2 in varchar2 default hr_api.g_varchar2,

1878: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1879: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1880: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1881: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1882: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1883: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1884: p_enforce_foreign_locking in boolean default true,
1885: p_validation_start_date out nocopy date,
1886: p_validation_end_date out nocopy date) Is

Line 1883: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,

1879: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1880: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1881: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1882: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1883: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1884: p_enforce_foreign_locking in boolean default true,
1885: p_validation_start_date out nocopy date,
1886: p_validation_end_date out nocopy date) Is
1887: --

Line 1899: hr_api.mandatory_arg_error(p_api_name => l_proc,

1895: Effective_Date_Valid(p_effective_date => p_effective_date);
1896: --
1897: -- Ensure that all the mandatory arguments are not null
1898: --
1899: hr_api.mandatory_arg_error(p_api_name => l_proc,
1900: p_argument => 'p_datetrack_mode',
1901: p_argument_value => p_datetrack_mode);
1902: hr_api.mandatory_arg_error(p_api_name => l_proc,
1903: p_argument => 'p_base_table_name',

Line 1902: hr_api.mandatory_arg_error(p_api_name => l_proc,

1898: --
1899: hr_api.mandatory_arg_error(p_api_name => l_proc,
1900: p_argument => 'p_datetrack_mode',
1901: p_argument_value => p_datetrack_mode);
1902: hr_api.mandatory_arg_error(p_api_name => l_proc,
1903: p_argument => 'p_base_table_name',
1904: p_argument_value => p_base_table_name);
1905: hr_api.mandatory_arg_error(p_api_name => l_proc,
1906: p_argument => 'p_base_key_column',

Line 1905: hr_api.mandatory_arg_error(p_api_name => l_proc,

1901: p_argument_value => p_datetrack_mode);
1902: hr_api.mandatory_arg_error(p_api_name => l_proc,
1903: p_argument => 'p_base_table_name',
1904: p_argument_value => p_base_table_name);
1905: hr_api.mandatory_arg_error(p_api_name => l_proc,
1906: p_argument => 'p_base_key_column',
1907: p_argument_value => p_base_key_column);
1908: --
1909: -- Determine if any entity range row locking is required

Line 1911: If (l_datetrack_mode = hr_api.g_update_override or

1907: p_argument_value => p_base_key_column);
1908: --
1909: -- Determine if any entity range row locking is required
1910: --
1911: If (l_datetrack_mode = hr_api.g_update_override or
1912: l_datetrack_mode = hr_api.g_delete or
1913: l_datetrack_mode = hr_api.g_future_change or
1914: l_datetrack_mode = hr_api.g_delete_next_change) then
1915: --

Line 1912: l_datetrack_mode = hr_api.g_delete or

1908: --
1909: -- Determine if any entity range row locking is required
1910: --
1911: If (l_datetrack_mode = hr_api.g_update_override or
1912: l_datetrack_mode = hr_api.g_delete or
1913: l_datetrack_mode = hr_api.g_future_change or
1914: l_datetrack_mode = hr_api.g_delete_next_change) then
1915: --
1916: -- Perform the entity range row locking processing

Line 1913: l_datetrack_mode = hr_api.g_future_change or

1909: -- Determine if any entity range row locking is required
1910: --
1911: If (l_datetrack_mode = hr_api.g_update_override or
1912: l_datetrack_mode = hr_api.g_delete or
1913: l_datetrack_mode = hr_api.g_future_change or
1914: l_datetrack_mode = hr_api.g_delete_next_change) then
1915: --
1916: -- Perform the entity range row locking processing
1917: --

Line 1914: l_datetrack_mode = hr_api.g_delete_next_change) then

1910: --
1911: If (l_datetrack_mode = hr_api.g_update_override or
1912: l_datetrack_mode = hr_api.g_delete or
1913: l_datetrack_mode = hr_api.g_future_change or
1914: l_datetrack_mode = hr_api.g_delete_next_change) then
1915: --
1916: -- Perform the entity range row locking processing
1917: --
1918: Lck_Future_Rows

Line 1924: ElsIf l_datetrack_mode = hr_api.g_zap then

1920: p_table_name => p_base_table_name,
1921: p_key_column => p_base_key_column,
1922: p_key_value => p_base_key_value);
1923: --
1924: ElsIf l_datetrack_mode = hr_api.g_zap then
1925: -- As we are performing a ZAP we must lock all rows from
1926: -- the start of time
1927: Lck_Future_Rows
1928: (p_effective_date => hr_api.g_sot,

Line 1928: (p_effective_date => hr_api.g_sot,

1924: ElsIf l_datetrack_mode = hr_api.g_zap then
1925: -- As we are performing a ZAP we must lock all rows from
1926: -- the start of time
1927: Lck_Future_Rows
1928: (p_effective_date => hr_api.g_sot,
1929: p_table_name => p_base_table_name,
1930: p_key_column => p_base_key_column,
1931: p_key_value => p_base_key_value);
1932: --

Line 1935: If (l_datetrack_mode = hr_api.g_insert) then

1931: p_key_value => p_base_key_value);
1932: --
1933: End If;
1934: --
1935: If (l_datetrack_mode = hr_api.g_insert) then
1936: --
1937: Get_Insert_Dates
1938: (p_effective_date => p_effective_date,
1939: p_base_table_name => p_base_table_name,

Line 1978: ElsIf (l_datetrack_mode = hr_api.g_correction) then

1974: p_enforce_foreign_locking => p_enforce_foreign_locking,
1975: p_validation_start_date => p_validation_start_date,
1976: p_validation_end_date => p_validation_end_date);
1977: --
1978: ElsIf (l_datetrack_mode = hr_api.g_correction) then
1979: --
1980: Get_Correction_Dates
1981: (p_effective_date => p_effective_date,
1982: p_base_table_name => p_base_table_name,

Line 1988: ElsIf (l_datetrack_mode = hr_api.g_update) then

1984: p_base_key_value => p_base_key_value,
1985: p_validation_start_date => p_validation_start_date,
1986: p_validation_end_date => p_validation_end_date);
1987: --
1988: ElsIf (l_datetrack_mode = hr_api.g_update) then
1989: --
1990: Get_Update_Dates
1991: (p_effective_date => p_effective_date,
1992: p_base_table_name => p_base_table_name,

Line 1998: ElsIf (l_datetrack_mode = hr_api.g_update_override) then

1994: p_base_key_value => p_base_key_value,
1995: p_validation_start_date => p_validation_start_date,
1996: p_validation_end_date => p_validation_end_date);
1997: --
1998: ElsIf (l_datetrack_mode = hr_api.g_update_override) then
1999: --
2000: Get_Update_Override_Dates
2001: (p_effective_date => p_effective_date,
2002: p_base_table_name => p_base_table_name,

Line 2008: ElsIf (l_datetrack_mode = hr_api.g_update_change_insert) then

2004: p_base_key_value => p_base_key_value,
2005: p_validation_start_date => p_validation_start_date,
2006: p_validation_end_date => p_validation_end_date);
2007: --
2008: ElsIf (l_datetrack_mode = hr_api.g_update_change_insert) then
2009: --
2010: Get_Update_Change_Insert_Dates
2011: (p_effective_date => p_effective_date,
2012: p_base_table_name => p_base_table_name,

Line 2018: ElsIf (l_datetrack_mode = hr_api.g_zap) then

2014: p_base_key_value => p_base_key_value,
2015: p_validation_start_date => p_validation_start_date,
2016: p_validation_end_date => p_validation_end_date);
2017: --
2018: ElsIf (l_datetrack_mode = hr_api.g_zap) then
2019: --
2020: Get_Zap_Dates
2021: (p_effective_date => p_effective_date,
2022: p_base_table_name => p_base_table_name,

Line 2028: ElsIf (l_datetrack_mode = hr_api.g_delete) then

2024: p_base_key_value => p_base_key_value,
2025: p_validation_start_date => p_validation_start_date,
2026: p_validation_end_date => p_validation_end_date);
2027: --
2028: ElsIf (l_datetrack_mode = hr_api.g_delete) then
2029: -- if (l_datetrack_mode = hr_api.g_delete) then
2030: --
2031: Get_Delete_Dates
2032: (p_effective_date => p_effective_date,

Line 2029: -- if (l_datetrack_mode = hr_api.g_delete) then

2025: p_validation_start_date => p_validation_start_date,
2026: p_validation_end_date => p_validation_end_date);
2027: --
2028: ElsIf (l_datetrack_mode = hr_api.g_delete) then
2029: -- if (l_datetrack_mode = hr_api.g_delete) then
2030: --
2031: Get_Delete_Dates
2032: (p_effective_date => p_effective_date,
2033: p_base_table_name => p_base_table_name,

Line 2046: ElsIf (l_datetrack_mode = hr_api.g_future_change) then

2042: p_enforce_foreign_locking => p_enforce_foreign_locking,
2043: p_validation_start_date => p_validation_start_date,
2044: p_validation_end_date => p_validation_end_date);
2045: --
2046: ElsIf (l_datetrack_mode = hr_api.g_future_change) then
2047: --
2048: Get_Future_Change_Dates
2049: (p_effective_date => p_effective_date,
2050: p_base_table_name => p_base_table_name,

Line 2088: ElsIf (l_datetrack_mode = hr_api.g_delete_next_change) then

2084: */
2085: p_validation_start_date => p_validation_start_date,
2086: p_validation_end_date => p_validation_end_date);
2087: --
2088: ElsIf (l_datetrack_mode = hr_api.g_delete_next_change) then
2089: --
2090: Get_Delete_Next_Change_Dates
2091: (p_effective_date => p_effective_date,
2092: p_base_table_name => p_base_table_name,

Line 2346: hr_api.mandatory_arg_error(p_api_name => l_proc

2342: hr_utility.set_location('Entering:'||l_proc, 5);
2343: --
2344: -- Ensure that all the mandatory arguments are not null
2345: --
2346: hr_api.mandatory_arg_error(p_api_name => l_proc
2347: ,p_argument => 'effective_date'
2348: ,p_argument_value => p_effective_date
2349: );
2350: --

Line 2351: hr_api.mandatory_arg_error(p_api_name => l_proc

2347: ,p_argument => 'effective_date'
2348: ,p_argument_value => p_effective_date
2349: );
2350: --
2351: hr_api.mandatory_arg_error(p_api_name => l_proc
2352: ,p_argument => 'datetrack_mode'
2353: ,p_argument_value => p_datetrack_mode
2354: );
2355: --

Line 2356: hr_api.mandatory_arg_error(p_api_name => l_proc

2352: ,p_argument => 'datetrack_mode'
2353: ,p_argument_value => p_datetrack_mode
2354: );
2355: --
2356: hr_api.mandatory_arg_error(p_api_name => l_proc
2357: ,p_argument => 'run_type_id'
2358: ,p_argument_value => p_run_type_id
2359: );
2360: --

Line 2361: hr_api.mandatory_arg_error(p_api_name => l_proc

2357: ,p_argument => 'run_type_id'
2358: ,p_argument_value => p_run_type_id
2359: );
2360: --
2361: hr_api.mandatory_arg_error(p_api_name => l_proc
2362: ,p_argument => 'object_version_number'
2363: ,p_argument_value => p_object_version_number
2364: );
2365: --

Line 2368: If (p_datetrack_mode <> hr_api.g_insert) then

2364: );
2365: --
2366: -- Check to ensure the datetrack mode is not INSERT.
2367: --
2368: If (p_datetrack_mode <> hr_api.g_insert) then
2369: --
2370: -- We must select and lock the current row.
2371: --
2372: Open C_Sel1;

Line 2450: When HR_Api.Object_Locked then

2446: --
2447: -- We need to trap the ORA LOCK exception
2448: --
2449: Exception
2450: When HR_Api.Object_Locked then
2451: --
2452: -- The object is locked therefore we need to supply a meaningful
2453: -- error message.
2454: --