APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on MRP_AP_REFRESH_S

Line 1847: SELECT MRP_AP_REFRESH_S.NEXTVAL

1843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'snp name - ' || pSNAPSHOT_NAME);
1844:
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:

Line 2177: ||' SET LRN= MRP_AP_REFRESH_S.CURRVAL, '

2173: END;
2174:
2175:
2176: lv_sql_stmt := 'UPDATE MRP_AP_APPS_INSTANCES_ALL '
2177: ||' SET LRN= MRP_AP_REFRESH_S.CURRVAL, '
2178: -- Resource Start Time. This time will be updated before the snapshot refresh.
2179: -- LRD= SYSDATE,
2180: ||' LAST_UPDATE_DATE= SYSDATE,'
2181: ||' LAST_UPDATED_BY= FND_GLOBAL.USER_ID,'

Line 2367: SELECT MRP_AP_REFRESH_S.NEXTVAL

2363: END;
2364:
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;