APPS.MSC_CL_AHL_PULL dependencies on MSC_CL_PULL

Line 10: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

6: BEGIN
7:
8: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS ');
9:
10: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
11: MSC_CL_PULL.v_table_name:= 'MSC_ST_VISITS';
12: MSC_CL_PULL.v_view_name := 'MRP_AD_AHL_VISITS_V';
13: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in IF1');
14:

Line 11: MSC_CL_PULL.v_table_name:= 'MSC_ST_VISITS';

7:
8: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS ');
9:
10: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
11: MSC_CL_PULL.v_table_name:= 'MSC_ST_VISITS';
12: MSC_CL_PULL.v_view_name := 'MRP_AD_AHL_VISITS_V';
13: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in IF1');
14:
15: -- insert into MSC_ST_VISITS from MRP_AD_AHL_VISITS_V

Line 12: MSC_CL_PULL.v_view_name := 'MRP_AD_AHL_VISITS_V';

8: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS ');
9:
10: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
11: MSC_CL_PULL.v_table_name:= 'MSC_ST_VISITS';
12: MSC_CL_PULL.v_view_name := 'MRP_AD_AHL_VISITS_V';
13: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in IF1');
14:
15: -- insert into MSC_ST_VISITS from MRP_AD_AHL_VISITS_V
16: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 16: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

12: MSC_CL_PULL.v_view_name := 'MRP_AD_AHL_VISITS_V';
13: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in IF1');
14:
15: -- insert into MSC_ST_VISITS from MRP_AD_AHL_VISITS_V
16: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
17: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in v_lrnn'||MSC_CL_PULL.v_lrnn);
18:
19: v_sql_stmt:= ' INSERT INTO MSC_ST_VISITS'
20: ||'(VISIT_ID,'

Line 17: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in v_lrnn'||MSC_CL_PULL.v_lrnn);

13: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in IF1');
14:
15: -- insert into MSC_ST_VISITS from MRP_AD_AHL_VISITS_V
16: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
17: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in v_lrnn'||MSC_CL_PULL.v_lrnn);
18:
19: v_sql_stmt:= ' INSERT INTO MSC_ST_VISITS'
20: ||'(VISIT_ID,'
21: ||'ORGANIZATION_ID,'

Line 32: ||MSC_CL_PULL.V_DBLINK||' x'

28: ||'1,'
29: ||':v_refresh_id,'
30: ||':v_instance_id'
31: ||' FROM MRP_AD_AHL_VISITS_V'
32: ||MSC_CL_PULL.V_DBLINK||' x'
33: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
34: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
35:
36: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 33: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn

29: ||':v_refresh_id,'
30: ||':v_instance_id'
31: ||' FROM MRP_AD_AHL_VISITS_V'
32: ||MSC_CL_PULL.V_DBLINK||' x'
33: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
34: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
35:
36: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
37: MSC_CL_PULL.v_instance_id;

Line 36: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

32: ||MSC_CL_PULL.V_DBLINK||' x'
33: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
34: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
35:
36: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
37: MSC_CL_PULL.v_instance_id;
38: COMMIT;
39: END IF;
40:

Line 37: MSC_CL_PULL.v_instance_id;

33: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
34: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
35:
36: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
37: MSC_CL_PULL.v_instance_id;
38: COMMIT;
39: END IF;
40:
41: MSC_CL_PULL.v_table_name:= 'MSC_ST_VISITS';

Line 41: MSC_CL_PULL.v_table_name:= 'MSC_ST_VISITS';

37: MSC_CL_PULL.v_instance_id;
38: COMMIT;
39: END IF;
40:
41: MSC_CL_PULL.v_table_name:= 'MSC_ST_VISITS';
42: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_VISITS_V';
43:
44: v_sql_stmt:= ' INSERT INTO MSC_ST_VISITS'
45: ||'(VISIT_ID,'

Line 42: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_VISITS_V';

38: COMMIT;
39: END IF;
40:
41: MSC_CL_PULL.v_table_name:= 'MSC_ST_VISITS';
42: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_VISITS_V';
43:
44: v_sql_stmt:= ' INSERT INTO MSC_ST_VISITS'
45: ||'(VISIT_ID,'
46: ||'VISIT_NAME,'

Line 72: ||' FROM MRP_AP_VISITS_V'||MSC_CL_PULL.v_dblink||' x'

68: ||'x.STATUS_CODE,'
69: ||'x.VISIT_NUMBER,'
70: ||' :v_refresh_id,'
71: ||' :v_instance_id'
72: ||' FROM MRP_AP_VISITS_V'||MSC_CL_PULL.v_dblink||' x'
73: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
74: ||' AND x.ORGANIZATION_ID '
75: ||MSC_UTIL.v_in_org_str;
76:

Line 73: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn

69: ||'x.VISIT_NUMBER,'
70: ||' :v_refresh_id,'
71: ||' :v_instance_id'
72: ||' FROM MRP_AP_VISITS_V'||MSC_CL_PULL.v_dblink||' x'
73: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
74: ||' AND x.ORGANIZATION_ID '
75: ||MSC_UTIL.v_in_org_str;
76:
77: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 77: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

73: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
74: ||' AND x.ORGANIZATION_ID '
75: ||MSC_UTIL.v_in_org_str;
76:
77: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
78: MSC_CL_PULL.v_instance_id ;
79: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
80: END LOAD_VISITS;
81:

Line 78: MSC_CL_PULL.v_instance_id ;

74: ||' AND x.ORGANIZATION_ID '
75: ||MSC_UTIL.v_in_org_str;
76:
77: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
78: MSC_CL_PULL.v_instance_id ;
79: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
80: END LOAD_VISITS;
81:
82: PROCEDURE LOAD_WO_ATTRIBUTES IS

Line 87: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

83: BEGIN
84:
85: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_ATTRIBUTES ');
86:
87: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
88: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';
89: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_ATTRIBUTES_V';
90:
91: -- insert into MSC_ST_WO_ATTRIBUTES from MRP_AD_WO_ATTRIBUTES_V

Line 88: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';

84:
85: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_ATTRIBUTES ');
86:
87: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
88: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';
89: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_ATTRIBUTES_V';
90:
91: -- insert into MSC_ST_WO_ATTRIBUTES from MRP_AD_WO_ATTRIBUTES_V
92: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 89: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_ATTRIBUTES_V';

85: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_ATTRIBUTES ');
86:
87: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
88: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';
89: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_ATTRIBUTES_V';
90:
91: -- insert into MSC_ST_WO_ATTRIBUTES from MRP_AD_WO_ATTRIBUTES_V
92: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
93: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_ATTRIBUTES'

Line 92: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

88: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';
89: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_ATTRIBUTES_V';
90:
91: -- insert into MSC_ST_WO_ATTRIBUTES from MRP_AD_WO_ATTRIBUTES_V
92: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
93: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_ATTRIBUTES'
94: ||'(WIP_ENTITY_ID,'
95: ||'ORGANIZATION_ID,'
96: ||'DELETED_FLAG,'

Line 106: ||MSC_CL_PULL.V_DBLINK||' x'

102: ||'1,'
103: ||':v_refresh_id,'
104: ||':v_instance_id'
105: ||' FROM MRP_AD_WO_ATTRIBUTES_V'
106: ||MSC_CL_PULL.V_DBLINK||' x'
107: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
108: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
109:
110: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 107: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn

103: ||':v_refresh_id,'
104: ||':v_instance_id'
105: ||' FROM MRP_AD_WO_ATTRIBUTES_V'
106: ||MSC_CL_PULL.V_DBLINK||' x'
107: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
108: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
109:
110: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
111: MSC_CL_PULL.v_instance_id;

Line 110: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

106: ||MSC_CL_PULL.V_DBLINK||' x'
107: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
108: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
109:
110: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
111: MSC_CL_PULL.v_instance_id;
112: COMMIT;
113: END IF;
114:

Line 111: MSC_CL_PULL.v_instance_id;

107: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
108: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
109:
110: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
111: MSC_CL_PULL.v_instance_id;
112: COMMIT;
113: END IF;
114:
115: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';

Line 115: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';

111: MSC_CL_PULL.v_instance_id;
112: COMMIT;
113: END IF;
114:
115: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';
116: MSC_CL_PULL.v_view_name := 'MRP_AP_WO_ATTRIBUTES_V';
117:
118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
119: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '

Line 116: MSC_CL_PULL.v_view_name := 'MRP_AP_WO_ATTRIBUTES_V';

112: COMMIT;
113: END IF;
114:
115: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';
116: MSC_CL_PULL.v_view_name := 'MRP_AP_WO_ATTRIBUTES_V';
117:
118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
119: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
120: ||' SELECT '

Line 118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

114:
115: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';
116: MSC_CL_PULL.v_view_name := 'MRP_AP_WO_ATTRIBUTES_V';
117:
118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
119: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
120: ||' SELECT '
121: ||'x.SERIAL_NUMBER,'
122: ||'x.WIP_ENTITY_ID,'

Line 119: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '

115: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';
116: MSC_CL_PULL.v_view_name := 'MRP_AP_WO_ATTRIBUTES_V';
117:
118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
119: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
120: ||' SELECT '
121: ||'x.SERIAL_NUMBER,'
122: ||'x.WIP_ENTITY_ID,'
123: ||'x.FLEET_HEADER_ID,'

Line 148: ||MSC_CL_PULL.V_DBLINK||' x'

144: ||'x.ITEM_ALTERNATES_EXIST,'
145: ||':v_refresh_id,'
146: ||':v_instance_id'
147: ||' FROM MRP_AP_WO_ATTRIBUTES_V'
148: ||MSC_CL_PULL.V_DBLINK||' x'
149: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
150: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
151: ELSE
152: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn

Line 149: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn

145: ||':v_refresh_id,'
146: ||':v_instance_id'
147: ||' FROM MRP_AP_WO_ATTRIBUTES_V'
148: ||MSC_CL_PULL.V_DBLINK||' x'
149: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
150: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
151: ELSE
152: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';

Line 152: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn

148: ||MSC_CL_PULL.V_DBLINK||' x'
149: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
150: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
151: ELSE
152: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
154: END IF;
155:
156: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_ATTRIBUTES'

Line 153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';

149: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
150: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
151: ELSE
152: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
154: END IF;
155:
156: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_ATTRIBUTES'
157: ||'(SERIAL_NUM,'

Line 211: ||MSC_CL_PULL.V_DBLINK||' x'

207: ||'x.ITEM_ALTERNATES_EXIST,'
208: ||':v_refresh_id,'
209: ||':v_instance_id'
210: ||' FROM MRP_AP_WO_ATTRIBUTES_V'
211: ||MSC_CL_PULL.V_DBLINK||' x'
212: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
213: || v_union_sql ;
214:
215: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 215: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

211: ||MSC_CL_PULL.V_DBLINK||' x'
212: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
213: || v_union_sql ;
214:
215: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
216: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
217: MSC_CL_PULL.v_instance_id,
218: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
219: ELSE

Line 216: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

212: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
213: || v_union_sql ;
214:
215: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
216: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
217: MSC_CL_PULL.v_instance_id,
218: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
219: ELSE
220: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 217: MSC_CL_PULL.v_instance_id,

213: || v_union_sql ;
214:
215: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
216: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
217: MSC_CL_PULL.v_instance_id,
218: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
219: ELSE
220: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
221: MSC_CL_PULL.v_instance_id;

Line 218: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

214:
215: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
216: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
217: MSC_CL_PULL.v_instance_id,
218: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
219: ELSE
220: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
221: MSC_CL_PULL.v_instance_id;
222: END IF;

Line 220: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

216: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
217: MSC_CL_PULL.v_instance_id,
218: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
219: ELSE
220: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
221: MSC_CL_PULL.v_instance_id;
222: END IF;
223: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
224:

Line 221: MSC_CL_PULL.v_instance_id;

217: MSC_CL_PULL.v_instance_id,
218: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
219: ELSE
220: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
221: MSC_CL_PULL.v_instance_id;
222: END IF;
223: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
224:
225: END LOAD_WO_ATTRIBUTES;

Line 232: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

228: BEGIN
229:
230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_TASK_HRY ');
231:
232: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
233: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';
234: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_TASK_HIERARCHY_V';
235:
236: -- insert into MSC_ST_WO_TASK_HIERARCHY from MRP_AD_WO_TASK_HRY_V

Line 233: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';

229:
230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_TASK_HRY ');
231:
232: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
233: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';
234: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_TASK_HIERARCHY_V';
235:
236: -- insert into MSC_ST_WO_TASK_HIERARCHY from MRP_AD_WO_TASK_HRY_V
237: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 234: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_TASK_HIERARCHY_V';

230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_TASK_HRY ');
231:
232: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
233: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';
234: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_TASK_HIERARCHY_V';
235:
236: -- insert into MSC_ST_WO_TASK_HIERARCHY from MRP_AD_WO_TASK_HRY_V
237: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
238: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_TASK_HIERARCHY'

Line 237: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

233: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';
234: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_TASK_HIERARCHY_V';
235:
236: -- insert into MSC_ST_WO_TASK_HIERARCHY from MRP_AD_WO_TASK_HRY_V
237: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
238: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_TASK_HIERARCHY'
239: ||'(TASK_LINK_ID,'
240: ||'ORGANIZATION_ID,'
241: ||'DELETED_FLAG,'

Line 251: ||MSC_CL_PULL.v_dblink||' x'

247: ||'1,'
248: ||':v_refresh_id,'
249: ||':v_instance_id'
250: ||' FROM MRP_AD_WO_TASK_HIERARCHY_V'
251: ||MSC_CL_PULL.v_dblink||' x'
252: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
253: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
254:
255: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 252: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn

248: ||':v_refresh_id,'
249: ||':v_instance_id'
250: ||' FROM MRP_AD_WO_TASK_HIERARCHY_V'
251: ||MSC_CL_PULL.v_dblink||' x'
252: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
253: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
254:
255: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
256: MSC_CL_PULL.v_instance_id;

Line 255: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

251: ||MSC_CL_PULL.v_dblink||' x'
252: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
253: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
254:
255: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
256: MSC_CL_PULL.v_instance_id;
257: COMMIT;
258: END IF;
259:

Line 256: MSC_CL_PULL.v_instance_id;

252: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
253: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
254:
255: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
256: MSC_CL_PULL.v_instance_id;
257: COMMIT;
258: END IF;
259:
260: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';

Line 260: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';

256: MSC_CL_PULL.v_instance_id;
257: COMMIT;
258: END IF;
259:
260: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';
261: MSC_CL_PULL.v_view_name := 'MRP_AP_WO_TASK_HRY_V';
262:
263: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
264: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '

Line 261: MSC_CL_PULL.v_view_name := 'MRP_AP_WO_TASK_HRY_V';

257: COMMIT;
258: END IF;
259:
260: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';
261: MSC_CL_PULL.v_view_name := 'MRP_AP_WO_TASK_HRY_V';
262:
263: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
264: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
265: ||' SELECT '

Line 263: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

259:
260: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';
261: MSC_CL_PULL.v_view_name := 'MRP_AP_WO_TASK_HRY_V';
262:
263: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
264: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
265: ||' SELECT '
266: ||'x.TASK_LINK_ID,'
267: ||'x.CURRENT_WIP_ENTITY_ID,'

Line 264: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '

260: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';
261: MSC_CL_PULL.v_view_name := 'MRP_AP_WO_TASK_HRY_V';
262:
263: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
264: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
265: ||' SELECT '
266: ||'x.TASK_LINK_ID,'
267: ||'x.CURRENT_WIP_ENTITY_ID,'
268: ||'x.NEXT_WIP_ENTITY_ID,'

Line 278: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'

274: ||'x.ORGANIZATION_ID, '
275: ||'2,'
276: ||':v_refresh_id,'
277: ||':v_instance_id'
278: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'
279: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
280: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
281: ||' UNION '
282: ||' SELECT '

Line 279: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn

275: ||'2,'
276: ||':v_refresh_id,'
277: ||':v_instance_id'
278: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'
279: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
280: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
281: ||' UNION '
282: ||' SELECT '
283: ||'x.TASK_LINK_ID,'

Line 295: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'

291: ||'x.ORGANIZATION_ID, '
292: ||'2,'
293: ||':v_refresh_id,'
294: ||':v_instance_id'
295: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'
296: ||' WHERE x.RN3> '||MSC_CL_PULL.v_lrn
297: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
298: ELSE
299: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn

Line 296: ||' WHERE x.RN3> '||MSC_CL_PULL.v_lrn

292: ||'2,'
293: ||':v_refresh_id,'
294: ||':v_instance_id'
295: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'
296: ||' WHERE x.RN3> '||MSC_CL_PULL.v_lrn
297: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
298: ELSE
299: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
300: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

Line 299: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn

295: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'
296: ||' WHERE x.RN3> '||MSC_CL_PULL.v_lrn
297: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
298: ELSE
299: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
300: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
301: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
302: END IF;
303:

Line 300: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

296: ||' WHERE x.RN3> '||MSC_CL_PULL.v_lrn
297: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
298: ELSE
299: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
300: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
301: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
302: END IF;
303:
304: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_TASK_HIERARCHY'

Line 301: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';

297: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
298: ELSE
299: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
300: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
301: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
302: END IF;
303:
304: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_TASK_HIERARCHY'
305: ||'(TASK_LINK_ID,'

Line 330: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'

326: ||'x.ORGANIZATION_ID, '
327: ||'2,'
328: ||':v_refresh_id,'
329: ||':v_instance_id'
330: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'
331: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
332: || v_union_sql ;
333:
334: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 334: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

330: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'
331: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
332: || v_union_sql ;
333:
334: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_refresh_id,
338: MSC_CL_PULL.v_instance_id,

Line 335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

331: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
332: || v_union_sql ;
333:
334: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_refresh_id,
338: MSC_CL_PULL.v_instance_id,
339: MSC_CL_PULL.v_refresh_id,

Line 336: MSC_CL_PULL.v_instance_id,

332: || v_union_sql ;
333:
334: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_refresh_id,
338: MSC_CL_PULL.v_instance_id,
339: MSC_CL_PULL.v_refresh_id,
340: MSC_CL_PULL.v_instance_id;

Line 337: MSC_CL_PULL.v_refresh_id,

333:
334: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_refresh_id,
338: MSC_CL_PULL.v_instance_id,
339: MSC_CL_PULL.v_refresh_id,
340: MSC_CL_PULL.v_instance_id;
341: ELSE

Line 338: MSC_CL_PULL.v_instance_id,

334: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_refresh_id,
338: MSC_CL_PULL.v_instance_id,
339: MSC_CL_PULL.v_refresh_id,
340: MSC_CL_PULL.v_instance_id;
341: ELSE
342: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 339: MSC_CL_PULL.v_refresh_id,

335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_refresh_id,
338: MSC_CL_PULL.v_instance_id,
339: MSC_CL_PULL.v_refresh_id,
340: MSC_CL_PULL.v_instance_id;
341: ELSE
342: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
343: MSC_CL_PULL.v_instance_id;

Line 340: MSC_CL_PULL.v_instance_id;

336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_refresh_id,
338: MSC_CL_PULL.v_instance_id,
339: MSC_CL_PULL.v_refresh_id,
340: MSC_CL_PULL.v_instance_id;
341: ELSE
342: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
343: MSC_CL_PULL.v_instance_id;
344: END IF;

Line 342: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

338: MSC_CL_PULL.v_instance_id,
339: MSC_CL_PULL.v_refresh_id,
340: MSC_CL_PULL.v_instance_id;
341: ELSE
342: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
343: MSC_CL_PULL.v_instance_id;
344: END IF;
345: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
346:

Line 343: MSC_CL_PULL.v_instance_id;

339: MSC_CL_PULL.v_refresh_id,
340: MSC_CL_PULL.v_instance_id;
341: ELSE
342: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
343: MSC_CL_PULL.v_instance_id;
344: END IF;
345: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
346:
347: END LOAD_WO_TASK_HRY;

Line 354: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

350: BEGIN
351:
352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_MILESTONES ');
353:
354: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
355: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_MILESTONES';
356: MSC_CL_PULL.v_view_name := 'MRP_AD_MILESTONES_V';
357:
358: -- insert into MSC_ST_WO_MILESTONES from MRP_AD_MILESTONES_V

Line 355: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_MILESTONES';

351:
352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_MILESTONES ');
353:
354: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
355: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_MILESTONES';
356: MSC_CL_PULL.v_view_name := 'MRP_AD_MILESTONES_V';
357:
358: -- insert into MSC_ST_WO_MILESTONES from MRP_AD_MILESTONES_V
359: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 356: MSC_CL_PULL.v_view_name := 'MRP_AD_MILESTONES_V';

352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_MILESTONES ');
353:
354: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
355: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_MILESTONES';
356: MSC_CL_PULL.v_view_name := 'MRP_AD_MILESTONES_V';
357:
358: -- insert into MSC_ST_WO_MILESTONES from MRP_AD_MILESTONES_V
359: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
360: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_MILESTONES'

Line 359: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

355: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_MILESTONES';
356: MSC_CL_PULL.v_view_name := 'MRP_AD_MILESTONES_V';
357:
358: -- insert into MSC_ST_WO_MILESTONES from MRP_AD_MILESTONES_V
359: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
360: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_MILESTONES'
361: ||'(VISIT_ID,'
362: ||'MILESTONE,'
363: ||'ORGANIZATION_ID,'

Line 375: ||MSC_CL_PULL.v_dblink||' x'

371: ||'1,'
372: ||':v_refresh_id,'
373: ||':v_instance_id'
374: ||' FROM MRP_AD_MILESTONES_V'
375: ||MSC_CL_PULL.v_dblink||' x'
376: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
377: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
378:
379: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 376: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn

372: ||':v_refresh_id,'
373: ||':v_instance_id'
374: ||' FROM MRP_AD_MILESTONES_V'
375: ||MSC_CL_PULL.v_dblink||' x'
376: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
377: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
378:
379: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
380: MSC_CL_PULL.v_instance_id;

Line 379: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

375: ||MSC_CL_PULL.v_dblink||' x'
376: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
377: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
378:
379: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
380: MSC_CL_PULL.v_instance_id;
381: COMMIT;
382: END IF;
383:

Line 380: MSC_CL_PULL.v_instance_id;

376: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
377: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
378:
379: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
380: MSC_CL_PULL.v_instance_id;
381: COMMIT;
382: END IF;
383:
384: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_MILESTONES';

Line 384: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_MILESTONES';

380: MSC_CL_PULL.v_instance_id;
381: COMMIT;
382: END IF;
383:
384: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_MILESTONES';
385: MSC_CL_PULL.v_view_name := 'MRP_AP_MILESTONES_V';
386:
387: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_MILESTONES'
388: ||'(MILESTONE,'

Line 385: MSC_CL_PULL.v_view_name := 'MRP_AP_MILESTONES_V';

381: COMMIT;
382: END IF;
383:
384: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_MILESTONES';
385: MSC_CL_PULL.v_view_name := 'MRP_AP_MILESTONES_V';
386:
387: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_MILESTONES'
388: ||'(MILESTONE,'
389: ||'MILESTONE_DESC,'

Line 407: ||' from MRP_AP_MILESTONES_V'||MSC_CL_PULL.V_DBLINK||' x'

403: ||'x.EARLIEST_START_DATE,'
404: ||'x.PLANNED_END_DATE,'
405: ||':v_refresh_id,'
406: ||':v_instance_id'
407: ||' from MRP_AP_MILESTONES_V'||MSC_CL_PULL.V_DBLINK||' x'
408: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
409: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
410:
411: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 408: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn

404: ||'x.PLANNED_END_DATE,'
405: ||':v_refresh_id,'
406: ||':v_instance_id'
407: ||' from MRP_AP_MILESTONES_V'||MSC_CL_PULL.V_DBLINK||' x'
408: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
409: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
410:
411: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
412: MSC_CL_PULL.v_instance_id;

Line 411: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

407: ||' from MRP_AP_MILESTONES_V'||MSC_CL_PULL.V_DBLINK||' x'
408: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
409: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
410:
411: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
412: MSC_CL_PULL.v_instance_id;
413: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
414:
415: END LOAD_MILESTONES;

Line 412: MSC_CL_PULL.v_instance_id;

408: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
409: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
410:
411: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
412: MSC_CL_PULL.v_instance_id;
413: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
414:
415: END LOAD_MILESTONES;
416:

Line 422: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

418: BEGIN
419:
420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_OPER_RELN');
421:
422: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
423: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';
424: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_OPERATIONS_REL_V';
425:
426: -- insert into MSC_ST_WO_OPERATION_REL from MRP_AD_WO_OPERATIONS_REL_V

Line 423: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';

419:
420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_OPER_RELN');
421:
422: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
423: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';
424: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_OPERATIONS_REL_V';
425:
426: -- insert into MSC_ST_WO_OPERATION_REL from MRP_AD_WO_OPERATIONS_REL_V
427: IF MSC_CL_PULL.V_LRNN<> -1 THEN -- incremental refresh

Line 424: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_OPERATIONS_REL_V';

420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_OPER_RELN');
421:
422: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
423: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';
424: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_OPERATIONS_REL_V';
425:
426: -- insert into MSC_ST_WO_OPERATION_REL from MRP_AD_WO_OPERATIONS_REL_V
427: IF MSC_CL_PULL.V_LRNN<> -1 THEN -- incremental refresh
428: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_OPERATION_REL'

Line 427: IF MSC_CL_PULL.V_LRNN<> -1 THEN -- incremental refresh

423: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';
424: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_OPERATIONS_REL_V';
425:
426: -- insert into MSC_ST_WO_OPERATION_REL from MRP_AD_WO_OPERATIONS_REL_V
427: IF MSC_CL_PULL.V_LRNN<> -1 THEN -- incremental refresh
428: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_OPERATION_REL'
429: ||'(WORKORDER_ID,'
430: ||'FROM_OP_SEQ_NUM,'
431: ||'TO_OP_SEQ_NUM,'

