APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on DUAL

Line 191: || ' from dual ';

187: end if;
188:
189: if lv_success THEN
190: lv_sql_stmt:= 'select NVL(FND_PROFILE.VALUE'||v_a2m_dblink||'(''MSC_SRP_ENABLED''),''N'')'
191: || ' from dual ';
192: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_sql_stmt);
193: execute immediate lv_sql_stmt into lv_srp_enabled_flag ;
194: IF lv_srp_enabled_flag='Y' THEN
195: CREATE_INDEX(lv_out);

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

1567: val := 1;
1568: else
1569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Evaluating -- ' || exp);
1570: begin
1571: execute immediate ' select ' || exp || ' from dual ' into val;
1572: exception when others then
1573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error while evaluating :' || exp);
1574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,SQLERRM);
1575: val :=0;

Line 1766: INDIVIDUAL_REFRESH_ERROR EXCEPTION;

1762: lv_DEGREE NUMBER := nvl(pDEGREE,0);
1763:
1764: lv_flm_appl_short_name VARCHAR2(50);
1765: CONFIG_BOM_NOT_FOUND EXCEPTION;
1766: INDIVIDUAL_REFRESH_ERROR EXCEPTION;
1767:
1768: lv_base_table_name VARCHAR2(30);
1769: lv_base_schema VARCHAR2(30);
1770: lv_snap_log_schema VARCHAR2(30);

Line 1849: FROM DUAL;

1845: dbms_output.put_line('The degree of parallelism for Refreshing snapshots is set to: '||lv_DEGREE);
1846:
1847: SELECT MRP_AP_REFRESH_S.NEXTVAL
1848: INTO v_refresh_number
1849: FROM DUAL;
1850:
1851:
1852: IF pCALLING_MODULE = G_COLLECTIONS THEN /* Forward Port Bug 2904050 */
1853:

Line 1911: FROM DUAL;

1907: /* Based on the profile option setting MSC_SOURCE_SETUP Setup the Source Objects */
1908:
1909: SELECT DECODE(NVL(fnd_profile.value('MSC_SOURCE_SETUP') ,'Y'), 'Y',1 ,2)
1910: INTO lv_setup_source_objs
1911: FROM DUAL;
1912:
1913: IF (lv_setup_source_objs = 1) THEN
1914: IF SETUP_SOURCE_OBJECTS = FALSE THEN
1915: RAISE SOURCE_SETUP_ERROR;

Line 1998: RAISE INDIVIDUAL_REFRESH_ERROR;

1994: ELSE
1995: ROLLBACK;
1996: RETCODE:= G_ERROR;
1997: ERRBUF:= SQLERRM;
1998: RAISE INDIVIDUAL_REFRESH_ERROR;
1999: END IF;
2000:
2001: EXCEPTION
2002: WHEN OTHERS THEN

Line 2262: WHEN INDIVIDUAL_REFRESH_ERROR THEN

2258: RETCODE:= G_ERROR;
2259:
2260: ERRBUF:= SQLERRM;
2261:
2262: WHEN INDIVIDUAL_REFRESH_ERROR THEN
2263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2264: RETCODE:= G_ERROR;
2265: ERRBUF:= SQLERRM;
2266:

Line 2369: FROM DUAL;

2365: --Set the global variable for triggers.
2366: IF pCURRENT_LRN = -1 THEN
2367: SELECT MRP_AP_REFRESH_S.NEXTVAL
2368: INTO v_refresh_number
2369: FROM DUAL;
2370: ELSE
2371: v_refresh_number := pCURRENT_LRN;
2372: END IF;
2373:

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

2468: WHEN OTHERS THEN
2469: ROLLBACK;
2470: RETCODE:= G_ERROR;
2471: ERRBUF:= SQLERRM;
2472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error refreshing individual snapshot : ' || lv_snap_str);
2473: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error : '|| ERRBUF);
2474: RAISE;
2475: END REFRESH_SINGLE_SNAPSHOT;
2476: