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_RECEIPT_METHODS

Line 14: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
15: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
16: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
17: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
18: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 55: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
56: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
57: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
58: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
59: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 100: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
101: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
102: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
103: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
104: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 126: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
127: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
128: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
129: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
130: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 137: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,

133: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE);
134:
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,

Line 154: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

150: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
151:
152: -- bug 3922691 : consolidate code used in 2 procedures
153: PROCEDURE construct_hz(
154: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
155: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
156: p_suffix_hz OUT NOCOPY varchar2);
157:
158: -- bug 3922691 : remove p_suffixe_select_statement, add p_lead_days

Line 160: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,

156: p_suffix_hz OUT NOCOPY varchar2);
157:
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,

Line 161: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

157:
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,

Line 173: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

169: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
170: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
171: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
172: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
173: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
174: p_batch_id IN RA_BATCHES.batch_id%TYPE,
175: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
176: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
177: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

Line 182: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,

178: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
179:
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,

Line 183: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

179:
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,

Line 195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

191: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
192: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
193: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
194: p_site_use_id IN HZ_CUST_SITE_USES.site_use_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,

Line 208: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

204: PROCEDURE create_BR(
205: p_draft_mode IN VARCHAR2,
206: p_call IN NUMBER,
207: p_batch_id IN RA_BATCHES.batch_id%TYPE,
208: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
209: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
210: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
211: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
212: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,

Line 209: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

205: p_draft_mode IN VARCHAR2,
206: p_call IN NUMBER,
207: p_batch_id IN RA_BATCHES.batch_id%TYPE,
208: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
209: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
210: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
211: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
212: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
213: p_currency_code IN RA_BATCHES.currency_code%TYPE,

Line 210: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,

206: p_call IN NUMBER,
207: p_batch_id IN RA_BATCHES.batch_id%TYPE,
208: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
209: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
210: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
211: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
212: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
213: p_currency_code IN RA_BATCHES.currency_code%TYPE,
214: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,

Line 211: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,

207: p_batch_id IN RA_BATCHES.batch_id%TYPE,
208: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
209: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
210: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
211: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
212: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
213: p_currency_code IN RA_BATCHES.currency_code%TYPE,
214: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
215: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

Line 212: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,

208: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
209: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
210: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
211: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
212: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
213: p_currency_code IN RA_BATCHES.currency_code%TYPE,
214: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
215: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
216: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,

Line 226: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,

222: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
223: p_batch_id IN RA_BATCHES.batch_id%TYPE,
224: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
225: p_bill_number IN RA_CUSTOMER_TRX.TRX_NUMBER%TYPE,
226: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
227: p_br_currency IN RA_BATCHES.currency_code%TYPE,
228: p_batch_status IN RA_BATCHES.status%TYPE,
229: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
230: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,

Line 236: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE);

232: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
233: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
234: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
235: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
236: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE);
237:
238: PROCEDURE run_report_pvt(
239: p_batch_id IN RA_BATCHES.batch_id%TYPE);
240:

Line 397: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE DEFAULT NULL,

393: p_due_date_high IN VARCHAR2 DEFAULT NULL,
394: p_trx_date_low IN VARCHAR2 DEFAULT NULL,
395: p_trx_date_high IN VARCHAR2 DEFAULT NULL,
396: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE DEFAULT NULL,
397: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE DEFAULT NULL,
398: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE DEFAULT NULL,
399: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
400: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
401: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,

Line 619: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
620: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
621: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
622: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
623: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 737: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
738: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
739: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
740: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
741: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 902: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
903: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
904: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
905: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
906: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 1174: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
1175: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1176: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1177: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
1178: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 1203: ar_receipt_methods pm,

1199: NVL(pm.br_max_acctd_amount,9999999999999999999999999999999999),
1200: trx.invoice_currency_code, trx.exchange_rate, trx.legal_entity_id
1201: FROM ra_batches batch,
1202: ar_receipt_classes class,
1203: ar_receipt_methods pm,
1204: ra_customer_trx trx,
1205: ra_cust_trx_types type,
1206: fnd_currencies_vl cur
1207: WHERE pm.receipt_method_id = NVL(p_rcpt_meth_id,pm.receipt_method_id)

Line 1239: ar_receipt_methods pm,

