APPS.HR_TEMPLATE_ITEMS_API dependencies on HR_API

Line 10: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

6: g_package varchar2(33) := ' hr_template_items_api.';
7: --
8: PROCEDURE update_template_item_contexts
9: (p_effective_date IN DATE
10: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
11: ,p_template_item_id IN NUMBER
12: ,p_alignment IN NUMBER DEFAULT hr_api.g_number
13: ,p_bevel IN NUMBER DEFAULT hr_api.g_number
14: ,p_case_restriction IN NUMBER DEFAULT hr_api.g_number

Line 12: ,p_alignment IN NUMBER DEFAULT hr_api.g_number

8: PROCEDURE update_template_item_contexts
9: (p_effective_date IN DATE
10: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
11: ,p_template_item_id IN NUMBER
12: ,p_alignment IN NUMBER DEFAULT hr_api.g_number
13: ,p_bevel IN NUMBER DEFAULT hr_api.g_number
14: ,p_case_restriction IN NUMBER DEFAULT hr_api.g_number
15: ,p_default_value IN VARCHAR2 DEFAULT hr_api.g_varchar2
16: ,p_enabled IN NUMBER DEFAULT hr_api.g_number

Line 13: ,p_bevel IN NUMBER DEFAULT hr_api.g_number

9: (p_effective_date IN DATE
10: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
11: ,p_template_item_id IN NUMBER
12: ,p_alignment IN NUMBER DEFAULT hr_api.g_number
13: ,p_bevel IN NUMBER DEFAULT hr_api.g_number
14: ,p_case_restriction IN NUMBER DEFAULT hr_api.g_number
15: ,p_default_value IN VARCHAR2 DEFAULT hr_api.g_varchar2
16: ,p_enabled IN NUMBER DEFAULT hr_api.g_number
17: ,p_format_mask IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 14: ,p_case_restriction IN NUMBER DEFAULT hr_api.g_number

10: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
11: ,p_template_item_id IN NUMBER
12: ,p_alignment IN NUMBER DEFAULT hr_api.g_number
13: ,p_bevel IN NUMBER DEFAULT hr_api.g_number
14: ,p_case_restriction IN NUMBER DEFAULT hr_api.g_number
15: ,p_default_value IN VARCHAR2 DEFAULT hr_api.g_varchar2
16: ,p_enabled IN NUMBER DEFAULT hr_api.g_number
17: ,p_format_mask IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_height IN NUMBER DEFAULT hr_api.g_number

Line 15: ,p_default_value IN VARCHAR2 DEFAULT hr_api.g_varchar2

11: ,p_template_item_id IN NUMBER
12: ,p_alignment IN NUMBER DEFAULT hr_api.g_number
13: ,p_bevel IN NUMBER DEFAULT hr_api.g_number
14: ,p_case_restriction IN NUMBER DEFAULT hr_api.g_number
15: ,p_default_value IN VARCHAR2 DEFAULT hr_api.g_varchar2
16: ,p_enabled IN NUMBER DEFAULT hr_api.g_number
17: ,p_format_mask IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_height IN NUMBER DEFAULT hr_api.g_number
19: ,p_information_formula_id IN NUMBER DEFAULT hr_api.g_number

Line 16: ,p_enabled IN NUMBER DEFAULT hr_api.g_number

12: ,p_alignment IN NUMBER DEFAULT hr_api.g_number
13: ,p_bevel IN NUMBER DEFAULT hr_api.g_number
14: ,p_case_restriction IN NUMBER DEFAULT hr_api.g_number
15: ,p_default_value IN VARCHAR2 DEFAULT hr_api.g_varchar2
16: ,p_enabled IN NUMBER DEFAULT hr_api.g_number
17: ,p_format_mask IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_height IN NUMBER DEFAULT hr_api.g_number
19: ,p_information_formula_id IN NUMBER DEFAULT hr_api.g_number
20: ,p_information_param_item_id1 IN NUMBER DEFAULT hr_api.g_number

Line 17: ,p_format_mask IN VARCHAR2 DEFAULT hr_api.g_varchar2

13: ,p_bevel IN NUMBER DEFAULT hr_api.g_number
14: ,p_case_restriction IN NUMBER DEFAULT hr_api.g_number
15: ,p_default_value IN VARCHAR2 DEFAULT hr_api.g_varchar2
16: ,p_enabled IN NUMBER DEFAULT hr_api.g_number
17: ,p_format_mask IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_height IN NUMBER DEFAULT hr_api.g_number
19: ,p_information_formula_id IN NUMBER DEFAULT hr_api.g_number
20: ,p_information_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
21: ,p_information_param_item_id2 IN NUMBER DEFAULT hr_api.g_number

Line 18: ,p_height IN NUMBER DEFAULT hr_api.g_number

14: ,p_case_restriction IN NUMBER DEFAULT hr_api.g_number
15: ,p_default_value IN VARCHAR2 DEFAULT hr_api.g_varchar2
16: ,p_enabled IN NUMBER DEFAULT hr_api.g_number
17: ,p_format_mask IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_height IN NUMBER DEFAULT hr_api.g_number
19: ,p_information_formula_id IN NUMBER DEFAULT hr_api.g_number
20: ,p_information_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
21: ,p_information_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
22: ,p_information_param_item_id3 IN NUMBER DEFAULT hr_api.g_number

Line 19: ,p_information_formula_id IN NUMBER DEFAULT hr_api.g_number

15: ,p_default_value IN VARCHAR2 DEFAULT hr_api.g_varchar2
16: ,p_enabled IN NUMBER DEFAULT hr_api.g_number
17: ,p_format_mask IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_height IN NUMBER DEFAULT hr_api.g_number
19: ,p_information_formula_id IN NUMBER DEFAULT hr_api.g_number
20: ,p_information_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
21: ,p_information_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
22: ,p_information_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
23: ,p_information_param_item_id4 IN NUMBER DEFAULT hr_api.g_number

Line 20: ,p_information_param_item_id1 IN NUMBER DEFAULT hr_api.g_number

16: ,p_enabled IN NUMBER DEFAULT hr_api.g_number
17: ,p_format_mask IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_height IN NUMBER DEFAULT hr_api.g_number
19: ,p_information_formula_id IN NUMBER DEFAULT hr_api.g_number
20: ,p_information_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
21: ,p_information_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
22: ,p_information_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
23: ,p_information_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
24: ,p_information_param_item_id5 IN NUMBER DEFAULT hr_api.g_number

Line 21: ,p_information_param_item_id2 IN NUMBER DEFAULT hr_api.g_number

17: ,p_format_mask IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_height IN NUMBER DEFAULT hr_api.g_number
19: ,p_information_formula_id IN NUMBER DEFAULT hr_api.g_number
20: ,p_information_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
21: ,p_information_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
22: ,p_information_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
23: ,p_information_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
24: ,p_information_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
25: ,p_information_prompt IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 22: ,p_information_param_item_id3 IN NUMBER DEFAULT hr_api.g_number

18: ,p_height IN NUMBER DEFAULT hr_api.g_number
19: ,p_information_formula_id IN NUMBER DEFAULT hr_api.g_number
20: ,p_information_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
21: ,p_information_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
22: ,p_information_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
23: ,p_information_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
24: ,p_information_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
25: ,p_information_prompt IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_insert_allowed IN NUMBER DEFAULT hr_api.g_number

Line 23: ,p_information_param_item_id4 IN NUMBER DEFAULT hr_api.g_number

19: ,p_information_formula_id IN NUMBER DEFAULT hr_api.g_number
20: ,p_information_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
21: ,p_information_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
22: ,p_information_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
23: ,p_information_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
24: ,p_information_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
25: ,p_information_prompt IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_insert_allowed IN NUMBER DEFAULT hr_api.g_number
27: ,p_label IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 24: ,p_information_param_item_id5 IN NUMBER DEFAULT hr_api.g_number

20: ,p_information_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
21: ,p_information_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
22: ,p_information_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
23: ,p_information_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
24: ,p_information_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
25: ,p_information_prompt IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_insert_allowed IN NUMBER DEFAULT hr_api.g_number
27: ,p_label IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_next_navigation_item_id IN NUMBER DEFAULT hr_api.g_number

Line 25: ,p_information_prompt IN VARCHAR2 DEFAULT hr_api.g_varchar2

21: ,p_information_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
22: ,p_information_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
23: ,p_information_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
24: ,p_information_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
25: ,p_information_prompt IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_insert_allowed IN NUMBER DEFAULT hr_api.g_number
27: ,p_label IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_next_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
29: ,p_previous_navigation_item_id IN NUMBER DEFAULT hr_api.g_number

Line 26: ,p_insert_allowed IN NUMBER DEFAULT hr_api.g_number

22: ,p_information_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
23: ,p_information_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
24: ,p_information_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
25: ,p_information_prompt IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_insert_allowed IN NUMBER DEFAULT hr_api.g_number
27: ,p_label IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_next_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
29: ,p_previous_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
30: ,p_prompt_text IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 27: ,p_label IN VARCHAR2 DEFAULT hr_api.g_varchar2

23: ,p_information_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
24: ,p_information_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
25: ,p_information_prompt IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_insert_allowed IN NUMBER DEFAULT hr_api.g_number
27: ,p_label IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_next_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
29: ,p_previous_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
30: ,p_prompt_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_prompt_alignment_offset IN NUMBER DEFAULT hr_api.g_number

Line 28: ,p_next_navigation_item_id IN NUMBER DEFAULT hr_api.g_number

24: ,p_information_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
25: ,p_information_prompt IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_insert_allowed IN NUMBER DEFAULT hr_api.g_number
27: ,p_label IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_next_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
29: ,p_previous_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
30: ,p_prompt_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_prompt_alignment_offset IN NUMBER DEFAULT hr_api.g_number
32: ,p_prompt_display_style IN NUMBER DEFAULT hr_api.g_number

Line 29: ,p_previous_navigation_item_id IN NUMBER DEFAULT hr_api.g_number

25: ,p_information_prompt IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_insert_allowed IN NUMBER DEFAULT hr_api.g_number
27: ,p_label IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_next_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
29: ,p_previous_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
30: ,p_prompt_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_prompt_alignment_offset IN NUMBER DEFAULT hr_api.g_number
32: ,p_prompt_display_style IN NUMBER DEFAULT hr_api.g_number
33: ,p_prompt_edge IN NUMBER DEFAULT hr_api.g_number

Line 30: ,p_prompt_text IN VARCHAR2 DEFAULT hr_api.g_varchar2

26: ,p_insert_allowed IN NUMBER DEFAULT hr_api.g_number
27: ,p_label IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_next_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
29: ,p_previous_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
30: ,p_prompt_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_prompt_alignment_offset IN NUMBER DEFAULT hr_api.g_number
32: ,p_prompt_display_style IN NUMBER DEFAULT hr_api.g_number
33: ,p_prompt_edge IN NUMBER DEFAULT hr_api.g_number
34: ,p_prompt_edge_alignment IN NUMBER DEFAULT hr_api.g_number

Line 31: ,p_prompt_alignment_offset IN NUMBER DEFAULT hr_api.g_number

27: ,p_label IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_next_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
29: ,p_previous_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
30: ,p_prompt_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_prompt_alignment_offset IN NUMBER DEFAULT hr_api.g_number
32: ,p_prompt_display_style IN NUMBER DEFAULT hr_api.g_number
33: ,p_prompt_edge IN NUMBER DEFAULT hr_api.g_number
34: ,p_prompt_edge_alignment IN NUMBER DEFAULT hr_api.g_number
35: ,p_prompt_edge_offset IN NUMBER DEFAULT hr_api.g_number

Line 32: ,p_prompt_display_style IN NUMBER DEFAULT hr_api.g_number

28: ,p_next_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
29: ,p_previous_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
30: ,p_prompt_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_prompt_alignment_offset IN NUMBER DEFAULT hr_api.g_number
32: ,p_prompt_display_style IN NUMBER DEFAULT hr_api.g_number
33: ,p_prompt_edge IN NUMBER DEFAULT hr_api.g_number
34: ,p_prompt_edge_alignment IN NUMBER DEFAULT hr_api.g_number
35: ,p_prompt_edge_offset IN NUMBER DEFAULT hr_api.g_number
36: ,p_prompt_text_alignment IN NUMBER DEFAULT hr_api.g_number

Line 33: ,p_prompt_edge IN NUMBER DEFAULT hr_api.g_number

29: ,p_previous_navigation_item_id IN NUMBER DEFAULT hr_api.g_number
30: ,p_prompt_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_prompt_alignment_offset IN NUMBER DEFAULT hr_api.g_number
32: ,p_prompt_display_style IN NUMBER DEFAULT hr_api.g_number
33: ,p_prompt_edge IN NUMBER DEFAULT hr_api.g_number
34: ,p_prompt_edge_alignment IN NUMBER DEFAULT hr_api.g_number
35: ,p_prompt_edge_offset IN NUMBER DEFAULT hr_api.g_number
36: ,p_prompt_text_alignment IN NUMBER DEFAULT hr_api.g_number
37: ,p_query_allowed IN NUMBER DEFAULT hr_api.g_number

Line 34: ,p_prompt_edge_alignment IN NUMBER DEFAULT hr_api.g_number

30: ,p_prompt_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_prompt_alignment_offset IN NUMBER DEFAULT hr_api.g_number
32: ,p_prompt_display_style IN NUMBER DEFAULT hr_api.g_number
33: ,p_prompt_edge IN NUMBER DEFAULT hr_api.g_number
34: ,p_prompt_edge_alignment IN NUMBER DEFAULT hr_api.g_number
35: ,p_prompt_edge_offset IN NUMBER DEFAULT hr_api.g_number
36: ,p_prompt_text_alignment IN NUMBER DEFAULT hr_api.g_number
37: ,p_query_allowed IN NUMBER DEFAULT hr_api.g_number
38: ,p_required IN NUMBER DEFAULT hr_api.g_number

Line 35: ,p_prompt_edge_offset IN NUMBER DEFAULT hr_api.g_number

31: ,p_prompt_alignment_offset IN NUMBER DEFAULT hr_api.g_number
32: ,p_prompt_display_style IN NUMBER DEFAULT hr_api.g_number
33: ,p_prompt_edge IN NUMBER DEFAULT hr_api.g_number
34: ,p_prompt_edge_alignment IN NUMBER DEFAULT hr_api.g_number
35: ,p_prompt_edge_offset IN NUMBER DEFAULT hr_api.g_number
36: ,p_prompt_text_alignment IN NUMBER DEFAULT hr_api.g_number
37: ,p_query_allowed IN NUMBER DEFAULT hr_api.g_number
38: ,p_required IN NUMBER DEFAULT hr_api.g_number
39: ,p_tooltip_text IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 36: ,p_prompt_text_alignment IN NUMBER DEFAULT hr_api.g_number

32: ,p_prompt_display_style IN NUMBER DEFAULT hr_api.g_number
33: ,p_prompt_edge IN NUMBER DEFAULT hr_api.g_number
34: ,p_prompt_edge_alignment IN NUMBER DEFAULT hr_api.g_number
35: ,p_prompt_edge_offset IN NUMBER DEFAULT hr_api.g_number
36: ,p_prompt_text_alignment IN NUMBER DEFAULT hr_api.g_number
37: ,p_query_allowed IN NUMBER DEFAULT hr_api.g_number
38: ,p_required IN NUMBER DEFAULT hr_api.g_number
39: ,p_tooltip_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_update_allowed IN NUMBER DEFAULT hr_api.g_number

Line 37: ,p_query_allowed IN NUMBER DEFAULT hr_api.g_number

33: ,p_prompt_edge IN NUMBER DEFAULT hr_api.g_number
34: ,p_prompt_edge_alignment IN NUMBER DEFAULT hr_api.g_number
35: ,p_prompt_edge_offset IN NUMBER DEFAULT hr_api.g_number
36: ,p_prompt_text_alignment IN NUMBER DEFAULT hr_api.g_number
37: ,p_query_allowed IN NUMBER DEFAULT hr_api.g_number
38: ,p_required IN NUMBER DEFAULT hr_api.g_number
39: ,p_tooltip_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_update_allowed IN NUMBER DEFAULT hr_api.g_number
41: ,p_validation_formula_id IN NUMBER DEFAULT hr_api.g_number

Line 38: ,p_required IN NUMBER DEFAULT hr_api.g_number

34: ,p_prompt_edge_alignment IN NUMBER DEFAULT hr_api.g_number
35: ,p_prompt_edge_offset IN NUMBER DEFAULT hr_api.g_number
36: ,p_prompt_text_alignment IN NUMBER DEFAULT hr_api.g_number
37: ,p_query_allowed IN NUMBER DEFAULT hr_api.g_number
38: ,p_required IN NUMBER DEFAULT hr_api.g_number
39: ,p_tooltip_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_update_allowed IN NUMBER DEFAULT hr_api.g_number
41: ,p_validation_formula_id IN NUMBER DEFAULT hr_api.g_number
42: ,p_validation_param_item_id1 IN NUMBER DEFAULT hr_api.g_number

Line 39: ,p_tooltip_text IN VARCHAR2 DEFAULT hr_api.g_varchar2

35: ,p_prompt_edge_offset IN NUMBER DEFAULT hr_api.g_number
36: ,p_prompt_text_alignment IN NUMBER DEFAULT hr_api.g_number
37: ,p_query_allowed IN NUMBER DEFAULT hr_api.g_number
38: ,p_required IN NUMBER DEFAULT hr_api.g_number
39: ,p_tooltip_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_update_allowed IN NUMBER DEFAULT hr_api.g_number
41: ,p_validation_formula_id IN NUMBER DEFAULT hr_api.g_number
42: ,p_validation_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
43: ,p_validation_param_item_id2 IN NUMBER DEFAULT hr_api.g_number

Line 40: ,p_update_allowed IN NUMBER DEFAULT hr_api.g_number

36: ,p_prompt_text_alignment IN NUMBER DEFAULT hr_api.g_number
37: ,p_query_allowed IN NUMBER DEFAULT hr_api.g_number
38: ,p_required IN NUMBER DEFAULT hr_api.g_number
39: ,p_tooltip_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_update_allowed IN NUMBER DEFAULT hr_api.g_number
41: ,p_validation_formula_id IN NUMBER DEFAULT hr_api.g_number
42: ,p_validation_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
43: ,p_validation_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
44: ,p_validation_param_item_id3 IN NUMBER DEFAULT hr_api.g_number

Line 41: ,p_validation_formula_id IN NUMBER DEFAULT hr_api.g_number

37: ,p_query_allowed IN NUMBER DEFAULT hr_api.g_number
38: ,p_required IN NUMBER DEFAULT hr_api.g_number
39: ,p_tooltip_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_update_allowed IN NUMBER DEFAULT hr_api.g_number
41: ,p_validation_formula_id IN NUMBER DEFAULT hr_api.g_number
42: ,p_validation_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
43: ,p_validation_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
44: ,p_validation_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
45: ,p_validation_param_item_id4 IN NUMBER DEFAULT hr_api.g_number

Line 42: ,p_validation_param_item_id1 IN NUMBER DEFAULT hr_api.g_number

38: ,p_required IN NUMBER DEFAULT hr_api.g_number
39: ,p_tooltip_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_update_allowed IN NUMBER DEFAULT hr_api.g_number
41: ,p_validation_formula_id IN NUMBER DEFAULT hr_api.g_number
42: ,p_validation_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
43: ,p_validation_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
44: ,p_validation_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
45: ,p_validation_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
46: ,p_validation_param_item_id5 IN NUMBER DEFAULT hr_api.g_number

Line 43: ,p_validation_param_item_id2 IN NUMBER DEFAULT hr_api.g_number

39: ,p_tooltip_text IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_update_allowed IN NUMBER DEFAULT hr_api.g_number
41: ,p_validation_formula_id IN NUMBER DEFAULT hr_api.g_number
42: ,p_validation_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
43: ,p_validation_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
44: ,p_validation_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
45: ,p_validation_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
46: ,p_validation_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
47: ,p_visible IN NUMBER DEFAULT hr_api.g_number

Line 44: ,p_validation_param_item_id3 IN NUMBER DEFAULT hr_api.g_number

40: ,p_update_allowed IN NUMBER DEFAULT hr_api.g_number
41: ,p_validation_formula_id IN NUMBER DEFAULT hr_api.g_number
42: ,p_validation_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
43: ,p_validation_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
44: ,p_validation_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
45: ,p_validation_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
46: ,p_validation_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
47: ,p_visible IN NUMBER DEFAULT hr_api.g_number
48: ,p_width IN NUMBER DEFAULT hr_api.g_number

Line 45: ,p_validation_param_item_id4 IN NUMBER DEFAULT hr_api.g_number

41: ,p_validation_formula_id IN NUMBER DEFAULT hr_api.g_number
42: ,p_validation_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
43: ,p_validation_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
44: ,p_validation_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
45: ,p_validation_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
46: ,p_validation_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
47: ,p_visible IN NUMBER DEFAULT hr_api.g_number
48: ,p_width IN NUMBER DEFAULT hr_api.g_number
49: ,p_x_position IN NUMBER DEFAULT hr_api.g_number

Line 46: ,p_validation_param_item_id5 IN NUMBER DEFAULT hr_api.g_number

42: ,p_validation_param_item_id1 IN NUMBER DEFAULT hr_api.g_number
43: ,p_validation_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
44: ,p_validation_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
45: ,p_validation_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
46: ,p_validation_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
47: ,p_visible IN NUMBER DEFAULT hr_api.g_number
48: ,p_width IN NUMBER DEFAULT hr_api.g_number
49: ,p_x_position IN NUMBER DEFAULT hr_api.g_number
50: ,p_y_position IN NUMBER DEFAULT hr_api.g_number

Line 47: ,p_visible IN NUMBER DEFAULT hr_api.g_number

43: ,p_validation_param_item_id2 IN NUMBER DEFAULT hr_api.g_number
44: ,p_validation_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
45: ,p_validation_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
46: ,p_validation_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
47: ,p_visible IN NUMBER DEFAULT hr_api.g_number
48: ,p_width IN NUMBER DEFAULT hr_api.g_number
49: ,p_x_position IN NUMBER DEFAULT hr_api.g_number
50: ,p_y_position IN NUMBER DEFAULT hr_api.g_number
51: ,p_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 48: ,p_width IN NUMBER DEFAULT hr_api.g_number

44: ,p_validation_param_item_id3 IN NUMBER DEFAULT hr_api.g_number
45: ,p_validation_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
46: ,p_validation_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
47: ,p_visible IN NUMBER DEFAULT hr_api.g_number
48: ,p_width IN NUMBER DEFAULT hr_api.g_number
49: ,p_x_position IN NUMBER DEFAULT hr_api.g_number
50: ,p_y_position IN NUMBER DEFAULT hr_api.g_number
51: ,p_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 49: ,p_x_position IN NUMBER DEFAULT hr_api.g_number

45: ,p_validation_param_item_id4 IN NUMBER DEFAULT hr_api.g_number
46: ,p_validation_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
47: ,p_visible IN NUMBER DEFAULT hr_api.g_number
48: ,p_width IN NUMBER DEFAULT hr_api.g_number
49: ,p_x_position IN NUMBER DEFAULT hr_api.g_number
50: ,p_y_position IN NUMBER DEFAULT hr_api.g_number
51: ,p_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 50: ,p_y_position IN NUMBER DEFAULT hr_api.g_number

46: ,p_validation_param_item_id5 IN NUMBER DEFAULT hr_api.g_number
47: ,p_visible IN NUMBER DEFAULT hr_api.g_number
48: ,p_width IN NUMBER DEFAULT hr_api.g_number
49: ,p_x_position IN NUMBER DEFAULT hr_api.g_number
50: ,p_y_position IN NUMBER DEFAULT hr_api.g_number
51: ,p_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 51: ,p_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

47: ,p_visible IN NUMBER DEFAULT hr_api.g_number
48: ,p_width IN NUMBER DEFAULT hr_api.g_number
49: ,p_x_position IN NUMBER DEFAULT hr_api.g_number
50: ,p_y_position IN NUMBER DEFAULT hr_api.g_number
51: ,p_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 52: ,p_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

48: ,p_width IN NUMBER DEFAULT hr_api.g_number
49: ,p_x_position IN NUMBER DEFAULT hr_api.g_number
50: ,p_y_position IN NUMBER DEFAULT hr_api.g_number
51: ,p_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 53: ,p_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

49: ,p_x_position IN NUMBER DEFAULT hr_api.g_number
50: ,p_y_position IN NUMBER DEFAULT hr_api.g_number
51: ,p_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 54: ,p_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

50: ,p_y_position IN NUMBER DEFAULT hr_api.g_number
51: ,p_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 55: ,p_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

51: ,p_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 56: ,p_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

52: ,p_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 57: ,p_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

53: ,p_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 58: ,p_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

54: ,p_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 59: ,p_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

55: ,p_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 60: ,p_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

56: ,p_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 61: ,p_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

57: ,p_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 62: ,p_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

58: ,p_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 63: ,p_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

59: ,p_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 64: ,p_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

60: ,p_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 65: ,p_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

61: ,p_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 66: ,p_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

62: ,p_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 67: ,p_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

63: ,p_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 68: ,p_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

64: ,p_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 69: ,p_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

65: ,p_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 70: ,p_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

66: ,p_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 71: ,p_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

67: ,p_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 72: ,p_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

68: ,p_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 73: ,p_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

69: ,p_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 74: ,p_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

70: ,p_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 75: ,p_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

71: ,p_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 76: ,p_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

72: ,p_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 77: ,p_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

73: ,p_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 78: ,p_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

74: ,p_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: )

Line 79: ,p_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

75: ,p_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: )
83: IS

Line 80: ,p_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

76: ,p_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: )
83: IS
84: --

Line 81: ,p_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

77: ,p_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: )
83: IS
84: --
85: CURSOR csr_template_item_contexts

Line 300: IF (NVL(l_template_item_context.alignment,hr_api.g_number) = NVL(l_template_item.alignment,hr_api.g_number)) THEN

296: --
297: -- If context property equals previous item property then context property
298: -- becomes new item property.
299: --
300: IF (NVL(l_template_item_context.alignment,hr_api.g_number) = NVL(l_template_item.alignment,hr_api.g_number)) THEN
301: l_template_item_context.alignment := p_alignment;
302: END IF;
303: IF (NVL(l_template_item_context.bevel,hr_api.g_number) = NVL(l_template_item.bevel,hr_api.g_number)) THEN
304: l_template_item_context.bevel := p_bevel;

Line 303: IF (NVL(l_template_item_context.bevel,hr_api.g_number) = NVL(l_template_item.bevel,hr_api.g_number)) THEN

299: --
300: IF (NVL(l_template_item_context.alignment,hr_api.g_number) = NVL(l_template_item.alignment,hr_api.g_number)) THEN
301: l_template_item_context.alignment := p_alignment;
302: END IF;
303: IF (NVL(l_template_item_context.bevel,hr_api.g_number) = NVL(l_template_item.bevel,hr_api.g_number)) THEN
304: l_template_item_context.bevel := p_bevel;
305: END IF;
306: IF (NVL(l_template_item_context.case_restriction,hr_api.g_number) = NVL(l_template_item.case_restriction,hr_api.g_number)) THEN
307: l_template_item_context.case_restriction := p_case_restriction;

Line 306: IF (NVL(l_template_item_context.case_restriction,hr_api.g_number) = NVL(l_template_item.case_restriction,hr_api.g_number)) THEN

302: END IF;
303: IF (NVL(l_template_item_context.bevel,hr_api.g_number) = NVL(l_template_item.bevel,hr_api.g_number)) THEN
304: l_template_item_context.bevel := p_bevel;
305: END IF;
306: IF (NVL(l_template_item_context.case_restriction,hr_api.g_number) = NVL(l_template_item.case_restriction,hr_api.g_number)) THEN
307: l_template_item_context.case_restriction := p_case_restriction;
308: END IF;
309: IF (NVL(l_template_item_context.default_value,hr_api.g_varchar2) = NVL(l_template_item.default_value,hr_api.g_varchar2)) THEN
310: l_template_item_context.default_value := p_default_value;

Line 309: IF (NVL(l_template_item_context.default_value,hr_api.g_varchar2) = NVL(l_template_item.default_value,hr_api.g_varchar2)) THEN

305: END IF;
306: IF (NVL(l_template_item_context.case_restriction,hr_api.g_number) = NVL(l_template_item.case_restriction,hr_api.g_number)) THEN
307: l_template_item_context.case_restriction := p_case_restriction;
308: END IF;
309: IF (NVL(l_template_item_context.default_value,hr_api.g_varchar2) = NVL(l_template_item.default_value,hr_api.g_varchar2)) THEN
310: l_template_item_context.default_value := p_default_value;
311: END IF;
312: IF (NVL(l_template_item_context.enabled,hr_api.g_number) = NVL(l_template_item.enabled,hr_api.g_number)) THEN
313: l_template_item_context.enabled := p_enabled;

Line 312: IF (NVL(l_template_item_context.enabled,hr_api.g_number) = NVL(l_template_item.enabled,hr_api.g_number)) THEN

308: END IF;
309: IF (NVL(l_template_item_context.default_value,hr_api.g_varchar2) = NVL(l_template_item.default_value,hr_api.g_varchar2)) THEN
310: l_template_item_context.default_value := p_default_value;
311: END IF;
312: IF (NVL(l_template_item_context.enabled,hr_api.g_number) = NVL(l_template_item.enabled,hr_api.g_number)) THEN
313: l_template_item_context.enabled := p_enabled;
314: END IF;
315: IF (NVL(l_template_item_context.format_mask,hr_api.g_varchar2) = NVL(l_template_item.format_mask,hr_api.g_varchar2)) THEN
316: l_template_item_context.format_mask := p_format_mask;

Line 315: IF (NVL(l_template_item_context.format_mask,hr_api.g_varchar2) = NVL(l_template_item.format_mask,hr_api.g_varchar2)) THEN

311: END IF;
312: IF (NVL(l_template_item_context.enabled,hr_api.g_number) = NVL(l_template_item.enabled,hr_api.g_number)) THEN
313: l_template_item_context.enabled := p_enabled;
314: END IF;
315: IF (NVL(l_template_item_context.format_mask,hr_api.g_varchar2) = NVL(l_template_item.format_mask,hr_api.g_varchar2)) THEN
316: l_template_item_context.format_mask := p_format_mask;
317: END IF;
318: IF (NVL(l_template_item_context.height,hr_api.g_number) = NVL(l_template_item.height,hr_api.g_number)) THEN
319: l_template_item_context.height := p_height;

Line 318: IF (NVL(l_template_item_context.height,hr_api.g_number) = NVL(l_template_item.height,hr_api.g_number)) THEN

314: END IF;
315: IF (NVL(l_template_item_context.format_mask,hr_api.g_varchar2) = NVL(l_template_item.format_mask,hr_api.g_varchar2)) THEN
316: l_template_item_context.format_mask := p_format_mask;
317: END IF;
318: IF (NVL(l_template_item_context.height,hr_api.g_number) = NVL(l_template_item.height,hr_api.g_number)) THEN
319: l_template_item_context.height := p_height;
320: END IF;
321: IF (NVL(l_template_item_context.information_formula_id,hr_api.g_number) = NVL(l_template_item.information_formula_id,hr_api.g_number)) THEN
322: l_template_item_context.information_formula_id := p_information_formula_id;

Line 321: IF (NVL(l_template_item_context.information_formula_id,hr_api.g_number) = NVL(l_template_item.information_formula_id,hr_api.g_number)) THEN

317: END IF;
318: IF (NVL(l_template_item_context.height,hr_api.g_number) = NVL(l_template_item.height,hr_api.g_number)) THEN
319: l_template_item_context.height := p_height;
320: END IF;
321: IF (NVL(l_template_item_context.information_formula_id,hr_api.g_number) = NVL(l_template_item.information_formula_id,hr_api.g_number)) THEN
322: l_template_item_context.information_formula_id := p_information_formula_id;
323: END IF;
324: IF (NVL(l_template_item_context.information_parameter_item_id1,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id1,hr_api.g_number)) THEN
325: l_template_item_context.information_parameter_item_id1 := p_information_param_item_id1;

Line 324: IF (NVL(l_template_item_context.information_parameter_item_id1,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id1,hr_api.g_number)) THEN

320: END IF;
321: IF (NVL(l_template_item_context.information_formula_id,hr_api.g_number) = NVL(l_template_item.information_formula_id,hr_api.g_number)) THEN
322: l_template_item_context.information_formula_id := p_information_formula_id;
323: END IF;
324: IF (NVL(l_template_item_context.information_parameter_item_id1,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id1,hr_api.g_number)) THEN
325: l_template_item_context.information_parameter_item_id1 := p_information_param_item_id1;
326: END IF;
327: IF (NVL(l_template_item_context.information_parameter_item_id2,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id2,hr_api.g_number)) THEN
328: l_template_item_context.information_parameter_item_id2 := p_information_param_item_id2;

Line 327: IF (NVL(l_template_item_context.information_parameter_item_id2,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id2,hr_api.g_number)) THEN

323: END IF;
324: IF (NVL(l_template_item_context.information_parameter_item_id1,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id1,hr_api.g_number)) THEN
325: l_template_item_context.information_parameter_item_id1 := p_information_param_item_id1;
326: END IF;
327: IF (NVL(l_template_item_context.information_parameter_item_id2,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id2,hr_api.g_number)) THEN
328: l_template_item_context.information_parameter_item_id2 := p_information_param_item_id2;
329: END IF;
330: IF (NVL(l_template_item_context.information_parameter_item_id3,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id3,hr_api.g_number)) THEN
331: l_template_item_context.information_parameter_item_id3 := p_information_param_item_id3;

Line 330: IF (NVL(l_template_item_context.information_parameter_item_id3,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id3,hr_api.g_number)) THEN

326: END IF;
327: IF (NVL(l_template_item_context.information_parameter_item_id2,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id2,hr_api.g_number)) THEN
328: l_template_item_context.information_parameter_item_id2 := p_information_param_item_id2;
329: END IF;
330: IF (NVL(l_template_item_context.information_parameter_item_id3,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id3,hr_api.g_number)) THEN
331: l_template_item_context.information_parameter_item_id3 := p_information_param_item_id3;
332: END IF;
333: IF (NVL(l_template_item_context.information_parameter_item_id4,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id4,hr_api.g_number)) THEN
334: l_template_item_context.information_parameter_item_id4 := p_information_param_item_id4;

Line 333: IF (NVL(l_template_item_context.information_parameter_item_id4,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id4,hr_api.g_number)) THEN

329: END IF;
330: IF (NVL(l_template_item_context.information_parameter_item_id3,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id3,hr_api.g_number)) THEN
331: l_template_item_context.information_parameter_item_id3 := p_information_param_item_id3;
332: END IF;
333: IF (NVL(l_template_item_context.information_parameter_item_id4,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id4,hr_api.g_number)) THEN
334: l_template_item_context.information_parameter_item_id4 := p_information_param_item_id4;
335: END IF;
336: IF (NVL(l_template_item_context.information_parameter_item_id5,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id5,hr_api.g_number)) THEN
337: l_template_item_context.information_parameter_item_id5 := p_information_param_item_id5;

Line 336: IF (NVL(l_template_item_context.information_parameter_item_id5,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id5,hr_api.g_number)) THEN

332: END IF;
333: IF (NVL(l_template_item_context.information_parameter_item_id4,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id4,hr_api.g_number)) THEN
334: l_template_item_context.information_parameter_item_id4 := p_information_param_item_id4;
335: END IF;
336: IF (NVL(l_template_item_context.information_parameter_item_id5,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id5,hr_api.g_number)) THEN
337: l_template_item_context.information_parameter_item_id5 := p_information_param_item_id5;
338: END IF;
339: IF (NVL(l_template_item_context.information_prompt,hr_api.g_varchar2) = NVL(l_template_item.information_prompt,hr_api.g_varchar2)) THEN
340: l_template_item_context.information_prompt := p_information_prompt;

Line 339: IF (NVL(l_template_item_context.information_prompt,hr_api.g_varchar2) = NVL(l_template_item.information_prompt,hr_api.g_varchar2)) THEN

335: END IF;
336: IF (NVL(l_template_item_context.information_parameter_item_id5,hr_api.g_number) = NVL(l_template_item.information_parameter_item_id5,hr_api.g_number)) THEN
337: l_template_item_context.information_parameter_item_id5 := p_information_param_item_id5;
338: END IF;
339: IF (NVL(l_template_item_context.information_prompt,hr_api.g_varchar2) = NVL(l_template_item.information_prompt,hr_api.g_varchar2)) THEN
340: l_template_item_context.information_prompt := p_information_prompt;
341: END IF;
342: IF (NVL(l_template_item_context.insert_allowed,hr_api.g_number) = NVL(l_template_item.insert_allowed,hr_api.g_number)) THEN
343: l_template_item_context.insert_allowed := p_insert_allowed;

Line 342: IF (NVL(l_template_item_context.insert_allowed,hr_api.g_number) = NVL(l_template_item.insert_allowed,hr_api.g_number)) THEN

338: END IF;
339: IF (NVL(l_template_item_context.information_prompt,hr_api.g_varchar2) = NVL(l_template_item.information_prompt,hr_api.g_varchar2)) THEN
340: l_template_item_context.information_prompt := p_information_prompt;
341: END IF;
342: IF (NVL(l_template_item_context.insert_allowed,hr_api.g_number) = NVL(l_template_item.insert_allowed,hr_api.g_number)) THEN
343: l_template_item_context.insert_allowed := p_insert_allowed;
344: END IF;
345: IF (NVL(l_template_item_context.label,hr_api.g_varchar2) = NVL(l_template_item.label,hr_api.g_varchar2)) THEN
346: l_template_item_context.label := p_label;

Line 345: IF (NVL(l_template_item_context.label,hr_api.g_varchar2) = NVL(l_template_item.label,hr_api.g_varchar2)) THEN

341: END IF;
342: IF (NVL(l_template_item_context.insert_allowed,hr_api.g_number) = NVL(l_template_item.insert_allowed,hr_api.g_number)) THEN
343: l_template_item_context.insert_allowed := p_insert_allowed;
344: END IF;
345: IF (NVL(l_template_item_context.label,hr_api.g_varchar2) = NVL(l_template_item.label,hr_api.g_varchar2)) THEN
346: l_template_item_context.label := p_label;
347: END IF;
348: IF (NVL(l_template_item_context.next_navigation_item_id,hr_api.g_number) = NVL(l_template_item.next_navigation_item_id,hr_api.g_number)) THEN
349: l_template_item_context.next_navigation_item_id := p_next_navigation_item_id;

Line 348: IF (NVL(l_template_item_context.next_navigation_item_id,hr_api.g_number) = NVL(l_template_item.next_navigation_item_id,hr_api.g_number)) THEN

344: END IF;
345: IF (NVL(l_template_item_context.label,hr_api.g_varchar2) = NVL(l_template_item.label,hr_api.g_varchar2)) THEN
346: l_template_item_context.label := p_label;
347: END IF;
348: IF (NVL(l_template_item_context.next_navigation_item_id,hr_api.g_number) = NVL(l_template_item.next_navigation_item_id,hr_api.g_number)) THEN
349: l_template_item_context.next_navigation_item_id := p_next_navigation_item_id;
350: END IF;
351: IF (NVL(l_template_item_context.previous_navigation_item_id,hr_api.g_number) = NVL(l_template_item.previous_navigation_item_id,hr_api.g_number)) THEN
352: l_template_item_context.previous_navigation_item_id := p_previous_navigation_item_id;

Line 351: IF (NVL(l_template_item_context.previous_navigation_item_id,hr_api.g_number) = NVL(l_template_item.previous_navigation_item_id,hr_api.g_number)) THEN

347: END IF;
348: IF (NVL(l_template_item_context.next_navigation_item_id,hr_api.g_number) = NVL(l_template_item.next_navigation_item_id,hr_api.g_number)) THEN
349: l_template_item_context.next_navigation_item_id := p_next_navigation_item_id;
350: END IF;
351: IF (NVL(l_template_item_context.previous_navigation_item_id,hr_api.g_number) = NVL(l_template_item.previous_navigation_item_id,hr_api.g_number)) THEN
352: l_template_item_context.previous_navigation_item_id := p_previous_navigation_item_id;
353: END IF;
354: IF (NVL(l_template_item_context.prompt_text,hr_api.g_varchar2) = NVL(l_template_item.prompt_text,hr_api.g_varchar2)) THEN
355: l_template_item_context.prompt_text := p_prompt_text;

Line 354: IF (NVL(l_template_item_context.prompt_text,hr_api.g_varchar2) = NVL(l_template_item.prompt_text,hr_api.g_varchar2)) THEN

350: END IF;
351: IF (NVL(l_template_item_context.previous_navigation_item_id,hr_api.g_number) = NVL(l_template_item.previous_navigation_item_id,hr_api.g_number)) THEN
352: l_template_item_context.previous_navigation_item_id := p_previous_navigation_item_id;
353: END IF;
354: IF (NVL(l_template_item_context.prompt_text,hr_api.g_varchar2) = NVL(l_template_item.prompt_text,hr_api.g_varchar2)) THEN
355: l_template_item_context.prompt_text := p_prompt_text;
356: END IF;
357: IF (NVL(l_template_item_context.prompt_alignment_offset,hr_api.g_number) = NVL(l_template_item.prompt_alignment_offset,hr_api.g_number)) THEN
358: l_template_item_context.prompt_alignment_offset := p_prompt_alignment_offset;

Line 357: IF (NVL(l_template_item_context.prompt_alignment_offset,hr_api.g_number) = NVL(l_template_item.prompt_alignment_offset,hr_api.g_number)) THEN

353: END IF;
354: IF (NVL(l_template_item_context.prompt_text,hr_api.g_varchar2) = NVL(l_template_item.prompt_text,hr_api.g_varchar2)) THEN
355: l_template_item_context.prompt_text := p_prompt_text;
356: END IF;
357: IF (NVL(l_template_item_context.prompt_alignment_offset,hr_api.g_number) = NVL(l_template_item.prompt_alignment_offset,hr_api.g_number)) THEN
358: l_template_item_context.prompt_alignment_offset := p_prompt_alignment_offset;
359: END IF;
360: IF (NVL(l_template_item_context.prompt_display_style,hr_api.g_number) = NVL(l_template_item.prompt_display_style,hr_api.g_number)) THEN
361: l_template_item_context.prompt_display_style := p_prompt_display_style;

Line 360: IF (NVL(l_template_item_context.prompt_display_style,hr_api.g_number) = NVL(l_template_item.prompt_display_style,hr_api.g_number)) THEN

356: END IF;
357: IF (NVL(l_template_item_context.prompt_alignment_offset,hr_api.g_number) = NVL(l_template_item.prompt_alignment_offset,hr_api.g_number)) THEN
358: l_template_item_context.prompt_alignment_offset := p_prompt_alignment_offset;
359: END IF;
360: IF (NVL(l_template_item_context.prompt_display_style,hr_api.g_number) = NVL(l_template_item.prompt_display_style,hr_api.g_number)) THEN
361: l_template_item_context.prompt_display_style := p_prompt_display_style;
362: END IF;
363: IF (NVL(l_template_item_context.prompt_edge,hr_api.g_number) = NVL(l_template_item.prompt_edge,hr_api.g_number)) THEN
364: l_template_item_context.prompt_edge := p_prompt_edge;

Line 363: IF (NVL(l_template_item_context.prompt_edge,hr_api.g_number) = NVL(l_template_item.prompt_edge,hr_api.g_number)) THEN

359: END IF;
360: IF (NVL(l_template_item_context.prompt_display_style,hr_api.g_number) = NVL(l_template_item.prompt_display_style,hr_api.g_number)) THEN
361: l_template_item_context.prompt_display_style := p_prompt_display_style;
362: END IF;
363: IF (NVL(l_template_item_context.prompt_edge,hr_api.g_number) = NVL(l_template_item.prompt_edge,hr_api.g_number)) THEN
364: l_template_item_context.prompt_edge := p_prompt_edge;
365: END IF;
366: IF (NVL(l_template_item_context.prompt_edge_alignment,hr_api.g_number) = NVL(l_template_item.prompt_edge_alignment,hr_api.g_number)) THEN
367: l_template_item_context.prompt_edge_alignment := p_prompt_edge_alignment;

Line 366: IF (NVL(l_template_item_context.prompt_edge_alignment,hr_api.g_number) = NVL(l_template_item.prompt_edge_alignment,hr_api.g_number)) THEN

362: END IF;
363: IF (NVL(l_template_item_context.prompt_edge,hr_api.g_number) = NVL(l_template_item.prompt_edge,hr_api.g_number)) THEN
364: l_template_item_context.prompt_edge := p_prompt_edge;
365: END IF;
366: IF (NVL(l_template_item_context.prompt_edge_alignment,hr_api.g_number) = NVL(l_template_item.prompt_edge_alignment,hr_api.g_number)) THEN
367: l_template_item_context.prompt_edge_alignment := p_prompt_edge_alignment;
368: END IF;
369: IF (NVL(l_template_item_context.prompt_edge_offset,hr_api.g_number) = NVL(l_template_item.prompt_edge_offset,hr_api.g_number)) THEN
370: l_template_item_context.prompt_edge_offset := p_prompt_edge_offset;

Line 369: IF (NVL(l_template_item_context.prompt_edge_offset,hr_api.g_number) = NVL(l_template_item.prompt_edge_offset,hr_api.g_number)) THEN

365: END IF;
366: IF (NVL(l_template_item_context.prompt_edge_alignment,hr_api.g_number) = NVL(l_template_item.prompt_edge_alignment,hr_api.g_number)) THEN
367: l_template_item_context.prompt_edge_alignment := p_prompt_edge_alignment;
368: END IF;
369: IF (NVL(l_template_item_context.prompt_edge_offset,hr_api.g_number) = NVL(l_template_item.prompt_edge_offset,hr_api.g_number)) THEN
370: l_template_item_context.prompt_edge_offset := p_prompt_edge_offset;
371: END IF;
372: IF (NVL(l_template_item_context.prompt_text_alignment,hr_api.g_number) = NVL(l_template_item.prompt_text_alignment,hr_api.g_number)) THEN
373: l_template_item_context.prompt_text_alignment := p_prompt_text_alignment;

Line 372: IF (NVL(l_template_item_context.prompt_text_alignment,hr_api.g_number) = NVL(l_template_item.prompt_text_alignment,hr_api.g_number)) THEN

368: END IF;
369: IF (NVL(l_template_item_context.prompt_edge_offset,hr_api.g_number) = NVL(l_template_item.prompt_edge_offset,hr_api.g_number)) THEN
370: l_template_item_context.prompt_edge_offset := p_prompt_edge_offset;
371: END IF;
372: IF (NVL(l_template_item_context.prompt_text_alignment,hr_api.g_number) = NVL(l_template_item.prompt_text_alignment,hr_api.g_number)) THEN
373: l_template_item_context.prompt_text_alignment := p_prompt_text_alignment;
374: END IF;
375: IF (NVL(l_template_item_context.query_allowed,hr_api.g_number) = NVL(l_template_item.query_allowed,hr_api.g_number)) THEN
376: l_template_item_context.query_allowed := p_query_allowed;

Line 375: IF (NVL(l_template_item_context.query_allowed,hr_api.g_number) = NVL(l_template_item.query_allowed,hr_api.g_number)) THEN

371: END IF;
372: IF (NVL(l_template_item_context.prompt_text_alignment,hr_api.g_number) = NVL(l_template_item.prompt_text_alignment,hr_api.g_number)) THEN
373: l_template_item_context.prompt_text_alignment := p_prompt_text_alignment;
374: END IF;
375: IF (NVL(l_template_item_context.query_allowed,hr_api.g_number) = NVL(l_template_item.query_allowed,hr_api.g_number)) THEN
376: l_template_item_context.query_allowed := p_query_allowed;
377: END IF;
378: IF (NVL(l_template_item_context.required,hr_api.g_number) = NVL(l_template_item.required,hr_api.g_number)) THEN
379: l_template_item_context.required := p_required;

Line 378: IF (NVL(l_template_item_context.required,hr_api.g_number) = NVL(l_template_item.required,hr_api.g_number)) THEN

374: END IF;
375: IF (NVL(l_template_item_context.query_allowed,hr_api.g_number) = NVL(l_template_item.query_allowed,hr_api.g_number)) THEN
376: l_template_item_context.query_allowed := p_query_allowed;
377: END IF;
378: IF (NVL(l_template_item_context.required,hr_api.g_number) = NVL(l_template_item.required,hr_api.g_number)) THEN
379: l_template_item_context.required := p_required;
380: END IF;
381: IF (NVL(l_template_item_context.tooltip_text,hr_api.g_varchar2) = NVL(l_template_item.tooltip_text,hr_api.g_varchar2)) THEN
382: l_template_item_context.tooltip_text := p_tooltip_text;

Line 381: IF (NVL(l_template_item_context.tooltip_text,hr_api.g_varchar2) = NVL(l_template_item.tooltip_text,hr_api.g_varchar2)) THEN

377: END IF;
378: IF (NVL(l_template_item_context.required,hr_api.g_number) = NVL(l_template_item.required,hr_api.g_number)) THEN
379: l_template_item_context.required := p_required;
380: END IF;
381: IF (NVL(l_template_item_context.tooltip_text,hr_api.g_varchar2) = NVL(l_template_item.tooltip_text,hr_api.g_varchar2)) THEN
382: l_template_item_context.tooltip_text := p_tooltip_text;
383: END IF;
384: IF (NVL(l_template_item_context.update_allowed,hr_api.g_number) = NVL(l_template_item.update_allowed,hr_api.g_number)) THEN
385: l_template_item_context.update_allowed := p_update_allowed;

Line 384: IF (NVL(l_template_item_context.update_allowed,hr_api.g_number) = NVL(l_template_item.update_allowed,hr_api.g_number)) THEN

380: END IF;
381: IF (NVL(l_template_item_context.tooltip_text,hr_api.g_varchar2) = NVL(l_template_item.tooltip_text,hr_api.g_varchar2)) THEN
382: l_template_item_context.tooltip_text := p_tooltip_text;
383: END IF;
384: IF (NVL(l_template_item_context.update_allowed,hr_api.g_number) = NVL(l_template_item.update_allowed,hr_api.g_number)) THEN
385: l_template_item_context.update_allowed := p_update_allowed;
386: END IF;
387: IF (NVL(l_template_item_context.validation_formula_id,hr_api.g_number) = NVL(l_template_item.validation_formula_id,hr_api.g_number)) THEN
388: l_template_item_context.validation_formula_id := p_validation_formula_id;

Line 387: IF (NVL(l_template_item_context.validation_formula_id,hr_api.g_number) = NVL(l_template_item.validation_formula_id,hr_api.g_number)) THEN

383: END IF;
384: IF (NVL(l_template_item_context.update_allowed,hr_api.g_number) = NVL(l_template_item.update_allowed,hr_api.g_number)) THEN
385: l_template_item_context.update_allowed := p_update_allowed;
386: END IF;
387: IF (NVL(l_template_item_context.validation_formula_id,hr_api.g_number) = NVL(l_template_item.validation_formula_id,hr_api.g_number)) THEN
388: l_template_item_context.validation_formula_id := p_validation_formula_id;
389: END IF;
390: IF (NVL(l_template_item_context.validation_parameter_item_id1,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id1,hr_api.g_number)) THEN
391: l_template_item_context.validation_parameter_item_id1 := p_validation_param_item_id1;

Line 390: IF (NVL(l_template_item_context.validation_parameter_item_id1,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id1,hr_api.g_number)) THEN

386: END IF;
387: IF (NVL(l_template_item_context.validation_formula_id,hr_api.g_number) = NVL(l_template_item.validation_formula_id,hr_api.g_number)) THEN
388: l_template_item_context.validation_formula_id := p_validation_formula_id;
389: END IF;
390: IF (NVL(l_template_item_context.validation_parameter_item_id1,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id1,hr_api.g_number)) THEN
391: l_template_item_context.validation_parameter_item_id1 := p_validation_param_item_id1;
392: END IF;
393: IF (NVL(l_template_item_context.validation_parameter_item_id2,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id2,hr_api.g_number)) THEN
394: l_template_item_context.validation_parameter_item_id2 := p_validation_param_item_id2;

Line 393: IF (NVL(l_template_item_context.validation_parameter_item_id2,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id2,hr_api.g_number)) THEN

389: END IF;
390: IF (NVL(l_template_item_context.validation_parameter_item_id1,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id1,hr_api.g_number)) THEN
391: l_template_item_context.validation_parameter_item_id1 := p_validation_param_item_id1;
392: END IF;
393: IF (NVL(l_template_item_context.validation_parameter_item_id2,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id2,hr_api.g_number)) THEN
394: l_template_item_context.validation_parameter_item_id2 := p_validation_param_item_id2;
395: END IF;
396: IF (NVL(l_template_item_context.validation_parameter_item_id3,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id3,hr_api.g_number)) THEN
397: l_template_item_context.validation_parameter_item_id3 := p_validation_param_item_id3;

Line 396: IF (NVL(l_template_item_context.validation_parameter_item_id3,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id3,hr_api.g_number)) THEN

392: END IF;
393: IF (NVL(l_template_item_context.validation_parameter_item_id2,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id2,hr_api.g_number)) THEN
394: l_template_item_context.validation_parameter_item_id2 := p_validation_param_item_id2;
395: END IF;
396: IF (NVL(l_template_item_context.validation_parameter_item_id3,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id3,hr_api.g_number)) THEN
397: l_template_item_context.validation_parameter_item_id3 := p_validation_param_item_id3;
398: END IF;
399: IF (NVL(l_template_item_context.validation_parameter_item_id4,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id4,hr_api.g_number)) THEN
400: l_template_item_context.validation_parameter_item_id4 := p_validation_param_item_id4;

Line 399: IF (NVL(l_template_item_context.validation_parameter_item_id4,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id4,hr_api.g_number)) THEN

395: END IF;
396: IF (NVL(l_template_item_context.validation_parameter_item_id3,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id3,hr_api.g_number)) THEN
397: l_template_item_context.validation_parameter_item_id3 := p_validation_param_item_id3;
398: END IF;
399: IF (NVL(l_template_item_context.validation_parameter_item_id4,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id4,hr_api.g_number)) THEN
400: l_template_item_context.validation_parameter_item_id4 := p_validation_param_item_id4;
401: END IF;
402: IF (NVL(l_template_item_context.validation_parameter_item_id5,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id5,hr_api.g_number)) THEN
403: l_template_item_context.validation_parameter_item_id5 := p_validation_param_item_id5;

Line 402: IF (NVL(l_template_item_context.validation_parameter_item_id5,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id5,hr_api.g_number)) THEN

398: END IF;
399: IF (NVL(l_template_item_context.validation_parameter_item_id4,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id4,hr_api.g_number)) THEN
400: l_template_item_context.validation_parameter_item_id4 := p_validation_param_item_id4;
401: END IF;
402: IF (NVL(l_template_item_context.validation_parameter_item_id5,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id5,hr_api.g_number)) THEN
403: l_template_item_context.validation_parameter_item_id5 := p_validation_param_item_id5;
404: END IF;
405: IF (NVL(l_template_item_context.visible,hr_api.g_number) = NVL(l_template_item.visible,hr_api.g_number)) THEN
406: l_template_item_context.visible := p_visible;

Line 405: IF (NVL(l_template_item_context.visible,hr_api.g_number) = NVL(l_template_item.visible,hr_api.g_number)) THEN

401: END IF;
402: IF (NVL(l_template_item_context.validation_parameter_item_id5,hr_api.g_number) = NVL(l_template_item.validation_parameter_item_id5,hr_api.g_number)) THEN
403: l_template_item_context.validation_parameter_item_id5 := p_validation_param_item_id5;
404: END IF;
405: IF (NVL(l_template_item_context.visible,hr_api.g_number) = NVL(l_template_item.visible,hr_api.g_number)) THEN
406: l_template_item_context.visible := p_visible;
407: END IF;
408: IF (NVL(l_template_item_context.width,hr_api.g_number) = NVL(l_template_item.width,hr_api.g_number)) THEN
409: l_template_item_context.width := p_width;

Line 408: IF (NVL(l_template_item_context.width,hr_api.g_number) = NVL(l_template_item.width,hr_api.g_number)) THEN

404: END IF;
405: IF (NVL(l_template_item_context.visible,hr_api.g_number) = NVL(l_template_item.visible,hr_api.g_number)) THEN
406: l_template_item_context.visible := p_visible;
407: END IF;
408: IF (NVL(l_template_item_context.width,hr_api.g_number) = NVL(l_template_item.width,hr_api.g_number)) THEN
409: l_template_item_context.width := p_width;
410: END IF;
411: IF (NVL(l_template_item_context.x_position,hr_api.g_number) = NVL(l_template_item.x_position,hr_api.g_number)) THEN
412: l_template_item_context.x_position := p_x_position;

Line 411: IF (NVL(l_template_item_context.x_position,hr_api.g_number) = NVL(l_template_item.x_position,hr_api.g_number)) THEN

407: END IF;
408: IF (NVL(l_template_item_context.width,hr_api.g_number) = NVL(l_template_item.width,hr_api.g_number)) THEN
409: l_template_item_context.width := p_width;
410: END IF;
411: IF (NVL(l_template_item_context.x_position,hr_api.g_number) = NVL(l_template_item.x_position,hr_api.g_number)) THEN
412: l_template_item_context.x_position := p_x_position;
413: END IF;
414: IF (NVL(l_template_item_context.y_position,hr_api.g_number) = NVL(l_template_item.y_position,hr_api.g_number)) THEN
415: l_template_item_context.y_position := p_y_position;

Line 414: IF (NVL(l_template_item_context.y_position,hr_api.g_number) = NVL(l_template_item.y_position,hr_api.g_number)) THEN

410: END IF;
411: IF (NVL(l_template_item_context.x_position,hr_api.g_number) = NVL(l_template_item.x_position,hr_api.g_number)) THEN
412: l_template_item_context.x_position := p_x_position;
413: END IF;
414: IF (NVL(l_template_item_context.y_position,hr_api.g_number) = NVL(l_template_item.y_position,hr_api.g_number)) THEN
415: l_template_item_context.y_position := p_y_position;
416: END IF;
417: IF (NVL(l_template_item_context.information_category,hr_api.g_varchar2) = NVL(l_template_item.information_category,hr_api.g_varchar2)) THEN
418: l_template_item_context.information_category := p_information_category;

Line 417: IF (NVL(l_template_item_context.information_category,hr_api.g_varchar2) = NVL(l_template_item.information_category,hr_api.g_varchar2)) THEN

413: END IF;
414: IF (NVL(l_template_item_context.y_position,hr_api.g_number) = NVL(l_template_item.y_position,hr_api.g_number)) THEN
415: l_template_item_context.y_position := p_y_position;
416: END IF;
417: IF (NVL(l_template_item_context.information_category,hr_api.g_varchar2) = NVL(l_template_item.information_category,hr_api.g_varchar2)) THEN
418: l_template_item_context.information_category := p_information_category;
419: IF (NVL(l_template_item_context.information1,hr_api.g_varchar2) = NVL(l_template_item.information1,hr_api.g_varchar2)) THEN
420: l_template_item_context.information1 := p_information1;
421: END IF;

Line 419: IF (NVL(l_template_item_context.information1,hr_api.g_varchar2) = NVL(l_template_item.information1,hr_api.g_varchar2)) THEN

415: l_template_item_context.y_position := p_y_position;
416: END IF;
417: IF (NVL(l_template_item_context.information_category,hr_api.g_varchar2) = NVL(l_template_item.information_category,hr_api.g_varchar2)) THEN
418: l_template_item_context.information_category := p_information_category;
419: IF (NVL(l_template_item_context.information1,hr_api.g_varchar2) = NVL(l_template_item.information1,hr_api.g_varchar2)) THEN
420: l_template_item_context.information1 := p_information1;
421: END IF;
422: IF (NVL(l_template_item_context.information2,hr_api.g_varchar2) = NVL(l_template_item.information2,hr_api.g_varchar2)) THEN
423: l_template_item_context.information2 := p_information2;

Line 422: IF (NVL(l_template_item_context.information2,hr_api.g_varchar2) = NVL(l_template_item.information2,hr_api.g_varchar2)) THEN

418: l_template_item_context.information_category := p_information_category;
419: IF (NVL(l_template_item_context.information1,hr_api.g_varchar2) = NVL(l_template_item.information1,hr_api.g_varchar2)) THEN
420: l_template_item_context.information1 := p_information1;
421: END IF;
422: IF (NVL(l_template_item_context.information2,hr_api.g_varchar2) = NVL(l_template_item.information2,hr_api.g_varchar2)) THEN
423: l_template_item_context.information2 := p_information2;
424: END IF;
425: IF (NVL(l_template_item_context.information3,hr_api.g_varchar2) = NVL(l_template_item.information3,hr_api.g_varchar2)) THEN
426: l_template_item_context.information3 := p_information3;

Line 425: IF (NVL(l_template_item_context.information3,hr_api.g_varchar2) = NVL(l_template_item.information3,hr_api.g_varchar2)) THEN

421: END IF;
422: IF (NVL(l_template_item_context.information2,hr_api.g_varchar2) = NVL(l_template_item.information2,hr_api.g_varchar2)) THEN
423: l_template_item_context.information2 := p_information2;
424: END IF;
425: IF (NVL(l_template_item_context.information3,hr_api.g_varchar2) = NVL(l_template_item.information3,hr_api.g_varchar2)) THEN
426: l_template_item_context.information3 := p_information3;
427: END IF;
428: IF (NVL(l_template_item_context.information4,hr_api.g_varchar2) = NVL(l_template_item.information4,hr_api.g_varchar2)) THEN
429: l_template_item_context.information4 := p_information4;

Line 428: IF (NVL(l_template_item_context.information4,hr_api.g_varchar2) = NVL(l_template_item.information4,hr_api.g_varchar2)) THEN

424: END IF;
425: IF (NVL(l_template_item_context.information3,hr_api.g_varchar2) = NVL(l_template_item.information3,hr_api.g_varchar2)) THEN
426: l_template_item_context.information3 := p_information3;
427: END IF;
428: IF (NVL(l_template_item_context.information4,hr_api.g_varchar2) = NVL(l_template_item.information4,hr_api.g_varchar2)) THEN
429: l_template_item_context.information4 := p_information4;
430: END IF;
431: IF (NVL(l_template_item_context.information5,hr_api.g_varchar2) = NVL(l_template_item.information5,hr_api.g_varchar2)) THEN
432: l_template_item_context.information5 := p_information5;

Line 431: IF (NVL(l_template_item_context.information5,hr_api.g_varchar2) = NVL(l_template_item.information5,hr_api.g_varchar2)) THEN

427: END IF;
428: IF (NVL(l_template_item_context.information4,hr_api.g_varchar2) = NVL(l_template_item.information4,hr_api.g_varchar2)) THEN
429: l_template_item_context.information4 := p_information4;
430: END IF;
431: IF (NVL(l_template_item_context.information5,hr_api.g_varchar2) = NVL(l_template_item.information5,hr_api.g_varchar2)) THEN
432: l_template_item_context.information5 := p_information5;
433: END IF;
434: IF (NVL(l_template_item_context.information6,hr_api.g_varchar2) = NVL(l_template_item.information6,hr_api.g_varchar2)) THEN
435: l_template_item_context.information6 := p_information6;

Line 434: IF (NVL(l_template_item_context.information6,hr_api.g_varchar2) = NVL(l_template_item.information6,hr_api.g_varchar2)) THEN

430: END IF;
431: IF (NVL(l_template_item_context.information5,hr_api.g_varchar2) = NVL(l_template_item.information5,hr_api.g_varchar2)) THEN
432: l_template_item_context.information5 := p_information5;
433: END IF;
434: IF (NVL(l_template_item_context.information6,hr_api.g_varchar2) = NVL(l_template_item.information6,hr_api.g_varchar2)) THEN
435: l_template_item_context.information6 := p_information6;
436: END IF;
437: IF (NVL(l_template_item_context.information7,hr_api.g_varchar2) = NVL(l_template_item.information7,hr_api.g_varchar2)) THEN
438: l_template_item_context.information7 := p_information7;

Line 437: IF (NVL(l_template_item_context.information7,hr_api.g_varchar2) = NVL(l_template_item.information7,hr_api.g_varchar2)) THEN

433: END IF;
434: IF (NVL(l_template_item_context.information6,hr_api.g_varchar2) = NVL(l_template_item.information6,hr_api.g_varchar2)) THEN
435: l_template_item_context.information6 := p_information6;
436: END IF;
437: IF (NVL(l_template_item_context.information7,hr_api.g_varchar2) = NVL(l_template_item.information7,hr_api.g_varchar2)) THEN
438: l_template_item_context.information7 := p_information7;
439: END IF;
440: IF (NVL(l_template_item_context.information8,hr_api.g_varchar2) = NVL(l_template_item.information8,hr_api.g_varchar2)) THEN
441: l_template_item_context.information8 := p_information8;

Line 440: IF (NVL(l_template_item_context.information8,hr_api.g_varchar2) = NVL(l_template_item.information8,hr_api.g_varchar2)) THEN

436: END IF;
437: IF (NVL(l_template_item_context.information7,hr_api.g_varchar2) = NVL(l_template_item.information7,hr_api.g_varchar2)) THEN
438: l_template_item_context.information7 := p_information7;
439: END IF;
440: IF (NVL(l_template_item_context.information8,hr_api.g_varchar2) = NVL(l_template_item.information8,hr_api.g_varchar2)) THEN
441: l_template_item_context.information8 := p_information8;
442: END IF;
443: IF (NVL(l_template_item_context.information9,hr_api.g_varchar2) = NVL(l_template_item.information9,hr_api.g_varchar2)) THEN
444: l_template_item_context.information9 := p_information9;

Line 443: IF (NVL(l_template_item_context.information9,hr_api.g_varchar2) = NVL(l_template_item.information9,hr_api.g_varchar2)) THEN

439: END IF;
440: IF (NVL(l_template_item_context.information8,hr_api.g_varchar2) = NVL(l_template_item.information8,hr_api.g_varchar2)) THEN
441: l_template_item_context.information8 := p_information8;
442: END IF;
443: IF (NVL(l_template_item_context.information9,hr_api.g_varchar2) = NVL(l_template_item.information9,hr_api.g_varchar2)) THEN
444: l_template_item_context.information9 := p_information9;
445: END IF;
446: IF (NVL(l_template_item_context.information10,hr_api.g_varchar2) = NVL(l_template_item.information10,hr_api.g_varchar2)) THEN
447: l_template_item_context.information10 := p_information10;

Line 446: IF (NVL(l_template_item_context.information10,hr_api.g_varchar2) = NVL(l_template_item.information10,hr_api.g_varchar2)) THEN

442: END IF;
443: IF (NVL(l_template_item_context.information9,hr_api.g_varchar2) = NVL(l_template_item.information9,hr_api.g_varchar2)) THEN
444: l_template_item_context.information9 := p_information9;
445: END IF;
446: IF (NVL(l_template_item_context.information10,hr_api.g_varchar2) = NVL(l_template_item.information10,hr_api.g_varchar2)) THEN
447: l_template_item_context.information10 := p_information10;
448: END IF;
449: IF (NVL(l_template_item_context.information11,hr_api.g_varchar2) = NVL(l_template_item.information11,hr_api.g_varchar2)) THEN
450: l_template_item_context.information11 := p_information11;

Line 449: IF (NVL(l_template_item_context.information11,hr_api.g_varchar2) = NVL(l_template_item.information11,hr_api.g_varchar2)) THEN

445: END IF;
446: IF (NVL(l_template_item_context.information10,hr_api.g_varchar2) = NVL(l_template_item.information10,hr_api.g_varchar2)) THEN
447: l_template_item_context.information10 := p_information10;
448: END IF;
449: IF (NVL(l_template_item_context.information11,hr_api.g_varchar2) = NVL(l_template_item.information11,hr_api.g_varchar2)) THEN
450: l_template_item_context.information11 := p_information11;
451: END IF;
452: IF (NVL(l_template_item_context.information12,hr_api.g_varchar2) = NVL(l_template_item.information12,hr_api.g_varchar2)) THEN
453: l_template_item_context.information12 := p_information12;

Line 452: IF (NVL(l_template_item_context.information12,hr_api.g_varchar2) = NVL(l_template_item.information12,hr_api.g_varchar2)) THEN

448: END IF;
449: IF (NVL(l_template_item_context.information11,hr_api.g_varchar2) = NVL(l_template_item.information11,hr_api.g_varchar2)) THEN
450: l_template_item_context.information11 := p_information11;
451: END IF;
452: IF (NVL(l_template_item_context.information12,hr_api.g_varchar2) = NVL(l_template_item.information12,hr_api.g_varchar2)) THEN
453: l_template_item_context.information12 := p_information12;
454: END IF;
455: IF (NVL(l_template_item_context.information13,hr_api.g_varchar2) = NVL(l_template_item.information13,hr_api.g_varchar2)) THEN
456: l_template_item_context.information13 := p_information13;

Line 455: IF (NVL(l_template_item_context.information13,hr_api.g_varchar2) = NVL(l_template_item.information13,hr_api.g_varchar2)) THEN

451: END IF;
452: IF (NVL(l_template_item_context.information12,hr_api.g_varchar2) = NVL(l_template_item.information12,hr_api.g_varchar2)) THEN
453: l_template_item_context.information12 := p_information12;
454: END IF;
455: IF (NVL(l_template_item_context.information13,hr_api.g_varchar2) = NVL(l_template_item.information13,hr_api.g_varchar2)) THEN
456: l_template_item_context.information13 := p_information13;
457: END IF;
458: IF (NVL(l_template_item_context.information14,hr_api.g_varchar2) = NVL(l_template_item.information14,hr_api.g_varchar2)) THEN
459: l_template_item_context.information14 := p_information14;

Line 458: IF (NVL(l_template_item_context.information14,hr_api.g_varchar2) = NVL(l_template_item.information14,hr_api.g_varchar2)) THEN

454: END IF;
455: IF (NVL(l_template_item_context.information13,hr_api.g_varchar2) = NVL(l_template_item.information13,hr_api.g_varchar2)) THEN
456: l_template_item_context.information13 := p_information13;
457: END IF;
458: IF (NVL(l_template_item_context.information14,hr_api.g_varchar2) = NVL(l_template_item.information14,hr_api.g_varchar2)) THEN
459: l_template_item_context.information14 := p_information14;
460: END IF;
461: IF (NVL(l_template_item_context.information15,hr_api.g_varchar2) = NVL(l_template_item.information15,hr_api.g_varchar2)) THEN
462: l_template_item_context.information15 := p_information15;

Line 461: IF (NVL(l_template_item_context.information15,hr_api.g_varchar2) = NVL(l_template_item.information15,hr_api.g_varchar2)) THEN

457: END IF;
458: IF (NVL(l_template_item_context.information14,hr_api.g_varchar2) = NVL(l_template_item.information14,hr_api.g_varchar2)) THEN
459: l_template_item_context.information14 := p_information14;
460: END IF;
461: IF (NVL(l_template_item_context.information15,hr_api.g_varchar2) = NVL(l_template_item.information15,hr_api.g_varchar2)) THEN
462: l_template_item_context.information15 := p_information15;
463: END IF;
464: IF (NVL(l_template_item_context.information16,hr_api.g_varchar2) = NVL(l_template_item.information16,hr_api.g_varchar2)) THEN
465: l_template_item_context.information16 := p_information16;

Line 464: IF (NVL(l_template_item_context.information16,hr_api.g_varchar2) = NVL(l_template_item.information16,hr_api.g_varchar2)) THEN

460: END IF;
461: IF (NVL(l_template_item_context.information15,hr_api.g_varchar2) = NVL(l_template_item.information15,hr_api.g_varchar2)) THEN
462: l_template_item_context.information15 := p_information15;
463: END IF;
464: IF (NVL(l_template_item_context.information16,hr_api.g_varchar2) = NVL(l_template_item.information16,hr_api.g_varchar2)) THEN
465: l_template_item_context.information16 := p_information16;
466: END IF;
467: IF (NVL(l_template_item_context.information17,hr_api.g_varchar2) = NVL(l_template_item.information17,hr_api.g_varchar2)) THEN
468: l_template_item_context.information17 := p_information17;

Line 467: IF (NVL(l_template_item_context.information17,hr_api.g_varchar2) = NVL(l_template_item.information17,hr_api.g_varchar2)) THEN

463: END IF;
464: IF (NVL(l_template_item_context.information16,hr_api.g_varchar2) = NVL(l_template_item.information16,hr_api.g_varchar2)) THEN
465: l_template_item_context.information16 := p_information16;
466: END IF;
467: IF (NVL(l_template_item_context.information17,hr_api.g_varchar2) = NVL(l_template_item.information17,hr_api.g_varchar2)) THEN
468: l_template_item_context.information17 := p_information17;
469: END IF;
470: IF (NVL(l_template_item_context.information18,hr_api.g_varchar2) = NVL(l_template_item.information18,hr_api.g_varchar2)) THEN
471: l_template_item_context.information18 := p_information18;

Line 470: IF (NVL(l_template_item_context.information18,hr_api.g_varchar2) = NVL(l_template_item.information18,hr_api.g_varchar2)) THEN

466: END IF;
467: IF (NVL(l_template_item_context.information17,hr_api.g_varchar2) = NVL(l_template_item.information17,hr_api.g_varchar2)) THEN
468: l_template_item_context.information17 := p_information17;
469: END IF;
470: IF (NVL(l_template_item_context.information18,hr_api.g_varchar2) = NVL(l_template_item.information18,hr_api.g_varchar2)) THEN
471: l_template_item_context.information18 := p_information18;
472: END IF;
473: IF (NVL(l_template_item_context.information19,hr_api.g_varchar2) = NVL(l_template_item.information19,hr_api.g_varchar2)) THEN
474: l_template_item_context.information19 := p_information19;

Line 473: IF (NVL(l_template_item_context.information19,hr_api.g_varchar2) = NVL(l_template_item.information19,hr_api.g_varchar2)) THEN

469: END IF;
470: IF (NVL(l_template_item_context.information18,hr_api.g_varchar2) = NVL(l_template_item.information18,hr_api.g_varchar2)) THEN
471: l_template_item_context.information18 := p_information18;
472: END IF;
473: IF (NVL(l_template_item_context.information19,hr_api.g_varchar2) = NVL(l_template_item.information19,hr_api.g_varchar2)) THEN
474: l_template_item_context.information19 := p_information19;
475: END IF;
476: IF (NVL(l_template_item_context.information20,hr_api.g_varchar2) = NVL(l_template_item.information20,hr_api.g_varchar2)) THEN
477: l_template_item_context.information20 := p_information20;

Line 476: IF (NVL(l_template_item_context.information20,hr_api.g_varchar2) = NVL(l_template_item.information20,hr_api.g_varchar2)) THEN

472: END IF;
473: IF (NVL(l_template_item_context.information19,hr_api.g_varchar2) = NVL(l_template_item.information19,hr_api.g_varchar2)) THEN
474: l_template_item_context.information19 := p_information19;
475: END IF;
476: IF (NVL(l_template_item_context.information20,hr_api.g_varchar2) = NVL(l_template_item.information20,hr_api.g_varchar2)) THEN
477: l_template_item_context.information20 := p_information20;
478: END IF;
479: IF (NVL(l_template_item_context.information21,hr_api.g_varchar2) = NVL(l_template_item.information21,hr_api.g_varchar2)) THEN
480: l_template_item_context.information21 := p_information21;

Line 479: IF (NVL(l_template_item_context.information21,hr_api.g_varchar2) = NVL(l_template_item.information21,hr_api.g_varchar2)) THEN

475: END IF;
476: IF (NVL(l_template_item_context.information20,hr_api.g_varchar2) = NVL(l_template_item.information20,hr_api.g_varchar2)) THEN
477: l_template_item_context.information20 := p_information20;
478: END IF;
479: IF (NVL(l_template_item_context.information21,hr_api.g_varchar2) = NVL(l_template_item.information21,hr_api.g_varchar2)) THEN
480: l_template_item_context.information21 := p_information21;
481: END IF;
482: IF (NVL(l_template_item_context.information22,hr_api.g_varchar2) = NVL(l_template_item.information22,hr_api.g_varchar2)) THEN
483: l_template_item_context.information22 := p_information22;

Line 482: IF (NVL(l_template_item_context.information22,hr_api.g_varchar2) = NVL(l_template_item.information22,hr_api.g_varchar2)) THEN

478: END IF;
479: IF (NVL(l_template_item_context.information21,hr_api.g_varchar2) = NVL(l_template_item.information21,hr_api.g_varchar2)) THEN
480: l_template_item_context.information21 := p_information21;
481: END IF;
482: IF (NVL(l_template_item_context.information22,hr_api.g_varchar2) = NVL(l_template_item.information22,hr_api.g_varchar2)) THEN
483: l_template_item_context.information22 := p_information22;
484: END IF;
485: IF (NVL(l_template_item_context.information23,hr_api.g_varchar2) = NVL(l_template_item.information23,hr_api.g_varchar2)) THEN
486: l_template_item_context.information23 := p_information23;

Line 485: IF (NVL(l_template_item_context.information23,hr_api.g_varchar2) = NVL(l_template_item.information23,hr_api.g_varchar2)) THEN

481: END IF;
482: IF (NVL(l_template_item_context.information22,hr_api.g_varchar2) = NVL(l_template_item.information22,hr_api.g_varchar2)) THEN
483: l_template_item_context.information22 := p_information22;
484: END IF;
485: IF (NVL(l_template_item_context.information23,hr_api.g_varchar2) = NVL(l_template_item.information23,hr_api.g_varchar2)) THEN
486: l_template_item_context.information23 := p_information23;
487: END IF;
488: IF (NVL(l_template_item_context.information24,hr_api.g_varchar2) = NVL(l_template_item.information24,hr_api.g_varchar2)) THEN
489: l_template_item_context.information24 := p_information24;

Line 488: IF (NVL(l_template_item_context.information24,hr_api.g_varchar2) = NVL(l_template_item.information24,hr_api.g_varchar2)) THEN

484: END IF;
485: IF (NVL(l_template_item_context.information23,hr_api.g_varchar2) = NVL(l_template_item.information23,hr_api.g_varchar2)) THEN
486: l_template_item_context.information23 := p_information23;
487: END IF;
488: IF (NVL(l_template_item_context.information24,hr_api.g_varchar2) = NVL(l_template_item.information24,hr_api.g_varchar2)) THEN
489: l_template_item_context.information24 := p_information24;
490: END IF;
491: IF (NVL(l_template_item_context.information25,hr_api.g_varchar2) = NVL(l_template_item.information25,hr_api.g_varchar2)) THEN
492: l_template_item_context.information25 := p_information25;

Line 491: IF (NVL(l_template_item_context.information25,hr_api.g_varchar2) = NVL(l_template_item.information25,hr_api.g_varchar2)) THEN

487: END IF;
488: IF (NVL(l_template_item_context.information24,hr_api.g_varchar2) = NVL(l_template_item.information24,hr_api.g_varchar2)) THEN
489: l_template_item_context.information24 := p_information24;
490: END IF;
491: IF (NVL(l_template_item_context.information25,hr_api.g_varchar2) = NVL(l_template_item.information25,hr_api.g_varchar2)) THEN
492: l_template_item_context.information25 := p_information25;
493: END IF;
494: IF (NVL(l_template_item_context.information26,hr_api.g_varchar2) = NVL(l_template_item.information26,hr_api.g_varchar2)) THEN
495: l_template_item_context.information26 := p_information26;

Line 494: IF (NVL(l_template_item_context.information26,hr_api.g_varchar2) = NVL(l_template_item.information26,hr_api.g_varchar2)) THEN

490: END IF;
491: IF (NVL(l_template_item_context.information25,hr_api.g_varchar2) = NVL(l_template_item.information25,hr_api.g_varchar2)) THEN
492: l_template_item_context.information25 := p_information25;
493: END IF;
494: IF (NVL(l_template_item_context.information26,hr_api.g_varchar2) = NVL(l_template_item.information26,hr_api.g_varchar2)) THEN
495: l_template_item_context.information26 := p_information26;
496: END IF;
497: IF (NVL(l_template_item_context.information27,hr_api.g_varchar2) = NVL(l_template_item.information27,hr_api.g_varchar2)) THEN
498: l_template_item_context.information27 := p_information27;

Line 497: IF (NVL(l_template_item_context.information27,hr_api.g_varchar2) = NVL(l_template_item.information27,hr_api.g_varchar2)) THEN

493: END IF;
494: IF (NVL(l_template_item_context.information26,hr_api.g_varchar2) = NVL(l_template_item.information26,hr_api.g_varchar2)) THEN
495: l_template_item_context.information26 := p_information26;
496: END IF;
497: IF (NVL(l_template_item_context.information27,hr_api.g_varchar2) = NVL(l_template_item.information27,hr_api.g_varchar2)) THEN
498: l_template_item_context.information27 := p_information27;
499: END IF;
500: IF (NVL(l_template_item_context.information28,hr_api.g_varchar2) = NVL(l_template_item.information28,hr_api.g_varchar2)) THEN
501: l_template_item_context.information28 := p_information28;

Line 500: IF (NVL(l_template_item_context.information28,hr_api.g_varchar2) = NVL(l_template_item.information28,hr_api.g_varchar2)) THEN

496: END IF;
497: IF (NVL(l_template_item_context.information27,hr_api.g_varchar2) = NVL(l_template_item.information27,hr_api.g_varchar2)) THEN
498: l_template_item_context.information27 := p_information27;
499: END IF;
500: IF (NVL(l_template_item_context.information28,hr_api.g_varchar2) = NVL(l_template_item.information28,hr_api.g_varchar2)) THEN
501: l_template_item_context.information28 := p_information28;
502: END IF;
503: IF (NVL(l_template_item_context.information29,hr_api.g_varchar2) = NVL(l_template_item.information29,hr_api.g_varchar2)) THEN
504: l_template_item_context.information29 := p_information29;

Line 503: IF (NVL(l_template_item_context.information29,hr_api.g_varchar2) = NVL(l_template_item.information29,hr_api.g_varchar2)) THEN

499: END IF;
500: IF (NVL(l_template_item_context.information28,hr_api.g_varchar2) = NVL(l_template_item.information28,hr_api.g_varchar2)) THEN
501: l_template_item_context.information28 := p_information28;
502: END IF;
503: IF (NVL(l_template_item_context.information29,hr_api.g_varchar2) = NVL(l_template_item.information29,hr_api.g_varchar2)) THEN
504: l_template_item_context.information29 := p_information29;
505: END IF;
506: IF (NVL(l_template_item_context.information30,hr_api.g_varchar2) = NVL(l_template_item.information30,hr_api.g_varchar2)) THEN
507: l_template_item_context.information30 := p_information30;

Line 506: IF (NVL(l_template_item_context.information30,hr_api.g_varchar2) = NVL(l_template_item.information30,hr_api.g_varchar2)) THEN

502: END IF;
503: IF (NVL(l_template_item_context.information29,hr_api.g_varchar2) = NVL(l_template_item.information29,hr_api.g_varchar2)) THEN
504: l_template_item_context.information29 := p_information29;
505: END IF;
506: IF (NVL(l_template_item_context.information30,hr_api.g_varchar2) = NVL(l_template_item.information30,hr_api.g_varchar2)) THEN
507: l_template_item_context.information30 := p_information30;
508: END IF;
509: END IF;
510: --

Line 603: ,p_language_code in varchar2 default hr_api.userenv_lang

599: -- ----------------------------------------------------------------------------
600: procedure copy_template_item
601: (p_validate in boolean default false
602: ,p_effective_date in date
603: ,p_language_code in varchar2 default hr_api.userenv_lang
604: ,p_template_item_id_from in number
605: ,p_form_template_id in number
606: ,p_template_item_id_to out nocopy number
607: ,p_object_version_number out nocopy number

Line 682: hr_api.validate_language_code(p_language_code => l_language_code);

678: -- instead of p_language_code from now on, to allow an IN OUT parameter to
679: -- be passed through.
680: --
681: l_language_code := p_language_code;
682: hr_api.validate_language_code(p_language_code => l_language_code);
683: --
684: --
685: -- Call Before Process User Hook
686: --

Line 695: when hr_api.cannot_find_prog_unit then

691: ,p_template_item_id_from => p_template_item_id_from
692: ,p_form_template_id => p_form_template_id
693: );
694: exception
695: when hr_api.cannot_find_prog_unit then
696: hr_api.cannot_find_prog_unit_error
697: (p_module_name => 'copy_template_item'
698: ,p_hook_type => 'BP'
699: );

Line 696: hr_api.cannot_find_prog_unit_error

692: ,p_form_template_id => p_form_template_id
693: );
694: exception
695: when hr_api.cannot_find_prog_unit then
696: hr_api.cannot_find_prog_unit_error
697: (p_module_name => 'copy_template_item'
698: ,p_hook_type => 'BP'
699: );
700: end;

Line 788: when hr_api.cannot_find_prog_unit then

784: ,p_template_item_id_to => l_template_item_id_to
785: ,p_object_version_number => l_object_version_number
786: );
787: exception
788: when hr_api.cannot_find_prog_unit then
789: hr_api.cannot_find_prog_unit_error
790: (p_module_name => 'copy_template_item'
791: ,p_hook_type => 'AP'
792: );

Line 789: hr_api.cannot_find_prog_unit_error

785: ,p_object_version_number => l_object_version_number
786: );
787: exception
788: when hr_api.cannot_find_prog_unit then
789: hr_api.cannot_find_prog_unit_error
790: (p_module_name => 'copy_template_item'
791: ,p_hook_type => 'AP'
792: );
793: end;

Line 800: raise hr_api.validate_enabled;

796: --
797: hr_utility.set_location('Entering:'|| l_proc, 50);
798:
799: if p_validate then
800: raise hr_api.validate_enabled;
801: end if;
802: --
803: -- Set all output arguments
804: --

Line 810: when hr_api.validate_enabled then

806: p_object_version_number := l_object_version_number;
807: --
808: hr_utility.set_location(' Leaving:'||l_proc, 70);
809: exception
810: when hr_api.validate_enabled then
811: --
812: -- As the Validate_Enabled exception has been raised
813: -- we must rollback to the savepoint
814: --

Line 843: ,p_language_code in varchar2 default hr_api.userenv_lang

839: --
840: procedure create_template_item
841: (p_validate in boolean default false
842: ,p_effective_date in date
843: ,p_language_code in varchar2 default hr_api.userenv_lang
844: ,p_form_template_id in number
845: ,p_form_item_id in number
846: ,p_template_tab_page_id in number default null
847: ,p_alignment in number default hr_api.g_number

Line 847: ,p_alignment in number default hr_api.g_number

843: ,p_language_code in varchar2 default hr_api.userenv_lang
844: ,p_form_template_id in number
845: ,p_form_item_id in number
846: ,p_template_tab_page_id in number default null
847: ,p_alignment in number default hr_api.g_number
848: ,p_bevel in number default hr_api.g_number
849: ,p_case_restriction in number default hr_api.g_number
850: ,p_default_value in varchar2 default hr_api.g_varchar2
851: ,p_enabled in number default hr_api.g_number

Line 848: ,p_bevel in number default hr_api.g_number

844: ,p_form_template_id in number
845: ,p_form_item_id in number
846: ,p_template_tab_page_id in number default null
847: ,p_alignment in number default hr_api.g_number
848: ,p_bevel in number default hr_api.g_number
849: ,p_case_restriction in number default hr_api.g_number
850: ,p_default_value in varchar2 default hr_api.g_varchar2
851: ,p_enabled in number default hr_api.g_number
852: ,p_format_mask in varchar2 default hr_api.g_varchar2

Line 849: ,p_case_restriction in number default hr_api.g_number

845: ,p_form_item_id in number
846: ,p_template_tab_page_id in number default null
847: ,p_alignment in number default hr_api.g_number
848: ,p_bevel in number default hr_api.g_number
849: ,p_case_restriction in number default hr_api.g_number
850: ,p_default_value in varchar2 default hr_api.g_varchar2
851: ,p_enabled in number default hr_api.g_number
852: ,p_format_mask in varchar2 default hr_api.g_varchar2
853: ,p_height in number default hr_api.g_number

Line 850: ,p_default_value in varchar2 default hr_api.g_varchar2

846: ,p_template_tab_page_id in number default null
847: ,p_alignment in number default hr_api.g_number
848: ,p_bevel in number default hr_api.g_number
849: ,p_case_restriction in number default hr_api.g_number
850: ,p_default_value in varchar2 default hr_api.g_varchar2
851: ,p_enabled in number default hr_api.g_number
852: ,p_format_mask in varchar2 default hr_api.g_varchar2
853: ,p_height in number default hr_api.g_number
854: ,p_information_formula_id in number default hr_api.g_number

Line 851: ,p_enabled in number default hr_api.g_number

847: ,p_alignment in number default hr_api.g_number
848: ,p_bevel in number default hr_api.g_number
849: ,p_case_restriction in number default hr_api.g_number
850: ,p_default_value in varchar2 default hr_api.g_varchar2
851: ,p_enabled in number default hr_api.g_number
852: ,p_format_mask in varchar2 default hr_api.g_varchar2
853: ,p_height in number default hr_api.g_number
854: ,p_information_formula_id in number default hr_api.g_number
855: ,p_information_param_item_id1 in number default hr_api.g_number

Line 852: ,p_format_mask in varchar2 default hr_api.g_varchar2

848: ,p_bevel in number default hr_api.g_number
849: ,p_case_restriction in number default hr_api.g_number
850: ,p_default_value in varchar2 default hr_api.g_varchar2
851: ,p_enabled in number default hr_api.g_number
852: ,p_format_mask in varchar2 default hr_api.g_varchar2
853: ,p_height in number default hr_api.g_number
854: ,p_information_formula_id in number default hr_api.g_number
855: ,p_information_param_item_id1 in number default hr_api.g_number
856: ,p_information_param_item_id2 in number default hr_api.g_number

Line 853: ,p_height in number default hr_api.g_number

849: ,p_case_restriction in number default hr_api.g_number
850: ,p_default_value in varchar2 default hr_api.g_varchar2
851: ,p_enabled in number default hr_api.g_number
852: ,p_format_mask in varchar2 default hr_api.g_varchar2
853: ,p_height in number default hr_api.g_number
854: ,p_information_formula_id in number default hr_api.g_number
855: ,p_information_param_item_id1 in number default hr_api.g_number
856: ,p_information_param_item_id2 in number default hr_api.g_number
857: ,p_information_param_item_id3 in number default hr_api.g_number

Line 854: ,p_information_formula_id in number default hr_api.g_number

850: ,p_default_value in varchar2 default hr_api.g_varchar2
851: ,p_enabled in number default hr_api.g_number
852: ,p_format_mask in varchar2 default hr_api.g_varchar2
853: ,p_height in number default hr_api.g_number
854: ,p_information_formula_id in number default hr_api.g_number
855: ,p_information_param_item_id1 in number default hr_api.g_number
856: ,p_information_param_item_id2 in number default hr_api.g_number
857: ,p_information_param_item_id3 in number default hr_api.g_number
858: ,p_information_param_item_id4 in number default hr_api.g_number

Line 855: ,p_information_param_item_id1 in number default hr_api.g_number

851: ,p_enabled in number default hr_api.g_number
852: ,p_format_mask in varchar2 default hr_api.g_varchar2
853: ,p_height in number default hr_api.g_number
854: ,p_information_formula_id in number default hr_api.g_number
855: ,p_information_param_item_id1 in number default hr_api.g_number
856: ,p_information_param_item_id2 in number default hr_api.g_number
857: ,p_information_param_item_id3 in number default hr_api.g_number
858: ,p_information_param_item_id4 in number default hr_api.g_number
859: ,p_information_param_item_id5 in number default hr_api.g_number

Line 856: ,p_information_param_item_id2 in number default hr_api.g_number

852: ,p_format_mask in varchar2 default hr_api.g_varchar2
853: ,p_height in number default hr_api.g_number
854: ,p_information_formula_id in number default hr_api.g_number
855: ,p_information_param_item_id1 in number default hr_api.g_number
856: ,p_information_param_item_id2 in number default hr_api.g_number
857: ,p_information_param_item_id3 in number default hr_api.g_number
858: ,p_information_param_item_id4 in number default hr_api.g_number
859: ,p_information_param_item_id5 in number default hr_api.g_number
860: ,p_information_prompt in varchar2 default hr_api.g_varchar2

Line 857: ,p_information_param_item_id3 in number default hr_api.g_number

853: ,p_height in number default hr_api.g_number
854: ,p_information_formula_id in number default hr_api.g_number
855: ,p_information_param_item_id1 in number default hr_api.g_number
856: ,p_information_param_item_id2 in number default hr_api.g_number
857: ,p_information_param_item_id3 in number default hr_api.g_number
858: ,p_information_param_item_id4 in number default hr_api.g_number
859: ,p_information_param_item_id5 in number default hr_api.g_number
860: ,p_information_prompt in varchar2 default hr_api.g_varchar2
861: ,p_insert_allowed in number default hr_api.g_number

Line 858: ,p_information_param_item_id4 in number default hr_api.g_number

854: ,p_information_formula_id in number default hr_api.g_number
855: ,p_information_param_item_id1 in number default hr_api.g_number
856: ,p_information_param_item_id2 in number default hr_api.g_number
857: ,p_information_param_item_id3 in number default hr_api.g_number
858: ,p_information_param_item_id4 in number default hr_api.g_number
859: ,p_information_param_item_id5 in number default hr_api.g_number
860: ,p_information_prompt in varchar2 default hr_api.g_varchar2
861: ,p_insert_allowed in number default hr_api.g_number
862: ,p_label in varchar2 default hr_api.g_varchar2

Line 859: ,p_information_param_item_id5 in number default hr_api.g_number

855: ,p_information_param_item_id1 in number default hr_api.g_number
856: ,p_information_param_item_id2 in number default hr_api.g_number
857: ,p_information_param_item_id3 in number default hr_api.g_number
858: ,p_information_param_item_id4 in number default hr_api.g_number
859: ,p_information_param_item_id5 in number default hr_api.g_number
860: ,p_information_prompt in varchar2 default hr_api.g_varchar2
861: ,p_insert_allowed in number default hr_api.g_number
862: ,p_label in varchar2 default hr_api.g_varchar2
863: ,p_prompt_text in varchar2 default hr_api.g_varchar2

Line 860: ,p_information_prompt in varchar2 default hr_api.g_varchar2

856: ,p_information_param_item_id2 in number default hr_api.g_number
857: ,p_information_param_item_id3 in number default hr_api.g_number
858: ,p_information_param_item_id4 in number default hr_api.g_number
859: ,p_information_param_item_id5 in number default hr_api.g_number
860: ,p_information_prompt in varchar2 default hr_api.g_varchar2
861: ,p_insert_allowed in number default hr_api.g_number
862: ,p_label in varchar2 default hr_api.g_varchar2
863: ,p_prompt_text in varchar2 default hr_api.g_varchar2
864: ,p_prompt_alignment_offset in number default hr_api.g_number

Line 861: ,p_insert_allowed in number default hr_api.g_number

857: ,p_information_param_item_id3 in number default hr_api.g_number
858: ,p_information_param_item_id4 in number default hr_api.g_number
859: ,p_information_param_item_id5 in number default hr_api.g_number
860: ,p_information_prompt in varchar2 default hr_api.g_varchar2
861: ,p_insert_allowed in number default hr_api.g_number
862: ,p_label in varchar2 default hr_api.g_varchar2
863: ,p_prompt_text in varchar2 default hr_api.g_varchar2
864: ,p_prompt_alignment_offset in number default hr_api.g_number
865: ,p_prompt_display_style in number default hr_api.g_number

Line 862: ,p_label in varchar2 default hr_api.g_varchar2

858: ,p_information_param_item_id4 in number default hr_api.g_number
859: ,p_information_param_item_id5 in number default hr_api.g_number
860: ,p_information_prompt in varchar2 default hr_api.g_varchar2
861: ,p_insert_allowed in number default hr_api.g_number
862: ,p_label in varchar2 default hr_api.g_varchar2
863: ,p_prompt_text in varchar2 default hr_api.g_varchar2
864: ,p_prompt_alignment_offset in number default hr_api.g_number
865: ,p_prompt_display_style in number default hr_api.g_number
866: ,p_prompt_edge in number default hr_api.g_number

Line 863: ,p_prompt_text in varchar2 default hr_api.g_varchar2

859: ,p_information_param_item_id5 in number default hr_api.g_number
860: ,p_information_prompt in varchar2 default hr_api.g_varchar2
861: ,p_insert_allowed in number default hr_api.g_number
862: ,p_label in varchar2 default hr_api.g_varchar2
863: ,p_prompt_text in varchar2 default hr_api.g_varchar2
864: ,p_prompt_alignment_offset in number default hr_api.g_number
865: ,p_prompt_display_style in number default hr_api.g_number
866: ,p_prompt_edge in number default hr_api.g_number
867: ,p_prompt_edge_alignment in number default hr_api.g_number

Line 864: ,p_prompt_alignment_offset in number default hr_api.g_number

860: ,p_information_prompt in varchar2 default hr_api.g_varchar2
861: ,p_insert_allowed in number default hr_api.g_number
862: ,p_label in varchar2 default hr_api.g_varchar2
863: ,p_prompt_text in varchar2 default hr_api.g_varchar2
864: ,p_prompt_alignment_offset in number default hr_api.g_number
865: ,p_prompt_display_style in number default hr_api.g_number
866: ,p_prompt_edge in number default hr_api.g_number
867: ,p_prompt_edge_alignment in number default hr_api.g_number
868: ,p_prompt_edge_offset in number default hr_api.g_number

Line 865: ,p_prompt_display_style in number default hr_api.g_number

861: ,p_insert_allowed in number default hr_api.g_number
862: ,p_label in varchar2 default hr_api.g_varchar2
863: ,p_prompt_text in varchar2 default hr_api.g_varchar2
864: ,p_prompt_alignment_offset in number default hr_api.g_number
865: ,p_prompt_display_style in number default hr_api.g_number
866: ,p_prompt_edge in number default hr_api.g_number
867: ,p_prompt_edge_alignment in number default hr_api.g_number
868: ,p_prompt_edge_offset in number default hr_api.g_number
869: ,p_prompt_text_alignment in number default hr_api.g_number

Line 866: ,p_prompt_edge in number default hr_api.g_number

862: ,p_label in varchar2 default hr_api.g_varchar2
863: ,p_prompt_text in varchar2 default hr_api.g_varchar2
864: ,p_prompt_alignment_offset in number default hr_api.g_number
865: ,p_prompt_display_style in number default hr_api.g_number
866: ,p_prompt_edge in number default hr_api.g_number
867: ,p_prompt_edge_alignment in number default hr_api.g_number
868: ,p_prompt_edge_offset in number default hr_api.g_number
869: ,p_prompt_text_alignment in number default hr_api.g_number
870: ,p_query_allowed in number default hr_api.g_number

Line 867: ,p_prompt_edge_alignment in number default hr_api.g_number

863: ,p_prompt_text in varchar2 default hr_api.g_varchar2
864: ,p_prompt_alignment_offset in number default hr_api.g_number
865: ,p_prompt_display_style in number default hr_api.g_number
866: ,p_prompt_edge in number default hr_api.g_number
867: ,p_prompt_edge_alignment in number default hr_api.g_number
868: ,p_prompt_edge_offset in number default hr_api.g_number
869: ,p_prompt_text_alignment in number default hr_api.g_number
870: ,p_query_allowed in number default hr_api.g_number
871: ,p_required in number default hr_api.g_number

Line 868: ,p_prompt_edge_offset in number default hr_api.g_number

864: ,p_prompt_alignment_offset in number default hr_api.g_number
865: ,p_prompt_display_style in number default hr_api.g_number
866: ,p_prompt_edge in number default hr_api.g_number
867: ,p_prompt_edge_alignment in number default hr_api.g_number
868: ,p_prompt_edge_offset in number default hr_api.g_number
869: ,p_prompt_text_alignment in number default hr_api.g_number
870: ,p_query_allowed in number default hr_api.g_number
871: ,p_required in number default hr_api.g_number
872: ,p_tooltip_text in varchar2 default hr_api.g_varchar2

Line 869: ,p_prompt_text_alignment in number default hr_api.g_number

865: ,p_prompt_display_style in number default hr_api.g_number
866: ,p_prompt_edge in number default hr_api.g_number
867: ,p_prompt_edge_alignment in number default hr_api.g_number
868: ,p_prompt_edge_offset in number default hr_api.g_number
869: ,p_prompt_text_alignment in number default hr_api.g_number
870: ,p_query_allowed in number default hr_api.g_number
871: ,p_required in number default hr_api.g_number
872: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
873: ,p_update_allowed in number default hr_api.g_number

Line 870: ,p_query_allowed in number default hr_api.g_number

866: ,p_prompt_edge in number default hr_api.g_number
867: ,p_prompt_edge_alignment in number default hr_api.g_number
868: ,p_prompt_edge_offset in number default hr_api.g_number
869: ,p_prompt_text_alignment in number default hr_api.g_number
870: ,p_query_allowed in number default hr_api.g_number
871: ,p_required in number default hr_api.g_number
872: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
873: ,p_update_allowed in number default hr_api.g_number
874: ,p_validation_formula_id in number default hr_api.g_number

Line 871: ,p_required in number default hr_api.g_number

867: ,p_prompt_edge_alignment in number default hr_api.g_number
868: ,p_prompt_edge_offset in number default hr_api.g_number
869: ,p_prompt_text_alignment in number default hr_api.g_number
870: ,p_query_allowed in number default hr_api.g_number
871: ,p_required in number default hr_api.g_number
872: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
873: ,p_update_allowed in number default hr_api.g_number
874: ,p_validation_formula_id in number default hr_api.g_number
875: ,p_validation_param_item_id1 in number default hr_api.g_number

Line 872: ,p_tooltip_text in varchar2 default hr_api.g_varchar2

868: ,p_prompt_edge_offset in number default hr_api.g_number
869: ,p_prompt_text_alignment in number default hr_api.g_number
870: ,p_query_allowed in number default hr_api.g_number
871: ,p_required in number default hr_api.g_number
872: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
873: ,p_update_allowed in number default hr_api.g_number
874: ,p_validation_formula_id in number default hr_api.g_number
875: ,p_validation_param_item_id1 in number default hr_api.g_number
876: ,p_validation_param_item_id2 in number default hr_api.g_number

Line 873: ,p_update_allowed in number default hr_api.g_number

869: ,p_prompt_text_alignment in number default hr_api.g_number
870: ,p_query_allowed in number default hr_api.g_number
871: ,p_required in number default hr_api.g_number
872: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
873: ,p_update_allowed in number default hr_api.g_number
874: ,p_validation_formula_id in number default hr_api.g_number
875: ,p_validation_param_item_id1 in number default hr_api.g_number
876: ,p_validation_param_item_id2 in number default hr_api.g_number
877: ,p_validation_param_item_id3 in number default hr_api.g_number

Line 874: ,p_validation_formula_id in number default hr_api.g_number

870: ,p_query_allowed in number default hr_api.g_number
871: ,p_required in number default hr_api.g_number
872: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
873: ,p_update_allowed in number default hr_api.g_number
874: ,p_validation_formula_id in number default hr_api.g_number
875: ,p_validation_param_item_id1 in number default hr_api.g_number
876: ,p_validation_param_item_id2 in number default hr_api.g_number
877: ,p_validation_param_item_id3 in number default hr_api.g_number
878: ,p_validation_param_item_id4 in number default hr_api.g_number

Line 875: ,p_validation_param_item_id1 in number default hr_api.g_number

871: ,p_required in number default hr_api.g_number
872: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
873: ,p_update_allowed in number default hr_api.g_number
874: ,p_validation_formula_id in number default hr_api.g_number
875: ,p_validation_param_item_id1 in number default hr_api.g_number
876: ,p_validation_param_item_id2 in number default hr_api.g_number
877: ,p_validation_param_item_id3 in number default hr_api.g_number
878: ,p_validation_param_item_id4 in number default hr_api.g_number
879: ,p_validation_param_item_id5 in number default hr_api.g_number

Line 876: ,p_validation_param_item_id2 in number default hr_api.g_number

872: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
873: ,p_update_allowed in number default hr_api.g_number
874: ,p_validation_formula_id in number default hr_api.g_number
875: ,p_validation_param_item_id1 in number default hr_api.g_number
876: ,p_validation_param_item_id2 in number default hr_api.g_number
877: ,p_validation_param_item_id3 in number default hr_api.g_number
878: ,p_validation_param_item_id4 in number default hr_api.g_number
879: ,p_validation_param_item_id5 in number default hr_api.g_number
880: ,p_visible in number default hr_api.g_number

Line 877: ,p_validation_param_item_id3 in number default hr_api.g_number

873: ,p_update_allowed in number default hr_api.g_number
874: ,p_validation_formula_id in number default hr_api.g_number
875: ,p_validation_param_item_id1 in number default hr_api.g_number
876: ,p_validation_param_item_id2 in number default hr_api.g_number
877: ,p_validation_param_item_id3 in number default hr_api.g_number
878: ,p_validation_param_item_id4 in number default hr_api.g_number
879: ,p_validation_param_item_id5 in number default hr_api.g_number
880: ,p_visible in number default hr_api.g_number
881: ,p_width in number default hr_api.g_number

Line 878: ,p_validation_param_item_id4 in number default hr_api.g_number

874: ,p_validation_formula_id in number default hr_api.g_number
875: ,p_validation_param_item_id1 in number default hr_api.g_number
876: ,p_validation_param_item_id2 in number default hr_api.g_number
877: ,p_validation_param_item_id3 in number default hr_api.g_number
878: ,p_validation_param_item_id4 in number default hr_api.g_number
879: ,p_validation_param_item_id5 in number default hr_api.g_number
880: ,p_visible in number default hr_api.g_number
881: ,p_width in number default hr_api.g_number
882: ,p_x_position in number default hr_api.g_number

Line 879: ,p_validation_param_item_id5 in number default hr_api.g_number

875: ,p_validation_param_item_id1 in number default hr_api.g_number
876: ,p_validation_param_item_id2 in number default hr_api.g_number
877: ,p_validation_param_item_id3 in number default hr_api.g_number
878: ,p_validation_param_item_id4 in number default hr_api.g_number
879: ,p_validation_param_item_id5 in number default hr_api.g_number
880: ,p_visible in number default hr_api.g_number
881: ,p_width in number default hr_api.g_number
882: ,p_x_position in number default hr_api.g_number
883: ,p_y_position in number default hr_api.g_number

Line 880: ,p_visible in number default hr_api.g_number

876: ,p_validation_param_item_id2 in number default hr_api.g_number
877: ,p_validation_param_item_id3 in number default hr_api.g_number
878: ,p_validation_param_item_id4 in number default hr_api.g_number
879: ,p_validation_param_item_id5 in number default hr_api.g_number
880: ,p_visible in number default hr_api.g_number
881: ,p_width in number default hr_api.g_number
882: ,p_x_position in number default hr_api.g_number
883: ,p_y_position in number default hr_api.g_number
884: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 881: ,p_width in number default hr_api.g_number

877: ,p_validation_param_item_id3 in number default hr_api.g_number
878: ,p_validation_param_item_id4 in number default hr_api.g_number
879: ,p_validation_param_item_id5 in number default hr_api.g_number
880: ,p_visible in number default hr_api.g_number
881: ,p_width in number default hr_api.g_number
882: ,p_x_position in number default hr_api.g_number
883: ,p_y_position in number default hr_api.g_number
884: ,p_information_category in varchar2 default hr_api.g_varchar2
885: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 882: ,p_x_position in number default hr_api.g_number

878: ,p_validation_param_item_id4 in number default hr_api.g_number
879: ,p_validation_param_item_id5 in number default hr_api.g_number
880: ,p_visible in number default hr_api.g_number
881: ,p_width in number default hr_api.g_number
882: ,p_x_position in number default hr_api.g_number
883: ,p_y_position in number default hr_api.g_number
884: ,p_information_category in varchar2 default hr_api.g_varchar2
885: ,p_information1 in varchar2 default hr_api.g_varchar2
886: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 883: ,p_y_position in number default hr_api.g_number

879: ,p_validation_param_item_id5 in number default hr_api.g_number
880: ,p_visible in number default hr_api.g_number
881: ,p_width in number default hr_api.g_number
882: ,p_x_position in number default hr_api.g_number
883: ,p_y_position in number default hr_api.g_number
884: ,p_information_category in varchar2 default hr_api.g_varchar2
885: ,p_information1 in varchar2 default hr_api.g_varchar2
886: ,p_information2 in varchar2 default hr_api.g_varchar2
887: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 884: ,p_information_category in varchar2 default hr_api.g_varchar2

880: ,p_visible in number default hr_api.g_number
881: ,p_width in number default hr_api.g_number
882: ,p_x_position in number default hr_api.g_number
883: ,p_y_position in number default hr_api.g_number
884: ,p_information_category in varchar2 default hr_api.g_varchar2
885: ,p_information1 in varchar2 default hr_api.g_varchar2
886: ,p_information2 in varchar2 default hr_api.g_varchar2
887: ,p_information3 in varchar2 default hr_api.g_varchar2
888: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 885: ,p_information1 in varchar2 default hr_api.g_varchar2

881: ,p_width in number default hr_api.g_number
882: ,p_x_position in number default hr_api.g_number
883: ,p_y_position in number default hr_api.g_number
884: ,p_information_category in varchar2 default hr_api.g_varchar2
885: ,p_information1 in varchar2 default hr_api.g_varchar2
886: ,p_information2 in varchar2 default hr_api.g_varchar2
887: ,p_information3 in varchar2 default hr_api.g_varchar2
888: ,p_information4 in varchar2 default hr_api.g_varchar2
889: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 886: ,p_information2 in varchar2 default hr_api.g_varchar2

882: ,p_x_position in number default hr_api.g_number
883: ,p_y_position in number default hr_api.g_number
884: ,p_information_category in varchar2 default hr_api.g_varchar2
885: ,p_information1 in varchar2 default hr_api.g_varchar2
886: ,p_information2 in varchar2 default hr_api.g_varchar2
887: ,p_information3 in varchar2 default hr_api.g_varchar2
888: ,p_information4 in varchar2 default hr_api.g_varchar2
889: ,p_information5 in varchar2 default hr_api.g_varchar2
890: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 887: ,p_information3 in varchar2 default hr_api.g_varchar2

883: ,p_y_position in number default hr_api.g_number
884: ,p_information_category in varchar2 default hr_api.g_varchar2
885: ,p_information1 in varchar2 default hr_api.g_varchar2
886: ,p_information2 in varchar2 default hr_api.g_varchar2
887: ,p_information3 in varchar2 default hr_api.g_varchar2
888: ,p_information4 in varchar2 default hr_api.g_varchar2
889: ,p_information5 in varchar2 default hr_api.g_varchar2
890: ,p_information6 in varchar2 default hr_api.g_varchar2
891: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 888: ,p_information4 in varchar2 default hr_api.g_varchar2

884: ,p_information_category in varchar2 default hr_api.g_varchar2
885: ,p_information1 in varchar2 default hr_api.g_varchar2
886: ,p_information2 in varchar2 default hr_api.g_varchar2
887: ,p_information3 in varchar2 default hr_api.g_varchar2
888: ,p_information4 in varchar2 default hr_api.g_varchar2
889: ,p_information5 in varchar2 default hr_api.g_varchar2
890: ,p_information6 in varchar2 default hr_api.g_varchar2
891: ,p_information7 in varchar2 default hr_api.g_varchar2
892: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 889: ,p_information5 in varchar2 default hr_api.g_varchar2

885: ,p_information1 in varchar2 default hr_api.g_varchar2
886: ,p_information2 in varchar2 default hr_api.g_varchar2
887: ,p_information3 in varchar2 default hr_api.g_varchar2
888: ,p_information4 in varchar2 default hr_api.g_varchar2
889: ,p_information5 in varchar2 default hr_api.g_varchar2
890: ,p_information6 in varchar2 default hr_api.g_varchar2
891: ,p_information7 in varchar2 default hr_api.g_varchar2
892: ,p_information8 in varchar2 default hr_api.g_varchar2
893: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 890: ,p_information6 in varchar2 default hr_api.g_varchar2

886: ,p_information2 in varchar2 default hr_api.g_varchar2
887: ,p_information3 in varchar2 default hr_api.g_varchar2
888: ,p_information4 in varchar2 default hr_api.g_varchar2
889: ,p_information5 in varchar2 default hr_api.g_varchar2
890: ,p_information6 in varchar2 default hr_api.g_varchar2
891: ,p_information7 in varchar2 default hr_api.g_varchar2
892: ,p_information8 in varchar2 default hr_api.g_varchar2
893: ,p_information9 in varchar2 default hr_api.g_varchar2
894: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 891: ,p_information7 in varchar2 default hr_api.g_varchar2

887: ,p_information3 in varchar2 default hr_api.g_varchar2
888: ,p_information4 in varchar2 default hr_api.g_varchar2
889: ,p_information5 in varchar2 default hr_api.g_varchar2
890: ,p_information6 in varchar2 default hr_api.g_varchar2
891: ,p_information7 in varchar2 default hr_api.g_varchar2
892: ,p_information8 in varchar2 default hr_api.g_varchar2
893: ,p_information9 in varchar2 default hr_api.g_varchar2
894: ,p_information10 in varchar2 default hr_api.g_varchar2
895: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 892: ,p_information8 in varchar2 default hr_api.g_varchar2

888: ,p_information4 in varchar2 default hr_api.g_varchar2
889: ,p_information5 in varchar2 default hr_api.g_varchar2
890: ,p_information6 in varchar2 default hr_api.g_varchar2
891: ,p_information7 in varchar2 default hr_api.g_varchar2
892: ,p_information8 in varchar2 default hr_api.g_varchar2
893: ,p_information9 in varchar2 default hr_api.g_varchar2
894: ,p_information10 in varchar2 default hr_api.g_varchar2
895: ,p_information11 in varchar2 default hr_api.g_varchar2
896: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 893: ,p_information9 in varchar2 default hr_api.g_varchar2

889: ,p_information5 in varchar2 default hr_api.g_varchar2
890: ,p_information6 in varchar2 default hr_api.g_varchar2
891: ,p_information7 in varchar2 default hr_api.g_varchar2
892: ,p_information8 in varchar2 default hr_api.g_varchar2
893: ,p_information9 in varchar2 default hr_api.g_varchar2
894: ,p_information10 in varchar2 default hr_api.g_varchar2
895: ,p_information11 in varchar2 default hr_api.g_varchar2
896: ,p_information12 in varchar2 default hr_api.g_varchar2
897: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 894: ,p_information10 in varchar2 default hr_api.g_varchar2

890: ,p_information6 in varchar2 default hr_api.g_varchar2
891: ,p_information7 in varchar2 default hr_api.g_varchar2
892: ,p_information8 in varchar2 default hr_api.g_varchar2
893: ,p_information9 in varchar2 default hr_api.g_varchar2
894: ,p_information10 in varchar2 default hr_api.g_varchar2
895: ,p_information11 in varchar2 default hr_api.g_varchar2
896: ,p_information12 in varchar2 default hr_api.g_varchar2
897: ,p_information13 in varchar2 default hr_api.g_varchar2
898: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 895: ,p_information11 in varchar2 default hr_api.g_varchar2

891: ,p_information7 in varchar2 default hr_api.g_varchar2
892: ,p_information8 in varchar2 default hr_api.g_varchar2
893: ,p_information9 in varchar2 default hr_api.g_varchar2
894: ,p_information10 in varchar2 default hr_api.g_varchar2
895: ,p_information11 in varchar2 default hr_api.g_varchar2
896: ,p_information12 in varchar2 default hr_api.g_varchar2
897: ,p_information13 in varchar2 default hr_api.g_varchar2
898: ,p_information14 in varchar2 default hr_api.g_varchar2
899: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 896: ,p_information12 in varchar2 default hr_api.g_varchar2

892: ,p_information8 in varchar2 default hr_api.g_varchar2
893: ,p_information9 in varchar2 default hr_api.g_varchar2
894: ,p_information10 in varchar2 default hr_api.g_varchar2
895: ,p_information11 in varchar2 default hr_api.g_varchar2
896: ,p_information12 in varchar2 default hr_api.g_varchar2
897: ,p_information13 in varchar2 default hr_api.g_varchar2
898: ,p_information14 in varchar2 default hr_api.g_varchar2
899: ,p_information15 in varchar2 default hr_api.g_varchar2
900: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 897: ,p_information13 in varchar2 default hr_api.g_varchar2

893: ,p_information9 in varchar2 default hr_api.g_varchar2
894: ,p_information10 in varchar2 default hr_api.g_varchar2
895: ,p_information11 in varchar2 default hr_api.g_varchar2
896: ,p_information12 in varchar2 default hr_api.g_varchar2
897: ,p_information13 in varchar2 default hr_api.g_varchar2
898: ,p_information14 in varchar2 default hr_api.g_varchar2
899: ,p_information15 in varchar2 default hr_api.g_varchar2
900: ,p_information16 in varchar2 default hr_api.g_varchar2
901: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 898: ,p_information14 in varchar2 default hr_api.g_varchar2

894: ,p_information10 in varchar2 default hr_api.g_varchar2
895: ,p_information11 in varchar2 default hr_api.g_varchar2
896: ,p_information12 in varchar2 default hr_api.g_varchar2
897: ,p_information13 in varchar2 default hr_api.g_varchar2
898: ,p_information14 in varchar2 default hr_api.g_varchar2
899: ,p_information15 in varchar2 default hr_api.g_varchar2
900: ,p_information16 in varchar2 default hr_api.g_varchar2
901: ,p_information17 in varchar2 default hr_api.g_varchar2
902: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 899: ,p_information15 in varchar2 default hr_api.g_varchar2

895: ,p_information11 in varchar2 default hr_api.g_varchar2
896: ,p_information12 in varchar2 default hr_api.g_varchar2
897: ,p_information13 in varchar2 default hr_api.g_varchar2
898: ,p_information14 in varchar2 default hr_api.g_varchar2
899: ,p_information15 in varchar2 default hr_api.g_varchar2
900: ,p_information16 in varchar2 default hr_api.g_varchar2
901: ,p_information17 in varchar2 default hr_api.g_varchar2
902: ,p_information18 in varchar2 default hr_api.g_varchar2
903: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 900: ,p_information16 in varchar2 default hr_api.g_varchar2

896: ,p_information12 in varchar2 default hr_api.g_varchar2
897: ,p_information13 in varchar2 default hr_api.g_varchar2
898: ,p_information14 in varchar2 default hr_api.g_varchar2
899: ,p_information15 in varchar2 default hr_api.g_varchar2
900: ,p_information16 in varchar2 default hr_api.g_varchar2
901: ,p_information17 in varchar2 default hr_api.g_varchar2
902: ,p_information18 in varchar2 default hr_api.g_varchar2
903: ,p_information19 in varchar2 default hr_api.g_varchar2
904: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 901: ,p_information17 in varchar2 default hr_api.g_varchar2

897: ,p_information13 in varchar2 default hr_api.g_varchar2
898: ,p_information14 in varchar2 default hr_api.g_varchar2
899: ,p_information15 in varchar2 default hr_api.g_varchar2
900: ,p_information16 in varchar2 default hr_api.g_varchar2
901: ,p_information17 in varchar2 default hr_api.g_varchar2
902: ,p_information18 in varchar2 default hr_api.g_varchar2
903: ,p_information19 in varchar2 default hr_api.g_varchar2
904: ,p_information20 in varchar2 default hr_api.g_varchar2
905: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 902: ,p_information18 in varchar2 default hr_api.g_varchar2

898: ,p_information14 in varchar2 default hr_api.g_varchar2
899: ,p_information15 in varchar2 default hr_api.g_varchar2
900: ,p_information16 in varchar2 default hr_api.g_varchar2
901: ,p_information17 in varchar2 default hr_api.g_varchar2
902: ,p_information18 in varchar2 default hr_api.g_varchar2
903: ,p_information19 in varchar2 default hr_api.g_varchar2
904: ,p_information20 in varchar2 default hr_api.g_varchar2
905: ,p_information21 in varchar2 default hr_api.g_varchar2
906: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 903: ,p_information19 in varchar2 default hr_api.g_varchar2

899: ,p_information15 in varchar2 default hr_api.g_varchar2
900: ,p_information16 in varchar2 default hr_api.g_varchar2
901: ,p_information17 in varchar2 default hr_api.g_varchar2
902: ,p_information18 in varchar2 default hr_api.g_varchar2
903: ,p_information19 in varchar2 default hr_api.g_varchar2
904: ,p_information20 in varchar2 default hr_api.g_varchar2
905: ,p_information21 in varchar2 default hr_api.g_varchar2
906: ,p_information22 in varchar2 default hr_api.g_varchar2
907: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 904: ,p_information20 in varchar2 default hr_api.g_varchar2

900: ,p_information16 in varchar2 default hr_api.g_varchar2
901: ,p_information17 in varchar2 default hr_api.g_varchar2
902: ,p_information18 in varchar2 default hr_api.g_varchar2
903: ,p_information19 in varchar2 default hr_api.g_varchar2
904: ,p_information20 in varchar2 default hr_api.g_varchar2
905: ,p_information21 in varchar2 default hr_api.g_varchar2
906: ,p_information22 in varchar2 default hr_api.g_varchar2
907: ,p_information23 in varchar2 default hr_api.g_varchar2
908: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 905: ,p_information21 in varchar2 default hr_api.g_varchar2

901: ,p_information17 in varchar2 default hr_api.g_varchar2
902: ,p_information18 in varchar2 default hr_api.g_varchar2
903: ,p_information19 in varchar2 default hr_api.g_varchar2
904: ,p_information20 in varchar2 default hr_api.g_varchar2
905: ,p_information21 in varchar2 default hr_api.g_varchar2
906: ,p_information22 in varchar2 default hr_api.g_varchar2
907: ,p_information23 in varchar2 default hr_api.g_varchar2
908: ,p_information24 in varchar2 default hr_api.g_varchar2
909: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 906: ,p_information22 in varchar2 default hr_api.g_varchar2

902: ,p_information18 in varchar2 default hr_api.g_varchar2
903: ,p_information19 in varchar2 default hr_api.g_varchar2
904: ,p_information20 in varchar2 default hr_api.g_varchar2
905: ,p_information21 in varchar2 default hr_api.g_varchar2
906: ,p_information22 in varchar2 default hr_api.g_varchar2
907: ,p_information23 in varchar2 default hr_api.g_varchar2
908: ,p_information24 in varchar2 default hr_api.g_varchar2
909: ,p_information25 in varchar2 default hr_api.g_varchar2
910: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 907: ,p_information23 in varchar2 default hr_api.g_varchar2

903: ,p_information19 in varchar2 default hr_api.g_varchar2
904: ,p_information20 in varchar2 default hr_api.g_varchar2
905: ,p_information21 in varchar2 default hr_api.g_varchar2
906: ,p_information22 in varchar2 default hr_api.g_varchar2
907: ,p_information23 in varchar2 default hr_api.g_varchar2
908: ,p_information24 in varchar2 default hr_api.g_varchar2
909: ,p_information25 in varchar2 default hr_api.g_varchar2
910: ,p_information26 in varchar2 default hr_api.g_varchar2
911: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 908: ,p_information24 in varchar2 default hr_api.g_varchar2

904: ,p_information20 in varchar2 default hr_api.g_varchar2
905: ,p_information21 in varchar2 default hr_api.g_varchar2
906: ,p_information22 in varchar2 default hr_api.g_varchar2
907: ,p_information23 in varchar2 default hr_api.g_varchar2
908: ,p_information24 in varchar2 default hr_api.g_varchar2
909: ,p_information25 in varchar2 default hr_api.g_varchar2
910: ,p_information26 in varchar2 default hr_api.g_varchar2
911: ,p_information27 in varchar2 default hr_api.g_varchar2
912: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 909: ,p_information25 in varchar2 default hr_api.g_varchar2

905: ,p_information21 in varchar2 default hr_api.g_varchar2
906: ,p_information22 in varchar2 default hr_api.g_varchar2
907: ,p_information23 in varchar2 default hr_api.g_varchar2
908: ,p_information24 in varchar2 default hr_api.g_varchar2
909: ,p_information25 in varchar2 default hr_api.g_varchar2
910: ,p_information26 in varchar2 default hr_api.g_varchar2
911: ,p_information27 in varchar2 default hr_api.g_varchar2
912: ,p_information28 in varchar2 default hr_api.g_varchar2
913: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 910: ,p_information26 in varchar2 default hr_api.g_varchar2

906: ,p_information22 in varchar2 default hr_api.g_varchar2
907: ,p_information23 in varchar2 default hr_api.g_varchar2
908: ,p_information24 in varchar2 default hr_api.g_varchar2
909: ,p_information25 in varchar2 default hr_api.g_varchar2
910: ,p_information26 in varchar2 default hr_api.g_varchar2
911: ,p_information27 in varchar2 default hr_api.g_varchar2
912: ,p_information28 in varchar2 default hr_api.g_varchar2
913: ,p_information29 in varchar2 default hr_api.g_varchar2
914: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 911: ,p_information27 in varchar2 default hr_api.g_varchar2

907: ,p_information23 in varchar2 default hr_api.g_varchar2
908: ,p_information24 in varchar2 default hr_api.g_varchar2
909: ,p_information25 in varchar2 default hr_api.g_varchar2
910: ,p_information26 in varchar2 default hr_api.g_varchar2
911: ,p_information27 in varchar2 default hr_api.g_varchar2
912: ,p_information28 in varchar2 default hr_api.g_varchar2
913: ,p_information29 in varchar2 default hr_api.g_varchar2
914: ,p_information30 in varchar2 default hr_api.g_varchar2
915: ,p_next_navigation_item_id in number default hr_api.g_number

Line 912: ,p_information28 in varchar2 default hr_api.g_varchar2

908: ,p_information24 in varchar2 default hr_api.g_varchar2
909: ,p_information25 in varchar2 default hr_api.g_varchar2
910: ,p_information26 in varchar2 default hr_api.g_varchar2
911: ,p_information27 in varchar2 default hr_api.g_varchar2
912: ,p_information28 in varchar2 default hr_api.g_varchar2
913: ,p_information29 in varchar2 default hr_api.g_varchar2
914: ,p_information30 in varchar2 default hr_api.g_varchar2
915: ,p_next_navigation_item_id in number default hr_api.g_number
916: ,p_previous_navigation_item_id in number default hr_api.g_number

Line 913: ,p_information29 in varchar2 default hr_api.g_varchar2

909: ,p_information25 in varchar2 default hr_api.g_varchar2
910: ,p_information26 in varchar2 default hr_api.g_varchar2
911: ,p_information27 in varchar2 default hr_api.g_varchar2
912: ,p_information28 in varchar2 default hr_api.g_varchar2
913: ,p_information29 in varchar2 default hr_api.g_varchar2
914: ,p_information30 in varchar2 default hr_api.g_varchar2
915: ,p_next_navigation_item_id in number default hr_api.g_number
916: ,p_previous_navigation_item_id in number default hr_api.g_number
917: ,p_template_item_id out nocopy number

Line 914: ,p_information30 in varchar2 default hr_api.g_varchar2

910: ,p_information26 in varchar2 default hr_api.g_varchar2
911: ,p_information27 in varchar2 default hr_api.g_varchar2
912: ,p_information28 in varchar2 default hr_api.g_varchar2
913: ,p_information29 in varchar2 default hr_api.g_varchar2
914: ,p_information30 in varchar2 default hr_api.g_varchar2
915: ,p_next_navigation_item_id in number default hr_api.g_number
916: ,p_previous_navigation_item_id in number default hr_api.g_number
917: ,p_template_item_id out nocopy number
918: ,p_object_version_number out nocopy number

Line 915: ,p_next_navigation_item_id in number default hr_api.g_number

911: ,p_information27 in varchar2 default hr_api.g_varchar2
912: ,p_information28 in varchar2 default hr_api.g_varchar2
913: ,p_information29 in varchar2 default hr_api.g_varchar2
914: ,p_information30 in varchar2 default hr_api.g_varchar2
915: ,p_next_navigation_item_id in number default hr_api.g_number
916: ,p_previous_navigation_item_id in number default hr_api.g_number
917: ,p_template_item_id out nocopy number
918: ,p_object_version_number out nocopy number
919: ,p_override_value_warning out nocopy boolean

Line 916: ,p_previous_navigation_item_id in number default hr_api.g_number

912: ,p_information28 in varchar2 default hr_api.g_varchar2
913: ,p_information29 in varchar2 default hr_api.g_varchar2
914: ,p_information30 in varchar2 default hr_api.g_varchar2
915: ,p_next_navigation_item_id in number default hr_api.g_number
916: ,p_previous_navigation_item_id in number default hr_api.g_number
917: ,p_template_item_id out nocopy number
918: ,p_object_version_number out nocopy number
919: ,p_override_value_warning out nocopy boolean
920: ) is

Line 968: hr_api.validate_language_code(p_language_code => l_language_code);

964: -- instead of p_language_code from now on, to allow an IN OUT parameter to
965: -- be passed through.
966: --
967: l_language_code := p_language_code;
968: hr_api.validate_language_code(p_language_code => l_language_code);
969: --
970: --
971: -- Call Before Process User Hook
972: --

Line 1051: when hr_api.cannot_find_prog_unit then

1047: ,p_information30 => p_information30
1048: ,p_next_navigation_item_id => p_next_navigation_item_id
1049: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
1050: exception
1051: when hr_api.cannot_find_prog_unit then
1052: hr_api.cannot_find_prog_unit_error
1053: (p_module_name => 'create_template_item'
1054: ,p_hook_type => 'BP'
1055: );

Line 1052: hr_api.cannot_find_prog_unit_error

1048: ,p_next_navigation_item_id => p_next_navigation_item_id
1049: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
1050: exception
1051: when hr_api.cannot_find_prog_unit then
1052: hr_api.cannot_find_prog_unit_error
1053: (p_module_name => 'create_template_item'
1054: ,p_hook_type => 'BP'
1055: );
1056: end;

Line 1069: IF ( p_required <> hr_api.g_number ) AND

1065: CLOSE cur_override;
1066:
1067: hr_utility.set_location('Entering:'|| l_proc, 20);
1068:
1069: IF ( p_required <> hr_api.g_number ) AND
1070: ( l_required_override is not null AND p_required is not null ) THEN
1071: l_override_value_warning := TRUE;
1072: END IF;
1073:

Line 1076: IF ( p_visible <> hr_api.g_number ) AND

1072: END IF;
1073:
1074: hr_utility.set_location('Entering:'|| l_proc, 25);
1075:
1076: IF ( p_visible <> hr_api.g_number ) AND
1077: ( l_visible_override is not null AND p_visible is not null ) THEN
1078: l_override_value_warning := TRUE;
1079: END IF;
1080:

Line 1285: when hr_api.cannot_find_prog_unit then

1281: ,p_template_item_id => l_template_item_id
1282: ,p_object_version_number => l_object_version_number
1283: ,p_override_value_warning => l_override_value_warning);
1284: exception
1285: when hr_api.cannot_find_prog_unit then
1286: hr_api.cannot_find_prog_unit_error
1287: (p_module_name => 'create_template_item'
1288: ,p_hook_type => 'AP'
1289: );

Line 1286: hr_api.cannot_find_prog_unit_error

1282: ,p_object_version_number => l_object_version_number
1283: ,p_override_value_warning => l_override_value_warning);
1284: exception
1285: when hr_api.cannot_find_prog_unit then
1286: hr_api.cannot_find_prog_unit_error
1287: (p_module_name => 'create_template_item'
1288: ,p_hook_type => 'AP'
1289: );
1290: end;

Line 1297: raise hr_api.validate_enabled;

1293: --
1294: hr_utility.set_location('Entering:'|| l_proc, 55);
1295:
1296: if p_validate then
1297: raise hr_api.validate_enabled;
1298: end if;
1299: --
1300: -- Set all output arguments
1301: --

Line 1308: when hr_api.validate_enabled then

1304: p_override_value_warning := l_override_value_warning;
1305: --
1306: hr_utility.set_location(' Leaving:'||l_proc, 70);
1307: exception
1308: when hr_api.validate_enabled then
1309: --
1310: -- As the Validate_Enabled exception has been raised
1311: -- we must rollback to the savepoint
1312: --

Line 1405: when hr_api.cannot_find_prog_unit then

1401: ,p_object_version_number => p_object_version_number
1402: ,p_delete_children_flag => p_delete_children_flag
1403: );
1404: exception
1405: when hr_api.cannot_find_prog_unit then
1406: hr_api.cannot_find_prog_unit_error
1407: (p_module_name => 'delete_template_item'
1408: ,p_hook_type => 'BP'
1409: );

Line 1406: hr_api.cannot_find_prog_unit_error

1402: ,p_delete_children_flag => p_delete_children_flag
1403: );
1404: exception
1405: when hr_api.cannot_find_prog_unit then
1406: hr_api.cannot_find_prog_unit_error
1407: (p_module_name => 'delete_template_item'
1408: ,p_hook_type => 'BP'
1409: );
1410: end;

Line 1483: when hr_api.cannot_find_prog_unit then

1479: ,p_object_version_number => p_object_version_number
1480: ,p_delete_children_flag => p_delete_children_flag
1481: );
1482: exception
1483: when hr_api.cannot_find_prog_unit then
1484: hr_api.cannot_find_prog_unit_error
1485: (p_module_name => 'delete_template_item'
1486: ,p_hook_type => 'AP'
1487: );

Line 1484: hr_api.cannot_find_prog_unit_error

1480: ,p_delete_children_flag => p_delete_children_flag
1481: );
1482: exception
1483: when hr_api.cannot_find_prog_unit then
1484: hr_api.cannot_find_prog_unit_error
1485: (p_module_name => 'delete_template_item'
1486: ,p_hook_type => 'AP'
1487: );
1488: end;

Line 1495: raise hr_api.validate_enabled;

1491: --
1492: hr_utility.set_location('Entering:'|| l_proc, 50);
1493:
1494: if p_validate then
1495: raise hr_api.validate_enabled;
1496: end if;
1497: --
1498: hr_utility.set_location(' Leaving:'||l_proc, 70);
1499: exception

Line 1500: when hr_api.validate_enabled then

1496: end if;
1497: --
1498: hr_utility.set_location(' Leaving:'||l_proc, 70);
1499: exception
1500: when hr_api.validate_enabled then
1501: --
1502: -- As the Validate_Enabled exception has been raised
1503: -- we must rollback to the savepoint
1504: --

Line 1528: ,p_language_code in varchar2 default hr_api.userenv_lang

1524: --
1525: procedure update_template_item
1526: (p_validate in boolean default false
1527: ,p_effective_date in date
1528: ,p_language_code in varchar2 default hr_api.userenv_lang
1529: ,p_template_item_id in number
1530: ,p_object_version_number in out nocopy number
1531: ,p_upd_template_item_contexts in boolean default false
1532: ,p_alignment in number default hr_api.g_number

Line 1532: ,p_alignment in number default hr_api.g_number

1528: ,p_language_code in varchar2 default hr_api.userenv_lang
1529: ,p_template_item_id in number
1530: ,p_object_version_number in out nocopy number
1531: ,p_upd_template_item_contexts in boolean default false
1532: ,p_alignment in number default hr_api.g_number
1533: ,p_bevel in number default hr_api.g_number
1534: ,p_case_restriction in number default hr_api.g_number
1535: ,p_default_value in varchar2 default hr_api.g_varchar2
1536: ,p_enabled in number default hr_api.g_number

Line 1533: ,p_bevel in number default hr_api.g_number

1529: ,p_template_item_id in number
1530: ,p_object_version_number in out nocopy number
1531: ,p_upd_template_item_contexts in boolean default false
1532: ,p_alignment in number default hr_api.g_number
1533: ,p_bevel in number default hr_api.g_number
1534: ,p_case_restriction in number default hr_api.g_number
1535: ,p_default_value in varchar2 default hr_api.g_varchar2
1536: ,p_enabled in number default hr_api.g_number
1537: ,p_format_mask in varchar2 default hr_api.g_varchar2

Line 1534: ,p_case_restriction in number default hr_api.g_number

1530: ,p_object_version_number in out nocopy number
1531: ,p_upd_template_item_contexts in boolean default false
1532: ,p_alignment in number default hr_api.g_number
1533: ,p_bevel in number default hr_api.g_number
1534: ,p_case_restriction in number default hr_api.g_number
1535: ,p_default_value in varchar2 default hr_api.g_varchar2
1536: ,p_enabled in number default hr_api.g_number
1537: ,p_format_mask in varchar2 default hr_api.g_varchar2
1538: ,p_height in number default hr_api.g_number

Line 1535: ,p_default_value in varchar2 default hr_api.g_varchar2

1531: ,p_upd_template_item_contexts in boolean default false
1532: ,p_alignment in number default hr_api.g_number
1533: ,p_bevel in number default hr_api.g_number
1534: ,p_case_restriction in number default hr_api.g_number
1535: ,p_default_value in varchar2 default hr_api.g_varchar2
1536: ,p_enabled in number default hr_api.g_number
1537: ,p_format_mask in varchar2 default hr_api.g_varchar2
1538: ,p_height in number default hr_api.g_number
1539: ,p_information_formula_id in number default hr_api.g_number

Line 1536: ,p_enabled in number default hr_api.g_number

1532: ,p_alignment in number default hr_api.g_number
1533: ,p_bevel in number default hr_api.g_number
1534: ,p_case_restriction in number default hr_api.g_number
1535: ,p_default_value in varchar2 default hr_api.g_varchar2
1536: ,p_enabled in number default hr_api.g_number
1537: ,p_format_mask in varchar2 default hr_api.g_varchar2
1538: ,p_height in number default hr_api.g_number
1539: ,p_information_formula_id in number default hr_api.g_number
1540: ,p_information_param_item_id1 in number default hr_api.g_number

Line 1537: ,p_format_mask in varchar2 default hr_api.g_varchar2

1533: ,p_bevel in number default hr_api.g_number
1534: ,p_case_restriction in number default hr_api.g_number
1535: ,p_default_value in varchar2 default hr_api.g_varchar2
1536: ,p_enabled in number default hr_api.g_number
1537: ,p_format_mask in varchar2 default hr_api.g_varchar2
1538: ,p_height in number default hr_api.g_number
1539: ,p_information_formula_id in number default hr_api.g_number
1540: ,p_information_param_item_id1 in number default hr_api.g_number
1541: ,p_information_param_item_id2 in number default hr_api.g_number

Line 1538: ,p_height in number default hr_api.g_number

1534: ,p_case_restriction in number default hr_api.g_number
1535: ,p_default_value in varchar2 default hr_api.g_varchar2
1536: ,p_enabled in number default hr_api.g_number
1537: ,p_format_mask in varchar2 default hr_api.g_varchar2
1538: ,p_height in number default hr_api.g_number
1539: ,p_information_formula_id in number default hr_api.g_number
1540: ,p_information_param_item_id1 in number default hr_api.g_number
1541: ,p_information_param_item_id2 in number default hr_api.g_number
1542: ,p_information_param_item_id3 in number default hr_api.g_number

Line 1539: ,p_information_formula_id in number default hr_api.g_number

1535: ,p_default_value in varchar2 default hr_api.g_varchar2
1536: ,p_enabled in number default hr_api.g_number
1537: ,p_format_mask in varchar2 default hr_api.g_varchar2
1538: ,p_height in number default hr_api.g_number
1539: ,p_information_formula_id in number default hr_api.g_number
1540: ,p_information_param_item_id1 in number default hr_api.g_number
1541: ,p_information_param_item_id2 in number default hr_api.g_number
1542: ,p_information_param_item_id3 in number default hr_api.g_number
1543: ,p_information_param_item_id4 in number default hr_api.g_number

Line 1540: ,p_information_param_item_id1 in number default hr_api.g_number

1536: ,p_enabled in number default hr_api.g_number
1537: ,p_format_mask in varchar2 default hr_api.g_varchar2
1538: ,p_height in number default hr_api.g_number
1539: ,p_information_formula_id in number default hr_api.g_number
1540: ,p_information_param_item_id1 in number default hr_api.g_number
1541: ,p_information_param_item_id2 in number default hr_api.g_number
1542: ,p_information_param_item_id3 in number default hr_api.g_number
1543: ,p_information_param_item_id4 in number default hr_api.g_number
1544: ,p_information_param_item_id5 in number default hr_api.g_number

Line 1541: ,p_information_param_item_id2 in number default hr_api.g_number

1537: ,p_format_mask in varchar2 default hr_api.g_varchar2
1538: ,p_height in number default hr_api.g_number
1539: ,p_information_formula_id in number default hr_api.g_number
1540: ,p_information_param_item_id1 in number default hr_api.g_number
1541: ,p_information_param_item_id2 in number default hr_api.g_number
1542: ,p_information_param_item_id3 in number default hr_api.g_number
1543: ,p_information_param_item_id4 in number default hr_api.g_number
1544: ,p_information_param_item_id5 in number default hr_api.g_number
1545: ,p_information_prompt in varchar2 default hr_api.g_varchar2

Line 1542: ,p_information_param_item_id3 in number default hr_api.g_number

1538: ,p_height in number default hr_api.g_number
1539: ,p_information_formula_id in number default hr_api.g_number
1540: ,p_information_param_item_id1 in number default hr_api.g_number
1541: ,p_information_param_item_id2 in number default hr_api.g_number
1542: ,p_information_param_item_id3 in number default hr_api.g_number
1543: ,p_information_param_item_id4 in number default hr_api.g_number
1544: ,p_information_param_item_id5 in number default hr_api.g_number
1545: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1546: ,p_insert_allowed in number default hr_api.g_number

Line 1543: ,p_information_param_item_id4 in number default hr_api.g_number

1539: ,p_information_formula_id in number default hr_api.g_number
1540: ,p_information_param_item_id1 in number default hr_api.g_number
1541: ,p_information_param_item_id2 in number default hr_api.g_number
1542: ,p_information_param_item_id3 in number default hr_api.g_number
1543: ,p_information_param_item_id4 in number default hr_api.g_number
1544: ,p_information_param_item_id5 in number default hr_api.g_number
1545: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1546: ,p_insert_allowed in number default hr_api.g_number
1547: ,p_label in varchar2 default hr_api.g_varchar2

Line 1544: ,p_information_param_item_id5 in number default hr_api.g_number

1540: ,p_information_param_item_id1 in number default hr_api.g_number
1541: ,p_information_param_item_id2 in number default hr_api.g_number
1542: ,p_information_param_item_id3 in number default hr_api.g_number
1543: ,p_information_param_item_id4 in number default hr_api.g_number
1544: ,p_information_param_item_id5 in number default hr_api.g_number
1545: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1546: ,p_insert_allowed in number default hr_api.g_number
1547: ,p_label in varchar2 default hr_api.g_varchar2
1548: ,p_prompt_text in varchar2 default hr_api.g_varchar2

Line 1545: ,p_information_prompt in varchar2 default hr_api.g_varchar2

1541: ,p_information_param_item_id2 in number default hr_api.g_number
1542: ,p_information_param_item_id3 in number default hr_api.g_number
1543: ,p_information_param_item_id4 in number default hr_api.g_number
1544: ,p_information_param_item_id5 in number default hr_api.g_number
1545: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1546: ,p_insert_allowed in number default hr_api.g_number
1547: ,p_label in varchar2 default hr_api.g_varchar2
1548: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1549: ,p_prompt_alignment_offset in number default hr_api.g_number

Line 1546: ,p_insert_allowed in number default hr_api.g_number

1542: ,p_information_param_item_id3 in number default hr_api.g_number
1543: ,p_information_param_item_id4 in number default hr_api.g_number
1544: ,p_information_param_item_id5 in number default hr_api.g_number
1545: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1546: ,p_insert_allowed in number default hr_api.g_number
1547: ,p_label in varchar2 default hr_api.g_varchar2
1548: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1549: ,p_prompt_alignment_offset in number default hr_api.g_number
1550: ,p_prompt_display_style in number default hr_api.g_number

Line 1547: ,p_label in varchar2 default hr_api.g_varchar2

1543: ,p_information_param_item_id4 in number default hr_api.g_number
1544: ,p_information_param_item_id5 in number default hr_api.g_number
1545: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1546: ,p_insert_allowed in number default hr_api.g_number
1547: ,p_label in varchar2 default hr_api.g_varchar2
1548: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1549: ,p_prompt_alignment_offset in number default hr_api.g_number
1550: ,p_prompt_display_style in number default hr_api.g_number
1551: ,p_prompt_edge in number default hr_api.g_number

Line 1548: ,p_prompt_text in varchar2 default hr_api.g_varchar2

1544: ,p_information_param_item_id5 in number default hr_api.g_number
1545: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1546: ,p_insert_allowed in number default hr_api.g_number
1547: ,p_label in varchar2 default hr_api.g_varchar2
1548: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1549: ,p_prompt_alignment_offset in number default hr_api.g_number
1550: ,p_prompt_display_style in number default hr_api.g_number
1551: ,p_prompt_edge in number default hr_api.g_number
1552: ,p_prompt_edge_alignment in number default hr_api.g_number

Line 1549: ,p_prompt_alignment_offset in number default hr_api.g_number

1545: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1546: ,p_insert_allowed in number default hr_api.g_number
1547: ,p_label in varchar2 default hr_api.g_varchar2
1548: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1549: ,p_prompt_alignment_offset in number default hr_api.g_number
1550: ,p_prompt_display_style in number default hr_api.g_number
1551: ,p_prompt_edge in number default hr_api.g_number
1552: ,p_prompt_edge_alignment in number default hr_api.g_number
1553: ,p_prompt_edge_offset in number default hr_api.g_number

Line 1550: ,p_prompt_display_style in number default hr_api.g_number

1546: ,p_insert_allowed in number default hr_api.g_number
1547: ,p_label in varchar2 default hr_api.g_varchar2
1548: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1549: ,p_prompt_alignment_offset in number default hr_api.g_number
1550: ,p_prompt_display_style in number default hr_api.g_number
1551: ,p_prompt_edge in number default hr_api.g_number
1552: ,p_prompt_edge_alignment in number default hr_api.g_number
1553: ,p_prompt_edge_offset in number default hr_api.g_number
1554: ,p_prompt_text_alignment in number default hr_api.g_number

Line 1551: ,p_prompt_edge in number default hr_api.g_number

1547: ,p_label in varchar2 default hr_api.g_varchar2
1548: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1549: ,p_prompt_alignment_offset in number default hr_api.g_number
1550: ,p_prompt_display_style in number default hr_api.g_number
1551: ,p_prompt_edge in number default hr_api.g_number
1552: ,p_prompt_edge_alignment in number default hr_api.g_number
1553: ,p_prompt_edge_offset in number default hr_api.g_number
1554: ,p_prompt_text_alignment in number default hr_api.g_number
1555: ,p_query_allowed in number default hr_api.g_number

Line 1552: ,p_prompt_edge_alignment in number default hr_api.g_number

1548: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1549: ,p_prompt_alignment_offset in number default hr_api.g_number
1550: ,p_prompt_display_style in number default hr_api.g_number
1551: ,p_prompt_edge in number default hr_api.g_number
1552: ,p_prompt_edge_alignment in number default hr_api.g_number
1553: ,p_prompt_edge_offset in number default hr_api.g_number
1554: ,p_prompt_text_alignment in number default hr_api.g_number
1555: ,p_query_allowed in number default hr_api.g_number
1556: ,p_required in number default hr_api.g_number

Line 1553: ,p_prompt_edge_offset in number default hr_api.g_number

1549: ,p_prompt_alignment_offset in number default hr_api.g_number
1550: ,p_prompt_display_style in number default hr_api.g_number
1551: ,p_prompt_edge in number default hr_api.g_number
1552: ,p_prompt_edge_alignment in number default hr_api.g_number
1553: ,p_prompt_edge_offset in number default hr_api.g_number
1554: ,p_prompt_text_alignment in number default hr_api.g_number
1555: ,p_query_allowed in number default hr_api.g_number
1556: ,p_required in number default hr_api.g_number
1557: ,p_tooltip_text in varchar2 default hr_api.g_varchar2

Line 1554: ,p_prompt_text_alignment in number default hr_api.g_number

1550: ,p_prompt_display_style in number default hr_api.g_number
1551: ,p_prompt_edge in number default hr_api.g_number
1552: ,p_prompt_edge_alignment in number default hr_api.g_number
1553: ,p_prompt_edge_offset in number default hr_api.g_number
1554: ,p_prompt_text_alignment in number default hr_api.g_number
1555: ,p_query_allowed in number default hr_api.g_number
1556: ,p_required in number default hr_api.g_number
1557: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1558: ,p_update_allowed in number default hr_api.g_number

Line 1555: ,p_query_allowed in number default hr_api.g_number

1551: ,p_prompt_edge in number default hr_api.g_number
1552: ,p_prompt_edge_alignment in number default hr_api.g_number
1553: ,p_prompt_edge_offset in number default hr_api.g_number
1554: ,p_prompt_text_alignment in number default hr_api.g_number
1555: ,p_query_allowed in number default hr_api.g_number
1556: ,p_required in number default hr_api.g_number
1557: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1558: ,p_update_allowed in number default hr_api.g_number
1559: ,p_validation_formula_id in number default hr_api.g_number

Line 1556: ,p_required in number default hr_api.g_number

1552: ,p_prompt_edge_alignment in number default hr_api.g_number
1553: ,p_prompt_edge_offset in number default hr_api.g_number
1554: ,p_prompt_text_alignment in number default hr_api.g_number
1555: ,p_query_allowed in number default hr_api.g_number
1556: ,p_required in number default hr_api.g_number
1557: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1558: ,p_update_allowed in number default hr_api.g_number
1559: ,p_validation_formula_id in number default hr_api.g_number
1560: ,p_validation_param_item_id1 in number default hr_api.g_number

Line 1557: ,p_tooltip_text in varchar2 default hr_api.g_varchar2

1553: ,p_prompt_edge_offset in number default hr_api.g_number
1554: ,p_prompt_text_alignment in number default hr_api.g_number
1555: ,p_query_allowed in number default hr_api.g_number
1556: ,p_required in number default hr_api.g_number
1557: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1558: ,p_update_allowed in number default hr_api.g_number
1559: ,p_validation_formula_id in number default hr_api.g_number
1560: ,p_validation_param_item_id1 in number default hr_api.g_number
1561: ,p_validation_param_item_id2 in number default hr_api.g_number

Line 1558: ,p_update_allowed in number default hr_api.g_number

1554: ,p_prompt_text_alignment in number default hr_api.g_number
1555: ,p_query_allowed in number default hr_api.g_number
1556: ,p_required in number default hr_api.g_number
1557: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1558: ,p_update_allowed in number default hr_api.g_number
1559: ,p_validation_formula_id in number default hr_api.g_number
1560: ,p_validation_param_item_id1 in number default hr_api.g_number
1561: ,p_validation_param_item_id2 in number default hr_api.g_number
1562: ,p_validation_param_item_id3 in number default hr_api.g_number

Line 1559: ,p_validation_formula_id in number default hr_api.g_number

1555: ,p_query_allowed in number default hr_api.g_number
1556: ,p_required in number default hr_api.g_number
1557: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1558: ,p_update_allowed in number default hr_api.g_number
1559: ,p_validation_formula_id in number default hr_api.g_number
1560: ,p_validation_param_item_id1 in number default hr_api.g_number
1561: ,p_validation_param_item_id2 in number default hr_api.g_number
1562: ,p_validation_param_item_id3 in number default hr_api.g_number
1563: ,p_validation_param_item_id4 in number default hr_api.g_number

Line 1560: ,p_validation_param_item_id1 in number default hr_api.g_number

1556: ,p_required in number default hr_api.g_number
1557: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1558: ,p_update_allowed in number default hr_api.g_number
1559: ,p_validation_formula_id in number default hr_api.g_number
1560: ,p_validation_param_item_id1 in number default hr_api.g_number
1561: ,p_validation_param_item_id2 in number default hr_api.g_number
1562: ,p_validation_param_item_id3 in number default hr_api.g_number
1563: ,p_validation_param_item_id4 in number default hr_api.g_number
1564: ,p_validation_param_item_id5 in number default hr_api.g_number

Line 1561: ,p_validation_param_item_id2 in number default hr_api.g_number

1557: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1558: ,p_update_allowed in number default hr_api.g_number
1559: ,p_validation_formula_id in number default hr_api.g_number
1560: ,p_validation_param_item_id1 in number default hr_api.g_number
1561: ,p_validation_param_item_id2 in number default hr_api.g_number
1562: ,p_validation_param_item_id3 in number default hr_api.g_number
1563: ,p_validation_param_item_id4 in number default hr_api.g_number
1564: ,p_validation_param_item_id5 in number default hr_api.g_number
1565: ,p_visible in number default hr_api.g_number

Line 1562: ,p_validation_param_item_id3 in number default hr_api.g_number

1558: ,p_update_allowed in number default hr_api.g_number
1559: ,p_validation_formula_id in number default hr_api.g_number
1560: ,p_validation_param_item_id1 in number default hr_api.g_number
1561: ,p_validation_param_item_id2 in number default hr_api.g_number
1562: ,p_validation_param_item_id3 in number default hr_api.g_number
1563: ,p_validation_param_item_id4 in number default hr_api.g_number
1564: ,p_validation_param_item_id5 in number default hr_api.g_number
1565: ,p_visible in number default hr_api.g_number
1566: ,p_width in number default hr_api.g_number

Line 1563: ,p_validation_param_item_id4 in number default hr_api.g_number

1559: ,p_validation_formula_id in number default hr_api.g_number
1560: ,p_validation_param_item_id1 in number default hr_api.g_number
1561: ,p_validation_param_item_id2 in number default hr_api.g_number
1562: ,p_validation_param_item_id3 in number default hr_api.g_number
1563: ,p_validation_param_item_id4 in number default hr_api.g_number
1564: ,p_validation_param_item_id5 in number default hr_api.g_number
1565: ,p_visible in number default hr_api.g_number
1566: ,p_width in number default hr_api.g_number
1567: ,p_x_position in number default hr_api.g_number

Line 1564: ,p_validation_param_item_id5 in number default hr_api.g_number

1560: ,p_validation_param_item_id1 in number default hr_api.g_number
1561: ,p_validation_param_item_id2 in number default hr_api.g_number
1562: ,p_validation_param_item_id3 in number default hr_api.g_number
1563: ,p_validation_param_item_id4 in number default hr_api.g_number
1564: ,p_validation_param_item_id5 in number default hr_api.g_number
1565: ,p_visible in number default hr_api.g_number
1566: ,p_width in number default hr_api.g_number
1567: ,p_x_position in number default hr_api.g_number
1568: ,p_y_position in number default hr_api.g_number

Line 1565: ,p_visible in number default hr_api.g_number

1561: ,p_validation_param_item_id2 in number default hr_api.g_number
1562: ,p_validation_param_item_id3 in number default hr_api.g_number
1563: ,p_validation_param_item_id4 in number default hr_api.g_number
1564: ,p_validation_param_item_id5 in number default hr_api.g_number
1565: ,p_visible in number default hr_api.g_number
1566: ,p_width in number default hr_api.g_number
1567: ,p_x_position in number default hr_api.g_number
1568: ,p_y_position in number default hr_api.g_number
1569: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 1566: ,p_width in number default hr_api.g_number

1562: ,p_validation_param_item_id3 in number default hr_api.g_number
1563: ,p_validation_param_item_id4 in number default hr_api.g_number
1564: ,p_validation_param_item_id5 in number default hr_api.g_number
1565: ,p_visible in number default hr_api.g_number
1566: ,p_width in number default hr_api.g_number
1567: ,p_x_position in number default hr_api.g_number
1568: ,p_y_position in number default hr_api.g_number
1569: ,p_information_category in varchar2 default hr_api.g_varchar2
1570: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 1567: ,p_x_position in number default hr_api.g_number

1563: ,p_validation_param_item_id4 in number default hr_api.g_number
1564: ,p_validation_param_item_id5 in number default hr_api.g_number
1565: ,p_visible in number default hr_api.g_number
1566: ,p_width in number default hr_api.g_number
1567: ,p_x_position in number default hr_api.g_number
1568: ,p_y_position in number default hr_api.g_number
1569: ,p_information_category in varchar2 default hr_api.g_varchar2
1570: ,p_information1 in varchar2 default hr_api.g_varchar2
1571: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 1568: ,p_y_position in number default hr_api.g_number

1564: ,p_validation_param_item_id5 in number default hr_api.g_number
1565: ,p_visible in number default hr_api.g_number
1566: ,p_width in number default hr_api.g_number
1567: ,p_x_position in number default hr_api.g_number
1568: ,p_y_position in number default hr_api.g_number
1569: ,p_information_category in varchar2 default hr_api.g_varchar2
1570: ,p_information1 in varchar2 default hr_api.g_varchar2
1571: ,p_information2 in varchar2 default hr_api.g_varchar2
1572: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 1569: ,p_information_category in varchar2 default hr_api.g_varchar2

1565: ,p_visible in number default hr_api.g_number
1566: ,p_width in number default hr_api.g_number
1567: ,p_x_position in number default hr_api.g_number
1568: ,p_y_position in number default hr_api.g_number
1569: ,p_information_category in varchar2 default hr_api.g_varchar2
1570: ,p_information1 in varchar2 default hr_api.g_varchar2
1571: ,p_information2 in varchar2 default hr_api.g_varchar2
1572: ,p_information3 in varchar2 default hr_api.g_varchar2
1573: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 1570: ,p_information1 in varchar2 default hr_api.g_varchar2

1566: ,p_width in number default hr_api.g_number
1567: ,p_x_position in number default hr_api.g_number
1568: ,p_y_position in number default hr_api.g_number
1569: ,p_information_category in varchar2 default hr_api.g_varchar2
1570: ,p_information1 in varchar2 default hr_api.g_varchar2
1571: ,p_information2 in varchar2 default hr_api.g_varchar2
1572: ,p_information3 in varchar2 default hr_api.g_varchar2
1573: ,p_information4 in varchar2 default hr_api.g_varchar2
1574: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 1571: ,p_information2 in varchar2 default hr_api.g_varchar2

1567: ,p_x_position in number default hr_api.g_number
1568: ,p_y_position in number default hr_api.g_number
1569: ,p_information_category in varchar2 default hr_api.g_varchar2
1570: ,p_information1 in varchar2 default hr_api.g_varchar2
1571: ,p_information2 in varchar2 default hr_api.g_varchar2
1572: ,p_information3 in varchar2 default hr_api.g_varchar2
1573: ,p_information4 in varchar2 default hr_api.g_varchar2
1574: ,p_information5 in varchar2 default hr_api.g_varchar2
1575: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 1572: ,p_information3 in varchar2 default hr_api.g_varchar2

1568: ,p_y_position in number default hr_api.g_number
1569: ,p_information_category in varchar2 default hr_api.g_varchar2
1570: ,p_information1 in varchar2 default hr_api.g_varchar2
1571: ,p_information2 in varchar2 default hr_api.g_varchar2
1572: ,p_information3 in varchar2 default hr_api.g_varchar2
1573: ,p_information4 in varchar2 default hr_api.g_varchar2
1574: ,p_information5 in varchar2 default hr_api.g_varchar2
1575: ,p_information6 in varchar2 default hr_api.g_varchar2
1576: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 1573: ,p_information4 in varchar2 default hr_api.g_varchar2

1569: ,p_information_category in varchar2 default hr_api.g_varchar2
1570: ,p_information1 in varchar2 default hr_api.g_varchar2
1571: ,p_information2 in varchar2 default hr_api.g_varchar2
1572: ,p_information3 in varchar2 default hr_api.g_varchar2
1573: ,p_information4 in varchar2 default hr_api.g_varchar2
1574: ,p_information5 in varchar2 default hr_api.g_varchar2
1575: ,p_information6 in varchar2 default hr_api.g_varchar2
1576: ,p_information7 in varchar2 default hr_api.g_varchar2
1577: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 1574: ,p_information5 in varchar2 default hr_api.g_varchar2

1570: ,p_information1 in varchar2 default hr_api.g_varchar2
1571: ,p_information2 in varchar2 default hr_api.g_varchar2
1572: ,p_information3 in varchar2 default hr_api.g_varchar2
1573: ,p_information4 in varchar2 default hr_api.g_varchar2
1574: ,p_information5 in varchar2 default hr_api.g_varchar2
1575: ,p_information6 in varchar2 default hr_api.g_varchar2
1576: ,p_information7 in varchar2 default hr_api.g_varchar2
1577: ,p_information8 in varchar2 default hr_api.g_varchar2
1578: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 1575: ,p_information6 in varchar2 default hr_api.g_varchar2

1571: ,p_information2 in varchar2 default hr_api.g_varchar2
1572: ,p_information3 in varchar2 default hr_api.g_varchar2
1573: ,p_information4 in varchar2 default hr_api.g_varchar2
1574: ,p_information5 in varchar2 default hr_api.g_varchar2
1575: ,p_information6 in varchar2 default hr_api.g_varchar2
1576: ,p_information7 in varchar2 default hr_api.g_varchar2
1577: ,p_information8 in varchar2 default hr_api.g_varchar2
1578: ,p_information9 in varchar2 default hr_api.g_varchar2
1579: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 1576: ,p_information7 in varchar2 default hr_api.g_varchar2

1572: ,p_information3 in varchar2 default hr_api.g_varchar2
1573: ,p_information4 in varchar2 default hr_api.g_varchar2
1574: ,p_information5 in varchar2 default hr_api.g_varchar2
1575: ,p_information6 in varchar2 default hr_api.g_varchar2
1576: ,p_information7 in varchar2 default hr_api.g_varchar2
1577: ,p_information8 in varchar2 default hr_api.g_varchar2
1578: ,p_information9 in varchar2 default hr_api.g_varchar2
1579: ,p_information10 in varchar2 default hr_api.g_varchar2
1580: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 1577: ,p_information8 in varchar2 default hr_api.g_varchar2

1573: ,p_information4 in varchar2 default hr_api.g_varchar2
1574: ,p_information5 in varchar2 default hr_api.g_varchar2
1575: ,p_information6 in varchar2 default hr_api.g_varchar2
1576: ,p_information7 in varchar2 default hr_api.g_varchar2
1577: ,p_information8 in varchar2 default hr_api.g_varchar2
1578: ,p_information9 in varchar2 default hr_api.g_varchar2
1579: ,p_information10 in varchar2 default hr_api.g_varchar2
1580: ,p_information11 in varchar2 default hr_api.g_varchar2
1581: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 1578: ,p_information9 in varchar2 default hr_api.g_varchar2

1574: ,p_information5 in varchar2 default hr_api.g_varchar2
1575: ,p_information6 in varchar2 default hr_api.g_varchar2
1576: ,p_information7 in varchar2 default hr_api.g_varchar2
1577: ,p_information8 in varchar2 default hr_api.g_varchar2
1578: ,p_information9 in varchar2 default hr_api.g_varchar2
1579: ,p_information10 in varchar2 default hr_api.g_varchar2
1580: ,p_information11 in varchar2 default hr_api.g_varchar2
1581: ,p_information12 in varchar2 default hr_api.g_varchar2
1582: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 1579: ,p_information10 in varchar2 default hr_api.g_varchar2

1575: ,p_information6 in varchar2 default hr_api.g_varchar2
1576: ,p_information7 in varchar2 default hr_api.g_varchar2
1577: ,p_information8 in varchar2 default hr_api.g_varchar2
1578: ,p_information9 in varchar2 default hr_api.g_varchar2
1579: ,p_information10 in varchar2 default hr_api.g_varchar2
1580: ,p_information11 in varchar2 default hr_api.g_varchar2
1581: ,p_information12 in varchar2 default hr_api.g_varchar2
1582: ,p_information13 in varchar2 default hr_api.g_varchar2
1583: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 1580: ,p_information11 in varchar2 default hr_api.g_varchar2

1576: ,p_information7 in varchar2 default hr_api.g_varchar2
1577: ,p_information8 in varchar2 default hr_api.g_varchar2
1578: ,p_information9 in varchar2 default hr_api.g_varchar2
1579: ,p_information10 in varchar2 default hr_api.g_varchar2
1580: ,p_information11 in varchar2 default hr_api.g_varchar2
1581: ,p_information12 in varchar2 default hr_api.g_varchar2
1582: ,p_information13 in varchar2 default hr_api.g_varchar2
1583: ,p_information14 in varchar2 default hr_api.g_varchar2
1584: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 1581: ,p_information12 in varchar2 default hr_api.g_varchar2

1577: ,p_information8 in varchar2 default hr_api.g_varchar2
1578: ,p_information9 in varchar2 default hr_api.g_varchar2
1579: ,p_information10 in varchar2 default hr_api.g_varchar2
1580: ,p_information11 in varchar2 default hr_api.g_varchar2
1581: ,p_information12 in varchar2 default hr_api.g_varchar2
1582: ,p_information13 in varchar2 default hr_api.g_varchar2
1583: ,p_information14 in varchar2 default hr_api.g_varchar2
1584: ,p_information15 in varchar2 default hr_api.g_varchar2
1585: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 1582: ,p_information13 in varchar2 default hr_api.g_varchar2

1578: ,p_information9 in varchar2 default hr_api.g_varchar2
1579: ,p_information10 in varchar2 default hr_api.g_varchar2
1580: ,p_information11 in varchar2 default hr_api.g_varchar2
1581: ,p_information12 in varchar2 default hr_api.g_varchar2
1582: ,p_information13 in varchar2 default hr_api.g_varchar2
1583: ,p_information14 in varchar2 default hr_api.g_varchar2
1584: ,p_information15 in varchar2 default hr_api.g_varchar2
1585: ,p_information16 in varchar2 default hr_api.g_varchar2
1586: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 1583: ,p_information14 in varchar2 default hr_api.g_varchar2

1579: ,p_information10 in varchar2 default hr_api.g_varchar2
1580: ,p_information11 in varchar2 default hr_api.g_varchar2
1581: ,p_information12 in varchar2 default hr_api.g_varchar2
1582: ,p_information13 in varchar2 default hr_api.g_varchar2
1583: ,p_information14 in varchar2 default hr_api.g_varchar2
1584: ,p_information15 in varchar2 default hr_api.g_varchar2
1585: ,p_information16 in varchar2 default hr_api.g_varchar2
1586: ,p_information17 in varchar2 default hr_api.g_varchar2
1587: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 1584: ,p_information15 in varchar2 default hr_api.g_varchar2

1580: ,p_information11 in varchar2 default hr_api.g_varchar2
1581: ,p_information12 in varchar2 default hr_api.g_varchar2
1582: ,p_information13 in varchar2 default hr_api.g_varchar2
1583: ,p_information14 in varchar2 default hr_api.g_varchar2
1584: ,p_information15 in varchar2 default hr_api.g_varchar2
1585: ,p_information16 in varchar2 default hr_api.g_varchar2
1586: ,p_information17 in varchar2 default hr_api.g_varchar2
1587: ,p_information18 in varchar2 default hr_api.g_varchar2
1588: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 1585: ,p_information16 in varchar2 default hr_api.g_varchar2

1581: ,p_information12 in varchar2 default hr_api.g_varchar2
1582: ,p_information13 in varchar2 default hr_api.g_varchar2
1583: ,p_information14 in varchar2 default hr_api.g_varchar2
1584: ,p_information15 in varchar2 default hr_api.g_varchar2
1585: ,p_information16 in varchar2 default hr_api.g_varchar2
1586: ,p_information17 in varchar2 default hr_api.g_varchar2
1587: ,p_information18 in varchar2 default hr_api.g_varchar2
1588: ,p_information19 in varchar2 default hr_api.g_varchar2
1589: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 1586: ,p_information17 in varchar2 default hr_api.g_varchar2

1582: ,p_information13 in varchar2 default hr_api.g_varchar2
1583: ,p_information14 in varchar2 default hr_api.g_varchar2
1584: ,p_information15 in varchar2 default hr_api.g_varchar2
1585: ,p_information16 in varchar2 default hr_api.g_varchar2
1586: ,p_information17 in varchar2 default hr_api.g_varchar2
1587: ,p_information18 in varchar2 default hr_api.g_varchar2
1588: ,p_information19 in varchar2 default hr_api.g_varchar2
1589: ,p_information20 in varchar2 default hr_api.g_varchar2
1590: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 1587: ,p_information18 in varchar2 default hr_api.g_varchar2

1583: ,p_information14 in varchar2 default hr_api.g_varchar2
1584: ,p_information15 in varchar2 default hr_api.g_varchar2
1585: ,p_information16 in varchar2 default hr_api.g_varchar2
1586: ,p_information17 in varchar2 default hr_api.g_varchar2
1587: ,p_information18 in varchar2 default hr_api.g_varchar2
1588: ,p_information19 in varchar2 default hr_api.g_varchar2
1589: ,p_information20 in varchar2 default hr_api.g_varchar2
1590: ,p_information21 in varchar2 default hr_api.g_varchar2
1591: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 1588: ,p_information19 in varchar2 default hr_api.g_varchar2

1584: ,p_information15 in varchar2 default hr_api.g_varchar2
1585: ,p_information16 in varchar2 default hr_api.g_varchar2
1586: ,p_information17 in varchar2 default hr_api.g_varchar2
1587: ,p_information18 in varchar2 default hr_api.g_varchar2
1588: ,p_information19 in varchar2 default hr_api.g_varchar2
1589: ,p_information20 in varchar2 default hr_api.g_varchar2
1590: ,p_information21 in varchar2 default hr_api.g_varchar2
1591: ,p_information22 in varchar2 default hr_api.g_varchar2
1592: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 1589: ,p_information20 in varchar2 default hr_api.g_varchar2

1585: ,p_information16 in varchar2 default hr_api.g_varchar2
1586: ,p_information17 in varchar2 default hr_api.g_varchar2
1587: ,p_information18 in varchar2 default hr_api.g_varchar2
1588: ,p_information19 in varchar2 default hr_api.g_varchar2
1589: ,p_information20 in varchar2 default hr_api.g_varchar2
1590: ,p_information21 in varchar2 default hr_api.g_varchar2
1591: ,p_information22 in varchar2 default hr_api.g_varchar2
1592: ,p_information23 in varchar2 default hr_api.g_varchar2
1593: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 1590: ,p_information21 in varchar2 default hr_api.g_varchar2

1586: ,p_information17 in varchar2 default hr_api.g_varchar2
1587: ,p_information18 in varchar2 default hr_api.g_varchar2
1588: ,p_information19 in varchar2 default hr_api.g_varchar2
1589: ,p_information20 in varchar2 default hr_api.g_varchar2
1590: ,p_information21 in varchar2 default hr_api.g_varchar2
1591: ,p_information22 in varchar2 default hr_api.g_varchar2
1592: ,p_information23 in varchar2 default hr_api.g_varchar2
1593: ,p_information24 in varchar2 default hr_api.g_varchar2
1594: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 1591: ,p_information22 in varchar2 default hr_api.g_varchar2

1587: ,p_information18 in varchar2 default hr_api.g_varchar2
1588: ,p_information19 in varchar2 default hr_api.g_varchar2
1589: ,p_information20 in varchar2 default hr_api.g_varchar2
1590: ,p_information21 in varchar2 default hr_api.g_varchar2
1591: ,p_information22 in varchar2 default hr_api.g_varchar2
1592: ,p_information23 in varchar2 default hr_api.g_varchar2
1593: ,p_information24 in varchar2 default hr_api.g_varchar2
1594: ,p_information25 in varchar2 default hr_api.g_varchar2
1595: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 1592: ,p_information23 in varchar2 default hr_api.g_varchar2

1588: ,p_information19 in varchar2 default hr_api.g_varchar2
1589: ,p_information20 in varchar2 default hr_api.g_varchar2
1590: ,p_information21 in varchar2 default hr_api.g_varchar2
1591: ,p_information22 in varchar2 default hr_api.g_varchar2
1592: ,p_information23 in varchar2 default hr_api.g_varchar2
1593: ,p_information24 in varchar2 default hr_api.g_varchar2
1594: ,p_information25 in varchar2 default hr_api.g_varchar2
1595: ,p_information26 in varchar2 default hr_api.g_varchar2
1596: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 1593: ,p_information24 in varchar2 default hr_api.g_varchar2

1589: ,p_information20 in varchar2 default hr_api.g_varchar2
1590: ,p_information21 in varchar2 default hr_api.g_varchar2
1591: ,p_information22 in varchar2 default hr_api.g_varchar2
1592: ,p_information23 in varchar2 default hr_api.g_varchar2
1593: ,p_information24 in varchar2 default hr_api.g_varchar2
1594: ,p_information25 in varchar2 default hr_api.g_varchar2
1595: ,p_information26 in varchar2 default hr_api.g_varchar2
1596: ,p_information27 in varchar2 default hr_api.g_varchar2
1597: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 1594: ,p_information25 in varchar2 default hr_api.g_varchar2

1590: ,p_information21 in varchar2 default hr_api.g_varchar2
1591: ,p_information22 in varchar2 default hr_api.g_varchar2
1592: ,p_information23 in varchar2 default hr_api.g_varchar2
1593: ,p_information24 in varchar2 default hr_api.g_varchar2
1594: ,p_information25 in varchar2 default hr_api.g_varchar2
1595: ,p_information26 in varchar2 default hr_api.g_varchar2
1596: ,p_information27 in varchar2 default hr_api.g_varchar2
1597: ,p_information28 in varchar2 default hr_api.g_varchar2
1598: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 1595: ,p_information26 in varchar2 default hr_api.g_varchar2

1591: ,p_information22 in varchar2 default hr_api.g_varchar2
1592: ,p_information23 in varchar2 default hr_api.g_varchar2
1593: ,p_information24 in varchar2 default hr_api.g_varchar2
1594: ,p_information25 in varchar2 default hr_api.g_varchar2
1595: ,p_information26 in varchar2 default hr_api.g_varchar2
1596: ,p_information27 in varchar2 default hr_api.g_varchar2
1597: ,p_information28 in varchar2 default hr_api.g_varchar2
1598: ,p_information29 in varchar2 default hr_api.g_varchar2
1599: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 1596: ,p_information27 in varchar2 default hr_api.g_varchar2

1592: ,p_information23 in varchar2 default hr_api.g_varchar2
1593: ,p_information24 in varchar2 default hr_api.g_varchar2
1594: ,p_information25 in varchar2 default hr_api.g_varchar2
1595: ,p_information26 in varchar2 default hr_api.g_varchar2
1596: ,p_information27 in varchar2 default hr_api.g_varchar2
1597: ,p_information28 in varchar2 default hr_api.g_varchar2
1598: ,p_information29 in varchar2 default hr_api.g_varchar2
1599: ,p_information30 in varchar2 default hr_api.g_varchar2
1600: ,p_next_navigation_item_id in number default hr_api.g_number

Line 1597: ,p_information28 in varchar2 default hr_api.g_varchar2

1593: ,p_information24 in varchar2 default hr_api.g_varchar2
1594: ,p_information25 in varchar2 default hr_api.g_varchar2
1595: ,p_information26 in varchar2 default hr_api.g_varchar2
1596: ,p_information27 in varchar2 default hr_api.g_varchar2
1597: ,p_information28 in varchar2 default hr_api.g_varchar2
1598: ,p_information29 in varchar2 default hr_api.g_varchar2
1599: ,p_information30 in varchar2 default hr_api.g_varchar2
1600: ,p_next_navigation_item_id in number default hr_api.g_number
1601: ,p_previous_navigation_item_id in number default hr_api.g_number

Line 1598: ,p_information29 in varchar2 default hr_api.g_varchar2

1594: ,p_information25 in varchar2 default hr_api.g_varchar2
1595: ,p_information26 in varchar2 default hr_api.g_varchar2
1596: ,p_information27 in varchar2 default hr_api.g_varchar2
1597: ,p_information28 in varchar2 default hr_api.g_varchar2
1598: ,p_information29 in varchar2 default hr_api.g_varchar2
1599: ,p_information30 in varchar2 default hr_api.g_varchar2
1600: ,p_next_navigation_item_id in number default hr_api.g_number
1601: ,p_previous_navigation_item_id in number default hr_api.g_number
1602: ,p_override_value_warning out nocopy boolean

Line 1599: ,p_information30 in varchar2 default hr_api.g_varchar2

1595: ,p_information26 in varchar2 default hr_api.g_varchar2
1596: ,p_information27 in varchar2 default hr_api.g_varchar2
1597: ,p_information28 in varchar2 default hr_api.g_varchar2
1598: ,p_information29 in varchar2 default hr_api.g_varchar2
1599: ,p_information30 in varchar2 default hr_api.g_varchar2
1600: ,p_next_navigation_item_id in number default hr_api.g_number
1601: ,p_previous_navigation_item_id in number default hr_api.g_number
1602: ,p_override_value_warning out nocopy boolean
1603: ) is

Line 1600: ,p_next_navigation_item_id in number default hr_api.g_number

1596: ,p_information27 in varchar2 default hr_api.g_varchar2
1597: ,p_information28 in varchar2 default hr_api.g_varchar2
1598: ,p_information29 in varchar2 default hr_api.g_varchar2
1599: ,p_information30 in varchar2 default hr_api.g_varchar2
1600: ,p_next_navigation_item_id in number default hr_api.g_number
1601: ,p_previous_navigation_item_id in number default hr_api.g_number
1602: ,p_override_value_warning out nocopy boolean
1603: ) is
1604: --

Line 1601: ,p_previous_navigation_item_id in number default hr_api.g_number

1597: ,p_information28 in varchar2 default hr_api.g_varchar2
1598: ,p_information29 in varchar2 default hr_api.g_varchar2
1599: ,p_information30 in varchar2 default hr_api.g_varchar2
1600: ,p_next_navigation_item_id in number default hr_api.g_number
1601: ,p_previous_navigation_item_id in number default hr_api.g_number
1602: ,p_override_value_warning out nocopy boolean
1603: ) is
1604: --
1605: -- Declare cursors and local variables

Line 1653: hr_api.validate_language_code(p_language_code => l_language_code);

1649: -- instead of p_language_code from now on, to allow an IN OUT parameter to
1650: -- be passed through.
1651: --
1652: l_language_code := p_language_code;
1653: hr_api.validate_language_code(p_language_code => l_language_code);
1654: --
1655: --
1656: -- Call Before Process User Hook
1657: --

Line 1737: when hr_api.cannot_find_prog_unit then

1733: ,p_next_navigation_item_id => p_next_navigation_item_id
1734: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
1735:
1736: exception
1737: when hr_api.cannot_find_prog_unit then
1738: hr_api.cannot_find_prog_unit_error
1739: (p_module_name => 'update_template_item'
1740: ,p_hook_type => 'BP'
1741: );

Line 1738: hr_api.cannot_find_prog_unit_error

1734: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
1735:
1736: exception
1737: when hr_api.cannot_find_prog_unit then
1738: hr_api.cannot_find_prog_unit_error
1739: (p_module_name => 'update_template_item'
1740: ,p_hook_type => 'BP'
1741: );
1742: end;

Line 1754: IF ( p_required <> hr_api.g_number ) AND

1750: CLOSE cur_override;
1751:
1752: hr_utility.set_location('Entering:'|| l_proc, 20);
1753:
1754: IF ( p_required <> hr_api.g_number ) AND
1755: ( l_required_override is not null AND p_required is not null ) THEN
1756: l_override_value_warning := TRUE;
1757: END IF;
1758:

Line 1761: IF ( p_visible <> hr_api.g_number ) AND

1757: END IF;
1758:
1759: hr_utility.set_location('Entering:'|| l_proc, 25);
1760:
1761: IF ( p_visible <> hr_api.g_number ) AND
1762: ( l_visible_override is not null AND p_visible is not null ) THEN
1763: l_override_value_warning := TRUE;
1764: END IF;
1765:

Line 2030: when hr_api.cannot_find_prog_unit then

2026: ,p_next_navigation_item_id => p_next_navigation_item_id
2027: ,p_previous_navigation_item_id => p_previous_navigation_item_id
2028: ,p_override_value_warning => l_override_value_warning);
2029: exception
2030: when hr_api.cannot_find_prog_unit then
2031: hr_api.cannot_find_prog_unit_error
2032: (p_module_name => 'update_template_item'
2033: ,p_hook_type => 'AP'
2034: );

Line 2031: hr_api.cannot_find_prog_unit_error

2027: ,p_previous_navigation_item_id => p_previous_navigation_item_id
2028: ,p_override_value_warning => l_override_value_warning);
2029: exception
2030: when hr_api.cannot_find_prog_unit then
2031: hr_api.cannot_find_prog_unit_error
2032: (p_module_name => 'update_template_item'
2033: ,p_hook_type => 'AP'
2034: );
2035: end;

Line 2042: raise hr_api.validate_enabled;

2038: --
2039: hr_utility.set_location('Entering:'|| l_proc, 50);
2040:
2041: if p_validate then
2042: raise hr_api.validate_enabled;
2043: end if;
2044: --
2045: -- Set all output arguments
2046: --

Line 2052: when hr_api.validate_enabled then

2048: p_override_value_warning := l_override_value_warning;
2049: --
2050: hr_utility.set_location(' Leaving:'||l_proc, 70);
2051: exception
2052: when hr_api.validate_enabled then
2053: --
2054: -- As the Validate_Enabled exception has been raised
2055: -- we must rollback to the savepoint
2056: --