DBA Data[Home] [Help]

APPS.CST_ACCRUAL_REC_PVT dependencies on CST_WRITE_OFFS

Line 198: -- 2 => cst_write_offs (View Write-Offs Form)

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
202: -- FND_API.G_FALSE => Failure

Line 268: update cst_write_offs

264: where rowid = p_row_id;
265: --}
266: elsif(p_prog = 2) then
267: --{
268: update cst_write_offs
269: set write_off_select_flag = 'Y'
270: where rowid = p_row_id;
271: --}
272: end if; /* p_prog=0, p_prog=1, p_prog=2 */

Line 290: update cst_write_offs

286: where rowid = p_row_id;
287: --}
288: elsif(p_prog = 2) then
289: --{
290: update cst_write_offs
291: set write_off_select_flag = null
292: where rowid = p_row_id;
293: --}
294: end if; /* p_prog=0, p_prog=1, p_prog=2 */

Line 578: -- 2 => cst_write_offs (View Write-Offs Form)

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
582: -- Sum of distributions/transactions selected

Line 881: into cst_write_offs

877: Insert the selected miscellaneous transactions into
878: Costing's Write-Off tables
879: */
880: insert all
881: into cst_write_offs
882: (
883: write_off_id,
884: transaction_date,
885: accrual_account_id,

Line 1405: insert into cst_write_offs

1401: /*
1402: Insert the PO distribution information, as well as the extra values
1403: recently calcuated into the write-off headers table.
1404: */
1405: insert into cst_write_offs
1406: (
1407: write_off_id,
1408: transaction_date,
1409: accrual_account_id,

Line 1628: from cst_write_offs

1624: write-off ID is another distributions reversal ID
1625: */
1626: select count(*)
1627: into l_enabled
1628: from cst_write_offs
1629: where reversal_id = p_wo_id
1630: and operating_unit_id = p_ou_id;
1631: if(l_enabled = 0) then
1632: --{

Line 1776: from cst_write_offs

1772: request_id,
1773: program_application_id,
1774: program_id,
1775: program_update_date
1776: from cst_write_offs
1777: where operating_unit_id = l_ou_id
1778: and write_off_select_flag = 'Y';
1779:
1780: begin

Line 1806: from cst_write_offs

1802:
1803: /* Check that the user has selected distributions to reverse */
1804: select count(*)
1805: into l_rows
1806: from cst_write_offs
1807: where operating_unit_id = p_ou_id
1808: and write_off_select_flag = 'Y';
1809:
1810: if(l_rows > 0) then

Line 1854: insert into cst_write_offs

1850:
1851: l_stmt_num := 20;
1852:
1853: /* Insert the reversal into the headers table */
1854: insert into cst_write_offs
1855: (
1856: write_off_id,
1857: transaction_date,
1858: accrual_account_id,

Line 2062: cst_write_offs cwo

2058: sysdate, --program_update_date,
2059: cwod.ae_header_id,
2060: cwod.ae_line_num
2061: from cst_write_off_details cwod,
2062: cst_write_offs cwo
2063: where cwo.write_off_id = c_wo_rec.l_wo_id
2064: and cwo.operating_unit_id = c_wo_rec.operating_unit_id
2065: and cwod.write_off_id = cwo.write_off_id
2066: and cwod.operating_unit_id = cwo.operating_unit_id;

Line 2150: from cst_write_offs cwo,

2146: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2147: sysdate, --program_update_date,
2148: cwod.ae_header_id,
2149: cwod.ae_line_num
2150: from cst_write_offs cwo,
2151: cst_write_off_details cwod
2152: where cwo.write_off_id = c_wo_rec.l_wo_id
2153: and cwo.po_distribution_id = c_wo_rec.po_distribution_id
2154: and cwo.accrual_account_id = c_wo_rec.accrual_account_id

Line 2207: from cst_write_offs cwo

2203: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2204: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2205: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2206: sysdate --program_update_date
2207: from cst_write_offs cwo
2208: where cwo.write_off_id in (c_wo_rec.l_wo_id, c_wo_rec.l_rev_id)
2209: and cwo.po_distribution_id = c_wo_rec.po_distribution_id
2210: and cwo.accrual_account_id = c_wo_rec.accrual_account_id
2211: and cwo.operating_unit_id = c_wo_rec.operating_unit_id;

Line 2266: cst_write_offs cwo

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
2270: and capr.accrual_account_id = cwo.accrual_account_id

Line 2380: from cst_write_offs cwo

2376: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2377: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2378: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2379: sysdate --program_update_date
2380: from cst_write_offs cwo
2381: where cwo.write_off_id = c_wo_rec.l_wo_id
2382: and cwo.po_distribution_id = c_wo_rec.po_distribution_id
2383: and cwo.accrual_account_id = c_wo_rec.accrual_account_id
2384: and cwo.operating_unit_id = c_wo_rec.operating_unit_id;

Line 2412: Update cst_write_offs

2408: p_entity_type_code => 'WO_ACCOUNTING_EVENTS');
2409:
2410: /* need to reset the write_off_select_flag back CWO back to NULL */
2411:
2412: Update cst_write_offs
2413: set write_off_select_flag = NULL
2414: where operating_unit_id = p_ou_id
2415: and write_off_select_flag = 'Y';
2416: