4: --
5: -----------------------------
6: --
7: Procedure chk_date_to(p_position_description_id IN
8: ghr_position_descriptions.position_description_id%TYPE,
9: p_date_from IN DATE,
10: p_date_to IN DATE);
11:
12: --
12: --
13: -----------------------------
14: --
15: Procedure chk_flsa(p_position_description_id IN
16: ghr_position_descriptions.position_description_id%TYPE,
17: p_flsa IN ghr_position_descriptions.flsa%TYPE,
18: p_effective_date IN DATE,
19: p_object_version_number IN number);
20: --
13: -----------------------------
14: --
15: Procedure chk_flsa(p_position_description_id IN
16: ghr_position_descriptions.position_description_id%TYPE,
17: p_flsa IN ghr_position_descriptions.flsa%TYPE,
18: p_effective_date IN DATE,
19: p_object_version_number IN number);
20: --
21: -----------------------------
20: --
21: -----------------------------
22: --
23: Procedure chk_category(p_position_description_id IN
24: ghr_position_descriptions.position_description_id%TYPE,
25: p_category IN ghr_position_descriptions.category%TYPE,
26: p_effective_date IN DATE,
27: p_object_version_number IN number);
28: --
21: -----------------------------
22: --
23: Procedure chk_category(p_position_description_id IN
24: ghr_position_descriptions.position_description_id%TYPE,
25: p_category IN ghr_position_descriptions.category%TYPE,
26: p_effective_date IN DATE,
27: p_object_version_number IN number);
28: --
29: -----------------------------
29: -----------------------------
30: --
31:
32: Procedure chk_financial_statement(p_position_description_id IN
33: ghr_position_descriptions.position_description_id%TYPE,
34: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE,
35: p_effective_date IN date,
36: p_object_version_number IN number);
37:
30: --
31:
32: Procedure chk_financial_statement(p_position_description_id IN
33: ghr_position_descriptions.position_description_id%TYPE,
34: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE,
35: p_effective_date IN date,
36: p_object_version_number IN number);
37:
38:
41: -------------------------------< chk_subject_to_ia_action>---------------------
42: --
43:
44: Procedure chk_subject_to_ia_action (p_position_description_id IN
45: ghr_position_descriptions.position_description_id%TYPE,
46: p_sub_to_ia_action IN ghr_position_descriptions.subject_to_ia_action %TYPE,
47: p_effective_date IN date,
48: p_object_version_number IN number);
49:
42: --
43:
44: Procedure chk_subject_to_ia_action (p_position_description_id IN
45: ghr_position_descriptions.position_description_id%TYPE,
46: p_sub_to_ia_action IN ghr_position_descriptions.subject_to_ia_action %TYPE,
47: p_effective_date IN date,
48: p_object_version_number IN number);
49:
50: --
51: ---------------------------------
52: --
53:
54: Procedure chk_position_status (p_position_description_id IN
55: ghr_position_descriptions.position_description_id%TYPE,
56: p_position_status IN ghr_position_descriptions.position_status%TYPE,
57: p_effective_date IN date,
58: p_object_version_number IN number);
59:
52: --
53:
54: Procedure chk_position_status (p_position_description_id IN
55: ghr_position_descriptions.position_description_id%TYPE,
56: p_position_status IN ghr_position_descriptions.position_status%TYPE,
57: p_effective_date IN date,
58: p_object_version_number IN number);
59:
60: --
61: -----------------------------------
62: --
63:
64: Procedure chk_position_is (p_position_description_id IN
65: ghr_position_descriptions.position_description_id%TYPE,
66: p_position_is IN ghr_position_descriptions.position_is%TYPE,
67: p_effective_date IN date,
68: p_object_version_number IN number);
69:
62: --
63:
64: Procedure chk_position_is (p_position_description_id IN
65: ghr_position_descriptions.position_description_id%TYPE,
66: p_position_is IN ghr_position_descriptions.position_is%TYPE,
67: p_effective_date IN date,
68: p_object_version_number IN number);
69:
70: --
71: ----------------------------------
72: --
73:
74: Procedure chk_position_sensitivity(p_position_description_id IN
75: ghr_position_descriptions.position_description_id%TYPE,
76: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE,
77: p_effective_date IN date,
78: p_object_version_number IN number);
79:
72: --
73:
74: Procedure chk_position_sensitivity(p_position_description_id IN
75: ghr_position_descriptions.position_description_id%TYPE,
76: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE,
77: p_effective_date IN date,
78: p_object_version_number IN number);
79:
80: --
81: -----------------------------------
82: --
83:
84: Procedure chk_competitive_level(p_position_description_id IN
85: ghr_position_descriptions.position_description_id%TYPE,
86: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE,
87: p_effective_date IN date,
88: p_object_version_number IN number);
89:
82: --
83:
84: Procedure chk_competitive_level(p_position_description_id IN
85: ghr_position_descriptions.position_description_id%TYPE,
86: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE,
87: p_effective_date IN date,
88: p_object_version_number IN number);
89:
90: --
91: ------------------------------------
92: --
93:
94: Procedure chk_career_ladder(p_position_description_id IN
95: ghr_position_descriptions.position_description_id%TYPE,
96: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE,
97: p_effective_date IN date,
98: p_object_version_number IN number);
99:
92: --
93:
94: Procedure chk_career_ladder(p_position_description_id IN
95: ghr_position_descriptions.position_description_id%TYPE,
96: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE,
97: p_effective_date IN date,
98: p_object_version_number IN number);
99:
100: --
101: ------------------------------------
102: --
103:
104: Procedure chk_routing_group_id(p_position_description_id IN
105: ghr_position_descriptions.position_description_id%TYPE,
106: p_routing_group_id IN ghr_position_descriptions.routing_group_id%TYPE,
107: p_effective_date IN date,
108: p_object_version_number IN number);
109:
102: --
103:
104: Procedure chk_routing_group_id(p_position_description_id IN
105: ghr_position_descriptions.position_description_id%TYPE,
106: p_routing_group_id IN ghr_position_descriptions.routing_group_id%TYPE,
107: p_effective_date IN date,
108: p_object_version_number IN number);
109:
110: --