[Home] [Help]
1082: -- Write-Off events in SLA. A single write-off event will be generated
1083: -- regardless of the number of transactions that make up the PO distribution.
1084: -- At the end, all the written-off PO distributions
1085: -- and individual AP and PO transactions are removed from
1086: -- cst_reconciliation_summary and cst_ap_po_reconciliation..
1087: -- Parameters :
1088: -- IN : p_wo_date IN DATE Required
1089: -- Write-Off Date
1090: -- : p_rea_id IN NUMBER Optional
1292: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1293: sysdate, --program_update_date,
1294: capr.ae_header_id,
1295: capr.ae_line_num
1296: from cst_ap_po_reconciliation capr
1297: where capr.po_distribution_id = c_wo_rec.po_distribution_id
1298: and capr.accrual_account_id = c_wo_rec.accrual_account_id
1299: and capr.operating_unit_id = c_wo_rec.operating_unit_id;
1300:
1302:
1303: /* Get the sum of the entered amount */
1304: select sum(capr.entered_amount)
1305: into l_ent_sum
1306: from cst_ap_po_reconciliation capr
1307: where capr.po_distribution_id = c_wo_rec.po_distribution_id
1308: and capr.accrual_account_id = c_wo_rec.accrual_account_id
1309: and capr.operating_unit_id = c_wo_rec.operating_unit_id;
1310:
1468: end loop; /* for c_wo_rec in c_wo(p_ou_id) */
1469:
1470: l_stmt_num := 35;
1471: /*
1472: First delete the individual transactions from cst_ap_po_reconciliation
1473: as to maintain referential integretiy.
1474: */
1475: delete from cst_ap_po_reconciliation capr
1476: where exists (
1471: /*
1472: First delete the individual transactions from cst_ap_po_reconciliation
1473: as to maintain referential integretiy.
1474: */
1475: delete from cst_ap_po_reconciliation capr
1476: where exists (
1477: select 'X'
1478: from cst_reconciliation_summary crs
1479: where capr.operating_unit_id = crs.operating_unit_id
1691: -- AP and PO distribution, then a write-off reversal is created and all
1692: -- the individual AP and PO transactions in addition to all write-offs
1693: -- and reversals sharing the same PO distribution ID and accrual account
1694: -- are summed up and if they equal a non-zero value, they are inserted
1695: -- into the cst_reconciliation_summary and cst_ap_po_reconciliation
1696: -- as appropriate (see package body).
1697: -- Parameters :
1698: -- IN : p_wo_date IN DATE Required
1699: -- Write-Off Date
2089: if(l_po_proc = 0) then
2090: --{
2091: l_stmt_num := 50;
2092:
2093: insert into cst_ap_po_reconciliation
2094: (
2095: transaction_date,
2096: amount,
2097: entered_amount,
2158:
2159: l_stmt_num := 55;
2160:
2161: /* Next insert the new write-off header and reversal header into CAPR */
2162: insert into cst_ap_po_reconciliation
2163: (
2164: transaction_date,
2165: amount,
2166: entered_amount,
2261: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2262: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2263: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2264: sysdate --program_update_date
2265: from cst_ap_po_reconciliation capr,
2266: cst_write_offs cwo
2267: where cwo.write_off_id = c_wo_rec.l_wo_id
2268: and cwo.operating_unit_id = c_wo_rec.operating_unit_id
2269: and capr.po_distribution_id = cwo.po_distribution_id
2306: if(l_po_proc + (-1 * c_wo_rec.amount) = 0) then
2307: --{
2308: l_stmt_num := 75;
2309:
2310: delete from cst_ap_po_reconciliation
2311: where po_distribution_id = c_wo_rec.po_distribution_id
2312: and accrual_account_id = c_wo_rec.accrual_account_id
2313: and operating_unit_id = c_wo_rec.operating_unit_id;
2314:
2331: and operating_unit_id = c_wo_rec.operating_unit_id;
2332:
2333: l_stmt_num := 90;
2334:
2335: insert into cst_ap_po_reconciliation
2336: (
2337: transaction_date,
2338: amount,
2339: entered_amount,