[Home] [Help]
PACKAGE: APPS.GHR_CPDF_CHECK3
Source
1 package GHR_CPDF_CHECK3 AUTHID CURRENT_USER as
2 /* $Header: ghcpdf03.pkh 120.3 2010/10/29 10:41:56 utokachi ship $ */
3
4
5 -- <Precedure Info>
6 -- Name:
7 -- Nature of Action
8 -- Sections in CPDF:
9 -- C37 - C40
10 -- Note:
11 --
12 --
13
14
15
16 procedure chk_Nature_of_Action
17 (p_First_NOAC_Lookup_Code in varchar2
18 ,p_Second_NOAC_Lookup_code in varchar2
19 ,p_First_Action_NOA_Code1 in varchar2
20 ,p_First_Action_NOA_Code2 in varchar2
21 ,p_Cur_Appt_Auth_1 in varchar2 --non SF52 item
22 ,p_Cur_Appt_Auth_2 in varchar2 --non SF52 item
23 ,p_Employee_Date_of_Birth in date
24 ,p_Duty_Station_Lookup_Code in varchar2
25 ,p_Employee_First_Name in varchar2
26 ,p_Employee_Last_Name in varchar2
27 ,p_Handicap in varchar2 --non SF52 item
28 ,p_Organ_Component in varchar2 --non SF52 item
29 ,p_Personal_Office_ID in varchar2 --non SF52 item
30 ,p_Position_Occ_Code in varchar2
31 ,p_Race_National_Region in varchar2 --non SF52 item
32 ,p_Retirement_Plan_Code in varchar2
33 ,p_Service_Computation_Date in Date
34 ,p_Sex in varchar2 --non SF52 item
35 ,p_Supervisory_Status_Code in varchar2
36 ,p_Tenure_Group_Code in varchar2
37 ,p_Veterans_Pref_Code in varchar2
38 ,p_Veterans_Status_Code in varchar2
39 ,p_Occupation in varchar2 --non SF52 item
40 ,p_To_Pay_Basis in varchar2
41 ,p_To_Grade_Or_Level in varchar2
42 ,p_To_Pay_Plan in varchar2
43 ,p_pay_rate_determinant_code in varchar2
44 ,p_To_Basic_Pay in varchar2
45 ,p_To_Step_Or_Rate in varchar2
46 ,p_Work_Sche_Code in varchar2
47 ,p_Prior_Occupation in varchar2 --non SF52 item
48 ,p_Prior_To_Pay_Basis in varchar2 --non SF52 item
49 ,p_Prior_To_Grade_Or_Level in varchar2 --non SF52 item
50 ,p_Prior_To_Pay_Plan in varchar2 --non SF52 item
51 ,p_Prior_Pay_Rate_Det_Code in varchar2 --non SF52 item
52 ,p_Prior_To_Basic_Pay in varchar2 --non SF52 item
53 ,p_Prior_To_Step_Or_Rate in varchar2 --non SF52 item
54 ,p_Prior_Work_Sche_Code in varchar2 --non SF52 item
55 ,p_prior_duty_station in varchar2
56 ,p_Retention_Allowance in varchar2 --non SF52 item
57 ,p_Staff_Diff in varchar2 --non SF52 item
58 ,p_Supervisory_Diff in varchar2 --non SF52 item
59 ,p_To_Locality_Adj in varchar2
60 ,p_Prior_To_Locality_Adj in varchar2 --non SF52 item
61 ,p_noa_family_code in varchar2
62 ,p_effective_date in date
63 ,p_agency_subelement in varchar2
64 ,p_ethnic_race_info in varchar2
65 ,p_rating_of_record_level in varchar2 --non SF52 item Bug# 10189715
66 ,p_rating_of_record_pattern in varchar2 --non SF52 item Bug# 10189715
67 );
68
69 -- <Precedure Info>
70 -- Name:
71 -- Occupation
72 -- Sections in CPDF:
73 -- C40 - C41
74 -- Note:
75 --
76 --
77
78 procedure chk_occupation
79 (p_to_pay_plan in varchar2
80 ,p_occ_code in varchar2
81 ,p_agency_sub in varchar2 -- non SF52 item
82 ,p_duty_station_lookup_code in varchar2
83 ,p_effective_date in date
84
85 );
86
87 -- -- Name:
88 -- Pay Basis
89 -- Sections in CPDF:
90 -- C42
91 -- Note:
92 --
93 --
94
95 procedure chk_pay_basis
96 (p_to_pay_plan in varchar2
97 ,p_pay_basis in varchar2
98 ,p_basic_pay in varchar2
99 ,p_agency_subelement in varchar2 --non SF52 item
100 ,p_occ_code in varchar2 --Bug# 5745356
101 ,p_effective_date in date
102 ,p_pay_rate_determinant_code in varchar2
103 );
104
105 -- Name:
106 -- Pay Grade
107 -- Sections in CPDF:
108 -- C43 - C46
109 -- Note:
110 --
111
112 procedure chk_pay_grade
113 (p_to_pay_plan in varchar2
114 ,p_to_grade_or_level in varchar2
115 ,p_pay_rate_determinant_code in varchar2
116 ,p_first_action_noa_la_code1 in varchar2
117 ,p_first_action_noa_la_code2 in varchar2
118 ,p_First_NOAC_Lookup_Code in varchar2
119 ,p_Second_NOAC_Lookup_code in varchar2
120 ,p_effective_date in date
121 );
122
123
124
125 -- <Precedure Info>
126 -- Name:
127 -- Pay Plan
128 -- Sections in CPDF:
129 -- C-47 - C-50
130 -- Note:
131 --
132
133 procedure chk_pay_plan
134 (p_to_pay_plan in varchar2
135 ,p_agency_subelement in varchar2 --non SF52
136 ,p_pers_office_identifier in varchar2 --non SF52
137 ,p_to_grade_or_level in varchar2
138 ,p_first_action_noa_la_code1 in varchar2
139 ,p_first_action_noa_la_code2 in varchar2
140 ,p_Cur_Appt_Auth_1 in varchar2 --non SF52 item
141 ,p_Cur_Appt_Auth_2 in varchar2 --non SF52 item
142 ,p_first_NOAC_Lookup_Code in varchar2
143 ,p_Pay_Rate_Determinant_Code in varchar2
144 ,p_Effective_Date in date
145 ,p_prior_pay_plan in varchar2 --non SF52
146 ,p_prior_grade in varchar2 --non SF52
147 ,p_Agency in varchar2 --non SF52
148 ,p_Supervisory_status_code in varchar2
149 );
150 --
151 -- <Precedure Info>
152 -- Name:
153 -- Pay Rate Determinant
154 -- Sections in CPDF:
155 -- C-51, C-52
156 -- Note:
157 --
158
159 procedure chk_pay_rate_determinant
160 (p_pay_rate_determinant_code in varchar2
161 ,p_prior_pay_rate_det_code in varchar2 --non SF52
162 ,p_to_pay_plan in varchar2
163 ,p_first_noa_lookup_code in varchar2
164 ,p_duty_station_lookup_code in varchar2
165 ,p_agency in varchar2
166 ,p_effective_date in date
167 );
168
169 end GHR_CPDF_CHECK3;