[Home] [Help]
1962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'snp name - ' || pSNAPSHOT_NAME);
1963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The degree of parallelism for Refreshing snapshots is set to: ' || lv_DEGREE); --8761596
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:
2115: -- incement the sequence once again so that the refresh of
2116: -- of all snapshots together gets a higher sequence number
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:
2405: END;
2406:
2407:
2408: lv_sql_stmt := 'UPDATE MRP_AP_APPS_INSTANCES_ALL '
2409: ||' SET LRN= MRP_AP_REFRESH_S.CURRVAL, '
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,'
2739: END;
2740:
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
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.
2750:
2751: SELECT MRP_AP_REFRESH_S.NEXTVAL
2752: INTO lv_ref_num
2753: FROM DUAL;
2754:
2755: v_refresh_number := pCURRENT_LRN;