APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on MRP_AP_APPS_INSTANCES_ALL

Line 1444: FROM MRP_AP_APPS_INSTANCES_ALL

1440: SELECT DECODE( A2M_DBLINK,
1441: NULL, NULL_DBLINK,
1442: '@'||A2M_DBLINK)
1443: INTO v_dblink
1444: FROM MRP_AP_APPS_INSTANCES_ALL
1445: WHERE INSTANCE_ID = g_INSTANCE_ID
1446: AND INSTANCE_CODE= g_INSTANCE_CODE
1447: AND nvl(A2M_DBLINK,NULL_DBLINK) = nvl(g_A2M_DBLINK,NULL_DBLINK) ;
1448:

Line 1857: FROM MRP_AP_APPS_INSTANCES_ALL;

1853:
1854: BEGIN
1855: SELECT max(LRD)
1856: INTO max_lrd
1857: FROM MRP_AP_APPS_INSTANCES_ALL;
1858: EXCEPTION
1859: WHEN NO_DATA_FOUND THEN
1860: RETCODE:= G_ERROR;
1861: ERRBUF := 'NO_INSTANCE_FOUND';

Line 1873: FROM MRP_AP_APPS_INSTANCES_ALL

1869: SELECT LRN, DECODE( A2M_DBLINK,
1870: NULL, NULL_DBLINK,
1871: '@'||A2M_DBLINK)
1872: INTO v_old_lrn, v_dblink
1873: FROM MRP_AP_APPS_INSTANCES_ALL
1874: WHERE INSTANCE_ID = pINSTANCE_ID
1875: AND INSTANCE_CODE= pINSTANCE_CODE
1876: AND nvl(A2M_DBLINK,NULL_DBLINK) = nvl(pA2M_DBLINK,NULL_DBLINK) ;
1877: EXCEPTION

Line 2176: lv_sql_stmt := 'UPDATE MRP_AP_APPS_INSTANCES_ALL '

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