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

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

13: v_temp_eam_sql VARCHAR2(1000);
14: v_rounding_Sql varchar2(1000);
15:
16: --NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
17: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
18: -- ===============================================================
19:
20: PROCEDURE LOAD_BOM IS
21: v_applsys_schema VARCHAR2(32);

Line 30: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN

26: BEGIN
27: lv_retval := FND_INSTALLATION.GET_APP_INFO (
28: 'FND', lv_dummy1, lv_dummy2, v_applsys_schema);
29:
30: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
31:
32: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
33: v_temp_sql1 := ' x.BASIS_TYPE, x.Old_Component_Sequence_ID,';
34: ELSE

Line 32: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

28: 'FND', lv_dummy1, lv_dummy2, v_applsys_schema);
29:
30: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
31:
32: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
33: v_temp_sql1 := ' x.BASIS_TYPE, x.Old_Component_Sequence_ID,';
34: ELSE
35: v_temp_sql1 := ' NULL, NULL,';
36: END IF;

Line 44: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

40:
41: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOM_COMPONENTS';
42: MSC_CL_PULL.v_view_name := 'MRP_AD_BOM_COMPONENTS_V';
43:
44: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
45: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
46: ELSE
47: v_temp_sql := NULL;
48: END IF;

Line 45: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

41: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOM_COMPONENTS';
42: MSC_CL_PULL.v_view_name := 'MRP_AD_BOM_COMPONENTS_V';
43:
44: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
45: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
46: ELSE
47: v_temp_sql := NULL;
48: END IF;
49:

Line 78: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

74: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOM_COMPONENTS';
75:
76:
77:
78: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
79: v_rounding_sql := 'decode(x.rounding_direction,0,3,1,2,2,1,3),';
80: ELSE
81: v_rounding_sql :='3,';
82: END IF ;

Line 86: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

82: END IF ;
83:
84: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
85:
86: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
87: MSC_CL_PULL.v_view_name := 'MRP_AN_BOM_COMPONENTS_V';
88: ELSE
89: MSC_CL_PULL.v_view_name := 'MRP_AP_BOM_COMPONENTS_V';
90: END IF;

Line 125: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

121: || v_temp_sql1
122: ||' :v_refresh_id,'
123: ||' :v_instance_id'
124: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
125: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
126: ||' AND ( x.RN2> :v_lrn )'
127: /* NCP
128: ||' UNION '
129: ||' select '

Line 156: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

152: || v_rounding_sql
153: ||' :v_refresh_id,'
154: ||' :v_instance_id'
155: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
156: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
157: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'
158: */
159:
160: ||' UNION '

Line 190: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

186: || v_temp_sql1
187: ||' :v_refresh_id,'
188: ||' :v_instance_id'
189: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
190: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
191: ||' AND ( x.RN3> :v_lrn )'
192: ||' UNION '
193: ||' select '
194: ||' x.COMPONENT_SEQUENCE_ID,'

Line 222: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

218: || v_temp_sql1
219: ||' :v_refresh_id,'
220: ||' :v_instance_id'
221: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
222: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
223: ||' AND ( x.RN4> :v_lrn )';
224: /*
225: ||' UNION '
226: ||' select '

Line 253: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

249: || v_rounding_sql
250: ||' :v_refresh_id,'
251: ||' :v_instance_id'
252: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
253: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
254: ||' AND ( x.RN6>'||MSC_CL_PULL.v_lrn||')' ;
255: */
256:
257: ELSE

Line 321: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

317: || v_temp_sql1
318: ||' :v_refresh_id,'
319: ||' :v_instance_id'
320: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
321: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
322: || v_union_sql ;
323:
324: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
325:

Line 351: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

347:
348: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOMS';
349: MSC_CL_PULL.v_view_name := 'MRP_AD_BOMS_V';
350:
351: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
352: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
353: ELSE
354: v_temp_sql := NULL;
355: END IF;

Line 352: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

348: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOMS';
349: MSC_CL_PULL.v_view_name := 'MRP_AD_BOMS_V';
350:
351: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
352: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
353: ELSE
354: v_temp_sql := NULL;
355: END IF;
356:

Line 400: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

396: ||' 2,'
397: ||' :v_refresh_id,'
398: ||' :v_instance_id'
399: ||' FROM MRP_AP_BOMS_V'||MSC_CL_PULL.v_dblink||' x'
400: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
401: ||' AND (x.RN2 > :v_lrn)';
402:
403: ELSE
404: v_union_sql := ' ';

Line 435: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

431: ||' 2,'
432: ||' :v_refresh_id,'
433: ||' :v_instance_id'
434: ||' FROM MRP_AP_BOMS_V'||MSC_CL_PULL.v_dblink||' x'
435: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
436: || v_union_sql;
437:
438: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
439:

Line 451: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

447:
448:
449: COMMIT;
450:
451: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
452: --=================== Net Change Mode: Delete ==================
453: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
454:
455: MSC_CL_PULL.v_table_name:= 'MSC_ST_COMPONENT_SUBSTITUTES';

Line 474: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str

470: ||' 1,'
471: ||' :v_refresh_id,'
472: ||' :v_instance_id'
473: ||' FROM MRP_AD_SUB_COMPS_V'||MSC_CL_PULL.v_dblink||' x'
474: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
475: ||' AND x.RN > :v_lrn';
476:
477: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
478:

Line 491: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

487: MSC_CL_PULL.v_view_name := 'MRP_AP_COMPONENT_SUBSTITUTES_V';
488:
489:
490:
491: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
492: v_rounding_sql := 'decode(x.rounding_direction,0,3,1,2,2,1,3),';
493: v_rounding_sql :='3,';
494: END IF ;
495:

Line 530: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

526: || v_rounding_sql
527: ||' :v_refresh_id,'
528: ||' :v_instance_id'
529: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
530: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
531: ||' AND (x.RN2 > :v_lrn)'
532: ||' UNION '
533: ||' SELECT'
534: ||' x.BILL_SEQUENCE_ID,'

Line 560: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

556: || v_rounding_sql
557: ||' :v_refresh_id,'
558: ||' :v_instance_id'
559: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
560: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
561: ||' AND (x.RN3 > :v_lrn)'
562: ||' UNION '
563: ||' SELECT'
564: ||' x.BILL_SEQUENCE_ID,'

Line 590: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

586: || v_rounding_sql
587: ||' :v_refresh_id,'
588: ||' :v_instance_id'
589: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
590: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
591: ||' AND (x.RN4 > :v_lrn)';
592:
593: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
594:

Line 593: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

589: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
590: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
591: ||' AND (x.RN4 > :v_lrn)';
592:
593: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
594:
595: v_union_sql :=
596: v_union_sql||' UNION '
597: ||' SELECT'

Line 624: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

620: || v_rounding_sql
621: ||' :v_refresh_id,'
622: ||' :v_instance_id'
623: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
624: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
625: ||' AND (x.RN5 > :v_lrn)';
626:
627:
628: END IF;

Line 674: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

670: || v_rounding_sql
671: ||' :v_refresh_id,'
672: ||' :v_instance_id'
673: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
674: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
675: || v_union_sql;
676:
677:
678: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 680: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

676:
677:
678: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
679:
680: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
681:
682: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_bom_subst_priority,MSC_CL_PULL.v_refresh_id,MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_lrn,
683: MSC_CL_PULL.v_msc_bom_subst_priority,MSC_CL_PULL.v_refresh_id,MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_lrn,
684: MSC_CL_PULL.v_msc_bom_subst_priority,MSC_CL_PULL.v_refresh_id,MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_lrn,

Line 705: if MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN /osfm change/

701:
702: COMMIT;
703:
704:
705: if MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN /*osfm change*/
706: select instance_code into lv_icode from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;
707: BEGIN
708:
709: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

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

716: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);
717:
718: EXCEPTION
719: WHEN OTHERS THEN
720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
721:
722: END;
723: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOM_COMPONENTS');
724:

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

732: 'drop index MSC_ST_BOM_COMPONENTS_'||lv_icode,
733: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);
734: EXCEPTION
735: WHEN OTHERS THEN
736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
737:
738: END;
739:
740: End If;

Line 752: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN

748: PROCEDURE LOAD_PROCESS_EFFECTIVITY IS
749: v_get_apps_ver number;
750: BEGIN
751:
752: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
753: --=================== Net Change Mode: Delete ==================
754: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
755:
756: MSC_CL_PULL.v_table_name:= 'MSC_ST_PROCESS_EFFECTIVITY';

Line 780: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

776: ||' :v_refresh_id,'
777: ||' :v_instance_id'
778: ||' FROM MRP_AD_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
779: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
780: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
781:
782: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
783:
784: COMMIT;

Line 826: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

822: ||' 2,'
823: ||' :v_refresh_id,'
824: ||' :v_instance_id'
825: ||' FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
826: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
827: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn||')'
828: */
829:
830: ||' UNION '

Line 862: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

858: ||' 2,'
859: ||' :v_refresh_id,'
860: ||' :v_instance_id'
861: ||' FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
862: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
863: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'
864: ||' UNION '
865: ||' SELECT'
866: ||' x.INVENTORY_ITEM_ID,'

Line 896: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

892: ||' 2,'
893: ||' :v_refresh_id,'
894: ||' :v_instance_id'
895: ||' FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
896: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
897: ||' AND ( x.RN4>'||MSC_CL_PULL.v_lrn||')';
898: /*
899: ||' UNION '
900: ||' SELECT'

Line 931: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

927: ||' 2,'
928: ||' :v_refresh_id,'
929: ||' :v_instance_id'
930: ||' FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
931: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
932: ||' AND ( x.RN5>'||MSC_CL_PULL.v_lrn||')' ;
933: */
934: ELSE
935: v_union_sql :=

Line 990: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

986: ||' 2,'
987: ||' :v_refresh_id,'
988: ||' :v_instance_id'
989: ||' FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
990: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
991: || v_union_sql ;
992:
993: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
994:

Line 1056: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1052: ||' 2,'
1053: ||' :v_refresh_id,'
1054: ||' :v_instance_id'
1055: ||' from MRP_AP_BILL_OF_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
1056: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1057: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1058: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
1059:
1060: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1108: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1104: ||' :v_refresh_id,'
1105: ||' :v_instance_id'
1106: ||' from MRP_AP_CRP_RESOURCE_HOURS_V'||MSC_CL_PULL.v_dblink||' x'
1107: ||' WHERE DECODE( :WIP_ENABLED, 2, LINE_ID) IS NULL'
1108: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1109: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
1110: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1111: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1112:

Line 1143: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1139: BEGIN
1140:
1141: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEPARTMENT_RESOURCES';
1142: MSC_CL_PULL.v_view_name := 'MRP_AP_DEPARTMENT_RESOURCES_V';
1143: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1144: v_temp_atp_rule_sql := 'x.ATP_RULE_ID,x.SCHEDULE_TO_INSTANCE,x.BATCHING_PENALTY,x.SETUP_TIME_PERCENT,x.UTILIZATION_CHANGE_PERCENT,x.SETUP_TIME_TYPE,x.UTILIZATION_CHANGE_TYPE,x.IDLE_TIME_TOLERANCE,x.SDS_SCHEDULING_WINDOW,';
1145: ELSE
1146: v_temp_atp_rule_sql := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1147: END IF;

Line 1148: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1144: v_temp_atp_rule_sql := 'x.ATP_RULE_ID,x.SCHEDULE_TO_INSTANCE,x.BATCHING_PENALTY,x.SETUP_TIME_PERCENT,x.UTILIZATION_CHANGE_PERCENT,x.SETUP_TIME_TYPE,x.UTILIZATION_CHANGE_TYPE,x.IDLE_TIME_TOLERANCE,x.SDS_SCHEDULING_WINDOW,';
1145: ELSE
1146: v_temp_atp_rule_sql := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1147: END IF;
1148: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1149: v_temp_atp_rule_sql1 := 'x.ATP_RULE_ID,x.SETUP_TIME_PERCENT,x.UTILIZATION_CHANGE_PERCENT,x.SETUP_TIME_TYPE,x.UTILIZATION_CHANGE_TYPE,';
1150: ELSE
1151: v_temp_atp_rule_sql1 := 'NULL,NULL,NULL,NULL,NULL,';
1152: END IF;

Line 1159: IF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN

1155: /* The code is forked since the Resource Batching flexfields are replaced by the columns
1156: in Patchset - G for 11i source only
1157: */
1158:
1159: IF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN
1160: v_sql_stmt:=
1161: ' insert into MSC_ST_DEPARTMENT_RESOURCES'
1162: ||' ( RESOURCE_ID,'
1163: ||' DEPARTMENT_ID,'

Line 1295: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1291: ||' :v_refresh_id,'
1292: || v_temp_atp_rule_sql
1293: ||' :v_instance_id'
1294: ||' from MRP_AP_DEPARTMENT_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
1295: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1296:
1297: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_aggreg_res_name,
1298: MSC_CL_PULL.v_msc_aggreg_res_name,
1299: MSC_CL_PULL.v_dgmt,

Line 1514: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1510: ||' :v_refresh_id,'
1511: || v_temp_atp_rule_sql
1512: ||' :v_instance_id'
1513: ||' FROM MRP_AP_DEPARTMENT_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
1514: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1515:
1516: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_aggreg_res_name,
1517: MSC_CL_PULL.v_msc_aggreg_res_name,
1518: MSC_CL_PULL.v_dgmt,

Line 1532: IF ((MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) OR (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES)) THEN

1528: END IF;
1529:
1530: COMMIT;
1531:
1532: IF ((MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) OR (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES)) THEN
1533:
1534: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEPARTMENT_RESOURCES';
1535: MSC_CL_PULL.v_view_name := 'MRP_AP_LINE_RESOURCES_V';
1536:

Line 1605: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1601: ||' :v_refresh_id,'
1602: || v_temp_atp_rule_sql1
1603: ||' :v_instance_id'
1604: ||' from MRP_AP_LINE_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
1605: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1606: || v_union_sql;
1607:
1608: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1609:

Line 1645: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1641: ||' 2,'
1642: ||' :v_refresh_id,'
1643: ||' :v_instance_id'
1644: ||' from MRP_AP_SIMULATION_SETS_V'||MSC_CL_PULL.v_dblink||' x'
1645: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1646:
1647: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1648:
1649: COMMIT;

Line 1685: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN

1681: COMMIT;
1682:
1683: END IF;
1684:
1685: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN
1686:
1687: IF (nvl(fnd_profile.value('MSC_INFLATE_WIP') ,'N')= 'N') THEN
1688: lv_inflate_wip := 2 ;
1689: ELSE

Line 1696: IF lv_inflate_wip = 1 AND MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1692:
1693: -- if the profile MSC_INFLATE_WIP is set to YES then inflating the operation resource hours by
1694: -- efficiency and utilization. Not inflating the operation resource hours for SDS records.
1695: -- for bug fix 2877975. Lot based jobs should get inflated irrespective of the profile.
1696: IF lv_inflate_wip = 1 AND MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1697: v_res_hrs_sql := ' decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) ,';
1698: v_res_hrs_left := ' AND (x.ENTITY_TYPE <>5 or decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) - x.HOURS_EXPENDED >0) ';
1699: v_touch_time := ' decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) ,';
1700: ELSIF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

Line 1700: ELSIF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1696: IF lv_inflate_wip = 1 AND MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1697: v_res_hrs_sql := ' decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) ,';
1698: v_res_hrs_left := ' AND (x.ENTITY_TYPE <>5 or decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) - x.HOURS_EXPENDED >0) ';
1699: v_touch_time := ' decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) ,';
1700: ELSIF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1701: v_res_hrs_sql := ' decode(x.entity_type,5, (decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED)),x.OPERATION_HOURS_REQUIRED),';
1702: v_res_hrs_left := ' AND (x.ENTITY_TYPE <>5 or decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) - x.HOURS_EXPENDED > 0) ';
1703: v_touch_time := ' decode(x.entity_type,5, (decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.efficiency),x.OPERATION_HOURS_REQUIRED)),x.OPERATION_HOURS_REQUIRED),';
1704: ELSE

Line 1710: -- Pulling parent_seq_num and SETUP_ID from MRP_AP_RESOURCE_REQUIREMENTS_V if MSC_CL_PULL.v_apps_ver is MSC_UTIL.G_APPS115

1706: v_res_hrs_left := ' AND (x.ENTITY_TYPE <>5 or x.OPERATION_HOURS_REQUIRED - x.HOURS_EXPENDED > 0 ) ';
1707: v_touch_time := ' x.OPERATION_HOURS_REQUIRED ,';
1708: END IF;
1709:
1710: -- Pulling parent_seq_num and SETUP_ID from MRP_AP_RESOURCE_REQUIREMENTS_V if MSC_CL_PULL.v_apps_ver is MSC_UTIL.G_APPS115
1711: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1712: v_temp_parent_seq := 'x.PARENT_SEQ_NUM,x.SETUP_ID, x.ORIG_RESOURCE_SEQ_NUM,GROUP_SEQUENCE_ID,GROUP_SEQUENCE_NUMBER,BATCH_NUMBER,MAXIMUM_ASSIGNED_UNITS, ';
1713: ELSE
1714: v_temp_parent_seq := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,';

Line 1711: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1707: v_touch_time := ' x.OPERATION_HOURS_REQUIRED ,';
1708: END IF;
1709:
1710: -- Pulling parent_seq_num and SETUP_ID from MRP_AP_RESOURCE_REQUIREMENTS_V if MSC_CL_PULL.v_apps_ver is MSC_UTIL.G_APPS115
1711: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1712: v_temp_parent_seq := 'x.PARENT_SEQ_NUM,x.SETUP_ID, x.ORIG_RESOURCE_SEQ_NUM,GROUP_SEQUENCE_ID,GROUP_SEQUENCE_NUMBER,BATCH_NUMBER,MAXIMUM_ASSIGNED_UNITS, ';
1713: ELSE
1714: v_temp_parent_seq := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1715: END IF;

Line 1717: If MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then

1713: ELSE
1714: v_temp_parent_seq := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1715: END IF;
1716:
1717: If MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then
1718: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
1719: where instance_id = MSC_CL_PULL.v_instance_id ;
1720: end if;
1721:

Line 1728: if MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' and MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120 then

1724:
1725: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_REQUIREMENTS';
1726: --MSC_CL_PULL.v_view_name := 'MRP_AD_RESOURCE_REQUIREMENTS_V';
1727: -- bug5996354
1728: if MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' and MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120 then
1729: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_IRO_ERO_RES_REQ_V';
1730: else
1731: MSC_CL_PULL.v_view_name := 'MRP_AD_RESOURCE_REQUIREMENTS_V';
1732: end if;

Line 1735: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1731: MSC_CL_PULL.v_view_name := 'MRP_AD_RESOURCE_REQUIREMENTS_V';
1732: end if;
1733: --
1734:
1735: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1736: v_temp_sql1 := ' x.RESOURCE_SEQ_NUM, ';
1737: ELSE
1738: v_temp_sql1 := ' NULL, ';
1739: END IF;

Line 1743: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1739: END IF;
1740:
1741: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
1742:
1743: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1744: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1745:
1746: if lv_lbj_details = 1 Then
1747: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';

Line 1744: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1740:
1741: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
1742:
1743: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1744: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1745:
1746: if lv_lbj_details = 1 Then
1747: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';
1748: end if;

Line 1788: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then

1784: MSC_CL_PULL.v_mps_consume_profile_value;
1785:
1786: COMMIT;
1787:
1788: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then
1789:
1790: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';
1791: MSC_CL_PULL.v_view_name := 'MRP_AD_DJOB_SUB_OP_RESOURCES_V';
1792:

Line 1848: if MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' and MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120 then

1844: ||' x.net_quantity), '
1845: ||' x.net_quantity) > 0' ;
1846: END IF;
1847: -- bug5996354
1848: if MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' and MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120 then
1849: MSC_CL_PULL.v_view_name := 'MRP_AP_NON_IRO_ERO_RES_REQ_V';
1850: else
1851: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_REQUIREMENTS_V';
1852: end if;

Line 1853: IF MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS121 THEN

1849: MSC_CL_PULL.v_view_name := 'MRP_AP_NON_IRO_ERO_RES_REQ_V';
1850: else
1851: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_REQUIREMENTS_V';
1852: end if;
1853: IF MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS121 THEN
1854: v_temp_sql1 := ' x.Operation_Code,'
1855: ||' (CASE WHEN x.maintenance_object_source in (1,2) THEN '
1856: ||' to_date(substr(x.WO_ACTUAL_DATES,instr(x.WO_ACTUAL_DATES,''#'')+1),''DD-MON-YYYY'')'
1857: ||' END), ';

Line 1863: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1859: v_temp_sql1 := 'NULL,NULL,';
1860: END IF;
1861:
1862: /* set the MTQ , Firm Flag, Scheduled flag */
1863: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1864: IF lv_lbj_details =1 Then
1865: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,x.scheduled_flag, x.QUANTITY_IN_QUEUE, x.QUANTITY_RUNNING, x.QUANTITY_WAITING_TO_MOVE, x.QUANTITY_COMPLETED,'
1866: ||' decode(x.ENTITY_TYPE,5,x.COPY_YIELD, x.YIELD), x.USAGE_RATE, x.Copy_op_seq_num, decode(x.ENTITY_TYPE,5,copy_STANDARD_OPERATION_CODE,Standard_Operation_Code), x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, ';
1867: v_temp_sql := v_temp_sql

Line 1879: IF MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS121 THEN

1875: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,x.scheduled_flag, x.QUANTITY_IN_QUEUE, x.QUANTITY_RUNNING, x.QUANTITY_WAITING_TO_MOVE, x.QUANTITY_COMPLETED,'
1876: ||' x.YIELD, x.USAGE_RATE, x.Operation_Seq_Num, x.Standard_Operation_Code, x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, x.ACTUAL_START_DATE, x.ROUTING_SEQUENCE_ID,';
1877: lv_cond_sql := ' AND (x.ENTITY_TYPE <> 5 OR x.OPERATION_SEQUENCE_ID is not null) ';
1878: END IF;
1879: IF MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS121 THEN
1880: v_temp_sql := v_temp_sql||'x.description,';
1881: ELSE
1882: v_temp_sql := v_temp_sql||'NULL,';
1883: END IF;

Line 1884: ELSIF MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 THEN

1880: v_temp_sql := v_temp_sql||'x.description,';
1881: ELSE
1882: v_temp_sql := v_temp_sql||'NULL,';
1883: END IF;
1884: ELSIF MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 THEN
1885: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL,NULL, ';
1886: ELSE
1887: v_temp_sql := ' NULL ,NULL ,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL,NULL, ';
1888: END IF;

Line 1891: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER and MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN

1887: v_temp_sql := ' NULL ,NULL ,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL,NULL, ';
1888: END IF;
1889:
1890: /*USAF starts*/
1891: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER and MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN
1892: v_temp_eam_sql := 'x.SHUTDOWN_TYPE,';
1893: ELSE
1894: v_temp_eam_sql := 'NULL,';
1895: END IF;

Line 1945: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1941: || v_touch_time
1942: || v_temp_sql1
1943: ||' :v_instance_id'
1944: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
1945: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1946: /*Bug#4704457 ||' AND DECODE( x.wip_job_type, '
1947: ||' 1, DECODE( :v_mps_consume_profile_value, '
1948: ||' 1, x.mps_net_quantity,'
1949: ||' x.net_quantity), '

Line 1987: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1983: || v_touch_time
1984: || v_temp_sql1
1985: ||' :v_instance_id'
1986: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
1987: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1988: /*Bug#4704457 ||' AND DECODE( x.wip_job_type, '
1989: ||' 1, DECODE( :v_mps_consume_profile_value, '
1990: ||' 1, x.mps_net_quantity,'
1991: ||' x.net_quantity), '

Line 2090: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2086: || v_touch_time
2087: || v_temp_sql1
2088: ||' :v_instance_id'
2089: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
2090: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2091: /*Bug#4704457 ||' AND DECODE( x.wip_job_type, '
2092: ||' 1, DECODE( :v_mps_consume_profile_value, '
2093: ||' 1, x.mps_net_quantity,'
2094: ||' x.net_quantity), '

Line 2134: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then

2130: MSC_CL_PULL.v_hour_uom;
2131: END IF;
2132: COMMIT;
2133:
2134: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then
2135:
2136: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RESOURCES';
2137: MSC_CL_PULL.v_view_name := 'MRP_AP_DJOB_SUB_OP_RESOURCES_V';
2138:

Line 2190: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2186: ||' x.SETUP_ID,'
2187: ||' 2,'
2188: ||' :v_refresh_id'
2189: ||' FROM MRP_AP_DJOB_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2190: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2191: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2192: ||' OR x.RN2>' || MSC_CL_PULL.v_lrn
2193: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2194:

Line 2199: END IF; /* MSC_UTIL.G_APPS115 */

2195: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2196:
2197: COMMIT;
2198:
2199: END IF; /* MSC_UTIL.G_APPS115 */
2200:
2201:
2202: END IF; -- MSC_CL_PULL.WIP_ENABLED
2203:

Line 2218: IF ( ((MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) OR (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES)) AND

2214: lv_op_seq_num VARCHAR2(100) := null;
2215:
2216: BEGIN
2217:
2218: IF ( ((MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) OR (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES)) AND
2219: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN
2220: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEPT_RES_INSTANCES';
2221: MSC_CL_PULL.v_view_name := 'MRP_AP_DEPT_RES_INSTANCES_V';
2222:

Line 2219: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN

2215:
2216: BEGIN
2217:
2218: IF ( ((MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) OR (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES)) AND
2219: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN
2220: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEPT_RES_INSTANCES';
2221: MSC_CL_PULL.v_view_name := 'MRP_AP_DEPT_RES_INSTANCES_V';
2222:
2223: v_sql_stmt:=

Line 2251: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

2247: ||' 2,'
2248: ||' :v_refresh_id,'
2249: ||' :v_instance_id'
2250: ||' from MRP_AP_DEPT_RES_INSTANCES_V'||MSC_CL_PULL.v_dblink||' x'
2251: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2252:
2253: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: dept_res_instance sql = '||v_sql_stmt);
2254: EXECUTE IMMEDIATE v_sql_stmt USING
2255: MSC_CL_PULL.v_refresh_id,

Line 2253: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: dept_res_instance sql = '||v_sql_stmt);

2249: ||' :v_instance_id'
2250: ||' from MRP_AP_DEPT_RES_INSTANCES_V'||MSC_CL_PULL.v_dblink||' x'
2251: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2252:
2253: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: dept_res_instance sql = '||v_sql_stmt);
2254: EXECUTE IMMEDIATE v_sql_stmt USING
2255: MSC_CL_PULL.v_refresh_id,
2256: MSC_CL_PULL.v_instance_id;
2257:

Line 2264: IF ( (MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) AND

2260:
2261: END IF;
2262:
2263:
2264: IF ( (MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) AND
2265: (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) ) THEN
2266:
2267: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2268: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_INSTANCE_REQS';

Line 2265: (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) ) THEN

2261: END IF;
2262:
2263:
2264: IF ( (MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) AND
2265: (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) ) THEN
2266:
2267: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2268: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_INSTANCE_REQS';
2269: MSC_CL_PULL.v_view_name := 'MRP_AD_RES_INSTANCE_REQS_V';

Line 2270: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

2266:
2267: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2268: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_INSTANCE_REQS';
2269: MSC_CL_PULL.v_view_name := 'MRP_AD_RES_INSTANCE_REQS_V';
2270: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2271:
2272: v_sql_stmt:=
2273: 'insert into MSC_ST_RESOURCE_INSTANCE_REQS'
2274: ||' ( WIP_ENTITY_ID,'

Line 2296: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: res_instance sql = '||v_sql_stmt);

2292: ||' WHERE x.RN > :v_lrn '
2293: || v_temp_sql;
2294:
2295:
2296: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: res_instance sql = '||v_sql_stmt);
2297: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2298: MSC_CL_PULL.v_instance_id,
2299: MSC_CL_PULL.v_lrn;
2300:

Line 2331: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: job res_instance sql = '||v_sql_stmt);

2327: ||' from MRP_AD_LJ_OPR_RES_INSTS_V'||MSC_CL_PULL.v_dblink||' x'
2328: ||' WHERE x.RN > :v_lrn '
2329: || v_temp_sql;
2330:
2331: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: job res_instance sql = '||v_sql_stmt);
2332: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2333: MSC_CL_PULL.v_instance_id,
2334: MSC_CL_PULL.v_lrn;
2335: COMMIT;

Line 2372: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str

2368: ||' 2,'
2369: ||' :v_refresh_id,'
2370: ||' :v_instance_id'
2371: ||' from MRP_AP_RES_INSTANCE_REQS_V' ||MSC_CL_PULL.v_dblink ||' x'
2372: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str
2373: || lv_cond_sql
2374: ||' AND ( x.RN2> :v_lrn )'
2375: ||' UNION '
2376: ||' select '

Line 2395: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str

2391: ||' 2,'
2392: ||' :v_refresh_id,'
2393: ||' :v_instance_id'
2394: ||' from MRP_AP_RES_INSTANCE_REQS_V' ||MSC_CL_PULL.v_dblink ||' x'
2395: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str
2396: || lv_cond_sql
2397: ||' AND ( x.RN3> :v_lrn )'
2398: ||' UNION '
2399: ||' select '

Line 2418: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str

2414: ||' 2,'
2415: ||' :v_refresh_id,'
2416: ||' :v_instance_id'
2417: ||' from MRP_AP_RES_INSTANCE_REQS_V' ||MSC_CL_PULL.v_dblink ||' x'
2418: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str
2419: || lv_cond_sql
2420: ||' AND ( x.RN4> :v_lrn )';
2421: ELSE -- full
2422:

Line 2466: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2462: ||' 2,'
2463: ||' :v_refresh_id,'
2464: ||' :v_instance_id'
2465: ||' from MRP_AP_RES_INSTANCE_REQS_V'||MSC_CL_PULL.v_dblink||' x'
2466: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2467: || lv_cond_sql
2468: || v_union_sql ;
2469:
2470:

Line 2471: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' Ds debug: insert from MRP_AP_RES_INSTANCE_REQS_V sql = '||v_sql_stmt);

2467: || lv_cond_sql
2468: || v_union_sql ;
2469:
2470:
2471: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' Ds debug: insert from MRP_AP_RES_INSTANCE_REQS_V sql = '||v_sql_stmt);
2472: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2473:
2474: EXECUTE IMMEDIATE v_sql_stmt USING
2475: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

Line 2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for Wip Job Res Instances='|| SQL%ROWCOUNT);

2482: EXECUTE IMMEDIATE v_sql_stmt USING
2483: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2484: END IF;
2485:
2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for Wip Job Res Instances='|| SQL%ROWCOUNT);
2487: COMMIT;
2488:
2489: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RES_INSTANCES';
2490: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_RES_INSTANCES_V';

Line 2527: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2523: ||' x.BATCH_NUMBER,'
2524: ||' 2,'
2525: ||' :v_refresh_id'
2526: ||' FROM MRP_AP_JOB_RES_INSTANCES_V'||MSC_CL_PULL.v_dblink||' x'
2527: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2528: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2529: ||' OR x.RN2>' || MSC_CL_PULL.v_lrn
2530: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2531:

Line 2532: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: insert from MRP_AP_JOB_RES_INSTANCES_V job res_instance sql = '||v_sql_stmt);

2528: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2529: ||' OR x.RN2>' || MSC_CL_PULL.v_lrn
2530: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2531:
2532: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: insert from MRP_AP_JOB_RES_INSTANCES_V job res_instance sql = '||v_sql_stmt);
2533: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for lJob Res Instances= '||SQL%ROWCOUNT);
2535:
2536: COMMIT;

Line 2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for lJob Res Instances= '||SQL%ROWCOUNT);

2530: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2531:
2532: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: insert from MRP_AP_JOB_RES_INSTANCES_V job res_instance sql = '||v_sql_stmt);
2533: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for lJob Res Instances= '||SQL%ROWCOUNT);
2535:
2536: COMMIT;
2537:
2538:

Line 2539: END IF; /* WI__ENABLED and MSC_UTIL.G_APPS115 */

2535:
2536: COMMIT;
2537:
2538:
2539: END IF; /* WI__ENABLED and MSC_UTIL.G_APPS115 */
2540:
2541: END LOAD_RESOURCE_INSTANCE;
2542:
2543:

Line 2593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'WSM_COPRODUCT_SPLIT_PERC does not exist. Using split from WSM_CO_PRODUCTS');

2589:
2590: IF nvl(v_split_table_exist,0) = 0 THEN
2591:
2592: -- old behaviour
2593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'WSM_COPRODUCT_SPLIT_PERC does not exist. Using split from WSM_CO_PRODUCTS');
2594:
2595: v_query_str := 'Select bill_sequence_id*2,co_product_id,split,' ||
2596: 'effectivity_date, disable_date, decode(nvl(primary_flag,''N''),''N'',2,1) primary_flag' ||
2597: 'from wsm_co_products'||MSC_CL_PULL.v_dblink|| -- Edited for BUG 14133049 (FP of SUN BUG 13530488)

Line 2619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'WSM_COPRODUCT_SPLIT_PERC Exists');

2615: and wsc.split > 0 -- Added this for bug:2208074
2616: and wsc.bill_Sequence_id*2 = bom.bill_Sequence_id';
2617:
2618: ELSE
2619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'WSM_COPRODUCT_SPLIT_PERC Exists');
2620:
2621: v_query_str := 'Select wsc.bill_sequence_id*2,
2622: wsc.co_product_id,
2623: perc.split,

Line 2772: IF (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES) THEN

2768:
2769: PROCEDURE LOAD_RESOURCE_SETUP IS
2770: BEGIN
2771:
2772: IF (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES) THEN
2773: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
2774:
2775: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_SETUPS';
2776: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_SETUPS_V';

Line 2773: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

2769: PROCEDURE LOAD_RESOURCE_SETUP IS
2770: BEGIN
2771:
2772: IF (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES) THEN
2773: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
2774:
2775: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_SETUPS';
2776: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_SETUPS_V';
2777:

Line 2800: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

2796: ||' 2,'
2797: ||' :v_refresh_id,'
2798: ||' :v_instance_id'
2799: ||' from MRP_AP_RESOURCE_SETUPS_V'||MSC_CL_PULL.v_dblink||' x'
2800: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2801:
2802: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup = '||v_sql_stmt);
2803: EXECUTE IMMEDIATE v_sql_stmt
2804: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 2802: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup = '||v_sql_stmt);

2798: ||' :v_instance_id'
2799: ||' from MRP_AP_RESOURCE_SETUPS_V'||MSC_CL_PULL.v_dblink||' x'
2800: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2801:
2802: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup = '||v_sql_stmt);
2803: EXECUTE IMMEDIATE v_sql_stmt
2804: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RESOURCE_SETUPS_V = '|| SQL%ROWCOUNT);
2806:

Line 2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RESOURCE_SETUPS_V = '|| SQL%ROWCOUNT);

2801:
2802: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup = '||v_sql_stmt);
2803: EXECUTE IMMEDIATE v_sql_stmt
2804: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RESOURCE_SETUPS_V = '|| SQL%ROWCOUNT);
2806:
2807: COMMIT;
2808:
2809: MSC_CL_PULL.v_table_name:= 'MSC_ST_SETUP_TRANSITIONS';

Line 2838: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

2834: ||' 2,'
2835: ||' :v_refresh_id,'
2836: ||' :v_instance_id'
2837: ||' from MRP_AP_SETUP_TRANSITIONS_V'||MSC_CL_PULL.v_dblink||' x'
2838: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2839:
2840: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup transition = '||v_sql_stmt);
2841: EXECUTE IMMEDIATE v_sql_stmt
2842: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 2840: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup transition = '||v_sql_stmt);

2836: ||' :v_instance_id'
2837: ||' from MRP_AP_SETUP_TRANSITIONS_V'||MSC_CL_PULL.v_dblink||' x'
2838: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2839:
2840: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup transition = '||v_sql_stmt);
2841: EXECUTE IMMEDIATE v_sql_stmt
2842: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_SETUP_TRANSITIONS_V = '|| SQL%ROWCOUNT);
2844:

Line 2843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_SETUP_TRANSITIONS_V = '|| SQL%ROWCOUNT);

2839:
2840: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup transition = '||v_sql_stmt);
2841: EXECUTE IMMEDIATE v_sql_stmt
2842: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_SETUP_TRANSITIONS_V = '|| SQL%ROWCOUNT);
2844:
2845: COMMIT;
2846:
2847: MSC_CL_PULL.v_table_name:= 'MSC_ST_STD_OP_RESOURCES';

Line 2884: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

2880: ||' 2,'
2881: ||' :v_refresh_id,'
2882: ||' :v_instance_id'
2883: ||' from MRP_AP_STD_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2884: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2885:
2886: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap std op resources = '||v_sql_stmt);
2887: EXECUTE IMMEDIATE v_sql_stmt
2888: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 2886: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap std op resources = '||v_sql_stmt);

2882: ||' :v_instance_id'
2883: ||' from MRP_AP_STD_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2884: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2885:
2886: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap std op resources = '||v_sql_stmt);
2887: EXECUTE IMMEDIATE v_sql_stmt
2888: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_STD_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2890:

Line 2889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_STD_OP_RESOURCES_V = '|| SQL%ROWCOUNT);

2885:
2886: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap std op resources = '||v_sql_stmt);
2887: EXECUTE IMMEDIATE v_sql_stmt
2888: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_STD_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2890:
2891: COMMIT;
2892:
2893: END IF; /* MSC_UTIL.G_APPS115 */

Line 2893: END IF; /* MSC_UTIL.G_APPS115 */

2889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_STD_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2890:
2891: COMMIT;
2892:
2893: END IF; /* MSC_UTIL.G_APPS115 */
2894:
2895: END IF; /* MSC_CL_PULL.BOM_ENABLED */
2896: END LOAD_RESOURCE_SETUP;
2897: