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.MRP_CL_REFRESH_SNAPSHOT dependencies on FND_PROFILE

Line 205: lv_sql_stmt:= 'select NVL(FND_PROFILE.VALUE'||v_a2m_dblink||'(''MSC_SRP_ENABLED''),''N'')'

201: if lv_out = 2 THEN lv_success := FALSE ; end if;
202: end if;
203:
204: if lv_success THEN
205: lv_sql_stmt:= 'select NVL(FND_PROFILE.VALUE'||v_a2m_dblink||'(''MSC_SRP_ENABLED''),''N'')'
206: || ' from dual ';
207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_sql_stmt);
208: execute immediate lv_sql_stmt into lv_srp_enabled_flag ;
209: IF lv_srp_enabled_flag='Y' THEN

Line 448: UPDATE FND_PROFILE_OPTION_VALUES

444: begin
445: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Updating Profile Option MSC_SOURCE_SETUP to No ');
446: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Region Site Mapping not being called here ');
447:
448: UPDATE FND_PROFILE_OPTION_VALUES
449: SET PROFILE_OPTION_VALUE = 'N'
450: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
451: FROM FND_PROFILE_OPTIONS
452: WHERE PROFILE_OPTION_NAME = 'MSC_SOURCE_SETUP');

Line 451: FROM FND_PROFILE_OPTIONS

447:
448: UPDATE FND_PROFILE_OPTION_VALUES
449: SET PROFILE_OPTION_VALUE = 'N'
450: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
451: FROM FND_PROFILE_OPTIONS
452: WHERE PROFILE_OPTION_NAME = 'MSC_SOURCE_SETUP');
453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Profile Option MSC_SOURCE_SETUP has been updated No ');
454: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Value No indicates that the Collection Setup Objects have been applied');
455: COMMIT;

Line 1027: lv_snapshot_threshold NUMBER := NVL(FND_PROFILE.VALUE('MSC_SNAPSHOT_THRESHOLD'),40);

1023: lv_where_clause VARCHAR2(2000) := NULL;
1024: lv_mlog_tab_name VARCHAR2(48);
1025: lv_master_tbl VARCHAR2(48);
1026: lv_base_schema VARCHAR2(48);
1027: lv_snapshot_threshold NUMBER := NVL(FND_PROFILE.VALUE('MSC_SNAPSHOT_THRESHOLD'),40);
1028:
1029: BEGIN
1030: /*
1031: IF (p_snapshot = 'MTL_MTRX_TMP_SN') OR (p_snapshot = 'WIP_FLOW_SCHDS_SN') OR

Line 1672: lv_sql_stmt:= 'select NVL(FND_PROFILE.VALUE'||v_a2m_dblink

1668: lv_sql_stmt VARCHAR2(300);
1669: lv_usaf_prof_flag NUMBER;
1670: BEGIN
1671:
1672: lv_sql_stmt:= 'select NVL(FND_PROFILE.VALUE'||v_a2m_dblink
1673: ||'(''MSC_ASCP_IGNORE_CMRO_EAM_WO''),1)'
1674: || ' from dual ';
1675:
1676: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_sql_stmt);

Line 2014: lv_sql_stmt:= 'select FND_PROFILE.VALUE'||v_dblink||'(''MSC_COLL_TIME_WINDOW_IBUC_HISTORY'') '

2010:
2011:
2012: EXECUTE IMMEDIATE lv_sql_stmt
2013: INTO v_apps_lrn, v_last_IBUC_coll_date ;
2014: lv_sql_stmt:= 'select FND_PROFILE.VALUE'||v_dblink||'(''MSC_COLL_TIME_WINDOW_IBUC_HISTORY'') '
2015: || ' from dual ';
2016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_sql_stmt);
2017: execute immediate lv_sql_stmt into v_window ;
2018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Value of the Time Window Profile ' ||v_window);

Line 2033: SELECT DECODE(NVL(fnd_profile.value('MSC_SOURCE_SETUP') ,'Y'), 'Y',1 ,2)

2029:
2030: /* NEW Patching Strategy */
2031: /* Based on the profile option setting MSC_SOURCE_SETUP Setup the Source Objects */
2032:
2033: SELECT DECODE(NVL(fnd_profile.value('MSC_SOURCE_SETUP') ,'Y'), 'Y',1 ,2)
2034: INTO lv_setup_source_objs
2035: FROM DUAL;
2036:
2037: IF (lv_setup_source_objs = 1) THEN

Line 2414: ||' BOM_HOUR_UOM_CODE =FND_PROFILE.VALUE(''BOM:HOUR_UOM_CODE''),'

2410: -- Resource Start Time. This time will be updated before the snapshot refresh.
2411: -- LRD= SYSDATE,
2412: ||' LAST_UPDATE_DATE= SYSDATE,'
2413: ||' LAST_UPDATED_BY= FND_GLOBAL.USER_ID,'
2414: ||' BOM_HOUR_UOM_CODE =FND_PROFILE.VALUE(''BOM:HOUR_UOM_CODE''),'
2415: ||' MRP_MPS_CONSUMPTION =DECODE( FND_PROFILE.VALUE(''MRP_MPS_CONSUMPTION''),'
2416: ||' ''Y'', 1,'
2417: ||' ''1'', 1,'
2418: ||' 2),'

Line 2415: ||' MRP_MPS_CONSUMPTION =DECODE( FND_PROFILE.VALUE(''MRP_MPS_CONSUMPTION''),'

2411: -- LRD= SYSDATE,
2412: ||' LAST_UPDATE_DATE= SYSDATE,'
2413: ||' LAST_UPDATED_BY= FND_GLOBAL.USER_ID,'
2414: ||' BOM_HOUR_UOM_CODE =FND_PROFILE.VALUE(''BOM:HOUR_UOM_CODE''),'
2415: ||' MRP_MPS_CONSUMPTION =DECODE( FND_PROFILE.VALUE(''MRP_MPS_CONSUMPTION''),'
2416: ||' ''Y'', 1,'
2417: ||' ''1'', 1,'
2418: ||' 2),'
2419: ||' MRP_SHIP_ARRIVE_FLAG =DECODE( FND_PROFILE.VALUE(''MRP_SHIP_ARRIVE_FLAG''),'

Line 2419: ||' MRP_SHIP_ARRIVE_FLAG =DECODE( FND_PROFILE.VALUE(''MRP_SHIP_ARRIVE_FLAG''),'

2415: ||' MRP_MPS_CONSUMPTION =DECODE( FND_PROFILE.VALUE(''MRP_MPS_CONSUMPTION''),'
2416: ||' ''Y'', 1,'
2417: ||' ''1'', 1,'
2418: ||' 2),'
2419: ||' MRP_SHIP_ARRIVE_FLAG =DECODE( FND_PROFILE.VALUE(''MRP_SHIP_ARRIVE_FLAG''),'
2420: ||' ''Y'', 1,'
2421: ||' ''1'', 1,'
2422: ||' 2),'
2423: ||' CRP_SPREAD_LOAD =DECODE( FND_PROFILE.VALUE(''CRP_SPREAD_LOAD''),'

Line 2423: ||' CRP_SPREAD_LOAD =DECODE( FND_PROFILE.VALUE(''CRP_SPREAD_LOAD''),'

2419: ||' MRP_SHIP_ARRIVE_FLAG =DECODE( FND_PROFILE.VALUE(''MRP_SHIP_ARRIVE_FLAG''),'
2420: ||' ''Y'', 1,'
2421: ||' ''1'', 1,'
2422: ||' 2),'
2423: ||' CRP_SPREAD_LOAD =DECODE( FND_PROFILE.VALUE(''CRP_SPREAD_LOAD''),'
2424: ||' ''Y'', 1,'
2425: ||' ''1'', 1,'
2426: ||' 2),'
2427: ||' MSO_ITEM_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_DMD_PENALTY'')),'

Line 2427: ||' MSO_ITEM_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_DMD_PENALTY'')),'

2423: ||' CRP_SPREAD_LOAD =DECODE( FND_PROFILE.VALUE(''CRP_SPREAD_LOAD''),'
2424: ||' ''Y'', 1,'
2425: ||' ''1'', 1,'
2426: ||' 2),'
2427: ||' MSO_ITEM_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_DMD_PENALTY'')),'
2428: ||' MSO_ITEM_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_CAP_PENALTY'')),'
2429: ||' MSO_ORG_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_DMD_PENALTY'')),'
2430: ||' MSO_ORG_ITEM_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_ITEM_PENALTY'')),'
2431: ||' MSO_ORG_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_RES_PENALTY'')),'

Line 2428: ||' MSO_ITEM_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_CAP_PENALTY'')),'

2424: ||' ''Y'', 1,'
2425: ||' ''1'', 1,'
2426: ||' 2),'
2427: ||' MSO_ITEM_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_DMD_PENALTY'')),'
2428: ||' MSO_ITEM_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_CAP_PENALTY'')),'
2429: ||' MSO_ORG_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_DMD_PENALTY'')),'
2430: ||' MSO_ORG_ITEM_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_ITEM_PENALTY'')),'
2431: ||' MSO_ORG_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_RES_PENALTY'')),'
2432: ||' MSO_ORG_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_TRSP_PENALTY'')),'

Line 2429: ||' MSO_ORG_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_DMD_PENALTY'')),'

