[Home] [Help]
1332: ar_receipt_methods rm,
1333: ar_receipt_classes rc,
1334: hz_cust_accounts hca,
1335: hz_parties party,
1336: /*ar_remit_gt g,*/
1337: ar_cash_receipt_history crh,
1338: ar_batches bat,
1339: ar_receipt_method_accounts rma,
1340: ar_distributions d
1884: -- XLA uptake
1885: CURSOR c_rec is
1886: select hist.cash_receipt_id cr_id
1887: from ar_cash_receipt_history hist,
1888: AR_REMIT_GT rec
1889: where hist.STATUS = 'REMITTED'
1890: and hist.cash_receipt_id = rec.cash_receipt_id;
1891:
1892: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
2101: IF PG_DEBUG in ('Y', 'C') THEN
2102: fnd_file.put_line(FND_FILE.LOG,'selrem and create and upd 1()-');
2103: END IF;
2104:
2105: -- Bulk Insert into AR_REMIT_GT
2106:
2107: /* CHECK AND CORRECT FROM HERE DONE UPTILL HERE */
2108: IF nvl(l_rows_fetched,0) > 0 THEN --BUG 7418725
2109: BEGIN
2107: /* CHECK AND CORRECT FROM HERE DONE UPTILL HERE */
2108: IF nvl(l_rows_fetched,0) > 0 THEN --BUG 7418725
2109: BEGIN
2110:
2111: inst_stmt := 'insert into AR_REMIT_GT values ( :c1_array,:c2_array,:c3_array,:c4_array,:c5_array,
2112: :c6_array,:c7_array,:c8_array,:c9_array,:c10_array,:c11_array,:c12_array,
2113: :c13_array,:c14_array,:c15_array,:c16_array,:c17_array,:c18_array,
2114: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
2115:
2335: :i_org_id,
2336: :i_program_application_id,
2337: :i_program_id,
2338: sysdate
2339: FROM AR_REMIT_GT r
2340: WHERE r.cash_receipt_history_id is not null';
2341:
2342: rem_t3 := dbms_sql.open_cursor;
2343:
2502: sysdate,
2503: :i_last_updated_by,
2504: :i_org_id,
2505: :i_last_update_login
2506: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,
2507: ar_lookups l
2508: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
2509: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
2510: AND l.lookup_code IN (''1'',''2'')';
2665: -- XLA uptake
2666: CURSOR c_rec is
2667: select hist.cash_receipt_id cr_id
2668: from ar_cash_receipt_history hist,
2669: AR_REMIT_GT rec
2670: where hist.STATUS = 'REMITTED'
2671: and hist.cash_receipt_id = rec.cash_receipt_id;
2672:
2673: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
2874: p_return_status := FND_API.G_RET_STS_SUCCESS;
2875: RETURN;
2876: END IF;
2877:
2878: -- Bulk Insert into AR_REMIT_GT
2879:
2880: BEGIN
2881:
2882: inst_stmt := 'insert into AR_REMIT_GT values
2878: -- Bulk Insert into AR_REMIT_GT
2879:
2880: BEGIN
2881:
2882: inst_stmt := 'insert into AR_REMIT_GT values
2883: ( :c1_array,:c2_array,:c3_array,:c4_array,:c5_array,
2884: :c6_array,:c7_array,:c8_array,:c9_array,:c10_array,:c11_array,:c12_array,
2885: :c13_array,:c14_array,:c15_array,:c16_array,:c17_array,:c18_array,
2886: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
3107: :i_org_id,
3108: :i_program_application_id,
3109: :i_program_id,
3110: sysdate
3111: FROM AR_REMIT_GT r
3112: WHERE r.cash_receipt_history_id is not null';
3113:
3114: rem_t3 := dbms_sql.open_cursor;
3115:
3274: sysdate,
3275: :i_last_updated_by,
3276: :i_org_id,
3277: :i_last_update_login
3278: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,
3279: ar_lookups l
3280: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
3281: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
3282: AND l.lookup_code IN (''1'',''2'')';
3928: ar_receipt_methods rm,
3929: ar_receipt_classes rc,
3930: hz_cust_accounts hca,
3931: hz_parties party,
3932: ar_remit_gt g,
3933: /* Need to pass country code for SEPA specific receipts */
3934: ce_bank_acct_uses bau,
3935: ce_bank_accounts cba,
3936: hz_parties bank,