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_RPO_PULL dependencies on MSC_UTIL

Line 16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;

12: v_temp_sql3 VARCHAR2(1000);
13: v_temp_sql4 VARCHAR2(1000);
14:
15: --NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
17:
18: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
19: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;
20: v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;

Line 18: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;

14:
15: --NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
17:
18: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
19: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;
20: v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;
21:
22:

Line 19: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;

15: --NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
17:
18: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
19: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;
20: v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;
21:
22:
23: PROCEDURE LOAD_IRO IS

Line 20: v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;

16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
17:
18: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
19: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;
20: v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;
21:
22:
23: PROCEDURE LOAD_IRO IS
24: BEGIN

Line 36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' MSC_CL_PULL.g_last_succ_iro_ref_time:'||to_char(MSC_CL_PULL.g_last_succ_iro_ref_time,'DD-MON-YYYY hh:mi:ss'));

32: ELSE
33: v_temp_sql1 := ' AND x.RO_STATUS_CODE <> '||'''C''';
34:
35: END IF;
36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' MSC_CL_PULL.g_last_succ_iro_ref_time:'||to_char(MSC_CL_PULL.g_last_succ_iro_ref_time,'DD-MON-YYYY hh:mi:ss'));
37: v_sql_stmt := ' INSERT INTO MSC_ST_SUPPLIES '
38: ||' ( DISPOSITION_ID, '
39: ||' ORDER_TYPE, '
40: ||' ORDER_NUMBER, '

Line 92: ||' where x.organization_id '||MSC_UTIL.v_depot_org_str

88: ||' :v_item_type_good ,'
89: ||' :v_refresh_id ,'
90: ||' :v_instance_id'
91: ||' from MRP_AP_REPAIR_ORDERS_V'||MSC_CL_PULL.v_dblink ||' x'
92: ||' where x.organization_id '||MSC_UTIL.v_depot_org_str
93: || v_temp_sql1
94: ;
95:
96:

Line 98: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

94: ;
95:
96:
97:
98: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
99:
100:
101: IF MSC_CL_PULL.v_lrnn<> -1 THEN
102: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ,MSC_CL_PULL.g_last_succ_iro_ref_time;

Line 120: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698

116: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
117: MSC_CL_PULL.v_view_name := 'MRP_AP_REPAIR_DEMAND_V';
118:
119:
120: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698
121:
122: v_temp_sql1:= ' AND ((x.date1>:g_last_succ_iro_ref_time) OR (x.date2> :g_last_succ_iro_ref_time) OR (x.RN1>'
123: || MSC_CL_PULL.v_lrnn ||
124: ') OR (x.RN2>' || MSC_CL_PULL.v_lrnn ||

Line 182: || ' where x.organization_id '||MSC_UTIL.v_depot_org_str

178: ||' :v_item_type_good,'
179: ||' :v_refresh_id ,'
180: ||' :v_instance_id'
181: || ' from MRP_AP_REPAIR_DEMAND_V'|| MSC_CL_PULL.v_dblink ||' x'
182: || ' where x.organization_id '||MSC_UTIL.v_depot_org_str
183: || v_temp_sql1
184: ;
185:
186: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

Line 186: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

182: || ' where x.organization_id '||MSC_UTIL.v_depot_org_str
183: || v_temp_sql1
184: ;
185:
186: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
187:
188:
189: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
190: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id,

Line 189: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN

185:
186: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
187:
188:
189: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
190: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id,
191: MSC_CL_PULL.v_instance_id,MSC_CL_PULL.g_last_succ_iro_ref_time,MSC_CL_PULL.g_last_succ_iro_ref_time ;
192: ELSE
193: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;

Line 201: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698

197: END IF;
198:
199: COMMIT;
200:
201: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698
202: BEGIN
203: v_temp_sql:=
204: 'insert into MSC_ST_DEMANDS'
205: ||' ( REPAIR_LINE_ID,'

Line 235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' LOAD_IRO_DEMAND ');

231: MSC_CL_PULL.g_last_succ_iro_ref_time ;
232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' LOAD_IRO_DEMAND ');
236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
237: RAISE;
238: END;
239: END IF; -- incremental refresh

Line 236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' LOAD_IRO_DEMAND ');
236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
237: RAISE;
238: END;
239: END IF; -- incremental refresh
240: COMMIT;

Line 268: ||' AND organization_id '||MSC_UTIL.v_non_depot_org_str;

264: ||' :v_refresh_id,'
265: ||' :v_instance_id'
266: ||' from MRP_AD_ERO_WIP_JOB_SUPP_V'||MSC_CL_PULL.v_dblink||' x'
267: ||' where x.RN> :v_lrn '
268: ||' AND organization_id '||MSC_UTIL.v_non_depot_org_str;
269:
270:
271:
272: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

Line 272: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

268: ||' AND organization_id '||MSC_UTIL.v_non_depot_org_str;
269:
270:
271:
272: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
273:
274: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, v_sql_stmt);
275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_instance_id);
276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_lrnn);

Line 274: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, v_sql_stmt);

270:
271:
272: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
273:
274: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, v_sql_stmt);
275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_instance_id);
276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_lrnn);
277:
278:

Line 275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_instance_id);

271:
272: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
273:
274: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, v_sql_stmt);
275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_instance_id);
276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_lrnn);
277:
278:
279: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_lrnn);

272: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
273:
274: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, v_sql_stmt);
275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_instance_id);
276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_lrnn);
277:
278:
279: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
280: MSC_CL_PULL.v_lrnn;

Line 384: ||' where x.organization_id '||MSC_UTIL.v_non_depot_org_str

380: ||' :v_item_type_good,'
381: ||' :v_refresh_id,'
382: ||' :v_instance_id'
383: ||' from MRP_AP_ERO_WIP_JOB_SUPPLY_V'||MSC_CL_PULL.v_dblink ||' x'
384: ||' where x.organization_id '||MSC_UTIL.v_non_depot_org_str
385: || ' AND (x.RN1 > :v_lrn or x.RN2 > :v_lrn or x.RN3 >:v_lrn)'
386: ;
387:
388:

Line 391: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

387:
388:
389:
390:
391: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
392: Execute Immediate v_sql_stmt
393: using
394: MSC_CL_PULL.v_mps_consume_profile_value,
395: MSC_CL_PULL.v_dgmt,

Line 438: ||' AND organization_id '||MSC_UTIL.v_non_depot_org_str;

434: ||' :v_refresh_id,'
435: ||' :v_instance_id'
436: ||' from MRP_AD_ERO_WIP_COMP_DEM_V'||MSC_CL_PULL.v_dblink||' x'
437: ||' where x.RN> :v_lrn '
438: ||' AND organization_id '||MSC_UTIL.v_non_depot_org_str;
439:
440: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
441:
442: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 440: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

436: ||' from MRP_AD_ERO_WIP_COMP_DEM_V'||MSC_CL_PULL.v_dblink||' x'
437: ||' where x.RN> :v_lrn '
438: ||' AND organization_id '||MSC_UTIL.v_non_depot_org_str;
439:
440: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
441:
442: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
443: MSC_CL_PULL.v_lrnn;
444: END IF;

Line 513: || ' where x.organization_id '||MSC_UTIL.v_non_depot_org_str

509: ||' :v_item_type_good,'
510: ||' :v_refresh_id,'
511: ||' :v_instance_id'
512: || ' from MRP_AP_ERO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink ||' x'
513: || ' where x.organization_id '||MSC_UTIL.v_non_depot_org_str
514: || ' AND (x.RN1 > :v_lrn or x.RN2 > :v_lrn or x.RN3 >:v_lrn)'
515: ;
516:
517:

Line 518: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

514: || ' AND (x.RN1 > :v_lrn or x.RN2 > :v_lrn or x.RN3 >:v_lrn)'
515: ;
516:
517:
518: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
519: Execute Immediate v_sql_stmt using
520: MSC_CL_PULL.v_dgmt,
521: MSC_CL_PULL.v_dgmt,
522: v_item_type_id,