[Home] [Help]
PACKAGE: APPS.PAY_KR_WG_PKG
Source
1 PACKAGE pay_kr_wg_pkg AUTHID CURRENT_USER AS
2 /* $Header: pykrffwg.pkh 120.3.12000000.1 2007/01/17 22:04:48 appldev noship $ */
3
4 TYPE t_court_orders IS RECORD
5 (
6 element_entry_id pay_element_entries_f.element_entry_id%type,
7 attachment_sequence_no VARCHAR2(100),
8 court_order_start_date DATE,
9 reception_time VARCHAR2(10),
10 case_number VARCHAR2(100),
11 processing_type VARCHAR2(2),
12 principal_base NUMBER DEFAULT 0,
13 court_fee_base NUMBER DEFAULT 0,
14 interest_base NUMBER DEFAULT 0,
15 interest_from_date1 DATE,
16 interest_to_date1 DATE,
17 interest_rate1 NUMBER DEFAULT 0,
18 interest_calculation_base1 NUMBER DEFAULT 0,
19 interest_from_date2 DATE,
20 interest_to_date2 DATE,
21 interest_rate2 NUMBER DEFAULT 0,
22 interest_calculation_base2 NUMBER DEFAULT 0,
23 interest_from_date3 DATE,
24 interest_to_date3 DATE,
25 interest_rate3 NUMBER DEFAULT 0,
26 interest_calculation_base3 NUMBER DEFAULT 0,
27 interest_from_date4 DATE,
28 interest_to_date4 DATE,
29 interest_rate4 NUMBER DEFAULT 0,
30 interest_calculation_base4 NUMBER DEFAULT 0,
31 interest_from_date5 DATE,
32 interest_to_date5 DATE,
33 interest_rate5 NUMBER DEFAULT 0,
34 interest_calculation_base5 NUMBER DEFAULT 0,
35 previous_case_number VARCHAR2(100),
36 payout_date DATE,
37 court_order_origin VARCHAR2(30),
38 previous_payout_date DATE,
39 obligation_release VARCHAR2(1),
40 -- Bug : 4866417
41 obligation_release_processed VARCHAR2(1),
42 stop_flag VARCHAR2(1),
43 attachment_total_base NUMBER DEFAULT 0,
44 interest_amount NUMBER DEFAULT 0,
45 real_attach_total_by_creditor NUMBER DEFAULT 0,
46 emp_attach_total_by_creditor NUMBER DEFAULT 0,
47 wg_adjusted_amount NUMBER DEFAULT 0,
48 wg_adjustment_amount NUMBER DEFAULT 0,
49 distribution_base NUMBER DEFAULT 0,
50 distribution_rate NUMBER DEFAULT 0,
51 curr_emp_paid_amt_by_creditor NUMBER DEFAULT 0,
52 out_message VARCHAR2(50) DEFAULT 'XYZ'
53 );
54
55 TYPE tab_court_orders IS TABLE OF t_court_orders INDEX BY BINARY_INTEGER;
56
57 g_court_orders tab_court_orders;
58
59 TYPE t_emp_total IS RECORD
60 (
61 emp_attach_total NUMBER DEFAULT 0,
62 distribution_base NUMBER DEFAULT 0,
63 curr_emp_paid_amt NUMBER DEFAULT 0,
64 attachable_earnings NUMBER DEFAULT 0,
65 wg_adjustment NUMBER DEFAULT 0,
66 wg_adjusted NUMBER DEFAULT 0
67 );
68
69 TYPE t_actual_attach IS RECORD
70 (
71 d_actual_attach_date DATE,
72 c_actual_attach_prev_case VARCHAR2(100),
73 c_actual_attach_case_found VARCHAR2(1) DEFAULT 'N'
74 );
75
76 TYPE tab_actual_attach IS TABLE OF t_actual_attach INDEX BY BINARY_INTEGER;
77
78 g_last_assignment_processed NUMBER;
79
80 FUNCTION calc_wage_garnishment( p_assignment_id IN NUMBER,
81 p_assignment_action_id IN NUMBER,
82 p_date_earned IN DATE,
83 p_element_entry_id IN NUMBER,
84 p_net_earnings IN NUMBER,
85 p_run_type IN VARCHAR2,
86 p_attachment_amount OUT NOCOPY NUMBER,
87 p_adjusted_amount OUT NOCOPY NUMBER,
88 p_attach_total_base OUT NOCOPY NUMBER,
89 p_real_attach_total OUT NOCOPY NUMBER,
90 p_emp_attach_total OUT NOCOPY NUMBER,
91 p_interest_amount OUT NOCOPY NUMBER,
92 p_adjustment_amount OUT NOCOPY NUMBER,
93 p_unadjusted_amount OUT NOCOPY NUMBER,
94 p_stop_flag OUT NOCOPY VARCHAR2,
95 p_message OUT NOCOPY VARCHAR2,
96 p_curr_attach_seq_no OUT NOCOPY VARCHAR2,
97 p_curr_case_number OUT NOCOPY VARCHAR2,
98 p_payout_date OUT NOCOPY DATE,
99 p_date_paid IN DATE,
100 p_wg_attach_earnings_mtd IN NUMBER,
101 p_wg_deductions_mtd IN NUMBER
102 ) RETURN NUMBER;
103
104 FUNCTION calc_wage_garnishment( p_assignment_id IN NUMBER,
105 p_assignment_action_id IN NUMBER,
106 p_date_earned IN DATE,
107 p_attachment_seq_no IN VARCHAR2,
108 p_net_earnings IN NUMBER,
109 p_run_type IN VARCHAR2,
110 p_attachment_amount OUT NOCOPY NUMBER,
111 p_adjusted_amount OUT NOCOPY NUMBER,
112 p_attach_total_base OUT NOCOPY NUMBER,
113 p_real_attach_total OUT NOCOPY NUMBER,
114 p_emp_attach_total OUT NOCOPY NUMBER,
115 p_interest_amount OUT NOCOPY NUMBER,
116 p_adjustment_amount OUT NOCOPY NUMBER,
117 p_unadjusted_amount OUT NOCOPY NUMBER,
118 p_stop_flag OUT NOCOPY VARCHAR2,
119 p_message OUT NOCOPY VARCHAR2,
120 p_curr_attach_seq_no OUT NOCOPY VARCHAR2,
121 p_curr_case_number OUT NOCOPY VARCHAR2,
122 p_payout_date OUT NOCOPY DATE,
123 p_date_paid IN DATE,
124 p_wg_attach_earnings_mtd IN NUMBER,
125 p_wg_deductions_mtd IN NUMBER
126
127 ) RETURN NUMBER;
128
129 -- Bug 2856663 : parameter p_assignment_id added.
130
131 FUNCTION attachment_seq_no_is_valid (p_assignment_id IN NUMBER,
132 p_element_entry_id IN NUMBER,
133 p_attachment_seq_no IN VARCHAR2
134 ) RETURN VARCHAR2;
135
136 end pay_kr_wg_pkg;