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.MSC_CL_COLLECTION dependencies on MSC_APPS_INSTANCES

Line 166: update the msc_apps_instances collections_start_time*/

162: END alter_temp_table_by_monitor;
163:
164: /* REsource Start Time changes
165: Get the refresh date from mrp_ap_apps_instances and
166: update the msc_apps_instances collections_start_time*/
167: PROCEDURE SET_COLLECTIONS_START_TIME(pINSTANCE_ID in number,
168: p_resource_start_time out NOCOPY date)
169: IS
170: lv_sql_stmt varchar2(32767);

Line 191: FROM MSC_APPS_INSTANCES

187: INSTANCE_CODE
188: INTO lv_dblink,
189: lv_dest_a2m,
190: lv_instance_code
191: FROM MSC_APPS_INSTANCES
192: WHERE INSTANCE_ID=pINSTANCE_ID;
193:
194: IF v_apps_ver >= MSC_UTIL.G_APPS115 THEN
195: lv_table_name := 'MRP_AP_APPS_INSTANCES_ALL';

Line 225: UPDATE MSC_APPS_INSTANCES

221: lv_resource_start_time := lv_resource_start_time - nvl(lv_res_avail_before_sysdate,1);
222: lv_collection_start_time:= SYSDATE;
223: END IF;
224:
225: UPDATE MSC_APPS_INSTANCES
226: SET COLLECTIONS_START_TIME= lv_collection_start_time
227: where instance_id = pINSTANCE_ID;
228: /*ASL */
229:

Line 279: UPDATE msc_apps_instances

275: SELECT PULL_WRKR_START_TIME into lv_COLL_PULL_START_TIME
276: from msc_coll_parameters
277: where INSTANCE_ID = pINSTANCE_ID;
278:
279: UPDATE msc_apps_instances
280: SET PULL_WRKR_START_TIME = lv_COLL_PULL_START_TIME,
281: SNAP_REF_START_TIME = lv_collection_start_time
282: where instance_id = pINSTANCE_ID;
283:

Line 866: FROM MSC_APPS_INSTANCES

862: v_current_user,
863: v_instance_code,
864: v_instance_type, -- OPM
865: v_sourcing_flag -- Sourcing Flag
866: FROM MSC_APPS_INSTANCES
867: WHERE INSTANCE_ID= pINSTANCE_ID;
868:
869: --- PREPLACE CHANGE START ---
870: /*

Line 974: FROM MSC_APPS_INSTANCES mai

970: IF pST_STATUS= MSC_UTIL.G_ST_COLLECTING THEN
971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'pST_STATUS = MSC_UTIL.G_ST_COLLECTING');
972: SELECT mai.ST_STATUS
973: INTO lv_staging_table_status
974: FROM MSC_APPS_INSTANCES mai
975: WHERE mai.INSTANCE_ID= pINSTANCE_ID
976: FOR UPDATE;
977:
978: IF lv_staging_table_status= MSC_UTIL.G_ST_EMPTY THEN

Line 1014: UPDATE MSC_APPS_INSTANCES

1010: ELSE
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' st status is success');
1012: RETCODE := MSC_UTIL.G_SUCCESS ;
1013:
1014: UPDATE MSC_APPS_INSTANCES
1015: SET ST_STATUS= MSC_UTIL.G_ST_COLLECTING,
1016: LCID= MSC_COLLECTION_S.NEXTVAL,
1017: LAST_UPDATE_DATE= v_current_date,
1018: LAST_UPDATED_BY= v_current_user,

Line 1036: FROM MSC_APPS_INSTANCES mai

1032:
1033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' pST_STATUS= MSC_UTIL.G_ST_PURGING ');
1034: SELECT mai.ST_STATUS
1035: INTO lv_staging_table_status
1036: FROM MSC_APPS_INSTANCES mai
1037: WHERE mai.INSTANCE_ID= pINSTANCE_ID
1038: FOR UPDATE;
1039:
1040: IF lv_staging_table_status= MSC_UTIL.G_ST_EMPTY THEN

Line 1075: UPDATE MSC_APPS_INSTANCES

1071:
1072: ELSE
1073: RETCODE := MSC_UTIL.G_SUCCESS ;
1074: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' stsetup = success');
1075: UPDATE MSC_APPS_INSTANCES
1076: SET ST_STATUS= MSC_UTIL.G_ST_PURGING,
1077: SO_TBL_STATUS= MSC_UTIL.SYS_YES,
1078: LAST_UPDATE_DATE= v_current_date,
1079: LAST_UPDATED_BY= v_current_user,

Line 1090: UPDATE MSC_APPS_INSTANCES

1086:
1087: ---===================== EMPTY ====================
1088: ELSIF pST_STATUS= MSC_UTIL.G_ST_EMPTY THEN
1089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' pST_STATUS= MSC_UTIL.G_ST_EMPTY');
1090: UPDATE MSC_APPS_INSTANCES
1091: SET ST_STATUS= MSC_UTIL.G_ST_EMPTY,
1092: SO_TBL_STATUS= MSC_UTIL.SYS_YES,
1093: LAST_UPDATE_DATE= v_current_date,
1094: LAST_UPDATED_BY= v_current_user,

Line 1104: UPDATE MSC_APPS_INSTANCES

1100:
1101: ---===================== READY ====================
1102: ELSIF pST_STATUS= MSC_UTIL.G_ST_READY THEN
1103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' pST_STATUS= MSC_UTIL.G_ST_READY');
1104: UPDATE MSC_APPS_INSTANCES
1105: SET ST_STATUS= MSC_UTIL.G_ST_READY,
1106: LAST_UPDATE_DATE= v_current_date,
1107: LAST_UPDATED_BY= v_current_user,
1108: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

Line 1130: UPDATE MSC_APPS_INSTANCES mai

1126: PROCEDURE FINAL
1127: IS
1128: BEGIN
1129:
1130: UPDATE MSC_APPS_INSTANCES mai
1131: SET LAST_UPDATE_DATE= v_current_date,
1132: LAST_UPDATED_BY= v_current_user,
1133: SUPPLIES_LOAD_FLAG = null,
1134: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

Line 1418: update msc_apps_instances

1414: -- ============= Execute the task according to its task number ===========
1415:
1416: IF pTASKNUM= TASK_SUPPLY THEN
1417:
1418: update msc_apps_instances
1419: set SUPPLIES_LOAD_FLAG = G_JOB_NOT_DONE
1420: where instance_id = v_instance_id;
1421: commit;
1422:

Line 1453: update msc_apps_instances

1449: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
1450:
1451: END IF;
1452:
1453: update msc_apps_instances
1454: set SUPPLIES_LOAD_FLAG = G_JOB_DONE
1455: where instance_id = v_instance_id;
1456: commit;
1457:

Line 2427: update msc_apps_instances

2423:
2424: ELSIF pTASKNUM= PTASK_SUPPLY THEN
2425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'ds debug: pTASKNUM= PTASK_SUPPLY ');
2426:
2427: update msc_apps_instances
2428: set SUPPLIES_LOAD_FLAG = G_JOB_NOT_DONE
2429: where instance_id = v_instance_id;
2430: commit;
2431:

Line 2548: update msc_apps_instances

2544: END IF;
2545:
2546: COMMIT;
2547:
2548: update msc_apps_instances
2549: set SUPPLIES_LOAD_FLAG = G_JOB_DONE
2550: where instance_id = v_instance_id;
2551: commit;
2552:

Line 3007: FROM MSC_APPS_INSTANCES

3003: v_current_date,
3004: v_current_user,
3005: v_current_date,
3006: v_current_user
3007: FROM MSC_APPS_INSTANCES
3008: WHERE INSTANCE_ID= pINSTANCE_ID;
3009:
3010: IF pVALIDATION= MSC_UTIL.SYS_YES THEN
3011:

Line 3113: from msc_apps_instances

3109: -- agmcont:
3110: if (v_is_cont_refresh ) then
3111: select lcid
3112: INTO v_last_collection_id
3113: from msc_apps_instances
3114: where instance_id = pINSTANCE_ID;
3115: else
3116: v_last_collection_id:= pLCID;
3117: end if;

Line 3769: UPDATE MSC_APPS_INSTANCES mai

3765: --unless all the related ATP tables are populated
3766:
3767: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so_tbl status to no');
3768: IF (v_coll_prec.tp_vendor_flag = MSC_UTIL.SYS_YES OR v_coll_prec.tp_customer_flag = MSC_UTIL.SYS_YES OR v_coll_prec.sourcing_rule_flag=MSC_UTIL.SYS_YES OR v_coll_prec.atp_rules_flag=MSC_UTIL.SYS_YES) THEN
3769: UPDATE MSC_APPS_INSTANCES mai
3770: SET
3771: so_tbl_status= MSC_UTIL.SYS_NO,
3772: LAST_UPDATE_DATE= v_current_date,
3773: LAST_UPDATED_BY= v_current_user,

Line 4062: UPDATE MSC_APPS_INSTANCES mai

4058: END if;
4059:
4060:
4061: if G_TASK_ATP_RULES =1 and G_TASK_SOURCING =1 then
4062: UPDATE MSC_APPS_INSTANCES mai
4063: SET
4064: so_tbl_status= MSC_UTIL.SYS_YES,
4065: LAST_UPDATE_DATE= v_current_date,
4066: LAST_UPDATED_BY= v_current_user,

Line 4157: UPDATE MSC_APPS_INSTANCES mai

4153: ELSE
4154:
4155: lv_task_number:= 0;
4156:
4157: UPDATE MSC_APPS_INSTANCES mai
4158: SET LAST_UPDATE_DATE= v_current_date,
4159: LAST_UPDATED_BY= v_current_user,
4160: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4161: WHERE mai.INSTANCE_ID= v_instance_id;

Line 4326: UPDATE MSC_APPS_INSTANCES

4322: IF ( v_coll_prec.item_flag = MSC_UTIL.SYS_YES or v_coll_prec.bom_flag = MSC_UTIL.SYS_YES ) THEN
4323: MSC_CL_ITEM_ODS_LOAD.UPDATE_LEADTIME;
4324: END IF;
4325:
4326: UPDATE MSC_APPS_INSTANCES
4327: SET so_tbl_status= MSC_UTIL.SYS_YES
4328: WHERE instance_id= v_instance_id;
4329: /*Resource Start Time*/
4330: -- Set The collections Start Time . Get the start time in the out variable

Line 4461: FROM MSC_APPS_INSTANCES

4457: SELECT DECODE(M2A_DBLINK,
4458: NULL,'',
4459: '@'||M2A_DBLINK)
4460: INTO lv_dblink
4461: FROM MSC_APPS_INSTANCES
4462: WHERE INSTANCE_ID=v_instance_id;
4463: lv_sql_stmt:=
4464: 'BEGIN MRP_CL_REFRESH_SNAPSHOT.PURGE_OBSOLETE_DATA'||lv_dblink||';END;';
4465:

Line 5401: UPDATE MSC_APPS_INSTANCES mai

5397: end if;
5398:
5399: if (v_is_partial_refresh) then
5400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so_tbl status to no');
5401: UPDATE MSC_APPS_INSTANCES mai
5402: SET
5403: so_tbl_status= MSC_UTIL.SYS_NO,
5404: LAST_UPDATE_DATE= v_current_date,
5405: LAST_UPDATED_BY= v_current_user,

Line 5433: UPDATE MSC_APPS_INSTANCES mai

5429:
5430: /* SCE Change ends */
5431:
5432: if (v_is_partial_refresh AND v_coll_prec.sourcing_rule_flag = MSC_UTIL.SYS_NO AND v_coll_prec.atp_rules_flag = MSC_UTIL.SYS_NO) then
5433: UPDATE MSC_APPS_INSTANCES mai
5434: SET
5435: so_tbl_status= MSC_UTIL.SYS_YES,
5436: LAST_UPDATE_DATE= v_current_date,
5437: LAST_UPDATED_BY= v_current_user,

Line 5649: UPDATE MSC_APPS_INSTANCES mai

5645:
5646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so_tbl status to no');
5647: if (v_is_partial_refresh AND ((v_coll_prec.sourcing_rule_flag = MSC_UTIL.SYS_YES OR v_coll_prec.atp_rules_flag = MSC_UTIL.SYS_YES)
5648: AND (v_coll_prec.tp_vendor_flag = MSC_UTIL.SYS_NO AND v_coll_prec.tp_customer_flag = MSC_UTIL.SYS_NO))) then
5649: UPDATE MSC_APPS_INSTANCES mai
5650: SET
5651: so_tbl_status= MSC_UTIL.SYS_NO,
5652: LAST_UPDATE_DATE= v_current_date,
5653: LAST_UPDATED_BY= v_current_user,

Line 5716: UPDATE MSC_APPS_INSTANCES mai

5712: end if;
5713:
5714: if v_is_partial_refresh AND (v_coll_prec.sourcing_rule_flag = MSC_UTIL.SYS_YES AND v_coll_prec.atp_rules_flag = MSC_UTIL.SYS_YES) then
5715: if G_TASK_ATP_RULES =1 and G_TASK_SOURCING =1 then
5716: UPDATE MSC_APPS_INSTANCES mai
5717: SET
5718: so_tbl_status= MSC_UTIL.SYS_YES,
5719: LAST_UPDATE_DATE= v_current_date,
5720: LAST_UPDATED_BY= v_current_user,

Line 5730: UPDATE MSC_APPS_INSTANCES mai

5726: G_TASK_SOURCING :=0;
5727: end if;
5728: elsif v_is_partial_refresh AND (v_coll_prec.sourcing_rule_flag = MSC_UTIL.SYS_YES AND v_coll_prec.atp_rules_flag = MSC_UTIL.SYS_NO) then
5729: if G_TASK_SOURCING =1 then
5730: UPDATE MSC_APPS_INSTANCES mai
5731: SET
5732: so_tbl_status= MSC_UTIL.SYS_YES,
5733: LAST_UPDATE_DATE= v_current_date,
5734: LAST_UPDATED_BY= v_current_user,

Line 5743: UPDATE MSC_APPS_INSTANCES mai

5739: G_TASK_SOURCING :=0;
5740: end if;
5741: elsif v_is_partial_refresh AND (v_coll_prec.sourcing_rule_flag = MSC_UTIL.SYS_NO AND v_coll_prec.atp_rules_flag = MSC_UTIL.SYS_YES) then
5742: if G_TASK_ATP_RULES =1 then
5743: UPDATE MSC_APPS_INSTANCES mai
5744: SET
5745: so_tbl_status= MSC_UTIL.SYS_YES,
5746: LAST_UPDATE_DATE= v_current_date,
5747: LAST_UPDATED_BY= v_current_user,

Line 5844: UPDATE MSC_APPS_INSTANCES mai

5840: ELSE
5841:
5842: lv_task_number:= 0;
5843:
5844: UPDATE MSC_APPS_INSTANCES mai
5845: SET LAST_UPDATE_DATE= v_current_date,
5846: LAST_UPDATED_BY= v_current_user,
5847: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
5848: WHERE mai.INSTANCE_ID= v_instance_id;

Line 6105: UPDATE MSC_APPS_INSTANCES

6101:
6102: END IF;
6103: END IF;
6104:
6105: UPDATE MSC_APPS_INSTANCES
6106: SET so_tbl_status= MSC_UTIL.SYS_YES
6107: WHERE instance_id= v_instance_id;
6108: /* Resource Start Time*/
6109: -- Set The collections Start Time . Get the start time in the out variable

Line 6759: FROM msc_apps_instances

6755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6756:
6757: SELECT instance_id
6758: INTO lv_instance_id
6759: FROM msc_apps_instances
6760: WHERE upper(instance_code) = p_instance_code;
6761:
6762: IF MSC_CL_EXCHANGE_PARTTBL.Initialize( lv_instance_id,
6763: p_instance_code,