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)
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;
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:
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
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