[Home] [Help]
136:
137: l_apply_fail VARCHAR2(1);
138: l_pay_process_fail VARCHAR2(1);
139: l_rec_inher_inv_num_flag VARCHAR2(1);
140: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;
141:
142: BEGIN
143:
144:
493: select decode(rc.confirm_flag,'Y','AUTORECAPI',null),nvl(rm.RECEIPT_CREATION_RULE_CODE,'MANUAL')
494: ,nvl(rm.receipt_inherit_inv_num_flag,'N')
495: INTO l_called_from,l_rec_creation_rule_code,l_rec_inher_inv_num_flag
496: from ar_receipt_classes rc,
497: ar_receipt_methods rm
498: where rm.receipt_method_id = l_receipt_method_id
499: and rm.receipt_class_id = rc.receipt_class_id;
500:
501:
1197: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688
1198: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
1199: p_batch_id IN ar_batches.batch_id%TYPE,
1200: p_approve_only_flag IN VARCHAR2 ,--Bug5344405
1201: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1202: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,
1203: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,
1204: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1205: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
1209: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
1210: p_cust_bank_account_id OUT NOCOPY ra_customer_trx.customer_bank_account_id%TYPE,
1211: p_cust_min_amt OUT NOCOPY hz_cust_profile_amts.auto_rec_min_receipt_amount%TYPE,
1212: p_payment_trxn_extension_id OUT NOCOPY ra_customer_trx.payment_trxn_extension_id%TYPE,
1213: p_payment_channel_code OUT NOCOPY ar_receipt_methods.payment_channel_code%TYPE,
1214: p_instrument_type OUT NOCOPY IBY_PMT_INSTR_USES_ALL.instrument_type%TYPE,
1215: p_return_status OUT NOCOPY VARCHAR2
1216: ) IS
1217:
1220: l_rows_fetched INTEGER;
1221: l_sel_stmt long;
1222: p_lead_days NUMBER;
1223: p_batch_date DATE;
1224: p_creation_rule ar_receipt_methods.receipt_creation_rule_code%TYPE;
1225: p_currency_code VARCHAR2(20);
1226:
1227: -- insert variables
1228: inst_stmt varchar2(1000);
1259: p_batch_date,
1260: p_lead_days,
1261: p_creation_rule
1262: from ar_batches b,
1263: ar_receipt_methods r
1264: WHERE b.batch_id = p_batch_id
1265: AND b.receipt_method_id = r.receipt_method_id
1266: AND r.receipt_method_id = p_receipt_method_id;
1267:
1767: l_status NUMBER;
1768: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;
1769: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
1770: p_set_of_books_id ar_batches.set_of_books_id%TYPE;
1771: p_name ar_receipt_methods.name%TYPE;
1772: p_batch_date ar_batches.batch_date%TYPE;
1773: p_currency_code ar_batches.currency_code%TYPE;
1774: p_exchange_rate ar_batches.exchange_rate%TYPE; -- Added for Bug 7313058
1775: p_exchange_date ar_batches.exchange_date%TYPE; -- Added for Bug 7313058
1794:
1795:
1796: SELECT receipt_creation_rule_code,receipt_class_id
1797: INTO p_creation_rule,l_receipt_class_id
1798: FROM ar_receipt_methods
1799: WHERE receipt_method_id = p_receipt_method_id;
1800:
1801:
1802: SELECT decode( confirm_flag, 'Y','AUTORECAPI',null)
1815:
1816: /* NOTE HERE WE WILL NEED SEPERATE LOOPS FOR
1817:
1818: SQL> select distinct receipt_creation_rule_code
1819: 2 from ar_receipt_methods;
1820:
1821: RECEIPT_CREATION_RULE_CODE
1822: ------------------------------
1823: PER_CUSTOMER
1861: ,p_exchange_rate_type
1862: /** Changes for Bug 7313058 End Here **/
1863: ,l_rec_inher_inv_num_flag
1864: from ar_batches b,
1865: ar_receipt_methods r
1866: where b.batch_id = p_batch_id
1867: and r.receipt_method_id = p_receipt_method_id
1868: and b.receipt_method_id = r.receipt_method_id;
1869:
2166: ,p_exchange_date
2167: ,p_exchange_rate_type
2168: /** Changes for Bug 7313058 End Here **/
2169: from ar_batches b,
2170: ar_receipt_methods r
2171: where b.batch_id = p_batch_id
2172: and r.receipt_method_id = p_receipt_method_id
2173: and b.receipt_method_id = r.receipt_method_id;
2174:
2452: ,p_exchange_date
2453: ,p_exchange_rate_type
2454: /** Changes for Bug 7313058 End Here **/
2455: from ar_batches b,
2456: ar_receipt_methods r
2457: where b.batch_id = p_batch_id
2458: and r.receipt_method_id = p_receipt_method_id
2459: and b.receipt_method_id = r.receipt_method_id;
2460:
2744: ,p_exchange_date
2745: ,p_exchange_rate_type
2746: /** Changes for Bug 7313058 End Here **/
2747: from ar_batches b,
2748: ar_receipt_methods r
2749: where b.batch_id = p_batch_id
2750: and r.receipt_method_id = p_receipt_method_id
2751: and b.receipt_method_id = r.receipt_method_id;
2752:
3037: ,p_exchange_date
3038: ,p_exchange_rate_type
3039: /** Changes for Bug 7313058 End Here **/
3040: from ar_batches b,
3041: ar_receipt_methods r
3042: where b.batch_id = p_batch_id
3043: and r.receipt_method_id = p_receipt_method_id
3044: and b.receipt_method_id = r.receipt_method_id;
3045:
3324: ,p_exchange_date
3325: ,p_exchange_rate_type
3326: /** Changes for Bug 7313058 End Here **/
3327: from ar_batches b,
3328: ar_receipt_methods r
3329: where b.batch_id = p_batch_id
3330: and r.receipt_method_id = p_receipt_method_id
3331: and b.receipt_method_id = r.receipt_method_id;
3332:
3590: ,p_exchange_date
3591: ,p_exchange_rate_type
3592: /** Changes for Bug 7313058 End Here **/
3593: from ar_batches b,
3594: ar_receipt_methods r
3595: where b.batch_id = p_batch_id
3596: and r.receipt_method_id = p_receipt_method_id
3597: and b.receipt_method_id = r.receipt_method_id;
3598:
3855: ,p_exchange_date
3856: ,p_exchange_rate_type
3857: /** Changes for Bug 7313058 End Here **/
3858: from ar_batches b,
3859: ar_receipt_methods r
3860: where b.batch_id = p_batch_id
3861: and r.receipt_method_id = p_receipt_method_id
3862: and b.receipt_method_id = r.receipt_method_id;
3863: