DBA Data[Home] [Help]

PACKAGE: APPS.GHR_CPDF_CHECK5

Source


1 package GHR_CPDF_CHECK5 as
2 /* $Header: ghcpdf05.pkh 120.3.12010000.1 2008/07/28 10:25:54 appldev ship $ */
3 
4 -- <Precedure Info>
5 -- Name:
6 --   RATING OF RECORD
7 -- Sections in CPDF:
8 --   C53
9 -- Note:
10 --
11 --
12 
13 
14 procedure chk_rating_of_rec
15   (p_rating_of_record_level 	    in 	varchar2  -- non SF52
16   ,p_rating_of_record_pattern	    in	varchar2  -- non SF52
17   ,p_rating_of_record_period	    in	varchar2  -- non SF52
18   ,p_rating_of_record_per_starts    in	varchar2  -- non SF52
19   ,p_first_noac_lookup_code         in  varchar2
20   ,p_effective_date                 in  date
21   ,p_submission_date                in  date         -- non SF52
22   ,p_to_pay_plan                    in  varchar2
23   );
24 
25 
26 
27 --
28 -- <Precedure Info>
29 -- Name:
30 --   Position Occupied
31 -- Sections in CPDF:
32 --   C53, C54
33 -- Note:
34 --
35 --
36 
37 
38 procedure chk_position_occupied
39   (p_position_occupied_code 	in varchar2
40   ,p_to_pay_plan            	in varchar2
41   ,p_first_noac_lookup_code   in varchar2
42   ,p_effective_date           in date
43   );
44 
45 --
46 -- <Precedure Info>
47 -- Name:
48 --   Prior Occupation
49 -- Sections in CPDF:
50 --   C54, C55
51 -- Note:
52 --
53 procedure chk_prior_occupation
54   (p_prior_occupation_code         in  varchar2  --non SF52
55   ,p_occupation_code               in  varchar2  --non SF52
56   ,p_first_noac_lookup_code        in  varchar2
57   ,p_prior_pay_plan                in  varchar2  --non SF52
58   ,p_agency_subelement             in  varchar2  --non SF52
59   ,p_effective_date                in  date
60   );
61 
62 
63 -- <Precedure Info>
64 -- Name:
65 --   Prior Pay Basis
66 -- Sections in CPDF:
67 --   C56
68 -- Note:
69 --
70 procedure chk_prior_pay_basis
71   (p_prior_pay_basis      in  varchar2  --non SF52
72   ,p_prior_pay_plan       in  varchar2  --non SF52
73   ,p_agency_subelement    in  varchar2  --non SF52
74   ,p_prior_basic_pay      in  varchar2  --non SF52
75   ,p_effective_date       in  date
76   ,p_prior_effective_date in date
77   ,p_prior_pay_rate_det_code in varchar2
78   );
79 
80 
81 --
82 -- <Precedure Info>
83 -- Name:
84 --   Prior Grade
85 -- Sections in CPDF:
86 --   C57 - C62
87 -- Note:
88 --
89 procedure chk_prior_grade
90   (p_prior_pay_plan         	in  varchar2  --non SF52
91   ,p_grade_or_level         	in  varchar2
92   ,p_prior_grade            	in  varchar2  --non SF52
93   ,p_to_pay_plan            	in  varchar2
94   ,p_first_noac_lookup_code 	in  varchar2
95   ,p_prior_pay_rate_det_code	in  varchar2  --non SF52
96   ,p_effective_date           in  date
97   );
98 
99 
100 --
101 -- <Precedure Info>
102 -- Name:
103 --   Prior Pay Plan
104 -- Sections in CPDF:
105 --   C62
106 -- Note:
107 --
108 procedure chk_prior_pay_plan
109   (p_prior_pay_plan            in  varchar2  --non SF52
110   ,p_to_pay_plan               in  varchar2
111   ,p_first_noac_lookup_code    in  varchar2
112   --,p_prior_effective_date      in date --Bug# 6010943
113   ,p_effective_date      in date -- add Bug# 6010943
114   );
115 
116 
117 
118 -- <Precedure Info>
119 -- Name:
120 --   Prior Pay Rate Determinant
121 -- Sections in CPDF:
122 --   C62 - C64
123 -- Note:
124 --
125 
126 
127 procedure chk_prior_pay_rate_determinant
128   (p_prior_pay_rate_det_code    in varchar2       --non SF52 item
129   ,p_pay_rate_determinant       in varchar2
130   ,p_prior_pay_plan             in varchar2       --non SF52 item
131   ,p_to_pay_plan                in varchar2
132   ,p_agency                     in varchar2
133   ,p_First_NOAC_Lookup_Code     in varchar2
134   ,p_prior_duty_stn             in varchar2       --non SF52 item
135   ,p_prior_effective_date       in date
136   ,P_effective_date				in date           -- FWFA Change
137   );
138 
139 
140 --
141 -- <Precedure Info>
142 -- Name:
143 --   Prior Step or Rate
144 -- Sections in CPDF:
145 --   C70 - C74
146 -- Note:
147 --
148 
149 procedure chk_prior_step_or_rate
150   (p_prior_step_or_rate         in varchar2    --non SF52
151   ,p_first_noac_lookup_code     in varchar2
152   ,p_to_step_or_rate            in varchar2
153   ,p_pay_rate_determinant_code  in varchar2
154   ,p_to_pay_plan                in varchar2
155   ,p_prior_pay_rate_det_code    in varchar2    --non SF52
156   ,p_prior_pay_plan             in varchar2    --non SF52
157   ,p_prior_grade                in varchar2    --non SF52
158  ,p_prior_effective_date       in date
159  ,p_cur_appt_auth_1            in varchar2
160   ,p_cur_appt_auth_2            in varchar2
161   ,p_effective_date             in date
162 
163 
164   );
165 
166 End GHR_CPDF_CHECK5;