eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 887: into cst_write_offs

883: Insert the selected miscellaneous transactions into
884: Costing's Write-Off tables
885: */
886: insert all
887: into cst_write_offs
888: (
889: write_off_id,
890: transaction_date,
891: accrual_account_id,

Line 1415: insert into cst_write_offs

1411: /*
1412: Insert the PO distribution information, as well as the extra values
1413: recently calcuated into the write-off headers table.
1414: */
1415: insert into cst_write_offs
1416: (
1417: write_off_id,
1418: transaction_date,
1419: accrual_account_id,

Line 1638: from cst_write_offs

1634: write-off ID is another distributions reversal ID
1635: */
1636: select count(*)
1637: into l_enabled
1638: from cst_write_offs
1639: where reversal_id = p_wo_id
1640: and operating_unit_id = p_ou_id;
1641: if(l_enabled = 0) then
1642: --{

Line 1786: from cst_write_offs

1782: request_id,
1783: program_application_id,
1784: program_id,
1785: program_update_date
1786: from cst_write_offs
1787: where operating_unit_id = l_ou_id
1788: and write_off_select_flag = 'Y';
1789:
1790: begin

Line 1816: from cst_write_offs

1812:
1813: /* Check that the user has selected distributions to reverse */
1814: select count(*)
1815: into l_rows
1816: from cst_write_offs
1817: where operating_unit_id = p_ou_id
1818: and write_off_select_flag = 'Y';
1819:
1820: if(l_rows > 0) then

Line 1864: insert into cst_write_offs

1860:
1861: l_stmt_num := 20;
1862:
1863: /* Insert the reversal into the headers table */
1864: insert into cst_write_offs
1865: (
1866: write_off_id,
1867: transaction_date,
1868: accrual_account_id,

Line 2072: cst_write_offs cwo

2068: sysdate, --program_update_date,
2069: cwod.ae_header_id,
2070: cwod.ae_line_num
2071: from cst_write_off_details cwod,
2072: cst_write_offs cwo
2073: where cwo.write_off_id = c_wo_rec.l_wo_id
2074: and cwo.operating_unit_id = c_wo_rec.operating_unit_id
2075: and cwod.write_off_id = cwo.write_off_id
2076: and cwod.operating_unit_id = cwo.operating_unit_id;

Line 2160: from cst_write_offs cwo,

2156: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2157: sysdate, --program_update_date,
2158: cwod.ae_header_id,
2159: cwod.ae_line_num
2160: from cst_write_offs cwo,
2161: cst_write_off_details cwod
2162: where cwo.write_off_id = c_wo_rec.l_wo_id
2163: and cwo.po_distribution_id = c_wo_rec.po_distribution_id
2164: and cwo.accrual_account_id = c_wo_rec.accrual_account_id

Line 2217: from cst_write_offs cwo

2213: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2214: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2215: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2216: sysdate --program_update_date
2217: from cst_write_offs cwo
2218: where cwo.write_off_id in (c_wo_rec.l_wo_id, c_wo_rec.l_rev_id)
2219: and cwo.po_distribution_id = c_wo_rec.po_distribution_id
2220: and cwo.accrual_account_id = c_wo_rec.accrual_account_id
2221: and cwo.operating_unit_id = c_wo_rec.operating_unit_id;

Line 2276: cst_write_offs cwo

2272: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2273: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2274: sysdate --program_update_date
2275: from cst_ap_po_reconciliation capr,
2276: cst_write_offs cwo
2277: where cwo.write_off_id = c_wo_rec.l_wo_id
2278: and cwo.operating_unit_id = c_wo_rec.operating_unit_id
2279: and capr.po_distribution_id = cwo.po_distribution_id
2280: and capr.accrual_account_id = cwo.accrual_account_id

Line 2390: from cst_write_offs cwo

2386: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2387: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2388: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2389: sysdate --program_update_date
2390: from cst_write_offs cwo
2391: where cwo.write_off_id = c_wo_rec.l_wo_id
2392: and cwo.po_distribution_id = c_wo_rec.po_distribution_id
2393: and cwo.accrual_account_id = c_wo_rec.accrual_account_id
2394: and cwo.operating_unit_id = c_wo_rec.operating_unit_id;

Line 2422: Update cst_write_offs

2418: p_entity_type_code => 'WO_ACCOUNTING_EVENTS');
2419:
2420: /* need to reset the write_off_select_flag back CWO back to NULL */
2421:
2422: Update cst_write_offs
2423: set write_off_select_flag = NULL
2424: where operating_unit_id = p_ou_id
2425: and write_off_select_flag = 'Y';
2426: