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 594: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

590: PROCEDURE from_automatic_batch_window(
591: p_draft_mode IN VARCHAR2,
592: p_print_flag IN VARCHAR2,
593: p_batch_id IN RA_BATCHES.batch_id%TYPE,
594: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
595: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
596: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
597: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
598: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 595: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

591: p_draft_mode IN VARCHAR2,
592: p_print_flag IN VARCHAR2,
593: p_batch_id IN RA_BATCHES.batch_id%TYPE,
594: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
595: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
596: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
597: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
598: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
599: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 712: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

708: p_attribute12 IN VARCHAR2,
709: p_attribute13 IN VARCHAR2,
710: p_attribute14 IN VARCHAR2,
711: p_attribute15 IN VARCHAR2,
712: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
713: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
714: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
715: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
716: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 713: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

709: p_attribute13 IN VARCHAR2,
710: p_attribute14 IN VARCHAR2,
711: p_attribute15 IN VARCHAR2,
712: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
713: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
714: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
715: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
716: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
717: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 877: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

873: p_attribute12 IN VARCHAR2,
874: p_attribute13 IN VARCHAR2,
875: p_attribute14 IN VARCHAR2,
876: p_attribute15 IN VARCHAR2,
877: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
878: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
879: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
880: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
881: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 878: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

874: p_attribute13 IN VARCHAR2,
875: p_attribute14 IN VARCHAR2,
876: p_attribute15 IN VARCHAR2,
877: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
878: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
879: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
880: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
881: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
882: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 1150: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

1146: PROCEDURE select_trx_and_create_BR(
1147: p_draft_mode IN VARCHAR2,
1148: p_call IN NUMBER,
1149: p_batch_id IN RA_BATCHES.batch_id%TYPE,
1150: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1151: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1152: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1153: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1154: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 1151: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

1147: p_draft_mode IN VARCHAR2,
1148: p_call IN NUMBER,
1149: p_batch_id IN RA_BATCHES.batch_id%TYPE,
1150: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1151: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1152: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1153: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1154: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1155: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 1286: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

1282:
1283: -- 2nd break criteria
1284: l_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1285: l_customer_id2 HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1286: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
1287: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1288: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
1289: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1290:

Line 1287: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

1283: -- 2nd break criteria
1284: l_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1285: l_customer_id2 HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1286: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
1287: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1288: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
1289: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1290:
1291: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

Line 1288: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;

1284: l_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1285: l_customer_id2 HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1286: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
1287: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1288: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
1289: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1290:
1291: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
1292: l_request_id NUMBER;

Line 1289: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

1285: l_customer_id2 HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1286: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
1287: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1288: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
1289: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1290:
1291: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
1292: l_request_id NUMBER;
1293: -- 3922691

Line 1871: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

1867:
1868: PROCEDURE construct_suffixe_select(
1869: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
1870: p_suffixe_select_statement OUT NOCOPY varchar2,
1871: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1872: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1873: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1874: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1875: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 1872: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

1868: PROCEDURE construct_suffixe_select(
1869: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
1870: p_suffixe_select_statement OUT NOCOPY varchar2,
1871: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1872: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1873: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1874: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1875: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1876: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 1913: ar_payment_schedules ps,

1909:
1910: l_trx_select_statement :=
1911: 'FROM ra_batches batch,
1912: ar_receipt_methods pm,
1913: ar_payment_schedules ps,
1914: ra_customer_trx trx,
1915: ra_cust_trx_types type,
1916: fnd_currencies_vl cur,
1917: hz_cust_accounts cust,

Line 2109: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

2105: +===========================================================================*/
2106: PROCEDURE select_DM_and_CM_IMM(
2107: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2108: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2109: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2110: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2111: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2112: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2113: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

Line 2110: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

2106: PROCEDURE select_DM_and_CM_IMM(
2107: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2108: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2109: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2110: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2111: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2112: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2113: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2114: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 2140: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

2136: l_aimm_ctr NUMBER;
2137:
2138: c_trx cur_typ;
2139:
2140: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2141: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2142: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2143: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2144: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

Line 2141: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;

2137:
2138: c_trx cur_typ;
2139:
2140: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2141: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2142: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2143: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2144: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2145: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

Line 2142: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

2138: c_trx cur_typ;
2139:
2140: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2141: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2142: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2143: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2144: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2145: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2146: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

Line 2143: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;

2139:
2140: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2141: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2142: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2143: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2144: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2145: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2146: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2147: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 2144: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

2140: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2141: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2142: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2143: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2144: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2145: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2146: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2147: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2148: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;

Line 2145: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

2141: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2142: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2143: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2144: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2145: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2146: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2147: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2148: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2149:

Line 2146: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

2142: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2143: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2144: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2145: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2146: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2147: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2148: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2149:
2150: BEGIN

Line 2147: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

2143: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2144: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2145: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2146: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2147: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2148: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2149:
2150: BEGIN
2151:

Line 2148: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;

2144: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2145: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2146: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2147: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2148: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2149:
2150: BEGIN
2151:
2152: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM (+)');

Line 2357: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

2353: +===========================================================================*/
2354: PROCEDURE select_trx_NIMM(
2355: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2356: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2357: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2358: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2359: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2360: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2361: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

Line 2358: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

2354: PROCEDURE select_trx_NIMM(
2355: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2356: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2357: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2358: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2359: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2360: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2361: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2362: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 2372: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,

2368: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2369: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2370: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2371: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2372: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2373: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2374: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2375: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2376:

Line 2386: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

2382: l_insert_statement VARCHAR2(2000);
2383:
2384: c_trx cur_typ;
2385:
2386: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2387: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2388: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2389: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2390: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

Line 2387: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;

2383:
2384: c_trx cur_typ;
2385:
2386: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2387: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2388: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2389: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2390: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2391: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

Line 2388: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

2384: c_trx cur_typ;
2385:
2386: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2387: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2388: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2389: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2390: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2391: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2392: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

Line 2389: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;

2385:
2386: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2387: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2388: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2389: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2390: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2391: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2392: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2393: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 2390: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

2386: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2387: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2388: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2389: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2390: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2391: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2392: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2393: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2394: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;

Line 2391: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

2387: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
2388: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2389: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2390: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2391: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2392: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2393: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2394: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2395:

Line 2392: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

2388: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
2389: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2390: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2391: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2392: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2393: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2394: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2395:
2396: BEGIN

Line 2393: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

2389: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
2390: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2391: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2392: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2393: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2394: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2395:
2396: BEGIN
2397:

Line 2394: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;

2390: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2391: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
2392: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
2393: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2394: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2395:
2396: BEGIN
2397:
2398: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_NIMM (+)');

Line 2631: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

2627: l_return_status VARCHAR2(20);
2628: l_msg_count NUMBER;
2629: l_msg_data VARCHAR2(4000);
2630:
2631: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2632:
2633: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2634: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2635: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;

Line 2685: l_excluded_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

2681: l_tot_nimm NUMBER;
2682: l_tot_imm NUMBER;
2683: l_br_amount NUMBER;
2684:
2685: l_excluded_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2686: l_assigned_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2687:
2688: l_tot_negative_count NUMBER;
2689: l_tot_positive_count NUMBER;

Line 2686: l_assigned_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

2682: l_tot_imm NUMBER;
2683: l_br_amount NUMBER;
2684:
2685: l_excluded_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2686: l_assigned_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
2687:
2688: l_tot_negative_count NUMBER;
2689: l_tot_positive_count NUMBER;
2690:

Line 2697: l_bill_to_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

2693:
2694: l_org_id NUMBER;
2695:
2696: -- Bug 1710187 : define a variable to hold customer_site_use_id for transaction being exchanged for BR
2697: l_bill_to_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2698:
2699: -- Bug 1708420 : define variable to hold BR_INHERIT_INV_NUM_FLAG value
2700: l_br_inherit_inv_num_flag AR_RECEIPT_METHODS.BR_INHERIT_INV_NUM_FLAG%TYPE;
2701: l_trx_number RA_CUSTOMER_TRX.TRX_NUMBER%TYPE;

Line 2723: c_psid AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE;

2719: 'amount_due_remaining, nvl(exclude_flag,''N''), org_id FROM '|| g_tmp_table_imm ||
2720: ' ORDER BY due_date DESC, amount_due_remaining DESC';
2721: use_cursor_stmt VARCHAR2(1000);
2722: cursor_loop cur_typ;
2723: c_psid AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE;
2724: c_due AR_PAYMENT_SCHEDULES.DUE_DATE%TYPE;
2725: c_adr AR_PAYMENT_SCHEDULES.AMOUNT_DUE_REMAINING%TYPE;
2726: c_exc VARCHAR2(1);
2727: -- end 4006714

Line 2724: c_due AR_PAYMENT_SCHEDULES.DUE_DATE%TYPE;

2720: ' ORDER BY due_date DESC, amount_due_remaining DESC';
2721: use_cursor_stmt VARCHAR2(1000);
2722: cursor_loop cur_typ;
2723: c_psid AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE;
2724: c_due AR_PAYMENT_SCHEDULES.DUE_DATE%TYPE;
2725: c_adr AR_PAYMENT_SCHEDULES.AMOUNT_DUE_REMAINING%TYPE;
2726: c_exc VARCHAR2(1);
2727: -- end 4006714
2728:

Line 2725: c_adr AR_PAYMENT_SCHEDULES.AMOUNT_DUE_REMAINING%TYPE;

2721: use_cursor_stmt VARCHAR2(1000);
2722: cursor_loop cur_typ;
2723: c_psid AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE;
2724: c_due AR_PAYMENT_SCHEDULES.DUE_DATE%TYPE;
2725: c_adr AR_PAYMENT_SCHEDULES.AMOUNT_DUE_REMAINING%TYPE;
2726: c_exc VARCHAR2(1);
2727: -- end 4006714
2728:
2729: jnk1 NUMBER;

Line 3099: 'from ar_payment_schedules ps ' ||

3095: execute immediate l_statement INTO l_count_trxid, l_cust_trx_id;
3096:
3097: IF l_count_trxid = 1 THEN
3098: l_statement := 'SELECT count(*), max(ps.trx_number) ' ||
3099: 'from ar_payment_schedules ps ' ||
3100: 'where ps.customer_trx_id = ' ||
3101: l_cust_trx_id ;
3102: execute immediate l_statement INTO l_count_ps, l_trx_number;
3103:

Line 4742: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

4738:
4739: -- bug 1808976 :
4740: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;
4741:
4742: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4743: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4744: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4745: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4746: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;

Line 4743: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;

4739: -- bug 1808976 :
4740: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;
4741:
4742: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4743: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4744: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4745: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4746: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4747: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

Line 4744: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

4740: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;
4741:
4742: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4743: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4744: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4745: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4746: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4747: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4748: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

Line 4745: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;

4741:
4742: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4743: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4744: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4745: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4746: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4747: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4748: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4749: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

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

4742: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4743: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4744: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4745: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4746: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4747: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4748: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4749: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4750: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

Line 4747: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

4743: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4744: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4745: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4746: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4747: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4748: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4749: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4750: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4751: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 4748: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

4744: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
4745: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4746: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4747: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4748: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4749: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4750: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4751: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4752:

Line 4749: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;

4745: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4746: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4747: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4748: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4749: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4750: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4751: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4752:
4753: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

Line 4750: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;

4746: p_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE := NULL;
4747: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4748: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4749: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4750: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4751: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4752:
4753: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
4754: l_request_id NUMBER;

Line 4751: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

4747: l_customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4748: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
4749: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4750: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4751: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4752:
4753: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
4754: l_request_id NUMBER;
4755:

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

4818: Also added additional condition to check if the payment schedule is open and
4819: to check that the transaction has not been reserved.
4820: */
4821:
4822: l_suffixe_select_statement := ' FROM ar_payment_schedules ps,'||
4823: ' ra_cust_trx_types type,'||
4824: ' ra_customer_trx trx,'||
4825: ' ar_receipt_methods pm '||
4826: 'WHERE ps.cust_trx_type_id = type.cust_trx_type_id '||