APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on DUAL

Line 206: || ' from dual ';

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
210: CREATE_INDEX(lv_out);

Line 1634: execute immediate ' select ' || exp || ' from dual ' into val;

1630: val := 1;
1631: else
1632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Evaluating -- ' || exp);
1633: begin
1634: execute immediate ' select ' || exp || ' from dual ' into val;
1635: exception when others then
1636: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error while evaluating :' || exp);
1637: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,SQLERRM);
1638: val :=0;

Line 1674: || ' from dual ';

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);
1677: execute immediate lv_sql_stmt into lv_usaf_prof_flag ;
1678:

Line 1882: INDIVIDUAL_REFRESH_ERROR EXCEPTION;

1878: lv_DEGREE NUMBER := nvl(pDEGREE,0);
1879:
1880: lv_flm_appl_short_name VARCHAR2(50);
1881: CONFIG_BOM_NOT_FOUND EXCEPTION;
1882: INDIVIDUAL_REFRESH_ERROR EXCEPTION;
1883:
1884: lv_base_table_name VARCHAR2(30);
1885: lv_base_schema VARCHAR2(30);
1886: lv_snap_log_schema VARCHAR2(30);

Line 1968: FROM DUAL;

1964: --dbms_output.put_line('The degree of parallelism for Refreshing snapshots is set to: '||lv_DEGREE);
1965:
1966: SELECT MRP_AP_REFRESH_S.NEXTVAL
1967: INTO v_refresh_number
1968: FROM DUAL;
1969:
1970:
1971: IF pCALLING_MODULE = G_COLLECTIONS THEN /* Forward Port Bug 2904050 */
1972:

Line 2015: || ' from dual ';

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);
2019:

Line 2035: FROM DUAL;

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
2038: IF SETUP_SOURCE_OBJECTS = FALSE THEN
2039: RAISE SOURCE_SETUP_ERROR;

Line 2121: FROM DUAL;

2117: -- and this will be recorded in mrp_ap_apps_instances_all.lrn
2118:
2119: SELECT MRP_AP_REFRESH_S.NEXTVAL
2120: INTO v_refresh_number
2121: FROM DUAL;
2122:
2123:
2124: END IF;
2125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, substr(lv_snapshot_str,1,100) );

Line 2137: RAISE INDIVIDUAL_REFRESH_ERROR;

2133: ELSE
2134: ROLLBACK;
2135: RETCODE:= G_ERROR;
2136: ERRBUF:= SQLERRM;
2137: RAISE INDIVIDUAL_REFRESH_ERROR;
2138: END IF;
2139:
2140: /*IBUC*/
2141: IF lv_ibuc_history_flag = MSC_UTIL.SYS_YES THEN

Line 2227: RAISE INDIVIDUAL_REFRESH_ERROR;

2223: /* ELSE
2224: ROLLBACK;
2225: RETCODE:= G_ERROR;
2226: ERRBUF:= SQLERRM;
2227: RAISE INDIVIDUAL_REFRESH_ERROR;
2228: END IF; */
2229:
2230: EXCEPTION
2231: WHEN OTHERS THEN

Line 2482: FROM dual;

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
2485: lv_map_region_during_coll := 1;
2486: End;

Line 2627: WHEN INDIVIDUAL_REFRESH_ERROR THEN

2623: RETCODE:= G_ERROR;
2624:
2625: ERRBUF:= SQLERRM;
2626:
2627: WHEN INDIVIDUAL_REFRESH_ERROR THEN
2628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2629: RETCODE:= G_ERROR;
2630: ERRBUF:= SQLERRM;
2631:

Line 2745: FROM DUAL;

2741: --Set the global variable for triggers.
2742: IF pCURRENT_LRN = -1 THEN
2743: SELECT MRP_AP_REFRESH_S.NEXTVAL
2744: INTO v_refresh_number
2745: FROM DUAL;
2746: ELSE
2747: -- BUG 8997371
2748: -- Do a Dummy next val as the fast refresh on DB version 11.2
2749: -- does not find the PL/SQL package variable.

Line 2753: FROM DUAL;

2749: -- does not find the PL/SQL package variable.
2750:
2751: SELECT MRP_AP_REFRESH_S.NEXTVAL
2752: INTO lv_ref_num
2753: FROM DUAL;
2754:
2755: v_refresh_number := pCURRENT_LRN;
2756: END IF;
2757:

Line 2917: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error refreshing individual snapshot : ' || lv_snap_str);

2913: WHEN OTHERS THEN
2914: ROLLBACK;
2915: RETCODE:= G_ERROR;
2916: ERRBUF:= SQLERRM;
2917: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error refreshing individual snapshot : ' || lv_snap_str);
2918: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error : '|| ERRBUF);
2919: RAISE;
2920: END REFRESH_SINGLE_SNAPSHOT;
2921: