DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_DRAFT_LOGS_ALL

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

Line 5613: FROM OZF_RESALE_DRAFT_LOGS_ALL)

5609: REQUEST_ID,
5610: PROGRAM_APPLICATION_ID,
5611: PROGRAM_ID,
5612: PROGRAM_UPDATE_DATE
5613: FROM OZF_RESALE_DRAFT_LOGS_ALL)
5614: VALUES l_resale_logs_tbl(i);
5615: $ELSE
5616: FORALL i IN NVL(l_resale_logs_tbl.FIRST, 1) .. NVL(l_resale_logs_tbl.LAST, 0)
5617: INSERT INTO OZF_RESALE_DRAFT_LOGS_ALL

Line 5617: INSERT INTO OZF_RESALE_DRAFT_LOGS_ALL

5613: FROM OZF_RESALE_DRAFT_LOGS_ALL)
5614: VALUES l_resale_logs_tbl(i);
5615: $ELSE
5616: FORALL i IN NVL(l_resale_logs_tbl.FIRST, 1) .. NVL(l_resale_logs_tbl.LAST, 0)
5617: INSERT INTO OZF_RESALE_DRAFT_LOGS_ALL
5618: ( RESALE_DRAFT_LOG_ID,
5619: RESALE_ID,
5620: DRAFT_RUN_ID,
5621: RESALE_ID_TYPE,