APPS.AR_AUTOREC_API dependencies on AR_AUTOREC_INTERIM

Line 743: from ar_autorec_interim a

739: payment_channel_code,
740: payment_instrument,
741: null,
742: null
743: from ar_autorec_interim a
744: where a.worker_id = decode(l_current_worker_number,0,a.worker_id,
745: l_current_worker_number)
746: and a.batch_id = o_batch_id;
747:

Line 807: from ar_autorec_interim

803: invoke the report */
804: IF l_total_workers = 0 THEN
805: --cleanup the interim table
806: delete
807: from ar_autorec_interim
808: where batch_id = o_batch_id;
809:
810: --release the lock on batch record
811: l_batch_lock_flag :=

Line 893: from ar_autorec_interim

889: --anyway repopulate the needed data
890: IF l_total_workers = 0
891: THEN
892: delete
893: from ar_autorec_interim
894: where batch_id = o_batch_id;
895:
896: IF p_approve_flag = 'Y'
897: THEN

Line 1320: from ar_autorec_interim

1316: commit;
1317:
1318: --cleanup interim table
1319: delete
1320: from ar_autorec_interim
1321: where batch_id = o_batch_id;
1322:
1323: l_batch_lock_flag := ARP_RW_BATCHES_PKG.release_lock( o_batch_id, l_batch_lock_msg);
1324:

Line 1332: from ar_autorec_interim

1328: WHEN OTHERS THEN
1329: --incase of any exception thrown,cleanup the interim table as the next run will
1330: --anyway repopulate the needed data
1331: delete
1332: from ar_autorec_interim
1333: where batch_id = o_batch_id;
1334:
1335: --release the lock on batch record
1336: l_batch_lock_flag :=

Line 1661: l_sel_stmt := 'INSERT /*+ parallel(a) append */ into ar_autorec_interim a ';

1657: END IF;
1658:
1659: -- Build the query dynamically based on the input parameters
1660: IF PG_PARALLEL IN ('Y', 'C') THEN
1661: l_sel_stmt := 'INSERT /*+ parallel(a) append */ into ar_autorec_interim a ';
1662: ELSE
1663: l_sel_stmt := 'INSERT into ar_autorec_interim a ';
1664: END IF;
1665:

Line 1663: l_sel_stmt := 'INSERT into ar_autorec_interim a ';

1659: -- Build the query dynamically based on the input parameters
1660: IF PG_PARALLEL IN ('Y', 'C') THEN
1661: l_sel_stmt := 'INSERT /*+ parallel(a) append */ into ar_autorec_interim a ';
1662: ELSE
1663: l_sel_stmt := 'INSERT into ar_autorec_interim a ';
1664: END IF;
1665:
1666: l_sel_stmt := l_sel_stmt ||
1667: ' SELECT /*+ leading(PS1) use_nl(ps,cust_cp,site_cp,cust_cpa,site_cpa,ct,x,u,p) rowid(ps) index_ffs(ps1) parallel_index(ps1) */

Line 1908: from ar_autorec_interim a

1904: set selected_for_receipt_batch_id = p_batch_id
1905: where payment_schedule_id in
1906: ( select /*+ cardinality(a 10) */
1907: payment_schedule_id
1908: from ar_autorec_interim a
1909: where batch_id = p_batch_id);
1910:
1911: IF PG_DEBUG in ('Y', 'C') THEN
1912: arp_debug.debug('Number of PS records stamped : '||SQL%ROWCOUNT);