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 427: FROM DUAL;

423: BEGIN
424:
425: SELECT MSC_ERRORS_S.NEXTVAL
426: INTO SEQ
427: FROM DUAL;
428:
429: IF fnd_global.conc_request_id > 0 THEN
430:
431: FND_FILE.PUT_LINE( FND_FILE.LOG,

Line 467: FROM DUAL;

463: BEGIN
464:
465: SELECT MSC_ERRORS_S.NEXTVAL
466: INTO SEQ
467: FROM DUAL;
468:
469: IF fnd_global.conc_request_id > 0 THEN
470:
471: FND_FILE.PUT_LINE( FND_FILE.LOG,

Line 1032: FROM DUAL;

1028: WHERE INSTANCE_ID= pINSTANCE_ID;
1029:
1030: SELECT MSC_COLLECTION_S.CURRVAL
1031: INTO v_last_collection_id
1032: FROM DUAL;
1033:
1034: RETURN TRUE;
1035:
1036: END IF;

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

3720: EXIT WHEN is_request_status_running <> MSC_UTIL.SYS_YES;
3721:
3722: -- ============= Check the execution time ==============
3723:
3724: select (SYSDATE- START_TIME) into lv_process_time from dual;
3725: IF lv_process_time > pTIMEOUT/1440.0 THEN Raise EX_PROCESS_TIME_OUT;
3726: END IF;
3727:
3728: -- ============= Get the Task from Task Que ==============

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

4732: END IF;
4733:
4734: -- ============= Check the execution time ==============
4735:
4736: select (SYSDATE- START_TIME) into lv_process_time from dual;
4737:
4738: IF lv_process_time > pTIMEOUT/1440.0 THEN Raise EX_PROCESS_TIME_OUT;
4739: END IF;
4740:

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

4854: ELSIF lv_pipe_ret_code<> 1 THEN
4855: RAISE EX_PIPE_RCV; -- If the error is not time-out error
4856: END IF;
4857:
4858: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;
4859: --EXIT WHEN lv_process_time > 10.0/1440.0; -- wait for 10 minutes
4860: IF ( lv_process_time > 3.0/1440.0) AND (lv_worker_committed <> pTotalWorkerNum) THEN
4861: EXIT WHEN all_workers_completed(lvs_request_id) = MSC_UTIL.SYS_YES;
4862: END IF;

Line 5012: FROM DUAL;

5008: IF (pPURGE_SH = MSC_UTIL.SYS_YES) THEN
5009:
5010: SELECT DECODE(nvl(FND_PROFILE.VALUE('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
5011: INTO lv_delete_flag
5012: FROM DUAL;
5013: -- If the above profile option is set then we are assuming that there is only one source
5014: -- So we can safely truncate the msc_sourcing_history table to improve performance
5015: IF (lv_delete_flag = 2) THEN
5016: DELETE MSC_SOURCING_HISTORY

Line 5145: FROM dual;

5141: CLOSE c_query_package;
5142: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
5143: SELECT nvl(fnd_profile.value('INV_CTP'),-10)
5144: INTO lv_inv_ctp
5145: FROM dual;
5146:
5147: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
5148: SELECT decode(nvl(fnd_profile.value('MSC_ENABLE_ATP_SUMMARY'),'N'),'Y',1,2)
5149: INTO lv_MSC_ENABLE_ATP_SUMMARY

Line 5150: FROM dual;

5146:
5147: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
5148: SELECT decode(nvl(fnd_profile.value('MSC_ENABLE_ATP_SUMMARY'),'N'),'Y',1,2)
5149: INTO lv_MSC_ENABLE_ATP_SUMMARY
5150: FROM dual;
5151:
5152: EXCEPTION
5153: WHEN OTHERS THEN
5154: IF c_query_package%ISOPEN THEN CLOSE c_query_package; END IF;

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

6578: END IF;
6579:
6580: -- ============= Check the execution time ==============
6581:
6582: select (SYSDATE- START_TIME) into lv_process_time from dual;
6583:
6584: IF lv_process_time > pTIMEOUT/1440.0 THEN Raise EX_PROCESS_TIME_OUT;
6585: END IF;
6586:

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

6721: ELSIF lv_pipe_ret_code<> 1 THEN
6722: RAISE EX_PIPE_RCV; -- If the error is not time-out error
6723: END IF;
6724:
6725: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;
6726: --EXIT WHEN lv_process_time > 10.0/1440.0; -- wait for 10 minutes
6727:
6728: IF (lv_process_time > 3.0/1440.0) AND (lv_worker_committed <> pTotalWorkerNum) THEN
6729: EXIT WHEN all_workers_completed(lvs_request_id) = MSC_UTIL.SYS_YES;

Line 6976: FROM DUAL;

6972: IF pPURGE_SH = MSC_UTIL.SYS_YES THEN
6973:
6974: SELECT DECODE(nvl(FND_PROFILE.VALUE('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
6975: INTO lv_delete_flag
6976: FROM DUAL;
6977:
6978: IF (lv_delete_flag = 2) THEN
6979: DELETE MSC_SOURCING_HISTORY
6980: WHERE SR_INSTANCE_ID= v_instance_id;

Line 7099: FROM dual;

7095: CLOSE c_query_package;
7096: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
7097: SELECT nvl(fnd_profile.value('INV_CTP'),-10)
7098: INTO lv_inv_ctp
7099: FROM dual;
7100:
7101: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
7102: SELECT decode(nvl(fnd_profile.value('MSC_ENABLE_ATP_SUMMARY'),'N'),'Y',1,2)
7103: INTO lv_MSC_ENABLE_ATP_SUMMARY

Line 7104: FROM dual;

7100:
7101: /* CHECK TO SEE IF THE ATP PROFILE INV_CTP is set to 5 */
7102: SELECT decode(nvl(fnd_profile.value('MSC_ENABLE_ATP_SUMMARY'),'N'),'Y',1,2)
7103: INTO lv_MSC_ENABLE_ATP_SUMMARY
7104: FROM dual;
7105: EXCEPTION
7106: WHEN OTHERS THEN
7107: IF c_query_package%ISOPEN THEN CLOSE c_query_package; END IF;
7108: lv_atp_package_exists := 2;