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 299: hr_api.mandatory_arg_error(p_api_name => l_proc,

295: --
296: BEGIN
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: -- Ensure that all the mandatory arguments are not null
299: hr_api.mandatory_arg_error(p_api_name => l_proc,
300: p_argument => 'p_base_table_name',
301: p_argument_value => p_base_table_name);
302: hr_api.mandatory_arg_error(p_api_name => l_proc,
303: p_argument => 'p_base_key_column',

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

298: -- Ensure that all the mandatory arguments are not null
299: hr_api.mandatory_arg_error(p_api_name => l_proc,
300: p_argument => 'p_base_table_name',
301: p_argument_value => p_base_table_name);
302: hr_api.mandatory_arg_error(p_api_name => l_proc,
303: p_argument => 'p_base_key_column',
304: p_argument_value => p_base_key_column);
305: hr_api.mandatory_arg_error(p_api_name => l_proc,
306: p_argument => 'p_base_key_value',

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

301: p_argument_value => p_base_table_name);
302: hr_api.mandatory_arg_error(p_api_name => l_proc,
303: p_argument => 'p_base_key_column',
304: p_argument_value => p_base_key_column);
305: hr_api.mandatory_arg_error(p_api_name => l_proc,
306: p_argument => 'p_base_key_value',
307: p_argument_value => p_base_key_value);
308: -- [ end of change 30.14 ]
309: -- Define dynamic sql text with substitution tokens

Line 435: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

431: --
432: -- ----------------------------------------------------------------------------
433: Function Return_Min_Parent_End_Date
434: (p_effective_date in date,
435: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
437: p_parent_key_value1 in number default hr_api.g_number)
438: /*
439: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

Line 436: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

432: -- ----------------------------------------------------------------------------
433: Function Return_Min_Parent_End_Date
434: (p_effective_date in date,
435: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
437: p_parent_key_value1 in number default hr_api.g_number)
438: /*
439: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
440: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

Line 437: p_parent_key_value1 in number default hr_api.g_number)

433: Function Return_Min_Parent_End_Date
434: (p_effective_date in date,
435: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
437: p_parent_key_value1 in number default hr_api.g_number)
438: /*
439: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
440: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_value2 in number default hr_api.g_number,

Line 439: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

435: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
436: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
437: p_parent_key_value1 in number default hr_api.g_number)
438: /*
439: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
440: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_value2 in number default hr_api.g_number,
442: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
443: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

Line 440: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

436: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
437: p_parent_key_value1 in number default hr_api.g_number)
438: /*
439: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
440: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_value2 in number default hr_api.g_number,
442: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
443: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
444: p_parent_key_value3 in number default hr_api.g_number,

Line 441: p_parent_key_value2 in number default hr_api.g_number,

437: p_parent_key_value1 in number default hr_api.g_number)
438: /*
439: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
440: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_value2 in number default hr_api.g_number,
442: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
443: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
444: p_parent_key_value3 in number default hr_api.g_number,
445: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

Line 442: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,

438: /*
439: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
440: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_value2 in number default hr_api.g_number,
442: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
443: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
444: p_parent_key_value3 in number default hr_api.g_number,
445: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
446: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

Line 443: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

439: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
440: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_value2 in number default hr_api.g_number,
442: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
443: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
444: p_parent_key_value3 in number default hr_api.g_number,
445: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
446: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
447: p_parent_key_value4 in number default hr_api.g_number,

Line 444: p_parent_key_value3 in number default hr_api.g_number,

440: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
441: p_parent_key_value2 in number default hr_api.g_number,
442: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
443: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
444: p_parent_key_value3 in number default hr_api.g_number,
445: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
446: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
447: p_parent_key_value4 in number default hr_api.g_number,
448: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

Line 445: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

441: p_parent_key_value2 in number default hr_api.g_number,
442: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
443: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
444: p_parent_key_value3 in number default hr_api.g_number,
445: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
446: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
447: p_parent_key_value4 in number default hr_api.g_number,
448: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
449: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

Line 446: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

442: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
443: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
444: p_parent_key_value3 in number default hr_api.g_number,
445: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
446: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
447: p_parent_key_value4 in number default hr_api.g_number,
448: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
449: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
450: p_parent_key_value5 in number default hr_api.g_number,

Line 447: p_parent_key_value4 in number default hr_api.g_number,

443: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
444: p_parent_key_value3 in number default hr_api.g_number,
445: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
446: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
447: p_parent_key_value4 in number default hr_api.g_number,
448: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
449: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
450: p_parent_key_value5 in number default hr_api.g_number,
451: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

Line 448: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

444: p_parent_key_value3 in number default hr_api.g_number,
445: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
446: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
447: p_parent_key_value4 in number default hr_api.g_number,
448: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
449: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
450: p_parent_key_value5 in number default hr_api.g_number,
451: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
452: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

Line 449: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

445: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
446: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
447: p_parent_key_value4 in number default hr_api.g_number,
448: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
449: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
450: p_parent_key_value5 in number default hr_api.g_number,
451: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
452: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
453: p_parent_key_value6 in number default hr_api.g_number,

Line 450: p_parent_key_value5 in number default hr_api.g_number,

446: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
447: p_parent_key_value4 in number default hr_api.g_number,
448: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
449: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
450: p_parent_key_value5 in number default hr_api.g_number,
451: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
452: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
453: p_parent_key_value6 in number default hr_api.g_number,
454: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

Line 451: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

447: p_parent_key_value4 in number default hr_api.g_number,
448: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
449: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
450: p_parent_key_value5 in number default hr_api.g_number,
451: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
452: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
453: p_parent_key_value6 in number default hr_api.g_number,
454: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
455: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

Line 452: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

448: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
449: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
450: p_parent_key_value5 in number default hr_api.g_number,
451: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
452: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
453: p_parent_key_value6 in number default hr_api.g_number,
454: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
455: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
456: p_parent_key_value7 in number default hr_api.g_number,

Line 453: p_parent_key_value6 in number default hr_api.g_number,

449: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
450: p_parent_key_value5 in number default hr_api.g_number,
451: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
452: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
453: p_parent_key_value6 in number default hr_api.g_number,
454: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
455: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
456: p_parent_key_value7 in number default hr_api.g_number,
457: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

Line 454: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

450: p_parent_key_value5 in number default hr_api.g_number,
451: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
452: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
453: p_parent_key_value6 in number default hr_api.g_number,
454: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
455: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
456: p_parent_key_value7 in number default hr_api.g_number,
457: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
458: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

Line 455: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

451: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
452: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
453: p_parent_key_value6 in number default hr_api.g_number,
454: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
455: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
456: p_parent_key_value7 in number default hr_api.g_number,
457: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
458: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
459: p_parent_key_value8 in number default hr_api.g_number,

Line 456: p_parent_key_value7 in number default hr_api.g_number,

452: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
453: p_parent_key_value6 in number default hr_api.g_number,
454: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
455: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
456: p_parent_key_value7 in number default hr_api.g_number,
457: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
458: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
459: p_parent_key_value8 in number default hr_api.g_number,
460: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

Line 457: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

453: p_parent_key_value6 in number default hr_api.g_number,
454: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
455: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
456: p_parent_key_value7 in number default hr_api.g_number,
457: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
458: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
459: p_parent_key_value8 in number default hr_api.g_number,
460: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
461: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

Line 458: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

454: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
455: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
456: p_parent_key_value7 in number default hr_api.g_number,
457: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
458: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
459: p_parent_key_value8 in number default hr_api.g_number,
460: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
461: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
462: p_parent_key_value9 in number default hr_api.g_number,

Line 459: p_parent_key_value8 in number default hr_api.g_number,

455: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
456: p_parent_key_value7 in number default hr_api.g_number,
457: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
458: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
459: p_parent_key_value8 in number default hr_api.g_number,
460: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
461: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
462: p_parent_key_value9 in number default hr_api.g_number,
463: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

Line 460: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

456: p_parent_key_value7 in number default hr_api.g_number,
457: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
458: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
459: p_parent_key_value8 in number default hr_api.g_number,
460: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
461: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
462: p_parent_key_value9 in number default hr_api.g_number,
463: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
464: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

Line 461: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

457: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
458: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
459: p_parent_key_value8 in number default hr_api.g_number,
460: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
461: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
462: p_parent_key_value9 in number default hr_api.g_number,
463: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
464: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
465: p_parent_key_value10 in number default hr_api.g_number)

Line 462: p_parent_key_value9 in number default hr_api.g_number,

458: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
459: p_parent_key_value8 in number default hr_api.g_number,
460: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
461: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
462: p_parent_key_value9 in number default hr_api.g_number,
463: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
464: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
465: p_parent_key_value10 in number default hr_api.g_number)
466: */

Line 463: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

459: p_parent_key_value8 in number default hr_api.g_number,
460: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
461: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
462: p_parent_key_value9 in number default hr_api.g_number,
463: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
464: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
465: p_parent_key_value10 in number default hr_api.g_number)
466: */
467: Return Date Is

Line 464: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

460: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
461: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
462: p_parent_key_value9 in number default hr_api.g_number,
463: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
464: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
465: p_parent_key_value10 in number default hr_api.g_number)
466: */
467: Return Date Is
468: --

Line 465: p_parent_key_value10 in number default hr_api.g_number)

461: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
462: p_parent_key_value9 in number default hr_api.g_number,
463: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
464: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
465: p_parent_key_value10 in number default hr_api.g_number)
466: */
467: Return Date Is
468: --
469: l_proc varchar2(72) := g_package||

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

468: --
469: l_proc varchar2(72) := g_package||
470: 'Return_Min_Parent_End_Date';
471: --
472: l_min_date date := hr_api.g_eot; -- End Of Time
473: l_counter integer; -- Loop counter
474: l_temp_date date;
475: --
476: l_parent_table_name varchar2(30);

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

531: */
532: --
533: -- Ensure that all the working parental details have been specified
534: --
535: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
536: hr_api.g_varchar2) or
537: (nvl(l_parent_key_column, hr_api.g_varchar2) =
538: hr_api.g_varchar2) or
539: (nvl(l_parent_key_value, hr_api.g_number) =

Line 536: hr_api.g_varchar2) or

532: --
533: -- Ensure that all the working parental details have been specified
534: --
535: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
536: hr_api.g_varchar2) or
537: (nvl(l_parent_key_column, hr_api.g_varchar2) =
538: hr_api.g_varchar2) or
539: (nvl(l_parent_key_value, hr_api.g_number) =
540: hr_api.g_number)) then

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

533: -- Ensure that all the working parental details have been specified
534: --
535: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
536: hr_api.g_varchar2) or
537: (nvl(l_parent_key_column, hr_api.g_varchar2) =
538: hr_api.g_varchar2) or
539: (nvl(l_parent_key_value, hr_api.g_number) =
540: hr_api.g_number)) then
541: --

Line 538: hr_api.g_varchar2) or

534: --
535: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
536: hr_api.g_varchar2) or
537: (nvl(l_parent_key_column, hr_api.g_varchar2) =
538: hr_api.g_varchar2) or
539: (nvl(l_parent_key_value, hr_api.g_number) =
540: hr_api.g_number)) then
541: --
542: -- All the parental arguments have been specified therefore we must get

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

535: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
536: hr_api.g_varchar2) or
537: (nvl(l_parent_key_column, hr_api.g_varchar2) =
538: hr_api.g_varchar2) or
539: (nvl(l_parent_key_value, hr_api.g_number) =
540: hr_api.g_number)) then
541: --
542: -- All the parental arguments have been specified therefore we must get
543: -- the maximum effective end date for the given parent.

Line 540: hr_api.g_number)) then

536: hr_api.g_varchar2) or
537: (nvl(l_parent_key_column, hr_api.g_varchar2) =
538: hr_api.g_varchar2) or
539: (nvl(l_parent_key_value, hr_api.g_number) =
540: hr_api.g_number)) then
541: --
542: -- All the parental arguments have been specified therefore we must get
543: -- the maximum effective end date for the given parent.
544: --

Line 589: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

585: --
586: -- ----------------------------------------------------------------------------
587: Function Return_Min_Parent_Start_Date
588: (p_effective_date in date,
589: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
591: p_parent_key_value1 in number default hr_api.g_number)
592: /*
593: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

Line 590: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

586: -- ----------------------------------------------------------------------------
587: Function Return_Min_Parent_Start_Date
588: (p_effective_date in date,
589: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
591: p_parent_key_value1 in number default hr_api.g_number)
592: /*
593: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
594: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

Line 591: p_parent_key_value1 in number default hr_api.g_number)

587: Function Return_Min_Parent_Start_Date
588: (p_effective_date in date,
589: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
591: p_parent_key_value1 in number default hr_api.g_number)
592: /*
593: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
594: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_value2 in number default hr_api.g_number,

Line 593: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

589: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
590: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
591: p_parent_key_value1 in number default hr_api.g_number)
592: /*
593: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
594: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_value2 in number default hr_api.g_number,
596: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
597: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

Line 594: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

590: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
591: p_parent_key_value1 in number default hr_api.g_number)
592: /*
593: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
594: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_value2 in number default hr_api.g_number,
596: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
597: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
598: p_parent_key_value3 in number default hr_api.g_number,

Line 595: p_parent_key_value2 in number default hr_api.g_number,

591: p_parent_key_value1 in number default hr_api.g_number)
592: /*
593: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
594: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_value2 in number default hr_api.g_number,
596: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
597: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
598: p_parent_key_value3 in number default hr_api.g_number,
599: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

Line 596: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,

592: /*
593: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
594: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_value2 in number default hr_api.g_number,
596: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
597: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
598: p_parent_key_value3 in number default hr_api.g_number,
599: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
600: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

Line 597: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

593: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
594: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_value2 in number default hr_api.g_number,
596: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
597: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
598: p_parent_key_value3 in number default hr_api.g_number,
599: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
600: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
601: p_parent_key_value4 in number default hr_api.g_number,

Line 598: p_parent_key_value3 in number default hr_api.g_number,

594: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
595: p_parent_key_value2 in number default hr_api.g_number,
596: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
597: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
598: p_parent_key_value3 in number default hr_api.g_number,
599: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
600: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
601: p_parent_key_value4 in number default hr_api.g_number,
602: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

Line 599: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

595: p_parent_key_value2 in number default hr_api.g_number,
596: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
597: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
598: p_parent_key_value3 in number default hr_api.g_number,
599: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
600: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
601: p_parent_key_value4 in number default hr_api.g_number,
602: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
603: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

Line 600: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

596: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
597: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
598: p_parent_key_value3 in number default hr_api.g_number,
599: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
600: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
601: p_parent_key_value4 in number default hr_api.g_number,
602: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
603: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
604: p_parent_key_value5 in number default hr_api.g_number,

Line 601: p_parent_key_value4 in number default hr_api.g_number,

597: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
598: p_parent_key_value3 in number default hr_api.g_number,
599: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
600: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
601: p_parent_key_value4 in number default hr_api.g_number,
602: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
603: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
604: p_parent_key_value5 in number default hr_api.g_number,
605: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

Line 602: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

598: p_parent_key_value3 in number default hr_api.g_number,
599: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
600: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
601: p_parent_key_value4 in number default hr_api.g_number,
602: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
603: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
604: p_parent_key_value5 in number default hr_api.g_number,
605: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
606: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

Line 603: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

599: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
600: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
601: p_parent_key_value4 in number default hr_api.g_number,
602: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
603: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
604: p_parent_key_value5 in number default hr_api.g_number,
605: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
606: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
607: p_parent_key_value6 in number default hr_api.g_number,

Line 604: p_parent_key_value5 in number default hr_api.g_number,

600: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
601: p_parent_key_value4 in number default hr_api.g_number,
602: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
603: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
604: p_parent_key_value5 in number default hr_api.g_number,
605: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
606: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
607: p_parent_key_value6 in number default hr_api.g_number,
608: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

Line 605: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

601: p_parent_key_value4 in number default hr_api.g_number,
602: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
603: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
604: p_parent_key_value5 in number default hr_api.g_number,
605: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
606: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
607: p_parent_key_value6 in number default hr_api.g_number,
608: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
609: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

Line 606: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

602: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
603: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
604: p_parent_key_value5 in number default hr_api.g_number,
605: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
606: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
607: p_parent_key_value6 in number default hr_api.g_number,
608: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
609: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
610: p_parent_key_value7 in number default hr_api.g_number,

Line 607: p_parent_key_value6 in number default hr_api.g_number,

603: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
604: p_parent_key_value5 in number default hr_api.g_number,
605: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
606: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
607: p_parent_key_value6 in number default hr_api.g_number,
608: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
609: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
610: p_parent_key_value7 in number default hr_api.g_number,
611: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

Line 608: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

604: p_parent_key_value5 in number default hr_api.g_number,
605: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
606: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
607: p_parent_key_value6 in number default hr_api.g_number,
608: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
609: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
610: p_parent_key_value7 in number default hr_api.g_number,
611: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
612: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

Line 609: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

605: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
606: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
607: p_parent_key_value6 in number default hr_api.g_number,
608: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
609: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
610: p_parent_key_value7 in number default hr_api.g_number,
611: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
612: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
613: p_parent_key_value8 in number default hr_api.g_number,

Line 610: p_parent_key_value7 in number default hr_api.g_number,

606: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
607: p_parent_key_value6 in number default hr_api.g_number,
608: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
609: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
610: p_parent_key_value7 in number default hr_api.g_number,
611: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
612: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
613: p_parent_key_value8 in number default hr_api.g_number,
614: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

Line 611: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

607: p_parent_key_value6 in number default hr_api.g_number,
608: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
609: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
610: p_parent_key_value7 in number default hr_api.g_number,
611: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
612: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
613: p_parent_key_value8 in number default hr_api.g_number,
614: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
615: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

Line 612: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

608: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
609: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
610: p_parent_key_value7 in number default hr_api.g_number,
611: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
612: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
613: p_parent_key_value8 in number default hr_api.g_number,
614: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
615: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
616: p_parent_key_value9 in number default hr_api.g_number,

Line 613: p_parent_key_value8 in number default hr_api.g_number,

609: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
610: p_parent_key_value7 in number default hr_api.g_number,
611: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
612: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
613: p_parent_key_value8 in number default hr_api.g_number,
614: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
615: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
616: p_parent_key_value9 in number default hr_api.g_number,
617: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

Line 614: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

610: p_parent_key_value7 in number default hr_api.g_number,
611: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
612: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
613: p_parent_key_value8 in number default hr_api.g_number,
614: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
615: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
616: p_parent_key_value9 in number default hr_api.g_number,
617: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
618: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

Line 615: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

611: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
612: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
613: p_parent_key_value8 in number default hr_api.g_number,
614: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
615: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
616: p_parent_key_value9 in number default hr_api.g_number,
617: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
618: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
619: p_parent_key_value10 in number default hr_api.g_number)

Line 616: p_parent_key_value9 in number default hr_api.g_number,

612: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
613: p_parent_key_value8 in number default hr_api.g_number,
614: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
615: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
616: p_parent_key_value9 in number default hr_api.g_number,
617: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
618: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
619: p_parent_key_value10 in number default hr_api.g_number)
620: */

Line 617: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

613: p_parent_key_value8 in number default hr_api.g_number,
614: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
615: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
616: p_parent_key_value9 in number default hr_api.g_number,
617: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
618: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
619: p_parent_key_value10 in number default hr_api.g_number)
620: */
621: Return Date Is

Line 618: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

614: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
615: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
616: p_parent_key_value9 in number default hr_api.g_number,
617: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
618: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
619: p_parent_key_value10 in number default hr_api.g_number)
620: */
621: Return Date Is
622: --

Line 619: p_parent_key_value10 in number default hr_api.g_number)

615: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
616: p_parent_key_value9 in number default hr_api.g_number,
617: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
618: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
619: p_parent_key_value10 in number default hr_api.g_number)
620: */
621: Return Date Is
622: --
623: l_proc varchar2(72) := g_package||

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

622: --
623: l_proc varchar2(72) := g_package||
624: 'Return_Min_Parent_Start_Date';
625: --
626: l_min_date date := hr_api.g_sot; -- Start Of Time
627: l_counter integer; -- Loop counter
628: l_temp_date date;
629: --
630: l_parent_table_name varchar2(30);

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

687: */
688: --
689: -- Ensure that all the working parental details have been specified
690: --
691: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
692: hr_api.g_varchar2) or
693: (nvl(l_parent_key_column, hr_api.g_varchar2) =
694: hr_api.g_varchar2) or
695: (nvl(l_parent_key_value, hr_api.g_number) =

Line 692: hr_api.g_varchar2) or

688: --
689: -- Ensure that all the working parental details have been specified
690: --
691: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
692: hr_api.g_varchar2) or
693: (nvl(l_parent_key_column, hr_api.g_varchar2) =
694: hr_api.g_varchar2) or
695: (nvl(l_parent_key_value, hr_api.g_number) =
696: hr_api.g_number)) then

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

689: -- Ensure that all the working parental details have been specified
690: --
691: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
692: hr_api.g_varchar2) or
693: (nvl(l_parent_key_column, hr_api.g_varchar2) =
694: hr_api.g_varchar2) or
695: (nvl(l_parent_key_value, hr_api.g_number) =
696: hr_api.g_number)) then
697: --

Line 694: hr_api.g_varchar2) or

690: --
691: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
692: hr_api.g_varchar2) or
693: (nvl(l_parent_key_column, hr_api.g_varchar2) =
694: hr_api.g_varchar2) or
695: (nvl(l_parent_key_value, hr_api.g_number) =
696: hr_api.g_number)) then
697: --
698: -- All the parental arguments have been specified therefore we must get

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

691: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
692: hr_api.g_varchar2) or
693: (nvl(l_parent_key_column, hr_api.g_varchar2) =
694: hr_api.g_varchar2) or
695: (nvl(l_parent_key_value, hr_api.g_number) =
696: hr_api.g_number)) then
697: --
698: -- All the parental arguments have been specified therefore we must get
699: -- the minimum effective start date for the given parent.

Line 696: hr_api.g_number)) then

692: hr_api.g_varchar2) or
693: (nvl(l_parent_key_column, hr_api.g_varchar2) =
694: hr_api.g_varchar2) or
695: (nvl(l_parent_key_value, hr_api.g_number) =
696: hr_api.g_number)) then
697: --
698: -- All the parental arguments have been specified therefore we must get
699: -- the minimum effective start date for the given parent.
700: --

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

