[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
1017: c_wo_rec.inventory_organization_id,
1018: c_wo_rec.operating_unit_id,
1019: c_wo_rec.ae_header_id,
1020: c_wo_rec.ae_line_num
1021: from cst_misc_reconciliation
1022: where rownum = 1;
1023: --}
1024: end loop; /* for c_wo_rec in c_wo(p_ou_id) */
1025:
1025:
1026: l_stmt_num := 30;
1027:
1028: /* Delete written-off transactions from Costing's Miscellaneous table */
1029: delete from cst_misc_reconciliation
1030: where operating_unit_id = p_ou_id
1031: and write_off_select_flag = 'Y';
1032:
1033:
1686: -- Function : Performs a write-off reversal and insert distributions and/or
1687: -- individual transactions back into the appropriate tables.
1688: -- If the reversing miscellaneous write-offs, then a write-off
1689: -- reversal is created and the individual miscellaneous transactions
1690: -- is inserted back into cst_misc_reconciliation. If reversing an
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
1998: (c_wo_rec.invoice_distribution_id is not null)) then
1999: --{
2000: l_stmt_num := 35;
2001:
2002: insert into cst_misc_reconciliation
2003: (
2004: transaction_date,
2005: amount,
2006: entered_amount,