1 package GHR_CPDF_CHECK7 as
2 /* $Header: ghcpdf07.pkh 120.0.12000000.2 2007/02/14 11:35:48 utokachi noship $ */
3
4 -- <Precedure Info>
5 -- Name:
6 -- Prior BASIC PAY
7 -- Sections in CPDF:
8 -- C65 - C70
9 -- Note:
10 --
11 --
12 procedure chk_prior_basic_pay
13 (p_prior_pay_plan in varchar2 /* Non-SF52 Data Item */
14 ,p_pay_determinant_code in varchar2
15 ,p_prior_pay_rate_det_code in varchar2 /* Non-SF52 Data Item */
16 ,p_prior_basic_pay in varchar2 /* Non-SF52 Data Item */
17 ,p_retained_pay_plan in varchar2 /* Non-SF52 Data Item */
18 ,p_retained_grade in varchar2 /* Non-SF52 Data Item */
19 ,p_retained_step in varchar2 /* Non-SF52 Data Item */
20 ,p_agency_subelement in varchar2 /* Non-SF52 Data Item */
21 ,p_prior_grade_or_level in varchar2 /* Non-SF52 Data Item */
22 ,p_prior_step_or_rate in varchar2 /* Non-SF52 Data Item */
23 ,p_prior_pay_basis in varchar2 /* Non-SF52 Data Item */
24 ,p_first_noac_lookup_code in varchar2
25 ,p_to_basic_pay in varchar2
26 ,p_to_pay_basis in varchar2
27 ,p_effective_date in date
28 ,p_prior_effective_date in date
29 );
30
31
32 --
33 -- <Precedure Info>
34 -- Name:
35 -- Locality Adjustment
36 -- Sections in CPDF:
37 -- C82 - C85
38 -- Note:
39 --
40 --
41 /* Table 25 contains up to a maximum of 3 percentages.
42 The locality adjustment amount will pass the lookup if, as a percentage of basic pay,
43 it represents any percentage shown for the locality area, with the "as of date" of the
44 file falling within the date range, on Table 25. (If a more percise check is needed,
45 as is the case of area 41, a subsequent relationship edit will catch the error.)
46 Locality pay is generated within CPDF according to the duty station. For definitions,
47 see the Guide to Personnel Data Standards. */
48
49 procedure chk_locality_adj
50 (p_to_pay_plan in varchar2
51 ,p_to_basic_pay in varchar2
52 ,p_pay_rate_determinant_code in varchar2
53 ,p_retained_pay_plan in varchar2
54 ,p_prior_pay_plan in varchar2
55 ,p_prior_pay_rate_det_code in varchar2 /* Non-SF52 Data Item */
56 ,p_locality_pay_area in varchar2 /* Non-SF52 Data Item */
57 ,p_to_locality_adj in varchar2
58 ,p_effective_date in date
59 ,p_as_of_date in date /* Non-SF52 */
60 ,p_first_noac_lookup_code in varchar2
61 ,p_agency_subelement in varchar2
62 ,p_duty_station_code in varchar2
63 ,p_special_pay_table_id in varchar2 --Bug# 5745356(upd50)
64 );
65
66
67 --
68 -- <Precedure Info>
69 -- Name:
70 -- PRIOR LOCALITY ADJUSTMENT
71 -- Sections in CPDF:
72 -- C86, C87
73 -- Note:
74 --
75
76 procedure chk_prior_locality_adj
77 (p_to_pay_plan in varchar2
78 ,p_to_basic_pay in varchar2
79 ,p_prior_pay_plan in varchar2
80 ,p_pay_rate_determinant_code in varchar2
81 ,p_retained_pay_plan in varchar2
82 ,p_prior_pay_rate_det_code in varchar2 /* Non-SF52 Data Item */
83 ,p_locality_pay_area in varchar2 /* Non-SF52 Data Item */
84 ,p_prior_locality_pay_area in varchar2 /* Non-SF52 Data Item */
85 ,p_prior_basic_pay in varchar2
86 ,p_to_locality_adj in varchar2
87 ,p_prior_locality_adj in varchar2 /* Non-SF52 Data Item */
88 ,p_prior_loc_adj_effective_date in date
89 ,p_first_noac_lookup_code in varchar2
90 ,p_as_of_date in date /* Non-SF52 */
91 ,p_agency_subelement in varchar2
92 ,p_prior_duty_station in varchar2
93 ,p_effective_date in date
94 );
95
96 end GHR_CPDF_CHECK7;