[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
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
1164: request_id,
1165: program_application_id,
1166: program_id,
1167: program_update_date
1168: from cst_reconciliation_summary
1169: where operating_unit_id = l_ou_id
1170: and write_off_select_flag = 'Y';
1171:
1172: begin
1194:
1195: /* Make sure user selected PO distributions to write-off */
1196: select count(*)
1197: into l_rows
1198: from cst_reconciliation_summary
1199: where operating_unit_id = p_ou_id
1200: and write_off_select_flag = 'Y';
1201:
1202: if(l_rows > 0) then
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
1490: and capr.po_distribution_id = crs.po_distribution_id
1491: and capr.accrual_account_id = crs.accrual_account_id
1492: and crs.write_off_select_flag = 'Y');
1494: l_stmt_num := 40;
1495:
1496: /*
1497: Once all the individual transaction have been deleted, removed the
1498: header information from cst_reconciliation_summary
1499: */
1500: delete from cst_reconciliation_summary
1501: where operating_unit_id = p_ou_id
1502: and write_off_select_flag = 'Y';
1496: /*
1497: Once all the individual transaction have been deleted, removed the
1498: header information from cst_reconciliation_summary
1499: */
1500: delete from cst_reconciliation_summary
1501: where operating_unit_id = p_ou_id
1502: and write_off_select_flag = 'Y';
1503:
1504: l_stmt_num := 45;
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
2089: po_distribution_id/accrual_account_id pair
2090: */
2091: select count(*)
2092: into l_po_proc
2093: from cst_reconciliation_summary
2094: where po_distribution_id = c_wo_rec.po_distribution_id
2095: and accrual_account_id = c_wo_rec.accrual_account_id
2096: and operating_unit_id = c_wo_rec.operating_unit_id;
2097:
2222:
2223: l_stmt_num := 60;
2224:
2225: /* Insert the data into the summary table */
2226: insert into cst_reconciliation_summary
2227: (
2228: po_distribution_id,
2229: accrual_account_id,
2230: po_balance,
2306: l_stmt_num := 70;
2307:
2308: select (po_balance + ap_balance + write_off_balance)
2309: into l_po_proc
2310: from cst_reconciliation_summary
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:
2323: and operating_unit_id = c_wo_rec.operating_unit_id;
2324:
2325: l_stmt_num := 80;
2326:
2327: delete from cst_reconciliation_summary
2328: where po_distribution_id = c_wo_rec.po_distribution_id
2329: and accrual_account_id = c_wo_rec.accrual_account_id
2330: and operating_unit_id = c_wo_rec.operating_unit_id;
2331: --}
2333: else
2334: --{
2335: l_stmt_num := 85;
2336:
2337: update cst_reconciliation_summary crs
2338: set crs.write_off_balance = crs.write_off_balance + (-1 * c_wo_rec.amount)
2339: where po_distribution_id = c_wo_rec.po_distribution_id
2340: and accrual_account_id = c_wo_rec.accrual_account_id
2341: and operating_unit_id = c_wo_rec.operating_unit_id;