760: -- Ensure that all the required parameters exist
761: -- Note: we don't check the p_key_value argument
762: --
763: -- [ start of change 30.14 ]
764: hr_api.mandatory_arg_error(p_api_name => l_proc,
765: p_argument => 'p_effective_date',
766: p_argument_value => p_effective_date);
767: hr_api.mandatory_arg_error(p_api_name => l_proc,
768: p_argument => 'p_table_name',

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

763: -- [ start of change 30.14 ]
764: hr_api.mandatory_arg_error(p_api_name => l_proc,
765: p_argument => 'p_effective_date',
766: p_argument_value => p_effective_date);
767: hr_api.mandatory_arg_error(p_api_name => l_proc,
768: p_argument => 'p_table_name',
769: p_argument_value => p_table_name);
770: hr_api.mandatory_arg_error(p_api_name => l_proc,
771: p_argument => 'p_key_column',

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

766: p_argument_value => p_effective_date);
767: hr_api.mandatory_arg_error(p_api_name => l_proc,
768: p_argument => 'p_table_name',
769: p_argument_value => p_table_name);
770: hr_api.mandatory_arg_error(p_api_name => l_proc,
771: p_argument => 'p_key_column',
772: p_argument_value => p_key_column);
773: -- [ end of change 30.14 ]
774: -- If the p_key_value is null then we must not

Line 803: WHEN hr_api.object_locked THEN

799: -- therefore a serious integrity problem has ocurred
800: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
801: hr_utility.set_message_token('ARGUMENT', upper(p_key_column));
802: hr_utility.raise_error;
803: WHEN hr_api.object_locked THEN
804: -- The object is locked therefore we need to supply a meaningful
805: -- error message.
806: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
807: hr_utility.set_message_token('TABLE_NAME', p_table_name);

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

882: --
883: -- Ensure that all the required parameters exist
884: -- Note: we don't check the p_parent_key_value argument
885: --
886: hr_api.mandatory_arg_error(p_api_name => l_proc,
887: p_argument => 'p_child_table_name',
888: p_argument_value => p_child_table_name);
889: hr_api.mandatory_arg_error(p_api_name => l_proc,
890: p_argument => 'p_child_key_column',

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

885: --
886: hr_api.mandatory_arg_error(p_api_name => l_proc,
887: p_argument => 'p_child_table_name',
888: p_argument_value => p_child_table_name);
889: hr_api.mandatory_arg_error(p_api_name => l_proc,
890: p_argument => 'p_child_key_column',
891: p_argument_value => p_child_key_column);
892: hr_api.mandatory_arg_error(p_api_name => l_proc,
893: p_argument => 'p_parent_key_column',

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

888: p_argument_value => p_child_table_name);
889: hr_api.mandatory_arg_error(p_api_name => l_proc,
890: p_argument => 'p_child_key_column',
891: p_argument_value => p_child_key_column);
892: hr_api.mandatory_arg_error(p_api_name => l_proc,
893: p_argument => 'p_parent_key_column',
894: p_argument_value => p_parent_key_column);
895: hr_api.mandatory_arg_error(p_api_name => l_proc,
896: p_argument => 'p_validation_start_date',

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

891: p_argument_value => p_child_key_column);
892: hr_api.mandatory_arg_error(p_api_name => l_proc,
893: p_argument => 'p_parent_key_column',
894: p_argument_value => p_parent_key_column);
895: hr_api.mandatory_arg_error(p_api_name => l_proc,
896: p_argument => 'p_validation_start_date',
897: p_argument_value => p_validation_start_date);
898: --
899: -- If the p_parent_key_value is null then we must not

Line 945: WHEN hr_api.object_locked THEN

941: CLOSE l_cursor;
942: hr_utility.set_location(' Leaving:'||l_proc, 35);
943: END IF;
944: EXCEPTION
945: WHEN hr_api.object_locked THEN
946: IF l_cursor%ISOPEN THEN
947: CLOSE l_cursor;
948: END IF;
949: -- The object is locked therefore we need to supply a meaningful

Line 977: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

973: (p_effective_date in date,
974: p_base_table_name in varchar2,
975: p_base_key_column in varchar2,
976: p_base_key_value in number,
977: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
979: p_parent_key_value1 in number default hr_api.g_number,
980: /*
981: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

Line 978: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

974: p_base_table_name in varchar2,
975: p_base_key_column in varchar2,
976: p_base_key_value in number,
977: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
979: p_parent_key_value1 in number default hr_api.g_number,
980: /*
981: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
982: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

Line 979: p_parent_key_value1 in number default hr_api.g_number,

975: p_base_key_column in varchar2,
976: p_base_key_value in number,
977: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
979: p_parent_key_value1 in number default hr_api.g_number,
980: /*
981: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
982: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_value2 in number default hr_api.g_number,

Line 981: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

977: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
978: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
979: p_parent_key_value1 in number default hr_api.g_number,
980: /*
981: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
982: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_value2 in number default hr_api.g_number,
984: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
985: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

Line 982: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

978: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
979: p_parent_key_value1 in number default hr_api.g_number,
980: /*
981: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
982: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_value2 in number default hr_api.g_number,
984: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
985: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
986: p_parent_key_value3 in number default hr_api.g_number,

Line 983: p_parent_key_value2 in number default hr_api.g_number,

979: p_parent_key_value1 in number default hr_api.g_number,
980: /*
981: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
982: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_value2 in number default hr_api.g_number,
984: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
985: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
986: p_parent_key_value3 in number default hr_api.g_number,
987: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

Line 984: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,

980: /*
981: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
982: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_value2 in number default hr_api.g_number,
984: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
985: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
986: p_parent_key_value3 in number default hr_api.g_number,
987: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
988: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

Line 985: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

981: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
982: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_value2 in number default hr_api.g_number,
984: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
985: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
986: p_parent_key_value3 in number default hr_api.g_number,
987: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
988: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
989: p_parent_key_value4 in number default hr_api.g_number,

Line 986: p_parent_key_value3 in number default hr_api.g_number,

982: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
983: p_parent_key_value2 in number default hr_api.g_number,
984: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
985: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
986: p_parent_key_value3 in number default hr_api.g_number,
987: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
988: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
989: p_parent_key_value4 in number default hr_api.g_number,
990: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

Line 987: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

983: p_parent_key_value2 in number default hr_api.g_number,
984: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
985: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
986: p_parent_key_value3 in number default hr_api.g_number,
987: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
988: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
989: p_parent_key_value4 in number default hr_api.g_number,
990: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
991: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

Line 988: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

984: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
985: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
986: p_parent_key_value3 in number default hr_api.g_number,
987: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
988: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
989: p_parent_key_value4 in number default hr_api.g_number,
990: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
991: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
992: p_parent_key_value5 in number default hr_api.g_number,

Line 989: p_parent_key_value4 in number default hr_api.g_number,

985: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
986: p_parent_key_value3 in number default hr_api.g_number,
987: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
988: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
989: p_parent_key_value4 in number default hr_api.g_number,
990: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
991: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
992: p_parent_key_value5 in number default hr_api.g_number,
993: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

Line 990: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

986: p_parent_key_value3 in number default hr_api.g_number,
987: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
988: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
989: p_parent_key_value4 in number default hr_api.g_number,
990: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
991: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
992: p_parent_key_value5 in number default hr_api.g_number,
993: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
994: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

Line 991: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

987: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
988: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
989: p_parent_key_value4 in number default hr_api.g_number,
990: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
991: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
992: p_parent_key_value5 in number default hr_api.g_number,
993: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
994: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
995: p_parent_key_value6 in number default hr_api.g_number,

Line 992: p_parent_key_value5 in number default hr_api.g_number,

988: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
989: p_parent_key_value4 in number default hr_api.g_number,
990: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
991: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
992: p_parent_key_value5 in number default hr_api.g_number,
993: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
994: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
995: p_parent_key_value6 in number default hr_api.g_number,
996: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

Line 993: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

989: p_parent_key_value4 in number default hr_api.g_number,
990: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
991: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
992: p_parent_key_value5 in number default hr_api.g_number,
993: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
994: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
995: p_parent_key_value6 in number default hr_api.g_number,
996: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
997: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

Line 994: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

990: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
991: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
992: p_parent_key_value5 in number default hr_api.g_number,
993: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
994: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
995: p_parent_key_value6 in number default hr_api.g_number,
996: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
997: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
998: p_parent_key_value7 in number default hr_api.g_number,

Line 995: p_parent_key_value6 in number default hr_api.g_number,

991: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
992: p_parent_key_value5 in number default hr_api.g_number,
993: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
994: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
995: p_parent_key_value6 in number default hr_api.g_number,
996: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
997: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
998: p_parent_key_value7 in number default hr_api.g_number,
999: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

Line 996: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

992: p_parent_key_value5 in number default hr_api.g_number,
993: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
994: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
995: p_parent_key_value6 in number default hr_api.g_number,
996: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
997: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
998: p_parent_key_value7 in number default hr_api.g_number,
999: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1000: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

Line 997: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

993: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
994: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
995: p_parent_key_value6 in number default hr_api.g_number,
996: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
997: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
998: p_parent_key_value7 in number default hr_api.g_number,
999: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1000: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1001: p_parent_key_value8 in number default hr_api.g_number,

Line 998: p_parent_key_value7 in number default hr_api.g_number,

994: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
995: p_parent_key_value6 in number default hr_api.g_number,
996: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
997: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
998: p_parent_key_value7 in number default hr_api.g_number,
999: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1000: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1001: p_parent_key_value8 in number default hr_api.g_number,
1002: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

Line 999: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

995: p_parent_key_value6 in number default hr_api.g_number,
996: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
997: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
998: p_parent_key_value7 in number default hr_api.g_number,
999: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1000: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1001: p_parent_key_value8 in number default hr_api.g_number,
1002: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1003: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

Line 1000: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

996: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
997: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
998: p_parent_key_value7 in number default hr_api.g_number,
999: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1000: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1001: p_parent_key_value8 in number default hr_api.g_number,
1002: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1003: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1004: p_parent_key_value9 in number default hr_api.g_number,

Line 1001: p_parent_key_value8 in number default hr_api.g_number,

997: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
998: p_parent_key_value7 in number default hr_api.g_number,
999: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1000: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1001: p_parent_key_value8 in number default hr_api.g_number,
1002: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1003: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1004: p_parent_key_value9 in number default hr_api.g_number,
1005: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

Line 1002: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

998: p_parent_key_value7 in number default hr_api.g_number,
999: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1000: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1001: p_parent_key_value8 in number default hr_api.g_number,
1002: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1003: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1004: p_parent_key_value9 in number default hr_api.g_number,
1005: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1006: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

Line 1003: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

999: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1000: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1001: p_parent_key_value8 in number default hr_api.g_number,
1002: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1003: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1004: p_parent_key_value9 in number default hr_api.g_number,
1005: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1006: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1007: p_parent_key_value10 in number default hr_api.g_number,

Line 1004: p_parent_key_value9 in number default hr_api.g_number,

1000: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1001: p_parent_key_value8 in number default hr_api.g_number,
1002: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1003: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1004: p_parent_key_value9 in number default hr_api.g_number,
1005: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1006: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1007: p_parent_key_value10 in number default hr_api.g_number,
1008: */

Line 1005: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

1001: p_parent_key_value8 in number default hr_api.g_number,
1002: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1003: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1004: p_parent_key_value9 in number default hr_api.g_number,
1005: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1006: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1007: p_parent_key_value10 in number default hr_api.g_number,
1008: */
1009: p_enforce_foreign_locking in boolean,

Line 1006: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

1002: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1003: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1004: p_parent_key_value9 in number default hr_api.g_number,
1005: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1006: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1007: p_parent_key_value10 in number default hr_api.g_number,
1008: */
1009: p_enforce_foreign_locking in boolean,
1010: p_validation_start_date out nocopy date,

Line 1007: p_parent_key_value10 in number default hr_api.g_number,

1003: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1004: p_parent_key_value9 in number default hr_api.g_number,
1005: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1006: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1007: p_parent_key_value10 in number default hr_api.g_number,
1008: */
1009: p_enforce_foreign_locking in boolean,
1010: p_validation_start_date out nocopy date,
1011: p_validation_end_date out nocopy date) Is

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

1075: */
1076: --
1077: -- Ensure that all the working parental details have been specified
1078: --
1079: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
1080: hr_api.g_varchar2) or
1081: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1082: hr_api.g_varchar2) or
1083: (nvl(l_parent_key_value, hr_api.g_number) =

Line 1080: hr_api.g_varchar2) or

1076: --
1077: -- Ensure that all the working parental details have been specified
1078: --
1079: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
1080: hr_api.g_varchar2) or
1081: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1082: hr_api.g_varchar2) or
1083: (nvl(l_parent_key_value, hr_api.g_number) =
1084: hr_api.g_number)) then

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

1077: -- Ensure that all the working parental details have been specified
1078: --
1079: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
1080: hr_api.g_varchar2) or
1081: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1082: hr_api.g_varchar2) or
1083: (nvl(l_parent_key_value, hr_api.g_number) =
1084: hr_api.g_number)) then
1085: --

Line 1082: hr_api.g_varchar2) or

1078: --
1079: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
1080: hr_api.g_varchar2) or
1081: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1082: hr_api.g_varchar2) or
1083: (nvl(l_parent_key_value, hr_api.g_number) =
1084: hr_api.g_number)) then
1085: --
1086: -- All the parental arguments have been specified therefore we must

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

1079: If NOT ((nvl(l_parent_table_name, hr_api.g_varchar2) =
1080: hr_api.g_varchar2) or
1081: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1082: hr_api.g_varchar2) or
1083: (nvl(l_parent_key_value, hr_api.g_number) =
1084: hr_api.g_number)) then
1085: --
1086: -- All the parental arguments have been specified therefore we must
1087: -- attempt to lock the specified parent rows.

