[Home] [Help]
572: FND_GLOBAL.APPLICATION_NAME
573: INTO lv_user_name,
574: lv_resp_name,
575: lv_application_name
576: FROM dual;
577:
578: SELECT APPLICATION_ID
579: INTO lv_application_id
580: FROM FND_APPLICATION_VL
626: FND_GLOBAL.APPLICATION_NAME
627: INTO lv_user_name,
628: lv_resp_name,
629: lv_application_name
630: FROM dual;
631: */
632:
633: lv_user_name := FND_GLOBAL.USER_NAME;
634: lv_resp_name := FND_GLOBAL.RESP_NAME;
644: MSC_UTIL.G_INCREMENTAL, 'I',
645: MSC_UTIL.G_PARTIAL, 'P',
646: MSC_UTIL.G_CONT, 'T')
647: INTO lv_refresh_type
648: FROM DUAL;
649: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' before calling MRP_CL_REFRESH_SNAPSHOT.REFRESH_SNAPSHOT 1 ');
650: /* submit a (remote) request */
651: IF v_apps_ver >= MSC_UTIL.G_APPS115 THEN
652: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Application id: ' || lv_application_id);
1370: ||' TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MRP_DMD_PRIORITY_FLEX_NUM'')),'
1371: --for bug13562886,use the MSC_UTIL.MSC_NUMVAL() to filter the wrong value set in the profile.
1372: ||' MSC_UTIL.MSC_NUMVAL( FND_PROFILE.VALUE'||v_dblink||'(''MSC_FCST_PRIORITY_FLEX_NUM''))'
1373: --||' TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MSC_FCST_PRIORITY_FLEX_NUM''))'
1374: ||' FROM DUAL';
1375:
1376: ELSE
1377: v_sql_stmt:=
1378: 'SELECT USERENV(''LANG''),'
1416: ||' TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MRP_DMD_PRIORITY_FLEX_NUM'')),'
1417: --for bug13562886,use the MSC_UTIL.MSC_NUMVAL() to filter the wrong value set in the profile.
1418: --||' TO_NUMBER( FND_PROFILE.VALUE'||v_dblink||'(''MSC_FCST_PRIORITY_FLEX_NUM''))'
1419: ||' MSC_UTIL.MSC_NUMVAL( FND_PROFILE.VALUE'||v_dblink||'(''MSC_FCST_PRIORITY_FLEX_NUM''))'
1420: ||' FROM DUAL';
1421:
1422: END IF;
1423:
1424: EXECUTE IMMEDIATE v_sql_stmt
1457: BEGIN
1458:
1459: /*
1460: v_sql_stmt:=
1461: 'SELECT OE_INSTALL.Get_Active_Product'||v_dblink||' FROM DUAL';
1462:
1463: EXECUTE IMMEDIATE v_sql_stmt
1464: INTO lv_oe_install;
1465: */
1504: EXIT WHEN is_monitor_status_running <> MSC_UTIL.SYS_YES;
1505:
1506: EXIT WHEN is_request_status_running <> MSC_UTIL.SYS_YES;
1507:
1508: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;
1509: IF lv_process_time > pTIMEOUT/1440.0 THEN RAISE EX_PROCESS_TIME_OUT;
1510: END IF;
1511:
1512: -- Get the Task Number ----------------------
2267: END IF;
2268:
2269: If pRTYPE = MSC_UTIL.G_COMPLETE Then
2270: IF v_apps_ver >= MSC_UTIL.G_APPS115 Then
2271: 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' || ' ) '
2272: || ' where instance_id = ' || pINSTANCE_ID ;
2273: ELSE
2274: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = 2 '
2275: || ' where instance_id = ' || pINSTANCE_ID ;
2350: IF (v_req_data is null) THEN -- for the fix 2351297
2351:
2352: BEGIN
2353: v_sql_stmt:=
2354: 'SELECT PJM_UNIT_EFF.ENABLED'||v_dblink || ' FROM DUAL';
2355:
2356: EXECUTE IMMEDIATE v_sql_stmt
2357: INTO lv_pjm_enabled;
2358: EXCEPTION
3024: END IF; -- CP_ENABLED;
3025: -- Updating the timestamp of pullworker
3026: BEGIN -- For Bug 6126924
3027: v_sql_stmt:=
3028: 'SELECT sysdate FROM DUAL'||v_dblink;
3029:
3030: EXECUTE IMMEDIATE v_sql_stmt INTO lv_src_time;
3031:
3032: UPDATE msc_coll_parameters
3160: END IF;
3161:
3162: -- ============= Check the execution time ==============
3163:
3164: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;
3165:
3166: IF lv_process_time > pTIMEOUT/1440.0 THEN RAISE EX_PROCESS_TIME_OUT;
3167: END IF;
3168:
3299: ELSIF lv_pipe_ret_code<> 1 THEN
3300: RAISE EX_PIPE_RCV; -- If the error is not time-out error
3301: END IF;
3302:
3303: SELECT (SYSDATE- lv_start_time) INTO lv_process_time FROM dual;
3304: -- For bug:2210970 Removed this exit and added the function all_workers_completed to exit
3305: -- EXIT WHEN lv_process_time > 3.0/1440.0;
3306:
3307: IF (lv_process_time > 3.0/1440.0) AND (lv_worker_committed <> pTotalWorkerNum) THEN
4423: BEGIN
4424:
4425: Select MSC_CL_REFRESH_S.NEXTVAL
4426: into pREFRESH_ID
4427: from dual;
4428:
4429: pTOTAL_TASK_NUMBER := TOTAL_TASK_NUMBER;
4430:
4431: END INITIALIZE;
5143: lv_nra_enabled_r11 := 0;
5144: /*
5145: select decode(NRA_ENABLED,1,1,2,0,3,1,0)
5146: into lv_nra_enabled_r11
5147: from dual;
5148: */
5149: END IF;
5150: SELECT DECODE( M2A_DBLINK,
5151: NULL, ' ',
5179: SELECT decode(NVL(FND_PROFILE.VALUE('MSC_COLLECT_COMPLETED_JOBS'),'Y'),
5180: 'Y', 1,
5181: 2)
5182: INTO v_collect_completed_jobs
5183: FROM DUAL;
5184:
5185: /* this feature is not supported yet, so set to 0 as default */
5186: v_dgmt:= 0;
5187: