1 PACKAGE JL_ZZ_AR_LIBRARY_1_PKG AUTHID CURRENT_USER AS
2 /* $Header: jlzzrl1s.pls 120.9 2006/11/21 18:57:21 appradha ship $ */
3
4
5 PROCEDURE get_customer_trx_id (pay_sched_id IN NUMBER,
6 cust_trx_id IN OUT NOCOPY NUMBER,
7 trans_date IN OUT NOCOPY DATE,
8 row_number IN NUMBER,
9 Errcd IN OUT NOCOPY NUMBER);
10
11 PROCEDURE get_amt_within_approval_limits (userid IN NUMBER,
12 amt IN NUMBER,
13 approved_amt IN OUT NOCOPY VARCHAR2,
14 row_number IN NUMBER,
15 Errcd IN OUT NOCOPY NUMBER);
16
17 PROCEDURE get_bank_account_amounts (rcpt_mthd IN NUMBER,
18 bnk_acct IN NUMBER,
19 perc_tol IN OUT NOCOPY NUMBER,
20 amt_tol IN OUT NOCOPY NUMBER,
21 writeoff_rectrx IN OUT NOCOPY NUMBER,
22 writeoff_ccid IN OUT NOCOPY NUMBER,
23 rev_rectrx IN OUT NOCOPY NUMBER,
24 rev_ccid IN OUT NOCOPY NUMBER,
25 calc_intr_ccid IN OUT NOCOPY NUMBER,
26 calc_intr_rectx_id IN OUT NOCOPY NUMBER,
27 row_number IN NUMBER,
28 Errcd IN OUT NOCOPY NUMBER);
29
30 PROCEDURE get_sum_adjustment_amounts (pay_sched_id IN NUMBER,
31 amount_adjusted IN OUT NOCOPY NUMBER,
32 row_number IN NUMBER,
33 Errcd IN OUT NOCOPY NUMBER);
34
35 PROCEDURE get_idm_profiles_from_syspa (trx_type IN OUT NOCOPY VARCHAR2,
36 batch_source IN OUT NOCOPY VARCHAR2,
37 receipt_method IN OUT NOCOPY VARCHAR2,
38 row_number IN NUMBER,
39 Errcd IN OUT NOCOPY NUMBER);
40
41 PROCEDURE get_interest_payment_date (pay_schd_id IN NUMBER,
42 interest_payment_date IN OUT NOCOPY VARCHAR2,
43 row_number IN NUMBER,
44 Errcd IN OUT NOCOPY NUMBER);
45
46 PROCEDURE get_customer_interest_dtls (cust_trx_id IN NUMBER,
47 interest_type IN OUT NOCOPY VARCHAR2,
48 interest_rate_amount IN OUT NOCOPY NUMBER,
49 interest_period IN OUT NOCOPY NUMBER,
50 interest_formula IN OUT NOCOPY VARCHAR2,
51 interest_grace_days IN OUT NOCOPY NUMBER,
52 penalty_type IN OUT NOCOPY VARCHAR2,
53 penalty_rate_amount IN OUT NOCOPY NUMBER,
54 row_number IN NUMBER,
55 Errcd IN OUT NOCOPY NUMBER);
56
57 PROCEDURE get_city_from_ra_addresses (pay_sched_id IN NUMBER,
58 city IN OUT NOCOPY VARCHAR2,
59 row_number IN NUMBER,
60 Errcd IN OUT NOCOPY NUMBER);
61
62 PROCEDURE get_total_receipts (cash_rcpt_id IN NUMBER,
63 tot_rec IN OUT NOCOPY NUMBER,
64 row_number IN NUMBER,
65 Errcd IN OUT NOCOPY NUMBER);
66
67 PROCEDURE get_status_amount_due (amt_due_remain_char IN VARCHAR2,
68 status IN OUT NOCOPY VARCHAR2,
69 row_number IN NUMBER,
70 Errcd IN OUT NOCOPY NUMBER);
71
72 PROCEDURE get_gl_date_closed (amt_due_remain_char IN VARCHAR2,
73 gl_date IN VARCHAR2,
74 gl_date_closed IN OUT NOCOPY VARCHAR2,
75 row_number IN NUMBER,
76 Errcd IN OUT NOCOPY NUMBER);
77
78 PROCEDURE get_actual_date_closed (amt_due_remain_char IN VARCHAR2,
79 gl_date IN VARCHAR2,
80 actual_date_closed IN OUT NOCOPY VARCHAR2,
81 row_number IN NUMBER,
82 Errcd IN OUT NOCOPY NUMBER);
83
84 PROCEDURE get_count_of_receipt_methods (rcpt_class_id IN NUMBER,
85 total_rec IN OUT NOCOPY NUMBER,
86 row_number IN NUMBER,
87 Errcd IN OUT NOCOPY NUMBER);
88
89 PROCEDURE get_collection_method (rcpt_class_id IN NUMBER,
90 collection_method IN OUT NOCOPY NUMBER,
91 row_number IN NUMBER,
92 Errcd IN OUT NOCOPY NUMBER);
93
94 PROCEDURE get_print_immediately_flag (print_immediately_flag IN OUT NOCOPY VARCHAR2,
95 row_number IN NUMBER,
96 Errcd IN OUT NOCOPY NUMBER);
97
98 PROCEDURE get_count_complete_flag (total_records IN OUT NOCOPY NUMBER,
99 row_number IN NUMBER,
100 Errcd IN OUT NOCOPY NUMBER);
101
102 PROCEDURE get_cust_trx_type_status (p_cust_trx_type_id IN NUMBER,
103 class IN OUT NOCOPY VARCHAR2,
104 dfstatus IN OUT NOCOPY VARCHAR2,
105 row_number IN NUMBER,
106 Errcd IN OUT NOCOPY NUMBER);
107
108 PROCEDURE update_doc_status(p_cash_receipt_id IN NUMBER);
109 -- Bug 3610797
110 PROCEDURE get_inv_item_details (fcc_code_type IN VARCHAR2,
111 tran_nat_type IN VARCHAR2,
112 so_org_id IN VARCHAR2,
113 inv_item_id IN NUMBER,
114 fcc_code IN OUT NOCOPY VARCHAR2,
115 tran_nat IN OUT NOCOPY VARCHAR2,
116 item_org IN OUT NOCOPY VARCHAR2,
117 item_ft IN OUT NOCOPY VARCHAR2,
118 fed_trib IN OUT NOCOPY VARCHAR2,
119 sta_trib IN OUT NOCOPY VARCHAR2,
120 row_number IN NUMBER,
121 Errcd IN OUT NOCOPY NUMBER);
122
123 PROCEDURE get_memo_line_details (p_memo_line_id IN NUMBER,
124 item_org IN OUT NOCOPY VARCHAR2,
125 item_ft IN OUT NOCOPY VARCHAR2,
126 fed_trib IN OUT NOCOPY VARCHAR2,
127 sta_trib IN OUT NOCOPY VARCHAR2,
128 row_number IN NUMBER,
129 Errcd IN OUT NOCOPY NUMBER);
130
131 PROCEDURE get_next_seq_number (seq_name IN VARCHAR2,
132 seq_no IN OUT NOCOPY NUMBER,
133 row_number IN NUMBER,
134 Errcd IN OUT NOCOPY NUMBER);
135
136 PROCEDURE get_bearer_of_trade_note (pay_sched_id IN NUMBER,
137 bearer_tr_note IN OUT NOCOPY VARCHAR2,
138 row_number IN NUMBER,
139 Errcd IN OUT NOCOPY NUMBER);
140
141 PROCEDURE get_customer_profile_dtls (bill_to_cust_id IN NUMBER,
142 interest_type IN OUT NOCOPY VARCHAR2,
143 interest_rate_amt IN OUT NOCOPY VARCHAR2,
144 interest_period IN OUT NOCOPY VARCHAR2,
145 interest_formula IN OUT NOCOPY VARCHAR2,
146 interest_grace IN OUT NOCOPY VARCHAR2,
147 penalty_type IN OUT NOCOPY VARCHAR2,
148 penalty_rate_amt IN OUT NOCOPY VARCHAR2,
149 row_number IN NUMBER,
150 Errcd IN OUT NOCOPY NUMBER);
151
152 PROCEDURE get_batch_id (p_batch_source_id IN NUMBER,
153 batch_id IN OUT NOCOPY NUMBER,
154 row_number IN NUMBER,
155 Errcd IN OUT NOCOPY NUMBER);
156
157 PROCEDURE get_tax_base_rate_amt (cust_trx_id IN NUMBER,
158 base_amt IN OUT NOCOPY NUMBER,
159 base_rate IN OUT NOCOPY NUMBER,
160 row_number IN NUMBER,
161 Errcd IN OUT NOCOPY NUMBER);
162
163 PROCEDURE get_issue_date (cust_trx_id IN NUMBER,
164 iss_date IN OUT NOCOPY DATE,
165 row_number IN NUMBER,
166 Errcd IN OUT NOCOPY NUMBER);
167
168 PROCEDURE get_customer_trx_dtls (cust_trx_id IN NUMBER,
169 status IN OUT NOCOPY VARCHAR2,
170 typ_class IN OUT NOCOPY VARCHAR2,
171 row_number IN NUMBER,
172 Errcd IN OUT NOCOPY NUMBER);
173
174 PROCEDURE get_class (p_trx_number IN VARCHAR2,
175 p_class IN OUT NOCOPY VARCHAR2,
176 row_number IN NUMBER,
177 Errcd IN OUT NOCOPY NUMBER);
178
179 PROCEDURE get_prev_interest_values(p_applied_payment_schedule_id IN NUMBER,
180 p_cash_receipt_id IN NUMBER,
181 p_apply_date IN DATE,
182 p_main_amnt_rec OUT NOCOPY VARCHAR2,
183 p_base_int_calc OUT NOCOPY VARCHAR2,
184 p_calculated_interest OUT NOCOPY VARCHAR2,
185 p_received_interest OUT NOCOPY VARCHAR2,
186 p_int_diff_action OUT NOCOPY VARCHAR2,
187 p_int_writeoff_reason OUT NOCOPY VARCHAR2,
188 p_payment_date OUT NOCOPY VARCHAR2,
189 p_writeoff_date OUT NOCOPY VARCHAR2,
190 Errcd IN OUT NOCOPY NUMBER);
191
192 PROCEDURE get_interest_reversal_flag(p_cash_receipt_id IN NUMBER,
193 p_interest_reversal OUT NOCOPY BOOLEAN,
194 Errcd IN OUT NOCOPY NUMBER);
195
196 PROCEDURE get_adjustment_record(p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,
197 p_user_id IN NUMBER,
198 p_amount IN NUMBER,
199 p_receipt_date IN DATE,
200 p_cash_receipt_id IN NUMBER,
201 p_customer_trx_id IN NUMBER,
202 p_pay_sched_id IN NUMBER,
203 p_rectrx_id IN NUMBER,
204 p_status IN VARCHAR2,
205 Errcd IN OUT NOCOPY NUMBER);
206
207 PROCEDURE get_warehouse_info(p_customer_trx_id IN NUMBER,
208 p_warehouse_count OUT NOCOPY NUMBER);
209
210 PROCEDURE get_warehouse_id(p_customer_trx_id IN NUMBER,
211 p_warehouse_id OUT NOCOPY NUMBER);
212
213 PROCEDURE get_void_trx_type_id(p_country_code IN VARCHAR2,
214 p_void_trx_type_id OUT NOCOPY NUMBER,
215 Errcd IN OUT NOCOPY NUMBER);
216
217 PROCEDURE get_city_from_ra_addresses (pay_sched_id IN NUMBER,
218 city IN OUT NOCOPY VARCHAR2,
219 row_number IN NUMBER,
220 Errcd IN OUT NOCOPY NUMBER,
221 state IN OUT NOCOPY VARCHAR2);
222
223 PROCEDURE get_dbms_sql_native (x_dbms_sql_native OUT NOCOPY INTEGER); --Bugs 2952004 / 2939830
224
225 END JL_ZZ_AR_LIBRARY_1_PKG;