eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DT_API dependencies on HR_API

Line 14: -- set private package vars once to avoid cross package calls to hr_api

10: g_dynamic_sql_comment CONSTANT VARCHAR2(500) :=
11: ' /* dynamic SQL from dt_api.{proc} for'||
12: ' ORACLE '||TO_CHAR(g_oracle_db_version)||' */'; -- dynamic SQL comment str
13: g_dynamic_sql VARCHAR2(2000); -- dynamic SQL text string
14: -- set private package vars once to avoid cross package calls to hr_api
15: -- even though it might be redundant because they are defined as
16: -- constants in hr_api.
17: g_sot CONSTANT DATE := hr_api.g_sot;
18: g_eot CONSTANT DATE := hr_api.g_eot;

Line 16: -- constants in hr_api.

12: ' ORACLE '||TO_CHAR(g_oracle_db_version)||' */'; -- dynamic SQL comment str
13: g_dynamic_sql VARCHAR2(2000); -- dynamic SQL text string
14: -- set private package vars once to avoid cross package calls to hr_api
15: -- even though it might be redundant because they are defined as
16: -- constants in hr_api.
17: g_sot CONSTANT DATE := hr_api.g_sot;
18: g_eot CONSTANT DATE := hr_api.g_eot;
19: g_insert CONSTANT VARCHAR2(30) := hr_api.g_insert;
20: g_correction CONSTANT VARCHAR2(30) := hr_api.g_correction;

Line 17: g_sot CONSTANT DATE := hr_api.g_sot;

13: g_dynamic_sql VARCHAR2(2000); -- dynamic SQL text string
14: -- set private package vars once to avoid cross package calls to hr_api
15: -- even though it might be redundant because they are defined as
16: -- constants in hr_api.
17: g_sot CONSTANT DATE := hr_api.g_sot;
18: g_eot CONSTANT DATE := hr_api.g_eot;
19: g_insert CONSTANT VARCHAR2(30) := hr_api.g_insert;
20: g_correction CONSTANT VARCHAR2(30) := hr_api.g_correction;
21: g_update CONSTANT VARCHAR2(30) := hr_api.g_update;

Line 18: g_eot CONSTANT DATE := hr_api.g_eot;

14: -- set private package vars once to avoid cross package calls to hr_api
15: -- even though it might be redundant because they are defined as
16: -- constants in hr_api.
17: g_sot CONSTANT DATE := hr_api.g_sot;
18: g_eot CONSTANT DATE := hr_api.g_eot;
19: g_insert CONSTANT VARCHAR2(30) := hr_api.g_insert;
20: g_correction CONSTANT VARCHAR2(30) := hr_api.g_correction;
21: g_update CONSTANT VARCHAR2(30) := hr_api.g_update;
22: g_update_override CONSTANT VARCHAR2(30) := hr_api.g_update_override;

Line 19: g_insert CONSTANT VARCHAR2(30) := hr_api.g_insert;

15: -- even though it might be redundant because they are defined as
16: -- constants in hr_api.
17: g_sot CONSTANT DATE := hr_api.g_sot;
18: g_eot CONSTANT DATE := hr_api.g_eot;
19: g_insert CONSTANT VARCHAR2(30) := hr_api.g_insert;
20: g_correction CONSTANT VARCHAR2(30) := hr_api.g_correction;
21: g_update CONSTANT VARCHAR2(30) := hr_api.g_update;
22: g_update_override CONSTANT VARCHAR2(30) := hr_api.g_update_override;
23: g_update_change_insert CONSTANT VARCHAR2(30) := hr_api.g_update_change_insert;

Line 20: g_correction CONSTANT VARCHAR2(30) := hr_api.g_correction;

16: -- constants in hr_api.
17: g_sot CONSTANT DATE := hr_api.g_sot;
18: g_eot CONSTANT DATE := hr_api.g_eot;
19: g_insert CONSTANT VARCHAR2(30) := hr_api.g_insert;
20: g_correction CONSTANT VARCHAR2(30) := hr_api.g_correction;
21: g_update CONSTANT VARCHAR2(30) := hr_api.g_update;
22: g_update_override CONSTANT VARCHAR2(30) := hr_api.g_update_override;
23: g_update_change_insert CONSTANT VARCHAR2(30) := hr_api.g_update_change_insert;
24: g_zap CONSTANT VARCHAR2(30) := hr_api.g_zap;

Line 21: g_update CONSTANT VARCHAR2(30) := hr_api.g_update;

17: g_sot CONSTANT DATE := hr_api.g_sot;
18: g_eot CONSTANT DATE := hr_api.g_eot;
19: g_insert CONSTANT VARCHAR2(30) := hr_api.g_insert;
20: g_correction CONSTANT VARCHAR2(30) := hr_api.g_correction;
21: g_update CONSTANT VARCHAR2(30) := hr_api.g_update;
22: g_update_override CONSTANT VARCHAR2(30) := hr_api.g_update_override;
23: g_update_change_insert CONSTANT VARCHAR2(30) := hr_api.g_update_change_insert;
24: g_zap CONSTANT VARCHAR2(30) := hr_api.g_zap;
25: g_delete CONSTANT VARCHAR2(30) := hr_api.g_delete;

Line 22: g_update_override CONSTANT VARCHAR2(30) := hr_api.g_update_override;

18: g_eot CONSTANT DATE := hr_api.g_eot;
19: g_insert CONSTANT VARCHAR2(30) := hr_api.g_insert;
20: g_correction CONSTANT VARCHAR2(30) := hr_api.g_correction;
21: g_update CONSTANT VARCHAR2(30) := hr_api.g_update;
22: g_update_override CONSTANT VARCHAR2(30) := hr_api.g_update_override;
23: g_update_change_insert CONSTANT VARCHAR2(30) := hr_api.g_update_change_insert;
24: g_zap CONSTANT VARCHAR2(30) := hr_api.g_zap;
25: g_delete CONSTANT VARCHAR2(30) := hr_api.g_delete;
26: g_future_change CONSTANT VARCHAR2(30) := hr_api.g_future_change;

Line 23: g_update_change_insert CONSTANT VARCHAR2(30) := hr_api.g_update_change_insert;

19: g_insert CONSTANT VARCHAR2(30) := hr_api.g_insert;
20: g_correction CONSTANT VARCHAR2(30) := hr_api.g_correction;
21: g_update CONSTANT VARCHAR2(30) := hr_api.g_update;
22: g_update_override CONSTANT VARCHAR2(30) := hr_api.g_update_override;
23: g_update_change_insert CONSTANT VARCHAR2(30) := hr_api.g_update_change_insert;
24: g_zap CONSTANT VARCHAR2(30) := hr_api.g_zap;
25: g_delete CONSTANT VARCHAR2(30) := hr_api.g_delete;
26: g_future_change CONSTANT VARCHAR2(30) := hr_api.g_future_change;
27: g_delete_next_change CONSTANT VARCHAR2(30) := hr_api.g_delete_next_change;

Line 24: g_zap CONSTANT VARCHAR2(30) := hr_api.g_zap;

20: g_correction CONSTANT VARCHAR2(30) := hr_api.g_correction;
21: g_update CONSTANT VARCHAR2(30) := hr_api.g_update;
22: g_update_override CONSTANT VARCHAR2(30) := hr_api.g_update_override;
23: g_update_change_insert CONSTANT VARCHAR2(30) := hr_api.g_update_change_insert;
24: g_zap CONSTANT VARCHAR2(30) := hr_api.g_zap;
25: g_delete CONSTANT VARCHAR2(30) := hr_api.g_delete;
26: g_future_change CONSTANT VARCHAR2(30) := hr_api.g_future_change;
27: g_delete_next_change CONSTANT VARCHAR2(30) := hr_api.g_delete_next_change;
28: g_varchar2 CONSTANT VARCHAR2(9) := hr_api.g_varchar2;

Line 25: g_delete CONSTANT VARCHAR2(30) := hr_api.g_delete;

21: g_update CONSTANT VARCHAR2(30) := hr_api.g_update;
22: g_update_override CONSTANT VARCHAR2(30) := hr_api.g_update_override;
23: g_update_change_insert CONSTANT VARCHAR2(30) := hr_api.g_update_change_insert;
24: g_zap CONSTANT VARCHAR2(30) := hr_api.g_zap;
25: g_delete CONSTANT VARCHAR2(30) := hr_api.g_delete;
26: g_future_change CONSTANT VARCHAR2(30) := hr_api.g_future_change;
27: g_delete_next_change CONSTANT VARCHAR2(30) := hr_api.g_delete_next_change;
28: g_varchar2 CONSTANT VARCHAR2(9) := hr_api.g_varchar2;
29: g_number CONSTANT NUMBER := hr_api.g_number;

Line 26: g_future_change CONSTANT VARCHAR2(30) := hr_api.g_future_change;

22: g_update_override CONSTANT VARCHAR2(30) := hr_api.g_update_override;
23: g_update_change_insert CONSTANT VARCHAR2(30) := hr_api.g_update_change_insert;
24: g_zap CONSTANT VARCHAR2(30) := hr_api.g_zap;
25: g_delete CONSTANT VARCHAR2(30) := hr_api.g_delete;
26: g_future_change CONSTANT VARCHAR2(30) := hr_api.g_future_change;
27: g_delete_next_change CONSTANT VARCHAR2(30) := hr_api.g_delete_next_change;
28: g_varchar2 CONSTANT VARCHAR2(9) := hr_api.g_varchar2;
29: g_number CONSTANT NUMBER := hr_api.g_number;
30: g_date CONSTANT DATE := hr_api.g_date;

Line 27: g_delete_next_change CONSTANT VARCHAR2(30) := hr_api.g_delete_next_change;

23: g_update_change_insert CONSTANT VARCHAR2(30) := hr_api.g_update_change_insert;
24: g_zap CONSTANT VARCHAR2(30) := hr_api.g_zap;
25: g_delete CONSTANT VARCHAR2(30) := hr_api.g_delete;
26: g_future_change CONSTANT VARCHAR2(30) := hr_api.g_future_change;
27: g_delete_next_change CONSTANT VARCHAR2(30) := hr_api.g_delete_next_change;
28: g_varchar2 CONSTANT VARCHAR2(9) := hr_api.g_varchar2;
29: g_number CONSTANT NUMBER := hr_api.g_number;
30: g_date CONSTANT DATE := hr_api.g_date;
31: -- define the effective rows record type

Line 28: g_varchar2 CONSTANT VARCHAR2(9) := hr_api.g_varchar2;