Line 445: ||MSC_CL_PULL.v_dblink||' x'

441: ||'1,'
442: ||':v_refresh_id,'
443: ||':v_instance_id'
444: ||' FROM MRP_AD_WO_OPERATIONS_REL_V'
445: ||MSC_CL_PULL.v_dblink||' x'
446: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
447: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
448:
449: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 446: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn

442: ||':v_refresh_id,'
443: ||':v_instance_id'
444: ||' FROM MRP_AD_WO_OPERATIONS_REL_V'
445: ||MSC_CL_PULL.v_dblink||' x'
446: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
447: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
448:
449: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
450: MSC_CL_PULL.v_instance_id;

Line 449: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

445: ||MSC_CL_PULL.v_dblink||' x'
446: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
447: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
448:
449: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
450: MSC_CL_PULL.v_instance_id;
451: COMMIT;
452: END IF;
453:

Line 450: MSC_CL_PULL.v_instance_id;

446: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
447: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
448:
449: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
450: MSC_CL_PULL.v_instance_id;
451: COMMIT;
452: END IF;
453:
454: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';

Line 454: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';

450: MSC_CL_PULL.v_instance_id;
451: COMMIT;
452: END IF;
453:
454: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';
455: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_WO_OPER_RELN_V';
456:
457: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
458: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '

Line 455: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_WO_OPER_RELN_V';

451: COMMIT;
452: END IF;
453:
454: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';
455: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_WO_OPER_RELN_V';
456:
457: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
458: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
459: ||' SELECT '

Line 457: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

453:
454: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';
455: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_WO_OPER_RELN_V';
456:
457: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
458: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
459: ||' SELECT '
460: ||'x.WORKORDER_ID,'
461: ||'x.WIP_ENTITY_ID,'

Line 458: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '

454: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';
455: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_WO_OPER_RELN_V';
456:
457: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
458: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
459: ||' SELECT '
460: ||'x.WORKORDER_ID,'
461: ||'x.WIP_ENTITY_ID,'
462: ||'x.FROM_OPERATION_SEQ,'

Line 474: ||MSC_CL_PULL.V_DBLINK||' x'

470: ||'2,'
471: ||':v_refresh_id,'
472: ||':v_instance_id'
473: ||' from MRP_AP_WO_OPER_RELN_V'
474: ||MSC_CL_PULL.V_DBLINK||' x'
475: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
476: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
477: ELSE
478: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn

Line 475: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn

471: ||':v_refresh_id,'
472: ||':v_instance_id'
473: ||' from MRP_AP_WO_OPER_RELN_V'
474: ||MSC_CL_PULL.V_DBLINK||' x'
475: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
476: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
477: ELSE
478: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
479: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';

Line 478: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn

474: ||MSC_CL_PULL.V_DBLINK||' x'
475: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
476: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
477: ELSE
478: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
479: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
480: END IF;
481:
482: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_OPERATION_REL'

Line 479: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';

475: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
476: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
477: ELSE
478: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
479: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
480: END IF;
481:
482: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_OPERATION_REL'
483: ||'(WORKORDER_ID,'

Line 511: ||MSC_CL_PULL.V_DBLINK||' x'

507: ||'2,'
508: ||':v_refresh_id,'
509: ||':v_instance_id'
510: ||' from MRP_AP_WO_OPER_RELN_V'
511: ||MSC_CL_PULL.V_DBLINK||' x'
512: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
513: || v_union_sql ;
514:
515: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 515: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

511: ||MSC_CL_PULL.V_DBLINK||' x'
512: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
513: || v_union_sql ;
514:
515: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
516: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
517: MSC_CL_PULL.v_instance_id,
518: MSC_CL_PULL.v_refresh_id,
519: MSC_CL_PULL.v_instance_id;

Line 516: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

512: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
513: || v_union_sql ;
514:
515: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
516: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
517: MSC_CL_PULL.v_instance_id,
518: MSC_CL_PULL.v_refresh_id,
519: MSC_CL_PULL.v_instance_id;
520: ELSE

Line 517: MSC_CL_PULL.v_instance_id,

513: || v_union_sql ;
514:
515: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
516: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
517: MSC_CL_PULL.v_instance_id,
518: MSC_CL_PULL.v_refresh_id,
519: MSC_CL_PULL.v_instance_id;
520: ELSE
521: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 518: MSC_CL_PULL.v_refresh_id,

514:
515: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
516: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
517: MSC_CL_PULL.v_instance_id,
518: MSC_CL_PULL.v_refresh_id,
519: MSC_CL_PULL.v_instance_id;
520: ELSE
521: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
522: MSC_CL_PULL.v_instance_id;

Line 519: MSC_CL_PULL.v_instance_id;

515: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
516: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
517: MSC_CL_PULL.v_instance_id,
518: MSC_CL_PULL.v_refresh_id,
519: MSC_CL_PULL.v_instance_id;
520: ELSE
521: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
522: MSC_CL_PULL.v_instance_id;
523: END IF;

Line 521: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

517: MSC_CL_PULL.v_instance_id,
518: MSC_CL_PULL.v_refresh_id,
519: MSC_CL_PULL.v_instance_id;
520: ELSE
521: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
522: MSC_CL_PULL.v_instance_id;
523: END IF;
524:
525: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */

Line 522: MSC_CL_PULL.v_instance_id;

518: MSC_CL_PULL.v_refresh_id,
519: MSC_CL_PULL.v_instance_id;
520: ELSE
521: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
522: MSC_CL_PULL.v_instance_id;
523: END IF;
524:
525: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
526:

Line 535: IF MSC_CL_PULL.V_APPS_VER >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

531:
532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
533: 'In Procedure LOAD_WORK_BREAKDOWN ');
534:
535: IF MSC_CL_PULL.V_APPS_VER >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
536:
537: MSC_CL_PULL.v_table_name:= 'MSC_ST_WORK_BREAKDOWN_STRUCT';
538: MSC_CL_PULL.v_view_name := 'MRP_AP_WORK_BREAKDOWN_V';
539:

Line 537: MSC_CL_PULL.v_table_name:= 'MSC_ST_WORK_BREAKDOWN_STRUCT';

533: 'In Procedure LOAD_WORK_BREAKDOWN ');
534:
535: IF MSC_CL_PULL.V_APPS_VER >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
536:
537: MSC_CL_PULL.v_table_name:= 'MSC_ST_WORK_BREAKDOWN_STRUCT';
538: MSC_CL_PULL.v_view_name := 'MRP_AP_WORK_BREAKDOWN_V';
539:
540: v_sql_stmt:= ' INSERT INTO MSC_ST_WORK_BREAKDOWN_STRUCT'
541: ||'(ORGANIZATION_ID,'

Line 538: MSC_CL_PULL.v_view_name := 'MRP_AP_WORK_BREAKDOWN_V';

534:
535: IF MSC_CL_PULL.V_APPS_VER >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
536:
537: MSC_CL_PULL.v_table_name:= 'MSC_ST_WORK_BREAKDOWN_STRUCT';
538: MSC_CL_PULL.v_view_name := 'MRP_AP_WORK_BREAKDOWN_V';
539:
540: v_sql_stmt:= ' INSERT INTO MSC_ST_WORK_BREAKDOWN_STRUCT'
541: ||'(ORGANIZATION_ID,'
542: ||'PARAMETER_NAME,'

Line 555: ||MSC_CL_PULL.v_dblink||' x'

551: ||'2,'
552: ||':v_refresh_id,'
553: ||':v_instance_id'
554: ||' from MRP_AP_WORK_BREAKDOWN_V'
555: ||MSC_CL_PULL.v_dblink||' x'
556: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
557:
558: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
559: MSC_CL_PULL.v_instance_id;

Line 558: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

554: ||' from MRP_AP_WORK_BREAKDOWN_V'
555: ||MSC_CL_PULL.v_dblink||' x'
556: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
557:
558: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
559: MSC_CL_PULL.v_instance_id;
560:
561: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
562:

Line 559: MSC_CL_PULL.v_instance_id;

555: ||MSC_CL_PULL.v_dblink||' x'
556: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
557:
558: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
559: MSC_CL_PULL.v_instance_id;
560:
561: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
562:
563: END LOAD_WORK_BREAKDOWN;

Line 569: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

565: PROCEDURE LOAD_WO_SUB_COMP IS
566: BEGIN
567: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_SUB_COMP ');
568:
569: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
570: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_SUB_COMP';
571: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_WO_SUB_COMP_V';
572:
573: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_SUB_COMP'

Line 570: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_SUB_COMP';

566: BEGIN
567: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_SUB_COMP ');
568:
569: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
570: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_SUB_COMP';
571: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_WO_SUB_COMP_V';
572:
573: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_SUB_COMP'
574: ||'(ALTERNATE_COMPONENT_ID,'

Line 571: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_WO_SUB_COMP_V';

567: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_SUB_COMP ');
568:
569: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
570: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_SUB_COMP';
571: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_WO_SUB_COMP_V';
572:
573: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_SUB_COMP'
574: ||'(ALTERNATE_COMPONENT_ID,'
575: ||'WIP_ENTITY_ID,'

Line 597: ||' FROM MRP_AP_WO_SUB_COMP_V'||MSC_CL_PULL.v_dblink||' x'

593: ||'x.RATIO,'
594: ||'x.REQUEST_ID,'
595: ||':v_refresh_id,'
596: ||':v_instance_id'
597: ||' FROM MRP_AP_WO_SUB_COMP_V'||MSC_CL_PULL.v_dblink||' x'
598: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
599:
600: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
601: MSC_CL_PULL.v_instance_id ;

Line 600: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

596: ||':v_instance_id'
597: ||' FROM MRP_AP_WO_SUB_COMP_V'||MSC_CL_PULL.v_dblink||' x'
598: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
599:
600: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
601: MSC_CL_PULL.v_instance_id ;
602: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
603:
604: END LOAD_WO_SUB_COMP;

Line 601: MSC_CL_PULL.v_instance_id ;

597: ||' FROM MRP_AP_WO_SUB_COMP_V'||MSC_CL_PULL.v_dblink||' x'
598: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
599:
600: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
601: MSC_CL_PULL.v_instance_id ;
602: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
603:
604: END LOAD_WO_SUB_COMP;
605:

Line 616: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

612: BEGIN
613:
614: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
615: 'In Procedure LOAD_CMRO_FORECASTS ');
616: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
617:
618: /*--incremental refresh is not to be supported for CMRO forecasts
619:
620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

616: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
617:
618: /*--incremental refresh is not to be supported for CMRO forecasts
619:
620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_CMRO_FORECASTS and v_lrnn= '||MSC_CL_PULL.v_lrnn);
622:
623: v_sql_stmt:= ' INSERT INTO MSC_ST_SUPPLIES'
624: ||'(DISPOSITION_ID,'

Line 621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_CMRO_FORECASTS and v_lrnn= '||MSC_CL_PULL.v_lrnn);

617:
618: /*--incremental refresh is not to be supported for CMRO forecasts
619:
620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_CMRO_FORECASTS and v_lrnn= '||MSC_CL_PULL.v_lrnn);
622:
623: v_sql_stmt:= ' INSERT INTO MSC_ST_SUPPLIES'
624: ||'(DISPOSITION_ID,'
625: ||'OBJECT_TYPE,'

Line 642: || MSC_CL_PULL.V_DBLINK||' x'

638: ||' 1,'
639: ||':v_refresh_id,'
640: ||':v_instance_id'
641: ||' FROM MRP_AD_UMP_MAINT_REQMNTS_V'
642: || MSC_CL_PULL.V_DBLINK||' x'
643: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
644:
645: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
646: MSC_CL_PULL.v_instance_id;

Line 643: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;

639: ||':v_refresh_id,'
640: ||':v_instance_id'
641: ||' FROM MRP_AD_UMP_MAINT_REQMNTS_V'
642: || MSC_CL_PULL.V_DBLINK||' x'
643: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
644:
645: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
646: MSC_CL_PULL.v_instance_id;
647:

Line 645: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

641: ||' FROM MRP_AD_UMP_MAINT_REQMNTS_V'
642: || MSC_CL_PULL.V_DBLINK||' x'
643: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
644:
645: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
646: MSC_CL_PULL.v_instance_id;
647:
648:
649: --incremental for demands

Line 646: MSC_CL_PULL.v_instance_id;

642: || MSC_CL_PULL.V_DBLINK||' x'
643: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
644:
645: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
646: MSC_CL_PULL.v_instance_id;
647:
648:
649: --incremental for demands
650:

Line 669: ||' FROM MRP_AD_UMP_MATERIAL_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'

665: ||'x.INVENTORY_ITEM_ID,'
666: ||' 1,'
667: ||':v_refresh_id,'
668: ||':v_instance_id'
669: ||' FROM MRP_AD_UMP_MATERIAL_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
670: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
671:
672: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
673: MSC_CL_PULL.v_instance_id ;

Line 670: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;

666: ||' 1,'
667: ||':v_refresh_id,'
668: ||':v_instance_id'
669: ||' FROM MRP_AD_UMP_MATERIAL_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
670: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
671:
672: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
673: MSC_CL_PULL.v_instance_id ;
674:

Line 672: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

668: ||':v_instance_id'
669: ||' FROM MRP_AD_UMP_MATERIAL_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
670: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
671:
672: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
673: MSC_CL_PULL.v_instance_id ;
674:
675:
676: --inc for resource requirements

Line 673: MSC_CL_PULL.v_instance_id ;

669: ||' FROM MRP_AD_UMP_MATERIAL_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
670: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
671:
672: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
673: MSC_CL_PULL.v_instance_id ;
674:
675:
676: --inc for resource requirements
677:

Line 696: ||' MRP_AD_UMP_RESOURCE_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'

692: ||'x.INVENTORY_ITEM_ID,'
693: ||' 1,'
694: ||':v_refresh_id,'
695: ||':v_instance_id'
696: ||' MRP_AD_UMP_RESOURCE_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
697: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
698:
699: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
700: MSC_CL_PULL.v_instance_id ;

Line 697: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;

693: ||' 1,'
694: ||':v_refresh_id,'
695: ||':v_instance_id'
696: ||' MRP_AD_UMP_RESOURCE_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
697: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
698:
699: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
700: MSC_CL_PULL.v_instance_id ;
701: --inc for designators

Line 699: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

695: ||':v_instance_id'
696: ||' MRP_AD_UMP_RESOURCE_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
697: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
698:
699: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
700: MSC_CL_PULL.v_instance_id ;
701: --inc for designators
702:
703:

Line 700: MSC_CL_PULL.v_instance_id ;

696: ||' MRP_AD_UMP_RESOURCE_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
697: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
698:
699: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
700: MSC_CL_PULL.v_instance_id ;
701: --inc for designators
702:
703:
704: v_sql_stmt:= ' INSERT INTO MSC_ST_DESIGNATORS'

Line 718: ||' MRP_AD_AHL_DESIGNATORS_V'||MSC_CL_PULL.v_dblink||' x'

714: ||'x.SIMULATION_PLAN_NAME,'
715: ||' 1,'
716: ||':v_refresh_id,'
717: ||':v_instance_id'
718: ||' MRP_AD_AHL_DESIGNATORS_V'||MSC_CL_PULL.v_dblink||' x'
719: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
720:
721: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
722: MSC_CL_PULL.v_instance_id ;

Line 719: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;

715: ||' 1,'
716: ||':v_refresh_id,'
717: ||':v_instance_id'
718: ||' MRP_AD_AHL_DESIGNATORS_V'||MSC_CL_PULL.v_dblink||' x'
719: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
720:
721: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
722: MSC_CL_PULL.v_instance_id ;
723:

Line 721: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

717: ||':v_instance_id'
718: ||' MRP_AD_AHL_DESIGNATORS_V'||MSC_CL_PULL.v_dblink||' x'
719: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
720:
721: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
722: MSC_CL_PULL.v_instance_id ;
723:
724: COMMIT;
725: END IF;

Line 722: MSC_CL_PULL.v_instance_id ;

718: ||' MRP_AD_AHL_DESIGNATORS_V'||MSC_CL_PULL.v_dblink||' x'
719: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn;
720:
721: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
722: MSC_CL_PULL.v_instance_id ;
723:
724: COMMIT;
725: END IF;
726: --end of incremental

Line 729: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

725: END IF;
726: --end of incremental
727: */
728:
729: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
730: MSC_CL_PULL.v_view_name := 'MRP_AP_UMP_MAINT_REQMNTS_V';
731:
732: v_sql_stmt:= ' INSERT INTO MSC_ST_SUPPLIES '
733: ||'(SCHEDULE_DESIGNATOR_ID,'

Line 730: MSC_CL_PULL.v_view_name := 'MRP_AP_UMP_MAINT_REQMNTS_V';

726: --end of incremental
727: */
728:
729: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
730: MSC_CL_PULL.v_view_name := 'MRP_AP_UMP_MAINT_REQMNTS_V';
731:
732: v_sql_stmt:= ' INSERT INTO MSC_ST_SUPPLIES '
733: ||'(SCHEDULE_DESIGNATOR_ID,'
734: ||'ORGANIZATION_ID,'

Line 774: ||' FROM MRP_AP_UMP_MAINT_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'

770: ||'x.MAINTENANCE_REQUIREMENT,'
771: ||' x.INVENTORY_ITEM_ID,'
772: ||':v_refresh_id,'
773: ||':v_instance_id'
774: ||' FROM MRP_AP_UMP_MAINT_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
775: ||' WHERE x.OPERATING_ORG_ID '|| MSC_UTIL.v_in_org_str
776: ||' AND x.DUE_DATE >= :p_eam_cmro_st_date '
777: ||' AND x.DUE_DATE <= :p_eam_cmro_end_date '
778: -- ||' AND x.RN > '||MSC_CL_PULL.v_lrn

Line 778: -- ||' AND x.RN > '||MSC_CL_PULL.v_lrn

774: ||' FROM MRP_AP_UMP_MAINT_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
775: ||' WHERE x.OPERATING_ORG_ID '|| MSC_UTIL.v_in_org_str
776: ||' AND x.DUE_DATE >= :p_eam_cmro_st_date '
777: ||' AND x.DUE_DATE <= :p_eam_cmro_end_date '
778: -- ||' AND x.RN > '||MSC_CL_PULL.v_lrn
779: ;
780:
781:
782: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for cmro forecast :' ||v_sql_stmt);

Line 786: MSC_CL_PULL.v_refresh_id,

782: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for cmro forecast :' ||v_sql_stmt);
783: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
784:
785: EXECUTE IMMEDIATE v_sql_stmt USING
786: MSC_CL_PULL.v_refresh_id,
787: MSC_CL_PULL.v_instance_id
788: ,p_eam_cmro_st_date
789: ,p_eam_cmro_end_date
790: ;

Line 787: MSC_CL_PULL.v_instance_id

783: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
784:
785: EXECUTE IMMEDIATE v_sql_stmt USING
786: MSC_CL_PULL.v_refresh_id,
787: MSC_CL_PULL.v_instance_id
788: ,p_eam_cmro_st_date
789: ,p_eam_cmro_end_date
790: ;
791:

Line 793: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

789: ,p_eam_cmro_end_date
790: ;
791:
792: COMMIT;
793: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
794: MSC_CL_PULL.v_view_name := 'MRP_AP_UMP_MATERIAL_REQMNTS_V';
795:
796: v_sql_stmt:= ' INSERT INTO MSC_ST_DEMANDS '
797: ||'(SCHEDULE_DESIGNATOR_ID,'

Line 794: MSC_CL_PULL.v_view_name := 'MRP_AP_UMP_MATERIAL_REQMNTS_V';

790: ;
791:
792: COMMIT;
793: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
794: MSC_CL_PULL.v_view_name := 'MRP_AP_UMP_MATERIAL_REQMNTS_V';
795:
796: v_sql_stmt:= ' INSERT INTO MSC_ST_DEMANDS '
797: ||'(SCHEDULE_DESIGNATOR_ID,'
798: ||'ORGANIZATION_ID,'

Line 826: ||' FROM MRP_AP_UMP_MATERIAL_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'

822: ||'x.MAINTENANCE_OBJECT_SOURCE,'
823: ||'x.USING_ASSEMBLY_ITEM_ID,'
824: ||':v_refresh_id,'
825: ||':v_instance_id'
826: ||' FROM MRP_AP_UMP_MATERIAL_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
827: ||' WHERE x.OPERATING_ORG_ID '||MSC_UTIL.v_in_org_str
828:
829: ||' AND x.USING_ASSEMBLY_DEMAND_DATE >= :p_eam_cmro_st_date '
830: ||' AND x.USING_ASSEMBLY_DEMAND_DATE <= :p_eam_cmro_end_date '

Line 831: -- ||' AND (x.RN1 >'||MSC_CL_PULL.v_lrn

827: ||' WHERE x.OPERATING_ORG_ID '||MSC_UTIL.v_in_org_str
828:
829: ||' AND x.USING_ASSEMBLY_DEMAND_DATE >= :p_eam_cmro_st_date '
830: ||' AND x.USING_ASSEMBLY_DEMAND_DATE <= :p_eam_cmro_end_date '
831: -- ||' AND (x.RN1 >'||MSC_CL_PULL.v_lrn
832: -- ||' AND x.RN2 >'||MSC_CL_PULL.v_lrn||')'
833: ;
834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for cmro forecast demands :' ||v_sql_stmt);
835:

Line 832: -- ||' AND x.RN2 >'||MSC_CL_PULL.v_lrn||')'

828:
829: ||' AND x.USING_ASSEMBLY_DEMAND_DATE >= :p_eam_cmro_st_date '
830: ||' AND x.USING_ASSEMBLY_DEMAND_DATE <= :p_eam_cmro_end_date '
831: -- ||' AND (x.RN1 >'||MSC_CL_PULL.v_lrn
832: -- ||' AND x.RN2 >'||MSC_CL_PULL.v_lrn||')'
833: ;
834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for cmro forecast demands :' ||v_sql_stmt);
835:
836: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);

Line 837: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

833: ;
834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for cmro forecast demands :' ||v_sql_stmt);
835:
836: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
837: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
838: MSC_CL_PULL.v_instance_id
839: ,p_eam_cmro_st_date
840: ,p_eam_cmro_end_date;
841: COMMIT;

Line 838: MSC_CL_PULL.v_instance_id

834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for cmro forecast demands :' ||v_sql_stmt);
835:
836: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
837: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
838: MSC_CL_PULL.v_instance_id
839: ,p_eam_cmro_st_date
840: ,p_eam_cmro_end_date;
841: COMMIT;
842:

Line 843: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_REQUIREMENTS';

839: ,p_eam_cmro_st_date
840: ,p_eam_cmro_end_date;
841: COMMIT;
842:
843: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_REQUIREMENTS';
844: MSC_CL_PULL.v_view_name := 'MRP_AP_UMP_RESOURCE_REQMNTS_V';
845:
846: IF (nvl(fnd_profile.value('MSC_INFLATE_WIP') ,'N')= 'N') THEN
847: lv_inflate_wip := 2 ;

Line 844: MSC_CL_PULL.v_view_name := 'MRP_AP_UMP_RESOURCE_REQMNTS_V';

840: ,p_eam_cmro_end_date;
841: COMMIT;
842:
843: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_REQUIREMENTS';
844: MSC_CL_PULL.v_view_name := 'MRP_AP_UMP_RESOURCE_REQMNTS_V';
845:
846: IF (nvl(fnd_profile.value('MSC_INFLATE_WIP') ,'N')= 'N') THEN
847: lv_inflate_wip := 2 ;
848: ELSE

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

850: END IF;
851:
852: -- if the profile MSC_INFLATE_WIP is set to YES then inflating the operation resource hours
853: -- and touch time by efficiency and utilization.
854: IF lv_inflate_wip = 1 AND MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
855: v_temp_sql := ' (x.TOTAL_QUANTITY *(1/x.utilization)*(1/x.efficiency)) OPERATION_HOURS_REQUIRED,'||
856: ' (x.TOTAL_QUANTITY * (1/x.efficiency)) TOUCH_TIME,';
857: v_temp_whr := ' AND (x.ENTITY_TYPE <>5 or ((x.TOTAL_QUANTITY * (1/x.utilization)* (1/x.efficiency)) - x.HOURS_EXPENDED) >0) ';
858: ELSE

Line 899: ||' FROM MRP_AP_UMP_RESOURCE_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'

895: ||'x.SUPPLY_TYPE,'
896: ||'x.due_date,'
897: ||':v_refresh_id,'
898: ||':v_instance_id'
899: ||' FROM MRP_AP_UMP_RESOURCE_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
900: ||' WHERE x.OPERATING_ORG_ID '||MSC_UTIL.v_in_org_str
901: ||' AND x.DUE_DATE >= :p_eam_cmro_st_date '
902: ||' AND x.DUE_DATE <= :p_eam_cmro_end_date '
903: || v_temp_whr

Line 909: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

905:
906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast resource :' ||v_sql_stmt);
907:
908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
909: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
910: MSC_CL_PULL.v_instance_id
911: ,p_eam_cmro_st_date
912: ,p_eam_cmro_end_date;
913:

Line 910: MSC_CL_PULL.v_instance_id

906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast resource :' ||v_sql_stmt);
907:
908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
909: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
910: MSC_CL_PULL.v_instance_id
911: ,p_eam_cmro_st_date
912: ,p_eam_cmro_end_date;
913:
914: COMMIT;

Line 916: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';

912: ,p_eam_cmro_end_date;
913:
914: COMMIT;
915:
916: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';
917: MSC_CL_PULL.v_view_name := 'MRP_AP_DESIGNATORS_V';
918:
919:
920: v_sql_stmt:= ' INSERT INTO MSC_ST_DESIGNATORS( '

Line 917: MSC_CL_PULL.v_view_name := 'MRP_AP_DESIGNATORS_V';

913:
914: COMMIT;
915:
916: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';
917: MSC_CL_PULL.v_view_name := 'MRP_AP_DESIGNATORS_V';
918:
919:
920: v_sql_stmt:= ' INSERT INTO MSC_ST_DESIGNATORS( '
921: -- ||'(DESIGNATOR_ID, '

Line 947: ||' MRP_AP_AHL_DESIGNATORS_V'||MSC_CL_PULL.v_dblink||' x';

943: ||' 2,'
944: ||':v_refresh_id,'
945: ||':v_instance_id '
946: ||' FROM '
947: ||' MRP_AP_AHL_DESIGNATORS_V'||MSC_CL_PULL.v_dblink||' x';
948: --||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
949:
950:
951: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;

Line 951: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;

947: ||' MRP_AP_AHL_DESIGNATORS_V'||MSC_CL_PULL.v_dblink||' x';
948: --||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
949:
950:
951: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;
952:
953: COMMIT;
954:
955:

Line 965: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

961: BEGIN
962:
963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS ');
964:
965: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
966: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
967: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
968:
969: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 966: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';

962:
963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS ');
964:
965: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
966: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
967: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
968:
969: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
970: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS in v_lrnn'||MSC_CL_PULL.v_lrnn);

Line 967: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';

963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS ');
964:
965: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
966: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
967: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
968:
969: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
970: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS in v_lrnn'||MSC_CL_PULL.v_lrnn);
971:

Line 969: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

965: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
966: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
967: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
968:
969: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
970: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS in v_lrnn'||MSC_CL_PULL.v_lrnn);
971:
972: v_sql_stmt:= ' INSERT INTO MSC_ST_RESERVATIONS'
973: ||' ( TRANSACTION_ID,'

Line 970: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS in v_lrnn'||MSC_CL_PULL.v_lrnn);

966: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
967: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
968:
969: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
970: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS in v_lrnn'||MSC_CL_PULL.v_lrnn);
971:
972: v_sql_stmt:= ' INSERT INTO MSC_ST_RESERVATIONS'
973: ||' ( TRANSACTION_ID,'
974: ||' ORGANIZATION_ID,'

Line 985: ||MSC_CL_PULL.V_DBLINK||' x'

981: ||' 1,'
982: ||' :v_refresh_id,'
983: ||' :v_instance_id'
984: ||' FROM MRP_AD_HARD_RESERVATIONS_V'
985: ||MSC_CL_PULL.V_DBLINK||' x'
986: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
987: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
988:
989: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 986: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn

982: ||' :v_refresh_id,'
983: ||' :v_instance_id'
984: ||' FROM MRP_AD_HARD_RESERVATIONS_V'
985: ||MSC_CL_PULL.V_DBLINK||' x'
986: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
987: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
988:
989: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
990: MSC_CL_PULL.v_instance_id;

Line 989: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

985: ||MSC_CL_PULL.V_DBLINK||' x'
986: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
987: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
988:
989: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
990: MSC_CL_PULL.v_instance_id;
991: COMMIT;
992: END IF;
993:

Line 990: MSC_CL_PULL.v_instance_id;

986: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
987: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
988:
989: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
990: MSC_CL_PULL.v_instance_id;
991: COMMIT;
992: END IF;
993:
994: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';

Line 994: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';

990: MSC_CL_PULL.v_instance_id;
991: COMMIT;
992: END IF;
993:
994: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
995: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_CMRO_RESERVATIONS_V';
996:
997: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
998: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '

Line 995: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_CMRO_RESERVATIONS_V';

991: COMMIT;
992: END IF;
993:
994: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
995: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_CMRO_RESERVATIONS_V';
996:
997: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
998: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
999: ||' SELECT '

Line 997: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

993:
994: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
995: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_CMRO_RESERVATIONS_V';
996:
997: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
998: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
999: ||' SELECT '
1000: ||'x.RESERVATION_ID * 2,'
1001: ||'x.DEMAND_SOURCE_HEADER_ID,'

Line 998: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '

994: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
995: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_CMRO_RESERVATIONS_V';
996:
997: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
998: v_union_sql := ' AND x.RN1> '||MSC_CL_PULL.v_lrn||' UNION '
999: ||' SELECT '
1000: ||'x.RESERVATION_ID * 2,'
1001: ||'x.DEMAND_SOURCE_HEADER_ID,'
1002: ||'x.DEMAND_SOURCE_LINE_ID,'

Line 1018: ||MSC_CL_PULL.v_dblink||' x'

1014: ||'2,'
1015: ||' :v_refresh_id,'
1016: ||' :v_instance_id'
1017: ||' FROM MRP_AP_CMRO_RESERVATIONS_V'
1018: ||MSC_CL_PULL.v_dblink||' x'
1019: ||' WHERE x.ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str
1020: ||' AND x.RN2> '||MSC_CL_PULL.v_lrn;
1021: ELSE
1022: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn

Line 1020: ||' AND x.RN2> '||MSC_CL_PULL.v_lrn;

1016: ||' :v_instance_id'
1017: ||' FROM MRP_AP_CMRO_RESERVATIONS_V'
1018: ||MSC_CL_PULL.v_dblink||' x'
1019: ||' WHERE x.ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str
1020: ||' AND x.RN2> '||MSC_CL_PULL.v_lrn;
1021: ELSE
1022: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1023: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
1024: END IF;

Line 1022: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn

1018: ||MSC_CL_PULL.v_dblink||' x'
1019: ||' WHERE x.ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str
1020: ||' AND x.RN2> '||MSC_CL_PULL.v_lrn;
1021: ELSE
1022: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1023: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
1024: END IF;
1025:
1026: v_sql_stmt:= ' INSERT INTO MSC_ST_RESERVATIONS'

Line 1023: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';

1019: ||' WHERE x.ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str
1020: ||' AND x.RN2> '||MSC_CL_PULL.v_lrn;
1021: ELSE
1022: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1023: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
1024: END IF;
1025:
1026: v_sql_stmt:= ' INSERT INTO MSC_ST_RESERVATIONS'
1027: ||'(TRANSACTION_ID,'

Line 1063: ||MSC_CL_PULL.v_dblink||' x'

1059: ||'2,'
1060: ||' :v_refresh_id,'
1061: ||' :v_instance_id'
1062: ||' FROM MRP_AP_CMRO_RESERVATIONS_V'
1063: ||MSC_CL_PULL.v_dblink||' x'
1064: ||' WHERE x.ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str
1065: ||v_union_sql;
1066:
1067: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 1067: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

1063: ||MSC_CL_PULL.v_dblink||' x'
1064: ||' WHERE x.ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str
1065: ||v_union_sql;
1066:
1067: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1068: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1069: MSC_CL_PULL.v_instance_id,
1070: MSC_CL_PULL.v_refresh_id,
1071: MSC_CL_PULL.v_instance_id;

Line 1068: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1064: ||' WHERE x.ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str
1065: ||v_union_sql;
1066:
1067: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1068: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1069: MSC_CL_PULL.v_instance_id,
1070: MSC_CL_PULL.v_refresh_id,
1071: MSC_CL_PULL.v_instance_id;
1072: ELSE

Line 1069: MSC_CL_PULL.v_instance_id,

1065: ||v_union_sql;
1066:
1067: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1068: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1069: MSC_CL_PULL.v_instance_id,
1070: MSC_CL_PULL.v_refresh_id,
1071: MSC_CL_PULL.v_instance_id;
1072: ELSE
1073: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 1070: MSC_CL_PULL.v_refresh_id,

1066:
1067: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1068: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1069: MSC_CL_PULL.v_instance_id,
1070: MSC_CL_PULL.v_refresh_id,
1071: MSC_CL_PULL.v_instance_id;
1072: ELSE
1073: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1074: MSC_CL_PULL.v_instance_id;

Line 1071: MSC_CL_PULL.v_instance_id;

1067: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1068: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1069: MSC_CL_PULL.v_instance_id,
1070: MSC_CL_PULL.v_refresh_id,
1071: MSC_CL_PULL.v_instance_id;
1072: ELSE
1073: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1074: MSC_CL_PULL.v_instance_id;
1075: END IF;

Line 1073: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1069: MSC_CL_PULL.v_instance_id,
1070: MSC_CL_PULL.v_refresh_id,
1071: MSC_CL_PULL.v_instance_id;
1072: ELSE
1073: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1074: MSC_CL_PULL.v_instance_id;
1075: END IF;
1076: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
1077:

Line 1074: MSC_CL_PULL.v_instance_id;

1070: MSC_CL_PULL.v_refresh_id,
1071: MSC_CL_PULL.v_instance_id;
1072: ELSE
1073: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1074: MSC_CL_PULL.v_instance_id;
1075: END IF;
1076: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
1077:
1078: END LOAD_SUPPLY_RESERVATIONS;

