1 package pay_kr_paykryrs_pkg as
2 /* $Header: paykryrs.pkh 120.8 2007/11/30 15:36:17 vaisriva noship $ */
3 ------------------------------------------------------------------------
4 function get_balance_value( p_assignment_id number,
5 p_year number,
6 p_ytd_balance_name varchar2) return number;
7
8 procedure data(
9 p_assignment_id in number,
10 p_year in number,
11 ----------------Education Exp--------------------
12 p_edu_p_count out nocopy number,
13 p_edu_h_count out nocopy number,
14 p_edu_u_count out nocopy number,
15 p_edu_d_count out nocopy number,
16 p_edu_exp_p out nocopy number,
17 p_edu_exp_h out nocopy number,
18 p_edu_exp_u out nocopy number,
19 p_edu_exp_d out nocopy number,
20 p_edu_exp_total out nocopy number,
21 --------------- Housing Saving Total--------------
22 p_hou_exp out nocopy number,
23 --------------- Special Exems --------------------
24 p_pers_ins_prem out nocopy number,
25 p_dis_ins_prem out nocopy number,
26 p_gen_med_exp out nocopy number,
27 p_emp_aged_dis_med_exp out nocopy number,
28 p_med_exp_card out nocopy number, -- Bug 4336742
29 p_hou_loan_repay out nocopy number,
30 p_lt_hou_int_repay out nocopy number,
31 p_donations out nocopy number,
32 p_emp_educ out nocopy number,
33 p_sp_prem_hi_sub out nocopy number,
34 p_sp_prem_ei_sub out nocopy number,
35 p_100p_donation out nocopy number,
36 p_50p_donation out nocopy number,
37 p_30p_donation out nocopy number,
38 p_10p_donation out nocopy number,
39 p_political_donation out nocopy number,
40 p_marr_reloc_funr_exem out nocopy number,
41 p_lt_hou_int_repay_gt_15 out nocopy number,
42 --------------- Other Exems --------------------
43 p_pers_pen_prem out nocopy number,
44 p_pers_pen_sav out nocopy number,
45 p_inv_part_fin2 out nocopy number,
46 p_emp_crd_exp out nocopy number,
47 p_dep_crd_exp out nocopy number,
48 p_emp_stk_opt out nocopy number,
49 p_tuition_giro out nocopy number,
50 p_cash_receipt out nocopy number, -- Bug 4336742
51 p_other_exem_np_prem out nocopy number,
52 p_other_exem_pen_prem out nocopy number, -- Bug 6655323
53 --------------- Tax Breaks -----------------------
54 p_hou_loan_int_repay_break out nocopy number,
55 p_lt_stk_sav1 out nocopy number,
56 p_lt_stk_sav2 out nocopy number,
57 --------------- FW Info --------------------------
58 p_emp_fw_exp out nocopy number,
59 --------------- Ovs Tax Break --------------------
60 p_ovs_tax_paid_fc out nocopy number,
61 p_ovs_tax_paid_lc out nocopy number,
62 p_ovs_country out nocopy varchar2,
63 p_ovs_paid_date out nocopy varchar2,
64 p_ovs_submit_date out nocopy varchar2,
65 p_ovs_location out nocopy varchar2,
66 p_ovs_period out nocopy varchar2,
67 p_ovs_title out nocopy varchar2,
68 --------------- FW Tax Break ---------------------
69 p_immigration_purpose out nocopy varchar2,
70 p_fw_contract_date out nocopy varchar2,
71 p_fw_expiry_date out nocopy varchar2,
72 p_fw_application_date out nocopy varchar2,
73 p_fw_submit_date out nocopy varchar2,
74 --------------- Prev Employer Info ---------------
75 p_total_hi_prem out nocopy number,
76 p_total_ei_prem out nocopy number,
77 p_total_np_prem out nocopy number,
78 p_total_pen_prem out nocopy number, /* Bug 6655323 */
79 --------------- Balance Values -------------------
80 p_np_prem_main out nocopy number,
81 p_pen_prem_main out nocopy number, /* Bug 6655323 */
82 p_ei_prem_main out nocopy number,
83 p_hi_prem_main out nocopy number,
84 p_corp_pension out nocopy number,
85 p_emp_ins_included out nocopy varchar2,
86 p_emp_med_included out nocopy varchar2,
87 p_emp_edu_included out nocopy varchar2,
88 p_emp_card_included out nocopy varchar2
89 );
90
91 procedure EMP_EXPENSE_DETAILS (p_emp_assignment_id in number
92 ,p_year in number
93 ,p_emp_ins_exp_nts out nocopy number
94 ,p_emp_ins_exp_oth out nocopy number
95 ,p_emp_med_exp_nts out nocopy number
96 ,p_emp_med_exp_oth out nocopy number
97 ,p_emp_edu_exp_nts out nocopy number
98 ,p_emp_edu_exp_oth out nocopy number
99 ,p_emp_card_exp_nts out nocopy number
100 ,p_emp_card_exp_oth out nocopy number
101 ,p_emp_cash_exp_nts out nocopy number
102 ,p_emp_don_exp_nts out nocopy number
103 ,p_emp_don_exp_oth out nocopy number);
104
105 /* Bug 5856504 Modified parameter name in the function EMP_EXPENSE_DETAILS */
106 function EMP_EXPENSE_DETAILS (p_assignment_id in number
107 ,p_year in number
108 ,p_emp_ins_exp_nts out nocopy number
109 ,p_emp_ins_exp_oth out nocopy number
110 ,p_emp_med_exp_nts out nocopy number
111 ,p_emp_med_exp_oth out nocopy number
112 ,p_emp_edu_exp_nts out nocopy number
113 ,p_emp_edu_exp_oth out nocopy number
114 ,p_emp_card_exp_nts out nocopy number
115 ,p_emp_card_exp_oth out nocopy number
116 ,p_emp_cash_exp_nts out nocopy number
117 ,p_emp_don_exp_nts out nocopy number
118 ,p_emp_don_exp_oth out nocopy number) return number;
119
120
121
122 end pay_kr_paykryrs_pkg;