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_EAM_ODS_LOAD dependencies on MSC_CL_COLLECTION

Line 17: AND mseaa.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

13: mseaa.ASSET_REBUILD_ITEM_ID,
14: mseaa.SR_INSTANCE_ID
15: FROM MSC_ST_EAM_ACT_ASSOCIATIONS mseaa
16: WHERE mseaa.deleted_flag = MSC_UTIL.SYS_YES
17: AND mseaa.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
18:
19: CURSOR c_del2 IS
20: SELECT mseaa.ASSET_GROUP_ITEM_ID,
21: mseaa.ORGANIZATION_ID,

Line 27: AND mseaa.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

23: mseaa.EQUIPMENT_ITEM_ID,
24: mseaa.SR_INSTANCE_ID
25: FROM MSC_ST_EAM_ASSET_EQUIP_DTLS mseaa
26: WHERE mseaa.deleted_flag = MSC_UTIL.SYS_YES
27: AND mseaa.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
28: lv_errbuf VARCHAR2(240);
29: lv_retcode NUMBER;
30: lv_tbl VARCHAR2(30);
31: lv_sql_stmt VARCHAR2(5000);

Line 59: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR

55: lv_SCHEDULE_TO_INSTANCE NUMBER;
56: BEGIN
57: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_INFO ');
58:
59: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
60: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
61: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
62: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
63: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',

Line 60: MSC_CL_COLLECTION.v_is_partial_refresh) THEN

56: BEGIN
57: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_INFO ');
58:
59: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
60: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
61: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
62: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
63: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',
64: MSC_CL_COLLECTION.v_instance_id,

Line 61: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =

57: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_INFO ');
58:
59: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
60: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
61: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
62: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
63: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',
64: MSC_CL_COLLECTION.v_instance_id,
65: -1);

Line 63: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',

59: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
60: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
61: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
62: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
63: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',
64: MSC_CL_COLLECTION.v_instance_id,
65: -1);
66: ELSE
67: MSC_CL_COLLECTION.v_sub_str :=

Line 64: MSC_CL_COLLECTION.v_instance_id,

60: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
61: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
62: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
63: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',
64: MSC_CL_COLLECTION.v_instance_id,
65: -1);
66: ELSE
67: MSC_CL_COLLECTION.v_sub_str :=
68: ' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 67: MSC_CL_COLLECTION.v_sub_str :=

63: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',
64: MSC_CL_COLLECTION.v_instance_id,
65: -1);
66: ELSE
67: MSC_CL_COLLECTION.v_sub_str :=
68: ' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
69: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',
70: MSC_CL_COLLECTION.v_instance_id,
71: null,

Line 69: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',

65: -1);
66: ELSE
67: MSC_CL_COLLECTION.v_sub_str :=
68: ' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
69: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',
70: MSC_CL_COLLECTION.v_instance_id,
71: null,
72: MSC_CL_COLLECTION.v_sub_str);
73: END IF;

Line 70: MSC_CL_COLLECTION.v_instance_id,

66: ELSE
67: MSC_CL_COLLECTION.v_sub_str :=
68: ' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
69: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',
70: MSC_CL_COLLECTION.v_instance_id,
71: null,
72: MSC_CL_COLLECTION.v_sub_str);
73: END IF;
74: END IF;

Line 72: MSC_CL_COLLECTION.v_sub_str);

68: ' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
69: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',
70: MSC_CL_COLLECTION.v_instance_id,
71: null,
72: MSC_CL_COLLECTION.v_sub_str);
73: END IF;
74: END IF;
75:
76: -- ========= Prepare the Cursor Statement ==========

Line 77: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

73: END IF;
74: END IF;
75:
76: -- ========= Prepare the Cursor Statement ==========
77: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
78: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;
79: ELSE
80: lv_tbl:= 'MSC_EAM_ACT_ASSOCIATIONS';
81: END IF;

Line 78: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;

74: END IF;
75:
76: -- ========= Prepare the Cursor Statement ==========
77: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
78: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;
79: ELSE
80: lv_tbl:= 'MSC_EAM_ACT_ASSOCIATIONS';
81: END IF;
82:

Line 96: ||MSC_CL_COLLECTION.v_instance_id

92: ||' FROM MSC_ST_EAM_ACT_ASSOCIATIONS mseaa,'
93: ||' MSC_ITEM_ID_LID m1,'
94: ||' MSC_ITEM_ID_LID m2'
95: ||' WHERE mseaa.SR_INSTANCE_ID= '
96: ||MSC_CL_COLLECTION.v_instance_id
97: --||' AND mseaa.PLAN_ID= -1'
98: ||' AND mseaa.SR_INSTANCE_ID= m1.SR_INSTANCE_ID'
99: ||' AND m1.SR_INVENTORY_ITEM_ID= mseaa.ASSET_ACTIVITY_ID'
100: ||' AND mseaa.SR_INSTANCE_ID= m2.SR_INSTANCE_ID'

Line 134: IF (MSC_CL_COLLECTION.v_is_complete_refresh

130: ||' :v_current_user,'
131: ||' :v_current_date,'
132: ||' :v_current_user)';
133:
134: IF (MSC_CL_COLLECTION.v_is_complete_refresh
135: OR MSC_CL_COLLECTION.v_is_partial_refresh)
136: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
137:
138: BEGIN

Line 135: OR MSC_CL_COLLECTION.v_is_partial_refresh)

131: ||' :v_current_date,'
132: ||' :v_current_user)';
133:
134: IF (MSC_CL_COLLECTION.v_is_complete_refresh
135: OR MSC_CL_COLLECTION.v_is_partial_refresh)
136: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
137:
138: BEGIN
139: lv_sql_ins:= 'insert into '||lv_tbl

Line 136: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

132: ||' :v_current_user)';
133:
134: IF (MSC_CL_COLLECTION.v_is_complete_refresh
135: OR MSC_CL_COLLECTION.v_is_partial_refresh)
136: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
137:
138: BEGIN
139: lv_sql_ins:= 'insert into '||lv_tbl
140: ||' ( ASSET_ACTIVITY_ID,'

Line 171: ||MSC_CL_COLLECTION.v_instance_id

167: ||' FROM MSC_ST_EAM_ACT_ASSOCIATIONS mseaa,'
168: ||' MSC_ITEM_ID_LID m1,'
169: ||' MSC_ITEM_ID_LID m2'
170: ||' WHERE mseaa.SR_INSTANCE_ID= '
171: ||MSC_CL_COLLECTION.v_instance_id
172: --||' AND mseaa.PLAN_ID= -1'
173: ||' AND mseaa.SR_INSTANCE_ID= m1.SR_INSTANCE_ID'
174: ||' AND m1.SR_INVENTORY_ITEM_ID= mseaa.ASSET_ACTIVITY_ID'
175: ||' AND mseaa.SR_INSTANCE_ID= m2.SR_INSTANCE_ID'

Line 182: USING MSC_CL_COLLECTION.v_last_collection_id,

178: ||' AND mseaa.DELETED_FLAG= '||MSC_UTIL.SYS_NO;
179:
180:
181: EXECUTE IMMEDIATE lv_sql_ins
182: USING MSC_CL_COLLECTION.v_last_collection_id,
183: MSC_CL_COLLECTION.v_current_date,
184: MSC_CL_COLLECTION.v_current_user,
185: MSC_CL_COLLECTION.v_current_date,
186: MSC_CL_COLLECTION.v_current_user;

Line 183: MSC_CL_COLLECTION.v_current_date,

179:
180:
181: EXECUTE IMMEDIATE lv_sql_ins
182: USING MSC_CL_COLLECTION.v_last_collection_id,
183: MSC_CL_COLLECTION.v_current_date,
184: MSC_CL_COLLECTION.v_current_user,
185: MSC_CL_COLLECTION.v_current_date,
186: MSC_CL_COLLECTION.v_current_user;
187: COMMIT;

Line 184: MSC_CL_COLLECTION.v_current_user,

180:
181: EXECUTE IMMEDIATE lv_sql_ins
182: USING MSC_CL_COLLECTION.v_last_collection_id,
183: MSC_CL_COLLECTION.v_current_date,
184: MSC_CL_COLLECTION.v_current_user,
185: MSC_CL_COLLECTION.v_current_date,
186: MSC_CL_COLLECTION.v_current_user;
187: COMMIT;
188: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

Line 185: MSC_CL_COLLECTION.v_current_date,

181: EXECUTE IMMEDIATE lv_sql_ins
182: USING MSC_CL_COLLECTION.v_last_collection_id,
183: MSC_CL_COLLECTION.v_current_date,
184: MSC_CL_COLLECTION.v_current_user,
185: MSC_CL_COLLECTION.v_current_date,
186: MSC_CL_COLLECTION.v_current_user;
187: COMMIT;
188: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
189: 'Eam activity associations loaded');

Line 186: MSC_CL_COLLECTION.v_current_user;

182: USING MSC_CL_COLLECTION.v_last_collection_id,
183: MSC_CL_COLLECTION.v_current_date,
184: MSC_CL_COLLECTION.v_current_user,
185: MSC_CL_COLLECTION.v_current_date,
186: MSC_CL_COLLECTION.v_current_user;
187: COMMIT;
188: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
189: 'Eam activity associations loaded');
190: EXCEPTION

Line 212: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
209: END IF;
210: END;
211:
212: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
213: -- OR MSC_CL_COLLECTION.v_is_partial_refresh
214:
215: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
216:

Line 213: -- OR MSC_CL_COLLECTION.v_is_partial_refresh

209: END IF;
210: END;
211:
212: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
213: -- OR MSC_CL_COLLECTION.v_is_partial_refresh
214:
215: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
216:
217: FOR c_rec IN c_del LOOP

Line 215: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

211:
212: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
213: -- OR MSC_CL_COLLECTION.v_is_partial_refresh
214:
215: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
216:
217: FOR c_rec IN c_del LOOP
218: DELETE MSC_EAM_ACT_ASSOCIATIONS
219: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id

Line 225: -- END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh

221: AND ORGANIZATION_ID = c_rec.organization_id
222: AND ASSET_REBUILD_ITEM_ID = c_rec.asset_rebuild_item_id;
223: END LOOP;
224:
225: -- END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh
226:
227: OPEN c4 FOR lv_cursor_stmt;
228: LOOP
229: FETCH c4 INTO lv_ASSET_ACTIVITY_ID,

Line 246: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,

