1 PACKAGE PAY_JP_CUSTOM_PKG AUTHID CURRENT_USER AS
2 /* $Header: pyjpcust.pkh 120.0.12020000.3 2012/08/17 13:02:05 mdubasi 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_assignment_id IN number,
47 p_locking_assignment_action_id IN NUMBER,
48 p_locked_assignment_action_id IN NUMBER,
49 p_action_status OUT NOCOPY VARCHAR2,
50 p_message OUT NOCOPY VARCHAR2);
51
52 -----------------------------------------------------------------------
53 PROCEDURE GET_ITAX_CATEGORY(
54 -----------------------------------------------------------------------
55 p_assignment_action_id IN NUMBER,
56 p_salary_category OUT NOCOPY VARCHAR2,
57 p_itax_category OUT NOCOPY VARCHAR2,
58 p_itax_yea_category OUT NOCOPY VARCHAR2);
59
60 -----------------------------------------------------------------------
61 PROCEDURE FETCH_VALUES(
62 -----------------------------------------------------------------------
63 P_BUSINESS_GROUP_ID IN NUMBER,
64 P_ASSIGNMENT_ACTION_ID IN NUMBER,
65 P_ASSIGNMENT_ID IN NUMBER,
66 P_DATE_EARNED IN DATE,
67 P_VALUE OUT NOCOPY value_rec);
68 END PAY_JP_CUSTOM_PKG;