[Home] [Help]
PACKAGE: APPS.IGS_FI_PRC_LOCKBOX
Source
1 PACKAGE IGS_FI_PRC_LOCKBOX AUTHID CURRENT_USER AS
2 /* $Header: IGSFI85S.pls 115.4 2003/08/27 09:48:58 shtatiko noship $ */
3
4 /******************************************************************
5 Created By : Amit Gairola
6 Date Created By : 12-Jun-2003
7 Purpose : Package for the Lockbox Processes
8
9 Known limitations,enhancements,remarks:
10 Change History
11 Who When What
12 shtatiko 28-AUG-203 Enh# 3045007, Added two columns, dflt_cr_type_id and balance_amount to LB_RECEIPT_REC
13 pathipat 21-Aug-2003 Enh 3076768 - Automatic Release of Holds build
14 Added column holds_released_yn to LB_RECEIPT_REC
15 ***************************************************************** */
16
17 TYPE LB_INT_REC IS RECORD(row_id ROWID,
18 lockbox_interface_id igs_fi_lockbox_ints.lockbox_interface_id%TYPE,
19 record_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE,
20 record_status igs_fi_lockbox_ints.record_status%TYPE,
21 deposit_date igs_fi_lockbox_ints.deposit_date%TYPE,
22 transmission_record_count igs_fi_lockbox_ints.transmission_record_count%TYPE,
23 transmission_amt igs_fi_lockbox_ints.transmission_amt%TYPE,
24 lockbox_name igs_fi_lockbox_ints.lockbox_name%TYPE,
25 lockbox_batch_count igs_fi_lockbox_ints.lockbox_batch_count%TYPE,
26 lockbox_record_count igs_fi_lockbox_ints.lockbox_record_count%TYPE,
27 lockbox_amt igs_fi_lockbox_ints.lockbox_amt%TYPE,
28 batch_name igs_fi_lockbox_ints.batch_name%TYPE,
29 batch_amt igs_fi_lockbox_ints.batch_amt%TYPE,
30 batch_record_count igs_fi_lockbox_ints.batch_record_count%TYPE,
31 item_number igs_fi_lockbox_ints.item_number%TYPE,
32 receipt_amt igs_fi_lockbox_ints.receipt_amt%TYPE,
33 check_cd igs_fi_lockbox_ints.check_cd%TYPE,
34 party_number igs_fi_lockbox_ints.party_number%TYPE,
35 payer_name igs_fi_lockbox_ints.payer_name%TYPE,
36 charge_cd1 igs_fi_lockbox_ints.charge_cd1%TYPE,
37 charge_cd2 igs_fi_lockbox_ints.charge_cd2%TYPE,
38 charge_cd3 igs_fi_lockbox_ints.charge_cd3%TYPE,
39 charge_cd4 igs_fi_lockbox_ints.charge_cd4%TYPE,
40 charge_cd5 igs_fi_lockbox_ints.charge_cd5%TYPE,
41 charge_cd6 igs_fi_lockbox_ints.charge_cd6%TYPE,
42 charge_cd7 igs_fi_lockbox_ints.charge_cd7%TYPE,
43 charge_cd8 igs_fi_lockbox_ints.charge_cd8%TYPE,
44 applied_amt1 igs_fi_lockbox_ints.applied_amt1%TYPE,
45 applied_amt2 igs_fi_lockbox_ints.applied_amt2%TYPE,
46 applied_amt3 igs_fi_lockbox_ints.applied_amt3%TYPE,
47 applied_amt4 igs_fi_lockbox_ints.applied_amt4%TYPE,
48 applied_amt5 igs_fi_lockbox_ints.applied_amt5%TYPE,
49 applied_amt6 igs_fi_lockbox_ints.applied_amt6%TYPE,
50 applied_amt7 igs_fi_lockbox_ints.applied_amt7%TYPE,
51 applied_amt8 igs_fi_lockbox_ints.applied_amt8%TYPE,
52 credit_type_cd igs_fi_lockbox_ints.credit_type_cd%TYPE,
53 fee_cal_instance_cd igs_fi_lockbox_ints.fee_cal_instance_cd%TYPE,
54 adm_application_id igs_fi_lockbox_ints.adm_application_id%TYPE,
55 attribute_category igs_fi_lockbox_ints.attribute_category%TYPE,
56 attribute1 igs_fi_lockbox_ints.attribute1%TYPE,
57 attribute2 igs_fi_lockbox_ints.attribute2%TYPE,
58 attribute3 igs_fi_lockbox_ints.attribute3%TYPE,
59 attribute4 igs_fi_lockbox_ints.attribute4%TYPE,
60 attribute5 igs_fi_lockbox_ints.attribute5%TYPE,
61 attribute6 igs_fi_lockbox_ints.attribute6%TYPE,
62 attribute7 igs_fi_lockbox_ints.attribute7%TYPE,
63 attribute8 igs_fi_lockbox_ints.attribute8%TYPE,
64 attribute9 igs_fi_lockbox_ints.attribute9%TYPE,
65 attribute10 igs_fi_lockbox_ints.attribute10%TYPE,
66 attribute11 igs_fi_lockbox_ints.attribute11%TYPE,
67 attribute12 igs_fi_lockbox_ints.attribute12%TYPE,
68 attribute13 igs_fi_lockbox_ints.attribute13%TYPE,
69 attribute14 igs_fi_lockbox_ints.attribute14%TYPE,
70 attribute15 igs_fi_lockbox_ints.attribute15%TYPE,
71 attribute16 igs_fi_lockbox_ints.attribute16%TYPE,
72 attribute17 igs_fi_lockbox_ints.attribute17%TYPE,
73 attribute18 igs_fi_lockbox_ints.attribute18%TYPE,
74 attribute19 igs_fi_lockbox_ints.attribute19%TYPE,
75 attribute20 igs_fi_lockbox_ints.attribute20%TYPE,
76 system_record_identifier igs_lookup_values.lookup_code%TYPE);
77
78 TYPE LB_RECEIPT_REC IS RECORD(row_id ROWID,
79 lockbox_interface_id igs_fi_lb_rect_errs.lockbox_interface_id%TYPE,
80 system_record_identifier igs_lookup_values.lookup_code%TYPE,
81 deposit_date igs_fi_lb_rect_errs.deposit_date%TYPE,
82 lockbox_name igs_fi_lb_rect_errs.lockbox_name%TYPE,
83 batch_name igs_fi_lb_rect_errs.batch_name%TYPE,
84 item_number igs_fi_lb_rect_errs.item_number%TYPE,
85 receipt_amt igs_fi_lb_rect_errs.receipt_amt%TYPE,
86 check_cd igs_fi_lb_rect_errs.check_cd%TYPE,
87 party_number igs_fi_lb_rect_errs.party_number%TYPE,
88 mapped_party_id hz_parties.party_id%TYPE,
89 payer_name igs_fi_lb_rect_errs.payer_name%TYPE,
90 charge_cd1 igs_fi_lb_rect_errs.charge_cd1%TYPE,
91 charge_cd2 igs_fi_lb_rect_errs.charge_cd2%TYPE,
92 charge_cd3 igs_fi_lb_rect_errs.charge_cd3%TYPE,
93 charge_cd4 igs_fi_lb_rect_errs.charge_cd4%TYPE,
94 charge_cd5 igs_fi_lb_rect_errs.charge_cd5%TYPE,
95 charge_cd6 igs_fi_lb_rect_errs.charge_cd6%TYPE,
96 charge_cd7 igs_fi_lb_rect_errs.charge_cd7%TYPE,
97 charge_cd8 igs_fi_lb_rect_errs.charge_cd8%TYPE,
98 applied_amt1 igs_fi_lb_rect_errs.applied_amt1%TYPE,
99 applied_amt2 igs_fi_lb_rect_errs.applied_amt2%TYPE,
100 applied_amt3 igs_fi_lb_rect_errs.applied_amt3%TYPE,
101 applied_amt4 igs_fi_lb_rect_errs.applied_amt4%TYPE,
102 applied_amt5 igs_fi_lb_rect_errs.applied_amt5%TYPE,
103 applied_amt6 igs_fi_lb_rect_errs.applied_amt6%TYPE,
104 applied_amt7 igs_fi_lb_rect_errs.applied_amt7%TYPE,
105 applied_amt8 igs_fi_lb_rect_errs.applied_amt8%TYPE,
106 credit_type_cd igs_fi_lb_rect_errs.credit_type_cd%TYPE,
107 mapped_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
108 fee_cal_instance_cd igs_fi_lb_rect_errs.fee_cal_instance_cd%TYPE,
109 mapped_fee_cal_type igs_ca_inst.cal_type%TYPE,
110 mapped_fee_ci_sequence_numbeR igs_ca_inst.sequence_number%TYPE,
111 adm_application_id igs_fi_lb_rect_errs.adm_application_id%TYPE,
112 attribute_category igs_fi_lb_rect_errs.attribute_category%TYPE,
113 attribute1 igs_fi_lb_rect_errs.attribute1%TYPE,
114 attribute2 igs_fi_lb_rect_errs.attribute2%TYPE,
115 attribute3 igs_fi_lb_rect_errs.attribute3%TYPE,
116 attribute4 igs_fi_lb_rect_errs.attribute4%TYPE,
117 attribute5 igs_fi_lb_rect_errs.attribute5%TYPE,
118 attribute6 igs_fi_lb_rect_errs.attribute6%TYPE,
119 attribute7 igs_fi_lb_rect_errs.attribute7%TYPE,
120 attribute8 igs_fi_lb_rect_errs.attribute8%TYPE,
121 attribute9 igs_fi_lb_rect_errs.attribute9%TYPE,
122 attribute10 igs_fi_lb_rect_errs.attribute10%TYPE,
123 attribute11 igs_fi_lb_rect_errs.attribute11%TYPE,
124 attribute12 igs_fi_lb_rect_errs.attribute12%TYPE,
125 attribute13 igs_fi_lb_rect_errs.attribute13%TYPE,
126 attribute14 igs_fi_lb_rect_errs.attribute14%TYPE,
127 attribute15 igs_fi_lb_rect_errs.attribute15%TYPE,
128 attribute16 igs_fi_lb_rect_errs.attribute16%TYPE,
129 attribute17 igs_fi_lb_rect_errs.attribute17%TYPE,
130 attribute18 igs_fi_lb_rect_errs.attribute18%TYPE,
131 attribute19 igs_fi_lb_rect_errs.attribute19%TYPE,
132 attribute20 igs_fi_lb_rect_errs.attribute20%TYPE,
133 credit_id igs_fi_credits.credit_id%TYPE,
134 record_status igs_lookup_values.lookup_code%TYPE,
135 target_invoice_id1 igs_fi_inv_int.invoice_id%TYPE,
136 target_invoice_id2 igs_fi_inv_int.invoice_id%TYPE,
137 target_invoice_id3 igs_fi_inv_int.invoice_id%TYPE,
138 target_invoice_id4 igs_fi_inv_int.invoice_id%TYPE,
139 target_invoice_id5 igs_fi_inv_int.invoice_id%TYPE,
140 target_invoice_id6 igs_fi_inv_int.invoice_id%TYPE,
141 target_invoice_id7 igs_fi_inv_int.invoice_id%TYPE,
142 target_invoice_id8 igs_fi_inv_int.invoice_id%TYPE,
143 act_applied_amt1 igs_fi_applications.amount_applied%TYPE,
144 act_applied_amt2 igs_fi_applications.amount_applied%TYPE,
145 act_applied_amt3 igs_fi_applications.amount_applied%TYPE,
146 act_applied_amt4 igs_fi_applications.amount_applied%TYPE,
147 act_applied_amt5 igs_fi_applications.amount_applied%TYPE,
148 act_applied_amt6 igs_fi_applications.amount_applied%TYPE,
149 act_applied_amt7 igs_fi_applications.amount_applied%TYPE,
150 act_applied_amt8 igs_fi_applications.amount_applied%TYPE,
151 gl_date DATE,
152 source_transaction_type igs_fi_credits.source_transaction_type%TYPE,
153 eligible_to_apply_yn VARCHAR2(5),
154 receipt_number NUMBER(38),
155 holds_released_yn VARCHAR2(5),
156 balance_amount igs_fi_lb_rect_errs.receipt_amt%TYPE,
157 dflt_cr_type_id igs_fi_cr_types.credit_type_id%TYPE);
158
159
160 TYPE LB_INT_TAB IS TABLE OF LB_INT_REC
161 INDEX BY BINARY_INTEGER;
162
163 TYPE LB_RECEIPT_TAB IS TABLE OF LB_RECEIPT_REC
164 INDEX BY BINARY_INTEGER;
165
166 PROCEDURE import_interface_lockbox(errbuf OUT NOCOPY VARCHAR2,
167 retcode OUT NOCOPY NUMBER,
168 p_v_lockbox_name VARCHAR2,
169 p_d_gl_date VARCHAR2,
170 p_v_test_run VARCHAR2);
171
172 PROCEDURE import_error_lockbox( errbuf OUT NOCOPY VARCHAR2,
173 retcode OUT NOCOPY NUMBER,
174 p_v_lockbox_name IN VARCHAR2,
175 p_d_gl_date IN VARCHAR2,
176 p_v_test_run IN VARCHAR2);
177 END igs_fi_prc_lockbox;