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.

APPS.ARP_PROGRAM_GENERATE_BR dependencies on AR_PAYMENT_SCHEDULES

Line 9: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

5: PROCEDURE from_automatic_batch_window(
6: p_draft_mode IN VARCHAR2,
7: p_print_flag IN VARCHAR2,
8: p_batch_id IN RA_BATCHES.batch_id%TYPE,
9: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
10: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
11: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
12: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
13: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

Line 10: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

6: p_draft_mode IN VARCHAR2,
7: p_print_flag IN VARCHAR2,
8: p_batch_id IN RA_BATCHES.batch_id%TYPE,
9: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
10: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
11: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
12: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
13: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
14: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 50: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

46: p_attribute12 IN VARCHAR2,
47: p_attribute13 IN VARCHAR2,
48: p_attribute14 IN VARCHAR2,
49: p_attribute15 IN VARCHAR2,
50: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
51: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
52: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
53: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
54: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

Line 51: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

47: p_attribute13 IN VARCHAR2,
48: p_attribute14 IN VARCHAR2,
49: p_attribute15 IN VARCHAR2,
50: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
51: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
52: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
53: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
54: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
55: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 95: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

91: p_attribute12 IN VARCHAR2,
92: p_attribute13 IN VARCHAR2,
93: p_attribute14 IN VARCHAR2,
94: p_attribute15 IN VARCHAR2,
95: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
96: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
97: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
98: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
99: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

Line 96: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

92: p_attribute13 IN VARCHAR2,
93: p_attribute14 IN VARCHAR2,
94: p_attribute15 IN VARCHAR2,
95: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
96: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
97: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
98: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
99: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
100: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 121: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

117: PROCEDURE select_trx_and_create_BR(
118: p_draft_mode IN VARCHAR2,
119: p_call IN NUMBER,
120: p_batch_id IN RA_BATCHES.batch_id%TYPE,
121: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
122: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
123: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
124: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
125: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

Line 122: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

118: p_draft_mode IN VARCHAR2,
119: p_call IN NUMBER,
120: p_batch_id IN RA_BATCHES.batch_id%TYPE,
121: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
122: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
123: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
124: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
125: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
126: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 139: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

135: -- Bug 3922691 : added additional parameters so dynamic sql can be more fine-tuned
136: PROCEDURE construct_suffixe_select(
137: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
138: p_suffixe_select_statement OUT NOCOPY varchar2,
139: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
140: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
141: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
142: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
143: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 140: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

136: PROCEDURE construct_suffixe_select(
137: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
138: p_suffixe_select_statement OUT NOCOPY varchar2,
139: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
140: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
141: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
142: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
143: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
144: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 162: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

158: -- bug 3922691 : remove p_suffixe_select_statement, add p_lead_days
159: PROCEDURE select_DM_and_CM_IMM(
160: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
161: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
162: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
163: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
164: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
165: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
166: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 163: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

159: PROCEDURE select_DM_and_CM_IMM(
160: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
161: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
162: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
163: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
164: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
165: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
166: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
167: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 184: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

180: -- bug 3922691 : remove p_suffixe_select_statement, add p_lead_days
181: PROCEDURE select_trx_NIMM(
182: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
183: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
184: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
185: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
186: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
187: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
188: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

Line 185: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

181: PROCEDURE select_trx_NIMM(
182: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
183: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
184: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
185: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
186: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
187: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
188: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
189: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 199: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,

195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
196: p_batch_id IN RA_BATCHES.batch_id%TYPE,
197: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
198: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
199: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
200: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
201: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
202: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
203:

Line 262: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE ,

258:
259: g_ctr NUMBER := 0;
260:
261: TYPE errorinvoicerectyp IS RECORD (
262: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE ,
263: customer_trx_id ar_payment_schedules.customer_trx_id%TYPE ,
264: trx_number ar_payment_schedules.trx_number%TYPE);
265:
266: TYPE errorinvoicetabtyp IS TABLE OF errorinvoicerectyp

Line 263: customer_trx_id ar_payment_schedules.customer_trx_id%TYPE ,

259: g_ctr NUMBER := 0;
260:
261: TYPE errorinvoicerectyp IS RECORD (
262: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE ,
263: customer_trx_id ar_payment_schedules.customer_trx_id%TYPE ,
264: trx_number ar_payment_schedules.trx_number%TYPE);
265:
266: TYPE errorinvoicetabtyp IS TABLE OF errorinvoicerectyp
267: INDEX by BINARY_INTEGER;

Line 264: trx_number ar_payment_schedules.trx_number%TYPE);

260:
261: TYPE errorinvoicerectyp IS RECORD (
262: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE ,
263: customer_trx_id ar_payment_schedules.customer_trx_id%TYPE ,
264: trx_number ar_payment_schedules.trx_number%TYPE);
265:
266: TYPE errorinvoicetabtyp IS TABLE OF errorinvoicerectyp
267: INDEX by BINARY_INTEGER;
268:

Line 274: due_date AR_PAYMENT_SCHEDULES.due_date%TYPE,

270:
271: /* Bug 14146916 */
272: TYPE skipped_br_records IS RECORD (
273: customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
274: due_date AR_PAYMENT_SCHEDULES.due_date%TYPE,
275: site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,
276: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE);
277:
278: TYPE skipped_br_tabtyp IS TABLE OF skipped_br_records

Line 275: site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,

271: /* Bug 14146916 */
272: TYPE skipped_br_records IS RECORD (
273: customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
274: due_date AR_PAYMENT_SCHEDULES.due_date%TYPE,
275: site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,
276: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE);
277:
278: TYPE skipped_br_tabtyp IS TABLE OF skipped_br_records
279: INDEX by BINARY_INTEGER;

Line 276: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE);

272: TYPE skipped_br_records IS RECORD (
273: customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
274: due_date AR_PAYMENT_SCHEDULES.due_date%TYPE,
275: site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,
276: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE);
277:
278: TYPE skipped_br_tabtyp IS TABLE OF skipped_br_records
279: INDEX by BINARY_INTEGER;
280:

Line 614: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

610: PROCEDURE from_automatic_batch_window(
611: p_draft_mode IN VARCHAR2,
612: p_print_flag IN VARCHAR2,
613: p_batch_id IN RA_BATCHES.batch_id%TYPE,
614: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
615: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
616: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
617: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
618: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 615: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

611: p_draft_mode IN VARCHAR2,
612: p_print_flag IN VARCHAR2,
613: p_batch_id IN RA_BATCHES.batch_id%TYPE,
614: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
615: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
616: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
617: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
618: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
619: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 732: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

728: p_attribute12 IN VARCHAR2,
729: p_attribute13 IN VARCHAR2,
730: p_attribute14 IN VARCHAR2,
731: p_attribute15 IN VARCHAR2,
732: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
733: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
734: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
735: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
736: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 733: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

729: p_attribute13 IN VARCHAR2,
730: p_attribute14 IN VARCHAR2,
731: p_attribute15 IN VARCHAR2,
732: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
733: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
734: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
735: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
736: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
737: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 897: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

893: p_attribute12 IN VARCHAR2,
894: p_attribute13 IN VARCHAR2,
895: p_attribute14 IN VARCHAR2,
896: p_attribute15 IN VARCHAR2,
897: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
898: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
899: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
900: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
901: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 898: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

894: p_attribute13 IN VARCHAR2,
895: p_attribute14 IN VARCHAR2,
896: p_attribute15 IN VARCHAR2,
897: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
898: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
899: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
900: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
901: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
902: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 1169: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

1165: PROCEDURE select_trx_and_create_BR(
1166: p_draft_mode IN VARCHAR2,
1167: p_call IN NUMBER,
1168: p_batch_id IN RA_BATCHES.batch_id%TYPE,
1169: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1170: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1171: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1172: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1173: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 1170: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

1166: p_draft_mode IN VARCHAR2,
1167: p_call IN NUMBER,
1168: p_batch_id IN RA_BATCHES.batch_id%TYPE,
1169: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1170: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1171: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1172: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1173: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1174: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 1304: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

1300:
1301: -- 2nd break criteria
1302: l_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1303: l_customer_id2 HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1304: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
1305: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1306: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
1307: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1308:

Line 1305: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

1301: -- 2nd break criteria
1302: l_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1303: l_customer_id2 HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1304: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
1305: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1306: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
1307: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1308:
1309: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

Line 1306: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;

1302: l_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1303: l_customer_id2 HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1304: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
1305: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1306: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
1307: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1308:
1309: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
1310: l_request_id NUMBER;

Line 1307: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

1303: l_customer_id2 HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1304: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
1305: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1306: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
1307: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1308:
1309: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
1310: l_request_id NUMBER;
1311: -- 3922691

Line 2020: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

2016:
2017: PROCEDURE construct_suffixe_select(
2018: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2019: p_suffixe_select_statement OUT NOCOPY varchar2,
2020: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2021: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2022: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2023: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2024: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 2021: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

2017: PROCEDURE construct_suffixe_select(
2018: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2019: p_suffixe_select_statement OUT NOCOPY varchar2,
2020: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2021: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2022: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2023: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2024: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2025: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 2062: ar_payment_schedules ps,

2058:
2059: l_trx_select_statement :=
2060: 'FROM ra_batches batch,
2061: ar_receipt_methods pm,
2062: ar_payment_schedules ps,
2063: ra_customer_trx trx,
2064: ra_cust_trx_types type,
2065: fnd_currencies_vl cur,
2066: hz_cust_accounts cust,

Line 2250: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

2246: +===========================================================================*/
2247: PROCEDURE select_DM_and_CM_IMM(
2248: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2249: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2250: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2251: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2252: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2253: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2254: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 2251: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

2247: PROCEDURE select_DM_and_CM_IMM(
2248: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2249: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2250: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2251: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2252: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2253: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2254: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2255: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 2281: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

2277: l_aimm_ctr NUMBER;
2278:
2279: c_trx cur_typ;
2280:
2281: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2282: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2283: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2284: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2285: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

Line 2282: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;

2278:
2279: c_trx cur_typ;
2280:
2281: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2282: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2283: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2284: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2285: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2286: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

Line 2283: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

2279: c_trx cur_typ;
2280:
2281: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2282: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2283: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2284: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2285: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2286: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2287: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

Line 2284: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;

2280:
2281: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2282: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2283: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2284: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2285: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2286: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2287: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2288: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 2285: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

2281: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2282: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2283: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2284: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2285: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2286: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2287: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2288: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2289: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;

Line 2286: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

2282: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2283: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2284: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2285: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2286: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2287: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2288: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2289: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2290:

Line 2287: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

2283: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2284: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2285: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2286: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2287: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2288: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2289: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2290:
2291: BEGIN

Line 2288: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

2284: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2285: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2286: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2287: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2288: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2289: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2290:
2291: BEGIN
2292:

Line 2289: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;

2285: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2286: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2287: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2288: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2289: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2290:
2291: BEGIN
2292:
2293: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM (+)');

Line 2498: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

2494: +===========================================================================*/
2495: PROCEDURE select_trx_NIMM(
2496: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2497: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2498: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2499: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2500: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2501: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2502: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

Line 2499: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

2495: PROCEDURE select_trx_NIMM(
2496: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2497: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2498: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2499: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2500: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2501: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2502: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2503: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 2513: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,

2509: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2510: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2511: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2512: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2513: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2514: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2515: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2516: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2517:

Line 2527: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

2523: l_insert_statement VARCHAR2(2000);
2524:
2525: c_trx cur_typ;
2526:
2527: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2528: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2529: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2531: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

Line 2528: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;

2524:
2525: c_trx cur_typ;
2526:
2527: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2528: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2529: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2531: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2532: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

Line 2529: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

2525: c_trx cur_typ;
2526:
2527: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2528: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2529: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2531: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2532: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2533: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

Line 2530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;

2526:
2527: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2528: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2529: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2531: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2532: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2533: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2534: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 2531: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

2527: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2528: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2529: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2531: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2532: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2533: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2534: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2535: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;

Line 2532: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

2528: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2529: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2531: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2532: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2533: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2534: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2535: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2536:

Line 2533: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

2529: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2531: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2532: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2533: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2534: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2535: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2536:
2537: BEGIN

Line 2534: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

2530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2531: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2532: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2533: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2534: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2535: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2536:
2537: BEGIN
2538:

Line 2535: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;

2531: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2532: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2533: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2534: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2535: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2536:
2537: BEGIN
2538:
2539: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_NIMM (+)');

Line 2772: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

2768: l_return_status VARCHAR2(20);
2769: l_msg_count NUMBER;
2770: l_msg_data VARCHAR2(4000);
2771:
2772: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2773:
2774: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2775: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2776: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;

Line 2826: l_excluded_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

2822: l_tot_nimm NUMBER;
2823: l_tot_imm NUMBER;
2824: l_br_amount NUMBER;
2825:
2826: l_excluded_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2827: l_assigned_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2828:
2829: l_tot_negative_count NUMBER;
2830: l_tot_positive_count NUMBER;

Line 2827: l_assigned_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

2823: l_tot_imm NUMBER;
2824: l_br_amount NUMBER;
2825:
2826: l_excluded_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2827: l_assigned_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2828:
2829: l_tot_negative_count NUMBER;
2830: l_tot_positive_count NUMBER;
2831:

Line 2838: l_bill_to_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

2834:
2835: l_org_id NUMBER;
2836:
2837: -- Bug 1710187 : define a variable to hold customer_site_use_id for transaction being exchanged for BR
2838: l_bill_to_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2839:
2840: -- Bug 1708420 : define variable to hold BR_INHERIT_INV_NUM_FLAG value
2841: l_br_inherit_inv_num_flag AR_RECEIPT_METHODS.BR_INHERIT_INV_NUM_FLAG%TYPE;
2842: l_trx_number RA_CUSTOMER_TRX.TRX_NUMBER%TYPE;

Line 2864: c_psid AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE;

2860: 'amount_due_remaining, nvl(exclude_flag,''N''), org_id FROM '|| g_tmp_table_imm ||
2861: ' ORDER BY due_date DESC, amount_due_remaining DESC';
2862: use_cursor_stmt VARCHAR2(1000);
2863: cursor_loop cur_typ;
2864: c_psid AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE;
2865: c_due AR_PAYMENT_SCHEDULES.DUE_DATE%TYPE;
2866: c_adr AR_PAYMENT_SCHEDULES.AMOUNT_DUE_REMAINING%TYPE;
2867: c_exc VARCHAR2(1);
2868: c_orgid AR_PAYMENT_SCHEDULES.ORG_ID%TYPE;

Line 2865: c_due AR_PAYMENT_SCHEDULES.DUE_DATE%TYPE;

2861: ' ORDER BY due_date DESC, amount_due_remaining DESC';
2862: use_cursor_stmt VARCHAR2(1000);
2863: cursor_loop cur_typ;
2864: c_psid AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE;
2865: c_due AR_PAYMENT_SCHEDULES.DUE_DATE%TYPE;
2866: c_adr AR_PAYMENT_SCHEDULES.AMOUNT_DUE_REMAINING%TYPE;
2867: c_exc VARCHAR2(1);
2868: c_orgid AR_PAYMENT_SCHEDULES.ORG_ID%TYPE;
2869: -- end 4006714

Line 2866: c_adr AR_PAYMENT_SCHEDULES.AMOUNT_DUE_REMAINING%TYPE;

2862: use_cursor_stmt VARCHAR2(1000);
2863: cursor_loop cur_typ;
2864: c_psid AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE;
2865: c_due AR_PAYMENT_SCHEDULES.DUE_DATE%TYPE;
2866: c_adr AR_PAYMENT_SCHEDULES.AMOUNT_DUE_REMAINING%TYPE;
2867: c_exc VARCHAR2(1);
2868: c_orgid AR_PAYMENT_SCHEDULES.ORG_ID%TYPE;
2869: -- end 4006714
2870:

Line 2868: c_orgid AR_PAYMENT_SCHEDULES.ORG_ID%TYPE;

2864: c_psid AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE;
2865: c_due AR_PAYMENT_SCHEDULES.DUE_DATE%TYPE;
2866: c_adr AR_PAYMENT_SCHEDULES.AMOUNT_DUE_REMAINING%TYPE;
2867: c_exc VARCHAR2(1);
2868: c_orgid AR_PAYMENT_SCHEDULES.ORG_ID%TYPE;
2869: -- end 4006714
2870:
2871: jnk1 NUMBER;
2872: jnk2 NUMBER;

Line 3243: 'from ar_payment_schedules ps ' ||

3239: execute immediate l_statement INTO l_count_trxid, l_cust_trx_id;
3240:
3241: IF l_count_trxid = 1 THEN
3242: l_statement := 'SELECT count(*), max(ps.trx_number) ' ||
3243: 'from ar_payment_schedules ps ' ||
3244: 'where ps.customer_trx_id = ' ||
3245: l_cust_trx_id ;
3246: execute immediate l_statement INTO l_count_ps, l_trx_number;
3247:

Line 4901: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

4897:
4898: -- bug 1808976 :
4899: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;
4900:
4901: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4902: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4903: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4904: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4905: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;

Line 4902: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;

4898: -- bug 1808976 :
4899: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;
4900:
4901: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4902: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4903: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4904: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4905: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4906: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

Line 4903: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

4899: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;
4900:
4901: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4902: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4903: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4904: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4905: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4906: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4907: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

Line 4904: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;

4900:
4901: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4902: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4903: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4904: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4905: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4906: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4907: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4908: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

Line 4905: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;

4901: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4902: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4903: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4904: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4905: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4906: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4907: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4908: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4909: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

Line 4906: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

4902: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4903: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4904: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4905: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4906: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4907: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4908: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4909: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4910: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 4907: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

4903: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4904: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4905: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4906: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4907: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4908: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4909: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4910: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4911:

Line 4908: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

4904: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4905: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4906: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4907: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4908: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4909: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4910: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4911:
4912: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

Line 4909: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

4905: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4906: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4907: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4908: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4909: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4910: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4911:
4912: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
4913: l_request_id NUMBER;

Line 4910: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

4906: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4907: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4908: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4909: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4910: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4911:
4912: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
4913: l_request_id NUMBER;
4914:

Line 4981: l_suffixe_select_statement := ' FROM ar_payment_schedules ps,'||

4977: Also added additional condition to check if the payment schedule is open and
4978: to check that the transaction has not been reserved.
4979: */
4980:
4981: l_suffixe_select_statement := ' FROM ar_payment_schedules ps,'||
4982: ' ra_cust_trx_types type,'||
4983: ' ra_customer_trx trx,'||
4984: ' ar_receipt_methods pm '||
4985: 'WHERE ps.cust_trx_type_id = type.cust_trx_type_id '||