APPS.HR_ICX_UPD dependencies on HR_API

Line 9: (p_segment1 in varchar2 default hr_api.g_varchar2,

5: -- |-------------------------------< upd_or_sel >-----------------------------|
6: -- ----------------------------------------------------------------------------
7: --
8: procedure upd_or_sel
9: (p_segment1 in varchar2 default hr_api.g_varchar2,
10: p_segment2 in varchar2 default hr_api.g_varchar2,
11: p_segment3 in varchar2 default hr_api.g_varchar2,
12: p_segment4 in varchar2 default hr_api.g_varchar2,
13: p_segment5 in varchar2 default hr_api.g_varchar2,

Line 10: p_segment2 in varchar2 default hr_api.g_varchar2,

6: -- ----------------------------------------------------------------------------
7: --
8: procedure upd_or_sel
9: (p_segment1 in varchar2 default hr_api.g_varchar2,
10: p_segment2 in varchar2 default hr_api.g_varchar2,
11: p_segment3 in varchar2 default hr_api.g_varchar2,
12: p_segment4 in varchar2 default hr_api.g_varchar2,
13: p_segment5 in varchar2 default hr_api.g_varchar2,
14: p_segment6 in varchar2 default hr_api.g_varchar2,

Line 11: p_segment3 in varchar2 default hr_api.g_varchar2,

7: --
8: procedure upd_or_sel
9: (p_segment1 in varchar2 default hr_api.g_varchar2,
10: p_segment2 in varchar2 default hr_api.g_varchar2,
11: p_segment3 in varchar2 default hr_api.g_varchar2,
12: p_segment4 in varchar2 default hr_api.g_varchar2,
13: p_segment5 in varchar2 default hr_api.g_varchar2,
14: p_segment6 in varchar2 default hr_api.g_varchar2,
15: p_segment7 in varchar2 default hr_api.g_varchar2,

Line 12: p_segment4 in varchar2 default hr_api.g_varchar2,

8: procedure upd_or_sel
9: (p_segment1 in varchar2 default hr_api.g_varchar2,
10: p_segment2 in varchar2 default hr_api.g_varchar2,
11: p_segment3 in varchar2 default hr_api.g_varchar2,
12: p_segment4 in varchar2 default hr_api.g_varchar2,
13: p_segment5 in varchar2 default hr_api.g_varchar2,
14: p_segment6 in varchar2 default hr_api.g_varchar2,
15: p_segment7 in varchar2 default hr_api.g_varchar2,
16: p_segment8 in varchar2 default hr_api.g_varchar2,

Line 13: p_segment5 in varchar2 default hr_api.g_varchar2,

9: (p_segment1 in varchar2 default hr_api.g_varchar2,
10: p_segment2 in varchar2 default hr_api.g_varchar2,
11: p_segment3 in varchar2 default hr_api.g_varchar2,
12: p_segment4 in varchar2 default hr_api.g_varchar2,
13: p_segment5 in varchar2 default hr_api.g_varchar2,
14: p_segment6 in varchar2 default hr_api.g_varchar2,
15: p_segment7 in varchar2 default hr_api.g_varchar2,
16: p_segment8 in varchar2 default hr_api.g_varchar2,
17: p_segment9 in varchar2 default hr_api.g_varchar2,

Line 14: p_segment6 in varchar2 default hr_api.g_varchar2,

10: p_segment2 in varchar2 default hr_api.g_varchar2,
11: p_segment3 in varchar2 default hr_api.g_varchar2,
12: p_segment4 in varchar2 default hr_api.g_varchar2,
13: p_segment5 in varchar2 default hr_api.g_varchar2,
14: p_segment6 in varchar2 default hr_api.g_varchar2,
15: p_segment7 in varchar2 default hr_api.g_varchar2,
16: p_segment8 in varchar2 default hr_api.g_varchar2,
17: p_segment9 in varchar2 default hr_api.g_varchar2,
18: p_segment10 in varchar2 default hr_api.g_varchar2,

Line 15: p_segment7 in varchar2 default hr_api.g_varchar2,

11: p_segment3 in varchar2 default hr_api.g_varchar2,
12: p_segment4 in varchar2 default hr_api.g_varchar2,
13: p_segment5 in varchar2 default hr_api.g_varchar2,
14: p_segment6 in varchar2 default hr_api.g_varchar2,
15: p_segment7 in varchar2 default hr_api.g_varchar2,
16: p_segment8 in varchar2 default hr_api.g_varchar2,
17: p_segment9 in varchar2 default hr_api.g_varchar2,
18: p_segment10 in varchar2 default hr_api.g_varchar2,
19: p_segment11 in varchar2 default hr_api.g_varchar2,

Line 16: p_segment8 in varchar2 default hr_api.g_varchar2,

12: p_segment4 in varchar2 default hr_api.g_varchar2,
13: p_segment5 in varchar2 default hr_api.g_varchar2,
14: p_segment6 in varchar2 default hr_api.g_varchar2,
15: p_segment7 in varchar2 default hr_api.g_varchar2,
16: p_segment8 in varchar2 default hr_api.g_varchar2,
17: p_segment9 in varchar2 default hr_api.g_varchar2,
18: p_segment10 in varchar2 default hr_api.g_varchar2,
19: p_segment11 in varchar2 default hr_api.g_varchar2,
20: p_segment12 in varchar2 default hr_api.g_varchar2,

Line 17: p_segment9 in varchar2 default hr_api.g_varchar2,

13: p_segment5 in varchar2 default hr_api.g_varchar2,
14: p_segment6 in varchar2 default hr_api.g_varchar2,
15: p_segment7 in varchar2 default hr_api.g_varchar2,
16: p_segment8 in varchar2 default hr_api.g_varchar2,
17: p_segment9 in varchar2 default hr_api.g_varchar2,
18: p_segment10 in varchar2 default hr_api.g_varchar2,
19: p_segment11 in varchar2 default hr_api.g_varchar2,
20: p_segment12 in varchar2 default hr_api.g_varchar2,
21: p_segment13 in varchar2 default hr_api.g_varchar2,

Line 18: p_segment10 in varchar2 default hr_api.g_varchar2,

14: p_segment6 in varchar2 default hr_api.g_varchar2,
15: p_segment7 in varchar2 default hr_api.g_varchar2,
16: p_segment8 in varchar2 default hr_api.g_varchar2,
17: p_segment9 in varchar2 default hr_api.g_varchar2,
18: p_segment10 in varchar2 default hr_api.g_varchar2,
19: p_segment11 in varchar2 default hr_api.g_varchar2,
20: p_segment12 in varchar2 default hr_api.g_varchar2,
21: p_segment13 in varchar2 default hr_api.g_varchar2,
22: p_segment14 in varchar2 default hr_api.g_varchar2,

Line 19: p_segment11 in varchar2 default hr_api.g_varchar2,

15: p_segment7 in varchar2 default hr_api.g_varchar2,
16: p_segment8 in varchar2 default hr_api.g_varchar2,
17: p_segment9 in varchar2 default hr_api.g_varchar2,
18: p_segment10 in varchar2 default hr_api.g_varchar2,
19: p_segment11 in varchar2 default hr_api.g_varchar2,
20: p_segment12 in varchar2 default hr_api.g_varchar2,
21: p_segment13 in varchar2 default hr_api.g_varchar2,
22: p_segment14 in varchar2 default hr_api.g_varchar2,
23: p_segment15 in varchar2 default hr_api.g_varchar2,

Line 20: p_segment12 in varchar2 default hr_api.g_varchar2,

16: p_segment8 in varchar2 default hr_api.g_varchar2,
17: p_segment9 in varchar2 default hr_api.g_varchar2,
18: p_segment10 in varchar2 default hr_api.g_varchar2,
19: p_segment11 in varchar2 default hr_api.g_varchar2,
20: p_segment12 in varchar2 default hr_api.g_varchar2,
21: p_segment13 in varchar2 default hr_api.g_varchar2,
22: p_segment14 in varchar2 default hr_api.g_varchar2,
23: p_segment15 in varchar2 default hr_api.g_varchar2,
24: p_segment16 in varchar2 default hr_api.g_varchar2,

Line 21: p_segment13 in varchar2 default hr_api.g_varchar2,

17: p_segment9 in varchar2 default hr_api.g_varchar2,
18: p_segment10 in varchar2 default hr_api.g_varchar2,
19: p_segment11 in varchar2 default hr_api.g_varchar2,
20: p_segment12 in varchar2 default hr_api.g_varchar2,
21: p_segment13 in varchar2 default hr_api.g_varchar2,
22: p_segment14 in varchar2 default hr_api.g_varchar2,
23: p_segment15 in varchar2 default hr_api.g_varchar2,
24: p_segment16 in varchar2 default hr_api.g_varchar2,
25: p_segment17 in varchar2 default hr_api.g_varchar2,

Line 22: p_segment14 in varchar2 default hr_api.g_varchar2,

18: p_segment10 in varchar2 default hr_api.g_varchar2,
19: p_segment11 in varchar2 default hr_api.g_varchar2,
20: p_segment12 in varchar2 default hr_api.g_varchar2,
21: p_segment13 in varchar2 default hr_api.g_varchar2,
22: p_segment14 in varchar2 default hr_api.g_varchar2,
23: p_segment15 in varchar2 default hr_api.g_varchar2,
24: p_segment16 in varchar2 default hr_api.g_varchar2,
25: p_segment17 in varchar2 default hr_api.g_varchar2,
26: p_segment18 in varchar2 default hr_api.g_varchar2,

Line 23: p_segment15 in varchar2 default hr_api.g_varchar2,

19: p_segment11 in varchar2 default hr_api.g_varchar2,
20: p_segment12 in varchar2 default hr_api.g_varchar2,
21: p_segment13 in varchar2 default hr_api.g_varchar2,
22: p_segment14 in varchar2 default hr_api.g_varchar2,
23: p_segment15 in varchar2 default hr_api.g_varchar2,
24: p_segment16 in varchar2 default hr_api.g_varchar2,
25: p_segment17 in varchar2 default hr_api.g_varchar2,
26: p_segment18 in varchar2 default hr_api.g_varchar2,
27: p_segment19 in varchar2 default hr_api.g_varchar2,

Line 24: p_segment16 in varchar2 default hr_api.g_varchar2,

20: p_segment12 in varchar2 default hr_api.g_varchar2,
21: p_segment13 in varchar2 default hr_api.g_varchar2,
22: p_segment14 in varchar2 default hr_api.g_varchar2,
23: p_segment15 in varchar2 default hr_api.g_varchar2,
24: p_segment16 in varchar2 default hr_api.g_varchar2,
25: p_segment17 in varchar2 default hr_api.g_varchar2,
26: p_segment18 in varchar2 default hr_api.g_varchar2,
27: p_segment19 in varchar2 default hr_api.g_varchar2,
28: p_segment20 in varchar2 default hr_api.g_varchar2,

Line 25: p_segment17 in varchar2 default hr_api.g_varchar2,

21: p_segment13 in varchar2 default hr_api.g_varchar2,
22: p_segment14 in varchar2 default hr_api.g_varchar2,
23: p_segment15 in varchar2 default hr_api.g_varchar2,
24: p_segment16 in varchar2 default hr_api.g_varchar2,
25: p_segment17 in varchar2 default hr_api.g_varchar2,
26: p_segment18 in varchar2 default hr_api.g_varchar2,
27: p_segment19 in varchar2 default hr_api.g_varchar2,
28: p_segment20 in varchar2 default hr_api.g_varchar2,
29: p_segment21 in varchar2 default hr_api.g_varchar2,

Line 26: p_segment18 in varchar2 default hr_api.g_varchar2,

22: p_segment14 in varchar2 default hr_api.g_varchar2,
23: p_segment15 in varchar2 default hr_api.g_varchar2,
24: p_segment16 in varchar2 default hr_api.g_varchar2,
25: p_segment17 in varchar2 default hr_api.g_varchar2,
26: p_segment18 in varchar2 default hr_api.g_varchar2,
27: p_segment19 in varchar2 default hr_api.g_varchar2,
28: p_segment20 in varchar2 default hr_api.g_varchar2,
29: p_segment21 in varchar2 default hr_api.g_varchar2,
30: p_segment22 in varchar2 default hr_api.g_varchar2,

Line 27: p_segment19 in varchar2 default hr_api.g_varchar2,

23: p_segment15 in varchar2 default hr_api.g_varchar2,
24: p_segment16 in varchar2 default hr_api.g_varchar2,
25: p_segment17 in varchar2 default hr_api.g_varchar2,
26: p_segment18 in varchar2 default hr_api.g_varchar2,
27: p_segment19 in varchar2 default hr_api.g_varchar2,
28: p_segment20 in varchar2 default hr_api.g_varchar2,
29: p_segment21 in varchar2 default hr_api.g_varchar2,
30: p_segment22 in varchar2 default hr_api.g_varchar2,
31: p_segment23 in varchar2 default hr_api.g_varchar2,

Line 28: p_segment20 in varchar2 default hr_api.g_varchar2,

24: p_segment16 in varchar2 default hr_api.g_varchar2,
25: p_segment17 in varchar2 default hr_api.g_varchar2,
26: p_segment18 in varchar2 default hr_api.g_varchar2,
27: p_segment19 in varchar2 default hr_api.g_varchar2,
28: p_segment20 in varchar2 default hr_api.g_varchar2,
29: p_segment21 in varchar2 default hr_api.g_varchar2,
30: p_segment22 in varchar2 default hr_api.g_varchar2,
31: p_segment23 in varchar2 default hr_api.g_varchar2,
32: p_segment24 in varchar2 default hr_api.g_varchar2,

Line 29: p_segment21 in varchar2 default hr_api.g_varchar2,

25: p_segment17 in varchar2 default hr_api.g_varchar2,
26: p_segment18 in varchar2 default hr_api.g_varchar2,
27: p_segment19 in varchar2 default hr_api.g_varchar2,
28: p_segment20 in varchar2 default hr_api.g_varchar2,
29: p_segment21 in varchar2 default hr_api.g_varchar2,
30: p_segment22 in varchar2 default hr_api.g_varchar2,
31: p_segment23 in varchar2 default hr_api.g_varchar2,
32: p_segment24 in varchar2 default hr_api.g_varchar2,
33: p_segment25 in varchar2 default hr_api.g_varchar2,

Line 30: p_segment22 in varchar2 default hr_api.g_varchar2,

26: p_segment18 in varchar2 default hr_api.g_varchar2,
27: p_segment19 in varchar2 default hr_api.g_varchar2,
28: p_segment20 in varchar2 default hr_api.g_varchar2,
29: p_segment21 in varchar2 default hr_api.g_varchar2,
30: p_segment22 in varchar2 default hr_api.g_varchar2,
31: p_segment23 in varchar2 default hr_api.g_varchar2,
32: p_segment24 in varchar2 default hr_api.g_varchar2,
33: p_segment25 in varchar2 default hr_api.g_varchar2,
34: p_segment26 in varchar2 default hr_api.g_varchar2,

Line 31: p_segment23 in varchar2 default hr_api.g_varchar2,

27: p_segment19 in varchar2 default hr_api.g_varchar2,
28: p_segment20 in varchar2 default hr_api.g_varchar2,
29: p_segment21 in varchar2 default hr_api.g_varchar2,
30: p_segment22 in varchar2 default hr_api.g_varchar2,
31: p_segment23 in varchar2 default hr_api.g_varchar2,
32: p_segment24 in varchar2 default hr_api.g_varchar2,
33: p_segment25 in varchar2 default hr_api.g_varchar2,
34: p_segment26 in varchar2 default hr_api.g_varchar2,
35: p_segment27 in varchar2 default hr_api.g_varchar2,

Line 32: p_segment24 in varchar2 default hr_api.g_varchar2,

28: p_segment20 in varchar2 default hr_api.g_varchar2,
29: p_segment21 in varchar2 default hr_api.g_varchar2,
30: p_segment22 in varchar2 default hr_api.g_varchar2,
31: p_segment23 in varchar2 default hr_api.g_varchar2,
32: p_segment24 in varchar2 default hr_api.g_varchar2,
33: p_segment25 in varchar2 default hr_api.g_varchar2,
34: p_segment26 in varchar2 default hr_api.g_varchar2,
35: p_segment27 in varchar2 default hr_api.g_varchar2,
36: p_segment28 in varchar2 default hr_api.g_varchar2,

Line 33: p_segment25 in varchar2 default hr_api.g_varchar2,

29: p_segment21 in varchar2 default hr_api.g_varchar2,
30: p_segment22 in varchar2 default hr_api.g_varchar2,
31: p_segment23 in varchar2 default hr_api.g_varchar2,
32: p_segment24 in varchar2 default hr_api.g_varchar2,
33: p_segment25 in varchar2 default hr_api.g_varchar2,
34: p_segment26 in varchar2 default hr_api.g_varchar2,
35: p_segment27 in varchar2 default hr_api.g_varchar2,
36: p_segment28 in varchar2 default hr_api.g_varchar2,
37: p_segment29 in varchar2 default hr_api.g_varchar2,

Line 34: p_segment26 in varchar2 default hr_api.g_varchar2,

30: p_segment22 in varchar2 default hr_api.g_varchar2,
31: p_segment23 in varchar2 default hr_api.g_varchar2,
32: p_segment24 in varchar2 default hr_api.g_varchar2,
33: p_segment25 in varchar2 default hr_api.g_varchar2,
34: p_segment26 in varchar2 default hr_api.g_varchar2,
35: p_segment27 in varchar2 default hr_api.g_varchar2,
36: p_segment28 in varchar2 default hr_api.g_varchar2,
37: p_segment29 in varchar2 default hr_api.g_varchar2,
38: p_segment30 in varchar2 default hr_api.g_varchar2,

Line 35: p_segment27 in varchar2 default hr_api.g_varchar2,

31: p_segment23 in varchar2 default hr_api.g_varchar2,
32: p_segment24 in varchar2 default hr_api.g_varchar2,
33: p_segment25 in varchar2 default hr_api.g_varchar2,
34: p_segment26 in varchar2 default hr_api.g_varchar2,
35: p_segment27 in varchar2 default hr_api.g_varchar2,
36: p_segment28 in varchar2 default hr_api.g_varchar2,
37: p_segment29 in varchar2 default hr_api.g_varchar2,
38: p_segment30 in varchar2 default hr_api.g_varchar2,
39: p_context_type in varchar2 default hr_api.g_varchar2,

Line 36: p_segment28 in varchar2 default hr_api.g_varchar2,

32: p_segment24 in varchar2 default hr_api.g_varchar2,
33: p_segment25 in varchar2 default hr_api.g_varchar2,
34: p_segment26 in varchar2 default hr_api.g_varchar2,
35: p_segment27 in varchar2 default hr_api.g_varchar2,
36: p_segment28 in varchar2 default hr_api.g_varchar2,
37: p_segment29 in varchar2 default hr_api.g_varchar2,
38: p_segment30 in varchar2 default hr_api.g_varchar2,
39: p_context_type in varchar2 default hr_api.g_varchar2,
40: p_item_context_id in out nocopy number,

Line 37: p_segment29 in varchar2 default hr_api.g_varchar2,

33: p_segment25 in varchar2 default hr_api.g_varchar2,
34: p_segment26 in varchar2 default hr_api.g_varchar2,
35: p_segment27 in varchar2 default hr_api.g_varchar2,
36: p_segment28 in varchar2 default hr_api.g_varchar2,
37: p_segment29 in varchar2 default hr_api.g_varchar2,
38: p_segment30 in varchar2 default hr_api.g_varchar2,
39: p_context_type in varchar2 default hr_api.g_varchar2,
40: p_item_context_id in out nocopy number,
41: p_object_version_number in out nocopy number,

Line 38: p_segment30 in varchar2 default hr_api.g_varchar2,

34: p_segment26 in varchar2 default hr_api.g_varchar2,
35: p_segment27 in varchar2 default hr_api.g_varchar2,
36: p_segment28 in varchar2 default hr_api.g_varchar2,
37: p_segment29 in varchar2 default hr_api.g_varchar2,
38: p_segment30 in varchar2 default hr_api.g_varchar2,
39: p_context_type in varchar2 default hr_api.g_varchar2,
40: p_item_context_id in out nocopy number,
41: p_object_version_number in out nocopy number,
42: p_concatenated_segments out nocopy varchar2

Line 39: p_context_type in varchar2 default hr_api.g_varchar2,

35: p_segment27 in varchar2 default hr_api.g_varchar2,
36: p_segment28 in varchar2 default hr_api.g_varchar2,
37: p_segment29 in varchar2 default hr_api.g_varchar2,
38: p_segment30 in varchar2 default hr_api.g_varchar2,
39: p_context_type in varchar2 default hr_api.g_varchar2,
40: p_item_context_id in out nocopy number,
41: p_object_version_number in out nocopy number,
42: p_concatenated_segments out nocopy varchar2
43: );

Line 141: ,p_id_flex_num in number default hr_api.g_number

137: Procedure upd
138: (p_effective_date in date
139: ,p_object_version_number in out nocopy number
140: ,p_item_context_id in number
141: ,p_id_flex_num in number default hr_api.g_number
142: ,p_summary_flag in varchar2 default hr_api.g_varchar2
143: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
144: ,p_start_date_active in date default hr_api.g_date
145: ,p_end_date_active in date default hr_api.g_date

Line 142: ,p_summary_flag in varchar2 default hr_api.g_varchar2

138: (p_effective_date in date
139: ,p_object_version_number in out nocopy number
140: ,p_item_context_id in number
141: ,p_id_flex_num in number default hr_api.g_number
142: ,p_summary_flag in varchar2 default hr_api.g_varchar2
143: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
144: ,p_start_date_active in date default hr_api.g_date
145: ,p_end_date_active in date default hr_api.g_date
146: ,p_segment1 in varchar2 default hr_api.g_varchar2

Line 143: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

139: ,p_object_version_number in out nocopy number
140: ,p_item_context_id in number
141: ,p_id_flex_num in number default hr_api.g_number
142: ,p_summary_flag in varchar2 default hr_api.g_varchar2
143: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
144: ,p_start_date_active in date default hr_api.g_date
145: ,p_end_date_active in date default hr_api.g_date
146: ,p_segment1 in varchar2 default hr_api.g_varchar2
147: ,p_segment2 in varchar2 default hr_api.g_varchar2

Line 144: ,p_start_date_active in date default hr_api.g_date

140: ,p_item_context_id in number
141: ,p_id_flex_num in number default hr_api.g_number
142: ,p_summary_flag in varchar2 default hr_api.g_varchar2
143: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
144: ,p_start_date_active in date default hr_api.g_date
145: ,p_end_date_active in date default hr_api.g_date
146: ,p_segment1 in varchar2 default hr_api.g_varchar2
147: ,p_segment2 in varchar2 default hr_api.g_varchar2
148: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 145: ,p_end_date_active in date default hr_api.g_date

141: ,p_id_flex_num in number default hr_api.g_number
142: ,p_summary_flag in varchar2 default hr_api.g_varchar2
143: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
144: ,p_start_date_active in date default hr_api.g_date
145: ,p_end_date_active in date default hr_api.g_date
146: ,p_segment1 in varchar2 default hr_api.g_varchar2
147: ,p_segment2 in varchar2 default hr_api.g_varchar2
148: ,p_segment3 in varchar2 default hr_api.g_varchar2
149: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 146: ,p_segment1 in varchar2 default hr_api.g_varchar2

142: ,p_summary_flag in varchar2 default hr_api.g_varchar2
143: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
144: ,p_start_date_active in date default hr_api.g_date
145: ,p_end_date_active in date default hr_api.g_date
146: ,p_segment1 in varchar2 default hr_api.g_varchar2
147: ,p_segment2 in varchar2 default hr_api.g_varchar2
148: ,p_segment3 in varchar2 default hr_api.g_varchar2
149: ,p_segment4 in varchar2 default hr_api.g_varchar2
150: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 147: ,p_segment2 in varchar2 default hr_api.g_varchar2

143: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
144: ,p_start_date_active in date default hr_api.g_date
145: ,p_end_date_active in date default hr_api.g_date
146: ,p_segment1 in varchar2 default hr_api.g_varchar2
147: ,p_segment2 in varchar2 default hr_api.g_varchar2
148: ,p_segment3 in varchar2 default hr_api.g_varchar2
149: ,p_segment4 in varchar2 default hr_api.g_varchar2
150: ,p_segment5 in varchar2 default hr_api.g_varchar2
151: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 148: ,p_segment3 in varchar2 default hr_api.g_varchar2

144: ,p_start_date_active in date default hr_api.g_date
145: ,p_end_date_active in date default hr_api.g_date
146: ,p_segment1 in varchar2 default hr_api.g_varchar2
147: ,p_segment2 in varchar2 default hr_api.g_varchar2
148: ,p_segment3 in varchar2 default hr_api.g_varchar2
149: ,p_segment4 in varchar2 default hr_api.g_varchar2
150: ,p_segment5 in varchar2 default hr_api.g_varchar2
151: ,p_segment6 in varchar2 default hr_api.g_varchar2
152: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 149: ,p_segment4 in varchar2 default hr_api.g_varchar2

145: ,p_end_date_active in date default hr_api.g_date
146: ,p_segment1 in varchar2 default hr_api.g_varchar2
147: ,p_segment2 in varchar2 default hr_api.g_varchar2
148: ,p_segment3 in varchar2 default hr_api.g_varchar2
149: ,p_segment4 in varchar2 default hr_api.g_varchar2
150: ,p_segment5 in varchar2 default hr_api.g_varchar2
151: ,p_segment6 in varchar2 default hr_api.g_varchar2
152: ,p_segment7 in varchar2 default hr_api.g_varchar2
153: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 150: ,p_segment5 in varchar2 default hr_api.g_varchar2

146: ,p_segment1 in varchar2 default hr_api.g_varchar2
147: ,p_segment2 in varchar2 default hr_api.g_varchar2
148: ,p_segment3 in varchar2 default hr_api.g_varchar2
149: ,p_segment4 in varchar2 default hr_api.g_varchar2
150: ,p_segment5 in varchar2 default hr_api.g_varchar2
151: ,p_segment6 in varchar2 default hr_api.g_varchar2
152: ,p_segment7 in varchar2 default hr_api.g_varchar2
153: ,p_segment8 in varchar2 default hr_api.g_varchar2
154: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 151: ,p_segment6 in varchar2 default hr_api.g_varchar2

147: ,p_segment2 in varchar2 default hr_api.g_varchar2
148: ,p_segment3 in varchar2 default hr_api.g_varchar2
149: ,p_segment4 in varchar2 default hr_api.g_varchar2
150: ,p_segment5 in varchar2 default hr_api.g_varchar2
151: ,p_segment6 in varchar2 default hr_api.g_varchar2
152: ,p_segment7 in varchar2 default hr_api.g_varchar2
153: ,p_segment8 in varchar2 default hr_api.g_varchar2
154: ,p_segment9 in varchar2 default hr_api.g_varchar2
155: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 152: ,p_segment7 in varchar2 default hr_api.g_varchar2

148: ,p_segment3 in varchar2 default hr_api.g_varchar2
149: ,p_segment4 in varchar2 default hr_api.g_varchar2
150: ,p_segment5 in varchar2 default hr_api.g_varchar2
151: ,p_segment6 in varchar2 default hr_api.g_varchar2
152: ,p_segment7 in varchar2 default hr_api.g_varchar2
153: ,p_segment8 in varchar2 default hr_api.g_varchar2
154: ,p_segment9 in varchar2 default hr_api.g_varchar2
155: ,p_segment10 in varchar2 default hr_api.g_varchar2
156: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 153: ,p_segment8 in varchar2 default hr_api.g_varchar2

149: ,p_segment4 in varchar2 default hr_api.g_varchar2
150: ,p_segment5 in varchar2 default hr_api.g_varchar2
151: ,p_segment6 in varchar2 default hr_api.g_varchar2
152: ,p_segment7 in varchar2 default hr_api.g_varchar2
153: ,p_segment8 in varchar2 default hr_api.g_varchar2
154: ,p_segment9 in varchar2 default hr_api.g_varchar2
155: ,p_segment10 in varchar2 default hr_api.g_varchar2
156: ,p_segment11 in varchar2 default hr_api.g_varchar2
157: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 154: ,p_segment9 in varchar2 default hr_api.g_varchar2

150: ,p_segment5 in varchar2 default hr_api.g_varchar2
151: ,p_segment6 in varchar2 default hr_api.g_varchar2
152: ,p_segment7 in varchar2 default hr_api.g_varchar2
153: ,p_segment8 in varchar2 default hr_api.g_varchar2
154: ,p_segment9 in varchar2 default hr_api.g_varchar2
155: ,p_segment10 in varchar2 default hr_api.g_varchar2
156: ,p_segment11 in varchar2 default hr_api.g_varchar2
157: ,p_segment12 in varchar2 default hr_api.g_varchar2
158: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 155: ,p_segment10 in varchar2 default hr_api.g_varchar2

151: ,p_segment6 in varchar2 default hr_api.g_varchar2
152: ,p_segment7 in varchar2 default hr_api.g_varchar2
153: ,p_segment8 in varchar2 default hr_api.g_varchar2
154: ,p_segment9 in varchar2 default hr_api.g_varchar2
155: ,p_segment10 in varchar2 default hr_api.g_varchar2
156: ,p_segment11 in varchar2 default hr_api.g_varchar2
157: ,p_segment12 in varchar2 default hr_api.g_varchar2
158: ,p_segment13 in varchar2 default hr_api.g_varchar2
159: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 156: ,p_segment11 in varchar2 default hr_api.g_varchar2

152: ,p_segment7 in varchar2 default hr_api.g_varchar2
153: ,p_segment8 in varchar2 default hr_api.g_varchar2
154: ,p_segment9 in varchar2 default hr_api.g_varchar2
155: ,p_segment10 in varchar2 default hr_api.g_varchar2
156: ,p_segment11 in varchar2 default hr_api.g_varchar2
157: ,p_segment12 in varchar2 default hr_api.g_varchar2
158: ,p_segment13 in varchar2 default hr_api.g_varchar2
159: ,p_segment14 in varchar2 default hr_api.g_varchar2
160: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 157: ,p_segment12 in varchar2 default hr_api.g_varchar2

153: ,p_segment8 in varchar2 default hr_api.g_varchar2
154: ,p_segment9 in varchar2 default hr_api.g_varchar2
155: ,p_segment10 in varchar2 default hr_api.g_varchar2
156: ,p_segment11 in varchar2 default hr_api.g_varchar2
157: ,p_segment12 in varchar2 default hr_api.g_varchar2
158: ,p_segment13 in varchar2 default hr_api.g_varchar2
159: ,p_segment14 in varchar2 default hr_api.g_varchar2
160: ,p_segment15 in varchar2 default hr_api.g_varchar2
161: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 158: ,p_segment13 in varchar2 default hr_api.g_varchar2

154: ,p_segment9 in varchar2 default hr_api.g_varchar2
155: ,p_segment10 in varchar2 default hr_api.g_varchar2
156: ,p_segment11 in varchar2 default hr_api.g_varchar2
157: ,p_segment12 in varchar2 default hr_api.g_varchar2
158: ,p_segment13 in varchar2 default hr_api.g_varchar2
159: ,p_segment14 in varchar2 default hr_api.g_varchar2
160: ,p_segment15 in varchar2 default hr_api.g_varchar2
161: ,p_segment16 in varchar2 default hr_api.g_varchar2
162: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 159: ,p_segment14 in varchar2 default hr_api.g_varchar2

155: ,p_segment10 in varchar2 default hr_api.g_varchar2
156: ,p_segment11 in varchar2 default hr_api.g_varchar2
157: ,p_segment12 in varchar2 default hr_api.g_varchar2
158: ,p_segment13 in varchar2 default hr_api.g_varchar2
159: ,p_segment14 in varchar2 default hr_api.g_varchar2
160: ,p_segment15 in varchar2 default hr_api.g_varchar2
161: ,p_segment16 in varchar2 default hr_api.g_varchar2
162: ,p_segment17 in varchar2 default hr_api.g_varchar2
163: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 160: ,p_segment15 in varchar2 default hr_api.g_varchar2

156: ,p_segment11 in varchar2 default hr_api.g_varchar2
157: ,p_segment12 in varchar2 default hr_api.g_varchar2
158: ,p_segment13 in varchar2 default hr_api.g_varchar2
159: ,p_segment14 in varchar2 default hr_api.g_varchar2
160: ,p_segment15 in varchar2 default hr_api.g_varchar2
161: ,p_segment16 in varchar2 default hr_api.g_varchar2
162: ,p_segment17 in varchar2 default hr_api.g_varchar2
163: ,p_segment18 in varchar2 default hr_api.g_varchar2
164: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 161: ,p_segment16 in varchar2 default hr_api.g_varchar2

157: ,p_segment12 in varchar2 default hr_api.g_varchar2
158: ,p_segment13 in varchar2 default hr_api.g_varchar2
159: ,p_segment14 in varchar2 default hr_api.g_varchar2
160: ,p_segment15 in varchar2 default hr_api.g_varchar2
161: ,p_segment16 in varchar2 default hr_api.g_varchar2
162: ,p_segment17 in varchar2 default hr_api.g_varchar2
163: ,p_segment18 in varchar2 default hr_api.g_varchar2
164: ,p_segment19 in varchar2 default hr_api.g_varchar2
165: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 162: ,p_segment17 in varchar2 default hr_api.g_varchar2

158: ,p_segment13 in varchar2 default hr_api.g_varchar2
159: ,p_segment14 in varchar2 default hr_api.g_varchar2
160: ,p_segment15 in varchar2 default hr_api.g_varchar2
161: ,p_segment16 in varchar2 default hr_api.g_varchar2
162: ,p_segment17 in varchar2 default hr_api.g_varchar2
163: ,p_segment18 in varchar2 default hr_api.g_varchar2
164: ,p_segment19 in varchar2 default hr_api.g_varchar2
165: ,p_segment20 in varchar2 default hr_api.g_varchar2
166: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 163: ,p_segment18 in varchar2 default hr_api.g_varchar2

159: ,p_segment14 in varchar2 default hr_api.g_varchar2
160: ,p_segment15 in varchar2 default hr_api.g_varchar2
161: ,p_segment16 in varchar2 default hr_api.g_varchar2
162: ,p_segment17 in varchar2 default hr_api.g_varchar2
163: ,p_segment18 in varchar2 default hr_api.g_varchar2
164: ,p_segment19 in varchar2 default hr_api.g_varchar2
165: ,p_segment20 in varchar2 default hr_api.g_varchar2
166: ,p_segment21 in varchar2 default hr_api.g_varchar2
167: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 164: ,p_segment19 in varchar2 default hr_api.g_varchar2

160: ,p_segment15 in varchar2 default hr_api.g_varchar2
161: ,p_segment16 in varchar2 default hr_api.g_varchar2
162: ,p_segment17 in varchar2 default hr_api.g_varchar2
163: ,p_segment18 in varchar2 default hr_api.g_varchar2
164: ,p_segment19 in varchar2 default hr_api.g_varchar2
165: ,p_segment20 in varchar2 default hr_api.g_varchar2
166: ,p_segment21 in varchar2 default hr_api.g_varchar2
167: ,p_segment22 in varchar2 default hr_api.g_varchar2
168: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 165: ,p_segment20 in varchar2 default hr_api.g_varchar2

161: ,p_segment16 in varchar2 default hr_api.g_varchar2
162: ,p_segment17 in varchar2 default hr_api.g_varchar2
163: ,p_segment18 in varchar2 default hr_api.g_varchar2
164: ,p_segment19 in varchar2 default hr_api.g_varchar2
165: ,p_segment20 in varchar2 default hr_api.g_varchar2
166: ,p_segment21 in varchar2 default hr_api.g_varchar2
167: ,p_segment22 in varchar2 default hr_api.g_varchar2
168: ,p_segment23 in varchar2 default hr_api.g_varchar2
169: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 166: ,p_segment21 in varchar2 default hr_api.g_varchar2

162: ,p_segment17 in varchar2 default hr_api.g_varchar2
163: ,p_segment18 in varchar2 default hr_api.g_varchar2
164: ,p_segment19 in varchar2 default hr_api.g_varchar2
165: ,p_segment20 in varchar2 default hr_api.g_varchar2
166: ,p_segment21 in varchar2 default hr_api.g_varchar2
167: ,p_segment22 in varchar2 default hr_api.g_varchar2
168: ,p_segment23 in varchar2 default hr_api.g_varchar2
169: ,p_segment24 in varchar2 default hr_api.g_varchar2
170: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 167: ,p_segment22 in varchar2 default hr_api.g_varchar2

163: ,p_segment18 in varchar2 default hr_api.g_varchar2
164: ,p_segment19 in varchar2 default hr_api.g_varchar2
165: ,p_segment20 in varchar2 default hr_api.g_varchar2
166: ,p_segment21 in varchar2 default hr_api.g_varchar2
167: ,p_segment22 in varchar2 default hr_api.g_varchar2
168: ,p_segment23 in varchar2 default hr_api.g_varchar2
169: ,p_segment24 in varchar2 default hr_api.g_varchar2
170: ,p_segment25 in varchar2 default hr_api.g_varchar2
171: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 168: ,p_segment23 in varchar2 default hr_api.g_varchar2

164: ,p_segment19 in varchar2 default hr_api.g_varchar2
165: ,p_segment20 in varchar2 default hr_api.g_varchar2
166: ,p_segment21 in varchar2 default hr_api.g_varchar2
167: ,p_segment22 in varchar2 default hr_api.g_varchar2
168: ,p_segment23 in varchar2 default hr_api.g_varchar2
169: ,p_segment24 in varchar2 default hr_api.g_varchar2
170: ,p_segment25 in varchar2 default hr_api.g_varchar2
171: ,p_segment26 in varchar2 default hr_api.g_varchar2
172: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 169: ,p_segment24 in varchar2 default hr_api.g_varchar2

165: ,p_segment20 in varchar2 default hr_api.g_varchar2
166: ,p_segment21 in varchar2 default hr_api.g_varchar2
167: ,p_segment22 in varchar2 default hr_api.g_varchar2
168: ,p_segment23 in varchar2 default hr_api.g_varchar2
169: ,p_segment24 in varchar2 default hr_api.g_varchar2
170: ,p_segment25 in varchar2 default hr_api.g_varchar2
171: ,p_segment26 in varchar2 default hr_api.g_varchar2
172: ,p_segment27 in varchar2 default hr_api.g_varchar2
173: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 170: ,p_segment25 in varchar2 default hr_api.g_varchar2

166: ,p_segment21 in varchar2 default hr_api.g_varchar2
167: ,p_segment22 in varchar2 default hr_api.g_varchar2
168: ,p_segment23 in varchar2 default hr_api.g_varchar2
169: ,p_segment24 in varchar2 default hr_api.g_varchar2
170: ,p_segment25 in varchar2 default hr_api.g_varchar2
171: ,p_segment26 in varchar2 default hr_api.g_varchar2
172: ,p_segment27 in varchar2 default hr_api.g_varchar2
173: ,p_segment28 in varchar2 default hr_api.g_varchar2
174: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 171: ,p_segment26 in varchar2 default hr_api.g_varchar2

167: ,p_segment22 in varchar2 default hr_api.g_varchar2
168: ,p_segment23 in varchar2 default hr_api.g_varchar2
169: ,p_segment24 in varchar2 default hr_api.g_varchar2
170: ,p_segment25 in varchar2 default hr_api.g_varchar2
171: ,p_segment26 in varchar2 default hr_api.g_varchar2
172: ,p_segment27 in varchar2 default hr_api.g_varchar2
173: ,p_segment28 in varchar2 default hr_api.g_varchar2
174: ,p_segment29 in varchar2 default hr_api.g_varchar2
175: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 172: ,p_segment27 in varchar2 default hr_api.g_varchar2

168: ,p_segment23 in varchar2 default hr_api.g_varchar2
169: ,p_segment24 in varchar2 default hr_api.g_varchar2
170: ,p_segment25 in varchar2 default hr_api.g_varchar2
171: ,p_segment26 in varchar2 default hr_api.g_varchar2
172: ,p_segment27 in varchar2 default hr_api.g_varchar2
173: ,p_segment28 in varchar2 default hr_api.g_varchar2
174: ,p_segment29 in varchar2 default hr_api.g_varchar2
175: ,p_segment30 in varchar2 default hr_api.g_varchar2
176: );

Line 173: ,p_segment28 in varchar2 default hr_api.g_varchar2

169: ,p_segment24 in varchar2 default hr_api.g_varchar2
170: ,p_segment25 in varchar2 default hr_api.g_varchar2
171: ,p_segment26 in varchar2 default hr_api.g_varchar2
172: ,p_segment27 in varchar2 default hr_api.g_varchar2
173: ,p_segment28 in varchar2 default hr_api.g_varchar2
174: ,p_segment29 in varchar2 default hr_api.g_varchar2
175: ,p_segment30 in varchar2 default hr_api.g_varchar2
176: );
177: --

Line 174: ,p_segment29 in varchar2 default hr_api.g_varchar2

170: ,p_segment25 in varchar2 default hr_api.g_varchar2
171: ,p_segment26 in varchar2 default hr_api.g_varchar2
172: ,p_segment27 in varchar2 default hr_api.g_varchar2
173: ,p_segment28 in varchar2 default hr_api.g_varchar2
174: ,p_segment29 in varchar2 default hr_api.g_varchar2
175: ,p_segment30 in varchar2 default hr_api.g_varchar2
176: );
177: --
178: end hr_icx_upd;

Line 175: ,p_segment30 in varchar2 default hr_api.g_varchar2

171: ,p_segment26 in varchar2 default hr_api.g_varchar2
172: ,p_segment27 in varchar2 default hr_api.g_varchar2
173: ,p_segment28 in varchar2 default hr_api.g_varchar2
174: ,p_segment29 in varchar2 default hr_api.g_varchar2
175: ,p_segment30 in varchar2 default hr_api.g_varchar2
176: );
177: --
178: end hr_icx_upd;