242: SET ACTIVITY = lv_ACTIVITY,
243: ACTIVITY_TYPE =lv_ACTIVITY_TYPE,
244: ASSET_REBUILD_GROUP = lv_ASSET_REBUILD_GROUP,
245: EAM_ITEM_TYPE = lv_EAM_ITEM_TYPE,
246: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
247: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
248: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
249: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
250: AND ASSET_ACTIVITY_ID = lv_asset_activity_id

Line 247: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

243: ACTIVITY_TYPE =lv_ACTIVITY_TYPE,
244: ASSET_REBUILD_GROUP = lv_ASSET_REBUILD_GROUP,
245: EAM_ITEM_TYPE = lv_EAM_ITEM_TYPE,
246: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
247: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
248: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
249: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
250: AND ASSET_ACTIVITY_ID = lv_asset_activity_id
251: AND ORGANIZATION_ID = lv_organization_id

Line 248: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

244: ASSET_REBUILD_GROUP = lv_ASSET_REBUILD_GROUP,
245: EAM_ITEM_TYPE = lv_EAM_ITEM_TYPE,
246: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
247: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
248: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
249: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
250: AND ASSET_ACTIVITY_ID = lv_asset_activity_id
251: AND ORGANIZATION_ID = lv_organization_id
252: AND ASSET_REBUILD_ITEM_ID = lv_asset_rebuild_item_id;

Line 249: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

245: EAM_ITEM_TYPE = lv_EAM_ITEM_TYPE,
246: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
247: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
248: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
249: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
250: AND ASSET_ACTIVITY_ID = lv_asset_activity_id
251: AND ORGANIZATION_ID = lv_organization_id
252: AND ASSET_REBUILD_ITEM_ID = lv_asset_rebuild_item_id;
253: --AND DELETED_FLAG = MSC_UTIL.SYS_NO;

Line 256: IF (MSC_CL_COLLECTION.v_is_complete_refresh

252: AND ASSET_REBUILD_ITEM_ID = lv_asset_rebuild_item_id;
253: --AND DELETED_FLAG = MSC_UTIL.SYS_NO;
254:
255:
256: IF (MSC_CL_COLLECTION.v_is_complete_refresh
257: OR MSC_CL_COLLECTION.v_is_partial_refresh)
258: OR SQL%NOTFOUND THEN
259:
260: EXECUTE IMMEDIATE lv_sql_stmt

Line 257: OR MSC_CL_COLLECTION.v_is_partial_refresh)

253: --AND DELETED_FLAG = MSC_UTIL.SYS_NO;
254:
255:
256: IF (MSC_CL_COLLECTION.v_is_complete_refresh
257: OR MSC_CL_COLLECTION.v_is_partial_refresh)
258: OR SQL%NOTFOUND THEN
259:
260: EXECUTE IMMEDIATE lv_sql_stmt
261: USING lv_ASSET_ACTIVITY_ID,

Line 269: MSC_CL_COLLECTION.v_last_collection_id,

265: lv_ACTIVITY_TYPE,
266: lv_ASSET_REBUILD_GROUP,
267: lv_EAM_ITEM_TYPE,
268: lv_SR_INSTANCE_ID,
269: MSC_CL_COLLECTION.v_last_collection_id,
270: MSC_CL_COLLECTION.v_current_date,
271: MSC_CL_COLLECTION.v_current_user,
272: MSC_CL_COLLECTION.v_current_date,
273: MSC_CL_COLLECTION.v_current_user;

Line 270: MSC_CL_COLLECTION.v_current_date,

266: lv_ASSET_REBUILD_GROUP,
267: lv_EAM_ITEM_TYPE,
268: lv_SR_INSTANCE_ID,
269: MSC_CL_COLLECTION.v_last_collection_id,
270: MSC_CL_COLLECTION.v_current_date,
271: MSC_CL_COLLECTION.v_current_user,
272: MSC_CL_COLLECTION.v_current_date,
273: MSC_CL_COLLECTION.v_current_user;
274:

Line 271: MSC_CL_COLLECTION.v_current_user,

267: lv_EAM_ITEM_TYPE,
268: lv_SR_INSTANCE_ID,
269: MSC_CL_COLLECTION.v_last_collection_id,
270: MSC_CL_COLLECTION.v_current_date,
271: MSC_CL_COLLECTION.v_current_user,
272: MSC_CL_COLLECTION.v_current_date,
273: MSC_CL_COLLECTION.v_current_user;
274:
275: END IF;

Line 272: MSC_CL_COLLECTION.v_current_date,

268: lv_SR_INSTANCE_ID,
269: MSC_CL_COLLECTION.v_last_collection_id,
270: MSC_CL_COLLECTION.v_current_date,
271: MSC_CL_COLLECTION.v_current_user,
272: MSC_CL_COLLECTION.v_current_date,
273: MSC_CL_COLLECTION.v_current_user;
274:
275: END IF;
276:

Line 273: MSC_CL_COLLECTION.v_current_user;

269: MSC_CL_COLLECTION.v_last_collection_id,
270: MSC_CL_COLLECTION.v_current_date,
271: MSC_CL_COLLECTION.v_current_user,
272: MSC_CL_COLLECTION.v_current_date,
273: MSC_CL_COLLECTION.v_current_user;
274:
275: END IF;
276:
277: c_count:= c_count+1;

Line 279: IF c_count> MSC_CL_COLLECTION.PBS THEN

275: END IF;
276:
277: c_count:= c_count+1;
278:
279: IF c_count> MSC_CL_COLLECTION.PBS THEN
280: IF (MSC_CL_COLLECTION.v_is_complete_refresh
281: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
282: COMMIT;
283: END IF;

Line 280: IF (MSC_CL_COLLECTION.v_is_complete_refresh

276:
277: c_count:= c_count+1;
278:
279: IF c_count> MSC_CL_COLLECTION.PBS THEN
280: IF (MSC_CL_COLLECTION.v_is_complete_refresh
281: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
282: COMMIT;
283: END IF;
284: c_count:= 0;

Line 281: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN

277: c_count:= c_count+1;
278:
279: IF c_count> MSC_CL_COLLECTION.PBS THEN
280: IF (MSC_CL_COLLECTION.v_is_complete_refresh
281: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
282: COMMIT;
283: END IF;
284: c_count:= 0;
285: END IF;

Line 300: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
297: RAISE;
298:
299: ELSE
300: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
301:
302: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
303: '========================================');
304: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

Line 313: MSC_CL_COLLECTION.v_instance_id));

309: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
310: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
311: FND_MESSAGE.SET_TOKEN('VALUE',
312: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
313: MSC_CL_COLLECTION.v_instance_id));
314: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
315:
316: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
317: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');

Line 331: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh

327: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
328: END IF;
329: END;
330: END LOOP;
331: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh
332:
333: IF (MSC_CL_COLLECTION.v_is_complete_refresh
334: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
335: COMMIT;

Line 333: IF (MSC_CL_COLLECTION.v_is_complete_refresh

329: END;
330: END LOOP;
331: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh
332:
333: IF (MSC_CL_COLLECTION.v_is_complete_refresh
334: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
335: COMMIT;
336: END IF;
337:

Line 334: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN

330: END LOOP;
331: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh
332:
333: IF (MSC_CL_COLLECTION.v_is_complete_refresh
334: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
335: COMMIT;
336: END IF;
337:
338: BEGIN

Line 339: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <>

335: COMMIT;
336: END IF;
337:
338: BEGIN
339: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <>
340: MSC_UTIL.G_ALL_ORGANIZATIONS )
341: AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
342:
343: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;

Line 341: AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

337:
338: BEGIN
339: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <>
340: MSC_UTIL.G_ALL_ORGANIZATIONS )
341: AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
342:
343: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;
344: lv_sql_stmt:= 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
345: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_EAM_ACT_ASSOCIATIONS'

Line 343: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;

339: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <>
340: MSC_UTIL.G_ALL_ORGANIZATIONS )
341: AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
342:
343: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;
344: lv_sql_stmt:= 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
345: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_EAM_ACT_ASSOCIATIONS'
346: ||' WHERE sr_instance_id = '
347: ||MSC_CL_COLLECTION.v_instance_id

Line 347: ||MSC_CL_COLLECTION.v_instance_id

343: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;
344: lv_sql_stmt:= 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
345: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_EAM_ACT_ASSOCIATIONS'
346: ||' WHERE sr_instance_id = '
347: ||MSC_CL_COLLECTION.v_instance_id
348: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
349:
350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '
351: ||lv_sql_stmt);

Line 362: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
359: RAISE;
360: END;
361:
362: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
363: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
364: lv_retcode,
365: 'MSC_EAM_ACT_ASSOCIATIONS',
366: MSC_CL_COLLECTION.v_instance_code,

Line 363: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,

359: RAISE;
360: END;
361:
362: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
363: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
364: lv_retcode,
365: 'MSC_EAM_ACT_ASSOCIATIONS',
366: MSC_CL_COLLECTION.v_instance_code,
367: MSC_UTIL.G_WARNING

Line 366: MSC_CL_COLLECTION.v_instance_code,

362: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
363: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
364: lv_retcode,
365: 'MSC_EAM_ACT_ASSOCIATIONS',
366: MSC_CL_COLLECTION.v_instance_code,
367: MSC_UTIL.G_WARNING
368: );
369:
370: IF lv_retcode = MSC_UTIL.G_ERROR THEN

Line 372: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

368: );
369:
370: IF lv_retcode = MSC_UTIL.G_ERROR THEN
371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
372: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
373: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
374: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
375: END IF;
376: END IF;

Line 374: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

370: IF lv_retcode = MSC_UTIL.G_ERROR THEN
371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
372: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
373: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
374: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
375: END IF;
376: END IF;
377:
378:

Line 382: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR

378:
379: /*--------- PS requirements - New table to collect asset number details ---------*/
380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_INFO -- EAM asset Equip');
381:
382: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
383: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
384: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
385: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
386: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',

Line 383: MSC_CL_COLLECTION.v_is_partial_refresh) THEN

379: /*--------- PS requirements - New table to collect asset number details ---------*/
380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_INFO -- EAM asset Equip');
381:
382: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
383: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
384: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
385: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
386: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',
387: MSC_CL_COLLECTION.v_instance_id,

Line 384: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =

380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_INFO -- EAM asset Equip');
381:
382: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
383: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
384: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
385: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
386: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',
387: MSC_CL_COLLECTION.v_instance_id,
388: -1);

Line 386: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',

382: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
383: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
384: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
385: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
386: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',
387: MSC_CL_COLLECTION.v_instance_id,
388: -1);
389: ELSE
390: MSC_CL_COLLECTION.v_sub_str :=

Line 387: MSC_CL_COLLECTION.v_instance_id,

383: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
384: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
385: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
386: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',
387: MSC_CL_COLLECTION.v_instance_id,
388: -1);
389: ELSE
390: MSC_CL_COLLECTION.v_sub_str :=
391: ' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 390: MSC_CL_COLLECTION.v_sub_str :=

386: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',
387: MSC_CL_COLLECTION.v_instance_id,
388: -1);
389: ELSE
390: MSC_CL_COLLECTION.v_sub_str :=
391: ' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
392: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',
393: MSC_CL_COLLECTION.v_instance_id,
394: null,

Line 392: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',

388: -1);
389: ELSE
390: MSC_CL_COLLECTION.v_sub_str :=
391: ' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
392: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',
393: MSC_CL_COLLECTION.v_instance_id,
394: null,
395: MSC_CL_COLLECTION.v_sub_str);
396: END IF;

Line 393: MSC_CL_COLLECTION.v_instance_id,

389: ELSE
390: MSC_CL_COLLECTION.v_sub_str :=
391: ' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
392: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',
393: MSC_CL_COLLECTION.v_instance_id,
394: null,
395: MSC_CL_COLLECTION.v_sub_str);
396: END IF;
397: END IF;

Line 395: MSC_CL_COLLECTION.v_sub_str);

391: ' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
392: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ASSET_EQUIP_DTLS',
393: MSC_CL_COLLECTION.v_instance_id,
394: null,
395: MSC_CL_COLLECTION.v_sub_str);
396: END IF;
397: END IF;
398:
399: -- ========= Prepare the Cursor Statement ==========

Line 400: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

396: END IF;
397: END IF;
398:
399: -- ========= Prepare the Cursor Statement ==========
400: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
401: lv_tbl:= 'EAM_ASSET_EQUIP_DTLS_'||MSC_CL_COLLECTION.v_instance_code;
402: ELSE
403: lv_tbl:= 'MSC_EAM_ASSET_EQUIP_DTLS';
404: END IF;

Line 401: lv_tbl:= 'EAM_ASSET_EQUIP_DTLS_'||MSC_CL_COLLECTION.v_instance_code;

397: END IF;
398:
399: -- ========= Prepare the Cursor Statement ==========
400: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
401: lv_tbl:= 'EAM_ASSET_EQUIP_DTLS_'||MSC_CL_COLLECTION.v_instance_code;
402: ELSE
403: lv_tbl:= 'MSC_EAM_ASSET_EQUIP_DTLS';
404: END IF;
405:

Line 424: ||MSC_CL_COLLECTION.v_instance_id

420: ||' MSC_ITEM_ID_LID m1,'
421: ||' MSC_ITEM_ID_LID m2,'
422: ||' MSC_ITEM_ID_LID m3'
423: ||' WHERE mse.SR_INSTANCE_ID= '
424: ||MSC_CL_COLLECTION.v_instance_id
425: ||' AND mse.SR_INSTANCE_ID= m1.SR_INSTANCE_ID'
426: ||' AND m1.SR_INVENTORY_ITEM_ID= mse.ASSET_GROUP_ITEM_ID'
427: ||' AND mse.SR_INSTANCE_ID= m2.SR_INSTANCE_ID'
428: ||' AND m2.SR_INVENTORY_ITEM_ID= mse.ASSET_ACTIVITY_ID'

Line 471: IF (MSC_CL_COLLECTION.v_is_complete_refresh

467: ||' :v_current_user,'
468: ||' :v_current_date,'
469: ||' :v_current_user)';
470:
471: IF (MSC_CL_COLLECTION.v_is_complete_refresh
472: OR MSC_CL_COLLECTION.v_is_partial_refresh)
473: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
474:
475: BEGIN

Line 472: OR MSC_CL_COLLECTION.v_is_partial_refresh)

468: ||' :v_current_date,'
469: ||' :v_current_user)';
470:
471: IF (MSC_CL_COLLECTION.v_is_complete_refresh
472: OR MSC_CL_COLLECTION.v_is_partial_refresh)
473: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
474:
475: BEGIN
476: lv_sql_ins:= 'insert into '||lv_tbl

Line 473: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

469: ||' :v_current_user)';
470:
471: IF (MSC_CL_COLLECTION.v_is_complete_refresh
472: OR MSC_CL_COLLECTION.v_is_partial_refresh)
473: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
474:
475: BEGIN
476: lv_sql_ins:= 'insert into '||lv_tbl
477: ||'(ASSET_GROUP_ITEM_ID,'

Line 517: ||MSC_CL_COLLECTION.v_instance_id

513: ||' MSC_ITEM_ID_LID m1,'
514: ||' MSC_ITEM_ID_LID m2,'
515: ||' MSC_ITEM_ID_LID m3'
516: ||' WHERE mse.SR_INSTANCE_ID= '
517: ||MSC_CL_COLLECTION.v_instance_id
518: ||' AND mse.SR_INSTANCE_ID= m1.SR_INSTANCE_ID'
519: ||' AND m1.SR_INVENTORY_ITEM_ID= mse.ASSET_GROUP_ITEM_ID'
520: ||' AND mse.SR_INSTANCE_ID= m2.SR_INSTANCE_ID'
521: ||' AND m2.SR_INVENTORY_ITEM_ID= mse.ASSET_ACTIVITY_ID'

Line 528: USING MSC_CL_COLLECTION.v_last_collection_id,

524: ||' AND mse.DELETED_FLAG= '||MSC_UTIL.SYS_NO;
525:
526:
527: EXECUTE IMMEDIATE lv_sql_ins
528: USING MSC_CL_COLLECTION.v_last_collection_id,
529: MSC_CL_COLLECTION.v_current_date,
530: MSC_CL_COLLECTION.v_current_user,
531: MSC_CL_COLLECTION.v_current_date,
532: MSC_CL_COLLECTION.v_current_user;

Line 529: MSC_CL_COLLECTION.v_current_date,

525:
526:
527: EXECUTE IMMEDIATE lv_sql_ins
528: USING MSC_CL_COLLECTION.v_last_collection_id,
529: MSC_CL_COLLECTION.v_current_date,
530: MSC_CL_COLLECTION.v_current_user,
531: MSC_CL_COLLECTION.v_current_date,
532: MSC_CL_COLLECTION.v_current_user;
533: COMMIT;

Line 530: MSC_CL_COLLECTION.v_current_user,

526:
527: EXECUTE IMMEDIATE lv_sql_ins
528: USING MSC_CL_COLLECTION.v_last_collection_id,
529: MSC_CL_COLLECTION.v_current_date,
530: MSC_CL_COLLECTION.v_current_user,
531: MSC_CL_COLLECTION.v_current_date,
532: MSC_CL_COLLECTION.v_current_user;
533: COMMIT;
534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

Line 531: MSC_CL_COLLECTION.v_current_date,

527: EXECUTE IMMEDIATE lv_sql_ins
528: USING MSC_CL_COLLECTION.v_last_collection_id,
529: MSC_CL_COLLECTION.v_current_date,
530: MSC_CL_COLLECTION.v_current_user,
531: MSC_CL_COLLECTION.v_current_date,
532: MSC_CL_COLLECTION.v_current_user;
533: COMMIT;
534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
535: 'Eam asset equipment details loaded');

Line 532: MSC_CL_COLLECTION.v_current_user;

528: USING MSC_CL_COLLECTION.v_last_collection_id,
529: MSC_CL_COLLECTION.v_current_date,
530: MSC_CL_COLLECTION.v_current_user,
531: MSC_CL_COLLECTION.v_current_date,
532: MSC_CL_COLLECTION.v_current_user;
533: COMMIT;
534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
535: 'Eam asset equipment details loaded');
536: EXCEPTION

Line 558: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
555: END IF;
556: END;
557:
558: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
559: -- OR MSC_CL_COLLECTION.v_is_partial_refresh
560:
561: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
562:

Line 559: -- OR MSC_CL_COLLECTION.v_is_partial_refresh

555: END IF;
556: END;
557:
558: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
559: -- OR MSC_CL_COLLECTION.v_is_partial_refresh
560:
561: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
562:
563: FOR c_rec IN c_del2 LOOP

Line 561: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

557:
558: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
559: -- OR MSC_CL_COLLECTION.v_is_partial_refresh
560:
561: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
562:
563: FOR c_rec IN c_del2 LOOP
564: DELETE MSC_EAM_ASSET_EQUIP_DTLS
565: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id

Line 572: -- END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh

568: AND ASSET_ACTIVITY_ID = c_rec.ASSET_ACTIVITY_ID
569: AND EQUIPMENT_ITEM_ID = c_rec.EQUIPMENT_ITEM_ID;
570: END LOOP;
571:
572: -- END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh
573:
574: OPEN c4 FOR lv_cursor_stmt;
575: LOOP
576: FETCH c4 INTO lv_ASSET_GROUP_ITEM_ID,

Line 600: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,

596: RESOURCE_ID = lv_RESOURCE_ID,
597: DEPARTMENT_ID = lv_DEPARTMENT_ID,
598: RESOURCE_CODE = lv_RESOURCE_CODE,
599: SCHEDULE_TO_INSTANCE = lv_SCHEDULE_TO_INSTANCE,
600: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
601: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
602: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
603: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
604: AND ASSET_GROUP_ITEM_ID = lv_ASSET_GROUP_ITEM_ID

Line 601: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

597: DEPARTMENT_ID = lv_DEPARTMENT_ID,
598: RESOURCE_CODE = lv_RESOURCE_CODE,
599: SCHEDULE_TO_INSTANCE = lv_SCHEDULE_TO_INSTANCE,
600: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
601: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
602: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
603: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
604: AND ASSET_GROUP_ITEM_ID = lv_ASSET_GROUP_ITEM_ID
605: AND ASSET_ACTIVITY_ID = lv_asset_activity_id

Line 602: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

598: RESOURCE_CODE = lv_RESOURCE_CODE,
599: SCHEDULE_TO_INSTANCE = lv_SCHEDULE_TO_INSTANCE,
600: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
601: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
602: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
603: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
604: AND ASSET_GROUP_ITEM_ID = lv_ASSET_GROUP_ITEM_ID
605: AND ASSET_ACTIVITY_ID = lv_asset_activity_id
606: AND ORGANIZATION_ID = lv_organization_id

Line 603: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

599: SCHEDULE_TO_INSTANCE = lv_SCHEDULE_TO_INSTANCE,
600: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
601: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
602: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
603: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
604: AND ASSET_GROUP_ITEM_ID = lv_ASSET_GROUP_ITEM_ID
605: AND ASSET_ACTIVITY_ID = lv_asset_activity_id
606: AND ORGANIZATION_ID = lv_organization_id
607: AND EQUIPMENT_ITEM_ID = lv_EQUIPMENT_ITEM_ID;

Line 610: IF (MSC_CL_COLLECTION.v_is_complete_refresh

606: AND ORGANIZATION_ID = lv_organization_id
607: AND EQUIPMENT_ITEM_ID = lv_EQUIPMENT_ITEM_ID;
608:
609:
610: IF (MSC_CL_COLLECTION.v_is_complete_refresh
611: OR MSC_CL_COLLECTION.v_is_partial_refresh)
612: OR SQL%NOTFOUND THEN
613:
614: EXECUTE IMMEDIATE lv_sql_stmt

Line 611: OR MSC_CL_COLLECTION.v_is_partial_refresh)

607: AND EQUIPMENT_ITEM_ID = lv_EQUIPMENT_ITEM_ID;
608:
609:
610: IF (MSC_CL_COLLECTION.v_is_complete_refresh
611: OR MSC_CL_COLLECTION.v_is_partial_refresh)
612: OR SQL%NOTFOUND THEN
613:
614: EXECUTE IMMEDIATE lv_sql_stmt
615: USING lv_ASSET_GROUP_ITEM_ID,

Line 627: MSC_CL_COLLECTION.v_last_collection_id,

623: lv_DEPARTMENT_ID,
624: lv_RESOURCE_CODE,
625: lv_SCHEDULE_TO_INSTANCE,
626: lv_SR_INSTANCE_ID,
627: MSC_CL_COLLECTION.v_last_collection_id,
628: MSC_CL_COLLECTION.v_current_date,
629: MSC_CL_COLLECTION.v_current_user,
630: MSC_CL_COLLECTION.v_current_date,
631: MSC_CL_COLLECTION.v_current_user;

Line 628: MSC_CL_COLLECTION.v_current_date,

624: lv_RESOURCE_CODE,
625: lv_SCHEDULE_TO_INSTANCE,
626: lv_SR_INSTANCE_ID,
627: MSC_CL_COLLECTION.v_last_collection_id,
628: MSC_CL_COLLECTION.v_current_date,
629: MSC_CL_COLLECTION.v_current_user,
630: MSC_CL_COLLECTION.v_current_date,
631: MSC_CL_COLLECTION.v_current_user;
632:

Line 629: MSC_CL_COLLECTION.v_current_user,

625: lv_SCHEDULE_TO_INSTANCE,
626: lv_SR_INSTANCE_ID,
627: MSC_CL_COLLECTION.v_last_collection_id,
628: MSC_CL_COLLECTION.v_current_date,
629: MSC_CL_COLLECTION.v_current_user,
630: MSC_CL_COLLECTION.v_current_date,
631: MSC_CL_COLLECTION.v_current_user;
632:
633: END IF;

Line 630: MSC_CL_COLLECTION.v_current_date,

626: lv_SR_INSTANCE_ID,
627: MSC_CL_COLLECTION.v_last_collection_id,
628: MSC_CL_COLLECTION.v_current_date,
629: MSC_CL_COLLECTION.v_current_user,
630: MSC_CL_COLLECTION.v_current_date,
631: MSC_CL_COLLECTION.v_current_user;
632:
633: END IF;
634:

Line 631: MSC_CL_COLLECTION.v_current_user;

627: MSC_CL_COLLECTION.v_last_collection_id,
628: MSC_CL_COLLECTION.v_current_date,
629: MSC_CL_COLLECTION.v_current_user,
630: MSC_CL_COLLECTION.v_current_date,
631: MSC_CL_COLLECTION.v_current_user;
632:
633: END IF;
634:
635: c_count:= c_count+1;

Line 637: IF c_count> MSC_CL_COLLECTION.PBS THEN

633: END IF;
634:
635: c_count:= c_count+1;
636:
637: IF c_count> MSC_CL_COLLECTION.PBS THEN
638: IF (MSC_CL_COLLECTION.v_is_complete_refresh
639: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
640: COMMIT;
641: END IF;

Line 638: IF (MSC_CL_COLLECTION.v_is_complete_refresh

634:
635: c_count:= c_count+1;
636:
637: IF c_count> MSC_CL_COLLECTION.PBS THEN
638: IF (MSC_CL_COLLECTION.v_is_complete_refresh
639: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
640: COMMIT;
641: END IF;
642: c_count:= 0;

Line 639: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN

635: c_count:= c_count+1;
636:
637: IF c_count> MSC_CL_COLLECTION.PBS THEN
638: IF (MSC_CL_COLLECTION.v_is_complete_refresh
639: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
640: COMMIT;
641: END IF;
642: c_count:= 0;
643: END IF;

Line 658: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

654: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
655: RAISE;
656:
657: ELSE
658: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
659:
660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
661: '========================================');
662: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

Line 671: MSC_CL_COLLECTION.v_instance_id));

667: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
668: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
669: FND_MESSAGE.SET_TOKEN('VALUE',
670: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
671: MSC_CL_COLLECTION.v_instance_id));
672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
673:
674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
675: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_GROUP_ITEM_ID');

Line 689: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh

685: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
686: END IF;
687: END;
688: END LOOP;
689: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh
690:
691: IF (MSC_CL_COLLECTION.v_is_complete_refresh
692: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
693: COMMIT;

Line 691: IF (MSC_CL_COLLECTION.v_is_complete_refresh

687: END;
688: END LOOP;
689: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh
690:
691: IF (MSC_CL_COLLECTION.v_is_complete_refresh
692: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
693: COMMIT;
694: END IF;
695:

Line 692: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN

688: END LOOP;
689: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh
690:
691: IF (MSC_CL_COLLECTION.v_is_complete_refresh
692: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
693: COMMIT;
694: END IF;
695:
696: BEGIN

Line 697: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <>

693: COMMIT;
694: END IF;
695:
696: BEGIN
697: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <>
698: MSC_UTIL.G_ALL_ORGANIZATIONS )
699: AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
700:
701: lv_tbl:= 'EAM_ASSET_EQUIP_DTLS_'||MSC_CL_COLLECTION.v_instance_code;

Line 699: AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

695:
696: BEGIN
697: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <>
698: MSC_UTIL.G_ALL_ORGANIZATIONS )
699: AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
700:
701: lv_tbl:= 'EAM_ASSET_EQUIP_DTLS_'||MSC_CL_COLLECTION.v_instance_code;
702: lv_sql_stmt:= 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
703: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_EAM_ASSET_EQUIP_DTLS'

Line 701: lv_tbl:= 'EAM_ASSET_EQUIP_DTLS_'||MSC_CL_COLLECTION.v_instance_code;

697: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <>
698: MSC_UTIL.G_ALL_ORGANIZATIONS )
699: AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
700:
701: lv_tbl:= 'EAM_ASSET_EQUIP_DTLS_'||MSC_CL_COLLECTION.v_instance_code;
702: lv_sql_stmt:= 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
703: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_EAM_ASSET_EQUIP_DTLS'
704: ||' WHERE sr_instance_id = '
705: ||MSC_CL_COLLECTION.v_instance_id

Line 705: ||MSC_CL_COLLECTION.v_instance_id

701: lv_tbl:= 'EAM_ASSET_EQUIP_DTLS_'||MSC_CL_COLLECTION.v_instance_code;
702: lv_sql_stmt:= 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
703: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_EAM_ASSET_EQUIP_DTLS'
704: ||' WHERE sr_instance_id = '
705: ||MSC_CL_COLLECTION.v_instance_id
706: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
707:
708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '
709: ||lv_sql_stmt);

Line 720: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

716: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
717: RAISE;
718: END;
719:
720: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
721: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
722: lv_retcode,
723: 'MSC_EAM_ASSET_EQUIP_DTLS',
724: MSC_CL_COLLECTION.v_instance_code,

Line 721: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,

717: RAISE;
718: END;
719:
720: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
721: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
722: lv_retcode,
723: 'MSC_EAM_ASSET_EQUIP_DTLS',
724: MSC_CL_COLLECTION.v_instance_code,
725: MSC_UTIL.G_WARNING

Line 724: MSC_CL_COLLECTION.v_instance_code,

720: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
721: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
722: lv_retcode,
723: 'MSC_EAM_ASSET_EQUIP_DTLS',
724: MSC_CL_COLLECTION.v_instance_code,
725: MSC_UTIL.G_WARNING
726: );
727:
728: IF lv_retcode = MSC_UTIL.G_ERROR THEN

Line 730: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

726: );
727:
728: IF lv_retcode = MSC_UTIL.G_ERROR THEN
729: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
730: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
731: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
732: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
733: END IF;
734: END IF;

Line 732: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

728: IF lv_retcode = MSC_UTIL.G_ERROR THEN
729: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
730: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
731: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
732: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
733: END IF;
734: END IF;
735:
736: EXCEPTION

Line 775: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

771:
772: COMMIT;
773:
774: BEGIN
775: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
776: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;
777: ELSE
778: lv_tbl:= 'MSC_EAM_ACT_ASSOCIATIONS';
779: END IF;

Line 776: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;

772: COMMIT;
773:
774: BEGIN
775: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
776: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;
777: ELSE
778: lv_tbl:= 'MSC_EAM_ACT_ASSOCIATIONS';
779: END IF;
780: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 833: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

829: EXIT WHEN cgen%NOTFOUND;
830:
831: BEGIN
832:
833: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
834:
835: FOR c_rec IN c1 LOOP
836: UPDATE MSC_EAM_ACT_ASSOCIATIONS
837: SET

Line 842: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,

838: ACTIVITY = c_rec.ACTIVITY,
839: ACTIVITY_TYPE = c_rec.ACTIVITY_TYPE,
840: ASSET_REBUILD_GROUP = c_rec.ASSET_REBUILD_GROUP,
841: EAM_ITEM_TYPE = c_rec.EAM_ITEM_TYPE,
842: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
843: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
844: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
845: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
846: AND ASSET_ACTIVITY_ID = c_rec.asset_activity_id

Line 843: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

839: ACTIVITY_TYPE = c_rec.ACTIVITY_TYPE,
840: ASSET_REBUILD_GROUP = c_rec.ASSET_REBUILD_GROUP,
841: EAM_ITEM_TYPE = c_rec.EAM_ITEM_TYPE,
842: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
843: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
844: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
845: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
846: AND ASSET_ACTIVITY_ID = c_rec.asset_activity_id
847: AND ORGANIZATION_ID = c_rec.organization_id

Line 844: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

840: ASSET_REBUILD_GROUP = c_rec.ASSET_REBUILD_GROUP,
841: EAM_ITEM_TYPE = c_rec.EAM_ITEM_TYPE,
842: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
843: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
844: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
845: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
846: AND ASSET_ACTIVITY_ID = c_rec.asset_activity_id
847: AND ORGANIZATION_ID = c_rec.organization_id
848: AND ASSET_REBUILD_ITEM_ID = c_rec.asset_rebuild_item_id;

Line 845: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

841: EAM_ITEM_TYPE = c_rec.EAM_ITEM_TYPE,
842: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
843: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
844: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
845: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
846: AND ASSET_ACTIVITY_ID = c_rec.asset_activity_id
847: AND ORGANIZATION_ID = c_rec.organization_id
848: AND ASSET_REBUILD_ITEM_ID = c_rec.asset_rebuild_item_id;
849:

Line 852: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN

848: AND ASSET_REBUILD_ITEM_ID = c_rec.asset_rebuild_item_id;
849:
850:
851:
852: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
853:
854: EXECUTE IMMEDIATE lv_sql_stmt
855: USING
856: c_rec.ASSET_ACTIVITY_ID,

Line 864: MSC_CL_COLLECTION.v_last_collection_id,

860: c_rec.ACTIVITY_TYPE,
861: c_rec.ASSET_REBUILD_GROUP,
862: c_rec.EAM_ITEM_TYPE,
863: c_rec.SR_INSTANCE_ID,
864: MSC_CL_COLLECTION.v_last_collection_id,
865: MSC_CL_COLLECTION.v_current_date,
866: MSC_CL_COLLECTION.v_current_user,
867: MSC_CL_COLLECTION.v_current_date,
868: MSC_CL_COLLECTION.v_current_user;

Line 865: MSC_CL_COLLECTION.v_current_date,

861: c_rec.ASSET_REBUILD_GROUP,
862: c_rec.EAM_ITEM_TYPE,
863: c_rec.SR_INSTANCE_ID,
864: MSC_CL_COLLECTION.v_last_collection_id,
865: MSC_CL_COLLECTION.v_current_date,
866: MSC_CL_COLLECTION.v_current_user,
867: MSC_CL_COLLECTION.v_current_date,
868: MSC_CL_COLLECTION.v_current_user;
869:

Line 866: MSC_CL_COLLECTION.v_current_user,

862: c_rec.EAM_ITEM_TYPE,
863: c_rec.SR_INSTANCE_ID,
864: MSC_CL_COLLECTION.v_last_collection_id,
865: MSC_CL_COLLECTION.v_current_date,
866: MSC_CL_COLLECTION.v_current_user,
867: MSC_CL_COLLECTION.v_current_date,
868: MSC_CL_COLLECTION.v_current_user;
869:
870: total_count := total_count + 1;

Line 867: MSC_CL_COLLECTION.v_current_date,

863: c_rec.SR_INSTANCE_ID,
864: MSC_CL_COLLECTION.v_last_collection_id,
865: MSC_CL_COLLECTION.v_current_date,
866: MSC_CL_COLLECTION.v_current_user,
867: MSC_CL_COLLECTION.v_current_date,
868: MSC_CL_COLLECTION.v_current_user;
869:
870: total_count := total_count + 1;
871: END IF;

Line 868: MSC_CL_COLLECTION.v_current_user;

864: MSC_CL_COLLECTION.v_last_collection_id,
865: MSC_CL_COLLECTION.v_current_date,
866: MSC_CL_COLLECTION.v_current_user,
867: MSC_CL_COLLECTION.v_current_date,
868: MSC_CL_COLLECTION.v_current_user;
869:
870: total_count := total_count + 1;
871: END IF;
872:

Line 890: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

886: RAISE;
887:
888: ELSE
889:
890: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
891:
892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
893: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');

Line 916: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

912:
913: COMMIT;
914: END;
915:
916: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
917: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
918: lv_retcode,
919: 'MSC_EAM_ACT_ASSOCIATIONS',
920: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 917: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,

913: COMMIT;
914: END;
915:
916: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
917: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
918: lv_retcode,
919: 'MSC_EAM_ACT_ASSOCIATIONS',
920: MSC_CL_COLLECTION.v_INSTANCE_CODE,
921: MSC_UTIL.G_ERROR);

Line 920: MSC_CL_COLLECTION.v_INSTANCE_CODE,

916: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
917: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
918: lv_retcode,
919: 'MSC_EAM_ACT_ASSOCIATIONS',
920: MSC_CL_COLLECTION.v_INSTANCE_CODE,
921: MSC_UTIL.G_ERROR);
922:
923: IF lv_retcode = MSC_UTIL.G_ERROR THEN
924: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 925: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

921: MSC_UTIL.G_ERROR);
922:
923: IF lv_retcode = MSC_UTIL.G_ERROR THEN
924: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
925: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
926: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
927: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
928: END IF;
929: END IF;

Line 927: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

923: IF lv_retcode = MSC_UTIL.G_ERROR THEN
924: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
925: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
926: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
927: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
928: END IF;
929: END IF;
930:
931: EXCEPTION

Line 958: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

954:
955: /*Delete msc_table based on org group ???? wher wil that be handled...*/
956:
957: -- ========= Prepare the Cursor Statement ==========
958: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
959: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
960: ELSE
961: lv_tbl:= 'MSC_SUPPLIES';
962: END IF;

Line 959: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

955: /*Delete msc_table based on org group ???? wher wil that be handled...*/
956:
957: -- ========= Prepare the Cursor Statement ==========
958: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
959: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
960: ELSE
961: lv_tbl:= 'MSC_SUPPLIES';
962: END IF;
963:

Line 964: IF (MSC_CL_COLLECTION.v_is_complete_refresh

960: ELSE
961: lv_tbl:= 'MSC_SUPPLIES';
962: END IF;
963:
964: IF (MSC_CL_COLLECTION.v_is_complete_refresh
965: OR MSC_CL_COLLECTION.v_is_partial_refresh)
966: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
967:
968: BEGIN

Line 965: OR MSC_CL_COLLECTION.v_is_partial_refresh)

961: lv_tbl:= 'MSC_SUPPLIES';
962: END IF;
963:
964: IF (MSC_CL_COLLECTION.v_is_complete_refresh
965: OR MSC_CL_COLLECTION.v_is_partial_refresh)
966: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
967:
968: BEGIN
969:

Line 966: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

962: END IF;
963:
964: IF (MSC_CL_COLLECTION.v_is_complete_refresh
965: OR MSC_CL_COLLECTION.v_is_partial_refresh)
966: AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
967:
968: BEGIN
969:
970: lv_sql_ins := 'insert into '||lv_tbl

Line 1032: ||' AND ms.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

1028: ||' AND t2.SR_INSTANCE_ID= ms.SR_INSTANCE_ID'
1029: ||' AND ms.DELETED_FLAG = '|| MSC_UTIL.SYS_NO
1030: ||' AND ms.SCHEDULE_DESIGNATOR_ID = md.SRC_SIM_FCST_ID'
1031: ||' AND md.SR_INSTANCE_ID= ms.SR_INSTANCE_ID'
1032: ||' AND ms.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1033: ||' AND ms.ORDER_TYPE = 92'
1034: ||' AND ms.MAINTENANCE_OBJECT_SOURCE = 1'
1035: ||' AND md.DESIGNATOR_TYPE = 12'
1036: ||' AND md.organization_id = ms.organization_id '

Line 1042: USING MSC_CL_COLLECTION.v_last_collection_id,

1038:
1039: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Sql stmt - '||lv_sql_ins);
1040:
1041: EXECUTE IMMEDIATE lv_sql_ins
1042: USING MSC_CL_COLLECTION.v_last_collection_id,
1043: MSC_CL_COLLECTION.v_current_date,
1044: MSC_CL_COLLECTION.v_current_user,
1045: MSC_CL_COLLECTION.v_current_date,
1046: MSC_CL_COLLECTION.v_current_user;

Line 1043: MSC_CL_COLLECTION.v_current_date,

1039: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Sql stmt - '||lv_sql_ins);
1040:
1041: EXECUTE IMMEDIATE lv_sql_ins
1042: USING MSC_CL_COLLECTION.v_last_collection_id,
1043: MSC_CL_COLLECTION.v_current_date,
1044: MSC_CL_COLLECTION.v_current_user,
1045: MSC_CL_COLLECTION.v_current_date,
1046: MSC_CL_COLLECTION.v_current_user;
1047:

Line 1044: MSC_CL_COLLECTION.v_current_user,

1040:
1041: EXECUTE IMMEDIATE lv_sql_ins
1042: USING MSC_CL_COLLECTION.v_last_collection_id,
1043: MSC_CL_COLLECTION.v_current_date,
1044: MSC_CL_COLLECTION.v_current_user,
1045: MSC_CL_COLLECTION.v_current_date,
1046: MSC_CL_COLLECTION.v_current_user;
1047:
1048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'no.of rows inserted '||SQL%ROWCOUNT);

Line 1045: MSC_CL_COLLECTION.v_current_date,

1041: EXECUTE IMMEDIATE lv_sql_ins
1042: USING MSC_CL_COLLECTION.v_last_collection_id,
1043: MSC_CL_COLLECTION.v_current_date,
1044: MSC_CL_COLLECTION.v_current_user,
1045: MSC_CL_COLLECTION.v_current_date,
1046: MSC_CL_COLLECTION.v_current_user;
1047:
1048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'no.of rows inserted '||SQL%ROWCOUNT);
1049: COMMIT;

Line 1046: MSC_CL_COLLECTION.v_current_user;

1042: USING MSC_CL_COLLECTION.v_last_collection_id,
1043: MSC_CL_COLLECTION.v_current_date,
1044: MSC_CL_COLLECTION.v_current_user,
1045: MSC_CL_COLLECTION.v_current_date,
1046: MSC_CL_COLLECTION.v_current_user;
1047:
1048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'no.of rows inserted '||SQL%ROWCOUNT);
1049: COMMIT;
1050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Eam forecasts loaded');

Line 1072: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh

1068: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1070: END IF;
1071: END;
1072: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh
1073:
1074:
1075: IF (MSC_CL_COLLECTION.v_is_complete_refresh
1076: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN

Line 1075: IF (MSC_CL_COLLECTION.v_is_complete_refresh

1071: END;
1072: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh
1073:
1074:
1075: IF (MSC_CL_COLLECTION.v_is_complete_refresh
1076: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1077: COMMIT;
1078: END IF;
1079:

Line 1076: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN

1072: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh
1073:
1074:
1075: IF (MSC_CL_COLLECTION.v_is_complete_refresh
1076: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1077: COMMIT;
1078: END IF;
1079:
1080:

Line 1101: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

1097: lv_sql_stmt VARCHAR2(32767);
1098: lv_supplies_tbl VARCHAR2(30);
1099:
1100: BEGIN
1101: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1102: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
1103: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1104: ELSE
1105: lv_tbl:= 'MSC_DEMANDS';

Line 1102: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;

1098: lv_supplies_tbl VARCHAR2(30);
1099:
1100: BEGIN
1101: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1102: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
1103: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1104: ELSE
1105: lv_tbl:= 'MSC_DEMANDS';
1106: lv_supplies_tbl:= 'MSC_SUPPLIES';

Line 1103: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

1099:
1100: BEGIN
1101: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1102: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
1103: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1104: ELSE
1105: lv_tbl:= 'MSC_DEMANDS';
1106: lv_supplies_tbl:= 'MSC_SUPPLIES';
1107: END IF;

Line 1149: ||' AND md.SR_INSTANCE_ID= '|| MSC_CL_COLLECTION.v_instance_id

1145: ||' AND md.ORIGINATION_TYPE = 92'
1146: ||' AND ms.PLAN_ID = -1'
1147: ||' AND ms.NEW_WIP_START_DATE = md.USING_ASSEMBLY_DEMAND_DATE'
1148: ||' AND ms.ORGANIZATION_ID = md.ORGANIZATION_ID'
1149: ||' AND md.SR_INSTANCE_ID= '|| MSC_CL_COLLECTION.v_instance_id
1150: ||' AND t1.SR_INVENTORY_ITEM_ID= md.inventory_item_id '
1151: ||' AND t1.sr_instance_id= '|| MSC_CL_COLLECTION.v_instance_id
1152: ||' AND md.SCHEDULE_DESIGNATOR_ID = md1.SRC_SIM_FCST_ID'
1153: ||' AND md.SR_INSTANCE_ID= md1.SR_INSTANCE_ID'

Line 1151: ||' AND t1.sr_instance_id= '|| MSC_CL_COLLECTION.v_instance_id

1147: ||' AND ms.NEW_WIP_START_DATE = md.USING_ASSEMBLY_DEMAND_DATE'
1148: ||' AND ms.ORGANIZATION_ID = md.ORGANIZATION_ID'
1149: ||' AND md.SR_INSTANCE_ID= '|| MSC_CL_COLLECTION.v_instance_id
1150: ||' AND t1.SR_INVENTORY_ITEM_ID= md.inventory_item_id '
1151: ||' AND t1.sr_instance_id= '|| MSC_CL_COLLECTION.v_instance_id
1152: ||' AND md.SCHEDULE_DESIGNATOR_ID = md1.SRC_SIM_FCST_ID'
1153: ||' AND md.SR_INSTANCE_ID= md1.SR_INSTANCE_ID'
1154: ||' AND md.SR_INSTANCE_ID= ms.SR_INSTANCE_ID'
1155: ||' AND md1.DESIGNATOR_TYPE = 12'

Line 1159: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN

1155: ||' AND md1.DESIGNATOR_TYPE = 12'
1156: ||' AND md1.organization_id = ms.organization_id '
1157: ||' AND md1.designator = ''-23453''';
1158:
1159: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1160:
1161: lv_sql_stmt:=
1162: 'INSERT INTO '||lv_tbl
1163: ||' ( PLAN_ID,'

Line 1189: MSC_CL_COLLECTION.v_last_collection_id,

1185:
1186: SAVEPOINT Load_eam_dem;
1187: EXECUTE IMMEDIATE lv_sql_stmt
1188: USING
1189: MSC_CL_COLLECTION.v_last_collection_id,
1190: MSC_CL_COLLECTION.v_current_date,
1191: MSC_CL_COLLECTION.v_current_user,
1192: MSC_CL_COLLECTION.v_current_date,
1193: MSC_CL_COLLECTION.v_current_user;

Line 1190: MSC_CL_COLLECTION.v_current_date,

1186: SAVEPOINT Load_eam_dem;
1187: EXECUTE IMMEDIATE lv_sql_stmt
1188: USING
1189: MSC_CL_COLLECTION.v_last_collection_id,
1190: MSC_CL_COLLECTION.v_current_date,
1191: MSC_CL_COLLECTION.v_current_user,
1192: MSC_CL_COLLECTION.v_current_date,
1193: MSC_CL_COLLECTION.v_current_user;
1194:

Line 1191: MSC_CL_COLLECTION.v_current_user,

1187: EXECUTE IMMEDIATE lv_sql_stmt
1188: USING
1189: MSC_CL_COLLECTION.v_last_collection_id,
1190: MSC_CL_COLLECTION.v_current_date,
1191: MSC_CL_COLLECTION.v_current_user,
1192: MSC_CL_COLLECTION.v_current_date,
1193: MSC_CL_COLLECTION.v_current_user;
1194:
1195: COMMIT;

Line 1192: MSC_CL_COLLECTION.v_current_date,

1188: USING
1189: MSC_CL_COLLECTION.v_last_collection_id,
1190: MSC_CL_COLLECTION.v_current_date,
1191: MSC_CL_COLLECTION.v_current_user,
1192: MSC_CL_COLLECTION.v_current_date,
1193: MSC_CL_COLLECTION.v_current_user;
1194:
1195: COMMIT;
1196: RETURN;

Line 1193: MSC_CL_COLLECTION.v_current_user;

1189: MSC_CL_COLLECTION.v_last_collection_id,
1190: MSC_CL_COLLECTION.v_current_date,
1191: MSC_CL_COLLECTION.v_current_user,
1192: MSC_CL_COLLECTION.v_current_date,
1193: MSC_CL_COLLECTION.v_current_user;
1194:
1195: COMMIT;
1196: RETURN;
1197:

Line 1226: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

1222: lv_sql_stmt VARCHAR2(32767);
1223:
1224: BEGIN
1225:
1226: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1227: lv_tbl:= 'RESOURCE_REQUIREMENTS_'||MSC_CL_COLLECTION.v_instance_code;
1228: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1229: ELSE
1230: lv_tbl:= 'MSC_RESOURCE_REQUIREMENTS';

Line 1227: lv_tbl:= 'RESOURCE_REQUIREMENTS_'||MSC_CL_COLLECTION.v_instance_code;

1223:
1224: BEGIN
1225:
1226: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1227: lv_tbl:= 'RESOURCE_REQUIREMENTS_'||MSC_CL_COLLECTION.v_instance_code;
1228: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1229: ELSE
1230: lv_tbl:= 'MSC_RESOURCE_REQUIREMENTS';
1231: lv_supplies_tbl:= 'MSC_SUPPLIES';

Line 1228: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

1224: BEGIN
1225:
1226: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1227: lv_tbl:= 'RESOURCE_REQUIREMENTS_'||MSC_CL_COLLECTION.v_instance_code;
1228: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1229: ELSE
1230: lv_tbl:= 'MSC_RESOURCE_REQUIREMENTS';
1231: lv_supplies_tbl:= 'MSC_SUPPLIES';
1232: END IF;

Line 1274: ||' AND mrr.SR_INSTANCE_ID='|| MSC_CL_COLLECTION.v_instance_id

1270: ||' AND ms.SCHEDULE_DESIGNATOR_ID = md1.DESIGNATOR_ID'
1271: ||' AND ms.SOURCE_ITEM_ID = mrr.INVENTORY_ITEM_ID'
1272: ||' AND ms.NEW_WIP_START_DATE = mrr.START_DATE'
1273: ||' AND ms.ORGANIZATION_ID = mrr.ORGANIZATION_ID'
1274: ||' AND mrr.SR_INSTANCE_ID='|| MSC_CL_COLLECTION.v_instance_id
1275: ||' AND mrr.SCHEDULE_DESIGNATOR_ID = md1.SRC_SIM_FCST_ID'
1276: ||' AND mrr.SR_INSTANCE_ID= md1.SR_INSTANCE_ID'
1277: ||' AND mrr.SR_INSTANCE_ID= ms.SR_INSTANCE_ID'
1278: ||' AND md1.DESIGNATOR_TYPE = 12'

Line 1281: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN

1277: ||' AND mrr.SR_INSTANCE_ID= ms.SR_INSTANCE_ID'
1278: ||' AND md1.DESIGNATOR_TYPE = 12'
1279: ||' AND md1.organization_id = ms.organization_id '
1280: ||' AND md1.designator = ''-23453''';
1281: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1282:
1283: lv_sql_stmt:= 'INSERT INTO '||lv_tbl
1284: ||' ( PLAN_ID,'
1285: ||' TRANSACTION_ID,'

Line 1315: MSC_CL_COLLECTION.v_last_collection_id,

1311:
1312: SAVEPOINT Load_eam_res;
1313: EXECUTE IMMEDIATE lv_sql_stmt
1314: USING
1315: MSC_CL_COLLECTION.v_last_collection_id,
1316: MSC_CL_COLLECTION.v_current_date,
1317: MSC_CL_COLLECTION.v_current_user,
1318: MSC_CL_COLLECTION.v_current_date,
1319: MSC_CL_COLLECTION.v_current_user;

Line 1316: MSC_CL_COLLECTION.v_current_date,

1312: SAVEPOINT Load_eam_res;
1313: EXECUTE IMMEDIATE lv_sql_stmt
1314: USING
1315: MSC_CL_COLLECTION.v_last_collection_id,
1316: MSC_CL_COLLECTION.v_current_date,
1317: MSC_CL_COLLECTION.v_current_user,
1318: MSC_CL_COLLECTION.v_current_date,
1319: MSC_CL_COLLECTION.v_current_user;
1320:

Line 1317: MSC_CL_COLLECTION.v_current_user,

1313: EXECUTE IMMEDIATE lv_sql_stmt
1314: USING
1315: MSC_CL_COLLECTION.v_last_collection_id,
1316: MSC_CL_COLLECTION.v_current_date,
1317: MSC_CL_COLLECTION.v_current_user,
1318: MSC_CL_COLLECTION.v_current_date,
1319: MSC_CL_COLLECTION.v_current_user;
1320:
1321: COMMIT;

Line 1318: MSC_CL_COLLECTION.v_current_date,

1314: USING
1315: MSC_CL_COLLECTION.v_last_collection_id,
1316: MSC_CL_COLLECTION.v_current_date,
1317: MSC_CL_COLLECTION.v_current_user,
1318: MSC_CL_COLLECTION.v_current_date,
1319: MSC_CL_COLLECTION.v_current_user;
1320:
1321: COMMIT;
1322: RETURN;

Line 1319: MSC_CL_COLLECTION.v_current_user;

1315: MSC_CL_COLLECTION.v_last_collection_id,
1316: MSC_CL_COLLECTION.v_current_date,
1317: MSC_CL_COLLECTION.v_current_user,
1318: MSC_CL_COLLECTION.v_current_date,
1319: MSC_CL_COLLECTION.v_current_user;
1320:
1321: COMMIT;
1322: RETURN;
1323:

Line 1399: ||'AND b.SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id

1395: ||'AND b.ACTIVITY_ITEM_ID = mea.ASSET_ACTIVITY_ID '
1396: ||'AND b.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1397: ||'AND b.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '
1398: ||'AND b.PLAN_ID =-1 '
1399: ||'AND b.SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id
1400: ||' AND b.repairable =1 ';
1401:
1402: BEGIN
1403:

Line 1427: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,

1423: ORGANIZATION_ID = lv_ORGANIZATION_ID,
1424: ACTIVITY_ITEM_ID = lv_ASSET_ACTIVITY_ID,
1425: REPAIRABLE = lv_REPAIRABLE,
1426: --PLAN_ID = lv_PLAN_ID,
1427: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1428: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1429: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1430: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1431: AND PLAN_ID = lv_PLAN_ID

Line 1428: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1424: ACTIVITY_ITEM_ID = lv_ASSET_ACTIVITY_ID,
1425: REPAIRABLE = lv_REPAIRABLE,
1426: --PLAN_ID = lv_PLAN_ID,
1427: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1428: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1429: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1430: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1431: AND PLAN_ID = lv_PLAN_ID
1432: AND BILL_SEQUENCE_ID = lv_BILL_SEQUENCE_ID

Line 1429: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

1425: REPAIRABLE = lv_REPAIRABLE,
1426: --PLAN_ID = lv_PLAN_ID,
1427: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1428: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1429: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1430: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1431: AND PLAN_ID = lv_PLAN_ID
1432: AND BILL_SEQUENCE_ID = lv_BILL_SEQUENCE_ID
1433: AND ASSEMBLY_ITEM_ID = lv_ASSET_REBUILD_ITEM_ID

Line 1430: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1426: --PLAN_ID = lv_PLAN_ID,
1427: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1428: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1429: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1430: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1431: AND PLAN_ID = lv_PLAN_ID
1432: AND BILL_SEQUENCE_ID = lv_BILL_SEQUENCE_ID
1433: AND ASSEMBLY_ITEM_ID = lv_ASSET_REBUILD_ITEM_ID
1434: AND ORGANIZATION_ID = lv_organization_id

Line 1477: ||'AND b.SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id

1473: ||'WHERE b.ASSEMBLY_ITEM_ID = mea.ASSET_ACTIVITY_ID '
1474: ||'AND b.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1475: ||'AND b.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '
1476: ||'AND b.PLAN_ID =-1 '
1477: ||'AND b.SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id
1478: ||' and (b.BILL_SEQUENCE_ID,mea.ASSET_REBUILD_ITEM_ID,mea.ASSET_ACTIVITY_ID,b.ORGANIZATION_ID) '
1479: ||' not in '
1480: ||'(select BILL_SEQUENCE_ID,ASSEMBLY_ITEM_ID,ACTIVITY_ITEM_ID,ORGANIZATION_ID '
1481: ||'from MSC_BOMS where PLAN_ID =-1 '

Line 1482: ||' AND SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id ||') ';

1478: ||' and (b.BILL_SEQUENCE_ID,mea.ASSET_REBUILD_ITEM_ID,mea.ASSET_ACTIVITY_ID,b.ORGANIZATION_ID) '
1479: ||' not in '
1480: ||'(select BILL_SEQUENCE_ID,ASSEMBLY_ITEM_ID,ACTIVITY_ITEM_ID,ORGANIZATION_ID '
1481: ||'from MSC_BOMS where PLAN_ID =-1 '
1482: ||' AND SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id ||') ';
1483:
1484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed-- ' || lv_ins_stmt);
1485:
1486: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_COLLECTION.v_last_collection_id,

Line 1486: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_COLLECTION.v_last_collection_id,

1482: ||' AND SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id ||') ';
1483:
1484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed-- ' || lv_ins_stmt);
1485:
1486: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_COLLECTION.v_last_collection_id,
1487: MSC_CL_COLLECTION.v_current_date,
1488: MSC_CL_COLLECTION.v_current_user,
1489: MSC_CL_COLLECTION.v_current_date,
1490: MSC_CL_COLLECTION.v_current_user;

Line 1487: MSC_CL_COLLECTION.v_current_date,

1483:
1484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed-- ' || lv_ins_stmt);
1485:
1486: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_COLLECTION.v_last_collection_id,
1487: MSC_CL_COLLECTION.v_current_date,
1488: MSC_CL_COLLECTION.v_current_user,
1489: MSC_CL_COLLECTION.v_current_date,
1490: MSC_CL_COLLECTION.v_current_user;
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_boms '

Line 1488: MSC_CL_COLLECTION.v_current_user,

1484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed-- ' || lv_ins_stmt);
1485:
1486: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_COLLECTION.v_last_collection_id,
1487: MSC_CL_COLLECTION.v_current_date,
1488: MSC_CL_COLLECTION.v_current_user,
1489: MSC_CL_COLLECTION.v_current_date,
1490: MSC_CL_COLLECTION.v_current_user;
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_boms '
1492: ||SQL%ROWCOUNT);

Line 1489: MSC_CL_COLLECTION.v_current_date,

1485:
1486: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_COLLECTION.v_last_collection_id,
1487: MSC_CL_COLLECTION.v_current_date,
1488: MSC_CL_COLLECTION.v_current_user,
1489: MSC_CL_COLLECTION.v_current_date,
1490: MSC_CL_COLLECTION.v_current_user;
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_boms '
1492: ||SQL%ROWCOUNT);
1493: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');

Line 1490: MSC_CL_COLLECTION.v_current_user;

1486: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_COLLECTION.v_last_collection_id,
1487: MSC_CL_COLLECTION.v_current_date,
1488: MSC_CL_COLLECTION.v_current_user,
1489: MSC_CL_COLLECTION.v_current_date,
1490: MSC_CL_COLLECTION.v_current_user;
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_boms '
1492: ||SQL%ROWCOUNT);
1493: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
1494:

Line 1527: ||'AND mr.SR_INSTANCE_ID = '|| MSC_CL_COLLECTION.v_instance_id;

1523: ||'AND mr.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1524: ||'AND mr.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '
1525: ||'AND mr.repairable=1 '
1526: ||'AND mr.PLAN_ID =-1 '
1527: ||'AND mr.SR_INSTANCE_ID = '|| MSC_CL_COLLECTION.v_instance_id;
1528:
1529:
1530: OPEN c4 FOR lv_cursor_stmt1;
1531: LOOP

Line 1551: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,

1547: ACTIVITY_ITEM_ID = lv_ASSET_ACTIVITY_ID,
1548: ROUTING_TYPE =lv_ROUTING_TYPE,
1549: ORGANIZATION_ID = lv_ORGANIZATION_ID,
1550: REPAIRABLE = lv_REPAIRABLE,
1551: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1552: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1553: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1554: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1555: AND PLAN_ID = lv_PLAN_ID

Line 1552: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1548: ROUTING_TYPE =lv_ROUTING_TYPE,
1549: ORGANIZATION_ID = lv_ORGANIZATION_ID,
1550: REPAIRABLE = lv_REPAIRABLE,
1551: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1552: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1553: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1554: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1555: AND PLAN_ID = lv_PLAN_ID
1556: AND ROUTING_SEQUENCE_ID = lv_ROUTING_SEQUENCE_ID

Line 1553: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

1549: ORGANIZATION_ID = lv_ORGANIZATION_ID,
1550: REPAIRABLE = lv_REPAIRABLE,
1551: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1552: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1553: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1554: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1555: AND PLAN_ID = lv_PLAN_ID
1556: AND ROUTING_SEQUENCE_ID = lv_ROUTING_SEQUENCE_ID
1557: AND ASSEMBLY_ITEM_ID = lv_ASSET_REBUILD_ITEM_ID

Line 1554: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1550: REPAIRABLE = lv_REPAIRABLE,
1551: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1552: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1553: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1554: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1555: AND PLAN_ID = lv_PLAN_ID
1556: AND ROUTING_SEQUENCE_ID = lv_ROUTING_SEQUENCE_ID
1557: AND ASSEMBLY_ITEM_ID = lv_ASSET_REBUILD_ITEM_ID
1558: AND ACTIVITY_ITEM_ID = lv_ASSET_ACTIVITY_ID;

Line 1601: ||'AND mr.SR_INSTANCE_ID = '|| MSC_CL_COLLECTION.v_instance_id

1597: ||'WHERE mr.ASSEMBLY_ITEM_ID = mea.ASSET_ACTIVITY_ID '
1598: ||'AND mr.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1599: ||'AND mr.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '
1600: ||'AND mr.PLAN_ID =-1 '
1601: ||'AND mr.SR_INSTANCE_ID = '|| MSC_CL_COLLECTION.v_instance_id
1602: ||' AND (mr.ROUTING_SEQUENCE_ID,mea.ASSET_REBUILD_ITEM_ID,mea.ASSET_ACTIVITY_ID,mr.ORGANIZATION_ID)'
1603: ||' not in '
1604: ||'(select ROUTING_SEQUENCE_ID, ASSEMBLY_ITEM_ID,ASSET_ACTIVITY_ID,ORGANIZATION_ID '
1605: ||'from MSC_ROUTINGS where PLAN_ID =-1 '

Line 1606: ||'AND SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id ||') ';

1602: ||' AND (mr.ROUTING_SEQUENCE_ID,mea.ASSET_REBUILD_ITEM_ID,mea.ASSET_ACTIVITY_ID,mr.ORGANIZATION_ID)'
1603: ||' not in '
1604: ||'(select ROUTING_SEQUENCE_ID, ASSEMBLY_ITEM_ID,ASSET_ACTIVITY_ID,ORGANIZATION_ID '
1605: ||'from MSC_ROUTINGS where PLAN_ID =-1 '
1606: ||'AND SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id ||') ';
1607:
1608:
1609: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed-- ' || lv_ins_stmt1);
1610:

Line 1611: EXECUTE IMMEDIATE lv_ins_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,

1607:
1608:
1609: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed-- ' || lv_ins_stmt1);
1610:
1611: EXECUTE IMMEDIATE lv_ins_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
1612: MSC_CL_COLLECTION.v_current_date,
1613: MSC_CL_COLLECTION.v_current_user,
1614: MSC_CL_COLLECTION.v_current_date,
1615: MSC_CL_COLLECTION.v_current_user;

Line 1612: MSC_CL_COLLECTION.v_current_date,

1608:
1609: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed-- ' || lv_ins_stmt1);
1610:
1611: EXECUTE IMMEDIATE lv_ins_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
1612: MSC_CL_COLLECTION.v_current_date,
1613: MSC_CL_COLLECTION.v_current_user,
1614: MSC_CL_COLLECTION.v_current_date,
1615: MSC_CL_COLLECTION.v_current_user;
1616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_routings'

Line 1613: MSC_CL_COLLECTION.v_current_user,

1609: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed-- ' || lv_ins_stmt1);
1610:
1611: EXECUTE IMMEDIATE lv_ins_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
1612: MSC_CL_COLLECTION.v_current_date,
1613: MSC_CL_COLLECTION.v_current_user,
1614: MSC_CL_COLLECTION.v_current_date,
1615: MSC_CL_COLLECTION.v_current_user;
1616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_routings'
1617: ||SQL%ROWCOUNT);

Line 1614: MSC_CL_COLLECTION.v_current_date,

1610:
1611: EXECUTE IMMEDIATE lv_ins_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
1612: MSC_CL_COLLECTION.v_current_date,
1613: MSC_CL_COLLECTION.v_current_user,
1614: MSC_CL_COLLECTION.v_current_date,
1615: MSC_CL_COLLECTION.v_current_user;
1616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_routings'
1617: ||SQL%ROWCOUNT);
1618: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');

Line 1615: MSC_CL_COLLECTION.v_current_user;

1611: EXECUTE IMMEDIATE lv_ins_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
1612: MSC_CL_COLLECTION.v_current_date,
1613: MSC_CL_COLLECTION.v_current_user,
1614: MSC_CL_COLLECTION.v_current_date,
1615: MSC_CL_COLLECTION.v_current_user;
1616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_routings'
1617: ||SQL%ROWCOUNT);
1618: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
1619:

Line 1653: ||'AND mpe.SR_INSTANCE_ID = '|| MSC_CL_COLLECTION.v_instance_id

1649: ||'AND mpe.ACTIVITY_ITEM_ID = mea.ASSET_ACTIVITY_ID '
1650: ||'AND mpe.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1651: ||'AND mpe.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '
1652: ||'AND mpe.PLAN_ID =-1 '
1653: ||'AND mpe.SR_INSTANCE_ID = '|| MSC_CL_COLLECTION.v_instance_id
1654: ||' AND mpe.repairable =1';
1655:
1656: OPEN c4 FOR lv_cursor_stmt2;
1657: LOOP

Line 1684: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,

1680: EFFECTIVITY_DATE = lv_EFFECTIVITY_DATE,
1681: LINE_ID = lv_LINE_ID,
1682: REPAIRABLE = lv_REPAIRABLE,
1683: --PLAN_ID = lv_PLAN_ID,
1684: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1685: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1686: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1687: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1688: AND PLAN_ID = lv_PLAN_ID

Line 1685: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1681: LINE_ID = lv_LINE_ID,
1682: REPAIRABLE = lv_REPAIRABLE,
1683: --PLAN_ID = lv_PLAN_ID,
1684: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1685: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1686: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1687: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1688: AND PLAN_ID = lv_PLAN_ID
1689: AND PROCESS_SEQUENCE_ID =lv_PROCESS_SEQUENCE_ID

Line 1686: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

1682: REPAIRABLE = lv_REPAIRABLE,
1683: --PLAN_ID = lv_PLAN_ID,
1684: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1685: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1686: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1687: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1688: AND PLAN_ID = lv_PLAN_ID
1689: AND PROCESS_SEQUENCE_ID =lv_PROCESS_SEQUENCE_ID
1690: AND ROUTING_SEQUENCE_ID = lv_ROUTING_SEQUENCE_ID

Line 1687: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1683: --PLAN_ID = lv_PLAN_ID,
1684: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1685: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1686: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1687: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1688: AND PLAN_ID = lv_PLAN_ID
1689: AND PROCESS_SEQUENCE_ID =lv_PROCESS_SEQUENCE_ID
1690: AND ROUTING_SEQUENCE_ID = lv_ROUTING_SEQUENCE_ID
1691: AND BILL_SEQUENCE_ID = lv_BILL_SEQUENCE_ID

Line 1745: ||' AND mpe.SR_INSTANCE_ID = '|| MSC_CL_COLLECTION.v_instance_id

1741: ||' WHERE mpe.ITEM_ID = mea.ASSET_ACTIVITY_ID '
1742: ||' AND mpe.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1743: ||' AND mpe.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '
1744: ||' AND mpe.PLAN_ID =-1 '
1745: ||' AND mpe.SR_INSTANCE_ID = '|| MSC_CL_COLLECTION.v_instance_id
1746: ||' AND (mea.ASSET_REBUILD_ITEM_ID,mpe.ROUTING_SEQUENCE_ID,mpe.BILL_SEQUENCE_ID,mea.ASSET_ACTIVITY_ID,mpe.LINE_ID,mpe.ORGANIZATION_ID)'
1747: ||' not in '
1748: ||' (select ITEM_ID,ROUTING_SEQUENCE_ID,BILL_SEQUENCE_ID,ACTIVITY_ITEM_ID,LINE_ID,ORGANIZATION_ID '
1749: ||' from MSC_PROCESS_EFFECTIVITY where PLAN_ID =-1 '

Line 1750: ||' AND SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id ||') ';

1746: ||' AND (mea.ASSET_REBUILD_ITEM_ID,mpe.ROUTING_SEQUENCE_ID,mpe.BILL_SEQUENCE_ID,mea.ASSET_ACTIVITY_ID,mpe.LINE_ID,mpe.ORGANIZATION_ID)'
1747: ||' not in '
1748: ||' (select ITEM_ID,ROUTING_SEQUENCE_ID,BILL_SEQUENCE_ID,ACTIVITY_ITEM_ID,LINE_ID,ORGANIZATION_ID '
1749: ||' from MSC_PROCESS_EFFECTIVITY where PLAN_ID =-1 '
1750: ||' AND SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id ||') ';
1751:
1752:
1753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed--' || lv_ins_stmt2);
1754:

Line 1755: EXECUTE IMMEDIATE lv_ins_stmt2 USING MSC_CL_COLLECTION.v_last_collection_id,

1751:
1752:
1753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed--' || lv_ins_stmt2);
1754:
1755: EXECUTE IMMEDIATE lv_ins_stmt2 USING MSC_CL_COLLECTION.v_last_collection_id,
1756: MSC_CL_COLLECTION.v_current_date,
1757: MSC_CL_COLLECTION.v_current_user,
1758: MSC_CL_COLLECTION.v_current_date,
1759: MSC_CL_COLLECTION.v_current_user;

Line 1756: MSC_CL_COLLECTION.v_current_date,

1752:
1753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed--' || lv_ins_stmt2);
1754:
1755: EXECUTE IMMEDIATE lv_ins_stmt2 USING MSC_CL_COLLECTION.v_last_collection_id,
1756: MSC_CL_COLLECTION.v_current_date,
1757: MSC_CL_COLLECTION.v_current_user,
1758: MSC_CL_COLLECTION.v_current_date,
1759: MSC_CL_COLLECTION.v_current_user;
1760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_process_effec'

Line 1757: MSC_CL_COLLECTION.v_current_user,

1753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed--' || lv_ins_stmt2);
1754:
1755: EXECUTE IMMEDIATE lv_ins_stmt2 USING MSC_CL_COLLECTION.v_last_collection_id,
1756: MSC_CL_COLLECTION.v_current_date,
1757: MSC_CL_COLLECTION.v_current_user,
1758: MSC_CL_COLLECTION.v_current_date,
1759: MSC_CL_COLLECTION.v_current_user;
1760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_process_effec'
1761: ||'tivity '||SQL%ROWCOUNT);

Line 1758: MSC_CL_COLLECTION.v_current_date,

1754:
1755: EXECUTE IMMEDIATE lv_ins_stmt2 USING MSC_CL_COLLECTION.v_last_collection_id,
1756: MSC_CL_COLLECTION.v_current_date,
1757: MSC_CL_COLLECTION.v_current_user,
1758: MSC_CL_COLLECTION.v_current_date,
1759: MSC_CL_COLLECTION.v_current_user;
1760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_process_effec'
1761: ||'tivity '||SQL%ROWCOUNT);
1762: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');

Line 1759: MSC_CL_COLLECTION.v_current_user;

1755: EXECUTE IMMEDIATE lv_ins_stmt2 USING MSC_CL_COLLECTION.v_last_collection_id,
1756: MSC_CL_COLLECTION.v_current_date,
1757: MSC_CL_COLLECTION.v_current_user,
1758: MSC_CL_COLLECTION.v_current_date,
1759: MSC_CL_COLLECTION.v_current_user;
1760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_process_effec'
1761: ||'tivity '||SQL%ROWCOUNT);
1762: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
1763:

Line 1791: and s.sr_instance_id = MSC_CL_COLLECTION.v_instance_id

1787: and s.activity_item_id = mea.asset_activity_id
1788: and s.organization_id = mea.organization_id
1789: and s.sr_instance_id = mea.sr_instance_id
1790: and mea.activity_type = 6
1791: and s.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
1792: and s.plan_id=-1
1793: and s.order_type=70
1794: and s.maintenance_object_source=1
1795: and s.schedule_designator_id is null

Line 1805: where ms.sr_instance_id = MSC_CL_COLLECTION.v_instance_id

1801:
1802: for c_rec in c_prod_stock loop
1803: update msc_supplies ms
1804: set ms.produces_to_stock =1
1805: where ms.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
1806: and ms.plan_id=-1
1807: and ms.order_type= c_rec.order_type
1808: and ms.maintenance_object_source=1
1809: and ms.schedule_designator_id is null