DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on CST_AP_PO_RECONCILIATION

Line 4218: debug(' deleting into cst_ap_po_reconciliation');

4214:
4215: /* Delete all transactions details from the AP/PO details table for those rows that belong to
4216: the current po_dist_id */
4217:
4218: debug(' deleting into cst_ap_po_reconciliation');
4219:
4220: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
4221: DELETE from cst_ap_po_reconciliation capr
4222: WHERE capr.operating_unit_id = p_operating_unit

Line 4221: DELETE from cst_ap_po_reconciliation capr

4217:
4218: debug(' deleting into cst_ap_po_reconciliation');
4219:
4220: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
4221: DELETE from cst_ap_po_reconciliation capr
4222: WHERE capr.operating_unit_id = p_operating_unit
4223: AND capr.po_distribution_id = po_dists_tab(indx);
4224:
4225: debug(' Done Deleting old data from CAPR');

Line 4231: debug(' deleting into cst_ap_po_reconciliation');

4227: l_stmt_num := 90;
4228:
4229: /* insert into AP/PO table from GTT */
4230:
4231: debug(' deleting into cst_ap_po_reconciliation');
4232:
4233: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
4234: Insert into CST_AP_PO_RECONCILIATION
4235: (

Line 4234: Insert into CST_AP_PO_RECONCILIATION

4230:
4231: debug(' deleting into cst_ap_po_reconciliation');
4232:
4233: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
4234: Insert into CST_AP_PO_RECONCILIATION
4235: (
4236: transaction_date,
4237: amount,
4238: entered_amount,