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 385: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE DEFAULT NULL,

381: p_due_date_high IN VARCHAR2 DEFAULT NULL,
382: p_trx_date_low IN VARCHAR2 DEFAULT NULL,
383: p_trx_date_high IN VARCHAR2 DEFAULT NULL,
384: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE DEFAULT NULL,
385: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE DEFAULT NULL,
386: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE DEFAULT NULL,
387: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
388: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
389: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,

Line 599: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
600: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
601: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
602: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
603: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 717: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
718: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
719: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
720: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
721: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 882: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
883: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
884: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
885: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
886: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 1155: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%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,
1156: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1157: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1158: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
1159: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 1181: ar_receipt_methods pm,

1177: NVL(pm.br_max_acctd_amount,9999999999999999999999999999999999),
1178: trx.invoice_currency_code, trx.exchange_rate, trx.legal_entity_id
1179: FROM ra_batches batch,
1180: ar_receipt_classes class,
1181: ar_receipt_methods pm,
1182: ra_customer_trx trx,
1183: ra_cust_trx_types type,
1184: fnd_currencies_vl cur
1185: WHERE pm.receipt_method_id = NVL(p_rcpt_meth_id,pm.receipt_method_id)

Line 1218: ar_receipt_methods pm,

1214: -- SELECT distinct trx.customer_bank_account_id 5051673
1215: SELECT distinct instrument_id customer_bank_account_id
1216: FROM ra_batches batch,
1217: ar_receipt_classes class,
1218: ar_receipt_methods pm,
1219: ra_customer_trx trx,
1220: ra_cust_trx_types type,
1221: fnd_currencies_vl cur,
1222: iby_trxn_extensions_v extn

Line 1266: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;

1262: l_suffixe_select_statement VARCHAR2(4000) :=NULL;
1263: l_suffix_hz VARCHAR2(5000) :=NULL;
1264:
1265: -- 1st break criteria
1266: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
1267: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1268: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1269: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1270: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;

Line 1267: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;

1263: l_suffix_hz VARCHAR2(5000) :=NULL;
1264:
1265: -- 1st break criteria
1266: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
1267: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1268: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1269: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1270: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1271: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;

Line 1268: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;

1264:
1265: -- 1st break criteria
1266: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
1267: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1268: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1269: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1270: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1271: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1272:

Line 1269: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;

1265: -- 1st break criteria
1266: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
1267: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1268: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1269: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1270: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1271: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1272:
1273: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;

Line 1270: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;

1266: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
1267: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1268: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1269: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1270: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1271: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1272:
1273: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
1274: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;

Line 1271: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;

1267: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
1268: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
1269: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1270: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1271: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1272:
1273: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
1274: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;
1275: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;

Line 1766: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

1762: | existed in auto_create_br_api |
1763: +===========================================================================*/
1764:
1765: PROCEDURE construct_hz(
1766: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
1767: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1768: p_suffix_hz OUT NOCOPY varchar2) IS
1769:
1770: l_trx_select_statement VARCHAR2(4000) := NULL;

Line 1869: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,

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

Line 1912: ar_receipt_methods pm,

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

Line 2107: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,

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

Line 2108: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

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

Line 2120: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

2116: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2117: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2118: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2119: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2120: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2121: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2122: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2123: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2124: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

Line 2355: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,

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

Line 2356: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

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

Line 2368: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

2364: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2365: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2366: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2367: p_site_use_id IN HZ_CUST_SITE_USES.site_use_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,

Line 2611: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

2607: PROCEDURE create_BR(
2608: p_draft_mode IN VARCHAR2,
2609: p_call IN NUMBER,
2610: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2611: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2612: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2613: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2614: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2615: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,

Line 2612: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

2608: p_draft_mode IN VARCHAR2,
2609: p_call IN NUMBER,
2610: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2611: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2612: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2613: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2614: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2615: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2616: p_currency_code IN RA_BATCHES.currency_code%TYPE,

Line 2613: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,

2609: p_call IN NUMBER,
2610: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2611: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2612: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2613: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2614: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2615: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2616: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2617: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,

Line 2614: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,

2610: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2611: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2612: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2613: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2614: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2615: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2616: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2617: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
2618: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

Line 2615: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,

2611: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2612: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2613: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2614: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2615: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2616: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2617: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
2618: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2619: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,

Line 2700: l_br_inherit_inv_num_flag AR_RECEIPT_METHODS.BR_INHERIT_INV_NUM_FLAG%TYPE;

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;
2702: l_count_trxid NUMBER;
2703: l_count_ps NUMBER;
2704: l_cust_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE;

Line 3075: FROM ar_receipt_methods

3071: SELECT br_cust_trx_type_id,
3072: br_inherit_inv_num_flag
3073: INTO l_cust_trx_type_id,
3074: l_br_inherit_inv_num_flag
3075: FROM ar_receipt_methods
3076: WHERE receipt_method_id = p_receipt_method_id;
3077:
3078: /* -------------------------------------------------------------------------
3079: Bug 1708420 : If receipt class was defined to "Inherit Transaction Number"

Line 4026: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,

4022: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
4023: p_batch_id IN RA_BATCHES.batch_id%TYPE,
4024: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4025: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,
4026: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
4027: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4028: p_batch_status IN RA_BATCHES.status%TYPE,
4029: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4030: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,

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

4032: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4033: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4034: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4035: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
4036: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4037:
4038: -- Bug 1420183
4039: -- Could pass creation rule code, min/max amounts into this procedure as parameters, but since
4040: -- we need to hit ar_receipt_methods to get lead days, we may as well get the other info there also

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

4036: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4037:
4038: -- Bug 1420183
4039: -- Could pass creation rule code, min/max amounts into this procedure as parameters, but since
4040: -- we need to hit ar_receipt_methods to get lead days, we may as well get the other info there also
4041: CURSOR c_get_receipt_method(l_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4042: SELECT name,
4043: receipt_creation_rule_code,
4044: br_min_acctd_amount,

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

4037:
4038: -- Bug 1420183
4039: -- Could pass creation rule code, min/max amounts into this procedure as parameters, but since
4040: -- we need to hit ar_receipt_methods to get lead days, we may as well get the other info there also
4041: CURSOR c_get_receipt_method(l_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4042: SELECT name,
4043: receipt_creation_rule_code,
4044: br_min_acctd_amount,
4045: br_max_acctd_amount,

Line 4047: FROM ar_receipt_methods

4043: receipt_creation_rule_code,
4044: br_min_acctd_amount,
4045: br_max_acctd_amount,
4046: lead_days
4047: FROM ar_receipt_methods
4048: WHERE receipt_method_id = l_receipt_method_id;
4049:
4050: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4051: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;

Line 4050: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;

4046: lead_days
4047: FROM ar_receipt_methods
4048: WHERE receipt_method_id = l_receipt_method_id;
4049:
4050: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4051: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4052: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4053: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4054: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;

Line 4051: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;

4047: FROM ar_receipt_methods
4048: WHERE receipt_method_id = l_receipt_method_id;
4049:
4050: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4051: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4052: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4053: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4054: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4055:

Line 4052: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;

4048: WHERE receipt_method_id = l_receipt_method_id;
4049:
4050: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4051: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4052: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4053: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4054: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4055:
4056: BEGIN

Line 4053: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;

4049:
4050: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4051: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4052: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4053: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4054: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4055:
4056: BEGIN
4057:

Line 4054: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;

4050: l_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
4051: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4052: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4053: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4054: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4055:
4056: BEGIN
4057:
4058:

Line 4715: FROM ar_receipt_methods pm,

4711: trx.invoice_currency_code,
4712: -- trx.customer_bank_account_id, Bug 5051673
4713: trx.payment_trxn_extension_id,
4714: trx.legal_entity_id
4715: FROM ar_receipt_methods pm,
4716: ra_customer_trx trx
4717: WHERE trx.customer_trx_id = p_customer_trx_id
4718: AND trx.receipt_method_id = pm.receipt_method_id;
4719:

Line 4730: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;

4726: l_insert_statement VARCHAR2(1000) :=NULL;
4727: l_delete_statement VARCHAR2(1000) :=NULL;
4728:
4729: -- 1st break criteria
4730: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
4731: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4732: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4733: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4734: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;

Line 4731: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;

4727: l_delete_statement VARCHAR2(1000) :=NULL;
4728:
4729: -- 1st break criteria
4730: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
4731: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4732: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4733: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4734: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4735: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;

Line 4732: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;

4728:
4729: -- 1st break criteria
4730: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
4731: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4732: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4733: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4734: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4735: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4736: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;

Line 4733: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;

4729: -- 1st break criteria
4730: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
4731: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4732: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4733: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4734: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4735: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4736: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4737: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;

Line 4734: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;

4730: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE;
4731: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4732: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4733: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4734: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4735: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4736: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4737: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
4738:

Line 4735: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;

4731: l_receipt_creation_rule_code AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE;
4732: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4733: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4734: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4735: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4736: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4737: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
4738:
4739: -- bug 1808976 :

Line 4825: ' ar_receipt_methods pm '||

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