[Home] [Help]
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
201: -- FND_API.G_TRUE => Success
258: where rowid = p_row_id;
259: --}
260: elsif(p_prog = 1) then
261: --{
262: update cst_misc_reconciliation
263: set write_off_select_flag = 'Y'
264: where rowid = p_row_id;
265: --}
266: elsif(p_prog = 2) then
280: where rowid = p_row_id;
281: --}
282: elsif(p_prog = 1) then
283: --{
284: update cst_misc_reconciliation
285: set write_off_select_flag = null
286: where rowid = p_row_id;
287: --}
288: elsif(p_prog = 2) then
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
581: -- OUT : x_out OUT NOCOPY NUBMER Required
647: elsif(p_prog = 1) then
648: --{
649: select count(*), sum(amount)
650: into x_tot, x_out
651: from cst_misc_reconciliation
652: where operating_unit_id = p_ou_id
653: and write_off_select_flag = 'Y';
654: --}
655: end if; /* p_prog = 0, p_prog = 1 */
683: -- Pre-reqs : None.
684: -- Function : Write-off transactions selected in the Miscellaneous
685: -- Accrual Write-Off Form in Costing tables. Proecedue will also generate
686: -- Write-Off events in SLA. At the end, all the written-off transactions are
687: -- removed from cst_misc_reconciliation.
688: -- Parameters :
689: -- IN : p_wo_date IN DATE Required
690: -- Write-Off Date
691: -- : p_off_id IN NUMBER Required
767: program_id,
768: program_update_date,
769: ae_header_id,
770: ae_line_num
771: from cst_misc_reconciliation
772: where operating_unit_id = l_ou_id
773: and write_off_select_flag = 'Y';
774:
775: begin
799:
800: /* Check whether any transactions have been selected for write-off */
801: select count(*)
802: into l_rows
803: from cst_misc_reconciliation
804: where operating_unit_id = p_ou_id
805: and write_off_select_flag = 'Y';
806:
807: if(l_rows > 0) then
1023: c_wo_rec.inventory_organization_id,
1024: c_wo_rec.operating_unit_id,
1025: c_wo_rec.ae_header_id,
1026: c_wo_rec.ae_line_num
1027: from cst_misc_reconciliation
1028: where rownum = 1;
1029: --}
1030: end loop; /* for c_wo_rec in c_wo(p_ou_id) */
1031:
1031:
1032: l_stmt_num := 30;
1033:
1034: /* Delete written-off transactions from Costing's Miscellaneous table */
1035: delete from cst_misc_reconciliation
1036: where operating_unit_id = p_ou_id
1037: and write_off_select_flag = 'Y';
1038:
1039:
1696: -- Function : Performs a write-off reversal and insert distributions and/or
1697: -- individual transactions back into the appropriate tables.
1698: -- If the reversing miscellaneous write-offs, then a write-off
1699: -- reversal is created and the individual miscellaneous transactions
1700: -- is inserted back into cst_misc_reconciliation. If reversing an
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
2008: (c_wo_rec.invoice_distribution_id is not null)) then
2009: --{
2010: l_stmt_num := 35;
2011:
2012: insert into cst_misc_reconciliation
2013: (
2014: transaction_date,
2015: amount,
2016: entered_amount,