APPS.AR_ECAPP_PKG dependencies on AR_SETTLEMENT_ERRORS_GT

Line 26: arp_standard.debug ('Inserting record into ar_settlement_errors_gt table');

22:
23: IF PG_DEBUG in ('Y', 'C') THEN
24: fnd_file.put_line(FND_FILE.LOG,'AR_ECAPP_PKG.UPDATE_STATUS()+');
25: fnd_file.put_line(FND_FILE.LOG, totalRows);
26: arp_standard.debug ('Inserting record into ar_settlement_errors_gt table');
27: END IF;
28:
29: FORALL i in 1 .. totalRows
30: insert into ar_settlement_errors_gt(

Line 30: insert into ar_settlement_errors_gt(

26: arp_standard.debug ('Inserting record into ar_settlement_errors_gt table');
27: END IF;
28:
29: FORALL i in 1 .. totalRows
30: insert into ar_settlement_errors_gt(
31: txn_id,
32: req_type,
33: Status,
34: updatedt,

Line 118: ar_settlement_errors_gt gt, iby_trxn_summaries_all summ,

114: CURSOR C1 IS
115: SELECT cr.cash_receipt_id, cr.receipt_number, cr.org_id,
116: summ.bepcode, summ.bepmessage, summ.instrtype
117: FROM ar_cash_receipts_all cr, ar_cash_receipt_history_all crh ,
118: ar_settlement_errors_gt gt, iby_trxn_summaries_all summ,
119: iby_fndcpt_tx_operations op
120: WHERE gt.req_type in ('ORAPMTCAPTURE', 'ORAPMTRETURN', 'ORAPMTCREDIT', 'ORAPMTVOID', 'ORAPMTBATCHREQ')
121: AND summ.transactionid = gt.txn_id
122: AND summ.reqtype = gt.req_type

Line 131: FROM ar_settlement_errors_gt gt_in

127: and crh.status = 'REMITTED'
128: and crh.current_record_flag = 'Y'
129: AND NOT EXISTS
130: (SELECT 1
131: FROM ar_settlement_errors_gt gt_in
132: WHERE gt_in.txn_id = gt.txn_id
133: AND gt_in.status = 0)
134: AND summ.rowid IN
135: (SELECT max(rowid)