DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_LINES_INT_DRAFT_ALL

Line 4801: FROM ozf_resale_logs_all logs, ozf_resale_lines_int_draft_all intDraft -- Fix for Bug 14584673

4797: ,OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID REQUEST_ID
4798: ,fnd_global.prog_appl_id PROGRAM_APPLICATION_ID
4799: ,fnd_global.conc_program_id PROGRAM_ID
4800: ,SYSDATE PROGRAM_UPDATE_DATE
4801: FROM ozf_resale_logs_all logs, ozf_resale_lines_int_draft_all intDraft -- Fix for Bug 14584673
4802: WHERE logs.resale_id = intDraft.resale_line_int_id
4803: AND intDraft.draft_run_id = l_draft_run_id
4804: AND intDraft.org_id = l_org_id; -- nepanda : Fix for bug # 15900683
4805:

Line 5092: -- Inserting data into OZF_RESALE_LINES_INT_DRAFT_ALL for the request_id

5088: END IF; -- END if l_batch_tbl.EXISTS
5089:
5090: -- Bug 14194884 - TPA In Draft Mode ER : start : Updating OZF_RESALE_LINES_INT_ALL table with the records populated in OZF_RESALE_LINES_INT_ALL_TEMP table except for STATUS_CODE
5091: IF l_run_mode = 'DRAFT' THEN
5092: -- Inserting data into OZF_RESALE_LINES_INT_DRAFT_ALL for the request_id
5093: INSERT INTO OZF_RESALE_LINES_INT_DRAFT_ALL
5094: ( RESALE_LINES_INT_DRAFT_ID,
5095: DRAFT_RUN_ID,
5096: RESALE_LINE_INT_ID,

Line 5093: INSERT INTO OZF_RESALE_LINES_INT_DRAFT_ALL

5089:
5090: -- Bug 14194884 - TPA In Draft Mode ER : start : Updating OZF_RESALE_LINES_INT_ALL table with the records populated in OZF_RESALE_LINES_INT_ALL_TEMP table except for STATUS_CODE
5091: IF l_run_mode = 'DRAFT' THEN
5092: -- Inserting data into OZF_RESALE_LINES_INT_DRAFT_ALL for the request_id
5093: INSERT INTO OZF_RESALE_LINES_INT_DRAFT_ALL
5094: ( RESALE_LINES_INT_DRAFT_ID,
5095: DRAFT_RUN_ID,
5096: RESALE_LINE_INT_ID,
5097: OBJECT_VERSION_NUMBER,

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