Line 1084: IF MSC_CL_PULL.v_lrnn<> -1 THEN

1080: PROCEDURE LOAD_CLOSED_CMRO_WOS IS
1081: BEGIN
1082: -- ===================start Closed CMRO jobs =====================
1083:
1084: IF MSC_CL_PULL.v_lrnn<> -1 THEN
1085: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1086: MSC_CL_PULL.v_view_name := 'MRP_AD_CMRO_CLOSED_JOBS_V';
1087:
1088: v_sql_stmt:=

Line 1085: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

1081: BEGIN
1082: -- ===================start Closed CMRO jobs =====================
1083:
1084: IF MSC_CL_PULL.v_lrnn<> -1 THEN
1085: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1086: MSC_CL_PULL.v_view_name := 'MRP_AD_CMRO_CLOSED_JOBS_V';
1087:
1088: v_sql_stmt:=
1089: ' insert into MSC_ST_SUPPLIES'

Line 1086: MSC_CL_PULL.v_view_name := 'MRP_AD_CMRO_CLOSED_JOBS_V';

1082: -- ===================start Closed CMRO jobs =====================
1083:
1084: IF MSC_CL_PULL.v_lrnn<> -1 THEN
1085: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1086: MSC_CL_PULL.v_view_name := 'MRP_AD_CMRO_CLOSED_JOBS_V';
1087:
1088: v_sql_stmt:=
1089: ' insert into MSC_ST_SUPPLIES'
1090: ||' ( DISPOSITION_ID,'

Line 1105: ||' from MRP_AD_CMRO_CLOSED_JOBS_V'||MSC_CL_PULL.v_dblink||' x'

1101: ||' x.MAINTENANCE_OBJECT_SOURCE,'
1102: ||' 1,'
1103: ||' :v_refresh_id,'
1104: ||' :v_instance_id'
1105: ||' from MRP_AD_CMRO_CLOSED_JOBS_V'||MSC_CL_PULL.v_dblink||' x'
1106: ||' WHERE x.RN> :v_lrn '
1107: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1108:
1109: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

Line 1109: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

1105: ||' from MRP_AD_CMRO_CLOSED_JOBS_V'||MSC_CL_PULL.v_dblink||' x'
1106: ||' WHERE x.RN> :v_lrn '
1107: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1108:
1109: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1110:
1111: COMMIT;
1112: END IF;
1113:

Line 1114: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

1110:
1111: COMMIT;
1112: END IF;
1113:
1114: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1115:
1116: v_union_sql :=
1117: ' AND x.RN1 > :v_lrn '
1118: ||' UNION '

Line 1155: ||' from MRP_AP_CMRO_CLOSED_JOBS_V'||MSC_CL_PULL.v_dblink||' x'

1151: ||' x.description,'
1152: ||' x.maintenance_object_type,'
1153: ||' :v_refresh_id,'
1154: ||' :v_instance_id'
1155: ||' from MRP_AP_CMRO_CLOSED_JOBS_V'||MSC_CL_PULL.v_dblink||' x'
1156: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1157: ||' AND x.RN2 > :v_lrn ';
1158:
1159: ELSE

Line 1165: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

1161: v_union_sql := ' ';
1162:
1163: END IF;
1164:
1165: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1166: MSC_CL_PULL.v_view_name := 'MRP_AP_CMRO_CLOSED_JOBS_V';
1167:
1168: v_sql_stmt:=
1169: 'insert into MSC_ST_SUPPLIES'

Line 1166: MSC_CL_PULL.v_view_name := 'MRP_AP_CMRO_CLOSED_JOBS_V';

1162:
1163: END IF;
1164:
1165: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1166: MSC_CL_PULL.v_view_name := 'MRP_AP_CMRO_CLOSED_JOBS_V';
1167:
1168: v_sql_stmt:=
1169: 'insert into MSC_ST_SUPPLIES'
1170: ||' ( INVENTORY_ITEM_ID,'

Line 1241: ||' from MRP_AP_CMRO_CLOSED_JOBS_V '||MSC_CL_PULL.v_dblink||' x'

1237: ||' x.description,'
1238: ||' x.maintenance_object_type,'
1239: ||' :v_refresh_id,'
1240: ||' :v_instance_id'
1241: ||' from MRP_AP_CMRO_CLOSED_JOBS_V '||MSC_CL_PULL.v_dblink||' x'
1242: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1243:
1244: v_sql_stmt:= v_sql_stmt || v_union_sql;
1245:

Line 1246: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

1242: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1243:
1244: v_sql_stmt:= v_sql_stmt || v_union_sql;
1245:
1246: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1247: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1248: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,
1249: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1250: MSC_CL_PULL.v_lrn,

Line 1248: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,

1244: v_sql_stmt:= v_sql_stmt || v_union_sql;
1245:
1246: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1247: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1248: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,
1249: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1250: MSC_CL_PULL.v_lrn,
1251: MSC_CL_PULL.v_dgmt,
1252: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 1249: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

1245:
1246: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1247: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1248: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,
1249: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1250: MSC_CL_PULL.v_lrn,
1251: MSC_CL_PULL.v_dgmt,
1252: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1253: MSC_CL_PULL.v_lrn;

Line 1250: MSC_CL_PULL.v_lrn,

1246: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1247: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1248: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,
1249: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1250: MSC_CL_PULL.v_lrn,
1251: MSC_CL_PULL.v_dgmt,
1252: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1253: MSC_CL_PULL.v_lrn;
1254:

Line 1251: MSC_CL_PULL.v_dgmt,

1247: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1248: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,
1249: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1250: MSC_CL_PULL.v_lrn,
1251: MSC_CL_PULL.v_dgmt,
1252: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1253: MSC_CL_PULL.v_lrn;
1254:
1255: ELSE -- For COmplete Refresh

Line 1252: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

1248: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,
1249: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1250: MSC_CL_PULL.v_lrn,
1251: MSC_CL_PULL.v_dgmt,
1252: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1253: MSC_CL_PULL.v_lrn;
1254:
1255: ELSE -- For COmplete Refresh
1256: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,

Line 1253: MSC_CL_PULL.v_lrn;

1249: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1250: MSC_CL_PULL.v_lrn,
1251: MSC_CL_PULL.v_dgmt,
1252: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1253: MSC_CL_PULL.v_lrn;
1254:
1255: ELSE -- For COmplete Refresh
1256: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,
1257: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1256: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,

1252: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1253: MSC_CL_PULL.v_lrn;
1254:
1255: ELSE -- For COmplete Refresh
1256: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,
1257: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1258: END IF;
1259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_CMRO_CLOSED_JOBS_V = '|| SQL%ROWCOUNT);
1260: COMMIT;

Line 1257: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1253: MSC_CL_PULL.v_lrn;
1254:
1255: ELSE -- For COmplete Refresh
1256: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,
1257: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1258: END IF;
1259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_CMRO_CLOSED_JOBS_V = '|| SQL%ROWCOUNT);
1260: COMMIT;
1261: -- ===================end Closed CMRO jobs =====================

Line 1272: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

1268: --v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;
1269:
1270: BEGIN
1271:
1272: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1273: MSC_CL_PULL.v_view_name := 'MRP_AP_OSP_SUP_V';
1274:
1275: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 AND
1276: MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN

Line 1273: MSC_CL_PULL.v_view_name := 'MRP_AP_OSP_SUP_V';

1269:
1270: BEGIN
1271:
1272: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1273: MSC_CL_PULL.v_view_name := 'MRP_AP_OSP_SUP_V';
1274:
1275: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 AND
1276: MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
1277:

Line 1275: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 AND

1271:
1272: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1273: MSC_CL_PULL.v_view_name := 'MRP_AP_OSP_SUP_V';
1274:
1275: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 AND
1276: MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
1277:
1278: v_sql_stmt:=
1279: 'insert into MSC_ST_SUPPLIES'

Line 1315: ||' FROM MRP_AP_OSP_SUP_V '||MSC_CL_PULL.v_dblink||' x'

1311: ||' :v_item_type_good,'
1312: ||' 2,'
1313: ||' :v_refresh_id,'
1314: ||' :v_instance_id'
1315: ||' FROM MRP_AP_OSP_SUP_V '||MSC_CL_PULL.v_dblink||' x'
1316: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str ;
1317:
1318: EXECUTE IMMEDIATE v_sql_stmt USING v_item_type_id,v_item_type_good,
1319: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1319: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1315: ||' FROM MRP_AP_OSP_SUP_V '||MSC_CL_PULL.v_dblink||' x'
1316: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str ;
1317:
1318: EXECUTE IMMEDIATE v_sql_stmt USING v_item_type_id,v_item_type_good,
1319: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1320:
1321: COMMIT;
1322:
1323: END IF;