1 PACKAGE ARP_PROCESS_LOCKBOX AUTHID CURRENT_USER AS
2 /*$Header: ARRPRLBS.pls 120.9 2011/01/09 08:49:14 kknekkal ship $ */
3 --
4 PROCEDURE auto_associate(
5 p_transmission_id IN VARCHAR2,
6 p_payment_rec_type IN VARCHAR2,
7 p_overflow_rec_type IN VARCHAR2,
8 p_item_num IN ar_payments_interface.item_number%type,
9 p_batch_name IN ar_payments_interface.batch_name%type,
10 p_lockbox_number IN ar_payments_interface.lockbox_number%type,
11 p_batches IN VARCHAR2,
12 p_only_one_lb IN VARCHAR2,
13 p_use_matching_date IN ar_lockboxes.use_matching_date%type,
14 p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,
15 p_pay_unrelated_invoices IN VARCHAR2,
16 p_out_customer_id OUT NOCOPY NUMBER,
17 p_out_customer_identified OUT NOCOPY NUMBER
18 );
19 --
20 PROCEDURE populate_resolved_columns(
21 p_transmission_id IN VARCHAR2,
22 p_payment_rec_type IN VARCHAR2,
23 p_overflow_rec_type IN VARCHAR2,
24 p_item_num IN ar_payments_interface.item_number%type,
25 p_batch_name IN ar_payments_interface.batch_name%type,
26 p_lockbox_number IN ar_payments_interface.lockbox_number%type,
27 p_batches IN VARCHAR2,
28 p_only_one_lb IN VARCHAR2,
29 p_use_matching_date IN ar_lockboxes.use_matching_date%type,
30 p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,
31 p_pay_unrelated_invoices IN VARCHAR2
32 );
33 --
34 PROCEDURE
35 find_cust_and_trx_num(
36 p_transmission_id IN VARCHAR2,
37 p_payment_rec_type IN VARCHAR2,
38 p_overflow_rec_type IN VARCHAR2,
39 p_item_num IN ar_payments_interface.item_number%type,
40 p_batch_name IN ar_payments_interface.batch_name%type,
41 p_lockbox_number IN ar_payments_interface.lockbox_number%type,
42 p_receipt_date IN ar_payments_interface.receipt_date%type,
43 p_batches IN VARCHAR2,
44 p_only_one_lb IN VARCHAR2,
45 p_use_matching_date IN ar_lockboxes.use_matching_date%type,
46 p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,
47 p_pay_unrelated_invoices IN VARCHAR2,
48 p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,
49 p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
50 p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
51 p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
52 p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
53 p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
54 p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
55 p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
56 p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
57 p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
58 p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
59 p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
60 p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
61 p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
62 p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
63 p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
64 p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
65 p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
66 p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
67 p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
68 p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
69 p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
70 p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,
71 p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,
72 p_matched_flag OUT NOCOPY VARCHAR2,
73 p_customer_id IN OUT NOCOPY NUMBER,
74 p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,
75 p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,
76 p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
77 p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
78 p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
79 p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
80 p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
81 p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,
82 p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type
83 );
84 --
85 PROCEDURE
86 get_cursor_name(
87 p_matching_option IN ar_lookups.lookup_code%type,
88 p_cursor_name OUT NOCOPY INTEGER,
89 p_match_successful OUT NOCOPY BOOLEAN
90 );
91 --
92 PROCEDURE
93 validate_llca_interface_data(
94 p_trans_request_id IN varchar2,
95 p_allow_invalid_trx_num IN varchar2,
96 p_format_amount IN varchar2,
97 p_return_status OUT NOCOPY varchar2
98 );
99 --
100 PROCEDURE
101 insert_interim_line_details(
102 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
103 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%type,
104 p_cash_receipt_line_id IN NUMBER,
105 p_trans_req_id IN ar_payments_interface.transmission_request_id%type,
106 p_batch_name IN ar_payments_interface.batch_name%type,
107 p_item_num IN ar_payments_interface.item_number%type,
108 p_return_status OUT NOCOPY varchar2
109 );
110 --
111 PROCEDURE
112 close_cursors;
113 --
114 PROCEDURE
115 debug1(str IN VARCHAR2);
116 --
117 FUNCTION get_format_amount(
118 p_trans_req_id IN NUMBER,
119 p_trans_rec_id IN NUMBER,
120 p_column_type IN varchar2
121 )
122 RETURN VARCHAR2;
123 --
124 END arp_process_lockbox;