[Home] [Help]
192: -- FND_API.G_TRUE => 'Y'
193: -- FND_API.G_FALSE => NULL
194: -- : p_prog IN NUMBER Required
195: -- Codes which tables's write_off_select_flag column will be altered
196: -- 0 => cst_reconciliation_summary (AP and PO Form)
197: -- 1 => cst_misc_reconciliation (Miscellaneous Form)
198: -- 2 => cst_write_offs (View Write-Offs Form)
199: -- OUT : x_count OUT NOCOPY VARCHAR2 Required
200: -- Succes Indicator
252: if(fnd_api.to_boolean(p_bit)) then
253: --{
254: if(p_prog = 0) then
255: --{
256: update cst_reconciliation_summary
257: set write_off_select_flag = 'Y'
258: where rowid = p_row_id;
259: --}
260: elsif(p_prog = 1) then
274: elsif(not fnd_api.to_boolean(p_bit)) then
275: --{
276: if(p_prog = 0) then
277: --{
278: update cst_reconciliation_summary
279: set write_off_select_flag = null
280: where rowid = p_row_id;
281: --}
282: elsif(p_prog = 1) then
572: -- IN : p_where IN VARCHAR2 Required
573: -- Where Clause
574: -- : p_prog IN NUMBER Required
575: -- Codes which table's write_off_select_flag column will be altered
576: -- 0 => cst_reconciliation_summary (AP and PO Form)
577: -- 1 => cst_misc_reconciliation (Miscellaneous Form)
578: -- 2 => cst_write_offs (View Write-Offs Form)
579: -- : p_ou_id IN NUMBER Required
580: -- Operating Unit Identifier
639: if(p_prog = 0) then
640: --{
641: select count(*), sum(po_balance + ap_balance + write_off_balance)
642: into x_tot, x_out
643: from cst_reconciliation_summary
644: where operating_unit_id = p_ou_id
645: and write_off_select_flag = 'Y';
646: --}
647: elsif(p_prog = 1) then
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
1158: request_id,
1159: program_application_id,
1160: program_id,
1161: program_update_date
1162: from cst_reconciliation_summary
1163: where operating_unit_id = l_ou_id
1164: and write_off_select_flag = 'Y';
1165:
1166: begin
1188:
1189: /* Make sure user selected PO distributions to write-off */
1190: select count(*)
1191: into l_rows
1192: from cst_reconciliation_summary
1193: where operating_unit_id = p_ou_id
1194: and write_off_select_flag = 'Y';
1195:
1196: if(l_rows > 0) then
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
1480: and capr.po_distribution_id = crs.po_distribution_id
1481: and capr.accrual_account_id = crs.accrual_account_id
1482: and crs.write_off_select_flag = 'Y');
1484: l_stmt_num := 40;
1485:
1486: /*
1487: Once all the individual transaction have been deleted, removed the
1488: header information from cst_reconciliation_summary
1489: */
1490: delete from cst_reconciliation_summary
1491: where operating_unit_id = p_ou_id
1492: and write_off_select_flag = 'Y';
1486: /*
1487: Once all the individual transaction have been deleted, removed the
1488: header information from cst_reconciliation_summary
1489: */
1490: delete from cst_reconciliation_summary
1491: where operating_unit_id = p_ou_id
1492: and write_off_select_flag = 'Y';
1493:
1494: l_stmt_num := 45;
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
2079: po_distribution_id/accrual_account_id pair
2080: */
2081: select count(*)
2082: into l_po_proc
2083: from cst_reconciliation_summary
2084: where po_distribution_id = c_wo_rec.po_distribution_id
2085: and accrual_account_id = c_wo_rec.accrual_account_id
2086: and operating_unit_id = c_wo_rec.operating_unit_id;
2087:
2212:
2213: l_stmt_num := 60;
2214:
2215: /* Insert the data into the summary table */
2216: insert into cst_reconciliation_summary
2217: (
2218: po_distribution_id,
2219: accrual_account_id,
2220: po_balance,
2296: l_stmt_num := 70;
2297:
2298: select (po_balance + ap_balance + write_off_balance)
2299: into l_po_proc
2300: from cst_reconciliation_summary
2301: where po_distribution_id = c_wo_rec.po_distribution_id
2302: and accrual_account_id = c_wo_rec.accrual_account_id
2303: and operating_unit_id = c_wo_rec.operating_unit_id;
2304:
2313: and operating_unit_id = c_wo_rec.operating_unit_id;
2314:
2315: l_stmt_num := 80;
2316:
2317: delete from cst_reconciliation_summary
2318: where po_distribution_id = c_wo_rec.po_distribution_id
2319: and accrual_account_id = c_wo_rec.accrual_account_id
2320: and operating_unit_id = c_wo_rec.operating_unit_id;
2321: --}
2323: else
2324: --{
2325: l_stmt_num := 85;
2326:
2327: update cst_reconciliation_summary crs
2328: set crs.write_off_balance = crs.write_off_balance + (-1 * c_wo_rec.amount)
2329: where po_distribution_id = c_wo_rec.po_distribution_id
2330: and accrual_account_id = c_wo_rec.accrual_account_id
2331: and operating_unit_id = c_wo_rec.operating_unit_id;