eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ARP_PROCESS_LOCKBOX dependencies on AR_PAYMENTS_INTERFACE

Line 42: | record in ar_payments_interface for returned trx_number, trx_date and

38: | Call find_cust_and_trx_num for each payment/overflow record to get the
39: | customer id and trx numbers.
40: | If find_cust_and_trx_num returns matched_flag = TRUE, then compare the
41: | l_customer_id with l_prev_customer_id. If they are same update the
42: | record in ar_payments_interface for returned trx_number, trx_date and
43: | installment number.
44: | If find_cust_and_trx_num returns matched_flag = FALSE, then rollback
45: | the updates for current item number.
46: | If all the customers are same for given item number,

Line 53: | column in ar_payments_interface.

49: |
50: | Modification History
51: | 28-Jul-97 K Trivedi Created.
52: | 24-Sep-97 K Trivedi Modified to populate match_resolved_using
53: | column in ar_payments_interface.
54: ----------------------------------------------------------------------------*/
55: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
56:
57: PROCEDURE auto_associate(

Line 61: p_item_num IN ar_payments_interface.item_number%type,

57: PROCEDURE auto_associate(
58: p_transmission_id IN VARCHAR2,
59: p_payment_rec_type IN VARCHAR2,
60: p_overflow_rec_type IN VARCHAR2,
61: p_item_num IN ar_payments_interface.item_number%type,
62: p_batch_name IN ar_payments_interface.batch_name%type,
63: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
64: p_batches IN VARCHAR2,
65: p_only_one_lb IN VARCHAR2,

Line 62: p_batch_name IN ar_payments_interface.batch_name%type,

58: p_transmission_id IN VARCHAR2,
59: p_payment_rec_type IN VARCHAR2,
60: p_overflow_rec_type IN VARCHAR2,
61: p_item_num IN ar_payments_interface.item_number%type,
62: p_batch_name IN ar_payments_interface.batch_name%type,
63: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
64: p_batches IN VARCHAR2,
65: p_only_one_lb IN VARCHAR2,
66: p_use_matching_date IN ar_lockboxes.use_matching_date%type,

Line 63: p_lockbox_number IN ar_payments_interface.lockbox_number%type,

59: p_payment_rec_type IN VARCHAR2,
60: p_overflow_rec_type IN VARCHAR2,
61: p_item_num IN ar_payments_interface.item_number%type,
62: p_batch_name IN ar_payments_interface.batch_name%type,
63: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
64: p_batches IN VARCHAR2,
65: p_only_one_lb IN VARCHAR2,
66: p_use_matching_date IN ar_lockboxes.use_matching_date%type,
67: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,

Line 76: l_item_num ar_payments_interface.item_number%type;

72: --
73: l_transmission_id VARCHAR2(50);
74: l_payment_rec_type VARCHAR2(3);
75: l_overflow_rec_type VARCHAR2(3);
76: l_item_num ar_payments_interface.item_number%type;
77: l_batch_name ar_payments_interface.batch_name%type;
78: l_lockbox_number ar_payments_interface.lockbox_number%type;
79: l_batches VARCHAR2(2);
80: l_only_one_lb VARCHAR2(2);

Line 77: l_batch_name ar_payments_interface.batch_name%type;

73: l_transmission_id VARCHAR2(50);
74: l_payment_rec_type VARCHAR2(3);
75: l_overflow_rec_type VARCHAR2(3);
76: l_item_num ar_payments_interface.item_number%type;
77: l_batch_name ar_payments_interface.batch_name%type;
78: l_lockbox_number ar_payments_interface.lockbox_number%type;
79: l_batches VARCHAR2(2);
80: l_only_one_lb VARCHAR2(2);
81: l_use_matching_date ar_lockboxes.use_matching_date%type;

Line 78: l_lockbox_number ar_payments_interface.lockbox_number%type;

74: l_payment_rec_type VARCHAR2(3);
75: l_overflow_rec_type VARCHAR2(3);
76: l_item_num ar_payments_interface.item_number%type;
77: l_batch_name ar_payments_interface.batch_name%type;
78: l_lockbox_number ar_payments_interface.lockbox_number%type;
79: l_batches VARCHAR2(2);
80: l_only_one_lb VARCHAR2(2);
81: l_use_matching_date ar_lockboxes.use_matching_date%type;
82: l_lockbox_matching_option ar_lockboxes.lockbox_matching_option%type;

Line 86: l_receipt_date ar_payments_interface.receipt_date%type;

82: l_lockbox_matching_option ar_lockboxes.lockbox_matching_option%type;
83: l_match_flag VARCHAR2(10);
84: l_rowid ROWID;
85: l_pay_unrelated_invoices VARCHAR2(2);
86: l_receipt_date ar_payments_interface.receipt_date%type;
87: l_no_batch_or_lb VARCHAR2(2); -- bug2980051
88: --
89: l_matching_number1 ar_payments_interface.invoice1%type;
90: l_matching_number2 ar_payments_interface.invoice2%type;

Line 89: l_matching_number1 ar_payments_interface.invoice1%type;

85: l_pay_unrelated_invoices VARCHAR2(2);
86: l_receipt_date ar_payments_interface.receipt_date%type;
87: l_no_batch_or_lb VARCHAR2(2); -- bug2980051
88: --
89: l_matching_number1 ar_payments_interface.invoice1%type;
90: l_matching_number2 ar_payments_interface.invoice2%type;
91: l_matching_number3 ar_payments_interface.invoice3%type;
92: l_matching_number4 ar_payments_interface.invoice4%type;
93: l_matching_number5 ar_payments_interface.invoice5%type;

Line 90: l_matching_number2 ar_payments_interface.invoice2%type;

86: l_receipt_date ar_payments_interface.receipt_date%type;
87: l_no_batch_or_lb VARCHAR2(2); -- bug2980051
88: --
89: l_matching_number1 ar_payments_interface.invoice1%type;
90: l_matching_number2 ar_payments_interface.invoice2%type;
91: l_matching_number3 ar_payments_interface.invoice3%type;
92: l_matching_number4 ar_payments_interface.invoice4%type;
93: l_matching_number5 ar_payments_interface.invoice5%type;
94: l_matching_number6 ar_payments_interface.invoice6%type;

Line 91: l_matching_number3 ar_payments_interface.invoice3%type;

87: l_no_batch_or_lb VARCHAR2(2); -- bug2980051
88: --
89: l_matching_number1 ar_payments_interface.invoice1%type;
90: l_matching_number2 ar_payments_interface.invoice2%type;
91: l_matching_number3 ar_payments_interface.invoice3%type;
92: l_matching_number4 ar_payments_interface.invoice4%type;
93: l_matching_number5 ar_payments_interface.invoice5%type;
94: l_matching_number6 ar_payments_interface.invoice6%type;
95: l_matching_number7 ar_payments_interface.invoice7%type;

Line 92: l_matching_number4 ar_payments_interface.invoice4%type;

88: --
89: l_matching_number1 ar_payments_interface.invoice1%type;
90: l_matching_number2 ar_payments_interface.invoice2%type;
91: l_matching_number3 ar_payments_interface.invoice3%type;
92: l_matching_number4 ar_payments_interface.invoice4%type;
93: l_matching_number5 ar_payments_interface.invoice5%type;
94: l_matching_number6 ar_payments_interface.invoice6%type;
95: l_matching_number7 ar_payments_interface.invoice7%type;
96: l_matching_number8 ar_payments_interface.invoice8%type;

Line 93: l_matching_number5 ar_payments_interface.invoice5%type;

89: l_matching_number1 ar_payments_interface.invoice1%type;
90: l_matching_number2 ar_payments_interface.invoice2%type;
91: l_matching_number3 ar_payments_interface.invoice3%type;
92: l_matching_number4 ar_payments_interface.invoice4%type;
93: l_matching_number5 ar_payments_interface.invoice5%type;
94: l_matching_number6 ar_payments_interface.invoice6%type;
95: l_matching_number7 ar_payments_interface.invoice7%type;
96: l_matching_number8 ar_payments_interface.invoice8%type;
97: --

Line 94: l_matching_number6 ar_payments_interface.invoice6%type;

90: l_matching_number2 ar_payments_interface.invoice2%type;
91: l_matching_number3 ar_payments_interface.invoice3%type;
92: l_matching_number4 ar_payments_interface.invoice4%type;
93: l_matching_number5 ar_payments_interface.invoice5%type;
94: l_matching_number6 ar_payments_interface.invoice6%type;
95: l_matching_number7 ar_payments_interface.invoice7%type;
96: l_matching_number8 ar_payments_interface.invoice8%type;
97: --
98: l_matching1_date ar_payments_interface.matching1_date%type;

Line 95: l_matching_number7 ar_payments_interface.invoice7%type;

91: l_matching_number3 ar_payments_interface.invoice3%type;
92: l_matching_number4 ar_payments_interface.invoice4%type;
93: l_matching_number5 ar_payments_interface.invoice5%type;
94: l_matching_number6 ar_payments_interface.invoice6%type;
95: l_matching_number7 ar_payments_interface.invoice7%type;
96: l_matching_number8 ar_payments_interface.invoice8%type;
97: --
98: l_matching1_date ar_payments_interface.matching1_date%type;
99: l_matching2_date ar_payments_interface.matching2_date%type;

Line 96: l_matching_number8 ar_payments_interface.invoice8%type;

92: l_matching_number4 ar_payments_interface.invoice4%type;
93: l_matching_number5 ar_payments_interface.invoice5%type;
94: l_matching_number6 ar_payments_interface.invoice6%type;
95: l_matching_number7 ar_payments_interface.invoice7%type;
96: l_matching_number8 ar_payments_interface.invoice8%type;
97: --
98: l_matching1_date ar_payments_interface.matching1_date%type;
99: l_matching2_date ar_payments_interface.matching2_date%type;
100: l_matching3_date ar_payments_interface.matching3_date%type;

Line 98: l_matching1_date ar_payments_interface.matching1_date%type;

94: l_matching_number6 ar_payments_interface.invoice6%type;
95: l_matching_number7 ar_payments_interface.invoice7%type;
96: l_matching_number8 ar_payments_interface.invoice8%type;
97: --
98: l_matching1_date ar_payments_interface.matching1_date%type;
99: l_matching2_date ar_payments_interface.matching2_date%type;
100: l_matching3_date ar_payments_interface.matching3_date%type;
101: l_matching4_date ar_payments_interface.matching4_date%type;
102: l_matching5_date ar_payments_interface.matching5_date%type;

Line 99: l_matching2_date ar_payments_interface.matching2_date%type;

95: l_matching_number7 ar_payments_interface.invoice7%type;
96: l_matching_number8 ar_payments_interface.invoice8%type;
97: --
98: l_matching1_date ar_payments_interface.matching1_date%type;
99: l_matching2_date ar_payments_interface.matching2_date%type;
100: l_matching3_date ar_payments_interface.matching3_date%type;
101: l_matching4_date ar_payments_interface.matching4_date%type;
102: l_matching5_date ar_payments_interface.matching5_date%type;
103: l_matching6_date ar_payments_interface.matching6_date%type;

Line 100: l_matching3_date ar_payments_interface.matching3_date%type;

96: l_matching_number8 ar_payments_interface.invoice8%type;
97: --
98: l_matching1_date ar_payments_interface.matching1_date%type;
99: l_matching2_date ar_payments_interface.matching2_date%type;
100: l_matching3_date ar_payments_interface.matching3_date%type;
101: l_matching4_date ar_payments_interface.matching4_date%type;
102: l_matching5_date ar_payments_interface.matching5_date%type;
103: l_matching6_date ar_payments_interface.matching6_date%type;
104: l_matching7_date ar_payments_interface.matching7_date%type;

Line 101: l_matching4_date ar_payments_interface.matching4_date%type;

97: --
98: l_matching1_date ar_payments_interface.matching1_date%type;
99: l_matching2_date ar_payments_interface.matching2_date%type;
100: l_matching3_date ar_payments_interface.matching3_date%type;
101: l_matching4_date ar_payments_interface.matching4_date%type;
102: l_matching5_date ar_payments_interface.matching5_date%type;
103: l_matching6_date ar_payments_interface.matching6_date%type;
104: l_matching7_date ar_payments_interface.matching7_date%type;
105: l_matching8_date ar_payments_interface.matching8_date%type;

Line 102: l_matching5_date ar_payments_interface.matching5_date%type;

98: l_matching1_date ar_payments_interface.matching1_date%type;
99: l_matching2_date ar_payments_interface.matching2_date%type;
100: l_matching3_date ar_payments_interface.matching3_date%type;
101: l_matching4_date ar_payments_interface.matching4_date%type;
102: l_matching5_date ar_payments_interface.matching5_date%type;
103: l_matching6_date ar_payments_interface.matching6_date%type;
104: l_matching7_date ar_payments_interface.matching7_date%type;
105: l_matching8_date ar_payments_interface.matching8_date%type;
106: --

Line 103: l_matching6_date ar_payments_interface.matching6_date%type;

99: l_matching2_date ar_payments_interface.matching2_date%type;
100: l_matching3_date ar_payments_interface.matching3_date%type;
101: l_matching4_date ar_payments_interface.matching4_date%type;
102: l_matching5_date ar_payments_interface.matching5_date%type;
103: l_matching6_date ar_payments_interface.matching6_date%type;
104: l_matching7_date ar_payments_interface.matching7_date%type;
105: l_matching8_date ar_payments_interface.matching8_date%type;
106: --
107: l_matching1_installment ar_payments_interface.invoice1_installment%type;

Line 104: l_matching7_date ar_payments_interface.matching7_date%type;

100: l_matching3_date ar_payments_interface.matching3_date%type;
101: l_matching4_date ar_payments_interface.matching4_date%type;
102: l_matching5_date ar_payments_interface.matching5_date%type;
103: l_matching6_date ar_payments_interface.matching6_date%type;
104: l_matching7_date ar_payments_interface.matching7_date%type;
105: l_matching8_date ar_payments_interface.matching8_date%type;
106: --
107: l_matching1_installment ar_payments_interface.invoice1_installment%type;
108: l_matching2_installment ar_payments_interface.invoice2_installment%type;

Line 105: l_matching8_date ar_payments_interface.matching8_date%type;

101: l_matching4_date ar_payments_interface.matching4_date%type;
102: l_matching5_date ar_payments_interface.matching5_date%type;
103: l_matching6_date ar_payments_interface.matching6_date%type;
104: l_matching7_date ar_payments_interface.matching7_date%type;
105: l_matching8_date ar_payments_interface.matching8_date%type;
106: --
107: l_matching1_installment ar_payments_interface.invoice1_installment%type;
108: l_matching2_installment ar_payments_interface.invoice2_installment%type;
109: l_matching3_installment ar_payments_interface.invoice3_installment%type;

Line 107: l_matching1_installment ar_payments_interface.invoice1_installment%type;

103: l_matching6_date ar_payments_interface.matching6_date%type;
104: l_matching7_date ar_payments_interface.matching7_date%type;
105: l_matching8_date ar_payments_interface.matching8_date%type;
106: --
107: l_matching1_installment ar_payments_interface.invoice1_installment%type;
108: l_matching2_installment ar_payments_interface.invoice2_installment%type;
109: l_matching3_installment ar_payments_interface.invoice3_installment%type;
110: l_matching4_installment ar_payments_interface.invoice4_installment%type;
111: l_matching5_installment ar_payments_interface.invoice5_installment%type;

Line 108: l_matching2_installment ar_payments_interface.invoice2_installment%type;

104: l_matching7_date ar_payments_interface.matching7_date%type;
105: l_matching8_date ar_payments_interface.matching8_date%type;
106: --
107: l_matching1_installment ar_payments_interface.invoice1_installment%type;
108: l_matching2_installment ar_payments_interface.invoice2_installment%type;
109: l_matching3_installment ar_payments_interface.invoice3_installment%type;
110: l_matching4_installment ar_payments_interface.invoice4_installment%type;
111: l_matching5_installment ar_payments_interface.invoice5_installment%type;
112: l_matching6_installment ar_payments_interface.invoice6_installment%type;

Line 109: l_matching3_installment ar_payments_interface.invoice3_installment%type;

105: l_matching8_date ar_payments_interface.matching8_date%type;
106: --
107: l_matching1_installment ar_payments_interface.invoice1_installment%type;
108: l_matching2_installment ar_payments_interface.invoice2_installment%type;
109: l_matching3_installment ar_payments_interface.invoice3_installment%type;
110: l_matching4_installment ar_payments_interface.invoice4_installment%type;
111: l_matching5_installment ar_payments_interface.invoice5_installment%type;
112: l_matching6_installment ar_payments_interface.invoice6_installment%type;
113: l_matching7_installment ar_payments_interface.invoice7_installment%type;

Line 110: l_matching4_installment ar_payments_interface.invoice4_installment%type;

106: --
107: l_matching1_installment ar_payments_interface.invoice1_installment%type;
108: l_matching2_installment ar_payments_interface.invoice2_installment%type;
109: l_matching3_installment ar_payments_interface.invoice3_installment%type;
110: l_matching4_installment ar_payments_interface.invoice4_installment%type;
111: l_matching5_installment ar_payments_interface.invoice5_installment%type;
112: l_matching6_installment ar_payments_interface.invoice6_installment%type;
113: l_matching7_installment ar_payments_interface.invoice7_installment%type;
114: l_matching8_installment ar_payments_interface.invoice8_installment%type;

Line 111: l_matching5_installment ar_payments_interface.invoice5_installment%type;

107: l_matching1_installment ar_payments_interface.invoice1_installment%type;
108: l_matching2_installment ar_payments_interface.invoice2_installment%type;
109: l_matching3_installment ar_payments_interface.invoice3_installment%type;
110: l_matching4_installment ar_payments_interface.invoice4_installment%type;
111: l_matching5_installment ar_payments_interface.invoice5_installment%type;
112: l_matching6_installment ar_payments_interface.invoice6_installment%type;
113: l_matching7_installment ar_payments_interface.invoice7_installment%type;
114: l_matching8_installment ar_payments_interface.invoice8_installment%type;
115: --

Line 112: l_matching6_installment ar_payments_interface.invoice6_installment%type;

108: l_matching2_installment ar_payments_interface.invoice2_installment%type;
109: l_matching3_installment ar_payments_interface.invoice3_installment%type;
110: l_matching4_installment ar_payments_interface.invoice4_installment%type;
111: l_matching5_installment ar_payments_interface.invoice5_installment%type;
112: l_matching6_installment ar_payments_interface.invoice6_installment%type;
113: l_matching7_installment ar_payments_interface.invoice7_installment%type;
114: l_matching8_installment ar_payments_interface.invoice8_installment%type;
115: --
116: l_match1_status ar_payments_interface.invoice1_status%type;

Line 113: l_matching7_installment ar_payments_interface.invoice7_installment%type;

109: l_matching3_installment ar_payments_interface.invoice3_installment%type;
110: l_matching4_installment ar_payments_interface.invoice4_installment%type;
111: l_matching5_installment ar_payments_interface.invoice5_installment%type;
112: l_matching6_installment ar_payments_interface.invoice6_installment%type;
113: l_matching7_installment ar_payments_interface.invoice7_installment%type;
114: l_matching8_installment ar_payments_interface.invoice8_installment%type;
115: --
116: l_match1_status ar_payments_interface.invoice1_status%type;
117: l_match2_status ar_payments_interface.invoice2_status%type;

Line 114: l_matching8_installment ar_payments_interface.invoice8_installment%type;

110: l_matching4_installment ar_payments_interface.invoice4_installment%type;
111: l_matching5_installment ar_payments_interface.invoice5_installment%type;
112: l_matching6_installment ar_payments_interface.invoice6_installment%type;
113: l_matching7_installment ar_payments_interface.invoice7_installment%type;
114: l_matching8_installment ar_payments_interface.invoice8_installment%type;
115: --
116: l_match1_status ar_payments_interface.invoice1_status%type;
117: l_match2_status ar_payments_interface.invoice2_status%type;
118: l_match3_status ar_payments_interface.invoice3_status%type;

Line 116: l_match1_status ar_payments_interface.invoice1_status%type;

112: l_matching6_installment ar_payments_interface.invoice6_installment%type;
113: l_matching7_installment ar_payments_interface.invoice7_installment%type;
114: l_matching8_installment ar_payments_interface.invoice8_installment%type;
115: --
116: l_match1_status ar_payments_interface.invoice1_status%type;
117: l_match2_status ar_payments_interface.invoice2_status%type;
118: l_match3_status ar_payments_interface.invoice3_status%type;
119: l_match4_status ar_payments_interface.invoice4_status%type;
120: l_match5_status ar_payments_interface.invoice5_status%type;

Line 117: l_match2_status ar_payments_interface.invoice2_status%type;

113: l_matching7_installment ar_payments_interface.invoice7_installment%type;
114: l_matching8_installment ar_payments_interface.invoice8_installment%type;
115: --
116: l_match1_status ar_payments_interface.invoice1_status%type;
117: l_match2_status ar_payments_interface.invoice2_status%type;
118: l_match3_status ar_payments_interface.invoice3_status%type;
119: l_match4_status ar_payments_interface.invoice4_status%type;
120: l_match5_status ar_payments_interface.invoice5_status%type;
121: l_match6_status ar_payments_interface.invoice6_status%type;

Line 118: l_match3_status ar_payments_interface.invoice3_status%type;

114: l_matching8_installment ar_payments_interface.invoice8_installment%type;
115: --
116: l_match1_status ar_payments_interface.invoice1_status%type;
117: l_match2_status ar_payments_interface.invoice2_status%type;
118: l_match3_status ar_payments_interface.invoice3_status%type;
119: l_match4_status ar_payments_interface.invoice4_status%type;
120: l_match5_status ar_payments_interface.invoice5_status%type;
121: l_match6_status ar_payments_interface.invoice6_status%type;
122: l_match7_status ar_payments_interface.invoice7_status%type;

Line 119: l_match4_status ar_payments_interface.invoice4_status%type;

115: --
116: l_match1_status ar_payments_interface.invoice1_status%type;
117: l_match2_status ar_payments_interface.invoice2_status%type;
118: l_match3_status ar_payments_interface.invoice3_status%type;
119: l_match4_status ar_payments_interface.invoice4_status%type;
120: l_match5_status ar_payments_interface.invoice5_status%type;
121: l_match6_status ar_payments_interface.invoice6_status%type;
122: l_match7_status ar_payments_interface.invoice7_status%type;
123: l_match8_status ar_payments_interface.invoice8_status%type;

Line 120: l_match5_status ar_payments_interface.invoice5_status%type;

116: l_match1_status ar_payments_interface.invoice1_status%type;
117: l_match2_status ar_payments_interface.invoice2_status%type;
118: l_match3_status ar_payments_interface.invoice3_status%type;
119: l_match4_status ar_payments_interface.invoice4_status%type;
120: l_match5_status ar_payments_interface.invoice5_status%type;
121: l_match6_status ar_payments_interface.invoice6_status%type;
122: l_match7_status ar_payments_interface.invoice7_status%type;
123: l_match8_status ar_payments_interface.invoice8_status%type;
124: --

Line 121: l_match6_status ar_payments_interface.invoice6_status%type;

117: l_match2_status ar_payments_interface.invoice2_status%type;
118: l_match3_status ar_payments_interface.invoice3_status%type;
119: l_match4_status ar_payments_interface.invoice4_status%type;
120: l_match5_status ar_payments_interface.invoice5_status%type;
121: l_match6_status ar_payments_interface.invoice6_status%type;
122: l_match7_status ar_payments_interface.invoice7_status%type;
123: l_match8_status ar_payments_interface.invoice8_status%type;
124: --
125: l_prev_customer_id ar_payments_interface.customer_id%type;

Line 122: l_match7_status ar_payments_interface.invoice7_status%type;

118: l_match3_status ar_payments_interface.invoice3_status%type;
119: l_match4_status ar_payments_interface.invoice4_status%type;
120: l_match5_status ar_payments_interface.invoice5_status%type;
121: l_match6_status ar_payments_interface.invoice6_status%type;
122: l_match7_status ar_payments_interface.invoice7_status%type;
123: l_match8_status ar_payments_interface.invoice8_status%type;
124: --
125: l_prev_customer_id ar_payments_interface.customer_id%type;
126: l_customer_id ar_payments_interface.customer_id%type;

Line 123: l_match8_status ar_payments_interface.invoice8_status%type;

119: l_match4_status ar_payments_interface.invoice4_status%type;
120: l_match5_status ar_payments_interface.invoice5_status%type;
121: l_match6_status ar_payments_interface.invoice6_status%type;
122: l_match7_status ar_payments_interface.invoice7_status%type;
123: l_match8_status ar_payments_interface.invoice8_status%type;
124: --
125: l_prev_customer_id ar_payments_interface.customer_id%type;
126: l_customer_id ar_payments_interface.customer_id%type;
127: l_matching_option ar_lookups.lookup_code%type;

Line 125: l_prev_customer_id ar_payments_interface.customer_id%type;

121: l_match6_status ar_payments_interface.invoice6_status%type;
122: l_match7_status ar_payments_interface.invoice7_status%type;
123: l_match8_status ar_payments_interface.invoice8_status%type;
124: --
125: l_prev_customer_id ar_payments_interface.customer_id%type;
126: l_customer_id ar_payments_interface.customer_id%type;
127: l_matching_option ar_lookups.lookup_code%type;
128: --
129: unexpected_program_error EXCEPTION;

Line 126: l_customer_id ar_payments_interface.customer_id%type;

122: l_match7_status ar_payments_interface.invoice7_status%type;
123: l_match8_status ar_payments_interface.invoice8_status%type;
124: --
125: l_prev_customer_id ar_payments_interface.customer_id%type;
126: l_customer_id ar_payments_interface.customer_id%type;
127: l_matching_option ar_lookups.lookup_code%type;
128: --
129: unexpected_program_error EXCEPTION;
130: --

Line 144: from ar_payments_interface pi

140: invoice5, matching5_date, invoice5_installment,
141: invoice6, matching6_date, invoice6_installment,
142: invoice7, matching7_date, invoice7_installment,
143: invoice8, matching8_date, invoice8_installment
144: from ar_payments_interface pi
145: where pi.transmission_id = l_transmission_id
146: and pi.record_type||'' in ( l_payment_rec_type, l_overflow_rec_type )
147: and pi.customer_id is null
148: and pi.status = 'AR_PLB_CONTROLS_OK'

Line 328: -- update the current record of ar_payments_interface table

324: --
325: IF ((l_customer_id = l_prev_customer_id) AND (l_match_flag = 'TRUE')) THEN
326: --
327: -- If the customer_id was identified uniquely,
328: -- update the current record of ar_payments_interface table
329: -- with returned values from find_cust_and_trx_num procedure.
330: -- Also update the status to indicate that Resolved columns were
331: -- populated.
332: -- customer_id is populated in arlvaa(), here we are updating the

Line 337: debug1('Updating ar_payments_interface for resolved columns..');

333: -- trx_number values and related details. It is possible that
334: -- customer_id was identified, but trx_number was not identified
335: -- uniquely. In that case matching_number will be NULL.
336: --
337: debug1('Updating ar_payments_interface for resolved columns..');
338: debug1('l_matching_number1 ' || l_matching_number1);
339: debug1('l_matching1_installment ' || l_matching1_installment);
340: debug1('l_matching1_date ' || to_char(l_matching1_date));
341: --

Line 342: UPDATE ar_payments_interface

338: debug1('l_matching_number1 ' || l_matching_number1);
339: debug1('l_matching1_installment ' || l_matching1_installment);
340: debug1('l_matching1_date ' || to_char(l_matching1_date));
341: --
342: UPDATE ar_payments_interface
343: SET resolved_matching_number1 = l_matching_number1,
344: resolved_matching1_installment = l_matching1_installment,
345: resolved_matching1_date = l_matching1_date,
346: invoice1_status = l_match1_status,

Line 379: UPDATE AR_PAYMENTS_INTERFACE SET tmp_amt_applied1=amount_applied1,

375: match_resolved_using = l_matching_option
376: WHERE rowid = l_rowid;
377: /*5052049*/
378: IF l_matching_option='CONSOLIDATE_BILL' then
379: UPDATE AR_PAYMENTS_INTERFACE SET tmp_amt_applied1=amount_applied1,
380: tmp_amt_applied2=amount_applied2,
381: tmp_amt_applied3=amount_applied3,
382: tmp_amt_applied4=amount_applied4,
383: tmp_amt_applied5=amount_applied5,

Line 399: -- Using rowid here for getting the current record, as ar_payments_interface

395: WHERE rowid = l_rowid and match_resolved_using='CONSOLIDATE_BILL';
396: END IF;
397:
398: --
399: -- Using rowid here for getting the current record, as ar_payments_interface
400: -- does not have any other primary key.
401: --
402: /* Bug 2106408. Added the following ELSIF */
403: ELSIF (l_match_flag = 'FALSE') AND

Line 461: UPDATE ar_payments_interface pi

457: -- If there was no match found, then also we must populate the
458: -- resolved columns as the program looks at resolved columns only
459: -- from hence forth.
460: /* Bug2980051. Replaced l_only_one_lb with l_no_batch_or_lb */
461: UPDATE ar_payments_interface pi
462: SET resolved_matching_number1 = invoice1,
463: resolved_matching1_installment = invoice1_installment,
464: resolved_matching1_date = matching1_date,
465: invoice1_status = decode(invoice1, null, null, 'AR_PLB_INVALID_MATCH'),

Line 518: UPDATE ar_payments_interface pi

514: RETURN;
515: /* Bug 2106408. Added the following UPDATE */
516: <>
517: /* Bug2980051. Replaced l_only_one_lb with l_no_batch_or_lb */
518: UPDATE ar_payments_interface pi
519: SET resolved_matching_number1 = invoice1,
520: resolved_matching1_installment = invoice1_installment,
521: resolved_matching1_date = matching1_date,
522: invoice1_status = decode(invoice1, null, null, 'AR_PLB_DUP_INV'),

Line 590: | Update record in ar_payments_interface for returned trx_number, trx_date and

586: | Fetch (using cursor matching_number) all 8 matching numbers, matching dates
587: | and installments for each record, for given lockbox/batch and item number.
588: | Call find_cust_and_trx_num for each payment/overflow record to get the
589: | trx numbers.
590: | Update record in ar_payments_interface for returned trx_number, trx_date and
591: | installment number.
592: |
593: | Modification History
594: | 30-Jul-97 K Trivedi Created. Rel 11 related changes.

Line 596: | column in ar_payments_interface.

592: |
593: | Modification History
594: | 30-Jul-97 K Trivedi Created. Rel 11 related changes.
595: | 24-Sep-97 K Trivedi Modified to populate match_resolved_using
596: | column in ar_payments_interface.
597: |
598: ----------------------------------------------------------------------------*/
599: PROCEDURE populate_resolved_columns(
600: p_transmission_id IN VARCHAR2,

Line 603: p_item_num IN ar_payments_interface.item_number%type,

599: PROCEDURE populate_resolved_columns(
600: p_transmission_id IN VARCHAR2,
601: p_payment_rec_type IN VARCHAR2,
602: p_overflow_rec_type IN VARCHAR2,
603: p_item_num IN ar_payments_interface.item_number%type,
604: p_batch_name IN ar_payments_interface.batch_name%type,
605: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
606: p_batches IN VARCHAR2,
607: p_only_one_lb IN VARCHAR2,

Line 604: p_batch_name IN ar_payments_interface.batch_name%type,

600: p_transmission_id IN VARCHAR2,
601: p_payment_rec_type IN VARCHAR2,
602: p_overflow_rec_type IN VARCHAR2,
603: p_item_num IN ar_payments_interface.item_number%type,
604: p_batch_name IN ar_payments_interface.batch_name%type,
605: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
606: p_batches IN VARCHAR2,
607: p_only_one_lb IN VARCHAR2,
608: p_use_matching_date IN ar_lockboxes.use_matching_date%type,

Line 605: p_lockbox_number IN ar_payments_interface.lockbox_number%type,

601: p_payment_rec_type IN VARCHAR2,
602: p_overflow_rec_type IN VARCHAR2,
603: p_item_num IN ar_payments_interface.item_number%type,
604: p_batch_name IN ar_payments_interface.batch_name%type,
605: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
606: p_batches IN VARCHAR2,
607: p_only_one_lb IN VARCHAR2,
608: p_use_matching_date IN ar_lockboxes.use_matching_date%type,
609: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,

Line 616: l_item_num ar_payments_interface.item_number%type;

612: --
613: l_transmission_id VARCHAR2(50);
614: l_payment_rec_type VARCHAR2(3);
615: l_overflow_rec_type VARCHAR2(3);
616: l_item_num ar_payments_interface.item_number%type;
617: l_batch_name ar_payments_interface.batch_name%type;
618: l_lockbox_number ar_payments_interface.lockbox_number%type;
619: l_batches VARCHAR2(2);
620: l_only_one_lb VARCHAR2(2);

Line 617: l_batch_name ar_payments_interface.batch_name%type;

613: l_transmission_id VARCHAR2(50);
614: l_payment_rec_type VARCHAR2(3);
615: l_overflow_rec_type VARCHAR2(3);
616: l_item_num ar_payments_interface.item_number%type;
617: l_batch_name ar_payments_interface.batch_name%type;
618: l_lockbox_number ar_payments_interface.lockbox_number%type;
619: l_batches VARCHAR2(2);
620: l_only_one_lb VARCHAR2(2);
621: l_use_matching_date ar_lockboxes.use_matching_date%type;

Line 618: l_lockbox_number ar_payments_interface.lockbox_number%type;

614: l_payment_rec_type VARCHAR2(3);
615: l_overflow_rec_type VARCHAR2(3);
616: l_item_num ar_payments_interface.item_number%type;
617: l_batch_name ar_payments_interface.batch_name%type;
618: l_lockbox_number ar_payments_interface.lockbox_number%type;
619: l_batches VARCHAR2(2);
620: l_only_one_lb VARCHAR2(2);
621: l_use_matching_date ar_lockboxes.use_matching_date%type;
622: l_lockbox_matching_option ar_lockboxes.lockbox_matching_option%type;

Line 626: l_receipt_date ar_payments_interface.receipt_date%type;

622: l_lockbox_matching_option ar_lockboxes.lockbox_matching_option%type;
623: l_match_flag VARCHAR2(10);
624: l_rowid ROWID;
625: l_pay_unrelated_invoices VARCHAR2(2);
626: l_receipt_date ar_payments_interface.receipt_date%type;
627:
628: l_no_batch_or_lb VARCHAR2(2); -- bug2980051
629: --
630: l_matching_number1 ar_payments_interface.invoice1%type;

Line 630: l_matching_number1 ar_payments_interface.invoice1%type;

626: l_receipt_date ar_payments_interface.receipt_date%type;
627:
628: l_no_batch_or_lb VARCHAR2(2); -- bug2980051
629: --
630: l_matching_number1 ar_payments_interface.invoice1%type;
631: l_matching_number2 ar_payments_interface.invoice2%type;
632: l_matching_number3 ar_payments_interface.invoice3%type;
633: l_matching_number4 ar_payments_interface.invoice4%type;
634: l_matching_number5 ar_payments_interface.invoice5%type;

Line 631: l_matching_number2 ar_payments_interface.invoice2%type;

627:
628: l_no_batch_or_lb VARCHAR2(2); -- bug2980051
629: --
630: l_matching_number1 ar_payments_interface.invoice1%type;
631: l_matching_number2 ar_payments_interface.invoice2%type;
632: l_matching_number3 ar_payments_interface.invoice3%type;
633: l_matching_number4 ar_payments_interface.invoice4%type;
634: l_matching_number5 ar_payments_interface.invoice5%type;
635: l_matching_number6 ar_payments_interface.invoice6%type;

Line 632: l_matching_number3 ar_payments_interface.invoice3%type;

628: l_no_batch_or_lb VARCHAR2(2); -- bug2980051
629: --
630: l_matching_number1 ar_payments_interface.invoice1%type;
631: l_matching_number2 ar_payments_interface.invoice2%type;
632: l_matching_number3 ar_payments_interface.invoice3%type;
633: l_matching_number4 ar_payments_interface.invoice4%type;
634: l_matching_number5 ar_payments_interface.invoice5%type;
635: l_matching_number6 ar_payments_interface.invoice6%type;
636: l_matching_number7 ar_payments_interface.invoice7%type;

Line 633: l_matching_number4 ar_payments_interface.invoice4%type;

629: --
630: l_matching_number1 ar_payments_interface.invoice1%type;
631: l_matching_number2 ar_payments_interface.invoice2%type;
632: l_matching_number3 ar_payments_interface.invoice3%type;
633: l_matching_number4 ar_payments_interface.invoice4%type;
634: l_matching_number5 ar_payments_interface.invoice5%type;
635: l_matching_number6 ar_payments_interface.invoice6%type;
636: l_matching_number7 ar_payments_interface.invoice7%type;
637: l_matching_number8 ar_payments_interface.invoice8%type;

Line 634: l_matching_number5 ar_payments_interface.invoice5%type;

630: l_matching_number1 ar_payments_interface.invoice1%type;
631: l_matching_number2 ar_payments_interface.invoice2%type;
632: l_matching_number3 ar_payments_interface.invoice3%type;
633: l_matching_number4 ar_payments_interface.invoice4%type;
634: l_matching_number5 ar_payments_interface.invoice5%type;
635: l_matching_number6 ar_payments_interface.invoice6%type;
636: l_matching_number7 ar_payments_interface.invoice7%type;
637: l_matching_number8 ar_payments_interface.invoice8%type;
638: --

Line 635: l_matching_number6 ar_payments_interface.invoice6%type;

631: l_matching_number2 ar_payments_interface.invoice2%type;
632: l_matching_number3 ar_payments_interface.invoice3%type;
633: l_matching_number4 ar_payments_interface.invoice4%type;
634: l_matching_number5 ar_payments_interface.invoice5%type;
635: l_matching_number6 ar_payments_interface.invoice6%type;
636: l_matching_number7 ar_payments_interface.invoice7%type;
637: l_matching_number8 ar_payments_interface.invoice8%type;
638: --
639: l_matching1_date ar_payments_interface.matching1_date%type;

Line 636: l_matching_number7 ar_payments_interface.invoice7%type;

632: l_matching_number3 ar_payments_interface.invoice3%type;
633: l_matching_number4 ar_payments_interface.invoice4%type;
634: l_matching_number5 ar_payments_interface.invoice5%type;
635: l_matching_number6 ar_payments_interface.invoice6%type;
636: l_matching_number7 ar_payments_interface.invoice7%type;
637: l_matching_number8 ar_payments_interface.invoice8%type;
638: --
639: l_matching1_date ar_payments_interface.matching1_date%type;
640: l_matching2_date ar_payments_interface.matching2_date%type;

Line 637: l_matching_number8 ar_payments_interface.invoice8%type;

633: l_matching_number4 ar_payments_interface.invoice4%type;
634: l_matching_number5 ar_payments_interface.invoice5%type;
635: l_matching_number6 ar_payments_interface.invoice6%type;
636: l_matching_number7 ar_payments_interface.invoice7%type;
637: l_matching_number8 ar_payments_interface.invoice8%type;
638: --
639: l_matching1_date ar_payments_interface.matching1_date%type;
640: l_matching2_date ar_payments_interface.matching2_date%type;
641: l_matching3_date ar_payments_interface.matching3_date%type;

Line 639: l_matching1_date ar_payments_interface.matching1_date%type;

635: l_matching_number6 ar_payments_interface.invoice6%type;
636: l_matching_number7 ar_payments_interface.invoice7%type;
637: l_matching_number8 ar_payments_interface.invoice8%type;
638: --
639: l_matching1_date ar_payments_interface.matching1_date%type;
640: l_matching2_date ar_payments_interface.matching2_date%type;
641: l_matching3_date ar_payments_interface.matching3_date%type;
642: l_matching4_date ar_payments_interface.matching4_date%type;
643: l_matching5_date ar_payments_interface.matching5_date%type;

Line 640: l_matching2_date ar_payments_interface.matching2_date%type;

636: l_matching_number7 ar_payments_interface.invoice7%type;
637: l_matching_number8 ar_payments_interface.invoice8%type;
638: --
639: l_matching1_date ar_payments_interface.matching1_date%type;
640: l_matching2_date ar_payments_interface.matching2_date%type;
641: l_matching3_date ar_payments_interface.matching3_date%type;
642: l_matching4_date ar_payments_interface.matching4_date%type;
643: l_matching5_date ar_payments_interface.matching5_date%type;
644: l_matching6_date ar_payments_interface.matching6_date%type;

Line 641: l_matching3_date ar_payments_interface.matching3_date%type;

637: l_matching_number8 ar_payments_interface.invoice8%type;
638: --
639: l_matching1_date ar_payments_interface.matching1_date%type;
640: l_matching2_date ar_payments_interface.matching2_date%type;
641: l_matching3_date ar_payments_interface.matching3_date%type;
642: l_matching4_date ar_payments_interface.matching4_date%type;
643: l_matching5_date ar_payments_interface.matching5_date%type;
644: l_matching6_date ar_payments_interface.matching6_date%type;
645: l_matching7_date ar_payments_interface.matching7_date%type;

Line 642: l_matching4_date ar_payments_interface.matching4_date%type;

638: --
639: l_matching1_date ar_payments_interface.matching1_date%type;
640: l_matching2_date ar_payments_interface.matching2_date%type;
641: l_matching3_date ar_payments_interface.matching3_date%type;
642: l_matching4_date ar_payments_interface.matching4_date%type;
643: l_matching5_date ar_payments_interface.matching5_date%type;
644: l_matching6_date ar_payments_interface.matching6_date%type;
645: l_matching7_date ar_payments_interface.matching7_date%type;
646: l_matching8_date ar_payments_interface.matching8_date%type;

Line 643: l_matching5_date ar_payments_interface.matching5_date%type;

639: l_matching1_date ar_payments_interface.matching1_date%type;
640: l_matching2_date ar_payments_interface.matching2_date%type;
641: l_matching3_date ar_payments_interface.matching3_date%type;
642: l_matching4_date ar_payments_interface.matching4_date%type;
643: l_matching5_date ar_payments_interface.matching5_date%type;
644: l_matching6_date ar_payments_interface.matching6_date%type;
645: l_matching7_date ar_payments_interface.matching7_date%type;
646: l_matching8_date ar_payments_interface.matching8_date%type;
647: --

Line 644: l_matching6_date ar_payments_interface.matching6_date%type;

640: l_matching2_date ar_payments_interface.matching2_date%type;
641: l_matching3_date ar_payments_interface.matching3_date%type;
642: l_matching4_date ar_payments_interface.matching4_date%type;
643: l_matching5_date ar_payments_interface.matching5_date%type;
644: l_matching6_date ar_payments_interface.matching6_date%type;
645: l_matching7_date ar_payments_interface.matching7_date%type;
646: l_matching8_date ar_payments_interface.matching8_date%type;
647: --
648: l_matching1_installment ar_payments_interface.invoice1_installment%type;

Line 645: l_matching7_date ar_payments_interface.matching7_date%type;

641: l_matching3_date ar_payments_interface.matching3_date%type;
642: l_matching4_date ar_payments_interface.matching4_date%type;
643: l_matching5_date ar_payments_interface.matching5_date%type;
644: l_matching6_date ar_payments_interface.matching6_date%type;
645: l_matching7_date ar_payments_interface.matching7_date%type;
646: l_matching8_date ar_payments_interface.matching8_date%type;
647: --
648: l_matching1_installment ar_payments_interface.invoice1_installment%type;
649: l_matching2_installment ar_payments_interface.invoice2_installment%type;

Line 646: l_matching8_date ar_payments_interface.matching8_date%type;

642: l_matching4_date ar_payments_interface.matching4_date%type;
643: l_matching5_date ar_payments_interface.matching5_date%type;
644: l_matching6_date ar_payments_interface.matching6_date%type;
645: l_matching7_date ar_payments_interface.matching7_date%type;
646: l_matching8_date ar_payments_interface.matching8_date%type;
647: --
648: l_matching1_installment ar_payments_interface.invoice1_installment%type;
649: l_matching2_installment ar_payments_interface.invoice2_installment%type;
650: l_matching3_installment ar_payments_interface.invoice3_installment%type;

Line 648: l_matching1_installment ar_payments_interface.invoice1_installment%type;

644: l_matching6_date ar_payments_interface.matching6_date%type;
645: l_matching7_date ar_payments_interface.matching7_date%type;
646: l_matching8_date ar_payments_interface.matching8_date%type;
647: --
648: l_matching1_installment ar_payments_interface.invoice1_installment%type;
649: l_matching2_installment ar_payments_interface.invoice2_installment%type;
650: l_matching3_installment ar_payments_interface.invoice3_installment%type;
651: l_matching4_installment ar_payments_interface.invoice4_installment%type;
652: l_matching5_installment ar_payments_interface.invoice5_installment%type;

Line 649: l_matching2_installment ar_payments_interface.invoice2_installment%type;

645: l_matching7_date ar_payments_interface.matching7_date%type;
646: l_matching8_date ar_payments_interface.matching8_date%type;
647: --
648: l_matching1_installment ar_payments_interface.invoice1_installment%type;
649: l_matching2_installment ar_payments_interface.invoice2_installment%type;
650: l_matching3_installment ar_payments_interface.invoice3_installment%type;
651: l_matching4_installment ar_payments_interface.invoice4_installment%type;
652: l_matching5_installment ar_payments_interface.invoice5_installment%type;
653: l_matching6_installment ar_payments_interface.invoice6_installment%type;

Line 650: l_matching3_installment ar_payments_interface.invoice3_installment%type;

646: l_matching8_date ar_payments_interface.matching8_date%type;
647: --
648: l_matching1_installment ar_payments_interface.invoice1_installment%type;
649: l_matching2_installment ar_payments_interface.invoice2_installment%type;
650: l_matching3_installment ar_payments_interface.invoice3_installment%type;
651: l_matching4_installment ar_payments_interface.invoice4_installment%type;
652: l_matching5_installment ar_payments_interface.invoice5_installment%type;
653: l_matching6_installment ar_payments_interface.invoice6_installment%type;
654: l_matching7_installment ar_payments_interface.invoice7_installment%type;

Line 651: l_matching4_installment ar_payments_interface.invoice4_installment%type;

647: --
648: l_matching1_installment ar_payments_interface.invoice1_installment%type;
649: l_matching2_installment ar_payments_interface.invoice2_installment%type;
650: l_matching3_installment ar_payments_interface.invoice3_installment%type;
651: l_matching4_installment ar_payments_interface.invoice4_installment%type;
652: l_matching5_installment ar_payments_interface.invoice5_installment%type;
653: l_matching6_installment ar_payments_interface.invoice6_installment%type;
654: l_matching7_installment ar_payments_interface.invoice7_installment%type;
655: l_matching8_installment ar_payments_interface.invoice8_installment%type;

Line 652: l_matching5_installment ar_payments_interface.invoice5_installment%type;

648: l_matching1_installment ar_payments_interface.invoice1_installment%type;
649: l_matching2_installment ar_payments_interface.invoice2_installment%type;
650: l_matching3_installment ar_payments_interface.invoice3_installment%type;
651: l_matching4_installment ar_payments_interface.invoice4_installment%type;
652: l_matching5_installment ar_payments_interface.invoice5_installment%type;
653: l_matching6_installment ar_payments_interface.invoice6_installment%type;
654: l_matching7_installment ar_payments_interface.invoice7_installment%type;
655: l_matching8_installment ar_payments_interface.invoice8_installment%type;
656: --

Line 653: l_matching6_installment ar_payments_interface.invoice6_installment%type;

649: l_matching2_installment ar_payments_interface.invoice2_installment%type;
650: l_matching3_installment ar_payments_interface.invoice3_installment%type;
651: l_matching4_installment ar_payments_interface.invoice4_installment%type;
652: l_matching5_installment ar_payments_interface.invoice5_installment%type;
653: l_matching6_installment ar_payments_interface.invoice6_installment%type;
654: l_matching7_installment ar_payments_interface.invoice7_installment%type;
655: l_matching8_installment ar_payments_interface.invoice8_installment%type;
656: --
657: l_match1_status ar_payments_interface.invoice1_status%type;

Line 654: l_matching7_installment ar_payments_interface.invoice7_installment%type;

650: l_matching3_installment ar_payments_interface.invoice3_installment%type;
651: l_matching4_installment ar_payments_interface.invoice4_installment%type;
652: l_matching5_installment ar_payments_interface.invoice5_installment%type;
653: l_matching6_installment ar_payments_interface.invoice6_installment%type;
654: l_matching7_installment ar_payments_interface.invoice7_installment%type;
655: l_matching8_installment ar_payments_interface.invoice8_installment%type;
656: --
657: l_match1_status ar_payments_interface.invoice1_status%type;
658: l_match2_status ar_payments_interface.invoice2_status%type;

Line 655: l_matching8_installment ar_payments_interface.invoice8_installment%type;

651: l_matching4_installment ar_payments_interface.invoice4_installment%type;
652: l_matching5_installment ar_payments_interface.invoice5_installment%type;
653: l_matching6_installment ar_payments_interface.invoice6_installment%type;
654: l_matching7_installment ar_payments_interface.invoice7_installment%type;
655: l_matching8_installment ar_payments_interface.invoice8_installment%type;
656: --
657: l_match1_status ar_payments_interface.invoice1_status%type;
658: l_match2_status ar_payments_interface.invoice2_status%type;
659: l_match3_status ar_payments_interface.invoice3_status%type;

Line 657: l_match1_status ar_payments_interface.invoice1_status%type;

653: l_matching6_installment ar_payments_interface.invoice6_installment%type;
654: l_matching7_installment ar_payments_interface.invoice7_installment%type;
655: l_matching8_installment ar_payments_interface.invoice8_installment%type;
656: --
657: l_match1_status ar_payments_interface.invoice1_status%type;
658: l_match2_status ar_payments_interface.invoice2_status%type;
659: l_match3_status ar_payments_interface.invoice3_status%type;
660: l_match4_status ar_payments_interface.invoice4_status%type;
661: l_match5_status ar_payments_interface.invoice5_status%type;

Line 658: l_match2_status ar_payments_interface.invoice2_status%type;

654: l_matching7_installment ar_payments_interface.invoice7_installment%type;
655: l_matching8_installment ar_payments_interface.invoice8_installment%type;
656: --
657: l_match1_status ar_payments_interface.invoice1_status%type;
658: l_match2_status ar_payments_interface.invoice2_status%type;
659: l_match3_status ar_payments_interface.invoice3_status%type;
660: l_match4_status ar_payments_interface.invoice4_status%type;
661: l_match5_status ar_payments_interface.invoice5_status%type;
662: l_match6_status ar_payments_interface.invoice6_status%type;

Line 659: l_match3_status ar_payments_interface.invoice3_status%type;

655: l_matching8_installment ar_payments_interface.invoice8_installment%type;
656: --
657: l_match1_status ar_payments_interface.invoice1_status%type;
658: l_match2_status ar_payments_interface.invoice2_status%type;
659: l_match3_status ar_payments_interface.invoice3_status%type;
660: l_match4_status ar_payments_interface.invoice4_status%type;
661: l_match5_status ar_payments_interface.invoice5_status%type;
662: l_match6_status ar_payments_interface.invoice6_status%type;
663: l_match7_status ar_payments_interface.invoice7_status%type;

Line 660: l_match4_status ar_payments_interface.invoice4_status%type;

656: --
657: l_match1_status ar_payments_interface.invoice1_status%type;
658: l_match2_status ar_payments_interface.invoice2_status%type;
659: l_match3_status ar_payments_interface.invoice3_status%type;
660: l_match4_status ar_payments_interface.invoice4_status%type;
661: l_match5_status ar_payments_interface.invoice5_status%type;
662: l_match6_status ar_payments_interface.invoice6_status%type;
663: l_match7_status ar_payments_interface.invoice7_status%type;
664: l_match8_status ar_payments_interface.invoice8_status%type;

Line 661: l_match5_status ar_payments_interface.invoice5_status%type;

657: l_match1_status ar_payments_interface.invoice1_status%type;
658: l_match2_status ar_payments_interface.invoice2_status%type;
659: l_match3_status ar_payments_interface.invoice3_status%type;
660: l_match4_status ar_payments_interface.invoice4_status%type;
661: l_match5_status ar_payments_interface.invoice5_status%type;
662: l_match6_status ar_payments_interface.invoice6_status%type;
663: l_match7_status ar_payments_interface.invoice7_status%type;
664: l_match8_status ar_payments_interface.invoice8_status%type;
665: --

Line 662: l_match6_status ar_payments_interface.invoice6_status%type;

658: l_match2_status ar_payments_interface.invoice2_status%type;
659: l_match3_status ar_payments_interface.invoice3_status%type;
660: l_match4_status ar_payments_interface.invoice4_status%type;
661: l_match5_status ar_payments_interface.invoice5_status%type;
662: l_match6_status ar_payments_interface.invoice6_status%type;
663: l_match7_status ar_payments_interface.invoice7_status%type;
664: l_match8_status ar_payments_interface.invoice8_status%type;
665: --
666: l_customer_id ar_payments_interface.customer_id%type;

Line 663: l_match7_status ar_payments_interface.invoice7_status%type;

659: l_match3_status ar_payments_interface.invoice3_status%type;
660: l_match4_status ar_payments_interface.invoice4_status%type;
661: l_match5_status ar_payments_interface.invoice5_status%type;
662: l_match6_status ar_payments_interface.invoice6_status%type;
663: l_match7_status ar_payments_interface.invoice7_status%type;
664: l_match8_status ar_payments_interface.invoice8_status%type;
665: --
666: l_customer_id ar_payments_interface.customer_id%type;
667: l_matching_option ar_lookups.lookup_code%type;

Line 664: l_match8_status ar_payments_interface.invoice8_status%type;

660: l_match4_status ar_payments_interface.invoice4_status%type;
661: l_match5_status ar_payments_interface.invoice5_status%type;
662: l_match6_status ar_payments_interface.invoice6_status%type;
663: l_match7_status ar_payments_interface.invoice7_status%type;
664: l_match8_status ar_payments_interface.invoice8_status%type;
665: --
666: l_customer_id ar_payments_interface.customer_id%type;
667: l_matching_option ar_lookups.lookup_code%type;
668: --

Line 666: l_customer_id ar_payments_interface.customer_id%type;

662: l_match6_status ar_payments_interface.invoice6_status%type;
663: l_match7_status ar_payments_interface.invoice7_status%type;
664: l_match8_status ar_payments_interface.invoice8_status%type;
665: --
666: l_customer_id ar_payments_interface.customer_id%type;
667: l_matching_option ar_lookups.lookup_code%type;
668: --
669: unexpected_program_error EXCEPTION;
670: --

Line 684: from ar_payments_interface pi

680: invoice5, matching5_date, invoice5_installment,
681: invoice6, matching6_date, invoice6_installment,
682: invoice7, matching7_date, invoice7_installment,
683: invoice8, matching8_date, invoice8_installment
684: from ar_payments_interface pi
685: where pi.transmission_id = l_transmission_id
686: and pi.record_type||'' in ( l_payment_rec_type, l_overflow_rec_type )
687: and pi.customer_id is NOT null
688: and pi.status in ('AR_PLB_CUST_OK', 'AR_PLB_MICR_OK')

Line 852: debug1('Updating ar_payments_interface for resolved columns...');

848: -- in the record.
849: --
850: IF (l_match_flag <> 'NO_ITEM') THEN
851: --
852: debug1('Updating ar_payments_interface for resolved columns...');
853: debug1('l_matching_number1 ' || l_matching_number1);
854: debug1('l_matching1_installment ' || l_matching1_installment);
855: debug1('l_matching1_date ' || to_char(l_matching1_date));
856: --

Line 857: UPDATE ar_payments_interface

853: debug1('l_matching_number1 ' || l_matching_number1);
854: debug1('l_matching1_installment ' || l_matching1_installment);
855: debug1('l_matching1_date ' || to_char(l_matching1_date));
856: --
857: UPDATE ar_payments_interface
858: SET resolved_matching_number1 = l_matching_number1,
859: resolved_matching1_installment = l_matching1_installment,
860: resolved_matching1_date = l_matching1_date,
861: invoice1_status = l_match1_status,

Line 893: -- Using rowid here for getting the current record, as ar_payments_interface

889: invoice8_status = l_match8_status,
890: match_resolved_using = l_matching_option
891: WHERE rowid = l_rowid;
892: --
893: -- Using rowid here for getting the current record, as ar_payments_interface
894: -- does not have any other primary key.
895: --
896: /*5052049*/
897: IF l_matching_option='CONSOLIDATE_BILL' then

Line 898: UPDATE AR_PAYMENTS_INTERFACE SET tmp_amt_applied1=amount_applied1,

894: -- does not have any other primary key.
895: --
896: /*5052049*/
897: IF l_matching_option='CONSOLIDATE_BILL' then
898: UPDATE AR_PAYMENTS_INTERFACE SET tmp_amt_applied1=amount_applied1,
899: tmp_amt_applied2=amount_applied2,
900: tmp_amt_applied3=amount_applied3,
901: tmp_amt_applied4=amount_applied4,
902: tmp_amt_applied5=amount_applied5,

Line 1000: p_item_num IN ar_payments_interface.item_number%type,

996: find_cust_and_trx_num(
997: p_transmission_id IN VARCHAR2,
998: p_payment_rec_type IN VARCHAR2,
999: p_overflow_rec_type IN VARCHAR2,
1000: p_item_num IN ar_payments_interface.item_number%type,
1001: p_batch_name IN ar_payments_interface.batch_name%type,
1002: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
1003: p_receipt_date IN ar_payments_interface.receipt_date%type,
1004: p_batches IN VARCHAR2,

Line 1001: p_batch_name IN ar_payments_interface.batch_name%type,

997: p_transmission_id IN VARCHAR2,
998: p_payment_rec_type IN VARCHAR2,
999: p_overflow_rec_type IN VARCHAR2,
1000: p_item_num IN ar_payments_interface.item_number%type,
1001: p_batch_name IN ar_payments_interface.batch_name%type,
1002: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
1003: p_receipt_date IN ar_payments_interface.receipt_date%type,
1004: p_batches IN VARCHAR2,
1005: p_only_one_lb IN VARCHAR2,

Line 1002: p_lockbox_number IN ar_payments_interface.lockbox_number%type,

998: p_payment_rec_type IN VARCHAR2,
999: p_overflow_rec_type IN VARCHAR2,
1000: p_item_num IN ar_payments_interface.item_number%type,
1001: p_batch_name IN ar_payments_interface.batch_name%type,
1002: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
1003: p_receipt_date IN ar_payments_interface.receipt_date%type,
1004: p_batches IN VARCHAR2,
1005: p_only_one_lb IN VARCHAR2,
1006: p_use_matching_date IN ar_lockboxes.use_matching_date%type,

Line 1003: p_receipt_date IN ar_payments_interface.receipt_date%type,

999: p_overflow_rec_type IN VARCHAR2,
1000: p_item_num IN ar_payments_interface.item_number%type,
1001: p_batch_name IN ar_payments_interface.batch_name%type,
1002: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
1003: p_receipt_date IN ar_payments_interface.receipt_date%type,
1004: p_batches IN VARCHAR2,
1005: p_only_one_lb IN VARCHAR2,
1006: p_use_matching_date IN ar_lockboxes.use_matching_date%type,
1007: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,

Line 1009: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,

1005: p_only_one_lb IN VARCHAR2,
1006: p_use_matching_date IN ar_lockboxes.use_matching_date%type,
1007: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,
1008: p_pay_unrelated_invoices IN VARCHAR2,
1009: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,
1010: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
1011: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
1012: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
1013: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,

Line 1010: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,

1006: p_use_matching_date IN ar_lockboxes.use_matching_date%type,
1007: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,
1008: p_pay_unrelated_invoices IN VARCHAR2,
1009: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,
1010: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
1011: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
1012: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
1013: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
1014: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,

Line 1011: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,

1007: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,
1008: p_pay_unrelated_invoices IN VARCHAR2,
1009: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,
1010: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
1011: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
1012: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
1013: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
1014: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
1015: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,

Line 1012: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,

1008: p_pay_unrelated_invoices IN VARCHAR2,
1009: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,
1010: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
1011: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
1012: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
1013: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
1014: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
1015: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
1016: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,

Line 1013: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,

1009: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,
1010: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
1011: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
1012: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
1013: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
1014: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
1015: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
1016: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
1017: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,

Line 1014: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,

1010: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
1011: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
1012: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
1013: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
1014: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
1015: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
1016: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
1017: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
1018: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,

Line 1015: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,

1011: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
1012: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
1013: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
1014: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
1015: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
1016: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
1017: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
1018: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
1019: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,

Line 1016: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,

1012: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
1013: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
1014: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
1015: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
1016: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
1017: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
1018: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
1019: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
1020: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,

Line 1017: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,

1013: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
1014: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
1015: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
1016: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
1017: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
1018: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
1019: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
1020: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
1021: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,

Line 1018: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,

1014: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
1015: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
1016: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
1017: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
1018: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
1019: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
1020: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
1021: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
1022: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,

Line 1019: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,

1015: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
1016: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
1017: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
1018: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
1019: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
1020: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
1021: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
1022: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
1023: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,

Line 1020: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,

1016: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
1017: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
1018: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
1019: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
1020: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
1021: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
1022: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
1023: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
1024: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,

Line 1021: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,

1017: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
1018: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
1019: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
1020: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
1021: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
1022: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
1023: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
1024: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
1025: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,

Line 1022: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,

1018: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
1019: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
1020: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
1021: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
1022: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
1023: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
1024: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
1025: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
1026: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,

Line 1023: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,

1019: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
1020: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
1021: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
1022: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
1023: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
1024: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
1025: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
1026: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
1027: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,

Line 1024: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,

1020: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
1021: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
1022: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
1023: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
1024: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
1025: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
1026: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
1027: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
1028: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,

Line 1025: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,

1021: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
1022: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
1023: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
1024: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
1025: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
1026: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
1027: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
1028: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
1029: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,

Line 1026: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,

1022: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
1023: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
1024: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
1025: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
1026: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
1027: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
1028: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
1029: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
1030: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,

Line 1027: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,

1023: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
1024: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
1025: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
1026: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
1027: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
1028: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
1029: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
1030: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
1031: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,

Line 1028: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,

1024: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
1025: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
1026: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
1027: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
1028: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
1029: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
1030: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
1031: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,
1032: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,

Line 1029: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,

1025: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
1026: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
1027: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
1028: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
1029: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
1030: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
1031: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,
1032: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,
1033: p_matched_flag OUT NOCOPY VARCHAR2,

Line 1030: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,

1026: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
1027: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
1028: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
1029: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
1030: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
1031: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,
1032: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,
1033: p_matched_flag OUT NOCOPY VARCHAR2,
1034: p_customer_id IN OUT NOCOPY NUMBER,

Line 1031: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,

1027: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
1028: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
1029: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
1030: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
1031: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,
1032: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,
1033: p_matched_flag OUT NOCOPY VARCHAR2,
1034: p_customer_id IN OUT NOCOPY NUMBER,
1035: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,

Line 1032: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,

1028: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
1029: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
1030: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
1031: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,
1032: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,
1033: p_matched_flag OUT NOCOPY VARCHAR2,
1034: p_customer_id IN OUT NOCOPY NUMBER,
1035: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,
1036: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,

Line 1036: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,

1032: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,
1033: p_matched_flag OUT NOCOPY VARCHAR2,
1034: p_customer_id IN OUT NOCOPY NUMBER,
1035: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,
1036: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,
1037: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
1038: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
1039: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
1040: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,

Line 1037: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,

1033: p_matched_flag OUT NOCOPY VARCHAR2,
1034: p_customer_id IN OUT NOCOPY NUMBER,
1035: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,
1036: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,
1037: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
1038: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
1039: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
1040: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
1041: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,

Line 1038: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,

1034: p_customer_id IN OUT NOCOPY NUMBER,
1035: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,
1036: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,
1037: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
1038: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
1039: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
1040: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
1041: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
1042: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,

Line 1039: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,

1035: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,
1036: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,
1037: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
1038: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
1039: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
1040: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
1041: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
1042: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,
1043: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type

Line 1040: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,

1036: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,
1037: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
1038: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
1039: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
1040: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
1041: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
1042: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,
1043: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type
1044: ) IS

Line 1041: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,

1037: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
1038: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
1039: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
1040: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
1041: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
1042: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,
1043: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type
1044: ) IS
1045: --

Line 1042: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,

1038: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
1039: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
1040: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
1041: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
1042: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,
1043: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type
1044: ) IS
1045: --
1046: bind_var_does_not_exist EXCEPTION;

Line 1043: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type

1039: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
1040: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
1041: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
1042: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,
1043: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type
1044: ) IS
1045: --
1046: bind_var_does_not_exist EXCEPTION;
1047: not_all_var_bound EXCEPTION;

Line 1054: l_current_matching_number ar_payments_interface.invoice1%type;

1050: --
1051: i integer; -- Index variable, used for looping
1052: -- thru' 1 to 8 for 8 matching number.
1053: --
1054: l_current_matching_number ar_payments_interface.invoice1%type;
1055: l_current_matching_date ar_payments_interface.matching1_date%type;
1056: l_current_invoice_number ar_payments_interface.invoice1%type;
1057: l_current_invoice_date ar_payments_interface.matching1_date%type;
1058: l_current_customer_id ar_payments_interface.customer_id%type;

Line 1055: l_current_matching_date ar_payments_interface.matching1_date%type;

1051: i integer; -- Index variable, used for looping
1052: -- thru' 1 to 8 for 8 matching number.
1053: --
1054: l_current_matching_number ar_payments_interface.invoice1%type;
1055: l_current_matching_date ar_payments_interface.matching1_date%type;
1056: l_current_invoice_number ar_payments_interface.invoice1%type;
1057: l_current_invoice_date ar_payments_interface.matching1_date%type;
1058: l_current_customer_id ar_payments_interface.customer_id%type;
1059: l_current_customer_id1 ar_payments_interface.customer_id%type;

Line 1056: l_current_invoice_number ar_payments_interface.invoice1%type;

1052: -- thru' 1 to 8 for 8 matching number.
1053: --
1054: l_current_matching_number ar_payments_interface.invoice1%type;
1055: l_current_matching_date ar_payments_interface.matching1_date%type;
1056: l_current_invoice_number ar_payments_interface.invoice1%type;
1057: l_current_invoice_date ar_payments_interface.matching1_date%type;
1058: l_current_customer_id ar_payments_interface.customer_id%type;
1059: l_current_customer_id1 ar_payments_interface.customer_id%type;
1060: l_current_customer_id2 ar_payments_interface.customer_id%type;

Line 1057: l_current_invoice_date ar_payments_interface.matching1_date%type;

1053: --
1054: l_current_matching_number ar_payments_interface.invoice1%type;
1055: l_current_matching_date ar_payments_interface.matching1_date%type;
1056: l_current_invoice_number ar_payments_interface.invoice1%type;
1057: l_current_invoice_date ar_payments_interface.matching1_date%type;
1058: l_current_customer_id ar_payments_interface.customer_id%type;
1059: l_current_customer_id1 ar_payments_interface.customer_id%type;
1060: l_current_customer_id2 ar_payments_interface.customer_id%type;
1061: l_current_customer_id3 ar_payments_interface.customer_id%type;

Line 1058: l_current_customer_id ar_payments_interface.customer_id%type;

1054: l_current_matching_number ar_payments_interface.invoice1%type;
1055: l_current_matching_date ar_payments_interface.matching1_date%type;
1056: l_current_invoice_number ar_payments_interface.invoice1%type;
1057: l_current_invoice_date ar_payments_interface.matching1_date%type;
1058: l_current_customer_id ar_payments_interface.customer_id%type;
1059: l_current_customer_id1 ar_payments_interface.customer_id%type;
1060: l_current_customer_id2 ar_payments_interface.customer_id%type;
1061: l_current_customer_id3 ar_payments_interface.customer_id%type;
1062: l_current_customer_id4 ar_payments_interface.customer_id%type;

Line 1059: l_current_customer_id1 ar_payments_interface.customer_id%type;

1055: l_current_matching_date ar_payments_interface.matching1_date%type;
1056: l_current_invoice_number ar_payments_interface.invoice1%type;
1057: l_current_invoice_date ar_payments_interface.matching1_date%type;
1058: l_current_customer_id ar_payments_interface.customer_id%type;
1059: l_current_customer_id1 ar_payments_interface.customer_id%type;
1060: l_current_customer_id2 ar_payments_interface.customer_id%type;
1061: l_current_customer_id3 ar_payments_interface.customer_id%type;
1062: l_current_customer_id4 ar_payments_interface.customer_id%type;
1063: l_current_customer_id5 ar_payments_interface.customer_id%type;

Line 1060: l_current_customer_id2 ar_payments_interface.customer_id%type;

1056: l_current_invoice_number ar_payments_interface.invoice1%type;
1057: l_current_invoice_date ar_payments_interface.matching1_date%type;
1058: l_current_customer_id ar_payments_interface.customer_id%type;
1059: l_current_customer_id1 ar_payments_interface.customer_id%type;
1060: l_current_customer_id2 ar_payments_interface.customer_id%type;
1061: l_current_customer_id3 ar_payments_interface.customer_id%type;
1062: l_current_customer_id4 ar_payments_interface.customer_id%type;
1063: l_current_customer_id5 ar_payments_interface.customer_id%type;
1064: l_current_customer_id6 ar_payments_interface.customer_id%type;

Line 1061: l_current_customer_id3 ar_payments_interface.customer_id%type;

1057: l_current_invoice_date ar_payments_interface.matching1_date%type;
1058: l_current_customer_id ar_payments_interface.customer_id%type;
1059: l_current_customer_id1 ar_payments_interface.customer_id%type;
1060: l_current_customer_id2 ar_payments_interface.customer_id%type;
1061: l_current_customer_id3 ar_payments_interface.customer_id%type;
1062: l_current_customer_id4 ar_payments_interface.customer_id%type;
1063: l_current_customer_id5 ar_payments_interface.customer_id%type;
1064: l_current_customer_id6 ar_payments_interface.customer_id%type;
1065: l_current_customer_id7 ar_payments_interface.customer_id%type;

Line 1062: l_current_customer_id4 ar_payments_interface.customer_id%type;

1058: l_current_customer_id ar_payments_interface.customer_id%type;
1059: l_current_customer_id1 ar_payments_interface.customer_id%type;
1060: l_current_customer_id2 ar_payments_interface.customer_id%type;
1061: l_current_customer_id3 ar_payments_interface.customer_id%type;
1062: l_current_customer_id4 ar_payments_interface.customer_id%type;
1063: l_current_customer_id5 ar_payments_interface.customer_id%type;
1064: l_current_customer_id6 ar_payments_interface.customer_id%type;
1065: l_current_customer_id7 ar_payments_interface.customer_id%type;
1066: l_current_customer_id8 ar_payments_interface.customer_id%type;

Line 1063: l_current_customer_id5 ar_payments_interface.customer_id%type;

1059: l_current_customer_id1 ar_payments_interface.customer_id%type;
1060: l_current_customer_id2 ar_payments_interface.customer_id%type;
1061: l_current_customer_id3 ar_payments_interface.customer_id%type;
1062: l_current_customer_id4 ar_payments_interface.customer_id%type;
1063: l_current_customer_id5 ar_payments_interface.customer_id%type;
1064: l_current_customer_id6 ar_payments_interface.customer_id%type;
1065: l_current_customer_id7 ar_payments_interface.customer_id%type;
1066: l_current_customer_id8 ar_payments_interface.customer_id%type;
1067: l_current_installment ar_payments_interface.invoice1_installment%type;

Line 1064: l_current_customer_id6 ar_payments_interface.customer_id%type;

1060: l_current_customer_id2 ar_payments_interface.customer_id%type;
1061: l_current_customer_id3 ar_payments_interface.customer_id%type;
1062: l_current_customer_id4 ar_payments_interface.customer_id%type;
1063: l_current_customer_id5 ar_payments_interface.customer_id%type;
1064: l_current_customer_id6 ar_payments_interface.customer_id%type;
1065: l_current_customer_id7 ar_payments_interface.customer_id%type;
1066: l_current_customer_id8 ar_payments_interface.customer_id%type;
1067: l_current_installment ar_payments_interface.invoice1_installment%type;
1068: first_customer ar_payments_interface.customer_id%type;

Line 1065: l_current_customer_id7 ar_payments_interface.customer_id%type;

1061: l_current_customer_id3 ar_payments_interface.customer_id%type;
1062: l_current_customer_id4 ar_payments_interface.customer_id%type;
1063: l_current_customer_id5 ar_payments_interface.customer_id%type;
1064: l_current_customer_id6 ar_payments_interface.customer_id%type;
1065: l_current_customer_id7 ar_payments_interface.customer_id%type;
1066: l_current_customer_id8 ar_payments_interface.customer_id%type;
1067: l_current_installment ar_payments_interface.invoice1_installment%type;
1068: first_customer ar_payments_interface.customer_id%type;
1069: l_matching_option ar_lookups.lookup_code%type;

Line 1066: l_current_customer_id8 ar_payments_interface.customer_id%type;

1062: l_current_customer_id4 ar_payments_interface.customer_id%type;
1063: l_current_customer_id5 ar_payments_interface.customer_id%type;
1064: l_current_customer_id6 ar_payments_interface.customer_id%type;
1065: l_current_customer_id7 ar_payments_interface.customer_id%type;
1066: l_current_customer_id8 ar_payments_interface.customer_id%type;
1067: l_current_installment ar_payments_interface.invoice1_installment%type;
1068: first_customer ar_payments_interface.customer_id%type;
1069: l_matching_option ar_lookups.lookup_code%type;
1070: l_cursor_name INTEGER;

Line 1067: l_current_installment ar_payments_interface.invoice1_installment%type;

1063: l_current_customer_id5 ar_payments_interface.customer_id%type;
1064: l_current_customer_id6 ar_payments_interface.customer_id%type;
1065: l_current_customer_id7 ar_payments_interface.customer_id%type;
1066: l_current_customer_id8 ar_payments_interface.customer_id%type;
1067: l_current_installment ar_payments_interface.invoice1_installment%type;
1068: first_customer ar_payments_interface.customer_id%type;
1069: l_matching_option ar_lookups.lookup_code%type;
1070: l_cursor_name INTEGER;
1071: l_cursor_found BOOLEAN;

Line 1068: first_customer ar_payments_interface.customer_id%type;

1064: l_current_customer_id6 ar_payments_interface.customer_id%type;
1065: l_current_customer_id7 ar_payments_interface.customer_id%type;
1066: l_current_customer_id8 ar_payments_interface.customer_id%type;
1067: l_current_installment ar_payments_interface.invoice1_installment%type;
1068: first_customer ar_payments_interface.customer_id%type;
1069: l_matching_option ar_lookups.lookup_code%type;
1070: l_cursor_name INTEGER;
1071: l_cursor_found BOOLEAN;
1072: --

Line 1073: l_matching_number1 ar_payments_interface.invoice1%type;

1069: l_matching_option ar_lookups.lookup_code%type;
1070: l_cursor_name INTEGER;
1071: l_cursor_found BOOLEAN;
1072: --
1073: l_matching_number1 ar_payments_interface.invoice1%type;
1074: l_matching1_date ar_payments_interface.matching1_date%type;
1075: l_matching_number2 ar_payments_interface.invoice2%type;
1076: l_matching2_date ar_payments_interface.matching2_date%type;
1077: l_matching_number3 ar_payments_interface.invoice3%type;

Line 1074: l_matching1_date ar_payments_interface.matching1_date%type;

1070: l_cursor_name INTEGER;
1071: l_cursor_found BOOLEAN;
1072: --
1073: l_matching_number1 ar_payments_interface.invoice1%type;
1074: l_matching1_date ar_payments_interface.matching1_date%type;
1075: l_matching_number2 ar_payments_interface.invoice2%type;
1076: l_matching2_date ar_payments_interface.matching2_date%type;
1077: l_matching_number3 ar_payments_interface.invoice3%type;
1078: l_matching3_date ar_payments_interface.matching3_date%type;

Line 1075: l_matching_number2 ar_payments_interface.invoice2%type;

1071: l_cursor_found BOOLEAN;
1072: --
1073: l_matching_number1 ar_payments_interface.invoice1%type;
1074: l_matching1_date ar_payments_interface.matching1_date%type;
1075: l_matching_number2 ar_payments_interface.invoice2%type;
1076: l_matching2_date ar_payments_interface.matching2_date%type;
1077: l_matching_number3 ar_payments_interface.invoice3%type;
1078: l_matching3_date ar_payments_interface.matching3_date%type;
1079: l_matching_number4 ar_payments_interface.invoice4%type;

Line 1076: l_matching2_date ar_payments_interface.matching2_date%type;

1072: --
1073: l_matching_number1 ar_payments_interface.invoice1%type;
1074: l_matching1_date ar_payments_interface.matching1_date%type;
1075: l_matching_number2 ar_payments_interface.invoice2%type;
1076: l_matching2_date ar_payments_interface.matching2_date%type;
1077: l_matching_number3 ar_payments_interface.invoice3%type;
1078: l_matching3_date ar_payments_interface.matching3_date%type;
1079: l_matching_number4 ar_payments_interface.invoice4%type;
1080: l_matching4_date ar_payments_interface.matching4_date%type;

Line 1077: l_matching_number3 ar_payments_interface.invoice3%type;

1073: l_matching_number1 ar_payments_interface.invoice1%type;
1074: l_matching1_date ar_payments_interface.matching1_date%type;
1075: l_matching_number2 ar_payments_interface.invoice2%type;
1076: l_matching2_date ar_payments_interface.matching2_date%type;
1077: l_matching_number3 ar_payments_interface.invoice3%type;
1078: l_matching3_date ar_payments_interface.matching3_date%type;
1079: l_matching_number4 ar_payments_interface.invoice4%type;
1080: l_matching4_date ar_payments_interface.matching4_date%type;
1081: l_matching_number5 ar_payments_interface.invoice5%type;

Line 1078: l_matching3_date ar_payments_interface.matching3_date%type;

1074: l_matching1_date ar_payments_interface.matching1_date%type;
1075: l_matching_number2 ar_payments_interface.invoice2%type;
1076: l_matching2_date ar_payments_interface.matching2_date%type;
1077: l_matching_number3 ar_payments_interface.invoice3%type;
1078: l_matching3_date ar_payments_interface.matching3_date%type;
1079: l_matching_number4 ar_payments_interface.invoice4%type;
1080: l_matching4_date ar_payments_interface.matching4_date%type;
1081: l_matching_number5 ar_payments_interface.invoice5%type;
1082: l_matching5_date ar_payments_interface.matching5_date%type;

Line 1079: l_matching_number4 ar_payments_interface.invoice4%type;

1075: l_matching_number2 ar_payments_interface.invoice2%type;
1076: l_matching2_date ar_payments_interface.matching2_date%type;
1077: l_matching_number3 ar_payments_interface.invoice3%type;
1078: l_matching3_date ar_payments_interface.matching3_date%type;
1079: l_matching_number4 ar_payments_interface.invoice4%type;
1080: l_matching4_date ar_payments_interface.matching4_date%type;
1081: l_matching_number5 ar_payments_interface.invoice5%type;
1082: l_matching5_date ar_payments_interface.matching5_date%type;
1083: l_matching_number6 ar_payments_interface.invoice6%type;

Line 1080: l_matching4_date ar_payments_interface.matching4_date%type;

1076: l_matching2_date ar_payments_interface.matching2_date%type;
1077: l_matching_number3 ar_payments_interface.invoice3%type;
1078: l_matching3_date ar_payments_interface.matching3_date%type;
1079: l_matching_number4 ar_payments_interface.invoice4%type;
1080: l_matching4_date ar_payments_interface.matching4_date%type;
1081: l_matching_number5 ar_payments_interface.invoice5%type;
1082: l_matching5_date ar_payments_interface.matching5_date%type;
1083: l_matching_number6 ar_payments_interface.invoice6%type;
1084: l_matching6_date ar_payments_interface.matching6_date%type;

Line 1081: l_matching_number5 ar_payments_interface.invoice5%type;

1077: l_matching_number3 ar_payments_interface.invoice3%type;
1078: l_matching3_date ar_payments_interface.matching3_date%type;
1079: l_matching_number4 ar_payments_interface.invoice4%type;
1080: l_matching4_date ar_payments_interface.matching4_date%type;
1081: l_matching_number5 ar_payments_interface.invoice5%type;
1082: l_matching5_date ar_payments_interface.matching5_date%type;
1083: l_matching_number6 ar_payments_interface.invoice6%type;
1084: l_matching6_date ar_payments_interface.matching6_date%type;
1085: l_matching_number7 ar_payments_interface.invoice7%type;

Line 1082: l_matching5_date ar_payments_interface.matching5_date%type;

1078: l_matching3_date ar_payments_interface.matching3_date%type;
1079: l_matching_number4 ar_payments_interface.invoice4%type;
1080: l_matching4_date ar_payments_interface.matching4_date%type;
1081: l_matching_number5 ar_payments_interface.invoice5%type;
1082: l_matching5_date ar_payments_interface.matching5_date%type;
1083: l_matching_number6 ar_payments_interface.invoice6%type;
1084: l_matching6_date ar_payments_interface.matching6_date%type;
1085: l_matching_number7 ar_payments_interface.invoice7%type;
1086: l_matching7_date ar_payments_interface.matching7_date%type;

Line 1083: l_matching_number6 ar_payments_interface.invoice6%type;

1079: l_matching_number4 ar_payments_interface.invoice4%type;
1080: l_matching4_date ar_payments_interface.matching4_date%type;
1081: l_matching_number5 ar_payments_interface.invoice5%type;
1082: l_matching5_date ar_payments_interface.matching5_date%type;
1083: l_matching_number6 ar_payments_interface.invoice6%type;
1084: l_matching6_date ar_payments_interface.matching6_date%type;
1085: l_matching_number7 ar_payments_interface.invoice7%type;
1086: l_matching7_date ar_payments_interface.matching7_date%type;
1087: l_matching_number8 ar_payments_interface.invoice8%type;

Line 1084: l_matching6_date ar_payments_interface.matching6_date%type;

1080: l_matching4_date ar_payments_interface.matching4_date%type;
1081: l_matching_number5 ar_payments_interface.invoice5%type;
1082: l_matching5_date ar_payments_interface.matching5_date%type;
1083: l_matching_number6 ar_payments_interface.invoice6%type;
1084: l_matching6_date ar_payments_interface.matching6_date%type;
1085: l_matching_number7 ar_payments_interface.invoice7%type;
1086: l_matching7_date ar_payments_interface.matching7_date%type;
1087: l_matching_number8 ar_payments_interface.invoice8%type;
1088: l_matching8_date ar_payments_interface.matching8_date%type;

Line 1085: l_matching_number7 ar_payments_interface.invoice7%type;

1081: l_matching_number5 ar_payments_interface.invoice5%type;
1082: l_matching5_date ar_payments_interface.matching5_date%type;
1083: l_matching_number6 ar_payments_interface.invoice6%type;
1084: l_matching6_date ar_payments_interface.matching6_date%type;
1085: l_matching_number7 ar_payments_interface.invoice7%type;
1086: l_matching7_date ar_payments_interface.matching7_date%type;
1087: l_matching_number8 ar_payments_interface.invoice8%type;
1088: l_matching8_date ar_payments_interface.matching8_date%type;
1089: --

Line 1086: l_matching7_date ar_payments_interface.matching7_date%type;

1082: l_matching5_date ar_payments_interface.matching5_date%type;
1083: l_matching_number6 ar_payments_interface.invoice6%type;
1084: l_matching6_date ar_payments_interface.matching6_date%type;
1085: l_matching_number7 ar_payments_interface.invoice7%type;
1086: l_matching7_date ar_payments_interface.matching7_date%type;
1087: l_matching_number8 ar_payments_interface.invoice8%type;
1088: l_matching8_date ar_payments_interface.matching8_date%type;
1089: --
1090: r_invoice_number1 ar_payments_interface.invoice1%type;

Line 1087: l_matching_number8 ar_payments_interface.invoice8%type;

1083: l_matching_number6 ar_payments_interface.invoice6%type;
1084: l_matching6_date ar_payments_interface.matching6_date%type;
1085: l_matching_number7 ar_payments_interface.invoice7%type;
1086: l_matching7_date ar_payments_interface.matching7_date%type;
1087: l_matching_number8 ar_payments_interface.invoice8%type;
1088: l_matching8_date ar_payments_interface.matching8_date%type;
1089: --
1090: r_invoice_number1 ar_payments_interface.invoice1%type;
1091: r_invoice_number2 ar_payments_interface.invoice2%type;

Line 1088: l_matching8_date ar_payments_interface.matching8_date%type;

1084: l_matching6_date ar_payments_interface.matching6_date%type;
1085: l_matching_number7 ar_payments_interface.invoice7%type;
1086: l_matching7_date ar_payments_interface.matching7_date%type;
1087: l_matching_number8 ar_payments_interface.invoice8%type;
1088: l_matching8_date ar_payments_interface.matching8_date%type;
1089: --
1090: r_invoice_number1 ar_payments_interface.invoice1%type;
1091: r_invoice_number2 ar_payments_interface.invoice2%type;
1092: r_invoice_number3 ar_payments_interface.invoice3%type;

Line 1090: r_invoice_number1 ar_payments_interface.invoice1%type;

1086: l_matching7_date ar_payments_interface.matching7_date%type;
1087: l_matching_number8 ar_payments_interface.invoice8%type;
1088: l_matching8_date ar_payments_interface.matching8_date%type;
1089: --
1090: r_invoice_number1 ar_payments_interface.invoice1%type;
1091: r_invoice_number2 ar_payments_interface.invoice2%type;
1092: r_invoice_number3 ar_payments_interface.invoice3%type;
1093: r_invoice_number4 ar_payments_interface.invoice4%type;
1094: r_invoice_number5 ar_payments_interface.invoice5%type;

Line 1091: r_invoice_number2 ar_payments_interface.invoice2%type;

1087: l_matching_number8 ar_payments_interface.invoice8%type;
1088: l_matching8_date ar_payments_interface.matching8_date%type;
1089: --
1090: r_invoice_number1 ar_payments_interface.invoice1%type;
1091: r_invoice_number2 ar_payments_interface.invoice2%type;
1092: r_invoice_number3 ar_payments_interface.invoice3%type;
1093: r_invoice_number4 ar_payments_interface.invoice4%type;
1094: r_invoice_number5 ar_payments_interface.invoice5%type;
1095: r_invoice_number6 ar_payments_interface.invoice6%type;

Line 1092: r_invoice_number3 ar_payments_interface.invoice3%type;

1088: l_matching8_date ar_payments_interface.matching8_date%type;
1089: --
1090: r_invoice_number1 ar_payments_interface.invoice1%type;
1091: r_invoice_number2 ar_payments_interface.invoice2%type;
1092: r_invoice_number3 ar_payments_interface.invoice3%type;
1093: r_invoice_number4 ar_payments_interface.invoice4%type;
1094: r_invoice_number5 ar_payments_interface.invoice5%type;
1095: r_invoice_number6 ar_payments_interface.invoice6%type;
1096: r_invoice_number7 ar_payments_interface.invoice7%type;

Line 1093: r_invoice_number4 ar_payments_interface.invoice4%type;

1089: --
1090: r_invoice_number1 ar_payments_interface.invoice1%type;
1091: r_invoice_number2 ar_payments_interface.invoice2%type;
1092: r_invoice_number3 ar_payments_interface.invoice3%type;
1093: r_invoice_number4 ar_payments_interface.invoice4%type;
1094: r_invoice_number5 ar_payments_interface.invoice5%type;
1095: r_invoice_number6 ar_payments_interface.invoice6%type;
1096: r_invoice_number7 ar_payments_interface.invoice7%type;
1097: r_invoice_number8 ar_payments_interface.invoice8%type;

Line 1094: r_invoice_number5 ar_payments_interface.invoice5%type;

1090: r_invoice_number1 ar_payments_interface.invoice1%type;
1091: r_invoice_number2 ar_payments_interface.invoice2%type;
1092: r_invoice_number3 ar_payments_interface.invoice3%type;
1093: r_invoice_number4 ar_payments_interface.invoice4%type;
1094: r_invoice_number5 ar_payments_interface.invoice5%type;
1095: r_invoice_number6 ar_payments_interface.invoice6%type;
1096: r_invoice_number7 ar_payments_interface.invoice7%type;
1097: r_invoice_number8 ar_payments_interface.invoice8%type;
1098: --

Line 1095: r_invoice_number6 ar_payments_interface.invoice6%type;

1091: r_invoice_number2 ar_payments_interface.invoice2%type;
1092: r_invoice_number3 ar_payments_interface.invoice3%type;
1093: r_invoice_number4 ar_payments_interface.invoice4%type;
1094: r_invoice_number5 ar_payments_interface.invoice5%type;
1095: r_invoice_number6 ar_payments_interface.invoice6%type;
1096: r_invoice_number7 ar_payments_interface.invoice7%type;
1097: r_invoice_number8 ar_payments_interface.invoice8%type;
1098: --
1099: r_invoice1_date ar_payments_interface.matching1_date%type;

Line 1096: r_invoice_number7 ar_payments_interface.invoice7%type;

1092: r_invoice_number3 ar_payments_interface.invoice3%type;
1093: r_invoice_number4 ar_payments_interface.invoice4%type;
1094: r_invoice_number5 ar_payments_interface.invoice5%type;
1095: r_invoice_number6 ar_payments_interface.invoice6%type;
1096: r_invoice_number7 ar_payments_interface.invoice7%type;
1097: r_invoice_number8 ar_payments_interface.invoice8%type;
1098: --
1099: r_invoice1_date ar_payments_interface.matching1_date%type;
1100: r_invoice2_date ar_payments_interface.matching2_date%type;

Line 1097: r_invoice_number8 ar_payments_interface.invoice8%type;

1093: r_invoice_number4 ar_payments_interface.invoice4%type;
1094: r_invoice_number5 ar_payments_interface.invoice5%type;
1095: r_invoice_number6 ar_payments_interface.invoice6%type;
1096: r_invoice_number7 ar_payments_interface.invoice7%type;
1097: r_invoice_number8 ar_payments_interface.invoice8%type;
1098: --
1099: r_invoice1_date ar_payments_interface.matching1_date%type;
1100: r_invoice2_date ar_payments_interface.matching2_date%type;
1101: r_invoice3_date ar_payments_interface.matching3_date%type;

Line 1099: r_invoice1_date ar_payments_interface.matching1_date%type;

1095: r_invoice_number6 ar_payments_interface.invoice6%type;
1096: r_invoice_number7 ar_payments_interface.invoice7%type;
1097: r_invoice_number8 ar_payments_interface.invoice8%type;
1098: --
1099: r_invoice1_date ar_payments_interface.matching1_date%type;
1100: r_invoice2_date ar_payments_interface.matching2_date%type;
1101: r_invoice3_date ar_payments_interface.matching3_date%type;
1102: r_invoice4_date ar_payments_interface.matching4_date%type;
1103: r_invoice5_date ar_payments_interface.matching5_date%type;

Line 1100: r_invoice2_date ar_payments_interface.matching2_date%type;

1096: r_invoice_number7 ar_payments_interface.invoice7%type;
1097: r_invoice_number8 ar_payments_interface.invoice8%type;
1098: --
1099: r_invoice1_date ar_payments_interface.matching1_date%type;
1100: r_invoice2_date ar_payments_interface.matching2_date%type;
1101: r_invoice3_date ar_payments_interface.matching3_date%type;
1102: r_invoice4_date ar_payments_interface.matching4_date%type;
1103: r_invoice5_date ar_payments_interface.matching5_date%type;
1104: r_invoice6_date ar_payments_interface.matching6_date%type;

Line 1101: r_invoice3_date ar_payments_interface.matching3_date%type;

1097: r_invoice_number8 ar_payments_interface.invoice8%type;
1098: --
1099: r_invoice1_date ar_payments_interface.matching1_date%type;
1100: r_invoice2_date ar_payments_interface.matching2_date%type;
1101: r_invoice3_date ar_payments_interface.matching3_date%type;
1102: r_invoice4_date ar_payments_interface.matching4_date%type;
1103: r_invoice5_date ar_payments_interface.matching5_date%type;
1104: r_invoice6_date ar_payments_interface.matching6_date%type;
1105: r_invoice7_date ar_payments_interface.matching7_date%type;

Line 1102: r_invoice4_date ar_payments_interface.matching4_date%type;

1098: --
1099: r_invoice1_date ar_payments_interface.matching1_date%type;
1100: r_invoice2_date ar_payments_interface.matching2_date%type;
1101: r_invoice3_date ar_payments_interface.matching3_date%type;
1102: r_invoice4_date ar_payments_interface.matching4_date%type;
1103: r_invoice5_date ar_payments_interface.matching5_date%type;
1104: r_invoice6_date ar_payments_interface.matching6_date%type;
1105: r_invoice7_date ar_payments_interface.matching7_date%type;
1106: r_invoice8_date ar_payments_interface.matching8_date%type;

Line 1103: r_invoice5_date ar_payments_interface.matching5_date%type;

1099: r_invoice1_date ar_payments_interface.matching1_date%type;
1100: r_invoice2_date ar_payments_interface.matching2_date%type;
1101: r_invoice3_date ar_payments_interface.matching3_date%type;
1102: r_invoice4_date ar_payments_interface.matching4_date%type;
1103: r_invoice5_date ar_payments_interface.matching5_date%type;
1104: r_invoice6_date ar_payments_interface.matching6_date%type;
1105: r_invoice7_date ar_payments_interface.matching7_date%type;
1106: r_invoice8_date ar_payments_interface.matching8_date%type;
1107: --

Line 1104: r_invoice6_date ar_payments_interface.matching6_date%type;

1100: r_invoice2_date ar_payments_interface.matching2_date%type;
1101: r_invoice3_date ar_payments_interface.matching3_date%type;
1102: r_invoice4_date ar_payments_interface.matching4_date%type;
1103: r_invoice5_date ar_payments_interface.matching5_date%type;
1104: r_invoice6_date ar_payments_interface.matching6_date%type;
1105: r_invoice7_date ar_payments_interface.matching7_date%type;
1106: r_invoice8_date ar_payments_interface.matching8_date%type;
1107: --
1108: r_current_invoice_number ar_payments_interface.invoice1%type;

Line 1105: r_invoice7_date ar_payments_interface.matching7_date%type;

1101: r_invoice3_date ar_payments_interface.matching3_date%type;
1102: r_invoice4_date ar_payments_interface.matching4_date%type;
1103: r_invoice5_date ar_payments_interface.matching5_date%type;
1104: r_invoice6_date ar_payments_interface.matching6_date%type;
1105: r_invoice7_date ar_payments_interface.matching7_date%type;
1106: r_invoice8_date ar_payments_interface.matching8_date%type;
1107: --
1108: r_current_invoice_number ar_payments_interface.invoice1%type;
1109: r_current_invoice_date ar_payments_interface.matching1_date%type;

Line 1106: r_invoice8_date ar_payments_interface.matching8_date%type;

1102: r_invoice4_date ar_payments_interface.matching4_date%type;
1103: r_invoice5_date ar_payments_interface.matching5_date%type;
1104: r_invoice6_date ar_payments_interface.matching6_date%type;
1105: r_invoice7_date ar_payments_interface.matching7_date%type;
1106: r_invoice8_date ar_payments_interface.matching8_date%type;
1107: --
1108: r_current_invoice_number ar_payments_interface.invoice1%type;
1109: r_current_invoice_date ar_payments_interface.matching1_date%type;
1110: r_temp_int INTEGER;

Line 1108: r_current_invoice_number ar_payments_interface.invoice1%type;

1104: r_invoice6_date ar_payments_interface.matching6_date%type;
1105: r_invoice7_date ar_payments_interface.matching7_date%type;
1106: r_invoice8_date ar_payments_interface.matching8_date%type;
1107: --
1108: r_current_invoice_number ar_payments_interface.invoice1%type;
1109: r_current_invoice_date ar_payments_interface.matching1_date%type;
1110: r_temp_int INTEGER;
1111: --
1112: CURSOR matching_options IS

Line 1109: r_current_invoice_date ar_payments_interface.matching1_date%type;

1105: r_invoice7_date ar_payments_interface.matching7_date%type;
1106: r_invoice8_date ar_payments_interface.matching8_date%type;
1107: --
1108: r_current_invoice_number ar_payments_interface.invoice1%type;
1109: r_current_invoice_date ar_payments_interface.matching1_date%type;
1110: r_temp_int INTEGER;
1111: --
1112: CURSOR matching_options IS
1113: select LOOKUP_CODE

Line 2151: l_invoice_number ar_payments_interface.INVOICE1%TYPE;

2147: AND status = 'AR_PLB_NEW_RECORD';
2148:
2149: tot_app_count NUMBER;
2150: line_app_count NUMBER;
2151: l_invoice_number ar_payments_interface.INVOICE1%TYPE;
2152: l_inv_currency_code ar_payments_interface.CURRENCY_CODE%TYPE;
2153: l_currency_code ar_payments_interface.CURRENCY_CODE%TYPE;
2154: l_trans_to_receipt_rate ar_payments_interface.TRANS_TO_RECEIPT_RATE1%TYPE;
2155: l_default_by VARCHAR2(20);

Line 2152: l_inv_currency_code ar_payments_interface.CURRENCY_CODE%TYPE;

2148:
2149: tot_app_count NUMBER;
2150: line_app_count NUMBER;
2151: l_invoice_number ar_payments_interface.INVOICE1%TYPE;
2152: l_inv_currency_code ar_payments_interface.CURRENCY_CODE%TYPE;
2153: l_currency_code ar_payments_interface.CURRENCY_CODE%TYPE;
2154: l_trans_to_receipt_rate ar_payments_interface.TRANS_TO_RECEIPT_RATE1%TYPE;
2155: l_default_by VARCHAR2(20);
2156: l_line_amount_remaining NUMBER;

Line 2153: l_currency_code ar_payments_interface.CURRENCY_CODE%TYPE;

2149: tot_app_count NUMBER;
2150: line_app_count NUMBER;
2151: l_invoice_number ar_payments_interface.INVOICE1%TYPE;
2152: l_inv_currency_code ar_payments_interface.CURRENCY_CODE%TYPE;
2153: l_currency_code ar_payments_interface.CURRENCY_CODE%TYPE;
2154: l_trans_to_receipt_rate ar_payments_interface.TRANS_TO_RECEIPT_RATE1%TYPE;
2155: l_default_by VARCHAR2(20);
2156: l_line_amount_remaining NUMBER;
2157: l_line_tax_remaining NUMBER;

Line 2154: l_trans_to_receipt_rate ar_payments_interface.TRANS_TO_RECEIPT_RATE1%TYPE;

2150: line_app_count NUMBER;
2151: l_invoice_number ar_payments_interface.INVOICE1%TYPE;
2152: l_inv_currency_code ar_payments_interface.CURRENCY_CODE%TYPE;
2153: l_currency_code ar_payments_interface.CURRENCY_CODE%TYPE;
2154: l_trans_to_receipt_rate ar_payments_interface.TRANS_TO_RECEIPT_RATE1%TYPE;
2155: l_default_by VARCHAR2(20);
2156: l_line_amount_remaining NUMBER;
2157: l_line_tax_remaining NUMBER;
2158: line_amt_due_original NUMBER;

Line 2176: l_trans_record_id ar_payments_interface.TRANSMISSION_RECORD_ID%TYPE;

2172: l_calc_per_line NUMBER;
2173: l_calc_tot_amount_app NUMBER;
2174: l_calc_line_amount NUMBER;
2175: l_calc_tax_amount NUMBER;
2176: l_trans_record_id ar_payments_interface.TRANSMISSION_RECORD_ID%TYPE;
2177: format_amount_app1 varchar2(2);
2178: format_amount_app2 varchar2(2);
2179: format_amount_app3 varchar2(2);
2180: format_amount_app4 varchar2(2);

Line 2213: FROM ar_payments_interface interface

2209:
2210: UPDATE ar_pmts_interface_line_details line_details
2211: SET status = 'AR_PLB_INVALID_REC_ID'
2212: WHERE transmission_record_id in ( SELECT transmission_record_id
2213: FROM ar_payments_interface interface
2214: WHERE interface.transmission_request_id = p_trans_req_id
2215: AND interface.transmission_record_id = line_details.transmission_record_id
2216: GROUP BY transmission_record_id
2217: HAVING count(transmission_record_id) <> 1

Line 2225: FROM ar_payments_interface interface

2221:
2222: UPDATE ar_pmts_interface_line_details line_details
2223: SET status = 'AR_PLB_INVALID_RECORD'
2224: WHERE transmission_record_id in ( SELECT transmission_record_id
2225: FROM ar_payments_interface interface
2226: WHERE interface.transmission_request_id = p_trans_req_id
2227: AND interface.transmission_record_id = line_details.transmission_record_id
2228: AND status <> 'AR_PLB_APP_OK')
2229: AND transmission_request_id = p_trans_req_id

Line 2234: FROM ar_payments_interface

2230: AND status = 'AR_PLB_NEW_RECORD';
2231:
2232: SELECT transmission_record_id
2233: INTO l_trans_record_id
2234: FROM ar_payments_interface
2235: WHERE transmission_request_id = p_trans_req_id
2236: AND rownum = 1;
2237:
2238: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2294: FROM ar_payments_interface interface,

2290: amount_applied1),
2291: nvl(trans_to_receipt_rate1,1),
2292: invoice_currency_code1,
2293: status
2294: FROM ar_payments_interface interface,
2295: fnd_currencies fc,
2296: fnd_currencies fc1
2297: WHERE invoice1 is NOT NULL
2298: AND transmission_request_id = p_trans_req_id

Line 2331: FROM ar_payments_interface interface,

2327: amount_applied2),
2328: nvl(trans_to_receipt_rate2,1),
2329: invoice_currency_code2,
2330: status
2331: FROM ar_payments_interface interface,
2332: fnd_currencies fc,
2333: fnd_currencies fc1
2334: WHERE invoice2 is NOT NULL
2335: AND transmission_request_id = p_trans_req_id

Line 2368: FROM ar_payments_interface interface,

2364: amount_applied3),
2365: nvl(trans_to_receipt_rate3,1),
2366: invoice_currency_code3,
2367: status
2368: FROM ar_payments_interface interface,
2369: fnd_currencies fc,
2370: fnd_currencies fc1
2371: WHERE invoice3 is NOT NULL
2372: AND transmission_request_id = p_trans_req_id

Line 2405: FROM ar_payments_interface interface,

2401: amount_applied4),
2402: nvl(trans_to_receipt_rate4,1),
2403: invoice_currency_code4,
2404: status
2405: FROM ar_payments_interface interface,
2406: fnd_currencies fc,
2407: fnd_currencies fc1
2408: WHERE invoice4 is NOT NULL
2409: AND transmission_request_id = p_trans_req_id

Line 2442: FROM ar_payments_interface interface,

2438: amount_applied5),
2439: nvl(trans_to_receipt_rate5,1),
2440: invoice_currency_code5,
2441: status
2442: FROM ar_payments_interface interface,
2443: fnd_currencies fc,
2444: fnd_currencies fc1
2445: WHERE invoice5 is NOT NULL
2446: AND transmission_request_id = p_trans_req_id

Line 2479: FROM ar_payments_interface interface,

2475: amount_applied6),
2476: nvl(trans_to_receipt_rate6,1),
2477: invoice_currency_code6,
2478: status
2479: FROM ar_payments_interface interface,
2480: fnd_currencies fc,
2481: fnd_currencies fc1
2482: WHERE invoice6 is NOT NULL
2483: AND transmission_request_id = p_trans_req_id

Line 2516: FROM ar_payments_interface interface,

2512: amount_applied7),
2513: nvl(trans_to_receipt_rate7,1),
2514: invoice_currency_code7,
2515: status
2516: FROM ar_payments_interface interface,
2517: fnd_currencies fc,
2518: fnd_currencies fc1
2519: WHERE invoice7 is NOT NULL
2520: AND transmission_request_id = p_trans_req_id

Line 2553: FROM ar_payments_interface interface,

2549: amount_applied8),
2550: nvl(trans_to_receipt_rate8,1),
2551: invoice_currency_code8,
2552: status
2553: FROM ar_payments_interface interface,
2554: fnd_currencies fc,
2555: fnd_currencies fc1
2556: WHERE invoice8 is NOT NULL
2557: AND transmission_request_id = p_trans_req_id

Line 3124: UPDATE ar_payments_interface interface

3120: WHERE status = 'AR_PLB_NEW_RECORD'
3121: AND transmission_request_id = p_trans_req_id;
3122:
3123: IF p_allow_invalid_trx_num = 'Y' THEN
3124: UPDATE ar_payments_interface interface
3125: SET resolved_matching_number1 = NULL
3126: WHERE (transmission_record_id, resolved_matching_number1)
3127: IN (SELECT transmission_record_id, invoice_number
3128: FROM ar_pmts_interface_line_details line_details

Line 3133: UPDATE ar_payments_interface interface

3129: WHERE transmission_request_id = p_trans_req_id
3130: AND status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3131: AND transmission_request_id = p_trans_req_id;
3132:
3133: UPDATE ar_payments_interface interface
3134: SET resolved_matching_number2 = NULL
3135: WHERE (transmission_record_id, resolved_matching_number2)
3136: IN (SELECT transmission_record_id, invoice_number
3137: FROM ar_pmts_interface_line_details line_details

Line 3142: UPDATE ar_payments_interface interface

3138: WHERE transmission_request_id = p_trans_req_id
3139: AND status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3140: AND transmission_request_id = p_trans_req_id;
3141:
3142: UPDATE ar_payments_interface interface
3143: SET resolved_matching_number3 = NULL
3144: WHERE (transmission_record_id, resolved_matching_number3)
3145: IN (SELECT transmission_record_id, invoice_number
3146: FROM ar_pmts_interface_line_details line_details

Line 3151: UPDATE ar_payments_interface interface

3147: WHERE transmission_request_id = p_trans_req_id
3148: AND status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3149: AND transmission_request_id = p_trans_req_id;
3150:
3151: UPDATE ar_payments_interface interface
3152: SET resolved_matching_number4 = NULL
3153: WHERE (transmission_record_id, resolved_matching_number4)
3154: IN (SELECT transmission_record_id, invoice_number
3155: FROM ar_pmts_interface_line_details line_details

Line 3160: UPDATE ar_payments_interface interface

3156: WHERE transmission_request_id = p_trans_req_id
3157: AND status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3158: AND transmission_request_id = p_trans_req_id;
3159:
3160: UPDATE ar_payments_interface interface
3161: SET resolved_matching_number5 = NULL
3162: WHERE (transmission_record_id, resolved_matching_number5)
3163: IN (SELECT transmission_record_id, invoice_number
3164: FROM ar_pmts_interface_line_details line_details

Line 3169: UPDATE ar_payments_interface interface

3165: WHERE transmission_request_id = p_trans_req_id
3166: AND status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3167: AND transmission_request_id = p_trans_req_id;
3168:
3169: UPDATE ar_payments_interface interface
3170: SET resolved_matching_number6 = NULL
3171: WHERE (transmission_record_id, resolved_matching_number6)
3172: IN (SELECT transmission_record_id, invoice_number
3173: FROM ar_pmts_interface_line_details line_details

Line 3178: UPDATE ar_payments_interface interface

3174: WHERE transmission_request_id = p_trans_req_id
3175: AND status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3176: AND transmission_request_id = p_trans_req_id;
3177:
3178: UPDATE ar_payments_interface interface
3179: SET resolved_matching_number7 = NULL
3180: WHERE (transmission_record_id, resolved_matching_number7)
3181: IN (SELECT transmission_record_id, invoice_number
3182: FROM ar_pmts_interface_line_details line_details

Line 3187: UPDATE ar_payments_interface interface

3183: WHERE transmission_request_id = p_trans_req_id
3184: AND status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3185: AND transmission_request_id = p_trans_req_id;
3186:
3187: UPDATE ar_payments_interface interface
3188: SET resolved_matching_number8 = NULL
3189: WHERE (transmission_record_id, resolved_matching_number8)
3190: IN (SELECT transmission_record_id, invoice_number
3191: FROM ar_pmts_interface_line_details line_details

Line 3196: UPDATE ar_payments_interface interface

3192: WHERE transmission_request_id = p_trans_req_id
3193: AND status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3194: AND transmission_request_id = p_trans_req_id;
3195: ELSE
3196: UPDATE ar_payments_interface interface
3197: SET invoice1_status = 'AR_PLB_INVALID_LINE_DET'
3198: WHERE (transmission_record_id, resolved_matching_number1)
3199: IN (SELECT transmission_record_id, invoice_number
3200: FROM ar_pmts_interface_line_details line_details

Line 3205: UPDATE ar_payments_interface interface

3201: WHERE transmission_request_id = p_trans_req_id
3202: AND line_details.status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3203: AND transmission_request_id = p_trans_req_id;
3204:
3205: UPDATE ar_payments_interface interface
3206: SET invoice2_status = 'AR_PLB_INVALID_LINE_DET'
3207: WHERE (transmission_record_id, resolved_matching_number2)
3208: IN (SELECT transmission_record_id, invoice_number
3209: FROM ar_pmts_interface_line_details line_details

Line 3214: UPDATE ar_payments_interface interface

3210: WHERE transmission_request_id = p_trans_req_id
3211: AND line_details.status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3212: AND transmission_request_id = p_trans_req_id;
3213:
3214: UPDATE ar_payments_interface interface
3215: SET invoice3_status = 'AR_PLB_INVALID_LINE_DET'
3216: WHERE (transmission_record_id, resolved_matching_number3)
3217: IN (SELECT transmission_record_id, invoice_number
3218: FROM ar_pmts_interface_line_details line_details

Line 3223: UPDATE ar_payments_interface interface

3219: WHERE transmission_request_id = p_trans_req_id
3220: AND line_details.status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3221: AND transmission_request_id = p_trans_req_id;
3222:
3223: UPDATE ar_payments_interface interface
3224: SET invoice4_status = 'AR_PLB_INVALID_LINE_DET'
3225: WHERE (transmission_record_id, resolved_matching_number4)
3226: IN (SELECT transmission_record_id, invoice_number
3227: FROM ar_pmts_interface_line_details line_details

Line 3232: UPDATE ar_payments_interface interface

3228: WHERE transmission_request_id = p_trans_req_id
3229: AND line_details.status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3230: AND transmission_request_id = p_trans_req_id;
3231:
3232: UPDATE ar_payments_interface interface
3233: SET invoice5_status = 'AR_PLB_INVALID_LINE_DET'
3234: WHERE (transmission_record_id, resolved_matching_number5)
3235: IN (SELECT transmission_record_id, invoice_number
3236: FROM ar_pmts_interface_line_details line_details

Line 3241: UPDATE ar_payments_interface interface

3237: WHERE transmission_request_id = p_trans_req_id
3238: AND line_details.status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3239: AND transmission_request_id = p_trans_req_id;
3240:
3241: UPDATE ar_payments_interface interface
3242: SET invoice6_status = 'AR_PLB_INVALID_LINE_DET'
3243: WHERE (transmission_record_id, resolved_matching_number6)
3244: IN (SELECT transmission_record_id, invoice_number
3245: FROM ar_pmts_interface_line_details line_details

Line 3250: UPDATE ar_payments_interface interface

3246: WHERE transmission_request_id = p_trans_req_id
3247: AND line_details.status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3248: AND transmission_request_id = p_trans_req_id;
3249:
3250: UPDATE ar_payments_interface interface
3251: SET invoice7_status = 'AR_PLB_INVALID_LINE_DET'
3252: WHERE (transmission_record_id, resolved_matching_number7)
3253: IN (SELECT transmission_record_id, invoice_number
3254: FROM ar_pmts_interface_line_details line_details

Line 3259: UPDATE ar_payments_interface interface

3255: WHERE transmission_request_id = p_trans_req_id
3256: AND line_details.status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3257: AND transmission_request_id = p_trans_req_id;
3258:
3259: UPDATE ar_payments_interface interface
3260: SET invoice8_status = 'AR_PLB_INVALID_LINE_DET'
3261: WHERE (transmission_record_id, resolved_matching_number8)
3262: IN (SELECT transmission_record_id, invoice_number
3263: FROM ar_pmts_interface_line_details line_details

Line 3268: UPDATE ar_payments_interface interface

3264: WHERE transmission_request_id = p_trans_req_id
3265: AND line_details.status NOT IN ('AR_PLB_INVALID_RECORD', 'AR_PLB_LINE_OK'))
3266: AND transmission_request_id = p_trans_req_id;
3267:
3268: UPDATE ar_payments_interface interface
3269: SET status = 'AR_PLB_INVALID_RECEIPT'
3270: WHERE (item_number, nvl(batch_name, -1))
3271: IN (SELECT item_number, nvl(batch_name, -1)
3272: FROM ar_payments_interface interface1

Line 3272: FROM ar_payments_interface interface1

3268: UPDATE ar_payments_interface interface
3269: SET status = 'AR_PLB_INVALID_RECEIPT'
3270: WHERE (item_number, nvl(batch_name, -1))
3271: IN (SELECT item_number, nvl(batch_name, -1)
3272: FROM ar_payments_interface interface1
3273: WHERE interface1.transmission_request_id = p_trans_req_id
3274: AND ( interface1.invoice1_status = 'AR_PLB_INVALID_LINE_DET'
3275: OR interface1.invoice2_status = 'AR_PLB_INVALID_LINE_DET'
3276: OR interface1.invoice3_status = 'AR_PLB_INVALID_LINE_DET'

Line 3308: AR_PAYMENTS_INTERFACE_all PI,

3304: into l_format_yn
3305: from
3306: AR_TRANS_FIELD_FORMATS FF,
3307: AR_TRANS_RECORD_FORMATS RF,
3308: AR_PAYMENTS_INTERFACE_all PI,
3309: AR_TRANSMISSIONS_all TR
3310: where TR.transmission_request_id = p_trans_req_id
3311: and PI.transmission_record_id = p_trans_rec_id
3312: and RF.transmission_format_id = TR.requested_trans_format_id

Line 3378: p_trans_req_id IN ar_payments_interface.transmission_request_id%type,

3374: PROCEDURE insert_interim_line_details(
3375: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3376: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%type,
3377: p_cash_receipt_line_id IN NUMBER,
3378: p_trans_req_id IN ar_payments_interface.transmission_request_id%type,
3379: p_return_status OUT NOCOPY varchar2
3380: )
3381: IS
3382: cursor interface_det_lines(inv_num in varchar2,req_id in number, receipt_id in number) is

Line 3402: from ar_payments_interface payment, ar_payments_interface overflow,

3398: where transmission_request_id = req_id
3399: and invoice_number = inv_num
3400: and transmission_record_id in (
3401: select overflow.transmission_record_id
3402: from ar_payments_interface payment, ar_payments_interface overflow,
3403: ar_trans_record_formats format, ar_transmissions transmissions,
3404: ar_interim_cash_receipts cash
3405: where payment.check_number = cash.receipt_number
3406: and payment.transmission_request_id = overflow.transmission_request_id