[Home] [Help]
1268: ar_receipt_methods rm,
1269: ar_receipt_classes rc,
1270: hz_cust_accounts hca,
1271: hz_parties party,
1272: /*ar_remit_gt g,*/
1273: ar_cash_receipt_history crh,
1274: ar_batches bat,
1275: ar_receipt_method_accounts rma,
1276: ar_payment_schedules ps,
1820: -- XLA uptake
1821: CURSOR c_rec is
1822: select hist.cash_receipt_id cr_id
1823: from ar_cash_receipt_history hist,
1824: AR_REMIT_GT rec
1825: where hist.STATUS = 'REMITTED'
1826: and hist.cash_receipt_id = rec.cash_receipt_id;
1827:
1828: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
2037: IF PG_DEBUG in ('Y', 'C') THEN
2038: fnd_file.put_line(FND_FILE.LOG,'selrem and create and upd 1()-');
2039: END IF;
2040:
2041: -- Bulk Insert into AR_REMIT_GT
2042:
2043: /* CHECK AND CORRECT FROM HERE DONE UPTILL HERE */
2044:
2045: BEGIN
2043: /* CHECK AND CORRECT FROM HERE DONE UPTILL HERE */
2044:
2045: BEGIN
2046:
2047: inst_stmt := 'insert into AR_REMIT_GT values ( :c1_array,:c2_array,:c3_array,:c4_array,:c5_array,
2048: :c6_array,:c7_array,:c8_array,:c9_array,:c10_array,:c11_array,:c12_array,
2049: :c13_array,:c14_array,:c15_array,:c16_array,:c17_array,:c18_array,
2050: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
2051:
2271: :i_org_id,
2272: :i_program_application_id,
2273: :i_program_id,
2274: sysdate
2275: FROM AR_REMIT_GT r
2276: WHERE r.cash_receipt_history_id is not null';
2277:
2278: rem_t3 := dbms_sql.open_cursor;
2279:
2438: sysdate,
2439: :i_last_updated_by,
2440: :i_org_id,
2441: :i_last_update_login
2442: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,
2443: ar_lookups l
2444: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
2445: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
2446: AND l.lookup_code IN (''1'',''2'')';
2601: -- XLA uptake
2602: CURSOR c_rec is
2603: select hist.cash_receipt_id cr_id
2604: from ar_cash_receipt_history hist,
2605: AR_REMIT_GT rec
2606: where hist.STATUS = 'REMITTED'
2607: and hist.cash_receipt_id = rec.cash_receipt_id;
2608:
2609: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
2797: IF PG_DEBUG in ('Y', 'C') THEN
2798: fnd_file.put_line(FND_FILE.LOG,'selrem and create and upd 1()-');
2799: END IF;
2800:
2801: -- Bulk Insert into AR_REMIT_GT
2802:
2803: BEGIN
2804:
2805: inst_stmt := 'insert into AR_REMIT_GT values
2801: -- Bulk Insert into AR_REMIT_GT
2802:
2803: BEGIN
2804:
2805: inst_stmt := 'insert into AR_REMIT_GT values
2806: ( :c1_array,:c2_array,:c3_array,:c4_array,:c5_array,
2807: :c6_array,:c7_array,:c8_array,:c9_array,:c10_array,:c11_array,:c12_array,
2808: :c13_array,:c14_array,:c15_array,:c16_array,:c17_array,:c18_array,
2809: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
3030: :i_org_id,
3031: :i_program_application_id,
3032: :i_program_id,
3033: sysdate
3034: FROM AR_REMIT_GT r
3035: WHERE r.cash_receipt_history_id is not null';
3036:
3037: rem_t3 := dbms_sql.open_cursor;
3038:
3197: sysdate,
3198: :i_last_updated_by,
3199: :i_org_id,
3200: :i_last_update_login
3201: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,
3202: ar_lookups l
3203: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
3204: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
3205: AND l.lookup_code IN (''1'',''2'')';
3643: ar_receipt_methods rm,
3644: ar_receipt_classes rc,
3645: hz_cust_accounts hca,
3646: hz_parties party,
3647: ar_remit_gt g
3648: WHERE cr.selected_remittance_batch_id = p_batch_id
3649: AND g.cash_receipt_id = cr.cash_receipt_id
3650: AND hca.party_id = party.party_id
3651: AND hca.cust_account_id = cr.pay_from_customer