DBA Data[Home] [Help]

APPS.CST_ACCRUAL_REC_PVT dependencies on CST_AP_PO_RECONCILIATION

Line 1092: -- cst_reconciliation_summary and cst_ap_po_reconciliation..

1088: -- Write-Off events in SLA. A single write-off event will be generated
1089: -- regardless of the number of transactions that make up the PO distribution.
1090: -- At the end, all the written-off PO distributions
1091: -- and individual AP and PO transactions are removed from
1092: -- cst_reconciliation_summary and cst_ap_po_reconciliation..
1093: -- Parameters :
1094: -- IN : p_wo_date IN DATE Required
1095: -- Write-Off Date
1096: -- : p_rea_id IN NUMBER Optional

Line 1302: from cst_ap_po_reconciliation capr

1298: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1299: sysdate, --program_update_date,
1300: capr.ae_header_id,
1301: capr.ae_line_num
1302: from cst_ap_po_reconciliation capr
1303: where capr.po_distribution_id = c_wo_rec.po_distribution_id
1304: and capr.accrual_account_id = c_wo_rec.accrual_account_id
1305: and capr.operating_unit_id = c_wo_rec.operating_unit_id;
1306:

Line 1312: from cst_ap_po_reconciliation capr

1308:
1309: /* Get the sum of the entered amount */
1310: select sum(capr.entered_amount)
1311: into l_ent_sum
1312: from cst_ap_po_reconciliation capr
1313: where capr.po_distribution_id = c_wo_rec.po_distribution_id
1314: and capr.accrual_account_id = c_wo_rec.accrual_account_id
1315: and capr.operating_unit_id = c_wo_rec.operating_unit_id;
1316:

Line 1482: First delete the individual transactions from cst_ap_po_reconciliation

1478: end loop; /* for c_wo_rec in c_wo(p_ou_id) */
1479:
1480: l_stmt_num := 35;
1481: /*
1482: First delete the individual transactions from cst_ap_po_reconciliation
1483: as to maintain referential integretiy.
1484: */
1485: delete from cst_ap_po_reconciliation capr
1486: where exists (

Line 1485: delete from cst_ap_po_reconciliation capr

1481: /*
1482: First delete the individual transactions from cst_ap_po_reconciliation
1483: as to maintain referential integretiy.
1484: */
1485: delete from cst_ap_po_reconciliation capr
1486: where exists (
1487: select 'X'
1488: from cst_reconciliation_summary crs
1489: where capr.operating_unit_id = crs.operating_unit_id

Line 1705: -- into the cst_reconciliation_summary and cst_ap_po_reconciliation

1701: -- AP and PO distribution, then a write-off reversal is created and all
1702: -- the individual AP and PO transactions in addition to all write-offs
1703: -- and reversals sharing the same PO distribution ID and accrual account
1704: -- are summed up and if they equal a non-zero value, they are inserted
1705: -- into the cst_reconciliation_summary and cst_ap_po_reconciliation
1706: -- as appropriate (see package body).
1707: -- Parameters :
1708: -- IN : p_wo_date IN DATE Required
1709: -- Write-Off Date

Line 2103: insert into cst_ap_po_reconciliation

2099: if(l_po_proc = 0) then
2100: --{
2101: l_stmt_num := 50;
2102:
2103: insert into cst_ap_po_reconciliation
2104: (
2105: transaction_date,
2106: amount,
2107: entered_amount,

Line 2172: insert into cst_ap_po_reconciliation

2168:
2169: l_stmt_num := 55;
2170:
2171: /* Next insert the new write-off header and reversal header into CAPR */
2172: insert into cst_ap_po_reconciliation
2173: (
2174: transaction_date,
2175: amount,
2176: entered_amount,

Line 2275: from cst_ap_po_reconciliation capr,

2271: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2272: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2273: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2274: sysdate --program_update_date
2275: from cst_ap_po_reconciliation capr,
2276: cst_write_offs cwo
2277: where cwo.write_off_id = c_wo_rec.l_wo_id
2278: and cwo.operating_unit_id = c_wo_rec.operating_unit_id
2279: and capr.po_distribution_id = cwo.po_distribution_id

Line 2320: delete from cst_ap_po_reconciliation

2316: if(l_po_proc + (-1 * c_wo_rec.amount) = 0) then
2317: --{
2318: l_stmt_num := 75;
2319:
2320: delete from cst_ap_po_reconciliation
2321: where po_distribution_id = c_wo_rec.po_distribution_id
2322: and accrual_account_id = c_wo_rec.accrual_account_id
2323: and operating_unit_id = c_wo_rec.operating_unit_id;
2324:

Line 2345: insert into cst_ap_po_reconciliation

2341: and operating_unit_id = c_wo_rec.operating_unit_id;
2342:
2343: l_stmt_num := 90;
2344:
2345: insert into cst_ap_po_reconciliation
2346: (
2347: transaction_date,
2348: amount,
2349: entered_amount,