eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_RPO_ODS_LOAD dependencies on MSC_CL_COLLECTION

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

79: NULL;
80: c_count:=0;
81:
82: -- ========= Prepare the Cursor Statement ==========
83: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
84: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
85: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
86: ELSE
87: lv_tbl:= 'MSC_DEMANDS';

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

80: c_count:=0;
81:
82: -- ========= Prepare the Cursor Statement ==========
83: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
84: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
85: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
86: ELSE
87: lv_tbl:= 'MSC_DEMANDS';
88: lv_supplies_tbl:= 'MSC_SUPPLIES';

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

81:
82: -- ========= Prepare the Cursor Statement ==========
83: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
84: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
85: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
86: ELSE
87: lv_tbl:= 'MSC_DEMANDS';
88: lv_supplies_tbl:= 'MSC_SUPPLIES';
89: END IF;

Line 123: Where mshr.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id

119: mshr.Origination_type ,
120: mshr.SR_INSTANCE_ID
121: From MSC_ST_DEMANDS mshr ,
122: msc_item_id_lid t1
123: Where mshr.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
124: ||' And mshr.ro_status_code=''C''
125: And mshr.origination_type= 77
126: AND t1.SR_INVENTORY_ITEM_ID(+)= mshr.inventory_item_id
127: AND t1.sr_instance_id(+)= mshr.sr_instance_id ';

Line 129: if MSC_CL_COLLECTION.v_is_legacy_refresh then

125: And mshr.origination_type= 77
126: AND t1.SR_INVENTORY_ITEM_ID(+)= mshr.inventory_item_id
127: AND t1.sr_instance_id(+)= mshr.sr_instance_id ';
128:
129: if MSC_CL_COLLECTION.v_is_legacy_refresh then
130: lv_del_stmt := lv_del_stmt || ' And mshr.ENTITY=''IRO''' ;
131: else
132: lv_del_stmt := lv_del_stmt || ' And mshr.organization_id '||MSC_UTIL.v_depot_org_str;
133: end if ;

Line 146: WHERE mshr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

142: mshr.WIP_ENTITY_ID,
143: mshr.wip_entity_name
144: FROM MSC_ST_DEMANDS mshr,
145: msc_item_id_lid t1
146: WHERE mshr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
147: ||' AND mshr.DELETED_FLAG= '||MSC_UTIL.SYS_YES
148: ||' AND mshr.ORIGINATION_TYPE=77
149: AND t1.SR_INVENTORY_ITEM_ID(+)= mshr.inventory_item_id
150: AND t1.sr_instance_id(+)= mshr.sr_instance_id ';

Line 153: if MSC_CL_COLLECTION.v_is_legacy_refresh then

149: AND t1.SR_INVENTORY_ITEM_ID(+)= mshr.inventory_item_id
150: AND t1.sr_instance_id(+)= mshr.sr_instance_id ';
151:
152:
153: if MSC_CL_COLLECTION.v_is_legacy_refresh then
154: lv_del_stmt2 := lv_del_stmt2 || ' And mshr.ENTITY=''IRO''' ;
155: else
156: lv_del_stmt2 := lv_del_stmt2 || 'And mshr.organization_id '||MSC_UTIL.v_depot_org_str;
157: end if ;

Line 204: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

200: ||' MSC_ITEM_ID_LID t2,'
201: ||' MSC_ITEM_ID_LID t3,'
202: || lv_supplies_tbl||' ms,'
203: ||' MSC_ST_DEMANDS msd'
204: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
205: ||' AND msd.ORIGINATION_TYPE = 77' /* 50 eam demand: ds change change SRP Change 5909379*/
206: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
207: ||' AND t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id'
208: ||' AND t1.sr_instance_id= msd.SR_INSTANCE_ID'

Line 263: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN -- incremental Refresh

259: ||' CREATED_BY)'
260: || lv_cursor_stmt;
261:
262:
263: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN -- incremental Refresh
264:
265:
266:
267: --=================================================

Line 317: if MSC_CL_COLLECTION.v_is_legacy_refresh then

313: lv_WIP_ENTITY_NAME ;
314:
315:
316: EXIT WHEN C11_d%NOTFOUND;
317: if MSC_CL_COLLECTION.v_is_legacy_refresh then
318: Delete from msc_demands
319: WHERE PLAN_ID= -1
320: AND SR_INSTANCE_ID= lv_SR_INSTANCE_ID
321: AND ORIGINATION_TYPE= lv_ORIGINATION_TYPE

Line 348: OPEN c2 FOR lv_cursor_stmt USING MSC_CL_COLLECTION.v_chr10,

344:
345: /* Opening The cursor ... Perofrom Update ... If not found the n inser ... row operation */
346:
347:
348: OPEN c2 FOR lv_cursor_stmt USING MSC_CL_COLLECTION.v_chr10,
349: MSC_CL_COLLECTION.v_chr13,
350: MSC_CL_COLLECTION.v_last_collection_id,
351: MSC_CL_COLLECTION.v_current_date,
352: MSC_CL_COLLECTION.v_current_user,

Line 349: MSC_CL_COLLECTION.v_chr13,

345: /* Opening The cursor ... Perofrom Update ... If not found the n inser ... row operation */
346:
347:
348: OPEN c2 FOR lv_cursor_stmt USING MSC_CL_COLLECTION.v_chr10,
349: MSC_CL_COLLECTION.v_chr13,
350: MSC_CL_COLLECTION.v_last_collection_id,
351: MSC_CL_COLLECTION.v_current_date,
352: MSC_CL_COLLECTION.v_current_user,
353: MSC_CL_COLLECTION.v_current_date,

Line 350: MSC_CL_COLLECTION.v_last_collection_id,

346:
347:
348: OPEN c2 FOR lv_cursor_stmt USING MSC_CL_COLLECTION.v_chr10,
349: MSC_CL_COLLECTION.v_chr13,
350: MSC_CL_COLLECTION.v_last_collection_id,
351: MSC_CL_COLLECTION.v_current_date,
352: MSC_CL_COLLECTION.v_current_user,
353: MSC_CL_COLLECTION.v_current_date,
354: MSC_CL_COLLECTION.v_current_user;

Line 351: MSC_CL_COLLECTION.v_current_date,

347:
348: OPEN c2 FOR lv_cursor_stmt USING MSC_CL_COLLECTION.v_chr10,
349: MSC_CL_COLLECTION.v_chr13,
350: MSC_CL_COLLECTION.v_last_collection_id,
351: MSC_CL_COLLECTION.v_current_date,
352: MSC_CL_COLLECTION.v_current_user,
353: MSC_CL_COLLECTION.v_current_date,
354: MSC_CL_COLLECTION.v_current_user;
355:

Line 352: MSC_CL_COLLECTION.v_current_user,

348: OPEN c2 FOR lv_cursor_stmt USING MSC_CL_COLLECTION.v_chr10,
349: MSC_CL_COLLECTION.v_chr13,
350: MSC_CL_COLLECTION.v_last_collection_id,
351: MSC_CL_COLLECTION.v_current_date,
352: MSC_CL_COLLECTION.v_current_user,
353: MSC_CL_COLLECTION.v_current_date,
354: MSC_CL_COLLECTION.v_current_user;
355:
356: LOOP

Line 353: MSC_CL_COLLECTION.v_current_date,

349: MSC_CL_COLLECTION.v_chr13,
350: MSC_CL_COLLECTION.v_last_collection_id,
351: MSC_CL_COLLECTION.v_current_date,
352: MSC_CL_COLLECTION.v_current_user,
353: MSC_CL_COLLECTION.v_current_date,
354: MSC_CL_COLLECTION.v_current_user;
355:
356: LOOP
357:

Line 354: MSC_CL_COLLECTION.v_current_user;

350: MSC_CL_COLLECTION.v_last_collection_id,
351: MSC_CL_COLLECTION.v_current_date,
352: MSC_CL_COLLECTION.v_current_user,
353: MSC_CL_COLLECTION.v_current_date,
354: MSC_CL_COLLECTION.v_current_user;
355:
356: LOOP
357:
358: FETCH c2 INTO

Line 404: if MSC_CL_COLLECTION.v_is_legacy_refresh then

400:
401: EXIT WHEN c2%NOTFOUND;
402:
403: BEGIN
404: if MSC_CL_COLLECTION.v_is_legacy_refresh then
405: Update MSC_DEMANDS
406: Set
407: USING_ASSEMBLY_ITEM_ID = lv_USING_ASSEMBLY_ITEM_ID ,
408: USING_ASSEMBLY_DEMAND_DATE = lv_USING_ASSEMBLY_DEMAND_DATE ,

Line 591: MSC_CL_COLLECTION.v_last_collection_id,

587: lv_COMPONENT_SCALING_TYPE,
588: lv_COMPONENT_YIELD_FACTOR,
589: lv_ITEM_TYPE_ID,
590: lv_ITEM_TYPE_VALUE,
591: MSC_CL_COLLECTION.v_last_collection_id,
592: MSC_CL_COLLECTION.v_current_date,
593: MSC_CL_COLLECTION.v_current_user,
594: MSC_CL_COLLECTION.v_current_date,
595: MSC_CL_COLLECTION.v_current_user;

Line 592: MSC_CL_COLLECTION.v_current_date,

588: lv_COMPONENT_YIELD_FACTOR,
589: lv_ITEM_TYPE_ID,
590: lv_ITEM_TYPE_VALUE,
591: MSC_CL_COLLECTION.v_last_collection_id,
592: MSC_CL_COLLECTION.v_current_date,
593: MSC_CL_COLLECTION.v_current_user,
594: MSC_CL_COLLECTION.v_current_date,
595: MSC_CL_COLLECTION.v_current_user;
596:

Line 593: MSC_CL_COLLECTION.v_current_user,

589: lv_ITEM_TYPE_ID,
590: lv_ITEM_TYPE_VALUE,
591: MSC_CL_COLLECTION.v_last_collection_id,
592: MSC_CL_COLLECTION.v_current_date,
593: MSC_CL_COLLECTION.v_current_user,
594: MSC_CL_COLLECTION.v_current_date,
595: MSC_CL_COLLECTION.v_current_user;
596:
597: END IF;

Line 594: MSC_CL_COLLECTION.v_current_date,

590: lv_ITEM_TYPE_VALUE,
591: MSC_CL_COLLECTION.v_last_collection_id,
592: MSC_CL_COLLECTION.v_current_date,
593: MSC_CL_COLLECTION.v_current_user,
594: MSC_CL_COLLECTION.v_current_date,
595: MSC_CL_COLLECTION.v_current_user;
596:
597: END IF;
598: EXCEPTION

Line 595: MSC_CL_COLLECTION.v_current_user;

591: MSC_CL_COLLECTION.v_last_collection_id,
592: MSC_CL_COLLECTION.v_current_date,
593: MSC_CL_COLLECTION.v_current_user,
594: MSC_CL_COLLECTION.v_current_date,
595: MSC_CL_COLLECTION.v_current_user;
596:
597: END IF;
598: EXCEPTION
599:

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

612: END LOOP;
613:
614: END IF; -- incremental Refresh
615:
616: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
617:
618: BEGIN
619:
620:

Line 623: MSC_CL_COLLECTION.v_chr10,

619:
620:
621: EXECUTE IMMEDIATE lv_sql_stmt
622: USING
623: MSC_CL_COLLECTION.v_chr10,
624: MSC_CL_COLLECTION.v_chr13,
625: MSC_CL_COLLECTION.v_last_collection_id,
626: MSC_CL_COLLECTION.v_current_date,
627: MSC_CL_COLLECTION.v_current_user,

Line 624: MSC_CL_COLLECTION.v_chr13,

620:
621: EXECUTE IMMEDIATE lv_sql_stmt
622: USING
623: MSC_CL_COLLECTION.v_chr10,
624: MSC_CL_COLLECTION.v_chr13,
625: MSC_CL_COLLECTION.v_last_collection_id,
626: MSC_CL_COLLECTION.v_current_date,
627: MSC_CL_COLLECTION.v_current_user,
628: MSC_CL_COLLECTION.v_current_date,

Line 625: MSC_CL_COLLECTION.v_last_collection_id,

621: EXECUTE IMMEDIATE lv_sql_stmt
622: USING
623: MSC_CL_COLLECTION.v_chr10,
624: MSC_CL_COLLECTION.v_chr13,
625: MSC_CL_COLLECTION.v_last_collection_id,
626: MSC_CL_COLLECTION.v_current_date,
627: MSC_CL_COLLECTION.v_current_user,
628: MSC_CL_COLLECTION.v_current_date,
629: MSC_CL_COLLECTION.v_current_user;

Line 626: MSC_CL_COLLECTION.v_current_date,

622: USING
623: MSC_CL_COLLECTION.v_chr10,
624: MSC_CL_COLLECTION.v_chr13,
625: MSC_CL_COLLECTION.v_last_collection_id,
626: MSC_CL_COLLECTION.v_current_date,
627: MSC_CL_COLLECTION.v_current_user,
628: MSC_CL_COLLECTION.v_current_date,
629: MSC_CL_COLLECTION.v_current_user;
630:

Line 627: MSC_CL_COLLECTION.v_current_user,

623: MSC_CL_COLLECTION.v_chr10,
624: MSC_CL_COLLECTION.v_chr13,
625: MSC_CL_COLLECTION.v_last_collection_id,
626: MSC_CL_COLLECTION.v_current_date,
627: MSC_CL_COLLECTION.v_current_user,
628: MSC_CL_COLLECTION.v_current_date,
629: MSC_CL_COLLECTION.v_current_user;
630:
631:

Line 628: MSC_CL_COLLECTION.v_current_date,

624: MSC_CL_COLLECTION.v_chr13,
625: MSC_CL_COLLECTION.v_last_collection_id,
626: MSC_CL_COLLECTION.v_current_date,
627: MSC_CL_COLLECTION.v_current_user,
628: MSC_CL_COLLECTION.v_current_date,
629: MSC_CL_COLLECTION.v_current_user;
630:
631:
632: COMMIT;

Line 629: MSC_CL_COLLECTION.v_current_user;

625: MSC_CL_COLLECTION.v_last_collection_id,
626: MSC_CL_COLLECTION.v_current_date,
627: MSC_CL_COLLECTION.v_current_user,
628: MSC_CL_COLLECTION.v_current_date,
629: MSC_CL_COLLECTION.v_current_user;
630:
631:
632: COMMIT;
633:

Line 673: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

669: msd.SR_INSTANCE_ID,
670: msd.ORGANIZATION_ID
671: FROM MSC_ITEM_ID_LID t1,
672: MSC_ST_DEMANDS msd
673: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
674: AND msd.ORIGINATION_TYPE = 77
675: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES
676: AND t1.SR_INVENTORY_ITEM_ID(+)= msd.inventory_item_id
677: AND t1.sr_instance_id(+)= MSC_CL_COLLECTION.v_instance_id;*/

Line 677: AND t1.sr_instance_id(+)= MSC_CL_COLLECTION.v_instance_id;*/

673: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
674: AND msd.ORIGINATION_TYPE = 77
675: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES
676: AND t1.SR_INVENTORY_ITEM_ID(+)= msd.inventory_item_id
677: AND t1.sr_instance_id(+)= MSC_CL_COLLECTION.v_instance_id;*/
678:
679: lv_DISPOSITION_ID NUMBER;
680: lv_INVENTORY_ITEM_ID NUMBER;
681: lv_ORGANIZATION_ID NUMBER;

Line 714: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN -- incremental Refresh

710: lv_data_sql_stmt VARCHAR2(1000);
711:
712: BEGIN
713:
714: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN -- incremental Refresh
715:
716: lv_del_stmt := 'SELECT msd1.WIP_ENTITY_ID,
717: msd1.OPERATION_SEQ_NUM,
718: t1.INVENTORY_ITEM_ID,

Line 724: WHERE msd1.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

720: msd1.SR_INSTANCE_ID,
721: msd1.ORGANIZATION_ID
722: FROM MSC_ITEM_ID_LID t1,
723: MSC_ST_DEMANDS msd1
724: WHERE msd1.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
725: ||' AND msd1.ORIGINATION_TYPE = 77
726: AND msd1.DELETED_FLAG= '|| MSC_UTIL.SYS_YES
727: ||' AND t1.SR_INVENTORY_ITEM_ID(+)= msd1.inventory_item_id
728: AND t1.sr_instance_id(+)= '||MSC_CL_COLLECTION.v_instance_id ;

Line 728: AND t1.sr_instance_id(+)= '||MSC_CL_COLLECTION.v_instance_id ;

724: WHERE msd1.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
725: ||' AND msd1.ORIGINATION_TYPE = 77
726: AND msd1.DELETED_FLAG= '|| MSC_UTIL.SYS_YES
727: ||' AND t1.SR_INVENTORY_ITEM_ID(+)= msd1.inventory_item_id
728: AND t1.sr_instance_id(+)= '||MSC_CL_COLLECTION.v_instance_id ;
729:
730: if MSC_CL_COLLECTION.v_is_legacy_refresh then
731: lv_del_stmt:=lv_del_stmt ||' AND msd1.ENTITY=''ERO''';
732: else

Line 730: if MSC_CL_COLLECTION.v_is_legacy_refresh then

726: AND msd1.DELETED_FLAG= '|| MSC_UTIL.SYS_YES
727: ||' AND t1.SR_INVENTORY_ITEM_ID(+)= msd1.inventory_item_id
728: AND t1.sr_instance_id(+)= '||MSC_CL_COLLECTION.v_instance_id ;
729:
730: if MSC_CL_COLLECTION.v_is_legacy_refresh then
731: lv_del_stmt:=lv_del_stmt ||' AND msd1.ENTITY=''ERO''';
732: else
733: lv_del_stmt:=lv_del_stmt ||' AND msd1.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str;
734: end if ;

Line 754: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

750:
751: UPDATE MSC_DEMANDS
752: SET USING_REQUIREMENT_QUANTITY= 0,
753: DAILY_DEMAND_RATE= 0,
754: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
755: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
756: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
757: WHERE PLAN_ID= -1
758: AND SR_INSTANCE_ID= lv_SR_INSTANCE_ID

Line 755: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

751: UPDATE MSC_DEMANDS
752: SET USING_REQUIREMENT_QUANTITY= 0,
753: DAILY_DEMAND_RATE= 0,
754: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
755: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
756: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
757: WHERE PLAN_ID= -1
758: AND SR_INSTANCE_ID= lv_SR_INSTANCE_ID
759: AND ORIGINATION_TYPE= lv_ORIGINATION_TYPE

Line 756: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

752: SET USING_REQUIREMENT_QUANTITY= 0,
753: DAILY_DEMAND_RATE= 0,
754: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
755: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
756: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
757: WHERE PLAN_ID= -1
758: AND SR_INSTANCE_ID= lv_SR_INSTANCE_ID
759: AND ORIGINATION_TYPE= lv_ORIGINATION_TYPE
760: AND WIP_ENTITY_ID= lv_WIP_ENTITY_ID

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

768:
769: c_count:=0;
770:
771: -- ========= Prepare the Cursor Statement ==========
772: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
773: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
774: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
775: ELSE
776: lv_tbl:= 'MSC_DEMANDS';

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

769: c_count:=0;
770:
771: -- ========= Prepare the Cursor Statement ==========
772: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
773: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
774: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
775: ELSE
776: lv_tbl:= 'MSC_DEMANDS';
777: lv_supplies_tbl:= 'MSC_SUPPLIES';

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

770:
771: -- ========= Prepare the Cursor Statement ==========
772: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
773: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
774: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
775: ELSE
776: lv_tbl:= 'MSC_DEMANDS';
777: lv_supplies_tbl:= 'MSC_SUPPLIES';
778: END IF;

Line 837: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

833: ||' MSC_ITEM_ID_LID t2,'
834: ||' MSC_ITEM_ID_LID t3,'
835: || lv_supplies_tbl||' ms,'
836: ||' MSC_ST_DEMANDS msd'
837: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
838: ||' AND msd.ORIGINATION_TYPE = 77' /* 50 eam demand: ds change change SRP Change 5909379*/
839: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
840: ||' AND t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id'
841: ||' AND t1.sr_instance_id= msd.SR_INSTANCE_ID'

Line 852: IF NOT MSC_CL_COLLECTION.v_is_incremental_refresh THEN

848: ||' AND ms.DISPOSITION_ID= msd.wip_entity_id '
849: ||' AND ms.plan_id=-1'
850: ||' AND ms.ORDER_TYPE= 86'; /* ds change change*/
851:
852: IF NOT MSC_CL_COLLECTION.v_is_incremental_refresh THEN
853: lv_sql_stmt:=
854: 'INSERT /*+ APPEND */ INTO '||lv_tbl
855: ||'( PLAN_ID,'
856: ||' DEMAND_ID,'

Line 901: MSC_CL_COLLECTION.v_chr10,

897:
898:
899: EXECUTE IMMEDIATE lv_sql_stmt
900: USING
901: MSC_CL_COLLECTION.v_chr10,
902: MSC_CL_COLLECTION.v_chr13,
903: MSC_CL_COLLECTION.v_last_collection_id,
904: MSC_CL_COLLECTION.v_current_date,
905: MSC_CL_COLLECTION.v_current_user,

Line 902: MSC_CL_COLLECTION.v_chr13,

898:
899: EXECUTE IMMEDIATE lv_sql_stmt
900: USING
901: MSC_CL_COLLECTION.v_chr10,
902: MSC_CL_COLLECTION.v_chr13,
903: MSC_CL_COLLECTION.v_last_collection_id,
904: MSC_CL_COLLECTION.v_current_date,
905: MSC_CL_COLLECTION.v_current_user,
906: MSC_CL_COLLECTION.v_current_date,

Line 903: MSC_CL_COLLECTION.v_last_collection_id,

899: EXECUTE IMMEDIATE lv_sql_stmt
900: USING
901: MSC_CL_COLLECTION.v_chr10,
902: MSC_CL_COLLECTION.v_chr13,
903: MSC_CL_COLLECTION.v_last_collection_id,
904: MSC_CL_COLLECTION.v_current_date,
905: MSC_CL_COLLECTION.v_current_user,
906: MSC_CL_COLLECTION.v_current_date,
907: MSC_CL_COLLECTION.v_current_user;

Line 904: MSC_CL_COLLECTION.v_current_date,

900: USING
901: MSC_CL_COLLECTION.v_chr10,
902: MSC_CL_COLLECTION.v_chr13,
903: MSC_CL_COLLECTION.v_last_collection_id,
904: MSC_CL_COLLECTION.v_current_date,
905: MSC_CL_COLLECTION.v_current_user,
906: MSC_CL_COLLECTION.v_current_date,
907: MSC_CL_COLLECTION.v_current_user;
908:

Line 905: MSC_CL_COLLECTION.v_current_user,

901: MSC_CL_COLLECTION.v_chr10,
902: MSC_CL_COLLECTION.v_chr13,
903: MSC_CL_COLLECTION.v_last_collection_id,
904: MSC_CL_COLLECTION.v_current_date,
905: MSC_CL_COLLECTION.v_current_user,
906: MSC_CL_COLLECTION.v_current_date,
907: MSC_CL_COLLECTION.v_current_user;
908:
909:

Line 906: MSC_CL_COLLECTION.v_current_date,

902: MSC_CL_COLLECTION.v_chr13,
903: MSC_CL_COLLECTION.v_last_collection_id,
904: MSC_CL_COLLECTION.v_current_date,
905: MSC_CL_COLLECTION.v_current_user,
906: MSC_CL_COLLECTION.v_current_date,
907: MSC_CL_COLLECTION.v_current_user;
908:
909:
910: COMMIT;

Line 907: MSC_CL_COLLECTION.v_current_user;

903: MSC_CL_COLLECTION.v_last_collection_id,
904: MSC_CL_COLLECTION.v_current_date,
905: MSC_CL_COLLECTION.v_current_user,
906: MSC_CL_COLLECTION.v_current_date,
907: MSC_CL_COLLECTION.v_current_user;
908:
909:
910: COMMIT;
911:

Line 927: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN -- incremental Refresh

923: END;
924: END IF; --v_is_complete_refresh
925:
926: --==========================
927: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN -- incremental Refresh
928: -- ========= Prepare SQL Statement for INSERT ==========
929: lv_sql_stmt:=
930: 'INSERT INTO '||lv_tbl
931: ||'( PLAN_ID,'

Line 1050: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

1046: ||' MSC_ITEM_ID_LID t2,'
1047: ||' MSC_ITEM_ID_LID t3,'
1048: || lv_supplies_tbl||' ms,'
1049: ||' MSC_ST_DEMANDS msd'
1050: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1051: ||' AND msd.ORIGINATION_TYPE = 77' /* 50 eam demand: ds change change*/
1052: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
1053: ||' AND t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id'
1054: ||' AND t1.sr_instance_id= msd.SR_INSTANCE_ID'

Line 1066: OPEN c2 FOR lv_cursor_stmt USING MSC_CL_COLLECTION.v_chr10, MSC_CL_COLLECTION.v_chr13;

1062: ||' AND ms.plan_id=-1'
1063: ||' AND ms.ORDER_TYPE= 86' /* ds change change*/
1064: ||' order by msd.SOURCE_WIP_ENTITY_ID, msd.SOURCE_INVENTORY_ITEM_ID,msd.SOURCE_ORGANIZATION_ID,msd.ORIGINATION_TYPE';
1065:
1066: OPEN c2 FOR lv_cursor_stmt USING MSC_CL_COLLECTION.v_chr10, MSC_CL_COLLECTION.v_chr13;
1067:
1068: LOOP
1069:
1070: FETCH c2 INTO

Line 1132: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

1128: WIP_SUPPLY_TYPE= lv_WIP_SUPPLY_TYPE,
1129: DISPOSITION_ID= lv_DISPOSITION_ID,
1130: COMPONENT_SCALING_TYPE = lv_COMPONENT_SCALING_TYPE, /* Discrete Mfg Enahancements Bug 4492736 */
1131: COMPONENT_YIELD_FACTOR = lv_COMPONENT_YIELD_FACTOR, /* Discrete Mfg Enahancements Bug 4492743 */
1132: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1133: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1134: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1135: WHERE PLAN_ID= -1
1136: AND SR_INSTANCE_ID= lv_SR_INSTANCE_ID

Line 1133: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1129: DISPOSITION_ID= lv_DISPOSITION_ID,
1130: COMPONENT_SCALING_TYPE = lv_COMPONENT_SCALING_TYPE, /* Discrete Mfg Enahancements Bug 4492736 */
1131: COMPONENT_YIELD_FACTOR = lv_COMPONENT_YIELD_FACTOR, /* Discrete Mfg Enahancements Bug 4492743 */
1132: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1133: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1134: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1135: WHERE PLAN_ID= -1
1136: AND SR_INSTANCE_ID= lv_SR_INSTANCE_ID
1137: AND ORIGINATION_TYPE= lv_ORIGINATION_TYPE

Line 1134: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

1130: COMPONENT_SCALING_TYPE = lv_COMPONENT_SCALING_TYPE, /* Discrete Mfg Enahancements Bug 4492736 */
1131: COMPONENT_YIELD_FACTOR = lv_COMPONENT_YIELD_FACTOR, /* Discrete Mfg Enahancements Bug 4492743 */
1132: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1133: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1134: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1135: WHERE PLAN_ID= -1
1136: AND SR_INSTANCE_ID= lv_SR_INSTANCE_ID
1137: AND ORIGINATION_TYPE= lv_ORIGINATION_TYPE
1138: AND ORGANIZATION_ID= lv_ORGANIZATION_ID

Line 1182: MSC_CL_COLLECTION.v_last_collection_id,

1178: lv_COMPONENT_SCALING_TYPE, /* Discrete Mfg Enahancements Bug 4492736 */
1179: lv_COMPONENT_YIELD_FACTOR, /* Discrete Mfg Enahancements Bug 4492743 */
1180: lv_item_type_id,
1181: lv_item_type_value,
1182: MSC_CL_COLLECTION.v_last_collection_id,
1183: MSC_CL_COLLECTION.v_current_date,
1184: MSC_CL_COLLECTION.v_current_user,
1185: MSC_CL_COLLECTION.v_current_date,
1186: MSC_CL_COLLECTION.v_current_user;

Line 1183: MSC_CL_COLLECTION.v_current_date,

1179: lv_COMPONENT_YIELD_FACTOR, /* Discrete Mfg Enahancements Bug 4492743 */
1180: lv_item_type_id,
1181: lv_item_type_value,
1182: MSC_CL_COLLECTION.v_last_collection_id,
1183: MSC_CL_COLLECTION.v_current_date,
1184: MSC_CL_COLLECTION.v_current_user,
1185: MSC_CL_COLLECTION.v_current_date,
1186: MSC_CL_COLLECTION.v_current_user;
1187:

Line 1184: MSC_CL_COLLECTION.v_current_user,

1180: lv_item_type_id,
1181: lv_item_type_value,
1182: MSC_CL_COLLECTION.v_last_collection_id,
1183: MSC_CL_COLLECTION.v_current_date,
1184: MSC_CL_COLLECTION.v_current_user,
1185: MSC_CL_COLLECTION.v_current_date,
1186: MSC_CL_COLLECTION.v_current_user;
1187:
1188: END IF;

Line 1185: MSC_CL_COLLECTION.v_current_date,

1181: lv_item_type_value,
1182: MSC_CL_COLLECTION.v_last_collection_id,
1183: MSC_CL_COLLECTION.v_current_date,
1184: MSC_CL_COLLECTION.v_current_user,
1185: MSC_CL_COLLECTION.v_current_date,
1186: MSC_CL_COLLECTION.v_current_user;
1187:
1188: END IF;
1189:

Line 1186: MSC_CL_COLLECTION.v_current_user;

1182: MSC_CL_COLLECTION.v_last_collection_id,
1183: MSC_CL_COLLECTION.v_current_date,
1184: MSC_CL_COLLECTION.v_current_user,
1185: MSC_CL_COLLECTION.v_current_date,
1186: MSC_CL_COLLECTION.v_current_user;
1187:
1188: END IF;
1189:
1190: EXCEPTION

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

1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1203: RAISE;
1204:
1205: ELSE
1206: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1207:
1208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1209:
1210: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1219: MSC_CL_COLLECTION.v_instance_id));

1215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1217: FND_MESSAGE.SET_TOKEN('VALUE',
1218: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1219: MSC_CL_COLLECTION.v_instance_id));
1220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1221:
1222: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1223: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');

Line 1240: IF c_count> MSC_CL_COLLECTION.PBS THEN

1236: END;
1237:
1238: c_count:= c_count+1;
1239:
1240: IF c_count> MSC_CL_COLLECTION.PBS THEN
1241: c_count:= 0;
1242: END IF;
1243: END LOOP; -- cursor c2
1244:

Line 1247: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh THEN -- incremental Refresh

1243: END LOOP; -- cursor c2
1244:
1245: CLOSE c2;
1246:
1247: END IF; -- MSC_CL_COLLECTION.v_is_incremental_refresh THEN -- incremental Refresh
1248: --==========================
1249: EXCEPTION
1250: WHEN OTHERS THEN
1251: IF c2%ISOPEN THEN CLOSE c2; END IF;