APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on AR_CONC_PROCESS_REQUESTS

Line 34: DELETE from AR_CONC_PROCESS_REQUESTS

30: PROCEDURE populate_aging_info(p_fmode varchar2, p_from_date date,p_org_id number); -- Added for bug#7662453
31: PROCEDURE populate_contracts_info; -- Added for bug#8261043
32: PROCEDURE insert_conc_req IS
33: BEGIN
34: DELETE from AR_CONC_PROCESS_REQUESTS
35: where CONCURRENT_PROGRAM_NAME = 'IEX_POPULATE_UWQ_SUM';
36:
37: INSERT INTO AR_CONC_PROCESS_REQUESTS
38: (CONCURRENT_PROGRAM_NAME, REQUEST_ID)

Line 37: INSERT INTO AR_CONC_PROCESS_REQUESTS

33: BEGIN
34: DELETE from AR_CONC_PROCESS_REQUESTS
35: where CONCURRENT_PROGRAM_NAME = 'IEX_POPULATE_UWQ_SUM';
36:
37: INSERT INTO AR_CONC_PROCESS_REQUESTS
38: (CONCURRENT_PROGRAM_NAME, REQUEST_ID)
39: values ('IEX_POPULATE_UWQ_SUM',FND_GLOBAL.conc_request_id);
40: COMMIT;
41: END insert_conc_req;

Line 687: DELETE from AR_CONC_PROCESS_REQUESTS

683: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || sqlerrm);
684: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
685: l_return_status := 'E';
686: Rollback;
687: DELETE from AR_CONC_PROCESS_REQUESTS
688: where REQUEST_ID = FND_GLOBAL.conc_request_id;
689: commit;
690: if FND_GLOBAL.Conc_Request_Id is not null then
691: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

Line 702: DELETE from AR_CONC_PROCESS_REQUESTS

698: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || sqlerrm);
699: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQLERRM: ' || sqlerrm);
700: l_return_status := 'E';
701: Rollback;
702: DELETE from AR_CONC_PROCESS_REQUESTS
703: where REQUEST_ID = FND_GLOBAL.conc_request_id;
704: commit;
705: if FND_GLOBAL.Conc_Request_Id is not null then
706: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

Line 9418: DELETE from AR_CONC_PROCESS_REQUESTS

9414:
9415: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Updated contracts info in Table IEX_DLN_UWQ_SUMMARY at time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));
9416: end if;
9417: -- End for bug#8261043
9418: DELETE from AR_CONC_PROCESS_REQUESTS
9419: WHERE REQUEST_ID = FND_GLOBAL.conc_request_id;
9420: COMMIT;
9421:
9422:

Line 9465: DELETE from AR_CONC_PROCESS_REQUESTS

9461: END IF;
9462:
9463: -- End - Andre Araujo - 10/20/06 - Added dynamic sql
9464: Rollback;
9465: DELETE from AR_CONC_PROCESS_REQUESTS
9466: where REQUEST_ID = FND_GLOBAL.conc_request_id;
9467: commit;
9468:
9469: if FND_GLOBAL.Conc_Request_Id is not null then

Line 9516: DELETE from AR_CONC_PROCESS_REQUESTS

9512: END IF;
9513:
9514: -- End - Andre Araujo - 10/20/06 - Added dynamic sql
9515: Rollback;
9516: DELETE from AR_CONC_PROCESS_REQUESTS
9517: where REQUEST_ID = FND_GLOBAL.conc_request_id;
9518: commit;
9519:
9520: if FND_GLOBAL.Conc_Request_Id is not null then