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 174: update the msc_apps_instances collections_start_time*/

170: END alter_temp_table_by_monitor;
171:
172: /* REsource Start Time changes
173: Get the refresh date from mrp_ap_apps_instances and
174: update the msc_apps_instances collections_start_time*/
175: PROCEDURE SET_COLLECTIONS_START_TIME(pINSTANCE_ID in number,
176: p_resource_start_time out NOCOPY date)
177: IS
178: lv_sql_stmt varchar2(32767);

Line 199: FROM MSC_APPS_INSTANCES

195: INSTANCE_CODE
196: INTO lv_dblink,
197: lv_dest_a2m,
198: lv_instance_code
199: FROM MSC_APPS_INSTANCES
200: WHERE INSTANCE_ID=pINSTANCE_ID;
201:
202: IF v_apps_ver >= MSC_UTIL.G_APPS115 THEN
203: lv_table_name := 'MRP_AP_APPS_INSTANCES_ALL';

Line 233: UPDATE MSC_APPS_INSTANCES

229: lv_resource_start_time := lv_resource_start_time - nvl(lv_res_avail_before_sysdate,1);
230: lv_collection_start_time:= SYSDATE;
231: END IF;
232:
233: UPDATE MSC_APPS_INSTANCES
234: SET COLLECTIONS_START_TIME= lv_collection_start_time
235: where instance_id = pINSTANCE_ID;
236: /*ASL */
237:

Line 287: UPDATE msc_apps_instances

283: SELECT PULL_WRKR_START_TIME into lv_COLL_PULL_START_TIME
284: from msc_coll_parameters
285: where INSTANCE_ID = pINSTANCE_ID;
286:
287: UPDATE msc_apps_instances
288: SET PULL_WRKR_START_TIME = lv_COLL_PULL_START_TIME,
289: SNAP_REF_START_TIME = lv_collection_start_time
290: where instance_id = pINSTANCE_ID;
291:

Line 874: FROM MSC_APPS_INSTANCES

870: v_current_user,
871: v_instance_code,
872: v_instance_type, -- OPM
873: v_sourcing_flag -- Sourcing Flag
874: FROM MSC_APPS_INSTANCES
875: WHERE INSTANCE_ID= pINSTANCE_ID;
876:
877: --- PREPLACE CHANGE START ---
878: /*

Line 982: FROM MSC_APPS_INSTANCES mai

978: IF pST_STATUS= MSC_UTIL.G_ST_COLLECTING THEN
979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'pST_STATUS = MSC_UTIL.G_ST_COLLECTING');
980: SELECT mai.ST_STATUS
981: INTO lv_staging_table_status
982: FROM MSC_APPS_INSTANCES mai
983: WHERE mai.INSTANCE_ID= pINSTANCE_ID
984: FOR UPDATE;
985:
986: IF lv_staging_table_status= MSC_UTIL.G_ST_EMPTY THEN

Line 1022: UPDATE MSC_APPS_INSTANCES

1018: ELSE
1019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' st status is success');
1020: RETCODE := MSC_UTIL.G_SUCCESS ;
1021:
1022: UPDATE MSC_APPS_INSTANCES
1023: SET ST_STATUS= MSC_UTIL.G_ST_COLLECTING,
1024: LCID= MSC_COLLECTION_S.NEXTVAL,
1025: LAST_UPDATE_DATE= v_current_date,
1026: LAST_UPDATED_BY= v_current_user,

Line 1044: FROM MSC_APPS_INSTANCES mai

1040:
1041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' pST_STATUS= MSC_UTIL.G_ST_PURGING ');
1042: SELECT mai.ST_STATUS
1043: INTO lv_staging_table_status
1044: FROM MSC_APPS_INSTANCES mai
1045: WHERE mai.INSTANCE_ID= pINSTANCE_ID
1046: FOR UPDATE;
1047:
1048: IF lv_staging_table_status= MSC_UTIL.G_ST_EMPTY THEN

Line 1083: UPDATE MSC_APPS_INSTANCES

1079:
1080: ELSE
1081: RETCODE := MSC_UTIL.G_SUCCESS ;
1082: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' stsetup = success');
1083: UPDATE MSC_APPS_INSTANCES
1084: SET ST_STATUS= MSC_UTIL.G_ST_PURGING,
1085: SO_TBL_STATUS= MSC_UTIL.SYS_YES,
1086: LAST_UPDATE_DATE= v_current_date,
1087: LAST_UPDATED_BY= v_current_user,

Line 1098: UPDATE MSC_APPS_INSTANCES

1094:
1095: ---===================== EMPTY ====================
1096: ELSIF pST_STATUS= MSC_UTIL.G_ST_EMPTY THEN
1097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' pST_STATUS= MSC_UTIL.G_ST_EMPTY');
1098: UPDATE MSC_APPS_INSTANCES
1099: SET ST_STATUS= MSC_UTIL.G_ST_EMPTY,
1100: SO_TBL_STATUS= MSC_UTIL.SYS_YES,
1101: LAST_UPDATE_DATE= v_current_date,
1102: LAST_UPDATED_BY= v_current_user,

Line 1112: UPDATE MSC_APPS_INSTANCES

1108:
1109: ---===================== READY ====================
1110: ELSIF pST_STATUS= MSC_UTIL.G_ST_READY THEN
1111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' pST_STATUS= MSC_UTIL.G_ST_READY');
1112: UPDATE MSC_APPS_INSTANCES
1113: SET ST_STATUS= MSC_UTIL.G_ST_READY,
1114: LAST_UPDATE_DATE= v_current_date,
1115: LAST_UPDATED_BY= v_current_user,
1116: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

Line 1138: UPDATE MSC_APPS_INSTANCES mai

1134: PROCEDURE FINAL
1135: IS
1136: BEGIN
1137:
1138: UPDATE MSC_APPS_INSTANCES mai
1139: SET LAST_UPDATE_DATE= v_current_date,
1140: LAST_UPDATED_BY= v_current_user,
1141: SUPPLIES_LOAD_FLAG = null,
1142: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

Line 1436: update msc_apps_instances

1432: -- ============= Execute the task according to its task number ===========
1433:
1434: IF pTASKNUM= TASK_SUPPLY THEN
1435:
1436: update msc_apps_instances
1437: set SUPPLIES_LOAD_FLAG = G_JOB_NOT_DONE
1438: where instance_id = v_instance_id;
1439: commit;
1440:

Line 1482: update msc_apps_instances

1478: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
1479:
1480: END IF;
1481:
1482: update msc_apps_instances
1483: set SUPPLIES_LOAD_FLAG = G_JOB_DONE
1484: where instance_id = v_instance_id;
1485: commit;
1486:

Line 2776: update msc_apps_instances

2772:
2773: ELSIF pTASKNUM= PTASK_SUPPLY THEN
2774: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'ds debug: pTASKNUM= PTASK_SUPPLY ');
2775:
2776: update msc_apps_instances
2777: set SUPPLIES_LOAD_FLAG = G_JOB_NOT_DONE
2778: where instance_id = v_instance_id;
2779: commit;
2780:

Line 2902: update msc_apps_instances

2898: END IF;
2899:
2900: COMMIT;
2901:
2902: update msc_apps_instances
2903: set SUPPLIES_LOAD_FLAG = G_JOB_DONE
2904: where instance_id = v_instance_id;
2905: commit;
2906:

Line 3604: FROM MSC_APPS_INSTANCES

3600: v_current_date,
3601: v_current_user,
3602: v_current_date,
3603: v_current_user
3604: FROM MSC_APPS_INSTANCES
3605: WHERE INSTANCE_ID= pINSTANCE_ID;
3606:
3607: IF pVALIDATION= MSC_UTIL.SYS_YES THEN
3608:

Line 3710: from msc_apps_instances

3706: -- agmcont:
3707: if (v_is_cont_refresh ) then
3708: select lcid
3709: INTO v_last_collection_id
3710: from msc_apps_instances
3711: where instance_id = pINSTANCE_ID;
3712: else
3713: v_last_collection_id:= pLCID;
3714: end if;

Line 4372: UPDATE MSC_APPS_INSTANCES mai

4368: --unless all the related ATP tables are populated
4369:
4370: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so_tbl status to no');
4371: 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
4372: UPDATE MSC_APPS_INSTANCES mai
4373: SET
4374: so_tbl_status= MSC_UTIL.SYS_NO,
4375: LAST_UPDATE_DATE= v_current_date,
4376: LAST_UPDATED_BY= v_current_user,

Line 4688: UPDATE MSC_APPS_INSTANCES mai

4684: END if;
4685:
4686:
4687: if G_TASK_ATP_RULES =1 and G_TASK_SOURCING =1 then
4688: UPDATE MSC_APPS_INSTANCES mai
4689: SET
4690: so_tbl_status= MSC_UTIL.SYS_YES,
4691: LAST_UPDATE_DATE= v_current_date,
4692: LAST_UPDATED_BY= v_current_user,

Line 4783: UPDATE MSC_APPS_INSTANCES mai

4779: ELSE
4780:
4781: lv_task_number:= 0;
4782:
4783: UPDATE MSC_APPS_INSTANCES mai
4784: SET LAST_UPDATE_DATE= v_current_date,
4785: LAST_UPDATED_BY= v_current_user,
4786: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4787: WHERE mai.INSTANCE_ID= v_instance_id;

Line 4972: UPDATE MSC_APPS_INSTANCES

4968:
4969: IF lv_bon_start_end = 3 THEN
4970: MSC_CL_ROUTING_ODS_LOAD.GET_START_END_OP ;
4971: END IF;
4972: UPDATE MSC_APPS_INSTANCES
4973: SET so_tbl_status= MSC_UTIL.SYS_YES
4974: WHERE instance_id= v_instance_id;
4975: /*Resource Start Time*/
4976: -- Set The collections Start Time . Get the start time in the out variable

Line 4981: UPDATE MSC_APPS_INSTANCES

4977: SET_COLLECTIONS_START_TIME(v_instance_id, v_resource_start_time);
4978:
4979: IF RETCODE <> MSC_UTIL.G_ERROR THEN
4980: IF v_coll_prec.ibuc_history_flag = MSC_UTIL.SYS_YES THEN
4981: UPDATE MSC_APPS_INSTANCES
4982: SET LAST_IBUC_COLL_DATE = lv_ibuc_coll_start_time
4983: WHERE INSTANCE_ID= pINSTANCE_ID;
4984: END IF;
4985: END IF;

Line 5115: FROM MSC_APPS_INSTANCES

5111: SELECT DECODE(M2A_DBLINK,
5112: NULL,'',
5113: '@'||M2A_DBLINK)
5114: INTO lv_dblink
5115: FROM MSC_APPS_INSTANCES
5116: WHERE INSTANCE_ID=v_instance_id;
5117: lv_sql_stmt:=
5118: 'BEGIN MRP_CL_REFRESH_SNAPSHOT.PURGE_OBSOLETE_DATA'||lv_dblink||';END;';
5119:

Line 6167: UPDATE MSC_APPS_INSTANCES mai

6163: end if;
6164:
6165: if (v_is_partial_refresh) then
6166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so_tbl status to no');
6167: UPDATE MSC_APPS_INSTANCES mai
6168: SET
6169: so_tbl_status= MSC_UTIL.SYS_NO,
6170: LAST_UPDATE_DATE= v_current_date,
6171: LAST_UPDATED_BY= v_current_user,

Line 6199: UPDATE MSC_APPS_INSTANCES mai

6195:
6196: /* SCE Change ends */
6197:
6198: 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
6199: UPDATE MSC_APPS_INSTANCES mai
6200: SET
6201: so_tbl_status= MSC_UTIL.SYS_YES,
6202: LAST_UPDATE_DATE= v_current_date,
6203: LAST_UPDATED_BY= v_current_user,

Line 6431: UPDATE MSC_APPS_INSTANCES mai

6427:
6428: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so_tbl status to no');
6429: 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)
6430: AND (v_coll_prec.tp_vendor_flag = MSC_UTIL.SYS_NO AND v_coll_prec.tp_customer_flag = MSC_UTIL.SYS_NO))) then
6431: UPDATE MSC_APPS_INSTANCES mai
6432: SET
6433: so_tbl_status= MSC_UTIL.SYS_NO,
6434: LAST_UPDATE_DATE= v_current_date,
6435: LAST_UPDATED_BY= v_current_user,

Line 6505: UPDATE MSC_APPS_INSTANCES mai

6501: end if;
6502:
6503: 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
6504: if G_TASK_ATP_RULES =1 and G_TASK_SOURCING =1 then
6505: UPDATE MSC_APPS_INSTANCES mai
6506: SET
6507: so_tbl_status= MSC_UTIL.SYS_YES,
6508: LAST_UPDATE_DATE= v_current_date,
6509: LAST_UPDATED_BY= v_current_user,

Line 6519: UPDATE MSC_APPS_INSTANCES mai

6515: G_TASK_SOURCING :=0;
6516: end if;
6517: 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
6518: if G_TASK_SOURCING =1 then
6519: UPDATE MSC_APPS_INSTANCES mai
6520: SET
6521: so_tbl_status= MSC_UTIL.SYS_YES,
6522: LAST_UPDATE_DATE= v_current_date,
6523: LAST_UPDATED_BY= v_current_user,

Line 6532: UPDATE MSC_APPS_INSTANCES mai

6528: G_TASK_SOURCING :=0;
6529: end if;
6530: 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
6531: if G_TASK_ATP_RULES =1 then
6532: UPDATE MSC_APPS_INSTANCES mai
6533: SET
6534: so_tbl_status= MSC_UTIL.SYS_YES,
6535: LAST_UPDATE_DATE= v_current_date,
6536: LAST_UPDATED_BY= v_current_user,

Line 6633: UPDATE MSC_APPS_INSTANCES mai

6629: ELSE
6630:
6631: lv_task_number:= 0;
6632:
6633: UPDATE MSC_APPS_INSTANCES mai
6634: SET LAST_UPDATE_DATE= v_current_date,
6635: LAST_UPDATED_BY= v_current_user,
6636: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
6637: WHERE mai.INSTANCE_ID= v_instance_id;

Line 6933: UPDATE MSC_APPS_INSTANCES

6929: IF lv_bon_start_end_partial = 3 then
6930: MSC_CL_ROUTING_ODS_LOAD.GET_START_END_OP_PARTIAL ;
6931: END IF;
6932:
6933: UPDATE MSC_APPS_INSTANCES
6934: SET so_tbl_status= MSC_UTIL.SYS_YES
6935: WHERE instance_id= v_instance_id;
6936: /* Resource Start Time*/
6937: -- Set The collections Start Time . Get the start time in the out variable

Line 6942: UPDATE MSC_APPS_INSTANCES

6938: SET_COLLECTIONS_START_TIME(v_instance_id, v_resource_start_time);
6939:
6940: IF RETCODE <> MSC_UTIL.G_ERROR THEN
6941: IF v_coll_prec.ibuc_history_flag = MSC_UTIL.SYS_YES THEN
6942: UPDATE MSC_APPS_INSTANCES
6943: SET LAST_IBUC_COLL_DATE = lv_ibuc_coll_start_time
6944: WHERE INSTANCE_ID= pINSTANCE_ID;
6945: END IF;
6946: END IF;

Line 7636: FROM msc_apps_instances

7632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
7633:
7634: SELECT instance_id
7635: INTO lv_instance_id
7636: FROM msc_apps_instances
7637: WHERE upper(instance_code) = p_instance_code;
7638:
7639: IF MSC_CL_EXCHANGE_PARTTBL.Initialize( lv_instance_id,
7640: p_instance_code,