eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_COLLECTION dependencies on DUAL

Line 419: FROM DUAL;

415: BEGIN
416:
417: SELECT MSC_ERRORS_S.NEXTVAL
418: INTO SEQ
419: FROM DUAL;
420:
421: IF fnd_global.conc_request_id > 0 THEN
422:
423: FND_FILE.PUT_LINE( FND_FILE.LOG,

Line 459: FROM DUAL;

455: BEGIN
456:
457: SELECT MSC_ERRORS_S.NEXTVAL
458: INTO SEQ
459: FROM DUAL;
460:
461: IF fnd_global.conc_request_id > 0 THEN
462:
463: FND_FILE.PUT_LINE( FND_FILE.LOG,

Line 1024: FROM DUAL;

1020: WHERE INSTANCE_ID= pINSTANCE_ID;
1021:
1022: SELECT MSC_COLLECTION_S.CURRVAL
1023: INTO v_last_collection_id
1024: FROM DUAL;
1025:
1026: RETURN TRUE;
1027:
1028: END IF;

Line 3127: select (SYSDATE- START_TIME) into lv_process_time from dual;

3123: EXIT WHEN is_request_status_running <> MSC_UTIL.SYS_YES;
3124:
3125: -- ============= Check the execution time ==============
3126:
3127: select (SYSDATE- START_TIME) into lv_process_time from dual;
3128: IF lv_process_time > pTIMEOUT/1440.0 THEN Raise EX_PROCESS_TIME_OUT;
3129: END IF;
3130:
3131: -- ============= Get the Task from Task Que ==============

Line 4110: select (SYSDATE- START_TIME) into lv_process_time from dual;

4106: END IF;
4107:
4108: -- ============= Check the execution time ==============
4109:
4110: select (SYSDATE- START_TIME) into lv_process_time from dual;
4111:
4112: IF lv_process_time > pTIMEOUT/1440.0 THEN Raise EX_PROCESS_TIME_OUT;
4113: END IF;
4114:

Line 4232: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;

4228: ELSIF lv_pipe_ret_code<> 1 THEN
4229: RAISE EX_PIPE_RCV; -- If the error is not time-out error
4230: END IF;
4231:
4232: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;
4233: --EXIT WHEN lv_process_time > 10.0/1440.0; -- wait for 10 minutes
4234: IF ( lv_process_time > 3.0/1440.0) AND (lv_worker_committed <> pTotalWorkerNum) THEN
4235: EXIT WHEN all_workers_completed(lvs_request_id) = MSC_UTIL.SYS_YES;
4236: END IF;

Line 4358: FROM DUAL;

4354: IF (pPURGE_SH = MSC_UTIL.SYS_YES) THEN
4355:
4356: SELECT DECODE(nvl(FND_PROFILE.VALUE('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
4357: INTO lv_delete_flag
4358: FROM DUAL;
4359: -- If the above profile option is set then we are assuming that there is only one source
4360: -- So we can safely truncate the msc_sourcing_history table to improve performance
4361: IF (lv_delete_flag = 2) THEN
4362: DELETE MSC_SOURCING_HISTORY

Line 4491: FROM dual;

4487: CLOSE c_query_package;
4488: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
4489: SELECT nvl(fnd_profile.value('INV_CTP'),-10)
4490: INTO lv_inv_ctp
4491: FROM dual;
4492:
4493: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
4494: SELECT decode(nvl(fnd_profile.value('MSC_ENABLE_ATP_SUMMARY'),'N'),'Y',1,2)
4495: INTO lv_MSC_ENABLE_ATP_SUMMARY

Line 4496: FROM dual;

4492:
4493: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
4494: SELECT decode(nvl(fnd_profile.value('MSC_ENABLE_ATP_SUMMARY'),'N'),'Y',1,2)
4495: INTO lv_MSC_ENABLE_ATP_SUMMARY
4496: FROM dual;
4497:
4498: EXCEPTION
4499: WHEN OTHERS THEN
4500: IF c_query_package%ISOPEN THEN CLOSE c_query_package; END IF;

Line 5793: select (SYSDATE- START_TIME) into lv_process_time from dual;

5789: END IF;
5790:
5791: -- ============= Check the execution time ==============
5792:
5793: select (SYSDATE- START_TIME) into lv_process_time from dual;
5794:
5795: IF lv_process_time > pTIMEOUT/1440.0 THEN Raise EX_PROCESS_TIME_OUT;
5796: END IF;
5797:

Line 5929: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;

5925: ELSIF lv_pipe_ret_code<> 1 THEN
5926: RAISE EX_PIPE_RCV; -- If the error is not time-out error
5927: END IF;
5928:
5929: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;
5930: --EXIT WHEN lv_process_time > 10.0/1440.0; -- wait for 10 minutes
5931:
5932: IF (lv_process_time > 3.0/1440.0) AND (lv_worker_committed <> pTotalWorkerNum) THEN
5933: EXIT WHEN all_workers_completed(lvs_request_id) = MSC_UTIL.SYS_YES;

Line 6140: FROM DUAL;

6136: IF pPURGE_SH = MSC_UTIL.SYS_YES THEN
6137:
6138: SELECT DECODE(nvl(FND_PROFILE.VALUE('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
6139: INTO lv_delete_flag
6140: FROM DUAL;
6141:
6142: IF (lv_delete_flag = 2) THEN
6143: DELETE MSC_SOURCING_HISTORY
6144: WHERE SR_INSTANCE_ID= v_instance_id;

Line 6262: FROM dual;

6258: CLOSE c_query_package;
6259: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
6260: SELECT nvl(fnd_profile.value('INV_CTP'),-10)
6261: INTO lv_inv_ctp
6262: FROM dual;
6263:
6264: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
6265: SELECT decode(nvl(fnd_profile.value('MSC_ENABLE_ATP_SUMMARY'),'N'),'Y',1,2)
6266: INTO lv_MSC_ENABLE_ATP_SUMMARY

Line 6267: FROM dual;

6263:
6264: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
6265: SELECT decode(nvl(fnd_profile.value('MSC_ENABLE_ATP_SUMMARY'),'N'),'Y',1,2)
6266: INTO lv_MSC_ENABLE_ATP_SUMMARY
6267: FROM dual;
6268: EXCEPTION
6269: WHEN OTHERS THEN
6270: IF c_query_package%ISOPEN THEN CLOSE c_query_package; END IF;
6271: lv_atp_package_exists := 2;