2425: ||' ''1'', 1,'
2426: ||' 2),'
2427: ||' MSO_ITEM_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_DMD_PENALTY'')),'
2428: ||' MSO_ITEM_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_CAP_PENALTY'')),'
2429: ||' MSO_ORG_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_DMD_PENALTY'')),'
2430: ||' MSO_ORG_ITEM_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_ITEM_PENALTY'')),'
2431: ||' MSO_ORG_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_RES_PENALTY'')),'
2432: ||' MSO_ORG_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_TRSP_PENALTY'')),'
2433: ||' MSC_AGGREG_RES_NAME =TO_NUMBER( FND_PROFILE.VALUE(''MSC_AGGREG_RES_NAME'')),'

Line 2430: ||' MSO_ORG_ITEM_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_ITEM_PENALTY'')),'

2426: ||' 2),'
2427: ||' MSO_ITEM_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_DMD_PENALTY'')),'
2428: ||' MSO_ITEM_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_CAP_PENALTY'')),'
2429: ||' MSO_ORG_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_DMD_PENALTY'')),'
2430: ||' MSO_ORG_ITEM_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_ITEM_PENALTY'')),'
2431: ||' MSO_ORG_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_RES_PENALTY'')),'
2432: ||' MSO_ORG_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_TRSP_PENALTY'')),'
2433: ||' MSC_AGGREG_RES_NAME =TO_NUMBER( FND_PROFILE.VALUE(''MSC_AGGREG_RES_NAME'')),'
2434: ||' MSO_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_RES_PENALTY'')),'

Line 2431: ||' MSO_ORG_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_RES_PENALTY'')),'

2427: ||' MSO_ITEM_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_DMD_PENALTY'')),'
2428: ||' MSO_ITEM_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_CAP_PENALTY'')),'
2429: ||' MSO_ORG_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_DMD_PENALTY'')),'
2430: ||' MSO_ORG_ITEM_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_ITEM_PENALTY'')),'
2431: ||' MSO_ORG_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_RES_PENALTY'')),'
2432: ||' MSO_ORG_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_TRSP_PENALTY'')),'
2433: ||' MSC_AGGREG_RES_NAME =TO_NUMBER( FND_PROFILE.VALUE(''MSC_AGGREG_RES_NAME'')),'
2434: ||' MSO_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_RES_PENALTY'')),'
2435: ||' MSO_SUP_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SUP_CAP_PENALTY'')),'

Line 2432: ||' MSO_ORG_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_TRSP_PENALTY'')),'

2428: ||' MSO_ITEM_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ITEM_CAP_PENALTY'')),'
2429: ||' MSO_ORG_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_DMD_PENALTY'')),'
2430: ||' MSO_ORG_ITEM_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_ITEM_PENALTY'')),'
2431: ||' MSO_ORG_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_RES_PENALTY'')),'
2432: ||' MSO_ORG_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_TRSP_PENALTY'')),'
2433: ||' MSC_AGGREG_RES_NAME =TO_NUMBER( FND_PROFILE.VALUE(''MSC_AGGREG_RES_NAME'')),'
2434: ||' MSO_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_RES_PENALTY'')),'
2435: ||' MSO_SUP_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SUP_CAP_PENALTY'')),'
2436: ||' MSC_BOM_SUBST_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BOM_SUBST_PRIORITY'')),'

Line 2433: ||' MSC_AGGREG_RES_NAME =TO_NUMBER( FND_PROFILE.VALUE(''MSC_AGGREG_RES_NAME'')),'

2429: ||' MSO_ORG_DMD_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_DMD_PENALTY'')),'
2430: ||' MSO_ORG_ITEM_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_ITEM_PENALTY'')),'
2431: ||' MSO_ORG_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_RES_PENALTY'')),'
2432: ||' MSO_ORG_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_TRSP_PENALTY'')),'
2433: ||' MSC_AGGREG_RES_NAME =TO_NUMBER( FND_PROFILE.VALUE(''MSC_AGGREG_RES_NAME'')),'
2434: ||' MSO_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_RES_PENALTY'')),'
2435: ||' MSO_SUP_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SUP_CAP_PENALTY'')),'
2436: ||' MSC_BOM_SUBST_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BOM_SUBST_PRIORITY'')),'
2437: ||' MSO_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_TRSP_PENALTY'')),'

Line 2434: ||' MSO_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_RES_PENALTY'')),'

2430: ||' MSO_ORG_ITEM_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_ITEM_PENALTY'')),'
2431: ||' MSO_ORG_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_RES_PENALTY'')),'
2432: ||' MSO_ORG_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_TRSP_PENALTY'')),'
2433: ||' MSC_AGGREG_RES_NAME =TO_NUMBER( FND_PROFILE.VALUE(''MSC_AGGREG_RES_NAME'')),'
2434: ||' MSO_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_RES_PENALTY'')),'
2435: ||' MSO_SUP_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SUP_CAP_PENALTY'')),'
2436: ||' MSC_BOM_SUBST_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BOM_SUBST_PRIORITY'')),'
2437: ||' MSO_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_TRSP_PENALTY'')),'
2438: ||' MSC_ALT_BOM_COST =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_BOM_COST'')),'

Line 2435: ||' MSO_SUP_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SUP_CAP_PENALTY'')),'

2431: ||' MSO_ORG_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_RES_PENALTY'')),'
2432: ||' MSO_ORG_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_TRSP_PENALTY'')),'
2433: ||' MSC_AGGREG_RES_NAME =TO_NUMBER( FND_PROFILE.VALUE(''MSC_AGGREG_RES_NAME'')),'
2434: ||' MSO_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_RES_PENALTY'')),'
2435: ||' MSO_SUP_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SUP_CAP_PENALTY'')),'
2436: ||' MSC_BOM_SUBST_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BOM_SUBST_PRIORITY'')),'
2437: ||' MSO_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_TRSP_PENALTY'')),'
2438: ||' MSC_ALT_BOM_COST =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_BOM_COST'')),'
2439: ||' MSO_FCST_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_FCST_PENALTY'')),'

Line 2436: ||' MSC_BOM_SUBST_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BOM_SUBST_PRIORITY'')),'

2432: ||' MSO_ORG_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_ORG_TRSP_PENALTY'')),'
2433: ||' MSC_AGGREG_RES_NAME =TO_NUMBER( FND_PROFILE.VALUE(''MSC_AGGREG_RES_NAME'')),'
2434: ||' MSO_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_RES_PENALTY'')),'
2435: ||' MSO_SUP_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SUP_CAP_PENALTY'')),'
2436: ||' MSC_BOM_SUBST_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BOM_SUBST_PRIORITY'')),'
2437: ||' MSO_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_TRSP_PENALTY'')),'
2438: ||' MSC_ALT_BOM_COST =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_BOM_COST'')),'
2439: ||' MSO_FCST_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_FCST_PENALTY'')),'
2440: ||' MSO_SO_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SO_PENALTY'')),'

Line 2437: ||' MSO_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_TRSP_PENALTY'')),'

2433: ||' MSC_AGGREG_RES_NAME =TO_NUMBER( FND_PROFILE.VALUE(''MSC_AGGREG_RES_NAME'')),'
2434: ||' MSO_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_RES_PENALTY'')),'
2435: ||' MSO_SUP_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SUP_CAP_PENALTY'')),'
2436: ||' MSC_BOM_SUBST_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BOM_SUBST_PRIORITY'')),'
2437: ||' MSO_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_TRSP_PENALTY'')),'
2438: ||' MSC_ALT_BOM_COST =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_BOM_COST'')),'
2439: ||' MSO_FCST_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_FCST_PENALTY'')),'
2440: ||' MSO_SO_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SO_PENALTY'')),'
2441: -- MSC_ALT_OP_RES =TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),

Line 2438: ||' MSC_ALT_BOM_COST =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_BOM_COST'')),'

2434: ||' MSO_RES_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_RES_PENALTY'')),'
2435: ||' MSO_SUP_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SUP_CAP_PENALTY'')),'
2436: ||' MSC_BOM_SUBST_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BOM_SUBST_PRIORITY'')),'
2437: ||' MSO_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_TRSP_PENALTY'')),'
2438: ||' MSC_ALT_BOM_COST =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_BOM_COST'')),'
2439: ||' MSO_FCST_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_FCST_PENALTY'')),'
2440: ||' MSO_SO_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SO_PENALTY'')),'
2441: -- MSC_ALT_OP_RES =TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
2442: ||' MSC_ALT_RES_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_RES_PRIORITY'')),'

Line 2439: ||' MSO_FCST_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_FCST_PENALTY'')),'

2435: ||' MSO_SUP_CAP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SUP_CAP_PENALTY'')),'
2436: ||' MSC_BOM_SUBST_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BOM_SUBST_PRIORITY'')),'
2437: ||' MSO_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_TRSP_PENALTY'')),'
2438: ||' MSC_ALT_BOM_COST =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_BOM_COST'')),'
2439: ||' MSO_FCST_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_FCST_PENALTY'')),'
2440: ||' MSO_SO_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SO_PENALTY'')),'
2441: -- MSC_ALT_OP_RES =TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
2442: ||' MSC_ALT_RES_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_RES_PRIORITY'')),'
2443: ||' MSC_SIMUL_RES_SEQ =TO_NUMBER( FND_PROFILE.VALUE(''MSC_SIMUL_RES_SEQ'')),'

Line 2440: ||' MSO_SO_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SO_PENALTY'')),'

