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

Line 36: WHERE std_op_res.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

32: std_op_res.SUBSTITUTE_GROUP_NUM,
33: std_op_res.UOM_CODE,
34: std_op_res.SCHEDULE_FLAG
35: FROM MSC_ST_STD_OP_RESOURCES std_op_res
36: WHERE std_op_res.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
37:
38: lv_cnt NUMBER;
39: lv_pbs NUMBER;
40: c_count NUMBER := 0;

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

41: total_count NUMBER := 0;
42:
43: BEGIN
44:
45: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (MSC_CL_COLLECTION.v_is_partial_refresh)) THEN
46: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
47: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
48: ELSE
49: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str); /* ds change change */

Line 46: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

42:
43: BEGIN
44:
45: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (MSC_CL_COLLECTION.v_is_partial_refresh)) THEN
46: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
47: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
48: ELSE
49: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str); /* ds change change */
50: END IF;

Line 47: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

43: BEGIN
44:
45: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (MSC_CL_COLLECTION.v_is_partial_refresh)) THEN
46: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
47: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
48: ELSE
49: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str); /* ds change change */
50: END IF;
51:

Line 49: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str); /* ds change change */

45: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (MSC_CL_COLLECTION.v_is_partial_refresh)) THEN
46: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
47: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
48: ELSE
49: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str); /* ds change change */
50: END IF;
51:
52: c_count := 0;
53: total_count := 0;

Line 92: MSC_CL_COLLECTION.v_last_collection_id,

88: c_rec.RESOURCE_UNITS,
89: c_rec.SUBSTITUTE_GROUP_NUM,
90: c_rec.UOM_CODE,
91: c_rec.SCHEDULE_FLAG,
92: MSC_CL_COLLECTION.v_last_collection_id,
93: MSC_CL_COLLECTION.v_current_date,
94: MSC_CL_COLLECTION.v_current_user,
95: MSC_CL_COLLECTION.v_current_date,
96: MSC_CL_COLLECTION.v_current_user );

Line 93: MSC_CL_COLLECTION.v_current_date,

89: c_rec.SUBSTITUTE_GROUP_NUM,
90: c_rec.UOM_CODE,
91: c_rec.SCHEDULE_FLAG,
92: MSC_CL_COLLECTION.v_last_collection_id,
93: MSC_CL_COLLECTION.v_current_date,
94: MSC_CL_COLLECTION.v_current_user,
95: MSC_CL_COLLECTION.v_current_date,
96: MSC_CL_COLLECTION.v_current_user );
97:

Line 94: MSC_CL_COLLECTION.v_current_user,

90: c_rec.UOM_CODE,
91: c_rec.SCHEDULE_FLAG,
92: MSC_CL_COLLECTION.v_last_collection_id,
93: MSC_CL_COLLECTION.v_current_date,
94: MSC_CL_COLLECTION.v_current_user,
95: MSC_CL_COLLECTION.v_current_date,
96: MSC_CL_COLLECTION.v_current_user );
97:
98: c_count:= c_count+1;

Line 95: MSC_CL_COLLECTION.v_current_date,

91: c_rec.SCHEDULE_FLAG,
92: MSC_CL_COLLECTION.v_last_collection_id,
93: MSC_CL_COLLECTION.v_current_date,
94: MSC_CL_COLLECTION.v_current_user,
95: MSC_CL_COLLECTION.v_current_date,
96: MSC_CL_COLLECTION.v_current_user );
97:
98: c_count:= c_count+1;
99: total_count := total_count+1;

Line 96: MSC_CL_COLLECTION.v_current_user );

92: MSC_CL_COLLECTION.v_last_collection_id,
93: MSC_CL_COLLECTION.v_current_date,
94: MSC_CL_COLLECTION.v_current_user,
95: MSC_CL_COLLECTION.v_current_date,
96: MSC_CL_COLLECTION.v_current_user );
97:
98: c_count:= c_count+1;
99: total_count := total_count+1;
100:

Line 101: IF c_count> MSC_CL_COLLECTION.PBS THEN

97:
98: c_count:= c_count+1;
99: total_count := total_count+1;
100:
101: IF c_count> MSC_CL_COLLECTION.PBS THEN
102: COMMIT;
103: c_count:= 0;
104: END IF;
105:

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

117:
118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
119: RAISE;
120: ELSE
121: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
122:
123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
124: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STD_OP_RESOURCES');

Line 148: MSC_CL_COLLECTION.v_instance_id));

144:
145: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
146: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
147: FND_MESSAGE.SET_TOKEN('VALUE', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
148: MSC_CL_COLLECTION.v_instance_id));
149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
151: END IF;
152:

Line 159: END IF; /* MSC_CL_COLLECTION.v_is_complete_refresh) OR (MSC_CL_COLLECTION.v_is_partial_refresh */

155: END LOOP;
156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total std op resources = '|| to_char(total_count));
157: COMMIT;
158:
159: END IF; /* MSC_CL_COLLECTION.v_is_complete_refresh) OR (MSC_CL_COLLECTION.v_is_partial_refresh */
160:
161: END LOAD_STD_OP_RESOURCES;
162:
163:

Line 217: WHERE mon.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id

213: mon.REFRESH_ID,
214: mon.SR_INSTANCE_ID
215: from MSC_ST_OPERATION_NETWORKS mon,
216: MSC_ITEM_ID_LID t1 /* ds change change */
217: WHERE mon.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
218: AND mon.DELETED_FLAG = MSC_UTIL.SYS_NO
219: AND mon.FROM_ITEM_ID = t1.SR_INVENTORY_ITEM_ID(+) /* ds change change */
220: AND mon.sr_instance_id = t1.sr_instance_id(+) ; /* ds change change */
221:

Line 231: WHERE mon.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

227: mon.DELETED_FLAG,
228: mon.REFRESH_ID,
229: mon.SR_INSTANCE_ID
230: FROM MSC_ST_OPERATION_NETWORKS mon
231: WHERE mon.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
232: and mon.DELETED_FLAG= MSC_UTIL.SYS_YES;
233:
234: c_count NUMBER:= 0;
235: lv_tbl VARCHAR2(30);

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

236: lv_sql_stmt VARCHAR2(5000);
237:
238: BEGIN
239:
240: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
241:
242: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
243: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1);
244: ELSE

Line 242: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

238: BEGIN
239:
240: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
241:
242: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
243: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1);
244: ELSE
245: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
246: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 243: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1);

239:
240: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
241:
242: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
243: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1);
244: ELSE
245: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
246: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
247: END IF;

Line 246: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

242: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
243: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1);
244: ELSE
245: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
246: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
247: END IF;
248:
249: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
250:

Line 249: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

245: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
246: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
247: END IF;
248:
249: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
250:
251: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
252:
253: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete

Line 251: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

247: END IF;
248:
249: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
250:
251: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
252:
253: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
254:
255: FOR c_rec IN c10_d LOOP

Line 274: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

270: FOR c_rec IN c10 LOOP
271:
272: BEGIN
273:
274: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
275:
276: UPDATE MSC_OPERATION_NETWORKS
277: SET
278: FROM_OP_SEQ_ID = c_rec.from_op_seq_id,

Line 287: LAST_UPDATED_BY = MSC_CL_COLLECTION.v_current_user,

283: CUMMULATIVE_PCT = c_rec. cummulative_pct,
284: EFFECTIVITY_DATE = c_Rec.efectivity_date,
285: DISABLE_DATE = c_Rec.disable_date,
286: PLAN_ID = -1,
287: LAST_UPDATED_BY = MSC_CL_COLLECTION.v_current_user,
288: LAST_UPDATE_DATE = MSC_CL_COLLECTION.v_current_date,
289: ATTRIBUTE_CATEGORY = c_rec.attribute_category,
290: ATTRIBUTE1 = c_rec.attribute1,
291: ATTRIBUTE2 = c_rec.attribute2,

Line 288: LAST_UPDATE_DATE = MSC_CL_COLLECTION.v_current_date,

284: EFFECTIVITY_DATE = c_Rec.efectivity_date,
285: DISABLE_DATE = c_Rec.disable_date,
286: PLAN_ID = -1,
287: LAST_UPDATED_BY = MSC_CL_COLLECTION.v_current_user,
288: LAST_UPDATE_DATE = MSC_CL_COLLECTION.v_current_date,
289: ATTRIBUTE_CATEGORY = c_rec.attribute_category,
290: ATTRIBUTE1 = c_rec.attribute1,
291: ATTRIBUTE2 = c_rec.attribute2,
292: ATTRIBUTE3 = c_Rec.attribute3,

Line 308: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id

304: ATTRIBUTE15 = c_rec.attribute15,
305: FROM_OP_SEQ_NUM= c_rec.FROM_OP_SEQ_NUM,
306: TO_OP_SEQ_NUM = c_rec.TO_OP_SEQ_NUM,
307: DEPENDENCY_TYPE = c_rec.DEPENDENCY_TYPE, /* ds change other new attr not added as they are for opm */
308: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id
309: WHERE PLAN_ID= -1
310: AND FROM_OP_SEQ_ID= c_rec.FROM_OP_SEQ_ID
311: AND TO_OP_SEQ_ID= c_rec.TO_OP_SEQ_ID
312: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID

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

313: AND routing_sequence_id = c_rec.routing_sequence_id;
314:
315: END IF;
316:
317: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
318:
319: insert into MSC_OPERATION_NETWORKS
320: ( FROM_OP_SEQ_ID,
321: TO_OP_SEQ_ID,

Line 384: MSC_CL_COLLECTION.v_current_user,

380: c_rec.APPLY_TO_CHARGES,
381: c_rec.TRANSFER_PCT,
382: c_rec.TRANSFER_QTY,
383: c_rec.TRANSFER_UOM, /*ds change change end */
384: MSC_CL_COLLECTION.v_current_user,
385: MSC_CL_COLLECTION.v_current_date,
386: MSC_CL_COLLECTION.v_current_user,
387: MSC_CL_COLLECTION.v_current_date,
388: c_rec.ATTRIBUTE_CATEGORY,

Line 385: MSC_CL_COLLECTION.v_current_date,

381: c_rec.TRANSFER_PCT,
382: c_rec.TRANSFER_QTY,
383: c_rec.TRANSFER_UOM, /*ds change change end */
384: MSC_CL_COLLECTION.v_current_user,
385: MSC_CL_COLLECTION.v_current_date,
386: MSC_CL_COLLECTION.v_current_user,
387: MSC_CL_COLLECTION.v_current_date,
388: c_rec.ATTRIBUTE_CATEGORY,
389: c_rec.ATTRIBUTE1,

Line 386: MSC_CL_COLLECTION.v_current_user,

382: c_rec.TRANSFER_QTY,
383: c_rec.TRANSFER_UOM, /*ds change change end */
384: MSC_CL_COLLECTION.v_current_user,
385: MSC_CL_COLLECTION.v_current_date,
386: MSC_CL_COLLECTION.v_current_user,
387: MSC_CL_COLLECTION.v_current_date,
388: c_rec.ATTRIBUTE_CATEGORY,
389: c_rec.ATTRIBUTE1,
390: c_rec.ATTRIBUTE2,

Line 387: MSC_CL_COLLECTION.v_current_date,

383: c_rec.TRANSFER_UOM, /*ds change change end */
384: MSC_CL_COLLECTION.v_current_user,
385: MSC_CL_COLLECTION.v_current_date,
386: MSC_CL_COLLECTION.v_current_user,
387: MSC_CL_COLLECTION.v_current_date,
388: c_rec.ATTRIBUTE_CATEGORY,
389: c_rec.ATTRIBUTE1,
390: c_rec.ATTRIBUTE2,
391: c_Rec.ATTRIBUTE3,

Line 406: MSC_CL_COLLECTION.v_last_collection_id,

402: c_rec.ATTRIBUTE14,
403: c_rec.ATTRIBUTE15,
404: c_rec.FROM_OP_SEQ_NUM,
405: c_rec.TO_OP_SEQ_NUM,
406: MSC_CL_COLLECTION.v_last_collection_id,
407: MSC_CL_COLLECTION.v_instance_id );
408:
409:
410: END IF; -- SQL%NOTFOUND

Line 407: MSC_CL_COLLECTION.v_instance_id );

403: c_rec.ATTRIBUTE15,
404: c_rec.FROM_OP_SEQ_NUM,
405: c_rec.TO_OP_SEQ_NUM,
406: MSC_CL_COLLECTION.v_last_collection_id,
407: MSC_CL_COLLECTION.v_instance_id );
408:
409:
410: END IF; -- SQL%NOTFOUND
411:

Line 414: IF c_count> MSC_CL_COLLECTION.PBS THEN

410: END IF; -- SQL%NOTFOUND
411:
412: c_count:= c_count+1;
413:
414: IF c_count> MSC_CL_COLLECTION.PBS THEN
415: COMMIT;
416: c_count:= 0;
417: END IF;
418:

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

430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
431: RAISE;
432:
433: ELSE
434: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
435:
436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
437: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
438: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_NETWORKS');

Line 500: AND msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

496: FROM MSC_ITEM_ID_LID t1,
497: MSC_ST_ROUTINGS msr
498: WHERE t1.SR_INVENTORY_ITEM_ID= msr.assembly_item_id
499: AND t1.sr_instance_id= msr.sr_instance_id
500: AND msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
501: AND msr.DELETED_FLAG= MSC_UTIL.SYS_NO;
502:
503: CURSOR c4_d IS
504: SELECT

Line 508: WHERE msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

504: SELECT
505: msr.ROUTING_SEQUENCE_ID,
506: msr.SR_INSTANCE_ID
507: FROM MSC_ST_ROUTINGS msr
508: WHERE msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
509: AND msr.DELETED_FLAG= MSC_UTIL.SYS_YES;
510:
511:
512: c_count NUMBER:= 0;

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

516: lb_refresh_failed BOOLEAN:= FALSE;
517:
518: BEGIN
519:
520: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
521: -- We want to delete all ROUTING related data and get new stuff.
522:
523: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
524:

Line 523: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);

519:
520: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
521: -- We want to delete all ROUTING related data and get new stuff.
522:
523: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
524:
525: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
526: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
527: ELSE

Line 525: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

521: -- We want to delete all ROUTING related data and get new stuff.
522:
523: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
524:
525: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
526: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
527: ELSE
528: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 526: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);

522:
523: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
524:
525: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
526: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
527: ELSE
528: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
530: END IF;

Line 529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

525: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
526: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
527: ELSE
528: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
530: END IF;
531:
532: BEGIN
533: lv_sql_ins:=

Line 588: ||' AND msr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

584: ||' FROM MSC_ITEM_ID_LID t1,'
585: ||' MSC_ST_ROUTINGS msr'
586: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msr.assembly_item_id'
587: ||' AND t1.sr_instance_id= msr.sr_instance_id'
588: ||' AND msr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
589: ||' AND msr.DELETED_FLAG= '||MSC_UTIL.SYS_NO;
590:
591: EXECUTE IMMEDIATE lv_sql_ins
592: USING v_chr10, v_chr13, MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;

Line 592: USING v_chr10, v_chr13, MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;

588: ||' AND msr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
589: ||' AND msr.DELETED_FLAG= '||MSC_UTIL.SYS_NO;
590:
591: EXECUTE IMMEDIATE lv_sql_ins
592: USING v_chr10, v_chr13, MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
593:
594: COMMIT;
595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'routings loaded');
596:

Line 627: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

623: lb_refresh_failed := TRUE;
624: END IF;
625: END;
626:
627: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
628:
629: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
630:
631: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

Line 629: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN

625: END;
626:
627: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
628:
629: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
630:
631: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
632:
633: FOR c_rec IN c4_d LOOP

Line 631: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

627: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
628:
629: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
630:
631: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
632:
633: FOR c_rec IN c4_d LOOP
634:
635: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete

Line 653: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

649: FOR c_rec IN c4 LOOP
650:
651: BEGIN
652:
653: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
654:
655: UPDATE MSC_ROUTINGS
656: SET
657: ROUTING_TYPE= c_rec.ROUTING_TYPE,

Line 672: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

668: CTP_FLAG= c_rec.CTP_FLAG,
669: ASSEMBLY_ITEM_ID= c_rec.ASSEMBLY_ITEM_ID,
670: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,
671: ROUTING_QUANTITY= c_rec.ROUTING_QUANTITY,
672: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
673: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
674: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
675: WHERE PLAN_ID= -1
676: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID

Line 673: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

669: ASSEMBLY_ITEM_ID= c_rec.ASSEMBLY_ITEM_ID,
670: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,
671: ROUTING_QUANTITY= c_rec.ROUTING_QUANTITY,
672: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
673: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
674: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
675: WHERE PLAN_ID= -1
676: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID
677: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line 674: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

670: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,
671: ROUTING_QUANTITY= c_rec.ROUTING_QUANTITY,
672: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
673: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
674: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
675: WHERE PLAN_ID= -1
676: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID
677: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
678:

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

677: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
678:
679: END IF;
680:
681: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
682:
683: INSERT INTO MSC_ROUTINGS
684: ( PLAN_ID,
685: ROUTING_SEQUENCE_ID,

Line 724: MSC_CL_COLLECTION.v_last_collection_id,

720: c_rec.ASSEMBLY_ITEM_ID,
721: c_rec.ORGANIZATION_ID,
722: c_rec.ROUTING_QUANTITY,
723: c_rec.SR_INSTANCE_ID,
724: MSC_CL_COLLECTION.v_last_collection_id,
725: MSC_CL_COLLECTION.v_current_date,
726: MSC_CL_COLLECTION.v_current_user,
727: MSC_CL_COLLECTION.v_current_date,
728: MSC_CL_COLLECTION.v_current_user,

Line 725: MSC_CL_COLLECTION.v_current_date,

721: c_rec.ORGANIZATION_ID,
722: c_rec.ROUTING_QUANTITY,
723: c_rec.SR_INSTANCE_ID,
724: MSC_CL_COLLECTION.v_last_collection_id,
725: MSC_CL_COLLECTION.v_current_date,
726: MSC_CL_COLLECTION.v_current_user,
727: MSC_CL_COLLECTION.v_current_date,
728: MSC_CL_COLLECTION.v_current_user,
729: c_rec.first_op_seq_num,

Line 726: MSC_CL_COLLECTION.v_current_user,

722: c_rec.ROUTING_QUANTITY,
723: c_rec.SR_INSTANCE_ID,
724: MSC_CL_COLLECTION.v_last_collection_id,
725: MSC_CL_COLLECTION.v_current_date,
726: MSC_CL_COLLECTION.v_current_user,
727: MSC_CL_COLLECTION.v_current_date,
728: MSC_CL_COLLECTION.v_current_user,
729: c_rec.first_op_seq_num,
730: c_rec.last_op_seq_num,

Line 727: MSC_CL_COLLECTION.v_current_date,

723: c_rec.SR_INSTANCE_ID,
724: MSC_CL_COLLECTION.v_last_collection_id,
725: MSC_CL_COLLECTION.v_current_date,
726: MSC_CL_COLLECTION.v_current_user,
727: MSC_CL_COLLECTION.v_current_date,
728: MSC_CL_COLLECTION.v_current_user,
729: c_rec.first_op_seq_num,
730: c_rec.last_op_seq_num,
731: c_rec.common_routing_sequence_id,

Line 728: MSC_CL_COLLECTION.v_current_user,

724: MSC_CL_COLLECTION.v_last_collection_id,
725: MSC_CL_COLLECTION.v_current_date,
726: MSC_CL_COLLECTION.v_current_user,
727: MSC_CL_COLLECTION.v_current_date,
728: MSC_CL_COLLECTION.v_current_user,
729: c_rec.first_op_seq_num,
730: c_rec.last_op_seq_num,
731: c_rec.common_routing_sequence_id,
732: c_rec.auto_step_qty_flag);

Line 738: IF c_count> MSC_CL_COLLECTION.PBS THEN

734: END IF; -- SQL%NOTFOUND
735:
736: c_count:= c_count+1;
737:
738: IF c_count> MSC_CL_COLLECTION.PBS THEN
739: COMMIT;
740: c_count:= 0;
741: END IF;
742:

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

755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
756: RAISE;
757:
758: ELSE
759: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
760:
761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
762: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
763: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');

Line 782: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh

778: END IF;
779: END;
780:
781: END LOOP;
782: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh
783:
784: COMMIT;
785:
786: END LOAD_ROUTING;

Line 801: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

797: BILL_SEQUENCE_ID,
798: ROUTING_SEQUENCE_ID,
799: SR_INSTANCE_ID
800: FROM MSC_ST_OPERATION_COMPONENTS msoc
801: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
802: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;
803:
804: CURSOR c9_d IS
805: SELECT

Line 813: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

809: ROUTING_SEQUENCE_ID,
810: SR_INSTANCE_ID,
811: ORGANIZATION_ID
812: FROM MSC_ST_OPERATION_COMPONENTS msoc
813: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
814: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_YES
815: UNION ALL
816: SELECT DISTINCT
817: TO_NUMBER(NULL),

Line 828: AND msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

824: MSC_ST_OPERATION_COMPONENTS msoc
825: WHERE msoc.Bill_Sequence_ID= moc.Bill_Sequence_ID
826: AND msoc.Routing_Sequence_ID <> moc.Routing_Sequence_ID
827: AND msoc.Organization_ID= moc.Organization_ID
828: AND msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
829: AND moc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
830: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO
831: AND moc.PLAN_ID= -1;
832:

Line 829: AND moc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

825: WHERE msoc.Bill_Sequence_ID= moc.Bill_Sequence_ID
826: AND msoc.Routing_Sequence_ID <> moc.Routing_Sequence_ID
827: AND msoc.Organization_ID= moc.Organization_ID
828: AND msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
829: AND moc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
830: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO
831: AND moc.PLAN_ID= -1;
832:
833:

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

839: lv_delete_flag BOOLEAN:= FALSE;
840:
841: BEGIN
842:
843: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
844: -- We want to delete all BOM related data and get new stuff.
845:
846: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
847:

Line 846: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);

842:
843: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
844: -- We want to delete all BOM related data and get new stuff.
845:
846: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
847:
848: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
849: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
850: ELSE

Line 848: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

844: -- We want to delete all BOM related data and get new stuff.
845:
846: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
847:
848: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
849: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
850: ELSE
851: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
852: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 849: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);

845:
846: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
847:
848: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
849: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
850: ELSE
851: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
852: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
853: END IF;

Line 852: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

848: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
849: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
850: ELSE
851: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
852: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
853: END IF;
854: BEGIN
855: INSERT /*+ append */
856: INTO MSC_OPERATION_COMPONENTS

Line 877: MSC_CL_COLLECTION.v_last_collection_id,

873: COMPONENT_SEQUENCE_ID,
874: SR_INSTANCE_ID,
875: BILL_SEQUENCE_ID,
876: ROUTING_SEQUENCE_ID,
877: MSC_CL_COLLECTION.v_last_collection_id,
878: MSC_CL_COLLECTION.v_current_date,
879: MSC_CL_COLLECTION.v_current_user,
880: MSC_CL_COLLECTION.v_current_date,
881: MSC_CL_COLLECTION.v_current_user

Line 878: MSC_CL_COLLECTION.v_current_date,

874: SR_INSTANCE_ID,
875: BILL_SEQUENCE_ID,
876: ROUTING_SEQUENCE_ID,
877: MSC_CL_COLLECTION.v_last_collection_id,
878: MSC_CL_COLLECTION.v_current_date,
879: MSC_CL_COLLECTION.v_current_user,
880: MSC_CL_COLLECTION.v_current_date,
881: MSC_CL_COLLECTION.v_current_user
882: FROM MSC_ST_OPERATION_COMPONENTS msoc

Line 879: MSC_CL_COLLECTION.v_current_user,

875: BILL_SEQUENCE_ID,
876: ROUTING_SEQUENCE_ID,
877: MSC_CL_COLLECTION.v_last_collection_id,
878: MSC_CL_COLLECTION.v_current_date,
879: MSC_CL_COLLECTION.v_current_user,
880: MSC_CL_COLLECTION.v_current_date,
881: MSC_CL_COLLECTION.v_current_user
882: FROM MSC_ST_OPERATION_COMPONENTS msoc
883: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 880: MSC_CL_COLLECTION.v_current_date,

876: ROUTING_SEQUENCE_ID,
877: MSC_CL_COLLECTION.v_last_collection_id,
878: MSC_CL_COLLECTION.v_current_date,
879: MSC_CL_COLLECTION.v_current_user,
880: MSC_CL_COLLECTION.v_current_date,
881: MSC_CL_COLLECTION.v_current_user
882: FROM MSC_ST_OPERATION_COMPONENTS msoc
883: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
884: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;

Line 881: MSC_CL_COLLECTION.v_current_user

877: MSC_CL_COLLECTION.v_last_collection_id,
878: MSC_CL_COLLECTION.v_current_date,
879: MSC_CL_COLLECTION.v_current_user,
880: MSC_CL_COLLECTION.v_current_date,
881: MSC_CL_COLLECTION.v_current_user
882: FROM MSC_ST_OPERATION_COMPONENTS msoc
883: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
884: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;
885:

Line 883: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

879: MSC_CL_COLLECTION.v_current_user,
880: MSC_CL_COLLECTION.v_current_date,
881: MSC_CL_COLLECTION.v_current_user
882: FROM MSC_ST_OPERATION_COMPONENTS msoc
883: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
884: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;
885:
886: COMMIT;
887: EXCEPTION

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

897:
898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
899: RAISE;
900: ELSE
901: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
902: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
903: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
904: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
905: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');

Line 912: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
909: lb_refresh_failed := TRUE;
910: END IF;
911: END;
912: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
913:
914: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
915:
916: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete

Line 914: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN

910: END IF;
911: END;
912: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
913:
914: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
915:
916: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
917: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
918: FOR c_rec IN c9_d LOOP

Line 917: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

913:
914: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
915:
916: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
917: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
918: FOR c_rec IN c9_d LOOP
919:
920: BEGIN
921:

Line 1009: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

1005: FOR c_rec IN c9 LOOP
1006:
1007: BEGIN
1008:
1009: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1010:
1011: UPDATE MSC_OPERATION_COMPONENTS
1012: SET PLAN_ID= -1,
1013: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 1013: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1009: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1010:
1011: UPDATE MSC_OPERATION_COMPONENTS
1012: SET PLAN_ID= -1,
1013: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1014: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1015: WHERE PLAN_ID= -1
1016: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
1017: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID

Line 1014: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

1010:
1011: UPDATE MSC_OPERATION_COMPONENTS
1012: SET PLAN_ID= -1,
1013: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1014: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1015: WHERE PLAN_ID= -1
1016: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
1017: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
1018: AND BILL_SEQUENCE_ID = c_rec.BILL_SEQUENCE_ID

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

1021: AND OPERATION_SEQUENCE_ID= c_rec.OPERATION_SEQUENCE_ID;
1022:
1023: END IF;
1024:
1025: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1026:
1027: INSERT INTO MSC_OPERATION_COMPONENTS
1028: ( PLAN_ID,
1029: ORGANIZATION_ID,

Line 1048: MSC_CL_COLLECTION.v_last_collection_id,

1044: c_rec.COMPONENT_SEQUENCE_ID,
1045: c_rec.SR_INSTANCE_ID,
1046: c_rec.BILL_SEQUENCE_ID,
1047: c_rec.ROUTING_SEQUENCE_ID,
1048: MSC_CL_COLLECTION.v_last_collection_id,
1049: MSC_CL_COLLECTION.v_current_date,
1050: MSC_CL_COLLECTION.v_current_user,
1051: MSC_CL_COLLECTION.v_current_date,
1052: MSC_CL_COLLECTION.v_current_user);

Line 1049: MSC_CL_COLLECTION.v_current_date,

1045: c_rec.SR_INSTANCE_ID,
1046: c_rec.BILL_SEQUENCE_ID,
1047: c_rec.ROUTING_SEQUENCE_ID,
1048: MSC_CL_COLLECTION.v_last_collection_id,
1049: MSC_CL_COLLECTION.v_current_date,
1050: MSC_CL_COLLECTION.v_current_user,
1051: MSC_CL_COLLECTION.v_current_date,
1052: MSC_CL_COLLECTION.v_current_user);
1053:

Line 1050: MSC_CL_COLLECTION.v_current_user,

1046: c_rec.BILL_SEQUENCE_ID,
1047: c_rec.ROUTING_SEQUENCE_ID,
1048: MSC_CL_COLLECTION.v_last_collection_id,
1049: MSC_CL_COLLECTION.v_current_date,
1050: MSC_CL_COLLECTION.v_current_user,
1051: MSC_CL_COLLECTION.v_current_date,
1052: MSC_CL_COLLECTION.v_current_user);
1053:
1054: END IF;

Line 1051: MSC_CL_COLLECTION.v_current_date,

1047: c_rec.ROUTING_SEQUENCE_ID,
1048: MSC_CL_COLLECTION.v_last_collection_id,
1049: MSC_CL_COLLECTION.v_current_date,
1050: MSC_CL_COLLECTION.v_current_user,
1051: MSC_CL_COLLECTION.v_current_date,
1052: MSC_CL_COLLECTION.v_current_user);
1053:
1054: END IF;
1055:

Line 1052: MSC_CL_COLLECTION.v_current_user);

1048: MSC_CL_COLLECTION.v_last_collection_id,
1049: MSC_CL_COLLECTION.v_current_date,
1050: MSC_CL_COLLECTION.v_current_user,
1051: MSC_CL_COLLECTION.v_current_date,
1052: MSC_CL_COLLECTION.v_current_user);
1053:
1054: END IF;
1055:
1056: c_count:= c_count+1;

Line 1058: IF c_count> MSC_CL_COLLECTION.PBS THEN

1054: END IF;
1055:
1056: c_count:= c_count+1;
1057:
1058: IF c_count> MSC_CL_COLLECTION.PBS THEN
1059: COMMIT;
1060: c_count:= 0;
1061: END IF;
1062:

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

1074: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1075: RAISE;
1076:
1077: ELSE
1078: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1079:
1080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1081: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1082: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');

Line 1088: FND_MESSAGE.SET_TOKEN('VALUE', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID, MSC_CL_COLLECTION.v_instance_id));

1084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1085:
1086: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1087: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1088: FND_MESSAGE.SET_TOKEN('VALUE', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID, MSC_CL_COLLECTION.v_instance_id));
1089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1090:
1091: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1092: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');

Line 1129: WHERE msors.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1125: msors.ACTIVITY_GROUP_ID,
1126: msors.SR_INSTANCE_ID,
1127: msors.ORGANIZATION_ID
1128: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors
1129: WHERE msors.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1130: AND msors.DELETED_FLAG= MSC_UTIL.SYS_NO;
1131:
1132: CURSOR c7_d IS
1133: SELECT

Line 1139: WHERE msors.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1135: msors.OPERATION_SEQUENCE_ID,
1136: msors.RESOURCE_SEQ_NUM,
1137: msors.SR_INSTANCE_ID
1138: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors
1139: WHERE msors.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1140: AND msors.DELETED_FLAG= MSC_UTIL.SYS_YES;
1141:
1142:
1143: c_count NUMBER:= 0;

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

1150: lv_retcode NUMBER;
1151:
1152: BEGIN
1153:
1154: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1155: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;
1156: ELSE
1157: lv_tbl:= 'MSC_OPERATION_RESOURCE_SEQS';
1158: END IF;

Line 1155: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;

1151:
1152: BEGIN
1153:
1154: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1155: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;
1156: ELSE
1157: lv_tbl:= 'MSC_OPERATION_RESOURCE_SEQS';
1158: END IF;
1159:

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

1156: ELSE
1157: lv_tbl:= 'MSC_OPERATION_RESOURCE_SEQS';
1158: END IF;
1159:
1160: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1161: -- We want to delete all BOM related data and get new stuff.
1162: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1163:
1164: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN

Line 1162: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);

1158: END IF;
1159:
1160: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1161: -- We want to delete all BOM related data and get new stuff.
1162: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1163:
1164: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1165: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1166: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);

Line 1164: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN

1160: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1161: -- We want to delete all BOM related data and get new stuff.
1162: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1163:
1164: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1165: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1166: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1167: ELSE
1168: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 1165: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1161: -- We want to delete all BOM related data and get new stuff.
1162: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1163:
1164: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1165: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1166: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1167: ELSE
1168: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1169: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 1166: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);

1162: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1163:
1164: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1165: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1166: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1167: ELSE
1168: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1169: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1170: END IF;

Line 1169: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1165: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1166: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1167: ELSE
1168: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1169: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1170: END IF;
1171: END IF;
1172:
1173: BEGIN

Line 1209: ||' WHERE msors.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

1205: ||' :v_current_user,'
1206: ||' :v_current_date,'
1207: ||' :v_current_user '
1208: ||' FROM MSC_ST_OPERATION_RESOURCE_SEQS msors'
1209: ||' WHERE msors.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1210: ||' AND msors.DELETED_FLAG= '||MSC_UTIL.SYS_NO
1211: ||' GROUP BY '
1212: ||' msors.ROUTING_SEQUENCE_ID, '
1213: ||' msors.OPERATION_SEQUENCE_ID, '

Line 1218: USING MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;

1214: ||' msors.RESOURCE_SEQ_NUM,'
1215: ||' msors.SR_INSTANCE_ID';
1216:
1217: EXECUTE IMMEDIATE lv_sql_ins
1218: USING MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
1219:
1220: COMMIT;
1221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'operation resource seqs loaded');
1222:

Line 1253: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

1249: lb_refresh_failed := TRUE;
1250: END IF;
1251: END;
1252:
1253: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
1254:
1255: lv_sql_stmt :=
1256: ' INSERT INTO '||lv_tbl
1257: ||' ( PLAN_ID, '

Line 1289: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN

1285: ||' :v_current_user, '
1286: ||' :v_current_date, '
1287: ||' :v_current_user ) ';
1288:
1289: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
1290:
1291: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1292:
1293: FOR c_rec IN c7_d LOOP

Line 1291: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

1287: ||' :v_current_user ) ';
1288:
1289: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
1290:
1291: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1292:
1293: FOR c_rec IN c7_d LOOP
1294:
1295: IF c_rec.OPERATION_SEQUENCE_ID IS NOT NULL THEN

Line 1320: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

1316: FOR c_rec IN c7 LOOP
1317:
1318: BEGIN
1319:
1320: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1321:
1322: UPDATE MSC_OPERATION_RESOURCE_SEQS
1323: SET
1324: SCHEDULE_FLAG= c_rec.SCHEDULE_FLAG,

Line 1329: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

1325: RESOURCE_OFFSET_PERCENT= c_rec.RESOURCE_OFFSET_PERCENT,
1326: DEPARTMENT_ID= c_rec.DEPARTMENT_ID,
1327: ACTIVITY_GROUP_ID= c_rec.ACTIVITY_GROUP_ID,
1328: ORGANIZATION_ID=c_rec.ORGANIZATION_ID,
1329: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1330: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1331: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1332: WHERE PLAN_ID= -1
1333: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID

Line 1330: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1326: DEPARTMENT_ID= c_rec.DEPARTMENT_ID,
1327: ACTIVITY_GROUP_ID= c_rec.ACTIVITY_GROUP_ID,
1328: ORGANIZATION_ID=c_rec.ORGANIZATION_ID,
1329: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1330: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1331: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1332: WHERE PLAN_ID= -1
1333: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID
1334: AND OPERATION_SEQUENCE_ID= c_rec.OPERATION_SEQUENCE_ID

Line 1331: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

1327: ACTIVITY_GROUP_ID= c_rec.ACTIVITY_GROUP_ID,
1328: ORGANIZATION_ID=c_rec.ORGANIZATION_ID,
1329: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1330: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1331: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1332: WHERE PLAN_ID= -1
1333: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID
1334: AND OPERATION_SEQUENCE_ID= c_rec.OPERATION_SEQUENCE_ID
1335: AND RESOURCE_SEQ_NUM= c_rec.RESOURCE_SEQ_NUM

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

1336: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
1337:
1338: END IF;
1339:
1340: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1341:
1342: EXECUTE IMMEDIATE lv_sql_stmt USING
1343: c_rec.ROUTING_SEQUENCE_ID,
1344: c_rec.OPERATION_SEQUENCE_ID,

Line 1352: MSC_CL_COLLECTION.v_last_collection_id,

1348: c_rec.DEPARTMENT_ID,
1349: c_rec.ACTIVITY_GROUP_ID,
1350: c_rec.SR_INSTANCE_ID,
1351: c_rec.ORGANIZATION_ID,
1352: MSC_CL_COLLECTION.v_last_collection_id,
1353: MSC_CL_COLLECTION.v_current_date,
1354: MSC_CL_COLLECTION.v_current_user,
1355: MSC_CL_COLLECTION.v_current_date,
1356: MSC_CL_COLLECTION.v_current_user ;

Line 1353: MSC_CL_COLLECTION.v_current_date,

1349: c_rec.ACTIVITY_GROUP_ID,
1350: c_rec.SR_INSTANCE_ID,
1351: c_rec.ORGANIZATION_ID,
1352: MSC_CL_COLLECTION.v_last_collection_id,
1353: MSC_CL_COLLECTION.v_current_date,
1354: MSC_CL_COLLECTION.v_current_user,
1355: MSC_CL_COLLECTION.v_current_date,
1356: MSC_CL_COLLECTION.v_current_user ;
1357:

Line 1354: MSC_CL_COLLECTION.v_current_user,

1350: c_rec.SR_INSTANCE_ID,
1351: c_rec.ORGANIZATION_ID,
1352: MSC_CL_COLLECTION.v_last_collection_id,
1353: MSC_CL_COLLECTION.v_current_date,
1354: MSC_CL_COLLECTION.v_current_user,
1355: MSC_CL_COLLECTION.v_current_date,
1356: MSC_CL_COLLECTION.v_current_user ;
1357:
1358: END IF; -- SQL%NOTFOUND

Line 1355: MSC_CL_COLLECTION.v_current_date,

1351: c_rec.ORGANIZATION_ID,
1352: MSC_CL_COLLECTION.v_last_collection_id,
1353: MSC_CL_COLLECTION.v_current_date,
1354: MSC_CL_COLLECTION.v_current_user,
1355: MSC_CL_COLLECTION.v_current_date,
1356: MSC_CL_COLLECTION.v_current_user ;
1357:
1358: END IF; -- SQL%NOTFOUND
1359:

Line 1356: MSC_CL_COLLECTION.v_current_user ;

1352: MSC_CL_COLLECTION.v_last_collection_id,
1353: MSC_CL_COLLECTION.v_current_date,
1354: MSC_CL_COLLECTION.v_current_user,
1355: MSC_CL_COLLECTION.v_current_date,
1356: MSC_CL_COLLECTION.v_current_user ;
1357:
1358: END IF; -- SQL%NOTFOUND
1359:
1360: c_count:= c_count+1;

Line 1362: IF c_count> MSC_CL_COLLECTION.PBS THEN

1358: END IF; -- SQL%NOTFOUND
1359:
1360: c_count:= c_count+1;
1361:
1362: IF c_count> MSC_CL_COLLECTION.PBS THEN
1363: COMMIT;
1364: c_count:= 0;
1365: END IF;
1366:

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

1383: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1384: RAISE;
1385:
1386: ELSE
1387: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1388:
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1390: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1391: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');

Line 1416: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh

1412: END IF;
1413: END;
1414:
1415: END LOOP;
1416: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh
1417:
1418: COMMIT;
1419:
1420: BEGIN

Line 1422: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

1418: COMMIT;
1419:
1420: BEGIN
1421:
1422: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
1423:
1424: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;
1425:
1426: lv_sql_stmt:=

Line 1424: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;

1420: BEGIN
1421:
1422: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
1423:
1424: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;
1425:
1426: lv_sql_stmt:=
1427: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1428: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCE_SEQS'

Line 1429: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id

1425:
1426: lv_sql_stmt:=
1427: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1428: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCE_SEQS'
1429: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1430: ||' AND plan_id = -1 '
1431: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1432:
1433: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

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

1436: COMMIT;
1437:
1438: END IF;
1439:
1440: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1441: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1442: lv_retcode,
1443: 'MSC_OPERATION_RESOURCE_SEQS',
1444: MSC_CL_COLLECTION.v_instance_code,

Line 1441: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,

1437:
1438: END IF;
1439:
1440: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1441: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1442: lv_retcode,
1443: 'MSC_OPERATION_RESOURCE_SEQS',
1444: MSC_CL_COLLECTION.v_instance_code,
1445: MSC_UTIL.G_WARNING

Line 1444: MSC_CL_COLLECTION.v_instance_code,

1440: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1441: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1442: lv_retcode,
1443: 'MSC_OPERATION_RESOURCE_SEQS',
1444: MSC_CL_COLLECTION.v_instance_code,
1445: MSC_UTIL.G_WARNING
1446: );
1447:
1448: IF lv_retcode = MSC_UTIL.G_ERROR THEN

Line 1450: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

1446: );
1447:
1448: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1449: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1450: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1451: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1452: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1453: END IF;
1454:

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

1448: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1449: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1450: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1451: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1452: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1453: END IF;
1454:
1455: END IF;
1456:

Line 1499: WHERE msro.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1495: msro.DELETED_FLAG,
1496: msro.SR_INSTANCE_ID,
1497: msro.ORGANIZATION_ID
1498: FROM MSC_ST_ROUTING_OPERATIONS msro
1499: WHERE msro.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1500: AND msro.DELETED_FLAG= MSC_UTIL.SYS_NO;
1501:
1502: CURSOR c5_d IS
1503: SELECT

Line 1508: WHERE msro.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1504: msro.ROUTING_SEQUENCE_ID,
1505: msro.OPERATION_SEQUENCE_ID,
1506: msro.SR_INSTANCE_ID
1507: FROM MSC_ST_ROUTING_OPERATIONS msro
1508: WHERE msro.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1509: AND msro.DELETED_FLAG= MSC_UTIL.SYS_YES;
1510:
1511:
1512: c_count NUMBER:= 0;

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

1519: lv_retcode NUMBER;
1520:
1521: BEGIN
1522:
1523: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1524: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1525: ELSE
1526: lv_tbl:= 'MSC_ROUTING_OPERATIONS';
1527: END IF;

Line 1524: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;

1520:
1521: BEGIN
1522:
1523: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1524: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1525: ELSE
1526: lv_tbl:= 'MSC_ROUTING_OPERATIONS';
1527: END IF;
1528:

Line 1529: IF MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh THEN

1525: ELSE
1526: lv_tbl:= 'MSC_ROUTING_OPERATIONS';
1527: END IF;
1528:
1529: IF MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh THEN
1530: -- We want to delete all BOM related data and get new stuff
1531: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1532:
1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN

Line 1531: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

1527: END IF;
1528:
1529: IF MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh THEN
1530: -- We want to delete all BOM related data and get new stuff
1531: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1532:
1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

Line 1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN

1529: IF MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh THEN
1530: -- We want to delete all BOM related data and get new stuff
1531: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1532:
1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1536: ELSE
1537: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1530: -- We want to delete all BOM related data and get new stuff
1531: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1532:
1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1536: ELSE
1537: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1538: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

1531: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1532:
1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1536: ELSE
1537: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1538: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1539: END IF;

Line 1538: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1536: ELSE
1537: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1538: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1539: END IF;
1540: END IF;
1541:
1542: BEGIN

Line 1611: ||' WHERE msro.SR_INSTANCE_ID= ' || MSC_CL_COLLECTION.v_instance_id

1607: ||' :v_current_user, '
1608: ||' :v_current_date, '
1609: ||' :v_current_user '
1610: ||' FROM MSC_ST_ROUTING_OPERATIONS msro '
1611: ||' WHERE msro.SR_INSTANCE_ID= ' || MSC_CL_COLLECTION.v_instance_id
1612: ||' AND msro.DELETED_FLAG= ' || MSC_UTIL.SYS_NO;
1613:
1614: EXECUTE IMMEDIATE lv_sql_ins
1615: USING v_chr10, v_chr13, MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;

Line 1615: USING v_chr10, v_chr13, MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;

1611: ||' WHERE msro.SR_INSTANCE_ID= ' || MSC_CL_COLLECTION.v_instance_id
1612: ||' AND msro.DELETED_FLAG= ' || MSC_UTIL.SYS_NO;
1613:
1614: EXECUTE IMMEDIATE lv_sql_ins
1615: USING v_chr10, v_chr13, MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
1616:
1617: COMMIT;
1618: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'routing operations loaded');
1619:

Line 1650: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

1646: lb_refresh_failed := TRUE;
1647: END IF;
1648: END;
1649:
1650: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
1651:
1652:
1653: lv_sql_stmt:=
1654: ' INSERT INTO '||lv_tbl

Line 1721: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN

1717: ||' :v_current_user, '
1718: ||' :v_current_date, '
1719: ||' :v_current_user ) ';
1720:
1721: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
1722:
1723: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
1724:
1725: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

Line 1725: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

1721: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
1722:
1723: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
1724:
1725: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1726: FOR c_rec IN c5_d LOOP
1727:
1728: DELETE MSC_ROUTING_OPERATIONS
1729: WHERE PLAN_ID= -1

Line 1743: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

1739: FOR c_rec IN c5 LOOP
1740:
1741: BEGIN
1742:
1743: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1744: UPDATE MSC_ROUTING_OPERATIONS
1745: SET
1746: OPERATION_SEQ_NUM= c_rec.OPERATION_SEQ_NUM,
1747: OPERATION_DESCRIPTION= c_rec.OPERATION_DESCRIPTION,

Line 1769: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

1765: STANDARD_OPERATION_CODE= c_rec.STANDARD_OPERATION_CODE,
1766: STEP_QUANTITY= c_rec.STEP_QUANTITY,
1767: STEP_QUANTITY_UOM= c_rec.STEP_QUANTITY_UOM,
1768: ORGANIZATION_ID = c_rec.ORGANIZATION_ID,
1769: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1770: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1771: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1772: WHERE PLAN_ID= -1
1773: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID

Line 1770: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1766: STEP_QUANTITY= c_rec.STEP_QUANTITY,
1767: STEP_QUANTITY_UOM= c_rec.STEP_QUANTITY_UOM,
1768: ORGANIZATION_ID = c_rec.ORGANIZATION_ID,
1769: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1770: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1771: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1772: WHERE PLAN_ID= -1
1773: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID
1774: AND OPERATION_SEQUENCE_ID= c_rec.OPERATION_SEQUENCE_ID

Line 1771: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

1767: STEP_QUANTITY_UOM= c_rec.STEP_QUANTITY_UOM,
1768: ORGANIZATION_ID = c_rec.ORGANIZATION_ID,
1769: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1770: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1771: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1772: WHERE PLAN_ID= -1
1773: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID
1774: AND OPERATION_SEQUENCE_ID= c_rec.OPERATION_SEQUENCE_ID
1775: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

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

1774: AND OPERATION_SEQUENCE_ID= c_rec.OPERATION_SEQUENCE_ID
1775: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
1776: END IF;
1777:
1778: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1779: EXECUTE IMMEDIATE lv_sql_stmt USING
1780: c_rec.ROUTING_SEQUENCE_ID,
1781: c_rec.OPERATION_SEQ_NUM,
1782: c_rec.OPERATION_SEQUENCE_ID,

Line 1806: MSC_CL_COLLECTION.v_last_collection_id,

1802: c_rec.STEP_QUANTITY,
1803: c_rec.STEP_QUANTITY_UOM,
1804: c_rec.SR_INSTANCE_ID,
1805: c_rec.ORGANIZATION_ID,
1806: MSC_CL_COLLECTION.v_last_collection_id,
1807: MSC_CL_COLLECTION.v_current_date,
1808: MSC_CL_COLLECTION.v_current_user,
1809: MSC_CL_COLLECTION.v_current_date,
1810: MSC_CL_COLLECTION.v_current_user ;

Line 1807: MSC_CL_COLLECTION.v_current_date,

1803: c_rec.STEP_QUANTITY_UOM,
1804: c_rec.SR_INSTANCE_ID,
1805: c_rec.ORGANIZATION_ID,
1806: MSC_CL_COLLECTION.v_last_collection_id,
1807: MSC_CL_COLLECTION.v_current_date,
1808: MSC_CL_COLLECTION.v_current_user,
1809: MSC_CL_COLLECTION.v_current_date,
1810: MSC_CL_COLLECTION.v_current_user ;
1811:

Line 1808: MSC_CL_COLLECTION.v_current_user,

1804: c_rec.SR_INSTANCE_ID,
1805: c_rec.ORGANIZATION_ID,
1806: MSC_CL_COLLECTION.v_last_collection_id,
1807: MSC_CL_COLLECTION.v_current_date,
1808: MSC_CL_COLLECTION.v_current_user,
1809: MSC_CL_COLLECTION.v_current_date,
1810: MSC_CL_COLLECTION.v_current_user ;
1811:
1812: END IF; -- SQL%NOTFOUND

Line 1809: MSC_CL_COLLECTION.v_current_date,

1805: c_rec.ORGANIZATION_ID,
1806: MSC_CL_COLLECTION.v_last_collection_id,
1807: MSC_CL_COLLECTION.v_current_date,
1808: MSC_CL_COLLECTION.v_current_user,
1809: MSC_CL_COLLECTION.v_current_date,
1810: MSC_CL_COLLECTION.v_current_user ;
1811:
1812: END IF; -- SQL%NOTFOUND
1813:

Line 1810: MSC_CL_COLLECTION.v_current_user ;

1806: MSC_CL_COLLECTION.v_last_collection_id,
1807: MSC_CL_COLLECTION.v_current_date,
1808: MSC_CL_COLLECTION.v_current_user,
1809: MSC_CL_COLLECTION.v_current_date,
1810: MSC_CL_COLLECTION.v_current_user ;
1811:
1812: END IF; -- SQL%NOTFOUND
1813:
1814: c_count:= c_count+1;

Line 1816: IF c_count> MSC_CL_COLLECTION.PBS THEN

1812: END IF; -- SQL%NOTFOUND
1813:
1814: c_count:= c_count+1;
1815:
1816: IF c_count> MSC_CL_COLLECTION.PBS THEN
1817: COMMIT;
1818: c_count:= 0;
1819: END IF;
1820:

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

1833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1834: RAISE;
1835:
1836: ELSE
1837: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1838:
1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1840: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1841: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');

Line 1865: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh

1861: END IF;
1862: END;
1863:
1864: END LOOP;
1865: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh
1866:
1867: COMMIT;
1868:
1869: BEGIN

Line 1871: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

1867: COMMIT;
1868:
1869: BEGIN
1870:
1871: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
1872:
1873: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1874:
1875: lv_sql_stmt:=

Line 1873: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;

1869: BEGIN
1870:
1871: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
1872:
1873: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1874:
1875: lv_sql_stmt:=
1876: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1877: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_ROUTING_OPERATIONS'

Line 1878: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id

1874:
1875: lv_sql_stmt:=
1876: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1877: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_ROUTING_OPERATIONS'
1878: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1879: ||' AND plan_id = -1 '
1880: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1881:
1882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

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

1885: COMMIT;
1886:
1887: END IF;
1888:
1889: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1890: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1891: lv_retcode,
1892: 'MSC_ROUTING_OPERATIONS',
1893: MSC_CL_COLLECTION.v_instance_code,

Line 1890: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,

1886:
1887: END IF;
1888:
1889: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1890: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1891: lv_retcode,
1892: 'MSC_ROUTING_OPERATIONS',
1893: MSC_CL_COLLECTION.v_instance_code,
1894: MSC_UTIL.G_WARNING

Line 1893: MSC_CL_COLLECTION.v_instance_code,

1889: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1890: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1891: lv_retcode,
1892: 'MSC_ROUTING_OPERATIONS',
1893: MSC_CL_COLLECTION.v_instance_code,
1894: MSC_UTIL.G_WARNING
1895: );
1896:
1897: IF lv_retcode = MSC_UTIL.G_ERROR THEN

Line 1899: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

1895: );
1896:
1897: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1899: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1900: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1901: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1902: END IF;
1903:

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

1897: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1899: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1900: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1901: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1902: END IF;
1903:
1904: END IF;
1905:

Line 1942: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1938: msor.MAXIMUM_CAPACITY ,
1939: msor.orig_resource_seq_num,
1940: msor.BREAKABLE_ACTIVITY_FLAG /*ds change change end */
1941: FROM MSC_ST_OPERATION_RESOURCES msor
1942: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1943: AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO;
1944:
1945: CURSOR c6_d IS
1946: SELECT

Line 1954: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1950: msor.RESOURCE_ID,
1951: msor.ALTERNATE_NUMBER,
1952: msor.SR_INSTANCE_ID
1953: FROM MSC_ST_OPERATION_RESOURCES msor
1954: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1955: AND msor.DELETED_FLAG= MSC_UTIL.SYS_YES;
1956:
1957: CURSOR c6_corrupt_data IS
1958: SELECT

Line 1963: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1959: msor.ROUTING_SEQUENCE_ID,
1960: msor.RESOURCE_ID,
1961: msor.RESOURCE_SEQ_NUM
1962: FROM MSC_ST_OPERATION_RESOURCES msor
1963: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1964: AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO
1965: AND nvl(msor.RESOURCE_SEQ_NUM,0)=0
1966: AND msor.ALTERNATE_NUMBER > 0;
1967:

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

1977: lv_delete_flag BOOLEAN:= FALSE;
1978:
1979: BEGIN
1980:
1981: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1982: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
1983: ELSE
1984: lv_tbl:= 'MSC_OPERATION_RESOURCES';
1985: END IF;

Line 1982: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;

1978:
1979: BEGIN
1980:
1981: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1982: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
1983: ELSE
1984: lv_tbl:= 'MSC_OPERATION_RESOURCES';
1985: END IF;
1986:

Line 1987: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN

1983: ELSE
1984: lv_tbl:= 'MSC_OPERATION_RESOURCES';
1985: END IF;
1986:
1987: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1988:
1989: -- We want to delete all BOM related data and get new stuff.
1990: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1991:

Line 1990: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

1986:
1987: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1988:
1989: -- We want to delete all BOM related data and get new stuff.
1990: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1991:
1992: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

Line 1992: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN

1988:
1989: -- We want to delete all BOM related data and get new stuff.
1990: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1991:
1992: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1995: ELSE
1996: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1989: -- We want to delete all BOM related data and get new stuff.
1990: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1991:
1992: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1995: ELSE
1996: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1997: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

1990: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1991:
1992: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1995: ELSE
1996: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1997: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1998: END IF;

Line 1997: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1995: ELSE
1996: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1997: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1998: END IF;
1999: END IF;
2000:
2001: BEGIN

Line 2056: ||' WHERE msor.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

2052: ||' :v_current_user, '
2053: ||' :v_current_date, '
2054: ||' :v_current_user '
2055: ||' FROM MSC_ST_OPERATION_RESOURCES msor'
2056: ||' WHERE msor.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2057: ||' AND msor.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2058: ||' AND NOT(nvl(msor.RESOURCE_SEQ_NUM,0)=0 AND msor.ALTERNATE_NUMBER > 0)';
2059:
2060: EXECUTE IMMEDIATE lv_sql_ins

Line 2061: USING MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;

2057: ||' AND msor.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2058: ||' AND NOT(nvl(msor.RESOURCE_SEQ_NUM,0)=0 AND msor.ALTERNATE_NUMBER > 0)';
2059:
2060: EXECUTE IMMEDIATE lv_sql_ins
2061: USING MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
2062:
2063: COMMIT;
2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'operation resources loaded');
2065:

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

2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'operation resources loaded');
2065:
2066: FOR c_rec IN c6_corrupt_data LOOP
2067:
2068: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2069:
2070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2071:
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

Line 2120: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

2116: END IF;
2117:
2118: END;
2119:
2120: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
2121:
2122: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
2123:
2124: lv_sql_stmt :=

Line 2122: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN

2118: END;
2119:
2120: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
2121:
2122: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
2123:
2124: lv_sql_stmt :=
2125: ' INSERT INTO '||lv_tbl
2126: ||' ( PLAN_ID, '

Line 2180: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

2176: ||' :v_current_user ) ';
2177:
2178:
2179: -- set RESOURCE_USAGE to 0 to indicate a SOFT delete
2180: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2181: FOR c_rec IN c6_d LOOP
2182: ---5470477
2183: lv_delete_flag := FALSE;
2184: lv_sql_stmt1 := ' UPDATE MSC_OPERATION_RESOURCES '

Line 2219: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id, MSC_CL_COLLECTION.v_current_date, MSC_CL_COLLECTION.v_current_user, c_rec.SR_INSTANCE_ID ;

2215: END IF;
2216:
2217: BEGIN
2218: If (lv_delete_flag) then
2219: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id, MSC_CL_COLLECTION.v_current_date, MSC_CL_COLLECTION.v_current_user, c_rec.SR_INSTANCE_ID ;
2220: end if;
2221: EXCEPTION
2222: WHEN OTHERS THEN
2223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');

Line 2237: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

2233: /*
2234: UPDATE MSC_OPERATION_RESOURCES
2235: SET RESOURCE_USAGE= 0,
2236: REFRESH_NUMBER= v_last_collection_id,
2237: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
2238: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
2239: WHERE PLAN_ID= -1
2240: AND ROUTING_SEQUENCE_ID= NVL(c_rec.ROUTING_SEQUENCE_ID,ROUTING_SEQUENCE_ID)
2241: AND OPERATION_SEQUENCE_ID= NVL(c_rec.OPERATION_SEQUENCE_ID,OPERATION_SEQUENCE_ID)

Line 2238: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

2234: UPDATE MSC_OPERATION_RESOURCES
2235: SET RESOURCE_USAGE= 0,
2236: REFRESH_NUMBER= v_last_collection_id,
2237: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
2238: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
2239: WHERE PLAN_ID= -1
2240: AND ROUTING_SEQUENCE_ID= NVL(c_rec.ROUTING_SEQUENCE_ID,ROUTING_SEQUENCE_ID)
2241: AND OPERATION_SEQUENCE_ID= NVL(c_rec.OPERATION_SEQUENCE_ID,OPERATION_SEQUENCE_ID)
2242: AND RESOURCE_SEQ_NUM= NVL(c_rec.RESOURCE_SEQ_NUM,RESOURCE_SEQ_NUM)

Line 2258: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

2254: FOR c_rec IN c6 LOOP
2255:
2256: BEGIN
2257:
2258: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2259:
2260: UPDATE MSC_OPERATION_RESOURCES
2261: SET
2262: PRINCIPAL_FLAG= c_rec.PRINCIPAL_FLAG,

Line 2269: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

2265: MAX_RESOURCE_UNITS= c_rec.MAX_RESOURCE_UNITS,
2266: RESOURCE_UNITS= c_rec.RESOURCE_UNITS,
2267: UOM_CODE= c_rec.UOM_CODE,
2268: RESOURCE_TYPE= c_rec.RESOURCE_TYPE,
2269: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
2270: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
2271: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
2272: -- ALTERNATE_NUMBER= c_rec.ALTERNATE_NUMBER, 10359759
2273: ORGANIZATION_ID= c_rec.ORGANIZATION_ID ,

Line 2270: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

2266: RESOURCE_UNITS= c_rec.RESOURCE_UNITS,
2267: UOM_CODE= c_rec.UOM_CODE,
2268: RESOURCE_TYPE= c_rec.RESOURCE_TYPE,
2269: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
2270: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
2271: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
2272: -- ALTERNATE_NUMBER= c_rec.ALTERNATE_NUMBER, 10359759
2273: ORGANIZATION_ID= c_rec.ORGANIZATION_ID ,
2274: SETUP_ID= c_rec.SETUP_ID , /* ds change change start*/

Line 2271: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,

2267: UOM_CODE= c_rec.UOM_CODE,
2268: RESOURCE_TYPE= c_rec.RESOURCE_TYPE,
2269: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
2270: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
2271: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
2272: -- ALTERNATE_NUMBER= c_rec.ALTERNATE_NUMBER, 10359759
2273: ORGANIZATION_ID= c_rec.ORGANIZATION_ID ,
2274: SETUP_ID= c_rec.SETUP_ID , /* ds change change start*/
2275: MINIMUM_CAPACITY = c_rec.MINIMUM_CAPACITY ,

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

2285: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
2286:
2287: END IF;
2288:
2289: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
2290: /* Start changes for 3586386*/
2291: IF nvl(c_rec.RESOURCE_SEQ_NUM,0)=0 AND c_rec.ALTERNATE_NUMBER > 0 THEN
2292:
2293: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

2289: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
2290: /* Start changes for 3586386*/
2291: IF nvl(c_rec.RESOURCE_SEQ_NUM,0)=0 AND c_rec.ALTERNATE_NUMBER > 0 THEN
2292:
2293: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2294:
2295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2296:
2297: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

Line 2334: MSC_CL_COLLECTION.v_last_collection_id,

2330: c_rec.MINIMUM_CAPACITY,
2331: c_rec.MAXIMUM_CAPACITY,
2332: c_rec.orig_resource_seq_num,
2333: c_rec.BREAKABLE_ACTIVITY_FLAG, /* ds change change end */
2334: MSC_CL_COLLECTION.v_last_collection_id,
2335: MSC_CL_COLLECTION.v_current_date,
2336: MSC_CL_COLLECTION.v_current_user,
2337: MSC_CL_COLLECTION.v_current_date,
2338: MSC_CL_COLLECTION.v_current_user ;

Line 2335: MSC_CL_COLLECTION.v_current_date,

2331: c_rec.MAXIMUM_CAPACITY,
2332: c_rec.orig_resource_seq_num,
2333: c_rec.BREAKABLE_ACTIVITY_FLAG, /* ds change change end */
2334: MSC_CL_COLLECTION.v_last_collection_id,
2335: MSC_CL_COLLECTION.v_current_date,
2336: MSC_CL_COLLECTION.v_current_user,
2337: MSC_CL_COLLECTION.v_current_date,
2338: MSC_CL_COLLECTION.v_current_user ;
2339: END IF;

Line 2336: MSC_CL_COLLECTION.v_current_user,

2332: c_rec.orig_resource_seq_num,
2333: c_rec.BREAKABLE_ACTIVITY_FLAG, /* ds change change end */
2334: MSC_CL_COLLECTION.v_last_collection_id,
2335: MSC_CL_COLLECTION.v_current_date,
2336: MSC_CL_COLLECTION.v_current_user,
2337: MSC_CL_COLLECTION.v_current_date,
2338: MSC_CL_COLLECTION.v_current_user ;
2339: END IF;
2340:

Line 2337: MSC_CL_COLLECTION.v_current_date,

2333: c_rec.BREAKABLE_ACTIVITY_FLAG, /* ds change change end */
2334: MSC_CL_COLLECTION.v_last_collection_id,
2335: MSC_CL_COLLECTION.v_current_date,
2336: MSC_CL_COLLECTION.v_current_user,
2337: MSC_CL_COLLECTION.v_current_date,
2338: MSC_CL_COLLECTION.v_current_user ;
2339: END IF;
2340:
2341: END IF; -- SQL%NOTFOUND

Line 2338: MSC_CL_COLLECTION.v_current_user ;

2334: MSC_CL_COLLECTION.v_last_collection_id,
2335: MSC_CL_COLLECTION.v_current_date,
2336: MSC_CL_COLLECTION.v_current_user,
2337: MSC_CL_COLLECTION.v_current_date,
2338: MSC_CL_COLLECTION.v_current_user ;
2339: END IF;
2340:
2341: END IF; -- SQL%NOTFOUND
2342:

Line 2345: IF c_count> MSC_CL_COLLECTION.PBS THEN

2341: END IF; -- SQL%NOTFOUND
2342:
2343: c_count:= c_count+1;
2344:
2345: IF c_count> MSC_CL_COLLECTION.PBS THEN
2346: COMMIT;
2347: c_count:= 0;
2348: END IF;
2349:

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

2361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2362: RAISE;
2363:
2364: ELSE
2365: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2366:
2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2368: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2369: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');

Line 2404: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

2400: COMMIT;
2401:
2402: BEGIN
2403:
2404: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
2405:
2406: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
2407:
2408: lv_sql_stmt:=

Line 2406: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;

2402: BEGIN
2403:
2404: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
2405:
2406: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
2407:
2408: lv_sql_stmt:=
2409: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2410: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCES'

Line 2411: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id

2407:
2408: lv_sql_stmt:=
2409: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2410: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCES'
2411: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2412: ||' AND plan_id = -1 '
2413: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2414:
2415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

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

2418: COMMIT;
2419:
2420: END IF;
2421:
2422: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2423: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2424: lv_retcode,
2425: 'MSC_OPERATION_RESOURCES',
2426: MSC_CL_COLLECTION.v_instance_code,

Line 2423: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,

2419:
2420: END IF;
2421:
2422: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2423: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2424: lv_retcode,
2425: 'MSC_OPERATION_RESOURCES',
2426: MSC_CL_COLLECTION.v_instance_code,
2427: MSC_UTIL.G_WARNING

Line 2426: MSC_CL_COLLECTION.v_instance_code,

2422: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2423: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2424: lv_retcode,
2425: 'MSC_OPERATION_RESOURCES',
2426: MSC_CL_COLLECTION.v_instance_code,
2427: MSC_UTIL.G_WARNING
2428: );
2429:
2430: IF lv_retcode = MSC_UTIL.G_ERROR THEN

Line 2432: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

2428: );
2429:
2430: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2432: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2433: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2434: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2435: END IF;
2436:

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

2430: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2432: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2433: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2434: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2435: END IF;
2436:
2437: END IF;
2438:

Line 2459: and mr.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id

2455: mr.sr_instance_id=mn.sr_instance_id
2456: and mr.routing_sequence_id= mn.routing_sequence_id
2457: and mr.CFM_ROUTING_FLAG=3
2458: and mn.plan_id = -1
2459: and mr.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2460: and (mr.first_op_seq_num is null or mr.last_op_seq_num is null);
2461:
2462: BEGIN
2463:

Line 2477: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),

2473: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.effectivity_date);
2474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2475:
2476: UPDATE MSC_ROUTINGS mr
2477: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),
2478: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)
2479: where mr.sr_instance_id=MSC_CL_COLLECTION.v_instance_id
2480: and mr.ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID
2481: and mr.CFM_ROUTING_FLAG=3

Line 2478: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)

2474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2475:
2476: UPDATE MSC_ROUTINGS mr
2477: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),
2478: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)
2479: where mr.sr_instance_id=MSC_CL_COLLECTION.v_instance_id
2480: and mr.ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID
2481: and mr.CFM_ROUTING_FLAG=3
2482: and mr.plan_id=-1;

Line 2479: where mr.sr_instance_id=MSC_CL_COLLECTION.v_instance_id

2475:
2476: UPDATE MSC_ROUTINGS mr
2477: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),
2478: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)
2479: where mr.sr_instance_id=MSC_CL_COLLECTION.v_instance_id
2480: and mr.ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID
2481: and mr.CFM_ROUTING_FLAG=3
2482: and mr.plan_id=-1;
2483:

Line 2511: and mr.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id

2507: and mr.routing_sequence_id= mn.routing_sequence_id
2508: and mr.CFM_ROUTING_FLAG=3
2509: and mn.plan_id = -1
2510: and mr.deleted_flag = MSC_UTIL.SYS_NO
2511: and mr.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2512: and (mr.first_op_seq_num is null or mr.last_op_seq_num is null);
2513:
2514: BEGIN
2515:

Line 2530: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),

2526: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.effectivity_date);
2527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2528:
2529: UPDATE MSC_ROUTINGS mr
2530: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),
2531: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)
2532: where mr.sr_instance_id=MSC_CL_COLLECTION.v_instance_id
2533: and mr.ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID
2534: and mr.CFM_ROUTING_FLAG=3

Line 2531: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)

2527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2528:
2529: UPDATE MSC_ROUTINGS mr
2530: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),
2531: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)
2532: where mr.sr_instance_id=MSC_CL_COLLECTION.v_instance_id
2533: and mr.ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID
2534: and mr.CFM_ROUTING_FLAG=3
2535: and mr.plan_id=-1;

Line 2532: where mr.sr_instance_id=MSC_CL_COLLECTION.v_instance_id

2528:
2529: UPDATE MSC_ROUTINGS mr
2530: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),
2531: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)
2532: where mr.sr_instance_id=MSC_CL_COLLECTION.v_instance_id
2533: and mr.ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID
2534: and mr.CFM_ROUTING_FLAG=3
2535: and mr.plan_id=-1;
2536:

Line 2619: AND mon2.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id

2615: AND mon.SR_INSTANCE_ID = v_instance_id
2616: AND mon.ROUTING_SEQUENCE_ID = v_routing_sequence_id
2617: AND NOT EXISTS (SELECT 1 FROM MSC_OPERATION_NETWORKS mon2
2618: WHERE mon2.PLAN_ID= -1
2619: AND mon2.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2620: AND mon2.ROUTING_SEQUENCE_ID = v_routing_sequence_id
2621: AND mon.TO_OP_SEQ_ID = mon2.FROM_OP_SEQ_ID)
2622: AND mro.PLAN_ID= -1
2623: AND mro.SR_INSTANCE_ID = v_instance_id