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.OZF_TP_ACCRUAL_PVT dependencies on OZF_FUNDS_UTILIZED_DRAFT_ALL

Line 4326: -- Fix for Bug 14584673 : INSERT INTO OZF_FUNDS_UTILIZED_DRAFT_ALL table is done here for accruals of all the lines at one time.

4322: END IF; -- END if for order_NUMBER, bill_to cust not NULL
4323: END LOOP; -- END LOOP FOR l_order_num_tbl
4324:
4325: IF l_run_mode = 'DRAFT' THEN
4326: -- Fix for Bug 14584673 : INSERT INTO OZF_FUNDS_UTILIZED_DRAFT_ALL table is done here for accruals of all the lines at one time.
4327: IF l_ozf_draft_accrual_tbl IS NOT NULL THEN
4328: IF l_ozf_draft_accrual_tbl.count > 0 THEN
4329:
4330: --//Fix for Bug 16170069 - Syntax correction

Line 4370: FROM OZF_FUNDS_UTILIZED_DRAFT_ALL)

4366: DISCOUNT_TYPE,
4367: DISCOUNT_AMOUNT,
4368: DISCOUNT_AMOUNT_CURRENCY_CODE,
4369: LIST_LINE_ID
4370: FROM OZF_FUNDS_UTILIZED_DRAFT_ALL)
4371: VALUES l_ozf_draft_accrual_tbl(ip);
4372: $ELSE
4373: FORALL ip IN NVL(l_ozf_draft_accrual_tbl.FIRST, 1) .. NVL(l_ozf_draft_accrual_tbl.LAST, 0)
4374: INSERT INTO OZF_FUNDS_UTILIZED_DRAFT_ALL

Line 4374: INSERT INTO OZF_FUNDS_UTILIZED_DRAFT_ALL

4370: FROM OZF_FUNDS_UTILIZED_DRAFT_ALL)
4371: VALUES l_ozf_draft_accrual_tbl(ip);
4372: $ELSE
4373: FORALL ip IN NVL(l_ozf_draft_accrual_tbl.FIRST, 1) .. NVL(l_ozf_draft_accrual_tbl.LAST, 0)
4374: INSERT INTO OZF_FUNDS_UTILIZED_DRAFT_ALL
4375: ( DRAFT_UTILIZATION_ID,
4376: DRAFT_RUN_ID,
4377: OBJECT_TYPE,
4378: OBJECT_ID,

Line 5577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please check OZF_FUNDS_UTILIZED_DRAFT_ALL, OZF_RESALE_DRAFT_LOGS_ALL and OZF_RESALE_LINES_INT_DRAFT_ALL tables for accrual details ');

5573: CLOSE csr_processed_lines_count;
5574:
5575: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Draft Run completed for Run Id : ' || l_draft_run_id || ' And Org Id : ' || l_org_id); -- nepanda : Fix for bug # 15900683
5576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number Of Lines Processed : '|| l_processed_lines_count);
5577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please check OZF_FUNDS_UTILIZED_DRAFT_ALL, OZF_RESALE_DRAFT_LOGS_ALL and OZF_RESALE_LINES_INT_DRAFT_ALL tables for accrual details ');
5578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
5579:
5580: -- Fix for Bug 14584673
5581: UPDATE ozf_resale_lines_int_all