1 PACKAGE GHR_CPDF_CHECK AUTHID CURRENT_USER AS
2 /* $Header: ghcpdf00.pkh 120.4 2011/02/14 10:40:40 utokachi ship $ */
3
4 -- <Precedure Info>
5 -- Name:
6 -- call_CPDF_Check
7 -- Note:
8 --
9 --
10
11 PROCEDURE call_CPDF_Check
12 (
13 p_academic_discipline in varchar2
14 ,p_Adj_Base_Pay in number
15 ,p_Agency in varchar2 -- Non-SF52 Data Item
16 ,p_agency_subelement in varchar2 -- Non-SF52 Data Item
17 ,p_as_of_date in date -- Non-SF52 Data Item
18 ,p_Benefit_Amount in varchar2 -- Non-SF52 Data Item
19 ,p_bargaining_unit_status_code in varchar2
20 ,p_citizenship in varchar2
21 ,p_credit_mil_svc in varchar2 -- Non-SF52 Data Item
22 ,p_Cur_Appt_Auth_1 in varchar2 -- non SF52 item
23 ,p_Cur_Appt_Auth_2 in varchar2 -- non SF52 item
24 ,p_Duty_Station_Lookup_Code in varchar2
25 ,p_education_level in varchar2
26 ,p_effective_date in date
27 ,p_Employee_Date_of_Birth in date
28 ,p_Employee_First_Name in varchar2
29 ,p_Employee_Last_Name in varchar2
30 ,p_employee_National_ID in varchar2
31 ,p_fegli_code in varchar2
32 ,p_fers_coverage in varchar2 -- Non-SF52 Data Item
33 ,p_First_Action_NOA_LA_Code1 in varchar2
34 ,p_First_Action_NOA_LA_Code2 in varchar2
35 ,p_First_NOAC_Lookup_Code in varchar2
36 -- Bug#4486823 RRR Changes
37 ,p_First_NOAC_Lookup_desc in varchar2
38 ,p_flsa_category in varchar2
39 ,p_functional_class in varchar2
40 ,p_health_plan in varchar2 -- Non-SF52 Data Item
41 ,p_Handicap in varchar2 -- Non-SF52 Data Item
42 ,p_Indiv_Award in varchar2 -- Non-SF52 Data Item
43 ,p_locality_pay_area in varchar2 -- Non-SF52 Data Item
44 ,p_Occupation_code in varchar2 -- Non-SF52 Data Item
45 ,p_One_Time_Payment_Amount in number
46 ,p_Organ_Component in varchar2 -- Non-SF52 Data Item
47 ,p_pay_rate_determinant_code in varchar2
48 ,p_Personnel_Officer_ID in varchar2 -- Non-SF52 Data Item
49 ,p_Position_Occ_Code in varchar2
50 ,p_Prior_Basic_Pay in varchar2 -- Non-SF52 Data Item
51 ,p_prior_duty_station in varchar2 -- Non-SF52 Data Item
52 ,p_Prior_Grade_Or_Level in varchar2 -- Non-SF52 Data Item
53 ,p_Prior_Locality_Adj in varchar2 -- Non-SF52 Data Item
54 ,p_prior_locality_pay_area in varchar2 -- Non-SF52 Data Item
55 ,p_Prior_Occupation_code in varchar2 -- Non-SF52 Data Item
56 ,p_Prior_Pay_Basis in varchar2 -- Non-SF52 Data Item
57 ,p_Prior_Pay_Plan in varchar2 -- Non-SF52 Data Item
58 ,p_Prior_Pay_Rate_Det_Code in varchar2 -- Non-SF52 Data Item
59 ,p_Prior_Step_Or_Rate in varchar2 -- Non-SF52 Data Item
60 ,p_prior_work_schedule_code in varchar2 -- Non-SF52 Data Item
61 ,p_Production_Date in date -- Non-SF52 Data Item
62 ,p_Race_National_Region in varchar2 -- Non-SF52 Data Item
63 ,p_rating_of_record_level in varchar2 -- Non-SF52 Data Item
64 ,p_rating_of_record_pattern in varchar2 -- Non-SF52 Data Item
65 ,p_rating_of_record_period in varchar2 -- Non-SF52 Data Item
66 -- Bug 4753117 added new parameter
67 ,p_rating_of_record_per_starts in varchar2 -- Non-SF52 Data Item
68 ,p_retain_grade in varchar2 -- Non-SF52 Data Item
69 ,p_retain_pay_plan in varchar2
70 ,p_retain_step in varchar2 -- Non-SF52 Data Item
71 ,p_Retirement_Plan_Code in varchar2
72 ,p_Retention_Allowance in varchar2 -- Non-SF52 Data Item
73 ,p_Second_NOAC_Lookup_code in varchar2
74 ,p_Service_Computation_Date in Date
75 ,p_Sex in varchar2 -- Non-SF52 Data Item
76 ,p_special_pay_table_id in varchar2 -- Non-SF52 Data Item
77 ,p_staffing_differential in varchar2 -- Non-SF52 Data Item
78 ,p_submission_date in date -- Non-SF52 Data Item
79 ,p_supervisory_differential in varchar2 -- Non-SF52 Data Item
80 ,p_Supervisory_Status_Code in varchar2
81 ,p_Tenure_Group_Code in varchar2
82 ,p_To_Basic_Pay in varchar2
83 ,p_To_Grade_Or_Level in varchar2
84 ,p_To_Locality_Adj in varchar2
85 ,p_To_Pay_Basis in varchar2
86 ,p_To_Pay_Plan in varchar2
87 ,p_to_pay_status in varchar2 -- Non-SF52 Data Item
88 ,p_To_Step_Or_Rate in varchar2
89 ,p_Veterans_Preference_Code in varchar2
90 ,p_Veterans_Status_Code in varchar2
91 ,p_work_schedule_code in varchar2
92 ,p_year_degree_attained in varchar2
93 ,p_assignment_id in number
94 ,p_noa_family_code in varchar2
95 ,p_prior_effective_date in date
96 ,p_prior_loc_adj_effective_date in date
97 ,p_rpa_step_or_rate in varchar2
98 ,p_ethnic_race_info in varchar2 -- Bug 4724337 Race or National Origin changes
99 --Bug# 11726461
100 ,p_scd_leave in date
101 ,p_scd_retirement in date
102 --Bug# 11726461
103 );
104
105 FUNCTION get_basic_pay
106 (table_name in varchar2
107 ,row_name in varchar2
108 ,column_name in varchar2
109 ,effective_date in date)
110 RETURN NUMBER;
111
112 end GHR_CPDF_CHECK;