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_PULL dependencies on DUAL

Line 572: FROM dual;

568: FND_GLOBAL.APPLICATION_NAME
569: INTO lv_user_name,
570: lv_resp_name,
571: lv_application_name
572: FROM dual;
573:
574: SELECT APPLICATION_ID
575: INTO lv_application_id
576: FROM FND_APPLICATION_VL

Line 626: FROM dual;

622: FND_GLOBAL.APPLICATION_NAME
623: INTO lv_user_name,
624: lv_resp_name,
625: lv_application_name
626: FROM dual;
627: */
628:
629: lv_user_name := FND_GLOBAL.USER_NAME;
630: lv_resp_name := FND_GLOBAL.RESP_NAME;

Line 644: FROM DUAL;

640: MSC_UTIL.G_INCREMENTAL, 'I',
641: MSC_UTIL.G_PARTIAL, 'P',
642: MSC_UTIL.G_CONT, 'T')
643: INTO lv_refresh_type
644: FROM DUAL;
645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' before calling MRP_CL_REFRESH_SNAPSHOT.REFRESH_SNAPSHOT 1 ');
646: /* submit a (remote) request */
647: IF v_apps_ver >= MSC_UTIL.G_APPS115 THEN
648: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Application id: ' || lv_application_id);

Line 1342: ||' FROM DUAL';

1338: ||' NVL(TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MRP_BIS_AV_DISCOUNT'')),0),'
1339: ||' TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MRP_BIS_PRICE_LIST'')),'
1340: ||' TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MRP_DMD_PRIORITY_FLEX_NUM'')),'
1341: ||' TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MSC_FCST_PRIORITY_FLEX_NUM''))'
1342: ||' FROM DUAL';
1343:
1344: ELSE
1345: v_sql_stmt:=
1346: 'SELECT USERENV(''LANG''),'

Line 1386: ||' FROM DUAL';

1382: ||' NVL(TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MRP_BIS_AV_DISCOUNT'')),0),'
1383: ||' TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MRP_BIS_PRICE_LIST'')),'
1384: ||' TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MRP_DMD_PRIORITY_FLEX_NUM'')),'
1385: ||' TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MRP_FCST_PRIORITY_FLEX_NUM''))'
1386: ||' FROM DUAL';
1387:
1388: END IF;
1389:
1390: EXECUTE IMMEDIATE v_sql_stmt

Line 1427: 'SELECT OE_INSTALL.Get_Active_Product'||v_dblink||' FROM DUAL';

1423: BEGIN
1424:
1425: /*
1426: v_sql_stmt:=
1427: 'SELECT OE_INSTALL.Get_Active_Product'||v_dblink||' FROM DUAL';
1428:
1429: EXECUTE IMMEDIATE v_sql_stmt
1430: INTO lv_oe_install;
1431: */

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

1470: EXIT WHEN is_monitor_status_running <> MSC_UTIL.SYS_YES;
1471:
1472: EXIT WHEN is_request_status_running <> MSC_UTIL.SYS_YES;
1473:
1474: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;
1475: IF lv_process_time > pTIMEOUT/1440.0 THEN RAISE EX_PROCESS_TIME_OUT;
1476: END IF;
1477:
1478: -- Get the Task Number ----------------------

Line 2125: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = (select decode(to_number(FND_PROFILE.VALUE' || v_dblink || '(''WSM_CREATE_LBJ_COPY_ROUTING'')),1,1,2) from dual' || ' ) '

2121: END IF;
2122:
2123: If pRTYPE = MSC_UTIL.G_COMPLETE Then
2124: IF v_apps_ver >= MSC_UTIL.G_APPS115 Then
2125: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = (select decode(to_number(FND_PROFILE.VALUE' || v_dblink || '(''WSM_CREATE_LBJ_COPY_ROUTING'')),1,1,2) from dual' || ' ) '
2126: || ' where instance_id = ' || pINSTANCE_ID ;
2127: ELSE
2128: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = 2 '
2129: || ' where instance_id = ' || pINSTANCE_ID ;

Line 2208: 'SELECT PJM_UNIT_EFF.ENABLED'||v_dblink || ' FROM DUAL';

2204: IF (v_req_data is null) THEN -- for the fix 2351297
2205:
2206: BEGIN
2207: v_sql_stmt:=
2208: 'SELECT PJM_UNIT_EFF.ENABLED'||v_dblink || ' FROM DUAL';
2209:
2210: EXECUTE IMMEDIATE v_sql_stmt
2211: INTO lv_pjm_enabled;
2212: EXCEPTION

Line 2872: 'SELECT sysdate FROM DUAL'||v_dblink;

2868: END IF; -- CP_ENABLED;
2869: -- Updating the timestamp of pullworker
2870: BEGIN -- For Bug 6126924
2871: v_sql_stmt:=
2872: 'SELECT sysdate FROM DUAL'||v_dblink;
2873:
2874: EXECUTE IMMEDIATE v_sql_stmt INTO lv_src_time;
2875:
2876: UPDATE msc_coll_parameters

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

3004: END IF;
3005:
3006: -- ============= Check the execution time ==============
3007:
3008: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;
3009:
3010: IF lv_process_time > pTIMEOUT/1440.0 THEN RAISE EX_PROCESS_TIME_OUT;
3011: END IF;
3012:

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

3143: ELSIF lv_pipe_ret_code<> 1 THEN
3144: RAISE EX_PIPE_RCV; -- If the error is not time-out error
3145: END IF;
3146:
3147: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;
3148: -- For bug:2210970 Removed this exit and added the function all_workers_completed to exit
3149: -- EXIT WHEN lv_process_time > 3.0/1440.0;
3150:
3151: IF (lv_process_time > 3.0/1440.0) AND (lv_worker_committed <> pTotalWorkerNum) THEN

Line 4270: from dual;

4266: BEGIN
4267:
4268: Select MSC_CL_REFRESH_S.NEXTVAL
4269: into pREFRESH_ID
4270: from dual;
4271:
4272: pTOTAL_TASK_NUMBER := TOTAL_TASK_NUMBER;
4273:
4274: END INITIALIZE;

Line 4936: from dual;

4932: lv_nra_enabled_r11 := 0;
4933: /*
4934: select decode(NRA_ENABLED,1,1,2,0,3,1,0)
4935: into lv_nra_enabled_r11
4936: from dual;
4937: */
4938: END IF;
4939: SELECT DECODE( M2A_DBLINK,
4940: NULL, ' ',

Line 4972: FROM DUAL;

4968: SELECT decode(NVL(FND_PROFILE.VALUE('MSC_COLLECT_COMPLETED_JOBS'),'Y'),
4969: 'Y', 1,
4970: 2)
4971: INTO v_collect_completed_jobs
4972: FROM DUAL;
4973:
4974: /* this feature is not supported yet, so set to 0 as default */
4975: v_dgmt:= 0;
4976: