DBA Data[Home] [Help]

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on AR_CONC_PROCESS_REQUESTS

Line 27: DELETE from AR_CONC_PROCESS_REQUESTS

23: TYPE date_list is TABLE of DATE INDEX BY BINARY_INTEGER;
24:
25: PROCEDURE insert_conc_req IS
26: BEGIN
27: DELETE from AR_CONC_PROCESS_REQUESTS
28: where CONCURRENT_PROGRAM_NAME = 'IEX_POPULATE_UWQ_SUM';
29:
30: INSERT INTO AR_CONC_PROCESS_REQUESTS
31: (CONCURRENT_PROGRAM_NAME, REQUEST_ID)

Line 30: INSERT INTO AR_CONC_PROCESS_REQUESTS

26: BEGIN
27: DELETE from AR_CONC_PROCESS_REQUESTS
28: where CONCURRENT_PROGRAM_NAME = 'IEX_POPULATE_UWQ_SUM';
29:
30: INSERT INTO AR_CONC_PROCESS_REQUESTS
31: (CONCURRENT_PROGRAM_NAME, REQUEST_ID)
32: values ('IEX_POPULATE_UWQ_SUM',FND_GLOBAL.conc_request_id);
33: COMMIT;
34: END insert_conc_req;

Line 3291: DELETE from AR_CONC_PROCESS_REQUESTS

3287: END IF;
3288:
3289: --Bug5701973. End.
3290:
3291: DELETE from AR_CONC_PROCESS_REQUESTS
3292: WHERE REQUEST_ID = FND_GLOBAL.conc_request_id;
3293: COMMIT;
3294:
3295:

Line 3338: DELETE from AR_CONC_PROCESS_REQUESTS

3334: END IF;
3335:
3336: -- End - Andre Araujo - 10/20/06 - Added dynamic sql
3337: Rollback;
3338: DELETE from AR_CONC_PROCESS_REQUESTS
3339: where REQUEST_ID = FND_GLOBAL.conc_request_id;
3340: commit;
3341:
3342: if FND_GLOBAL.Conc_Request_Id is not null then

Line 3389: DELETE from AR_CONC_PROCESS_REQUESTS

3385: END IF;
3386:
3387: -- End - Andre Araujo - 10/20/06 - Added dynamic sql
3388: Rollback;
3389: DELETE from AR_CONC_PROCESS_REQUESTS
3390: where REQUEST_ID = FND_GLOBAL.conc_request_id;
3391: commit;
3392:
3393: if FND_GLOBAL.Conc_Request_Id is not null then