1235: -- SELECT distinct trx.customer_bank_account_id 5051673
1236: SELECT distinct instrument_id customer_bank_account_id
1237: FROM ra_batches batch,
1238: ar_receipt_classes class,
1239: ar_receipt_methods pm,
1240: ra_customer_trx trx,
1241: ra_cust_trx_types type,
1242: fnd_currencies_vl cur,
1243: iby_trxn_extensions_v extn

Line 1284: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;

1280: l_suffixe_select_statement VARCHAR2(4000) :=NULL;
1281: l_suffix_hz VARCHAR2(5000) :=NULL;
1282:
1283: -- 1st break criteria
1284: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
1285: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1286: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1287: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1288: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;

Line 1285: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;

1281: l_suffix_hz VARCHAR2(5000) :=NULL;
1282:
1283: -- 1st break criteria
1284: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
1285: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1286: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1287: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1288: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1289: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;

Line 1286: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;

1282:
1283: -- 1st break criteria
1284: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
1285: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1286: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1287: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1288: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1289: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1290:

Line 1287: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;

1283: -- 1st break criteria
1284: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
1285: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1286: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1287: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1288: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1289: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1290:
1291: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;

Line 1288: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;

1284: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
1285: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1286: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1287: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1288: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1289: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1290:
1291: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
1292: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;

Line 1289: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;

1285: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1286: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1287: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1288: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1289: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1290:
1291: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
1292: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;
1293: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;

Line 1915: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

1911: | existed in auto_create_br_api |
1912: +===========================================================================*/
1913:
1914: PROCEDURE construct_hz(
1915: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
1916: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1917: p_suffix_hz OUT NOCOPY varchar2) IS
1918:
1919: l_trx_select_statement VARCHAR2(4000) := NULL;

Line 2018: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,

2014: | 21-Jan-06 Surendra Rajan Removed the references to ap_bank_accounts |
2015: +===========================================================================*/
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,

Line 2061: ar_receipt_methods pm,

2057: /* Bug 4928711 - Removed the references to ap_bank_accounts */
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,

Line 2248: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,

2244: | 11-MAY-05 VCRISOST LE-R12: add p_le_id |
2245: | 25-MAY-05 VCRISOST SSA-R12: add p_org_id |
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,

Line 2249: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

2245: | 25-MAY-05 VCRISOST SSA-R12: add p_org_id |
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,

Line 2261: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

2257: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2258: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2259: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2260: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2261: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2262: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2263: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2264: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2265: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

Line 2496: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,

2492: | 11-MAY-05 VCRISOST LE-R12: add p_le_id |
2493: | 25-MAY-05 VCRISOST SSA-R12: add p_org_id |
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,

Line 2497: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

2493: | 25-MAY-05 VCRISOST SSA-R12: add p_org_id |
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,

Line 2509: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

2505: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2506: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2507: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2508: p_site_use_id IN HZ_CUST_SITE_USES.site_use_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,

Line 2752: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

2748: PROCEDURE create_BR(
2749: p_draft_mode IN VARCHAR2,
2750: p_call IN NUMBER,
2751: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2752: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2753: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2754: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2755: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2756: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,

Line 2753: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

2749: p_draft_mode IN VARCHAR2,
2750: p_call IN NUMBER,
2751: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2752: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2753: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2754: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2755: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2756: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2757: p_currency_code IN RA_BATCHES.currency_code%TYPE,

Line 2754: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,

2750: p_call IN NUMBER,
2751: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2752: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2753: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2754: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2755: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2756: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2757: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2758: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,

Line 2755: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,

2751: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2752: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2753: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2754: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2755: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2756: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2757: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2758: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
2759: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

Line 2756: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,

2752: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2753: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2754: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2755: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2756: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2757: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2758: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
2759: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2760: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,

Line 2841: l_br_inherit_inv_num_flag AR_RECEIPT_METHODS.BR_INHERIT_INV_NUM_FLAG%TYPE;

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;
2843: l_count_trxid NUMBER;
2844: l_count_ps NUMBER;
2845: l_cust_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE;

Line 3218: FROM ar_receipt_methods

3214: SELECT br_cust_trx_type_id,
3215: br_inherit_inv_num_flag
3216: INTO l_cust_trx_type_id,
3217: l_br_inherit_inv_num_flag
3218: FROM ar_receipt_methods
3219: WHERE receipt_method_id = p_receipt_method_id;
3220:
3221:
3222: /* -------------------------------------------------------------------------

Line 4185: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,

4181: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
4182: p_batch_id IN RA_BATCHES.batch_id%TYPE,
4183: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4184: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,
4185: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
4186: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4187: p_batch_status IN RA_BATCHES.status%TYPE,
4188: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4189: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,

Line 4195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS

4191: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4192: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4193: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4194: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
4195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4196:
4197: -- Bug 1420183
4198: -- Could pass creation rule code, min/max amounts into this procedure as parameters, but since
4199: -- we need to hit ar_receipt_methods to get lead days, we may as well get the other info there also

Line 4199: -- we need to hit ar_receipt_methods to get lead days, we may as well get the other info there also

4195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4196:
4197: -- Bug 1420183
4198: -- Could pass creation rule code, min/max amounts into this procedure as parameters, but since
4199: -- we need to hit ar_receipt_methods to get lead days, we may as well get the other info there also
4200: CURSOR c_get_receipt_method(l_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4201: SELECT name,
4202: receipt_creation_rule_code,
4203: br_min_acctd_amount,

Line 4200: CURSOR c_get_receipt_method(l_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS

4196:
4197: -- Bug 1420183
4198: -- Could pass creation rule code, min/max amounts into this procedure as parameters, but since
4199: -- we need to hit ar_receipt_methods to get lead days, we may as well get the other info there also
4200: CURSOR c_get_receipt_method(l_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4201: SELECT name,
4202: receipt_creation_rule_code,
4203: br_min_acctd_amount,
4204: br_max_acctd_amount,

Line 4206: FROM ar_receipt_methods

4202: receipt_creation_rule_code,
4203: br_min_acctd_amount,
4204: br_max_acctd_amount,
4205: lead_days
4206: FROM ar_receipt_methods
4207: WHERE receipt_method_id = l_receipt_method_id;
4208:
4209: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4210: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;

Line 4209: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;

4205: lead_days
4206: FROM ar_receipt_methods
4207: WHERE receipt_method_id = l_receipt_method_id;
4208:
4209: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4210: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4211: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4212: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4213: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;

Line 4210: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;

4206: FROM ar_receipt_methods
4207: WHERE receipt_method_id = l_receipt_method_id;
4208:
4209: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4210: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4211: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4212: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4213: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4214:

Line 4211: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;

4207: WHERE receipt_method_id = l_receipt_method_id;
4208:
4209: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4210: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4211: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4212: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4213: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4214:
4215: BEGIN

Line 4212: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;

4208:
4209: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4210: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4211: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4212: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4213: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4214:
4215: BEGIN
4216:

Line 4213: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;

4209: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4210: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4211: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4212: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4213: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4214:
4215: BEGIN
4216:
4217:

Line 4874: FROM ar_receipt_methods pm,

4870: trx.invoice_currency_code,
4871: -- trx.customer_bank_account_id, Bug 5051673
4872: trx.payment_trxn_extension_id,
4873: trx.legal_entity_id
4874: FROM ar_receipt_methods pm,
4875: ra_customer_trx trx
4876: WHERE trx.customer_trx_id = p_customer_trx_id
4877: AND trx.receipt_method_id = pm.receipt_method_id;
4878:

Line 4889: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;

4885: l_insert_statement VARCHAR2(1000) :=NULL;
4886: l_delete_statement VARCHAR2(1000) :=NULL;
4887:
4888: -- 1st break criteria
4889: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
4890: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4891: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4892: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4893: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;

Line 4890: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;

4886: l_delete_statement VARCHAR2(1000) :=NULL;
4887:
4888: -- 1st break criteria
4889: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
4890: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4891: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4892: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4893: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4894: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;

Line 4891: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;

4887:
4888: -- 1st break criteria
4889: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
4890: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4891: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4892: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4893: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4894: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4895: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;

Line 4892: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;

4888: -- 1st break criteria
4889: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
4890: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4891: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4892: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4893: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4894: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4895: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4896: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;

Line 4893: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;

4889: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
4890: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4891: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4892: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4893: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4894: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4895: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4896: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
4897:

Line 4894: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;

4890: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4891: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4892: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4893: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4894: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4895: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4896: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
4897:
4898: -- bug 1808976 :

Line 4984: ' ar_receipt_methods pm '||

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 '||
4986: 'AND (type.type IN (''INV'',''DEP'',''CB'') OR '||
4987: ' (type.type IN (''CM'',''DM'') AND ps.term_id <> 5)) '||
4988: 'AND ps.customer_trx_id = NVL(:p_customer_trx_id,ps.customer_trx_id) '||