Line 1084: hr_api.g_number)) then

1080: hr_api.g_varchar2) or
1081: (nvl(l_parent_key_column, hr_api.g_varchar2) =
1082: hr_api.g_varchar2) or
1083: (nvl(l_parent_key_value, hr_api.g_number) =
1084: hr_api.g_number)) then
1085: --
1086: -- All the parental arguments have been specified therefore we must
1087: -- attempt to lock the specified parent rows.
1088: --

Line 1456: p_child_table_name1 in varchar2 default hr_api.g_varchar2,

1452: (p_effective_date in date,
1453: p_base_table_name in varchar2,
1454: p_base_key_column in varchar2,
1455: p_base_key_value in number,
1456: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1457: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1458: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1459: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1460: p_child_key_column2 in varchar2 default hr_api.g_varchar2,

Line 1457: p_child_key_column1 in varchar2 default hr_api.g_varchar2,

1453: p_base_table_name in varchar2,
1454: p_base_key_column in varchar2,
1455: p_base_key_value in number,
1456: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1457: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1458: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1459: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1460: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1461: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,

Line 1458: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,

1454: p_base_key_column in varchar2,
1455: p_base_key_value in number,
1456: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1457: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1458: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1459: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1460: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1461: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1462: p_enforce_foreign_locking in boolean default true,

Line 1459: p_child_table_name2 in varchar2 default hr_api.g_varchar2,

1455: p_base_key_value in number,
1456: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1457: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1458: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1459: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1460: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1461: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1462: p_enforce_foreign_locking in boolean default true,
1463: p_validation_start_date out nocopy date,

Line 1460: p_child_key_column2 in varchar2 default hr_api.g_varchar2,

1456: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1457: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1458: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1459: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1460: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1461: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1462: p_enforce_foreign_locking in boolean default true,
1463: p_validation_start_date out nocopy date,
1464: p_validation_end_date out nocopy date) Is

Line 1461: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,

1457: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1458: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1459: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1460: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1461: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1462: p_enforce_foreign_locking in boolean default true,
1463: p_validation_start_date out nocopy date,
1464: p_validation_end_date out nocopy date) Is
1465: --

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

1492: End If;
1493: --
1494: -- Ensure that all the working child details have been specified
1495: --
1496: If NOT ((nvl(l_child_table_name, hr_api.g_varchar2) =
1497: hr_api.g_varchar2) or
1498: (nvl(l_child_key_column, hr_api.g_varchar2) =
1499: hr_api.g_varchar2)) then
1500: --

Line 1497: hr_api.g_varchar2) or

1493: --
1494: -- Ensure that all the working child details have been specified
1495: --
1496: If NOT ((nvl(l_child_table_name, hr_api.g_varchar2) =
1497: hr_api.g_varchar2) or
1498: (nvl(l_child_key_column, hr_api.g_varchar2) =
1499: hr_api.g_varchar2)) then
1500: --
1501: --

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

1494: -- Ensure that all the working child details have been specified
1495: --
1496: If NOT ((nvl(l_child_table_name, hr_api.g_varchar2) =
1497: hr_api.g_varchar2) or
1498: (nvl(l_child_key_column, hr_api.g_varchar2) =
1499: hr_api.g_varchar2)) then
1500: --
1501: --
1502: -- All the child arguments have been specified therefore we must lock

Line 1499: hr_api.g_varchar2)) then

1495: --
1496: If NOT ((nvl(l_child_table_name, hr_api.g_varchar2) =
1497: hr_api.g_varchar2) or
1498: (nvl(l_child_key_column, hr_api.g_varchar2) =
1499: hr_api.g_varchar2)) then
1500: --
1501: --
1502: -- All the child arguments have been specified therefore we must lock
1503: -- the child rows (if they exist).

Line 1558: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

1554: (p_effective_date in date,
1555: p_base_table_name in varchar2,
1556: p_base_key_column in varchar2,
1557: p_base_key_value in number,
1558: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1560: p_parent_key_value1 in number default hr_api.g_number,
1561: /*
1562: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

Line 1559: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

1555: p_base_table_name in varchar2,
1556: p_base_key_column in varchar2,
1557: p_base_key_value in number,
1558: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1560: p_parent_key_value1 in number default hr_api.g_number,
1561: /*
1562: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1563: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

Line 1560: p_parent_key_value1 in number default hr_api.g_number,

1556: p_base_key_column in varchar2,
1557: p_base_key_value in number,
1558: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1560: p_parent_key_value1 in number default hr_api.g_number,
1561: /*
1562: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1563: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_value2 in number default hr_api.g_number,

Line 1562: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

1558: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1559: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1560: p_parent_key_value1 in number default hr_api.g_number,
1561: /*
1562: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1563: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_value2 in number default hr_api.g_number,
1565: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1566: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

Line 1563: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

1559: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1560: p_parent_key_value1 in number default hr_api.g_number,
1561: /*
1562: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1563: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_value2 in number default hr_api.g_number,
1565: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1566: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1567: p_parent_key_value3 in number default hr_api.g_number,

Line 1564: p_parent_key_value2 in number default hr_api.g_number,

1560: p_parent_key_value1 in number default hr_api.g_number,
1561: /*
1562: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1563: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_value2 in number default hr_api.g_number,
1565: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1566: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1567: p_parent_key_value3 in number default hr_api.g_number,
1568: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

Line 1565: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,

1561: /*
1562: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1563: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_value2 in number default hr_api.g_number,
1565: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1566: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1567: p_parent_key_value3 in number default hr_api.g_number,
1568: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1569: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

Line 1566: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

1562: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1563: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_value2 in number default hr_api.g_number,
1565: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1566: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1567: p_parent_key_value3 in number default hr_api.g_number,
1568: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1569: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1570: p_parent_key_value4 in number default hr_api.g_number,

Line 1567: p_parent_key_value3 in number default hr_api.g_number,

1563: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1564: p_parent_key_value2 in number default hr_api.g_number,
1565: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1566: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1567: p_parent_key_value3 in number default hr_api.g_number,
1568: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1569: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1570: p_parent_key_value4 in number default hr_api.g_number,
1571: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

Line 1568: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

1564: p_parent_key_value2 in number default hr_api.g_number,
1565: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1566: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1567: p_parent_key_value3 in number default hr_api.g_number,
1568: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1569: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1570: p_parent_key_value4 in number default hr_api.g_number,
1571: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1572: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

Line 1569: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

1565: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1566: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1567: p_parent_key_value3 in number default hr_api.g_number,
1568: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1569: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1570: p_parent_key_value4 in number default hr_api.g_number,
1571: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1572: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1573: p_parent_key_value5 in number default hr_api.g_number,

Line 1570: p_parent_key_value4 in number default hr_api.g_number,

1566: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1567: p_parent_key_value3 in number default hr_api.g_number,
1568: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1569: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1570: p_parent_key_value4 in number default hr_api.g_number,
1571: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1572: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1573: p_parent_key_value5 in number default hr_api.g_number,
1574: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

Line 1571: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

1567: p_parent_key_value3 in number default hr_api.g_number,
1568: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1569: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1570: p_parent_key_value4 in number default hr_api.g_number,
1571: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1572: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1573: p_parent_key_value5 in number default hr_api.g_number,
1574: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1575: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

Line 1572: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

1568: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1569: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1570: p_parent_key_value4 in number default hr_api.g_number,
1571: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1572: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1573: p_parent_key_value5 in number default hr_api.g_number,
1574: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1575: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1576: p_parent_key_value6 in number default hr_api.g_number,

Line 1573: p_parent_key_value5 in number default hr_api.g_number,

1569: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1570: p_parent_key_value4 in number default hr_api.g_number,
1571: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1572: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1573: p_parent_key_value5 in number default hr_api.g_number,
1574: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1575: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1576: p_parent_key_value6 in number default hr_api.g_number,
1577: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

Line 1574: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

1570: p_parent_key_value4 in number default hr_api.g_number,
1571: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1572: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1573: p_parent_key_value5 in number default hr_api.g_number,
1574: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1575: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1576: p_parent_key_value6 in number default hr_api.g_number,
1577: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1578: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

Line 1575: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

1571: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1572: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1573: p_parent_key_value5 in number default hr_api.g_number,
1574: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1575: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1576: p_parent_key_value6 in number default hr_api.g_number,
1577: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1578: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1579: p_parent_key_value7 in number default hr_api.g_number,

Line 1576: p_parent_key_value6 in number default hr_api.g_number,

1572: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1573: p_parent_key_value5 in number default hr_api.g_number,
1574: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1575: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1576: p_parent_key_value6 in number default hr_api.g_number,
1577: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1578: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1579: p_parent_key_value7 in number default hr_api.g_number,
1580: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

Line 1577: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

1573: p_parent_key_value5 in number default hr_api.g_number,
1574: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1575: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1576: p_parent_key_value6 in number default hr_api.g_number,
1577: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1578: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1579: p_parent_key_value7 in number default hr_api.g_number,
1580: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1581: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

Line 1578: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

1574: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1575: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1576: p_parent_key_value6 in number default hr_api.g_number,
1577: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1578: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1579: p_parent_key_value7 in number default hr_api.g_number,
1580: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1581: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1582: p_parent_key_value8 in number default hr_api.g_number,

Line 1579: p_parent_key_value7 in number default hr_api.g_number,

1575: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1576: p_parent_key_value6 in number default hr_api.g_number,
1577: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1578: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1579: p_parent_key_value7 in number default hr_api.g_number,
1580: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1581: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1582: p_parent_key_value8 in number default hr_api.g_number,
1583: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

Line 1580: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

1576: p_parent_key_value6 in number default hr_api.g_number,
1577: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1578: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1579: p_parent_key_value7 in number default hr_api.g_number,
1580: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1581: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1582: p_parent_key_value8 in number default hr_api.g_number,
1583: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1584: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

Line 1581: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

1577: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1578: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1579: p_parent_key_value7 in number default hr_api.g_number,
1580: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1581: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1582: p_parent_key_value8 in number default hr_api.g_number,
1583: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1584: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1585: p_parent_key_value9 in number default hr_api.g_number,

Line 1582: p_parent_key_value8 in number default hr_api.g_number,

1578: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1579: p_parent_key_value7 in number default hr_api.g_number,
1580: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1581: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1582: p_parent_key_value8 in number default hr_api.g_number,
1583: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1584: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1585: p_parent_key_value9 in number default hr_api.g_number,
1586: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

Line 1583: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

1579: p_parent_key_value7 in number default hr_api.g_number,
1580: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1581: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1582: p_parent_key_value8 in number default hr_api.g_number,
1583: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1584: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1585: p_parent_key_value9 in number default hr_api.g_number,
1586: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1587: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

Line 1584: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

1580: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1581: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1582: p_parent_key_value8 in number default hr_api.g_number,
1583: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1584: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1585: p_parent_key_value9 in number default hr_api.g_number,
1586: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1587: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1588: p_parent_key_value10 in number default hr_api.g_number,

Line 1585: p_parent_key_value9 in number default hr_api.g_number,

1581: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1582: p_parent_key_value8 in number default hr_api.g_number,
1583: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1584: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1585: p_parent_key_value9 in number default hr_api.g_number,
1586: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1587: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1588: p_parent_key_value10 in number default hr_api.g_number,
1589: */

Line 1586: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

1582: p_parent_key_value8 in number default hr_api.g_number,
1583: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1584: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1585: p_parent_key_value9 in number default hr_api.g_number,
1586: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1587: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1588: p_parent_key_value10 in number default hr_api.g_number,
1589: */
1590: p_validation_start_date out nocopy date,

Line 1587: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

1583: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1584: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1585: p_parent_key_value9 in number default hr_api.g_number,
1586: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1587: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1588: p_parent_key_value10 in number default hr_api.g_number,
1589: */
1590: p_validation_start_date out nocopy date,
1591: p_validation_end_date out nocopy date) Is

Line 1588: p_parent_key_value10 in number default hr_api.g_number,

1584: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1585: p_parent_key_value9 in number default hr_api.g_number,
1586: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1587: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1588: p_parent_key_value10 in number default hr_api.g_number,
1589: */
1590: p_validation_start_date out nocopy date,
1591: p_validation_end_date out nocopy date) Is
1592: --

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

1607: --
1608: -- Providing the current effective end date is not the end of time
1609: -- then we must set the validation dates
1610: --
1611: If (l_effective_end_date <> HR_Api.g_eot) then
1612: --
1613: p_validation_start_date := l_effective_end_date + 1;
1614: l_validation_end_date :=
1615: Return_Min_Parent_End_Date

Line 1688: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

1684: (p_effective_date in date,
1685: p_base_table_name in varchar2,
1686: p_base_key_column in varchar2,
1687: p_base_key_value in number,
1688: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1690: p_parent_key_value1 in number default hr_api.g_number,
1691: /*
1692: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

Line 1689: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

1685: p_base_table_name in varchar2,
1686: p_base_key_column in varchar2,
1687: p_base_key_value in number,
1688: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1690: p_parent_key_value1 in number default hr_api.g_number,
1691: /*
1692: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1693: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

Line 1690: p_parent_key_value1 in number default hr_api.g_number,

1686: p_base_key_column in varchar2,
1687: p_base_key_value in number,
1688: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1690: p_parent_key_value1 in number default hr_api.g_number,
1691: /*
1692: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1693: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_value2 in number default hr_api.g_number,

Line 1692: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,

1688: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1689: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1690: p_parent_key_value1 in number default hr_api.g_number,
1691: /*
1692: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1693: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_value2 in number default hr_api.g_number,
1695: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1696: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

Line 1693: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,

1689: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1690: p_parent_key_value1 in number default hr_api.g_number,
1691: /*
1692: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1693: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_value2 in number default hr_api.g_number,
1695: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1696: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1697: p_parent_key_value3 in number default hr_api.g_number,

Line 1694: p_parent_key_value2 in number default hr_api.g_number,

1690: p_parent_key_value1 in number default hr_api.g_number,
1691: /*
1692: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1693: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_value2 in number default hr_api.g_number,
1695: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1696: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1697: p_parent_key_value3 in number default hr_api.g_number,
1698: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

Line 1695: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,

1691: /*
1692: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1693: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_value2 in number default hr_api.g_number,
1695: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1696: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1697: p_parent_key_value3 in number default hr_api.g_number,
1698: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1699: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

Line 1696: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,

1692: p_parent_table_name2 in varchar2 default hr_api.g_varchar2,
1693: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_value2 in number default hr_api.g_number,
1695: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1696: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1697: p_parent_key_value3 in number default hr_api.g_number,
1698: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1699: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1700: p_parent_key_value4 in number default hr_api.g_number,

Line 1697: p_parent_key_value3 in number default hr_api.g_number,

1693: p_parent_key_column2 in varchar2 default hr_api.g_varchar2,
1694: p_parent_key_value2 in number default hr_api.g_number,
1695: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1696: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1697: p_parent_key_value3 in number default hr_api.g_number,
1698: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1699: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1700: p_parent_key_value4 in number default hr_api.g_number,
1701: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

Line 1698: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,

1694: p_parent_key_value2 in number default hr_api.g_number,
1695: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1696: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1697: p_parent_key_value3 in number default hr_api.g_number,
1698: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1699: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1700: p_parent_key_value4 in number default hr_api.g_number,
1701: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1702: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

Line 1699: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,

1695: p_parent_table_name3 in varchar2 default hr_api.g_varchar2,
1696: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1697: p_parent_key_value3 in number default hr_api.g_number,
1698: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1699: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1700: p_parent_key_value4 in number default hr_api.g_number,
1701: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1702: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1703: p_parent_key_value5 in number default hr_api.g_number,

Line 1700: p_parent_key_value4 in number default hr_api.g_number,

1696: p_parent_key_column3 in varchar2 default hr_api.g_varchar2,
1697: p_parent_key_value3 in number default hr_api.g_number,
1698: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1699: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1700: p_parent_key_value4 in number default hr_api.g_number,
1701: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1702: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1703: p_parent_key_value5 in number default hr_api.g_number,
1704: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

Line 1701: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,

1697: p_parent_key_value3 in number default hr_api.g_number,
1698: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1699: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1700: p_parent_key_value4 in number default hr_api.g_number,
1701: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1702: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1703: p_parent_key_value5 in number default hr_api.g_number,
1704: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1705: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

Line 1702: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,

1698: p_parent_table_name4 in varchar2 default hr_api.g_varchar2,
1699: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1700: p_parent_key_value4 in number default hr_api.g_number,
1701: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1702: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1703: p_parent_key_value5 in number default hr_api.g_number,
1704: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1705: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1706: p_parent_key_value6 in number default hr_api.g_number,

Line 1703: p_parent_key_value5 in number default hr_api.g_number,

1699: p_parent_key_column4 in varchar2 default hr_api.g_varchar2,
1700: p_parent_key_value4 in number default hr_api.g_number,
1701: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1702: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1703: p_parent_key_value5 in number default hr_api.g_number,
1704: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1705: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1706: p_parent_key_value6 in number default hr_api.g_number,
1707: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

Line 1704: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,

1700: p_parent_key_value4 in number default hr_api.g_number,
1701: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1702: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1703: p_parent_key_value5 in number default hr_api.g_number,
1704: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1705: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1706: p_parent_key_value6 in number default hr_api.g_number,
1707: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1708: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

Line 1705: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,

1701: p_parent_table_name5 in varchar2 default hr_api.g_varchar2,
1702: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1703: p_parent_key_value5 in number default hr_api.g_number,
1704: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1705: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1706: p_parent_key_value6 in number default hr_api.g_number,
1707: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1708: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1709: p_parent_key_value7 in number default hr_api.g_number,

Line 1706: p_parent_key_value6 in number default hr_api.g_number,

1702: p_parent_key_column5 in varchar2 default hr_api.g_varchar2,
1703: p_parent_key_value5 in number default hr_api.g_number,
1704: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1705: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1706: p_parent_key_value6 in number default hr_api.g_number,
1707: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1708: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1709: p_parent_key_value7 in number default hr_api.g_number,
1710: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

Line 1707: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,

1703: p_parent_key_value5 in number default hr_api.g_number,
1704: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1705: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1706: p_parent_key_value6 in number default hr_api.g_number,
1707: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1708: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1709: p_parent_key_value7 in number default hr_api.g_number,
1710: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1711: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

Line 1708: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,

1704: p_parent_table_name6 in varchar2 default hr_api.g_varchar2,
1705: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1706: p_parent_key_value6 in number default hr_api.g_number,
1707: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1708: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1709: p_parent_key_value7 in number default hr_api.g_number,
1710: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1711: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1712: p_parent_key_value8 in number default hr_api.g_number,

Line 1709: p_parent_key_value7 in number default hr_api.g_number,

1705: p_parent_key_column6 in varchar2 default hr_api.g_varchar2,
1706: p_parent_key_value6 in number default hr_api.g_number,
1707: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1708: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1709: p_parent_key_value7 in number default hr_api.g_number,
1710: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1711: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1712: p_parent_key_value8 in number default hr_api.g_number,
1713: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

Line 1710: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,

1706: p_parent_key_value6 in number default hr_api.g_number,
1707: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1708: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1709: p_parent_key_value7 in number default hr_api.g_number,
1710: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1711: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1712: p_parent_key_value8 in number default hr_api.g_number,
1713: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1714: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

Line 1711: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,

1707: p_parent_table_name7 in varchar2 default hr_api.g_varchar2,
1708: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1709: p_parent_key_value7 in number default hr_api.g_number,
1710: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1711: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1712: p_parent_key_value8 in number default hr_api.g_number,
1713: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1714: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1715: p_parent_key_value9 in number default hr_api.g_number,

Line 1712: p_parent_key_value8 in number default hr_api.g_number,

1708: p_parent_key_column7 in varchar2 default hr_api.g_varchar2,
1709: p_parent_key_value7 in number default hr_api.g_number,
1710: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1711: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1712: p_parent_key_value8 in number default hr_api.g_number,
1713: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1714: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1715: p_parent_key_value9 in number default hr_api.g_number,
1716: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

Line 1713: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,

1709: p_parent_key_value7 in number default hr_api.g_number,
1710: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1711: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1712: p_parent_key_value8 in number default hr_api.g_number,
1713: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1714: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1715: p_parent_key_value9 in number default hr_api.g_number,
1716: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1717: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

Line 1714: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,

1710: p_parent_table_name8 in varchar2 default hr_api.g_varchar2,
1711: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1712: p_parent_key_value8 in number default hr_api.g_number,
1713: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1714: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1715: p_parent_key_value9 in number default hr_api.g_number,
1716: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1717: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1718: p_parent_key_value10 in number default hr_api.g_number,

Line 1715: p_parent_key_value9 in number default hr_api.g_number,

1711: p_parent_key_column8 in varchar2 default hr_api.g_varchar2,
1712: p_parent_key_value8 in number default hr_api.g_number,
1713: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1714: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1715: p_parent_key_value9 in number default hr_api.g_number,
1716: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1717: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1718: p_parent_key_value10 in number default hr_api.g_number,
1719: */

Line 1716: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,

1712: p_parent_key_value8 in number default hr_api.g_number,
1713: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1714: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1715: p_parent_key_value9 in number default hr_api.g_number,
1716: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1717: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1718: p_parent_key_value10 in number default hr_api.g_number,
1719: */
1720: p_validation_start_date out nocopy date,

Line 1717: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,

1713: p_parent_table_name9 in varchar2 default hr_api.g_varchar2,
1714: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1715: p_parent_key_value9 in number default hr_api.g_number,
1716: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1717: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1718: p_parent_key_value10 in number default hr_api.g_number,
1719: */
1720: p_validation_start_date out nocopy date,
1721: p_validation_end_date out nocopy date) Is

Line 1718: p_parent_key_value10 in number default hr_api.g_number,

1714: p_parent_key_column9 in varchar2 default hr_api.g_varchar2,
1715: p_parent_key_value9 in number default hr_api.g_number,
1716: p_parent_table_name10 in varchar2 default hr_api.g_varchar2,
1717: p_parent_key_column10 in varchar2 default hr_api.g_varchar2,
1718: p_parent_key_value10 in number default hr_api.g_number,
1719: */
1720: p_validation_start_date out nocopy date,
1721: p_validation_end_date out nocopy date) Is
1722: --

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

1741: --
1742: -- Providing the current effective end date is not the end of time
1743: -- then we must set the validation dates
1744: --
1745: If (l_effective_end_date <> HR_Api.g_eot) then
1746: --
1747: l_validation_start_date := l_effective_end_date + 1;
1748: p_validation_start_date := l_validation_start_date;
1749: --

Line 1898: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,

1894: p_effective_date in date,
1895: p_base_table_name in varchar2,
1896: p_base_key_column in varchar2,
1897: p_base_key_value in number,
1898: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1899: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1900: p_parent_key_value1 in number default hr_api.g_number,
1901: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1902: p_child_key_column1 in varchar2 default hr_api.g_varchar2,

Line 1899: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,

1895: p_base_table_name in varchar2,
1896: p_base_key_column in varchar2,
1897: p_base_key_value in number,
1898: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1899: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1900: p_parent_key_value1 in number default hr_api.g_number,
1901: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1902: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1903: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,

Line 1900: p_parent_key_value1 in number default hr_api.g_number,

1896: p_base_key_column in varchar2,
1897: p_base_key_value in number,
1898: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1899: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1900: p_parent_key_value1 in number default hr_api.g_number,
1901: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1902: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1903: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1904: p_child_table_name2 in varchar2 default hr_api.g_varchar2,

Line 1901: p_child_table_name1 in varchar2 default hr_api.g_varchar2,

1897: p_base_key_value in number,
1898: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1899: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1900: p_parent_key_value1 in number default hr_api.g_number,
1901: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1902: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1903: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1904: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1905: p_child_key_column2 in varchar2 default hr_api.g_varchar2,

Line 1902: p_child_key_column1 in varchar2 default hr_api.g_varchar2,

1898: p_parent_table_name1 in varchar2 default hr_api.g_varchar2,
1899: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1900: p_parent_key_value1 in number default hr_api.g_number,
1901: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1902: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1903: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1904: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1905: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1906: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,

Line 1903: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,

1899: p_parent_key_column1 in varchar2 default hr_api.g_varchar2,
1900: p_parent_key_value1 in number default hr_api.g_number,
1901: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1902: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1903: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1904: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1905: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1906: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1907: p_enforce_foreign_locking in boolean default true,

Line 1904: p_child_table_name2 in varchar2 default hr_api.g_varchar2,

1900: p_parent_key_value1 in number default hr_api.g_number,
1901: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1902: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1903: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1904: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1905: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1906: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1907: p_enforce_foreign_locking in boolean default true,
1908: p_validation_start_date out nocopy date,

Line 1905: p_child_key_column2 in varchar2 default hr_api.g_varchar2,

1901: p_child_table_name1 in varchar2 default hr_api.g_varchar2,
1902: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1903: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1904: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1905: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1906: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1907: p_enforce_foreign_locking in boolean default true,
1908: p_validation_start_date out nocopy date,
1909: p_validation_end_date out nocopy date) Is

Line 1906: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,

1902: p_child_key_column1 in varchar2 default hr_api.g_varchar2,
1903: p_child_fk_column1 in varchar2 default hr_api.g_varchar2,
1904: p_child_table_name2 in varchar2 default hr_api.g_varchar2,
1905: p_child_key_column2 in varchar2 default hr_api.g_varchar2,
1906: p_child_fk_column2 in varchar2 default hr_api.g_varchar2,
1907: p_enforce_foreign_locking in boolean default true,
1908: p_validation_start_date out nocopy date,
1909: p_validation_end_date out nocopy date) Is
1910: --

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

1918: Effective_Date_Valid(p_effective_date => p_effective_date);
1919: --
1920: -- Ensure that all the mandatory arguments are not null
1921: --
1922: hr_api.mandatory_arg_error(p_api_name => l_proc,
1923: p_argument => 'p_datetrack_mode',
1924: p_argument_value => p_datetrack_mode);
1925: hr_api.mandatory_arg_error(p_api_name => l_proc,
1926: p_argument => 'p_base_table_name',

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

1921: --
1922: hr_api.mandatory_arg_error(p_api_name => l_proc,
1923: p_argument => 'p_datetrack_mode',
1924: p_argument_value => p_datetrack_mode);
1925: hr_api.mandatory_arg_error(p_api_name => l_proc,
1926: p_argument => 'p_base_table_name',
1927: p_argument_value => p_base_table_name);
1928: hr_api.mandatory_arg_error(p_api_name => l_proc,
1929: p_argument => 'p_base_key_column',

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

1924: p_argument_value => p_datetrack_mode);
1925: hr_api.mandatory_arg_error(p_api_name => l_proc,
1926: p_argument => 'p_base_table_name',
1927: p_argument_value => p_base_table_name);
1928: hr_api.mandatory_arg_error(p_api_name => l_proc,
1929: p_argument => 'p_base_key_column',
1930: p_argument_value => p_base_key_column);
1931: --
1932: -- Determine if any entity range row locking is required

Line 1934: If (l_datetrack_mode = hr_api.g_update_override or

1930: p_argument_value => p_base_key_column);
1931: --
1932: -- Determine if any entity range row locking is required
1933: --
1934: If (l_datetrack_mode = hr_api.g_update_override or
1935: l_datetrack_mode = hr_api.g_delete or
1936: l_datetrack_mode = hr_api.g_future_change or
1937: l_datetrack_mode = hr_api.g_delete_next_change) then
1938: --

Line 1935: l_datetrack_mode = hr_api.g_delete or

1931: --
1932: -- Determine if any entity range row locking is required
1933: --
1934: If (l_datetrack_mode = hr_api.g_update_override or
1935: l_datetrack_mode = hr_api.g_delete or
1936: l_datetrack_mode = hr_api.g_future_change or
1937: l_datetrack_mode = hr_api.g_delete_next_change) then
1938: --
1939: -- Perform the entity range row locking processing

Line 1936: l_datetrack_mode = hr_api.g_future_change or

1932: -- Determine if any entity range row locking is required
1933: --
1934: If (l_datetrack_mode = hr_api.g_update_override or
1935: l_datetrack_mode = hr_api.g_delete or
1936: l_datetrack_mode = hr_api.g_future_change or
1937: l_datetrack_mode = hr_api.g_delete_next_change) then
1938: --
1939: -- Perform the entity range row locking processing
1940: --

Line 1937: l_datetrack_mode = hr_api.g_delete_next_change) then

1933: --
1934: If (l_datetrack_mode = hr_api.g_update_override or
1935: l_datetrack_mode = hr_api.g_delete or
1936: l_datetrack_mode = hr_api.g_future_change or
1937: l_datetrack_mode = hr_api.g_delete_next_change) then
1938: --
1939: -- Perform the entity range row locking processing
1940: --
1941: Lck_Future_Rows

Line 1947: ElsIf l_datetrack_mode = hr_api.g_zap then

1943: p_table_name => p_base_table_name,
1944: p_key_column => p_base_key_column,
1945: p_key_value => p_base_key_value);
1946: --
1947: ElsIf l_datetrack_mode = hr_api.g_zap then
1948: -- As we are performing a ZAP we must lock all rows from
1949: -- the start of time
1950: Lck_Future_Rows
1951: (p_effective_date => hr_api.g_sot,

Line 1951: (p_effective_date => hr_api.g_sot,

1947: ElsIf l_datetrack_mode = hr_api.g_zap then
1948: -- As we are performing a ZAP we must lock all rows from
1949: -- the start of time
1950: Lck_Future_Rows
1951: (p_effective_date => hr_api.g_sot,
1952: p_table_name => p_base_table_name,
1953: p_key_column => p_base_key_column,
1954: p_key_value => p_base_key_value);
1955: --

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

1954: p_key_value => p_base_key_value);
1955: --
1956: End If;
1957: --
1958: If (l_datetrack_mode = hr_api.g_insert) then
1959: --
1960: Get_Insert_Dates
1961: (p_effective_date => p_effective_date,
1962: p_base_table_name => p_base_table_name,

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

1997: p_enforce_foreign_locking => p_enforce_foreign_locking,
1998: p_validation_start_date => p_validation_start_date,
1999: p_validation_end_date => p_validation_end_date);
2000: --
2001: ElsIf (l_datetrack_mode = hr_api.g_correction) then
2002: --
2003: Get_Correction_Dates
2004: (p_effective_date => p_effective_date,
2005: p_base_table_name => p_base_table_name,

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

2007: p_base_key_value => p_base_key_value,
2008: p_validation_start_date => p_validation_start_date,
2009: p_validation_end_date => p_validation_end_date);
2010: --
2011: ElsIf (l_datetrack_mode = hr_api.g_update) then
2012: --
2013: Get_Update_Dates
2014: (p_effective_date => p_effective_date,
2015: p_base_table_name => p_base_table_name,

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

2017: p_base_key_value => p_base_key_value,
2018: p_validation_start_date => p_validation_start_date,
2019: p_validation_end_date => p_validation_end_date);
2020: --
2021: ElsIf (l_datetrack_mode = hr_api.g_update_override) then
2022: --
2023: Get_Update_Override_Dates
2024: (p_effective_date => p_effective_date,
2025: p_base_table_name => p_base_table_name,

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

2027: p_base_key_value => p_base_key_value,
2028: p_validation_start_date => p_validation_start_date,
2029: p_validation_end_date => p_validation_end_date);
2030: --
2031: ElsIf (l_datetrack_mode = hr_api.g_update_change_insert) then
2032: --
2033: Get_Update_Change_Insert_Dates
2034: (p_effective_date => p_effective_date,
2035: p_base_table_name => p_base_table_name,

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

2037: p_base_key_value => p_base_key_value,
2038: p_validation_start_date => p_validation_start_date,
2039: p_validation_end_date => p_validation_end_date);
2040: --
2041: ElsIf (l_datetrack_mode = hr_api.g_zap) then
2042: --
2043: Get_Zap_Dates
2044: (p_effective_date => p_effective_date,
2045: p_base_table_name => p_base_table_name,

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

2047: p_base_key_value => p_base_key_value,
2048: p_validation_start_date => p_validation_start_date,
2049: p_validation_end_date => p_validation_end_date);
2050: --
2051: ElsIf (l_datetrack_mode = hr_api.g_delete) then
2052: -- if (l_datetrack_mode = hr_api.g_delete) then
2053: --
2054: Get_Delete_Dates
2055: (p_effective_date => p_effective_date,

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

2048: p_validation_start_date => p_validation_start_date,
2049: p_validation_end_date => p_validation_end_date);
2050: --
2051: ElsIf (l_datetrack_mode = hr_api.g_delete) then
2052: -- if (l_datetrack_mode = hr_api.g_delete) then
2053: --
2054: Get_Delete_Dates
2055: (p_effective_date => p_effective_date,
2056: p_base_table_name => p_base_table_name,

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

2065: p_enforce_foreign_locking => p_enforce_foreign_locking,
2066: p_validation_start_date => p_validation_start_date,
2067: p_validation_end_date => p_validation_end_date);
2068: --
2069: ElsIf (l_datetrack_mode = hr_api.g_future_change) then
2070: --
2071: Get_Future_Change_Dates
2072: (p_effective_date => p_effective_date,
2073: p_base_table_name => p_base_table_name,

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

2107: */
2108: p_validation_start_date => p_validation_start_date,
2109: p_validation_end_date => p_validation_end_date);
2110: --
2111: ElsIf (l_datetrack_mode = hr_api.g_delete_next_change) then
2112: --
2113: Get_Delete_Next_Change_Dates
2114: (p_effective_date => p_effective_date,
2115: p_base_table_name => p_base_table_name,

Line 2369: hr_api.mandatory_arg_error(p_api_name => l_proc

2365: hr_utility.set_location('Entering:'||l_proc, 5);
2366: --
2367: -- Ensure that all the mandatory arguments are not null
2368: --
2369: hr_api.mandatory_arg_error(p_api_name => l_proc
2370: ,p_argument => 'effective_date'
2371: ,p_argument_value => p_effective_date
2372: );
2373: --

Line 2374: hr_api.mandatory_arg_error(p_api_name => l_proc

2370: ,p_argument => 'effective_date'
2371: ,p_argument_value => p_effective_date
2372: );
2373: --
2374: hr_api.mandatory_arg_error(p_api_name => l_proc
2375: ,p_argument => 'datetrack_mode'
2376: ,p_argument_value => p_datetrack_mode
2377: );
2378: --

Line 2379: hr_api.mandatory_arg_error(p_api_name => l_proc

2375: ,p_argument => 'datetrack_mode'
2376: ,p_argument_value => p_datetrack_mode
2377: );
2378: --
2379: hr_api.mandatory_arg_error(p_api_name => l_proc
2380: ,p_argument => 'run_type_id'
2381: ,p_argument_value => p_run_type_id
2382: );
2383: --

Line 2384: hr_api.mandatory_arg_error(p_api_name => l_proc

2380: ,p_argument => 'run_type_id'
2381: ,p_argument_value => p_run_type_id
2382: );
2383: --
2384: hr_api.mandatory_arg_error(p_api_name => l_proc
2385: ,p_argument => 'object_version_number'
2386: ,p_argument_value => p_object_version_number
2387: );
2388: --

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

2387: );
2388: --
2389: -- Check to ensure the datetrack mode is not INSERT.
2390: --
2391: If (p_datetrack_mode <> hr_api.g_insert) then
2392: --
2393: -- We must select and lock the current row.
2394: --
2395: Open C_Sel1;

Line 2473: When HR_Api.Object_Locked then

2469: --
2470: -- We need to trap the ORA LOCK exception
2471: --
2472: Exception
2473: When HR_Api.Object_Locked then
2474: --
2475: -- The object is locked therefore we need to supply a meaningful
2476: -- error message.
2477: --