2436: ||' MSC_BOM_SUBST_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BOM_SUBST_PRIORITY'')),'
2437: ||' MSO_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_TRSP_PENALTY'')),'
2438: ||' MSC_ALT_BOM_COST =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_BOM_COST'')),'
2439: ||' MSO_FCST_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_FCST_PENALTY'')),'
2440: ||' MSO_SO_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SO_PENALTY'')),'
2441: -- MSC_ALT_OP_RES =TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
2442: ||' MSC_ALT_RES_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_RES_PRIORITY'')),'
2443: ||' MSC_SIMUL_RES_SEQ =TO_NUMBER( FND_PROFILE.VALUE(''MSC_SIMUL_RES_SEQ'')),'
2444: ||' MRP_BIS_AV_DISCOUNT =NVL(TO_NUMBER(FND_PROFILE.VALUE(''MRP_BIS_AV_DISCOUNT'')),0),'

Line 2441: -- MSC_ALT_OP_RES =TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),

2437: ||' MSO_TRSP_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_TRSP_PENALTY'')),'
2438: ||' MSC_ALT_BOM_COST =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_BOM_COST'')),'
2439: ||' MSO_FCST_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_FCST_PENALTY'')),'
2440: ||' MSO_SO_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SO_PENALTY'')),'
2441: -- MSC_ALT_OP_RES =TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
2442: ||' MSC_ALT_RES_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_RES_PRIORITY'')),'
2443: ||' MSC_SIMUL_RES_SEQ =TO_NUMBER( FND_PROFILE.VALUE(''MSC_SIMUL_RES_SEQ'')),'
2444: ||' MRP_BIS_AV_DISCOUNT =NVL(TO_NUMBER(FND_PROFILE.VALUE(''MRP_BIS_AV_DISCOUNT'')),0),'
2445: ||' MRP_BIS_PRICE_LIST =TO_NUMBER( FND_PROFILE.VALUE(''MRP_BIS_PRICE_LIST'')),'

Line 2442: ||' MSC_ALT_RES_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_RES_PRIORITY'')),'

2438: ||' MSC_ALT_BOM_COST =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_BOM_COST'')),'
2439: ||' MSO_FCST_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_FCST_PENALTY'')),'
2440: ||' MSO_SO_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SO_PENALTY'')),'
2441: -- MSC_ALT_OP_RES =TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
2442: ||' MSC_ALT_RES_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_RES_PRIORITY'')),'
2443: ||' MSC_SIMUL_RES_SEQ =TO_NUMBER( FND_PROFILE.VALUE(''MSC_SIMUL_RES_SEQ'')),'
2444: ||' MRP_BIS_AV_DISCOUNT =NVL(TO_NUMBER(FND_PROFILE.VALUE(''MRP_BIS_AV_DISCOUNT'')),0),'
2445: ||' MRP_BIS_PRICE_LIST =TO_NUMBER( FND_PROFILE.VALUE(''MRP_BIS_PRICE_LIST'')),'
2446: ||' MSC_DMD_PRIORITY_FLEX_NUM=NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_DMD_PRIORITY_FLEX_NUM'')),0),'

Line 2443: ||' MSC_SIMUL_RES_SEQ =TO_NUMBER( FND_PROFILE.VALUE(''MSC_SIMUL_RES_SEQ'')),'

2439: ||' MSO_FCST_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_FCST_PENALTY'')),'
2440: ||' MSO_SO_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SO_PENALTY'')),'
2441: -- MSC_ALT_OP_RES =TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
2442: ||' MSC_ALT_RES_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_RES_PRIORITY'')),'
2443: ||' MSC_SIMUL_RES_SEQ =TO_NUMBER( FND_PROFILE.VALUE(''MSC_SIMUL_RES_SEQ'')),'
2444: ||' MRP_BIS_AV_DISCOUNT =NVL(TO_NUMBER(FND_PROFILE.VALUE(''MRP_BIS_AV_DISCOUNT'')),0),'
2445: ||' MRP_BIS_PRICE_LIST =TO_NUMBER( FND_PROFILE.VALUE(''MRP_BIS_PRICE_LIST'')),'
2446: ||' MSC_DMD_PRIORITY_FLEX_NUM=NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_DMD_PRIORITY_FLEX_NUM'')),0),'
2447: ||' MSC_BATCHABLE_FLAG =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHABLE_FLAG'')),'

Line 2444: ||' MRP_BIS_AV_DISCOUNT =NVL(TO_NUMBER(FND_PROFILE.VALUE(''MRP_BIS_AV_DISCOUNT'')),0),'

2440: ||' MSO_SO_PENALTY =TO_NUMBER( FND_PROFILE.VALUE(''MSO_SO_PENALTY'')),'
2441: -- MSC_ALT_OP_RES =TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
2442: ||' MSC_ALT_RES_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_RES_PRIORITY'')),'
2443: ||' MSC_SIMUL_RES_SEQ =TO_NUMBER( FND_PROFILE.VALUE(''MSC_SIMUL_RES_SEQ'')),'
2444: ||' MRP_BIS_AV_DISCOUNT =NVL(TO_NUMBER(FND_PROFILE.VALUE(''MRP_BIS_AV_DISCOUNT'')),0),'
2445: ||' MRP_BIS_PRICE_LIST =TO_NUMBER( FND_PROFILE.VALUE(''MRP_BIS_PRICE_LIST'')),'
2446: ||' MSC_DMD_PRIORITY_FLEX_NUM=NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_DMD_PRIORITY_FLEX_NUM'')),0),'
2447: ||' MSC_BATCHABLE_FLAG =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHABLE_FLAG'')),'
2448: ||' MSC_BATCHING_WINDOW =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHING_WINDOW'')),'

Line 2445: ||' MRP_BIS_PRICE_LIST =TO_NUMBER( FND_PROFILE.VALUE(''MRP_BIS_PRICE_LIST'')),'

2441: -- MSC_ALT_OP_RES =TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
2442: ||' MSC_ALT_RES_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_RES_PRIORITY'')),'
2443: ||' MSC_SIMUL_RES_SEQ =TO_NUMBER( FND_PROFILE.VALUE(''MSC_SIMUL_RES_SEQ'')),'
2444: ||' MRP_BIS_AV_DISCOUNT =NVL(TO_NUMBER(FND_PROFILE.VALUE(''MRP_BIS_AV_DISCOUNT'')),0),'
2445: ||' MRP_BIS_PRICE_LIST =TO_NUMBER( FND_PROFILE.VALUE(''MRP_BIS_PRICE_LIST'')),'
2446: ||' MSC_DMD_PRIORITY_FLEX_NUM=NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_DMD_PRIORITY_FLEX_NUM'')),0),'
2447: ||' MSC_BATCHABLE_FLAG =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHABLE_FLAG'')),'
2448: ||' MSC_BATCHING_WINDOW =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHING_WINDOW'')),'
2449: ||' MSC_MIN_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MIN_CAPACITY'')),'

Line 2446: ||' MSC_DMD_PRIORITY_FLEX_NUM=NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_DMD_PRIORITY_FLEX_NUM'')),0),'

2442: ||' MSC_ALT_RES_PRIORITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_ALT_RES_PRIORITY'')),'
2443: ||' MSC_SIMUL_RES_SEQ =TO_NUMBER( FND_PROFILE.VALUE(''MSC_SIMUL_RES_SEQ'')),'
2444: ||' MRP_BIS_AV_DISCOUNT =NVL(TO_NUMBER(FND_PROFILE.VALUE(''MRP_BIS_AV_DISCOUNT'')),0),'
2445: ||' MRP_BIS_PRICE_LIST =TO_NUMBER( FND_PROFILE.VALUE(''MRP_BIS_PRICE_LIST'')),'
2446: ||' MSC_DMD_PRIORITY_FLEX_NUM=NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_DMD_PRIORITY_FLEX_NUM'')),0),'
2447: ||' MSC_BATCHABLE_FLAG =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHABLE_FLAG'')),'
2448: ||' MSC_BATCHING_WINDOW =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHING_WINDOW'')),'
2449: ||' MSC_MIN_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MIN_CAPACITY'')),'
2450: ||' MSC_MAX_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MAX_CAPACITY'')),'

Line 2447: ||' MSC_BATCHABLE_FLAG =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHABLE_FLAG'')),'

2443: ||' MSC_SIMUL_RES_SEQ =TO_NUMBER( FND_PROFILE.VALUE(''MSC_SIMUL_RES_SEQ'')),'
2444: ||' MRP_BIS_AV_DISCOUNT =NVL(TO_NUMBER(FND_PROFILE.VALUE(''MRP_BIS_AV_DISCOUNT'')),0),'
2445: ||' MRP_BIS_PRICE_LIST =TO_NUMBER( FND_PROFILE.VALUE(''MRP_BIS_PRICE_LIST'')),'
2446: ||' MSC_DMD_PRIORITY_FLEX_NUM=NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_DMD_PRIORITY_FLEX_NUM'')),0),'
2447: ||' MSC_BATCHABLE_FLAG =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHABLE_FLAG'')),'
2448: ||' MSC_BATCHING_WINDOW =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHING_WINDOW'')),'
2449: ||' MSC_MIN_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MIN_CAPACITY'')),'
2450: ||' MSC_MAX_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MAX_CAPACITY'')),'
2451: ||' MSC_UNIT_OF_MEASURE =TO_NUMBER( FND_PROFILE.VALUE(''MSC_UNIT_OF_MEASURE'')),'

Line 2448: ||' MSC_BATCHING_WINDOW =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHING_WINDOW'')),'

2444: ||' MRP_BIS_AV_DISCOUNT =NVL(TO_NUMBER(FND_PROFILE.VALUE(''MRP_BIS_AV_DISCOUNT'')),0),'
2445: ||' MRP_BIS_PRICE_LIST =TO_NUMBER( FND_PROFILE.VALUE(''MRP_BIS_PRICE_LIST'')),'
2446: ||' MSC_DMD_PRIORITY_FLEX_NUM=NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_DMD_PRIORITY_FLEX_NUM'')),0),'
2447: ||' MSC_BATCHABLE_FLAG =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHABLE_FLAG'')),'
2448: ||' MSC_BATCHING_WINDOW =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHING_WINDOW'')),'
2449: ||' MSC_MIN_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MIN_CAPACITY'')),'
2450: ||' MSC_MAX_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MAX_CAPACITY'')),'
2451: ||' MSC_UNIT_OF_MEASURE =TO_NUMBER( FND_PROFILE.VALUE(''MSC_UNIT_OF_MEASURE'')),'
2452: ||' VALIDATION_ORG_ID =NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_ORG_FOR_BOM_EXPLOSION'')),to_number(null)),'

Line 2449: ||' MSC_MIN_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MIN_CAPACITY'')),'

2445: ||' MRP_BIS_PRICE_LIST =TO_NUMBER( FND_PROFILE.VALUE(''MRP_BIS_PRICE_LIST'')),'
2446: ||' MSC_DMD_PRIORITY_FLEX_NUM=NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_DMD_PRIORITY_FLEX_NUM'')),0),'
2447: ||' MSC_BATCHABLE_FLAG =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHABLE_FLAG'')),'
2448: ||' MSC_BATCHING_WINDOW =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHING_WINDOW'')),'
2449: ||' MSC_MIN_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MIN_CAPACITY'')),'
2450: ||' MSC_MAX_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MAX_CAPACITY'')),'
2451: ||' MSC_UNIT_OF_MEASURE =TO_NUMBER( FND_PROFILE.VALUE(''MSC_UNIT_OF_MEASURE'')),'
2452: ||' VALIDATION_ORG_ID =NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_ORG_FOR_BOM_EXPLOSION'')),to_number(null)),'
2453: ||' MSC_SO_OFFSET_DAYS =TO_NUMBER( NVL(FND_PROFILE.VALUE'||v_dblink||'(''MSC_SO_OFFSET_DAYS''),99999)),'

Line 2450: ||' MSC_MAX_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MAX_CAPACITY'')),'

2446: ||' MSC_DMD_PRIORITY_FLEX_NUM=NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_DMD_PRIORITY_FLEX_NUM'')),0),'
2447: ||' MSC_BATCHABLE_FLAG =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHABLE_FLAG'')),'
2448: ||' MSC_BATCHING_WINDOW =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHING_WINDOW'')),'
2449: ||' MSC_MIN_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MIN_CAPACITY'')),'
2450: ||' MSC_MAX_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MAX_CAPACITY'')),'
2451: ||' MSC_UNIT_OF_MEASURE =TO_NUMBER( FND_PROFILE.VALUE(''MSC_UNIT_OF_MEASURE'')),'
2452: ||' VALIDATION_ORG_ID =NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_ORG_FOR_BOM_EXPLOSION'')),to_number(null)),'
2453: ||' MSC_SO_OFFSET_DAYS =TO_NUMBER( NVL(FND_PROFILE.VALUE'||v_dblink||'(''MSC_SO_OFFSET_DAYS''),99999)),'
2454: ||' ITEM_NAME_FROM_KFV = :lv_item_name_kfv '

Line 2451: ||' MSC_UNIT_OF_MEASURE =TO_NUMBER( FND_PROFILE.VALUE(''MSC_UNIT_OF_MEASURE'')),'

2447: ||' MSC_BATCHABLE_FLAG =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHABLE_FLAG'')),'
2448: ||' MSC_BATCHING_WINDOW =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHING_WINDOW'')),'
2449: ||' MSC_MIN_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MIN_CAPACITY'')),'
2450: ||' MSC_MAX_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MAX_CAPACITY'')),'
2451: ||' MSC_UNIT_OF_MEASURE =TO_NUMBER( FND_PROFILE.VALUE(''MSC_UNIT_OF_MEASURE'')),'
2452: ||' VALIDATION_ORG_ID =NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_ORG_FOR_BOM_EXPLOSION'')),to_number(null)),'
2453: ||' MSC_SO_OFFSET_DAYS =TO_NUMBER( NVL(FND_PROFILE.VALUE'||v_dblink||'(''MSC_SO_OFFSET_DAYS''),99999)),'
2454: ||' ITEM_NAME_FROM_KFV = :lv_item_name_kfv '
2455: ||' WHERE INSTANCE_ID = :pINSTANCE_ID'

Line 2452: ||' VALIDATION_ORG_ID =NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_ORG_FOR_BOM_EXPLOSION'')),to_number(null)),'

2448: ||' MSC_BATCHING_WINDOW =TO_NUMBER( FND_PROFILE.VALUE(''MSC_BATCHING_WINDOW'')),'
2449: ||' MSC_MIN_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MIN_CAPACITY'')),'
2450: ||' MSC_MAX_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MAX_CAPACITY'')),'
2451: ||' MSC_UNIT_OF_MEASURE =TO_NUMBER( FND_PROFILE.VALUE(''MSC_UNIT_OF_MEASURE'')),'
2452: ||' VALIDATION_ORG_ID =NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_ORG_FOR_BOM_EXPLOSION'')),to_number(null)),'
2453: ||' MSC_SO_OFFSET_DAYS =TO_NUMBER( NVL(FND_PROFILE.VALUE'||v_dblink||'(''MSC_SO_OFFSET_DAYS''),99999)),'
2454: ||' ITEM_NAME_FROM_KFV = :lv_item_name_kfv '
2455: ||' WHERE INSTANCE_ID = :pINSTANCE_ID'
2456: ||' AND INSTANCE_CODE= :pINSTANCE_CODE'

Line 2453: ||' MSC_SO_OFFSET_DAYS =TO_NUMBER( NVL(FND_PROFILE.VALUE'||v_dblink||'(''MSC_SO_OFFSET_DAYS''),99999)),'

2449: ||' MSC_MIN_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MIN_CAPACITY'')),'
2450: ||' MSC_MAX_CAPACITY =TO_NUMBER( FND_PROFILE.VALUE(''MSC_MAX_CAPACITY'')),'
2451: ||' MSC_UNIT_OF_MEASURE =TO_NUMBER( FND_PROFILE.VALUE(''MSC_UNIT_OF_MEASURE'')),'
2452: ||' VALIDATION_ORG_ID =NVL(TO_NUMBER( FND_PROFILE.VALUE(''MSC_ORG_FOR_BOM_EXPLOSION'')),to_number(null)),'
2453: ||' MSC_SO_OFFSET_DAYS =TO_NUMBER( NVL(FND_PROFILE.VALUE'||v_dblink||'(''MSC_SO_OFFSET_DAYS''),99999)),'
2454: ||' ITEM_NAME_FROM_KFV = :lv_item_name_kfv '
2455: ||' WHERE INSTANCE_ID = :pINSTANCE_ID'
2456: ||' AND INSTANCE_CODE= :pINSTANCE_CODE'
2457: ||' AND nvl(A2M_DBLINK,'||''''||NULL_DBLINK ||''''||') = nvl(:pA2M_DBLINK,'||''''||NULL_DBLINK||''''||') ';

Line 2480: SELECT Nvl(fnd_profile.value('MSC_REFRESH_REGION_SITE'),1)

2476:
2477: /* Employing different strategy for Region Site Mapping --9396359
2478: */
2479: Begin
2480: SELECT Nvl(fnd_profile.value('MSC_REFRESH_REGION_SITE'),1)
2481: INTO lv_map_region_during_coll
2482: FROM dual;
2483: Exception
2484: When Others Then

Line 2991: UPDATE FND_PROFILE_OPTION_VALUES

2987: if drop_count > 0 then
2988: begin
2989: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Updating Profile Option MSC_SOURCE_SETUP to Yes ');
2990:
2991: UPDATE FND_PROFILE_OPTION_VALUES
2992: SET PROFILE_OPTION_VALUE = 'Y'
2993: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
2994: FROM FND_PROFILE_OPTIONS
2995: WHERE PROFILE_OPTION_NAME = 'MSC_SOURCE_SETUP');

Line 2994: FROM FND_PROFILE_OPTIONS

2990:
2991: UPDATE FND_PROFILE_OPTION_VALUES
2992: SET PROFILE_OPTION_VALUE = 'Y'
2993: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
2994: FROM FND_PROFILE_OPTIONS
2995: WHERE PROFILE_OPTION_NAME = 'MSC_SOURCE_SETUP');
2996: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Profile Option MSC_SOURCE_SETUP has been updated Yes ');
2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Value Yes indicates that the Collection Setup Objects need to be recreated');
2998: COMMIT;

Line 3078: UPDATE FND_PROFILE_OPTION_VALUES

3074: if drop_count > 0 then
3075: begin
3076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Updating Profile Option MSC_SOURCE_SETUP to Yes ');
3077:
3078: UPDATE FND_PROFILE_OPTION_VALUES
3079: SET PROFILE_OPTION_VALUE = 'Y'
3080: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
3081: FROM FND_PROFILE_OPTIONS
3082: WHERE PROFILE_OPTION_NAME = 'MSC_SOURCE_SETUP');

Line 3081: FROM FND_PROFILE_OPTIONS

3077:
3078: UPDATE FND_PROFILE_OPTION_VALUES
3079: SET PROFILE_OPTION_VALUE = 'Y'
3080: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
3081: FROM FND_PROFILE_OPTIONS
3082: WHERE PROFILE_OPTION_NAME = 'MSC_SOURCE_SETUP');
3083: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Profile Option MSC_SOURCE_SETUP has been updated Yes ');
3084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Value Yes indicates that the Collection Setup Objects need to be recreated');
3085: COMMIT;