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 MRP_AP_APPS_INSTANCES_ALL

Line 1492: FROM MRP_AP_APPS_INSTANCES_ALL

1488: SELECT DECODE( A2M_DBLINK,
1489: NULL, NULL_DBLINK,
1490: '@'||A2M_DBLINK)
1491: INTO v_dblink
1492: FROM MRP_AP_APPS_INSTANCES_ALL
1493: WHERE INSTANCE_ID = g_INSTANCE_ID
1494: AND INSTANCE_CODE= g_INSTANCE_CODE
1495: AND nvl(A2M_DBLINK,NULL_DBLINK) = nvl(g_A2M_DBLINK,NULL_DBLINK) ;
1496:

Line 1976: FROM MRP_AP_APPS_INSTANCES_ALL;

1972:
1973: BEGIN
1974: SELECT max(LRD)
1975: INTO max_lrd
1976: FROM MRP_AP_APPS_INSTANCES_ALL;
1977: EXCEPTION
1978: WHEN NO_DATA_FOUND THEN
1979: RETCODE:= G_ERROR;
1980: ERRBUF := 'NO_INSTANCE_FOUND';

Line 1992: FROM MRP_AP_APPS_INSTANCES_ALL

1988: SELECT LRN, DECODE( A2M_DBLINK,
1989: NULL, NULL_DBLINK,
1990: '@'||A2M_DBLINK)
1991: INTO v_old_lrn, v_dblink
1992: FROM MRP_AP_APPS_INSTANCES_ALL
1993: WHERE INSTANCE_ID = pINSTANCE_ID
1994: AND INSTANCE_CODE= pINSTANCE_CODE
1995: AND nvl(A2M_DBLINK,NULL_DBLINK) = nvl(pA2M_DBLINK,NULL_DBLINK) ;
1996: EXCEPTION

Line 2069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Before update of mrp_ap_apps_instances_all');

2065:
2066: END;
2067: */
2068:
2069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Before update of mrp_ap_apps_instances_all');
2070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'lv_snapshot_name is '||lv_snapshot_name);
2071: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'pCALLING_MODULE is '|| pCALLING_MODULE);
2072:
2073: IF (( lv_snapshot_name = 'COLL SNAPSHOTS' ) and

Line 2077: UPDATE MRP_AP_APPS_INSTANCES_ALL SET LRD = SYSDATE

2073: IF (( lv_snapshot_name = 'COLL SNAPSHOTS' ) and
2074: ( pCALLING_MODULE = G_COLLECTIONS)) THEN
2075: -- If all the Snapshots set RESOURCE START TIME
2076:
2077: UPDATE MRP_AP_APPS_INSTANCES_ALL SET LRD = SYSDATE
2078: WHERE INSTANCE_ID = pINSTANCE_ID
2079: AND INSTANCE_CODE= pINSTANCE_CODE
2080: AND nvl(A2M_DBLINK,NULL_DBLINK) = nvl(pA2M_DBLINK,NULL_DBLINK) ;
2081:

Line 2117: -- and this will be recorded in mrp_ap_apps_instances_all.lrn

2113: ELSE
2114: -- For complete/targeted collection, we need to
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;

Line 2408: lv_sql_stmt := 'UPDATE MRP_AP_APPS_INSTANCES_ALL '

2404: lv_item_name_kfv := 'x.SEGMENT1';
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,'

Line 2499: FROM MRP_AP_APPS_INSTANCES_ALL

2495: SELECT DECODE( A2M_DBLINK,
2496: NULL, NULL_DBLINK,
2497: '@'||A2M_DBLINK)
2498: INTO v_dblink
2499: FROM MRP_AP_APPS_INSTANCES_ALL
2500: WHERE INSTANCE_ID = pINSTANCE_ID
2501: AND INSTANCE_CODE= pINSTANCE_CODE
2502: AND nvl(A2M_DBLINK,NULL_DBLINK) = nvl(pA2M_DBLINK,NULL_DBLINK) ;
2503: