APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_APPS_INSTANCES

Line 1795: FROM MSC_APPS_INSTANCES

1791: MSC_CL_COLLECTION.v_current_user,
1792: MSC_CL_COLLECTION.v_instance_code,
1793: MSC_CL_COLLECTION.v_instance_type, -- OPM
1794: MSC_CL_COLLECTION.v_last_collection_id
1795: FROM MSC_APPS_INSTANCES
1796: WHERE INSTANCE_ID= pINSTANCE_ID;
1797:
1798: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;
1799: MSC_CL_COLLECTION.v_is_incremental_refresh := FALSE;

Line 2717: lv_INSTANCE_ID MSC_APPS_INSTANCES.instance_id%TYPE;

2713: l_sql_stmt_del VARCHAR2 (4000);
2714: l_sql_stmt_tab VARCHAR2 (4000);
2715: lv_plan_name msc_plans.COMPILE_DESIGNATOR%TYPE;
2716: lv_plan_id msc_plans.plan_id%TYPE;
2717: lv_INSTANCE_ID MSC_APPS_INSTANCES.instance_id%TYPE;
2718: LV_DATA_START_DATE MSC_PLANS.DATA_START_DATE%TYPE;
2719: lv_PLAN_COMPLETION_DATE MSC_PLANS.PLAN_COMPLETION_DATE%TYPE;
2720: lv_UOM MSC_DEPARTMENT_RESOURCES.UNIT_OF_MEASURE%TYPE;
2721: v_dblink MSC_APPS_INSTANCES.M2A_DBLINK%TYPE;

Line 2721: v_dblink MSC_APPS_INSTANCES.M2A_DBLINK%TYPE;

2717: lv_INSTANCE_ID MSC_APPS_INSTANCES.instance_id%TYPE;
2718: LV_DATA_START_DATE MSC_PLANS.DATA_START_DATE%TYPE;
2719: lv_PLAN_COMPLETION_DATE MSC_PLANS.PLAN_COMPLETION_DATE%TYPE;
2720: lv_UOM MSC_DEPARTMENT_RESOURCES.UNIT_OF_MEASURE%TYPE;
2721: v_dblink MSC_APPS_INSTANCES.M2A_DBLINK%TYPE;
2722: LV_SOURCE_APPLICATION VARCHAR2 (3);
2723: v_current_date MSC_NET_RESOURCE_AVAIL.LAST_UPDATE_DATE%TYPE;
2724: v_current_user MSC_NET_RESOURCE_AVAIL.LAST_UPDATED_BY%TYPE;
2725: lv_TABLE_NAME all_tables.TABLE_NAME%TYPE;

Line 2743: FROM MSC_APPS_INSTANCES

2739:
2740: BEGIN
2741: SELECT DECODE (M2A_DBLINK, NULL, NULL_DBLINK, '@' || M2A_DBLINK)
2742: INTO v_dblink
2743: FROM MSC_APPS_INSTANCES
2744: WHERE INSTANCE_ID = pINSTANCE_ID;
2745: EXCEPTION
2746: WHEN NO_DATA_FOUND
2747: THEN