24: g_zap CONSTANT VARCHAR2(30) := hr_api.g_zap;
25: g_delete CONSTANT VARCHAR2(30) := hr_api.g_delete;
26: g_future_change CONSTANT VARCHAR2(30) := hr_api.g_future_change;
27: g_delete_next_change CONSTANT VARCHAR2(30) := hr_api.g_delete_next_change;
28: g_varchar2 CONSTANT VARCHAR2(9) := hr_api.g_varchar2;
29: g_number CONSTANT NUMBER := hr_api.g_number;
30: g_date CONSTANT DATE := hr_api.g_date;
31: -- define the effective rows record type
32: TYPE g_dt_effective_rows_rec IS RECORD

Line 29: g_number CONSTANT NUMBER := hr_api.g_number;

25: g_delete CONSTANT VARCHAR2(30) := hr_api.g_delete;
26: g_future_change CONSTANT VARCHAR2(30) := hr_api.g_future_change;
27: g_delete_next_change CONSTANT VARCHAR2(30) := hr_api.g_delete_next_change;
28: g_varchar2 CONSTANT VARCHAR2(9) := hr_api.g_varchar2;
29: g_number CONSTANT NUMBER := hr_api.g_number;
30: g_date CONSTANT DATE := hr_api.g_date;
31: -- define the effective rows record type
32: TYPE g_dt_effective_rows_rec IS RECORD
33: (effective_start_date DATE,

Line 30: g_date CONSTANT DATE := hr_api.g_date;

26: g_future_change CONSTANT VARCHAR2(30) := hr_api.g_future_change;
27: g_delete_next_change CONSTANT VARCHAR2(30) := hr_api.g_delete_next_change;
28: g_varchar2 CONSTANT VARCHAR2(9) := hr_api.g_varchar2;
29: g_number CONSTANT NUMBER := hr_api.g_number;
30: g_date CONSTANT DATE := hr_api.g_date;
31: -- define the effective rows record type
32: TYPE g_dt_effective_rows_rec IS RECORD
33: (effective_start_date DATE,
34: effective_end_date DATE);

Line 181: WHEN hr_api.object_locked THEN

177: -- therefore a serious integrity problem has ocurred
178: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
179: hr_utility.set_message_token('ARGUMENT', UPPER(p_base_key_column));
180: hr_utility.raise_error;
181: WHEN hr_api.object_locked THEN
182: -- close the cursor if open
183: IF l_csr%ISOPEN THEN
184: CLOSE l_csr;
185: END IF;

Line 387: WHEN hr_api.object_locked THEN

383: -- bug 3788667
384: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
385: hr_utility.set_message_token('ARGUMENT', UPPER(l_key_column));
386: hr_utility.raise_error;
387: WHEN hr_api.object_locked THEN
388: -- CLOSE the cursor if its open
389: IF l_csr%ISOPEN THEN
390: CLOSE l_csr;
391: END IF;

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

423: END IF;
424: -- Ensure that all the mandatory arguments are not null
425: -- [ start of change 30.14 ]
426: IF p_effective_date IS NULL THEN
427: hr_api.mandatory_arg_error(p_api_name => l_proc,
428: p_argument => 'p_effective_date',
429: p_argument_value => p_effective_date);
430: END IF;
431: -- [ end of change 30.14 ]

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

483: -- Ensure that all the mandatory arguments are not null
484: -- [ start of change 30.14 ]
485: IF p_base_table_name IS NULL OR p_base_key_column IS NULL OR
486: p_base_key_value IS NULL THEN
487: hr_api.mandatory_arg_error(p_api_name => l_proc,
488: p_argument => 'p_base_table_name',
489: p_argument_value => p_base_table_name);
490: hr_api.mandatory_arg_error(p_api_name => l_proc,
491: p_argument => 'p_base_key_column',

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

486: p_base_key_value IS NULL THEN
487: hr_api.mandatory_arg_error(p_api_name => l_proc,
488: p_argument => 'p_base_table_name',
489: p_argument_value => p_base_table_name);
490: hr_api.mandatory_arg_error(p_api_name => l_proc,
491: p_argument => 'p_base_key_column',
492: p_argument_value => p_base_key_column);
493: hr_api.mandatory_arg_error(p_api_name => l_proc,
494: p_argument => 'p_base_key_value',

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

489: p_argument_value => p_base_table_name);
490: hr_api.mandatory_arg_error(p_api_name => l_proc,
491: p_argument => 'p_base_key_column',
492: p_argument_value => p_base_key_column);
493: hr_api.mandatory_arg_error(p_api_name => l_proc,
494: p_argument => 'p_base_key_value',
495: p_argument_value => p_base_key_value);
496: END IF;
497: -- [ end of change 30.14 ]

Line 564: -- hr_api.mandatory_arg_error(p_api_name => l_proc,

560: -- Note: we don't check the p_parent_key_value argument
561: --
562: -- [ start of change 30.14 ]
563: --
564: -- hr_api.mandatory_arg_error(p_api_name => l_proc,
565: -- p_argument => 'p_child_table_name',
566: -- p_argument_value => p_child_table_name);
567: -- hr_api.mandatory_arg_error(p_api_name => l_proc,
568: -- p_argument => 'p_child_key_column',

Line 567: -- hr_api.mandatory_arg_error(p_api_name => l_proc,

563: --
564: -- hr_api.mandatory_arg_error(p_api_name => l_proc,
565: -- p_argument => 'p_child_table_name',
566: -- p_argument_value => p_child_table_name);
567: -- hr_api.mandatory_arg_error(p_api_name => l_proc,
568: -- p_argument => 'p_child_key_column',
569: -- p_argument_value => p_child_key_column);
570: IF p_parent_key_column IS NULL THEN
571: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

567: -- hr_api.mandatory_arg_error(p_api_name => l_proc,
568: -- p_argument => 'p_child_key_column',
569: -- p_argument_value => p_child_key_column);
570: IF p_parent_key_column IS NULL THEN
571: hr_api.mandatory_arg_error(p_api_name => l_proc,
572: p_argument => 'p_parent_key_column',
573: p_argument_value => p_parent_key_column);
574: END IF;
575: -- Define dynamic sql text with substitution tokens

Line 638: WHEN hr_api.object_locked THEN

634: IF g_debug THEN
635: hr_utility.set_location(' Leaving:'||l_proc, 35);
636: END IF;
637: EXCEPTION
638: WHEN hr_api.object_locked THEN
639: IF l_cursor%ISOPEN THEN
640: CLOSE l_cursor;
641: END IF;
642: -- The object is locked therefore we need to supply a meaningful

Line 735: p_parent_table_name1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

731: (p_effective_date IN DATE,
732: p_base_table_name IN VARCHAR2,
733: p_base_key_column IN VARCHAR2,
734: p_base_key_value IN NUMBER,
735: p_parent_table_name1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
736: p_parent_key_column1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
737: p_parent_key_value1 IN NUMBER DEFAULT hr_api.g_number,
738: p_parent_table_name2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
739: p_parent_key_column2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 736: p_parent_key_column1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

732: p_base_table_name IN VARCHAR2,
733: p_base_key_column IN VARCHAR2,
734: p_base_key_value IN NUMBER,
735: p_parent_table_name1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
736: p_parent_key_column1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
737: p_parent_key_value1 IN NUMBER DEFAULT hr_api.g_number,
738: p_parent_table_name2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
739: p_parent_key_column2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
740: p_parent_key_value2 IN NUMBER DEFAULT hr_api.g_number,

Line 737: p_parent_key_value1 IN NUMBER DEFAULT hr_api.g_number,

733: p_base_key_column IN VARCHAR2,
734: p_base_key_value IN NUMBER,
735: p_parent_table_name1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
736: p_parent_key_column1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
737: p_parent_key_value1 IN NUMBER DEFAULT hr_api.g_number,
738: p_parent_table_name2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
739: p_parent_key_column2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
740: p_parent_key_value2 IN NUMBER DEFAULT hr_api.g_number,
741: p_parent_table_name3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 738: p_parent_table_name2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

734: p_base_key_value IN NUMBER,
735: p_parent_table_name1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
736: p_parent_key_column1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
737: p_parent_key_value1 IN NUMBER DEFAULT hr_api.g_number,
738: p_parent_table_name2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
739: p_parent_key_column2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
740: p_parent_key_value2 IN NUMBER DEFAULT hr_api.g_number,
741: p_parent_table_name3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
742: p_parent_key_column3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 739: p_parent_key_column2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

735: p_parent_table_name1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
736: p_parent_key_column1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
737: p_parent_key_value1 IN NUMBER DEFAULT hr_api.g_number,
738: p_parent_table_name2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
739: p_parent_key_column2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
740: p_parent_key_value2 IN NUMBER DEFAULT hr_api.g_number,
741: p_parent_table_name3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
742: p_parent_key_column3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
743: p_parent_key_value3 IN NUMBER DEFAULT hr_api.g_number,

Line 740: p_parent_key_value2 IN NUMBER DEFAULT hr_api.g_number,

736: p_parent_key_column1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
737: p_parent_key_value1 IN NUMBER DEFAULT hr_api.g_number,
738: p_parent_table_name2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
739: p_parent_key_column2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
740: p_parent_key_value2 IN NUMBER DEFAULT hr_api.g_number,
741: p_parent_table_name3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
742: p_parent_key_column3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
743: p_parent_key_value3 IN NUMBER DEFAULT hr_api.g_number,
744: p_parent_table_name4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 741: p_parent_table_name3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

737: p_parent_key_value1 IN NUMBER DEFAULT hr_api.g_number,
738: p_parent_table_name2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
739: p_parent_key_column2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
740: p_parent_key_value2 IN NUMBER DEFAULT hr_api.g_number,
741: p_parent_table_name3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
742: p_parent_key_column3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
743: p_parent_key_value3 IN NUMBER DEFAULT hr_api.g_number,
744: p_parent_table_name4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
745: p_parent_key_column4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 742: p_parent_key_column3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

738: p_parent_table_name2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
739: p_parent_key_column2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
740: p_parent_key_value2 IN NUMBER DEFAULT hr_api.g_number,
741: p_parent_table_name3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
742: p_parent_key_column3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
743: p_parent_key_value3 IN NUMBER DEFAULT hr_api.g_number,
744: p_parent_table_name4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
745: p_parent_key_column4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
746: p_parent_key_value4 IN NUMBER DEFAULT hr_api.g_number,

Line 743: p_parent_key_value3 IN NUMBER DEFAULT hr_api.g_number,

739: p_parent_key_column2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
740: p_parent_key_value2 IN NUMBER DEFAULT hr_api.g_number,
741: p_parent_table_name3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
742: p_parent_key_column3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
743: p_parent_key_value3 IN NUMBER DEFAULT hr_api.g_number,
744: p_parent_table_name4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
745: p_parent_key_column4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
746: p_parent_key_value4 IN NUMBER DEFAULT hr_api.g_number,
747: p_parent_table_name5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 744: p_parent_table_name4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

740: p_parent_key_value2 IN NUMBER DEFAULT hr_api.g_number,
741: p_parent_table_name3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
742: p_parent_key_column3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
743: p_parent_key_value3 IN NUMBER DEFAULT hr_api.g_number,
744: p_parent_table_name4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
745: p_parent_key_column4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
746: p_parent_key_value4 IN NUMBER DEFAULT hr_api.g_number,
747: p_parent_table_name5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
748: p_parent_key_column5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 745: p_parent_key_column4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

741: p_parent_table_name3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
742: p_parent_key_column3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
743: p_parent_key_value3 IN NUMBER DEFAULT hr_api.g_number,
744: p_parent_table_name4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
745: p_parent_key_column4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
746: p_parent_key_value4 IN NUMBER DEFAULT hr_api.g_number,
747: p_parent_table_name5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
748: p_parent_key_column5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
749: p_parent_key_value5 IN NUMBER DEFAULT hr_api.g_number,

Line 746: p_parent_key_value4 IN NUMBER DEFAULT hr_api.g_number,

742: p_parent_key_column3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
743: p_parent_key_value3 IN NUMBER DEFAULT hr_api.g_number,
744: p_parent_table_name4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
745: p_parent_key_column4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
746: p_parent_key_value4 IN NUMBER DEFAULT hr_api.g_number,
747: p_parent_table_name5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
748: p_parent_key_column5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
749: p_parent_key_value5 IN NUMBER DEFAULT hr_api.g_number,
750: p_parent_table_name6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 747: p_parent_table_name5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

743: p_parent_key_value3 IN NUMBER DEFAULT hr_api.g_number,
744: p_parent_table_name4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
745: p_parent_key_column4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
746: p_parent_key_value4 IN NUMBER DEFAULT hr_api.g_number,
747: p_parent_table_name5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
748: p_parent_key_column5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
749: p_parent_key_value5 IN NUMBER DEFAULT hr_api.g_number,
750: p_parent_table_name6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
751: p_parent_key_column6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 748: p_parent_key_column5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

744: p_parent_table_name4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
745: p_parent_key_column4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
746: p_parent_key_value4 IN NUMBER DEFAULT hr_api.g_number,
747: p_parent_table_name5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
748: p_parent_key_column5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
749: p_parent_key_value5 IN NUMBER DEFAULT hr_api.g_number,
750: p_parent_table_name6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
751: p_parent_key_column6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
752: p_parent_key_value6 IN NUMBER DEFAULT hr_api.g_number,

Line 749: p_parent_key_value5 IN NUMBER DEFAULT hr_api.g_number,

745: p_parent_key_column4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
746: p_parent_key_value4 IN NUMBER DEFAULT hr_api.g_number,
747: p_parent_table_name5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
748: p_parent_key_column5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
749: p_parent_key_value5 IN NUMBER DEFAULT hr_api.g_number,
750: p_parent_table_name6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
751: p_parent_key_column6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
752: p_parent_key_value6 IN NUMBER DEFAULT hr_api.g_number,
753: p_parent_table_name7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 750: p_parent_table_name6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

746: p_parent_key_value4 IN NUMBER DEFAULT hr_api.g_number,
747: p_parent_table_name5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
748: p_parent_key_column5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
749: p_parent_key_value5 IN NUMBER DEFAULT hr_api.g_number,
750: p_parent_table_name6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
751: p_parent_key_column6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
752: p_parent_key_value6 IN NUMBER DEFAULT hr_api.g_number,
753: p_parent_table_name7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
754: p_parent_key_column7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 751: p_parent_key_column6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

747: p_parent_table_name5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
748: p_parent_key_column5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
749: p_parent_key_value5 IN NUMBER DEFAULT hr_api.g_number,
750: p_parent_table_name6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
751: p_parent_key_column6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
752: p_parent_key_value6 IN NUMBER DEFAULT hr_api.g_number,
753: p_parent_table_name7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
754: p_parent_key_column7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
755: p_parent_key_value7 IN NUMBER DEFAULT hr_api.g_number,

Line 752: p_parent_key_value6 IN NUMBER DEFAULT hr_api.g_number,

748: p_parent_key_column5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
749: p_parent_key_value5 IN NUMBER DEFAULT hr_api.g_number,
750: p_parent_table_name6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
751: p_parent_key_column6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
752: p_parent_key_value6 IN NUMBER DEFAULT hr_api.g_number,
753: p_parent_table_name7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
754: p_parent_key_column7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
755: p_parent_key_value7 IN NUMBER DEFAULT hr_api.g_number,
756: p_parent_table_name8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 753: p_parent_table_name7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

749: p_parent_key_value5 IN NUMBER DEFAULT hr_api.g_number,
750: p_parent_table_name6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
751: p_parent_key_column6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
752: p_parent_key_value6 IN NUMBER DEFAULT hr_api.g_number,
753: p_parent_table_name7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
754: p_parent_key_column7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
755: p_parent_key_value7 IN NUMBER DEFAULT hr_api.g_number,
756: p_parent_table_name8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
757: p_parent_key_column8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 754: p_parent_key_column7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

750: p_parent_table_name6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
751: p_parent_key_column6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
752: p_parent_key_value6 IN NUMBER DEFAULT hr_api.g_number,
753: p_parent_table_name7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
754: p_parent_key_column7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
755: p_parent_key_value7 IN NUMBER DEFAULT hr_api.g_number,
756: p_parent_table_name8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
757: p_parent_key_column8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
758: p_parent_key_value8 IN NUMBER DEFAULT hr_api.g_number,

Line 755: p_parent_key_value7 IN NUMBER DEFAULT hr_api.g_number,

751: p_parent_key_column6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
752: p_parent_key_value6 IN NUMBER DEFAULT hr_api.g_number,
753: p_parent_table_name7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
754: p_parent_key_column7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
755: p_parent_key_value7 IN NUMBER DEFAULT hr_api.g_number,
756: p_parent_table_name8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
757: p_parent_key_column8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
758: p_parent_key_value8 IN NUMBER DEFAULT hr_api.g_number,
759: p_parent_table_name9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 756: p_parent_table_name8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

752: p_parent_key_value6 IN NUMBER DEFAULT hr_api.g_number,
753: p_parent_table_name7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
754: p_parent_key_column7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
755: p_parent_key_value7 IN NUMBER DEFAULT hr_api.g_number,
756: p_parent_table_name8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
757: p_parent_key_column8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
758: p_parent_key_value8 IN NUMBER DEFAULT hr_api.g_number,
759: p_parent_table_name9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
760: p_parent_key_column9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 757: p_parent_key_column8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

753: p_parent_table_name7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
754: p_parent_key_column7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
755: p_parent_key_value7 IN NUMBER DEFAULT hr_api.g_number,
756: p_parent_table_name8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
757: p_parent_key_column8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
758: p_parent_key_value8 IN NUMBER DEFAULT hr_api.g_number,
759: p_parent_table_name9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
760: p_parent_key_column9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
761: p_parent_key_value9 IN NUMBER DEFAULT hr_api.g_number,

Line 758: p_parent_key_value8 IN NUMBER DEFAULT hr_api.g_number,

754: p_parent_key_column7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
755: p_parent_key_value7 IN NUMBER DEFAULT hr_api.g_number,
756: p_parent_table_name8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
757: p_parent_key_column8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
758: p_parent_key_value8 IN NUMBER DEFAULT hr_api.g_number,
759: p_parent_table_name9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
760: p_parent_key_column9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
761: p_parent_key_value9 IN NUMBER DEFAULT hr_api.g_number,
762: p_parent_table_name10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 759: p_parent_table_name9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

755: p_parent_key_value7 IN NUMBER DEFAULT hr_api.g_number,
756: p_parent_table_name8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
757: p_parent_key_column8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
758: p_parent_key_value8 IN NUMBER DEFAULT hr_api.g_number,
759: p_parent_table_name9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
760: p_parent_key_column9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
761: p_parent_key_value9 IN NUMBER DEFAULT hr_api.g_number,
762: p_parent_table_name10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
763: p_parent_key_column10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 760: p_parent_key_column9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

756: p_parent_table_name8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
757: p_parent_key_column8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
758: p_parent_key_value8 IN NUMBER DEFAULT hr_api.g_number,
759: p_parent_table_name9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
760: p_parent_key_column9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
761: p_parent_key_value9 IN NUMBER DEFAULT hr_api.g_number,
762: p_parent_table_name10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
763: p_parent_key_column10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
764: p_parent_key_value10 IN NUMBER DEFAULT hr_api.g_number,

Line 761: p_parent_key_value9 IN NUMBER DEFAULT hr_api.g_number,

757: p_parent_key_column8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
758: p_parent_key_value8 IN NUMBER DEFAULT hr_api.g_number,
759: p_parent_table_name9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
760: p_parent_key_column9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
761: p_parent_key_value9 IN NUMBER DEFAULT hr_api.g_number,
762: p_parent_table_name10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
763: p_parent_key_column10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
764: p_parent_key_value10 IN NUMBER DEFAULT hr_api.g_number,
765: p_zap OUT NOCOPY BOOLEAN,

Line 762: p_parent_table_name10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

758: p_parent_key_value8 IN NUMBER DEFAULT hr_api.g_number,
759: p_parent_table_name9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
760: p_parent_key_column9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
761: p_parent_key_value9 IN NUMBER DEFAULT hr_api.g_number,
762: p_parent_table_name10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
763: p_parent_key_column10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
764: p_parent_key_value10 IN NUMBER DEFAULT hr_api.g_number,
765: p_zap OUT NOCOPY BOOLEAN,
766: p_delete OUT NOCOPY BOOLEAN,

Line 763: p_parent_key_column10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

759: p_parent_table_name9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
760: p_parent_key_column9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
761: p_parent_key_value9 IN NUMBER DEFAULT hr_api.g_number,
762: p_parent_table_name10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
763: p_parent_key_column10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
764: p_parent_key_value10 IN NUMBER DEFAULT hr_api.g_number,
765: p_zap OUT NOCOPY BOOLEAN,
766: p_delete OUT NOCOPY BOOLEAN,
767: p_future_change OUT NOCOPY BOOLEAN,

Line 764: p_parent_key_value10 IN NUMBER DEFAULT hr_api.g_number,

760: p_parent_key_column9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
761: p_parent_key_value9 IN NUMBER DEFAULT hr_api.g_number,
762: p_parent_table_name10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
763: p_parent_key_column10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
764: p_parent_key_value10 IN NUMBER DEFAULT hr_api.g_number,
765: p_zap OUT NOCOPY BOOLEAN,
766: p_delete OUT NOCOPY BOOLEAN,
767: p_future_change OUT NOCOPY BOOLEAN,
768: p_delete_next_change OUT NOCOPY BOOLEAN) IS

Line 1789: p_parent_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1785: p_effective_date IN DATE,
1786: p_base_table_name IN VARCHAR2,
1787: p_base_key_column IN VARCHAR2,
1788: p_base_key_value IN NUMBER,
1789: p_parent_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1790: p_parent_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1791: p_parent_key_value1 IN NUMBER DEFAULT HR_API.G_NUMBER,
1792: p_parent_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1793: p_parent_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1790: p_parent_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1786: p_base_table_name IN VARCHAR2,
1787: p_base_key_column IN VARCHAR2,
1788: p_base_key_value IN NUMBER,
1789: p_parent_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1790: p_parent_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1791: p_parent_key_value1 IN NUMBER DEFAULT HR_API.G_NUMBER,
1792: p_parent_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1793: p_parent_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1794: p_parent_key_value2 IN NUMBER DEFAULT HR_API.G_NUMBER,

Line 1791: p_parent_key_value1 IN NUMBER DEFAULT HR_API.G_NUMBER,

1787: p_base_key_column IN VARCHAR2,
1788: p_base_key_value IN NUMBER,
1789: p_parent_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1790: p_parent_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1791: p_parent_key_value1 IN NUMBER DEFAULT HR_API.G_NUMBER,
1792: p_parent_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1793: p_parent_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1794: p_parent_key_value2 IN NUMBER DEFAULT HR_API.G_NUMBER,
1795: p_parent_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1792: p_parent_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1788: p_base_key_value IN NUMBER,
1789: p_parent_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1790: p_parent_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1791: p_parent_key_value1 IN NUMBER DEFAULT HR_API.G_NUMBER,
1792: p_parent_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1793: p_parent_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1794: p_parent_key_value2 IN NUMBER DEFAULT HR_API.G_NUMBER,
1795: p_parent_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1796: p_parent_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1793: p_parent_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1789: p_parent_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1790: p_parent_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1791: p_parent_key_value1 IN NUMBER DEFAULT HR_API.G_NUMBER,
1792: p_parent_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1793: p_parent_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1794: p_parent_key_value2 IN NUMBER DEFAULT HR_API.G_NUMBER,
1795: p_parent_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1796: p_parent_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1797: p_parent_key_value3 IN NUMBER DEFAULT HR_API.G_NUMBER,

Line 1794: p_parent_key_value2 IN NUMBER DEFAULT HR_API.G_NUMBER,

1790: p_parent_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1791: p_parent_key_value1 IN NUMBER DEFAULT HR_API.G_NUMBER,
1792: p_parent_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1793: p_parent_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1794: p_parent_key_value2 IN NUMBER DEFAULT HR_API.G_NUMBER,
1795: p_parent_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1796: p_parent_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1797: p_parent_key_value3 IN NUMBER DEFAULT HR_API.G_NUMBER,
1798: p_parent_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1795: p_parent_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1791: p_parent_key_value1 IN NUMBER DEFAULT HR_API.G_NUMBER,
1792: p_parent_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1793: p_parent_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1794: p_parent_key_value2 IN NUMBER DEFAULT HR_API.G_NUMBER,
1795: p_parent_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1796: p_parent_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1797: p_parent_key_value3 IN NUMBER DEFAULT HR_API.G_NUMBER,
1798: p_parent_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1799: p_parent_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1796: p_parent_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1792: p_parent_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1793: p_parent_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1794: p_parent_key_value2 IN NUMBER DEFAULT HR_API.G_NUMBER,
1795: p_parent_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1796: p_parent_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1797: p_parent_key_value3 IN NUMBER DEFAULT HR_API.G_NUMBER,
1798: p_parent_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1799: p_parent_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1800: p_parent_key_value4 IN NUMBER DEFAULT HR_API.G_NUMBER,

Line 1797: p_parent_key_value3 IN NUMBER DEFAULT HR_API.G_NUMBER,

1793: p_parent_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1794: p_parent_key_value2 IN NUMBER DEFAULT HR_API.G_NUMBER,
1795: p_parent_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1796: p_parent_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1797: p_parent_key_value3 IN NUMBER DEFAULT HR_API.G_NUMBER,
1798: p_parent_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1799: p_parent_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1800: p_parent_key_value4 IN NUMBER DEFAULT HR_API.G_NUMBER,
1801: p_parent_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1798: p_parent_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1794: p_parent_key_value2 IN NUMBER DEFAULT HR_API.G_NUMBER,
1795: p_parent_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1796: p_parent_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1797: p_parent_key_value3 IN NUMBER DEFAULT HR_API.G_NUMBER,
1798: p_parent_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1799: p_parent_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1800: p_parent_key_value4 IN NUMBER DEFAULT HR_API.G_NUMBER,
1801: p_parent_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1802: p_parent_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1799: p_parent_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1795: p_parent_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1796: p_parent_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1797: p_parent_key_value3 IN NUMBER DEFAULT HR_API.G_NUMBER,
1798: p_parent_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1799: p_parent_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1800: p_parent_key_value4 IN NUMBER DEFAULT HR_API.G_NUMBER,
1801: p_parent_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1802: p_parent_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1803: p_parent_key_value5 IN NUMBER DEFAULT HR_API.G_NUMBER,

Line 1800: p_parent_key_value4 IN NUMBER DEFAULT HR_API.G_NUMBER,

1796: p_parent_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1797: p_parent_key_value3 IN NUMBER DEFAULT HR_API.G_NUMBER,
1798: p_parent_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1799: p_parent_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1800: p_parent_key_value4 IN NUMBER DEFAULT HR_API.G_NUMBER,
1801: p_parent_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1802: p_parent_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1803: p_parent_key_value5 IN NUMBER DEFAULT HR_API.G_NUMBER,
1804: p_parent_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1801: p_parent_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1797: p_parent_key_value3 IN NUMBER DEFAULT HR_API.G_NUMBER,
1798: p_parent_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1799: p_parent_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1800: p_parent_key_value4 IN NUMBER DEFAULT HR_API.G_NUMBER,
1801: p_parent_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1802: p_parent_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1803: p_parent_key_value5 IN NUMBER DEFAULT HR_API.G_NUMBER,
1804: p_parent_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1805: p_parent_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1802: p_parent_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1798: p_parent_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1799: p_parent_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1800: p_parent_key_value4 IN NUMBER DEFAULT HR_API.G_NUMBER,
1801: p_parent_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1802: p_parent_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1803: p_parent_key_value5 IN NUMBER DEFAULT HR_API.G_NUMBER,
1804: p_parent_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1805: p_parent_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1806: p_parent_key_value6 IN NUMBER DEFAULT HR_API.G_NUMBER,

Line 1803: p_parent_key_value5 IN NUMBER DEFAULT HR_API.G_NUMBER,

1799: p_parent_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1800: p_parent_key_value4 IN NUMBER DEFAULT HR_API.G_NUMBER,
1801: p_parent_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1802: p_parent_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1803: p_parent_key_value5 IN NUMBER DEFAULT HR_API.G_NUMBER,
1804: p_parent_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1805: p_parent_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1806: p_parent_key_value6 IN NUMBER DEFAULT HR_API.G_NUMBER,
1807: p_parent_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1804: p_parent_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1800: p_parent_key_value4 IN NUMBER DEFAULT HR_API.G_NUMBER,
1801: p_parent_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1802: p_parent_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1803: p_parent_key_value5 IN NUMBER DEFAULT HR_API.G_NUMBER,
1804: p_parent_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1805: p_parent_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1806: p_parent_key_value6 IN NUMBER DEFAULT HR_API.G_NUMBER,
1807: p_parent_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1808: p_parent_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1805: p_parent_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1801: p_parent_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1802: p_parent_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1803: p_parent_key_value5 IN NUMBER DEFAULT HR_API.G_NUMBER,
1804: p_parent_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1805: p_parent_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1806: p_parent_key_value6 IN NUMBER DEFAULT HR_API.G_NUMBER,
1807: p_parent_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1808: p_parent_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1809: p_parent_key_value7 IN NUMBER DEFAULT HR_API.G_NUMBER,

Line 1806: p_parent_key_value6 IN NUMBER DEFAULT HR_API.G_NUMBER,

1802: p_parent_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1803: p_parent_key_value5 IN NUMBER DEFAULT HR_API.G_NUMBER,
1804: p_parent_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1805: p_parent_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1806: p_parent_key_value6 IN NUMBER DEFAULT HR_API.G_NUMBER,
1807: p_parent_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1808: p_parent_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1809: p_parent_key_value7 IN NUMBER DEFAULT HR_API.G_NUMBER,
1810: p_parent_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1807: p_parent_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1803: p_parent_key_value5 IN NUMBER DEFAULT HR_API.G_NUMBER,
1804: p_parent_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1805: p_parent_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1806: p_parent_key_value6 IN NUMBER DEFAULT HR_API.G_NUMBER,
1807: p_parent_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1808: p_parent_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1809: p_parent_key_value7 IN NUMBER DEFAULT HR_API.G_NUMBER,
1810: p_parent_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1811: p_parent_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1808: p_parent_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1804: p_parent_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1805: p_parent_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1806: p_parent_key_value6 IN NUMBER DEFAULT HR_API.G_NUMBER,
1807: p_parent_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1808: p_parent_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1809: p_parent_key_value7 IN NUMBER DEFAULT HR_API.G_NUMBER,
1810: p_parent_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1811: p_parent_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1812: p_parent_key_value8 IN NUMBER DEFAULT HR_API.G_NUMBER,

Line 1809: p_parent_key_value7 IN NUMBER DEFAULT HR_API.G_NUMBER,

1805: p_parent_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1806: p_parent_key_value6 IN NUMBER DEFAULT HR_API.G_NUMBER,
1807: p_parent_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1808: p_parent_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1809: p_parent_key_value7 IN NUMBER DEFAULT HR_API.G_NUMBER,
1810: p_parent_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1811: p_parent_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1812: p_parent_key_value8 IN NUMBER DEFAULT HR_API.G_NUMBER,
1813: p_parent_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1810: p_parent_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1806: p_parent_key_value6 IN NUMBER DEFAULT HR_API.G_NUMBER,
1807: p_parent_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1808: p_parent_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1809: p_parent_key_value7 IN NUMBER DEFAULT HR_API.G_NUMBER,
1810: p_parent_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1811: p_parent_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1812: p_parent_key_value8 IN NUMBER DEFAULT HR_API.G_NUMBER,
1813: p_parent_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1814: p_parent_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1811: p_parent_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1807: p_parent_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1808: p_parent_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1809: p_parent_key_value7 IN NUMBER DEFAULT HR_API.G_NUMBER,
1810: p_parent_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1811: p_parent_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1812: p_parent_key_value8 IN NUMBER DEFAULT HR_API.G_NUMBER,
1813: p_parent_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1814: p_parent_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1815: p_parent_key_value9 IN NUMBER DEFAULT HR_API.G_NUMBER,

Line 1812: p_parent_key_value8 IN NUMBER DEFAULT HR_API.G_NUMBER,

1808: p_parent_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1809: p_parent_key_value7 IN NUMBER DEFAULT HR_API.G_NUMBER,
1810: p_parent_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1811: p_parent_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1812: p_parent_key_value8 IN NUMBER DEFAULT HR_API.G_NUMBER,
1813: p_parent_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1814: p_parent_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1815: p_parent_key_value9 IN NUMBER DEFAULT HR_API.G_NUMBER,
1816: p_parent_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1813: p_parent_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1809: p_parent_key_value7 IN NUMBER DEFAULT HR_API.G_NUMBER,
1810: p_parent_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1811: p_parent_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1812: p_parent_key_value8 IN NUMBER DEFAULT HR_API.G_NUMBER,
1813: p_parent_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1814: p_parent_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1815: p_parent_key_value9 IN NUMBER DEFAULT HR_API.G_NUMBER,
1816: p_parent_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1817: p_parent_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1814: p_parent_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1810: p_parent_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1811: p_parent_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1812: p_parent_key_value8 IN NUMBER DEFAULT HR_API.G_NUMBER,
1813: p_parent_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1814: p_parent_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1815: p_parent_key_value9 IN NUMBER DEFAULT HR_API.G_NUMBER,
1816: p_parent_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1817: p_parent_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1818: p_parent_key_value10 IN NUMBER DEFAULT HR_API.G_NUMBER,

Line 1815: p_parent_key_value9 IN NUMBER DEFAULT HR_API.G_NUMBER,

1811: p_parent_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1812: p_parent_key_value8 IN NUMBER DEFAULT HR_API.G_NUMBER,
1813: p_parent_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1814: p_parent_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1815: p_parent_key_value9 IN NUMBER DEFAULT HR_API.G_NUMBER,
1816: p_parent_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1817: p_parent_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1818: p_parent_key_value10 IN NUMBER DEFAULT HR_API.G_NUMBER,
1819: p_child_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1816: p_parent_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1812: p_parent_key_value8 IN NUMBER DEFAULT HR_API.G_NUMBER,
1813: p_parent_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1814: p_parent_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1815: p_parent_key_value9 IN NUMBER DEFAULT HR_API.G_NUMBER,
1816: p_parent_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1817: p_parent_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1818: p_parent_key_value10 IN NUMBER DEFAULT HR_API.G_NUMBER,
1819: p_child_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1820: p_child_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1817: p_parent_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1813: p_parent_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1814: p_parent_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1815: p_parent_key_value9 IN NUMBER DEFAULT HR_API.G_NUMBER,
1816: p_parent_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1817: p_parent_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1818: p_parent_key_value10 IN NUMBER DEFAULT HR_API.G_NUMBER,
1819: p_child_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1820: p_child_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1821: p_child_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1818: p_parent_key_value10 IN NUMBER DEFAULT HR_API.G_NUMBER,

1814: p_parent_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1815: p_parent_key_value9 IN NUMBER DEFAULT HR_API.G_NUMBER,
1816: p_parent_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1817: p_parent_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1818: p_parent_key_value10 IN NUMBER DEFAULT HR_API.G_NUMBER,
1819: p_child_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1820: p_child_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1821: p_child_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1822: p_child_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1819: p_child_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1815: p_parent_key_value9 IN NUMBER DEFAULT HR_API.G_NUMBER,
1816: p_parent_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1817: p_parent_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1818: p_parent_key_value10 IN NUMBER DEFAULT HR_API.G_NUMBER,
1819: p_child_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1820: p_child_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1821: p_child_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1822: p_child_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1823: p_child_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1820: p_child_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1816: p_parent_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1817: p_parent_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1818: p_parent_key_value10 IN NUMBER DEFAULT HR_API.G_NUMBER,
1819: p_child_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1820: p_child_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1821: p_child_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1822: p_child_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1823: p_child_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1824: p_child_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1821: p_child_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1817: p_parent_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1818: p_parent_key_value10 IN NUMBER DEFAULT HR_API.G_NUMBER,
1819: p_child_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1820: p_child_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1821: p_child_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1822: p_child_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1823: p_child_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1824: p_child_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1825: p_child_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1822: p_child_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1818: p_parent_key_value10 IN NUMBER DEFAULT HR_API.G_NUMBER,
1819: p_child_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1820: p_child_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1821: p_child_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1822: p_child_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1823: p_child_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1824: p_child_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1825: p_child_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1826: p_child_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1823: p_child_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1819: p_child_table_name1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1820: p_child_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1821: p_child_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1822: p_child_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1823: p_child_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1824: p_child_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1825: p_child_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1826: p_child_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1827: p_child_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1824: p_child_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1820: p_child_key_column1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1821: p_child_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1822: p_child_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1823: p_child_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1824: p_child_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1825: p_child_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1826: p_child_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1827: p_child_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1828: p_child_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1825: p_child_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1821: p_child_table_name2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1822: p_child_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1823: p_child_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1824: p_child_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1825: p_child_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1826: p_child_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1827: p_child_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1828: p_child_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1829: p_child_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1826: p_child_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1822: p_child_key_column2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1823: p_child_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1824: p_child_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1825: p_child_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1826: p_child_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1827: p_child_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1828: p_child_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1829: p_child_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1830: p_child_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1827: p_child_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1823: p_child_table_name3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1824: p_child_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1825: p_child_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1826: p_child_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1827: p_child_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1828: p_child_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1829: p_child_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1830: p_child_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1831: p_child_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1828: p_child_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1824: p_child_key_column3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1825: p_child_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1826: p_child_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1827: p_child_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1828: p_child_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1829: p_child_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1830: p_child_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1831: p_child_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1832: p_child_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1829: p_child_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1825: p_child_table_name4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1826: p_child_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1827: p_child_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1828: p_child_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1829: p_child_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1830: p_child_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1831: p_child_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1832: p_child_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1833: p_child_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1830: p_child_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1826: p_child_key_column4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1827: p_child_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1828: p_child_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1829: p_child_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1830: p_child_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1831: p_child_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1832: p_child_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1833: p_child_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1834: p_child_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1831: p_child_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1827: p_child_table_name5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1828: p_child_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1829: p_child_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1830: p_child_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1831: p_child_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1832: p_child_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1833: p_child_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1834: p_child_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1835: p_child_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1832: p_child_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1828: p_child_key_column5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1829: p_child_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1830: p_child_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1831: p_child_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1832: p_child_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1833: p_child_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1834: p_child_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1835: p_child_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1836: p_child_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1833: p_child_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1829: p_child_table_name6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1830: p_child_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1831: p_child_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1832: p_child_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1833: p_child_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1834: p_child_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1835: p_child_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1836: p_child_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1837: p_child_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1834: p_child_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1830: p_child_key_column6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1831: p_child_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1832: p_child_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1833: p_child_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1834: p_child_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1835: p_child_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1836: p_child_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1837: p_child_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1838: p_child_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

Line 1835: p_child_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1831: p_child_table_name7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1832: p_child_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1833: p_child_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1834: p_child_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1835: p_child_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1836: p_child_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1837: p_child_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1838: p_child_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1839: p_child_alt_base_key_column1 IN VARCHAR2 DEFAULT NULL,

Line 1836: p_child_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1832: p_child_key_column7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1833: p_child_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1834: p_child_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1835: p_child_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1836: p_child_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1837: p_child_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1838: p_child_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1839: p_child_alt_base_key_column1 IN VARCHAR2 DEFAULT NULL,
1840: p_child_alt_base_key_column2 IN VARCHAR2 DEFAULT NULL,

Line 1837: p_child_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1833: p_child_table_name8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1834: p_child_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1835: p_child_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1836: p_child_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1837: p_child_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1838: p_child_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1839: p_child_alt_base_key_column1 IN VARCHAR2 DEFAULT NULL,
1840: p_child_alt_base_key_column2 IN VARCHAR2 DEFAULT NULL,
1841: p_child_alt_base_key_column3 IN VARCHAR2 DEFAULT NULL,

Line 1838: p_child_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,

1834: p_child_key_column8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1835: p_child_table_name9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1836: p_child_key_column9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1837: p_child_table_name10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1838: p_child_key_column10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2,
1839: p_child_alt_base_key_column1 IN VARCHAR2 DEFAULT NULL,
1840: p_child_alt_base_key_column2 IN VARCHAR2 DEFAULT NULL,
1841: p_child_alt_base_key_column3 IN VARCHAR2 DEFAULT NULL,
1842: p_child_alt_base_key_column4 IN VARCHAR2 DEFAULT NULL,

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

1868: -- [ start of change 30.14 ]
1869: --
1870: IF p_datetrack_mode IS NULL OR p_base_table_name IS NULL OR
1871: p_base_key_column IS NULL THEN
1872: hr_api.mandatory_arg_error(p_api_name => l_proc,
1873: p_argument => 'p_datetrack_mode',
1874: p_argument_value => p_datetrack_mode);
1875: hr_api.mandatory_arg_error(p_api_name => l_proc,
1876: p_argument => 'p_base_table_name',

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

1871: p_base_key_column IS NULL THEN
1872: hr_api.mandatory_arg_error(p_api_name => l_proc,
1873: p_argument => 'p_datetrack_mode',
1874: p_argument_value => p_datetrack_mode);
1875: hr_api.mandatory_arg_error(p_api_name => l_proc,
1876: p_argument => 'p_base_table_name',
1877: p_argument_value => p_base_table_name);
1878: hr_api.mandatory_arg_error(p_api_name => l_proc,
1879: p_argument => 'p_base_key_column',

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

1874: p_argument_value => p_datetrack_mode);
1875: hr_api.mandatory_arg_error(p_api_name => l_proc,
1876: p_argument => 'p_base_table_name',
1877: p_argument_value => p_base_table_name);
1878: hr_api.mandatory_arg_error(p_api_name => l_proc,
1879: p_argument => 'p_base_key_column',
1880: p_argument_value => p_base_key_column);
1881: END IF;
1882: -- [ start of change 30.15 ]

Line 1883: -- removed the hr_api.mandatory_arg_error for p_base_key_value

1879: p_argument => 'p_base_key_column',
1880: p_argument_value => p_base_key_column);
1881: END IF;
1882: -- [ start of change 30.15 ]
1883: -- removed the hr_api.mandatory_arg_error for p_base_key_value
1884: -- [ end of change 30.15 ]
1885: -- [ end of change 30.14 ]
1886: --
1887: IF (l_datetrack_mode = dt_api.g_insert) THEN

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

2130: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
2131: END IF;
2132: IF p_datetrack_mode IS NULL THEN
2133: -- Ensure that the mode is not null
2134: hr_api.mandatory_arg_error(p_api_name => l_proc,
2135: p_argument => 'datetrack_mode',
2136: p_argument_value => p_datetrack_mode);
2137: END IF;
2138: -- Check the mode is valid

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

2171: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
2172: END IF;
2173: IF p_datetrack_mode IS NULL THEN
2174: -- Ensure that the mode is not null
2175: hr_api.mandatory_arg_error(p_api_name => l_proc,
2176: p_argument => 'datetrack_mode',
2177: p_argument_value => p_datetrack_mode);
2178: END IF;
2179: -- Check the mode is valid

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

2283: -- [ start of change 30.14 ]
2284: IF p_base_table_name IS NULL OR
2285: p_base_key_column IS NULL OR
2286: p_base_key_value IS NULL THEN
2287: hr_api.mandatory_arg_error(p_api_name => l_proc,
2288: p_argument => 'p_base_table_name',
2289: p_argument_value => p_base_table_name);
2290: hr_api.mandatory_arg_error(p_api_name => l_proc,
2291: p_argument => 'p_base_key_column',

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

2286: p_base_key_value IS NULL THEN
2287: hr_api.mandatory_arg_error(p_api_name => l_proc,
2288: p_argument => 'p_base_table_name',
2289: p_argument_value => p_base_table_name);
2290: hr_api.mandatory_arg_error(p_api_name => l_proc,
2291: p_argument => 'p_base_key_column',
2292: p_argument_value => p_base_key_column);
2293: hr_api.mandatory_arg_error(p_api_name => l_proc,
2294: p_argument => 'p_base_key_value',

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

2289: p_argument_value => p_base_table_name);
2290: hr_api.mandatory_arg_error(p_api_name => l_proc,
2291: p_argument => 'p_base_key_column',
2292: p_argument_value => p_base_key_column);
2293: hr_api.mandatory_arg_error(p_api_name => l_proc,
2294: p_argument => 'p_base_key_value',
2295: p_argument_value => p_base_key_value);
2296: END IF;
2297: -- [ end of change 30.14 ]

Line 2336: p_to_date IN DATE DEFAULT hr_api.g_eot)

2332: (p_base_table_name IN VARCHAR2,
2333: p_base_key_column IN VARCHAR2,
2334: p_base_key_value IN NUMBER,
2335: p_from_date IN DATE,
2336: p_to_date IN DATE DEFAULT hr_api.g_eot)
2337: RETURN BOOLEAN IS
2338: --
2339: l_proc VARCHAR2(72);
2340: l_ret_column number(1); -- Returning Sql Column

Line 2354: hr_api.mandatory_arg_error

2350: p_base_key_column IS NULL OR
2351: p_from_date IS NULL OR
2352: p_to_date IS NULL THEN
2353: -- Mandatory arg checking
2354: hr_api.mandatory_arg_error
2355: (p_api_name => l_proc,
2356: p_argument => 'p_base_table_name',
2357: p_argument_value => p_base_table_name);
2358: --

Line 2359: hr_api.mandatory_arg_error

2355: (p_api_name => l_proc,
2356: p_argument => 'p_base_table_name',
2357: p_argument_value => p_base_table_name);
2358: --
2359: hr_api.mandatory_arg_error
2360: (p_api_name => l_proc,
2361: p_argument => 'p_base_key_column',
2362: p_argument_value => p_base_key_column);
2363: --

Line 2364: hr_api.mandatory_arg_error

2360: (p_api_name => l_proc,
2361: p_argument => 'p_base_key_column',
2362: p_argument_value => p_base_key_column);
2363: --
2364: hr_api.mandatory_arg_error
2365: (p_api_name => l_proc,
2366: p_argument => 'p_from_date',
2367: p_argument_value => p_from_date);
2368: --

Line 2369: hr_api.mandatory_arg_error

2365: (p_api_name => l_proc,
2366: p_argument => 'p_from_date',
2367: p_argument_value => p_from_date);
2368: --
2369: hr_api.mandatory_arg_error
2370: (p_api_name => l_proc,
2371: p_argument => 'p_to_date',
2372: p_argument_value => p_to_date);
2373: END IF;

Line 2447: hr_api.mandatory_arg_error

2443: p_base_key_column IS NULL OR
2444: p_from_date IS NULL OR
2445: p_to_date IS NULL THEN
2446: -- Mandatory arg checking
2447: hr_api.mandatory_arg_error
2448: (p_api_name => l_proc,
2449: p_argument => 'p_base_table_name',
2450: p_argument_value => p_base_table_name);
2451: --

Line 2452: hr_api.mandatory_arg_error

2448: (p_api_name => l_proc,
2449: p_argument => 'p_base_table_name',
2450: p_argument_value => p_base_table_name);
2451: --
2452: hr_api.mandatory_arg_error
2453: (p_api_name => l_proc,
2454: p_argument => 'p_base_key_column',
2455: p_argument_value => p_base_key_column);
2456: --

Line 2457: hr_api.mandatory_arg_error

2453: (p_api_name => l_proc,
2454: p_argument => 'p_base_key_column',
2455: p_argument_value => p_base_key_column);
2456: --
2457: hr_api.mandatory_arg_error
2458: (p_api_name => l_proc,
2459: p_argument => 'p_from_date',
2460: p_argument_value => p_from_date);
2461: --

Line 2462: hr_api.mandatory_arg_error

2458: (p_api_name => l_proc,
2459: p_argument => 'p_from_date',
2460: p_argument_value => p_from_date);
2461: --
2462: hr_api.mandatory_arg_error
2463: (p_api_name => l_proc,
2464: p_argument => 'p_to_date',
2465: p_argument_value => p_to_date);
2466: END IF;

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

2553: -- [ start of change 30.14 ]
2554: IF p_base_table_name IS NULL OR
2555: p_base_key_column IS NULL OR
2556: p_base_key_value IS NULL THEN
2557: hr_api.mandatory_arg_error(p_api_name => l_proc,
2558: p_argument => 'p_base_table_name',
2559: p_argument_value => p_base_table_name);
2560: hr_api.mandatory_arg_error(p_api_name => l_proc,
2561: p_argument => 'p_base_key_column',

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

2556: p_base_key_value IS NULL THEN
2557: hr_api.mandatory_arg_error(p_api_name => l_proc,
2558: p_argument => 'p_base_table_name',
2559: p_argument_value => p_base_table_name);
2560: hr_api.mandatory_arg_error(p_api_name => l_proc,
2561: p_argument => 'p_base_key_column',
2562: p_argument_value => p_base_key_column);
2563: hr_api.mandatory_arg_error(p_api_name => l_proc,
2564: p_argument => 'p_base_key_value',

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

2559: p_argument_value => p_base_table_name);
2560: hr_api.mandatory_arg_error(p_api_name => l_proc,
2561: p_argument => 'p_base_key_column',
2562: p_argument_value => p_base_key_column);
2563: hr_api.mandatory_arg_error(p_api_name => l_proc,
2564: p_argument => 'p_base_key_value',
2565: p_argument_value => p_base_key_value);
2566: END IF;
2567: -- [ end of change 30.14 ]

Line 2684: ,p_parent_table_name1 in varchar2 default hr_api.g_varchar2

2680: (p_effective_date in date
2681: ,p_base_table_name in varchar2
2682: ,p_base_key_column in varchar2
2683: ,p_base_key_value in number
2684: ,p_parent_table_name1 in varchar2 default hr_api.g_varchar2
2685: ,p_parent_key_column1 in varchar2 default hr_api.g_varchar2
2686: ,p_parent_key_value1 in number default hr_api.g_number
2687: ,p_parent_table_name2 in varchar2 default hr_api.g_varchar2
2688: ,p_parent_key_column2 in varchar2 default hr_api.g_varchar2

Line 2685: ,p_parent_key_column1 in varchar2 default hr_api.g_varchar2

2681: ,p_base_table_name in varchar2
2682: ,p_base_key_column in varchar2
2683: ,p_base_key_value in number
2684: ,p_parent_table_name1 in varchar2 default hr_api.g_varchar2
2685: ,p_parent_key_column1 in varchar2 default hr_api.g_varchar2
2686: ,p_parent_key_value1 in number default hr_api.g_number
2687: ,p_parent_table_name2 in varchar2 default hr_api.g_varchar2
2688: ,p_parent_key_column2 in varchar2 default hr_api.g_varchar2
2689: ,p_parent_key_value2 in number default hr_api.g_number

Line 2686: ,p_parent_key_value1 in number default hr_api.g_number

2682: ,p_base_key_column in varchar2
2683: ,p_base_key_value in number
2684: ,p_parent_table_name1 in varchar2 default hr_api.g_varchar2
2685: ,p_parent_key_column1 in varchar2 default hr_api.g_varchar2
2686: ,p_parent_key_value1 in number default hr_api.g_number
2687: ,p_parent_table_name2 in varchar2 default hr_api.g_varchar2
2688: ,p_parent_key_column2 in varchar2 default hr_api.g_varchar2
2689: ,p_parent_key_value2 in number default hr_api.g_number
2690: ,p_parent_table_name3 in varchar2 default hr_api.g_varchar2

Line 2687: ,p_parent_table_name2 in varchar2 default hr_api.g_varchar2

2683: ,p_base_key_value in number
2684: ,p_parent_table_name1 in varchar2 default hr_api.g_varchar2
2685: ,p_parent_key_column1 in varchar2 default hr_api.g_varchar2
2686: ,p_parent_key_value1 in number default hr_api.g_number
2687: ,p_parent_table_name2 in varchar2 default hr_api.g_varchar2
2688: ,p_parent_key_column2 in varchar2 default hr_api.g_varchar2
2689: ,p_parent_key_value2 in number default hr_api.g_number
2690: ,p_parent_table_name3 in varchar2 default hr_api.g_varchar2
2691: ,p_parent_key_column3 in varchar2 default hr_api.g_varchar2

Line 2688: ,p_parent_key_column2 in varchar2 default hr_api.g_varchar2

2684: ,p_parent_table_name1 in varchar2 default hr_api.g_varchar2
2685: ,p_parent_key_column1 in varchar2 default hr_api.g_varchar2
2686: ,p_parent_key_value1 in number default hr_api.g_number
2687: ,p_parent_table_name2 in varchar2 default hr_api.g_varchar2
2688: ,p_parent_key_column2 in varchar2 default hr_api.g_varchar2
2689: ,p_parent_key_value2 in number default hr_api.g_number
2690: ,p_parent_table_name3 in varchar2 default hr_api.g_varchar2
2691: ,p_parent_key_column3 in varchar2 default hr_api.g_varchar2
2692: ,p_parent_key_value3 in number default hr_api.g_number

Line 2689: ,p_parent_key_value2 in number default hr_api.g_number

2685: ,p_parent_key_column1 in varchar2 default hr_api.g_varchar2
2686: ,p_parent_key_value1 in number default hr_api.g_number
2687: ,p_parent_table_name2 in varchar2 default hr_api.g_varchar2
2688: ,p_parent_key_column2 in varchar2 default hr_api.g_varchar2
2689: ,p_parent_key_value2 in number default hr_api.g_number
2690: ,p_parent_table_name3 in varchar2 default hr_api.g_varchar2
2691: ,p_parent_key_column3 in varchar2 default hr_api.g_varchar2
2692: ,p_parent_key_value3 in number default hr_api.g_number
2693: ,p_parent_table_name4 in varchar2 default hr_api.g_varchar2

Line 2690: ,p_parent_table_name3 in varchar2 default hr_api.g_varchar2

2686: ,p_parent_key_value1 in number default hr_api.g_number
2687: ,p_parent_table_name2 in varchar2 default hr_api.g_varchar2
2688: ,p_parent_key_column2 in varchar2 default hr_api.g_varchar2
2689: ,p_parent_key_value2 in number default hr_api.g_number
2690: ,p_parent_table_name3 in varchar2 default hr_api.g_varchar2
2691: ,p_parent_key_column3 in varchar2 default hr_api.g_varchar2
2692: ,p_parent_key_value3 in number default hr_api.g_number
2693: ,p_parent_table_name4 in varchar2 default hr_api.g_varchar2
2694: ,p_parent_key_column4 in varchar2 default hr_api.g_varchar2

Line 2691: ,p_parent_key_column3 in varchar2 default hr_api.g_varchar2

2687: ,p_parent_table_name2 in varchar2 default hr_api.g_varchar2
2688: ,p_parent_key_column2 in varchar2 default hr_api.g_varchar2
2689: ,p_parent_key_value2 in number default hr_api.g_number
2690: ,p_parent_table_name3 in varchar2 default hr_api.g_varchar2
2691: ,p_parent_key_column3 in varchar2 default hr_api.g_varchar2
2692: ,p_parent_key_value3 in number default hr_api.g_number
2693: ,p_parent_table_name4 in varchar2 default hr_api.g_varchar2
2694: ,p_parent_key_column4 in varchar2 default hr_api.g_varchar2
2695: ,p_parent_key_value4 in number default hr_api.g_number

Line 2692: ,p_parent_key_value3 in number default hr_api.g_number

2688: ,p_parent_key_column2 in varchar2 default hr_api.g_varchar2
2689: ,p_parent_key_value2 in number default hr_api.g_number
2690: ,p_parent_table_name3 in varchar2 default hr_api.g_varchar2
2691: ,p_parent_key_column3 in varchar2 default hr_api.g_varchar2
2692: ,p_parent_key_value3 in number default hr_api.g_number
2693: ,p_parent_table_name4 in varchar2 default hr_api.g_varchar2
2694: ,p_parent_key_column4 in varchar2 default hr_api.g_varchar2
2695: ,p_parent_key_value4 in number default hr_api.g_number
2696: ,p_parent_table_name5 in varchar2 default hr_api.g_varchar2

Line 2693: ,p_parent_table_name4 in varchar2 default hr_api.g_varchar2

2689: ,p_parent_key_value2 in number default hr_api.g_number
2690: ,p_parent_table_name3 in varchar2 default hr_api.g_varchar2
2691: ,p_parent_key_column3 in varchar2 default hr_api.g_varchar2
2692: ,p_parent_key_value3 in number default hr_api.g_number
2693: ,p_parent_table_name4 in varchar2 default hr_api.g_varchar2
2694: ,p_parent_key_column4 in varchar2 default hr_api.g_varchar2
2695: ,p_parent_key_value4 in number default hr_api.g_number
2696: ,p_parent_table_name5 in varchar2 default hr_api.g_varchar2
2697: ,p_parent_key_column5 in varchar2 default hr_api.g_varchar2

Line 2694: ,p_parent_key_column4 in varchar2 default hr_api.g_varchar2

2690: ,p_parent_table_name3 in varchar2 default hr_api.g_varchar2
2691: ,p_parent_key_column3 in varchar2 default hr_api.g_varchar2
2692: ,p_parent_key_value3 in number default hr_api.g_number
2693: ,p_parent_table_name4 in varchar2 default hr_api.g_varchar2
2694: ,p_parent_key_column4 in varchar2 default hr_api.g_varchar2
2695: ,p_parent_key_value4 in number default hr_api.g_number
2696: ,p_parent_table_name5 in varchar2 default hr_api.g_varchar2
2697: ,p_parent_key_column5 in varchar2 default hr_api.g_varchar2
2698: ,p_parent_key_value5 in number default hr_api.g_number

Line 2695: ,p_parent_key_value4 in number default hr_api.g_number

2691: ,p_parent_key_column3 in varchar2 default hr_api.g_varchar2
2692: ,p_parent_key_value3 in number default hr_api.g_number
2693: ,p_parent_table_name4 in varchar2 default hr_api.g_varchar2
2694: ,p_parent_key_column4 in varchar2 default hr_api.g_varchar2
2695: ,p_parent_key_value4 in number default hr_api.g_number
2696: ,p_parent_table_name5 in varchar2 default hr_api.g_varchar2
2697: ,p_parent_key_column5 in varchar2 default hr_api.g_varchar2
2698: ,p_parent_key_value5 in number default hr_api.g_number
2699: ,p_parent_table_name6 in varchar2 default hr_api.g_varchar2

Line 2696: ,p_parent_table_name5 in varchar2 default hr_api.g_varchar2

2692: ,p_parent_key_value3 in number default hr_api.g_number
2693: ,p_parent_table_name4 in varchar2 default hr_api.g_varchar2
2694: ,p_parent_key_column4 in varchar2 default hr_api.g_varchar2
2695: ,p_parent_key_value4 in number default hr_api.g_number
2696: ,p_parent_table_name5 in varchar2 default hr_api.g_varchar2
2697: ,p_parent_key_column5 in varchar2 default hr_api.g_varchar2
2698: ,p_parent_key_value5 in number default hr_api.g_number
2699: ,p_parent_table_name6 in varchar2 default hr_api.g_varchar2
2700: ,p_parent_key_column6 in varchar2 default hr_api.g_varchar2

Line 2697: ,p_parent_key_column5 in varchar2 default hr_api.g_varchar2

2693: ,p_parent_table_name4 in varchar2 default hr_api.g_varchar2
2694: ,p_parent_key_column4 in varchar2 default hr_api.g_varchar2
2695: ,p_parent_key_value4 in number default hr_api.g_number
2696: ,p_parent_table_name5 in varchar2 default hr_api.g_varchar2
2697: ,p_parent_key_column5 in varchar2 default hr_api.g_varchar2
2698: ,p_parent_key_value5 in number default hr_api.g_number
2699: ,p_parent_table_name6 in varchar2 default hr_api.g_varchar2
2700: ,p_parent_key_column6 in varchar2 default hr_api.g_varchar2
2701: ,p_parent_key_value6 in number default hr_api.g_number

Line 2698: ,p_parent_key_value5 in number default hr_api.g_number

2694: ,p_parent_key_column4 in varchar2 default hr_api.g_varchar2
2695: ,p_parent_key_value4 in number default hr_api.g_number
2696: ,p_parent_table_name5 in varchar2 default hr_api.g_varchar2
2697: ,p_parent_key_column5 in varchar2 default hr_api.g_varchar2
2698: ,p_parent_key_value5 in number default hr_api.g_number
2699: ,p_parent_table_name6 in varchar2 default hr_api.g_varchar2
2700: ,p_parent_key_column6 in varchar2 default hr_api.g_varchar2
2701: ,p_parent_key_value6 in number default hr_api.g_number
2702: ,p_parent_table_name7 in varchar2 default hr_api.g_varchar2

Line 2699: ,p_parent_table_name6 in varchar2 default hr_api.g_varchar2

2695: ,p_parent_key_value4 in number default hr_api.g_number
2696: ,p_parent_table_name5 in varchar2 default hr_api.g_varchar2
2697: ,p_parent_key_column5 in varchar2 default hr_api.g_varchar2
2698: ,p_parent_key_value5 in number default hr_api.g_number
2699: ,p_parent_table_name6 in varchar2 default hr_api.g_varchar2
2700: ,p_parent_key_column6 in varchar2 default hr_api.g_varchar2
2701: ,p_parent_key_value6 in number default hr_api.g_number
2702: ,p_parent_table_name7 in varchar2 default hr_api.g_varchar2
2703: ,p_parent_key_column7 in varchar2 default hr_api.g_varchar2

Line 2700: ,p_parent_key_column6 in varchar2 default hr_api.g_varchar2

2696: ,p_parent_table_name5 in varchar2 default hr_api.g_varchar2
2697: ,p_parent_key_column5 in varchar2 default hr_api.g_varchar2
2698: ,p_parent_key_value5 in number default hr_api.g_number
2699: ,p_parent_table_name6 in varchar2 default hr_api.g_varchar2
2700: ,p_parent_key_column6 in varchar2 default hr_api.g_varchar2
2701: ,p_parent_key_value6 in number default hr_api.g_number
2702: ,p_parent_table_name7 in varchar2 default hr_api.g_varchar2
2703: ,p_parent_key_column7 in varchar2 default hr_api.g_varchar2
2704: ,p_parent_key_value7 in number default hr_api.g_number

Line 2701: ,p_parent_key_value6 in number default hr_api.g_number

2697: ,p_parent_key_column5 in varchar2 default hr_api.g_varchar2
2698: ,p_parent_key_value5 in number default hr_api.g_number
2699: ,p_parent_table_name6 in varchar2 default hr_api.g_varchar2
2700: ,p_parent_key_column6 in varchar2 default hr_api.g_varchar2
2701: ,p_parent_key_value6 in number default hr_api.g_number
2702: ,p_parent_table_name7 in varchar2 default hr_api.g_varchar2
2703: ,p_parent_key_column7 in varchar2 default hr_api.g_varchar2
2704: ,p_parent_key_value7 in number default hr_api.g_number
2705: ,p_parent_table_name8 in varchar2 default hr_api.g_varchar2

Line 2702: ,p_parent_table_name7 in varchar2 default hr_api.g_varchar2

2698: ,p_parent_key_value5 in number default hr_api.g_number
2699: ,p_parent_table_name6 in varchar2 default hr_api.g_varchar2
2700: ,p_parent_key_column6 in varchar2 default hr_api.g_varchar2
2701: ,p_parent_key_value6 in number default hr_api.g_number
2702: ,p_parent_table_name7 in varchar2 default hr_api.g_varchar2
2703: ,p_parent_key_column7 in varchar2 default hr_api.g_varchar2
2704: ,p_parent_key_value7 in number default hr_api.g_number
2705: ,p_parent_table_name8 in varchar2 default hr_api.g_varchar2
2706: ,p_parent_key_column8 in varchar2 default hr_api.g_varchar2

Line 2703: ,p_parent_key_column7 in varchar2 default hr_api.g_varchar2

2699: ,p_parent_table_name6 in varchar2 default hr_api.g_varchar2
2700: ,p_parent_key_column6 in varchar2 default hr_api.g_varchar2
2701: ,p_parent_key_value6 in number default hr_api.g_number
2702: ,p_parent_table_name7 in varchar2 default hr_api.g_varchar2
2703: ,p_parent_key_column7 in varchar2 default hr_api.g_varchar2
2704: ,p_parent_key_value7 in number default hr_api.g_number
2705: ,p_parent_table_name8 in varchar2 default hr_api.g_varchar2
2706: ,p_parent_key_column8 in varchar2 default hr_api.g_varchar2
2707: ,p_parent_key_value8 in number default hr_api.g_number

Line 2704: ,p_parent_key_value7 in number default hr_api.g_number

2700: ,p_parent_key_column6 in varchar2 default hr_api.g_varchar2
2701: ,p_parent_key_value6 in number default hr_api.g_number
2702: ,p_parent_table_name7 in varchar2 default hr_api.g_varchar2
2703: ,p_parent_key_column7 in varchar2 default hr_api.g_varchar2
2704: ,p_parent_key_value7 in number default hr_api.g_number
2705: ,p_parent_table_name8 in varchar2 default hr_api.g_varchar2
2706: ,p_parent_key_column8 in varchar2 default hr_api.g_varchar2
2707: ,p_parent_key_value8 in number default hr_api.g_number
2708: ,p_parent_table_name9 in varchar2 default hr_api.g_varchar2

Line 2705: ,p_parent_table_name8 in varchar2 default hr_api.g_varchar2

2701: ,p_parent_key_value6 in number default hr_api.g_number
2702: ,p_parent_table_name7 in varchar2 default hr_api.g_varchar2
2703: ,p_parent_key_column7 in varchar2 default hr_api.g_varchar2
2704: ,p_parent_key_value7 in number default hr_api.g_number
2705: ,p_parent_table_name8 in varchar2 default hr_api.g_varchar2
2706: ,p_parent_key_column8 in varchar2 default hr_api.g_varchar2
2707: ,p_parent_key_value8 in number default hr_api.g_number
2708: ,p_parent_table_name9 in varchar2 default hr_api.g_varchar2
2709: ,p_parent_key_column9 in varchar2 default hr_api.g_varchar2

Line 2706: ,p_parent_key_column8 in varchar2 default hr_api.g_varchar2

2702: ,p_parent_table_name7 in varchar2 default hr_api.g_varchar2
2703: ,p_parent_key_column7 in varchar2 default hr_api.g_varchar2
2704: ,p_parent_key_value7 in number default hr_api.g_number
2705: ,p_parent_table_name8 in varchar2 default hr_api.g_varchar2
2706: ,p_parent_key_column8 in varchar2 default hr_api.g_varchar2
2707: ,p_parent_key_value8 in number default hr_api.g_number
2708: ,p_parent_table_name9 in varchar2 default hr_api.g_varchar2
2709: ,p_parent_key_column9 in varchar2 default hr_api.g_varchar2
2710: ,p_parent_key_value9 in number default hr_api.g_number

Line 2707: ,p_parent_key_value8 in number default hr_api.g_number

2703: ,p_parent_key_column7 in varchar2 default hr_api.g_varchar2
2704: ,p_parent_key_value7 in number default hr_api.g_number
2705: ,p_parent_table_name8 in varchar2 default hr_api.g_varchar2
2706: ,p_parent_key_column8 in varchar2 default hr_api.g_varchar2
2707: ,p_parent_key_value8 in number default hr_api.g_number
2708: ,p_parent_table_name9 in varchar2 default hr_api.g_varchar2
2709: ,p_parent_key_column9 in varchar2 default hr_api.g_varchar2
2710: ,p_parent_key_value9 in number default hr_api.g_number
2711: ,p_parent_table_name10 in varchar2 default hr_api.g_varchar2

Line 2708: ,p_parent_table_name9 in varchar2 default hr_api.g_varchar2

2704: ,p_parent_key_value7 in number default hr_api.g_number
2705: ,p_parent_table_name8 in varchar2 default hr_api.g_varchar2
2706: ,p_parent_key_column8 in varchar2 default hr_api.g_varchar2
2707: ,p_parent_key_value8 in number default hr_api.g_number
2708: ,p_parent_table_name9 in varchar2 default hr_api.g_varchar2
2709: ,p_parent_key_column9 in varchar2 default hr_api.g_varchar2
2710: ,p_parent_key_value9 in number default hr_api.g_number
2711: ,p_parent_table_name10 in varchar2 default hr_api.g_varchar2
2712: ,p_parent_key_column10 in varchar2 default hr_api.g_varchar2

Line 2709: ,p_parent_key_column9 in varchar2 default hr_api.g_varchar2

2705: ,p_parent_table_name8 in varchar2 default hr_api.g_varchar2
2706: ,p_parent_key_column8 in varchar2 default hr_api.g_varchar2
2707: ,p_parent_key_value8 in number default hr_api.g_number
2708: ,p_parent_table_name9 in varchar2 default hr_api.g_varchar2
2709: ,p_parent_key_column9 in varchar2 default hr_api.g_varchar2
2710: ,p_parent_key_value9 in number default hr_api.g_number
2711: ,p_parent_table_name10 in varchar2 default hr_api.g_varchar2
2712: ,p_parent_key_column10 in varchar2 default hr_api.g_varchar2
2713: ,p_parent_key_value10 in number default hr_api.g_number

Line 2710: ,p_parent_key_value9 in number default hr_api.g_number

2706: ,p_parent_key_column8 in varchar2 default hr_api.g_varchar2
2707: ,p_parent_key_value8 in number default hr_api.g_number
2708: ,p_parent_table_name9 in varchar2 default hr_api.g_varchar2
2709: ,p_parent_key_column9 in varchar2 default hr_api.g_varchar2
2710: ,p_parent_key_value9 in number default hr_api.g_number
2711: ,p_parent_table_name10 in varchar2 default hr_api.g_varchar2
2712: ,p_parent_key_column10 in varchar2 default hr_api.g_varchar2
2713: ,p_parent_key_value10 in number default hr_api.g_number
2714: ,p_zap out nocopy boolean

Line 2711: ,p_parent_table_name10 in varchar2 default hr_api.g_varchar2

2707: ,p_parent_key_value8 in number default hr_api.g_number
2708: ,p_parent_table_name9 in varchar2 default hr_api.g_varchar2
2709: ,p_parent_key_column9 in varchar2 default hr_api.g_varchar2
2710: ,p_parent_key_value9 in number default hr_api.g_number
2711: ,p_parent_table_name10 in varchar2 default hr_api.g_varchar2
2712: ,p_parent_key_column10 in varchar2 default hr_api.g_varchar2
2713: ,p_parent_key_value10 in number default hr_api.g_number
2714: ,p_zap out nocopy boolean
2715: ,p_delete out nocopy boolean

Line 2712: ,p_parent_key_column10 in varchar2 default hr_api.g_varchar2

2708: ,p_parent_table_name9 in varchar2 default hr_api.g_varchar2
2709: ,p_parent_key_column9 in varchar2 default hr_api.g_varchar2
2710: ,p_parent_key_value9 in number default hr_api.g_number
2711: ,p_parent_table_name10 in varchar2 default hr_api.g_varchar2
2712: ,p_parent_key_column10 in varchar2 default hr_api.g_varchar2
2713: ,p_parent_key_value10 in number default hr_api.g_number
2714: ,p_zap out nocopy boolean
2715: ,p_delete out nocopy boolean
2716: ,p_future_change out nocopy boolean

Line 2713: ,p_parent_key_value10 in number default hr_api.g_number

2709: ,p_parent_key_column9 in varchar2 default hr_api.g_varchar2
2710: ,p_parent_key_value9 in number default hr_api.g_number
2711: ,p_parent_table_name10 in varchar2 default hr_api.g_varchar2
2712: ,p_parent_key_column10 in varchar2 default hr_api.g_varchar2
2713: ,p_parent_key_value10 in number default hr_api.g_number
2714: ,p_zap out nocopy boolean
2715: ,p_delete out nocopy boolean
2716: ,p_future_change out nocopy boolean
2717: ,p_delete_next_change out nocopy boolean

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

2744: -- [ start of change 30.14 ]
2745: IF p_base_table_name IS NULL OR
2746: p_base_key_column IS NULL OR
2747: p_base_key_value IS NULL THEN
2748: hr_api.mandatory_arg_error(p_api_name => l_proc,
2749: p_argument => 'p_base_table_name',
2750: p_argument_value => p_base_table_name);
2751: hr_api.mandatory_arg_error(p_api_name => l_proc,
2752: p_argument => 'p_base_key_column',

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

2747: p_base_key_value IS NULL THEN
2748: hr_api.mandatory_arg_error(p_api_name => l_proc,
2749: p_argument => 'p_base_table_name',
2750: p_argument_value => p_base_table_name);
2751: hr_api.mandatory_arg_error(p_api_name => l_proc,
2752: p_argument => 'p_base_key_column',
2753: p_argument_value => p_base_key_column);
2754: hr_api.mandatory_arg_error(p_api_name => l_proc,
2755: p_argument => 'p_base_key_value',

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

2750: p_argument_value => p_base_table_name);
2751: hr_api.mandatory_arg_error(p_api_name => l_proc,
2752: p_argument => 'p_base_key_column',
2753: p_argument_value => p_base_key_column);
2754: hr_api.mandatory_arg_error(p_api_name => l_proc,
2755: p_argument => 'p_base_key_value',
2756: p_argument_value => p_base_key_value);
2757: END IF;
2758: -- [ end of change 30.14 ]