1 PACKAGE PAY_JP_CUSTOM_PKG AS
2 /* $Header: pyjpcust.pkh 120.0.12010000.1 2008/07/27 22:57:51 appldev ship $ */
3 -- Actual Values for PAY_JP_PRE_TAX.
4 TYPE value_rec IS RECORD(
5 salary_category VARCHAR2(30),
6 itax_org_id NUMBER,
7 hi_org_id NUMBER,
8 wp_org_id NUMBER,
9 wpf_org_id NUMBER,
10 ui_org_id NUMBER,
11 wai_org_id NUMBER,
12 itax_category VARCHAR2(30),
13 itax_yea_category VARCHAR2(30),
14 ltax_district_code VARCHAR2(30),
15 ltax_swot_no VARCHAR2(30),
16 ui_category VARCHAR2(30),
17 wai_category VARCHAR2(30),
18 taxable_sal_amt NUMBER NOT NULL := 0,
19 taxable_mat_amt NUMBER NOT NULL := 0,
20 hi_prem_ee NUMBER NOT NULL := 0,
21 hi_prem_er NUMBER NOT NULL := 0,
22 ci_prem_ee NUMBER NOT NULL := 0,
23 ci_prem_er NUMBER NOT NULL := 0,
24 wp_prem_ee NUMBER NOT NULL := 0,
25 wp_prem_er NUMBER NOT NULL := 0,
26 wpf_prem_ee NUMBER NOT NULL := 0,
27 wpf_prem_er NUMBER NOT NULL := 0,
28 ui_prem_ee NUMBER NOT NULL := 0,
29 ui_sal_amt NUMBER NOT NULL := 0,
30 wai_sal_amt NUMBER NOT NULL := 0,
31 itax NUMBER NOT NULL := 0,
32 itax_adjustment NUMBER NOT NULL := 0,
33 ltax NUMBER NOT NULL := 0,
34 ltax_lumpsum NUMBER NOT NULL := 0,
35 sp_ltax_district_code VARCHAR2(30),
36 sp_ltax NUMBER NOT NULL := 0,
37 sp_ltax_income NUMBER NOT NULL := 0,
38 sp_ltax_shi NUMBER NOT NULL := 0,
39 sp_ltax_to NUMBER NOT NULL := 0,
40 mutual_aid NUMBER NOT NULL := 0,
41 disaster_tax_reduction NUMBER NOT NULL := 0);
42 -----------------------------------------------------------------------
43 PROCEDURE VALIDATE_RECORD(
44 -----------------------------------------------------------------------
45 p_value IN value_rec,
46 p_action_status OUT NOCOPY VARCHAR2,
47 p_message OUT NOCOPY VARCHAR2);
48
49 -----------------------------------------------------------------------
50 PROCEDURE GET_ITAX_CATEGORY(
51 -----------------------------------------------------------------------
52 p_assignment_action_id IN NUMBER,
53 p_salary_category OUT NOCOPY VARCHAR2,
54 p_itax_category OUT NOCOPY VARCHAR2,
55 p_itax_yea_category OUT NOCOPY VARCHAR2);
56
57 -----------------------------------------------------------------------
58 PROCEDURE FETCH_VALUES(
59 -----------------------------------------------------------------------
60 P_BUSINESS_GROUP_ID IN NUMBER,
61 P_ASSIGNMENT_ACTION_ID IN NUMBER,
62 P_ASSIGNMENT_ID IN NUMBER,
63 P_DATE_EARNED IN DATE,
64 P_VALUE OUT NOCOPY value_rec);
65 END PAY_JP_CUSTOM_PKG;