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_SCN_UTILS dependencies on MSC_ACTIVITY_PARAMETERS

Line 10: from msc_activity_parameters

6:
7: Procedure insert_seed_data is
8: Cursor tcur is
9: select count(*)
10: from msc_activity_parameters
11: where param_version >= p_version;
12:
13: ln_count number := 0;
14: begin

Line 50: msc_activity_parameters

46: 4 Run Inventory Plan
47: 6 Run Supply Network Plan
48:
49:
50: msc_activity_parameters
51: ACTIVITY_TYPE NOT NULL NUMBER
52: NAME NOT NULL VARCHAR2(30)
53: DATA_TYPE VARCHAR2(30)
54: DEFAULT_VALUE VARCHAR2(30)

Line 78: delete from msc_activity_parameters;

74: fetch tcur into ln_count;
75: close tcur;
76: if nvl(ln_count,0) < 1 then
77:
78: delete from msc_activity_parameters;
79: commit;
80:
81: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
82: NAME,

Line 81: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

77:
78: delete from msc_activity_parameters;
79: commit;
80:
81: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
82: NAME,
83: DATA_TYPE,
84: DEFAULT_VALUE,
85: SEQUENCE,

Line 97: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

93: VALUES(1,'PLAN_ID','NUMBER',NULL,1,
94: '',
95: 1,SYSDATE,'Y','N','Plan Name',p_version);
96:
97: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
98: NAME,
99: DATA_TYPE,
100: DEFAULT_VALUE,
101: SEQUENCE,

Line 115: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

111: 'from mfg_lookups '||
112: 'where lookup_type = ''MSC_LAUNCH_SNAPSHOT''',
113: 1,SYSDATE,'Y','Y','Launch Snapshot',p_version);
114:
115: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
116: NAME,
117: DATA_TYPE,
118: DEFAULT_VALUE,
119: SEQUENCE,

Line 134: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

130: 'where lookup_type = ''SYS_YES_NO''',
131: 1,SYSDATE,'Y','Y','Launch Planner',p_version);
132:
133:
134: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
135: NAME,
136: DATA_TYPE,
137: DEFAULT_VALUE,
138: SEQUENCE,

Line 150: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

146: VALUES(1,'ANCHOR_DATE','DATE',SYSDATE,4,
147: '',
148: 1,SYSDATE,'Y','Y','Anchor Date',p_version);
149:
150: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
151: NAME,
152: DATA_TYPE,
153: DEFAULT_VALUE,
154: SEQUENCE,

Line 167: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

163: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
164: 1,sysdate,'Y','Y','Archive Plan Summary',p_version);
165:
166:
167: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
168: NAME,
169: DATA_TYPE,
170: DEFAULT_VALUE,
171: SEQUENCE,

Line 186: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

182: 'where lookup_type = ''MSC_24X7_PURGE''',
183: 1,SYSDATE,'Y','Y','Enable 24x7ATP',p_version);
184:
185:
186: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
187: NAME,
188: DATA_TYPE,
189: DEFAULT_VALUE,
190: SEQUENCE,

Line 204: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

200: 'from mfg_lookups '||
201: 'where lookup_type = ''SYS_YES_NO''',
202: 1,SYSDATE,'Y','Y','Release Reschedules',p_version);
203:
204: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
205: NAME,
206: DATA_TYPE,
207: DEFAULT_VALUE,
208: SEQUENCE,

Line 222: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

218: 'from mfg_lookups '||
219: 'where lookup_type = ''SYS_YES_NO''',
220: 1,SYSDATE,'Y','Y','Snapshot Static Entities',p_version);
221:
222: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
223: NAME,
224: DATA_TYPE,
225: DEFAULT_VALUE,
226: SEQUENCE,

Line 250: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

246: ' AND NVL(plans.copy_plan_id,-1) = -1'||
247: ' AND NVL(desig.copy_designator_id, -1) = -1',
248: 1,SYSDATE,'Y','N','Plan Name',p_version);
249:
250: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
251: NAME,
252: DATA_TYPE,
253: DEFAULT_VALUE,
254: SEQUENCE,

Line 268: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

264: 'from mfg_lookups '||
265: 'where lookup_type = ''SYS_YES_NO''',
266: 1,SYSDATE,'Y','Y','Solve in Server',p_version);
267:
268: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
269: NAME,
270: DATA_TYPE,
271: DEFAULT_VALUE,
272: SEQUENCE,

Line 287: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

283:
284:
285:
286:
287: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
288: NAME,
289: DATA_TYPE,
290: DEFAULT_VALUE,
291: SEQUENCE,

Line 303: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

299: VALUES(4,'PLAN_ID','NUMBER',NULL,1,
300: '',
301: 1,SYSDATE,'Y','N','Plan Name',p_version);
302:
303: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
304: NAME,
305: DATA_TYPE,
306: DEFAULT_VALUE,
307: SEQUENCE,

Line 321: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

317: 1,SYSDATE,'Y','Y','Anchor Date',p_version);
318:
319:
320:
321: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
322: NAME,
323: DATA_TYPE,
324: DEFAULT_VALUE,
325: SEQUENCE,

Line 338: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

334: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
335: 1,sysdate,'Y','Y','Archive Plan Summary',p_version);
336:
337:
338: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
339: NAME,
340: DATA_TYPE,
341: DEFAULT_VALUE,
342: SEQUENCE,

Line 356: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

352: 'FROM MSC_APPS_INSTANCES '||
353: 'where instance_type IN (1,2,4) and enable_flag = 1',
354: 1,SYSDATE,'Y','Y','Instance',p_version);
355:
356: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
357: NAME,
358: DATA_TYPE,
359: DEFAULT_VALUE,
360: SEQUENCE,

Line 372: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

368: VALUES(11,'COLLECTION_GROUP','VARCHAR2',NULL,2,
369: 'select CODE hidden, ORG_GROUP Display FROM MSC_ORG_GROUPS_V ' ,
370: 1,SYSDATE,'Y','Y','Collections Group',p_version);
371:
372: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
373: NAME,
374: DATA_TYPE,
375: DEFAULT_VALUE,
376: SEQUENCE,

Line 386: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

382: DISPLAY_NAME,
383: PARAM_VERSION)
384: VALUES(11,'TOTAL_WORKER_NUM','NUMBER',3,3,NULL,1,SYSDATE,'Y','Y','Number of workers',p_version);
385:
386: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
387: NAME,
388: DATA_TYPE,
389: DEFAULT_VALUE,
390: SEQUENCE,

Line 400: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

396: DISPLAY_NAME,
397: PARAM_VERSION)
398: VALUES(11,'TIME_OUT','NUMBER',180,4,NULL,1,SYSDATE,'Y','Y','Timeout (Minutes)',p_version);
399:
400: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
401: NAME,
402: DATA_TYPE,
403: DEFAULT_VALUE,
404: SEQUENCE,

Line 416: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

412: VALUES(11,'ODS_PURGE_OPTION','VARCHAR2','Y',5,
413: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
414: 1,SYSDATE,'Y','Y','Purge Previously Collected Data',p_version);
415:
416: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
417: NAME,
418: DATA_TYPE,
419: DEFAULT_VALUE,
420: SEQUENCE,

Line 433: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

429: 'select decode(lookup_code, 1, ''COMPLETE_REFRESH'',2,''NET_CHANGE_REFRESH'',3,''TARGETED_REFRESH'') hidden, meaning display ' ||
430: 'from mfg_lookups WHERE lookup_type = ''PARTIAL_YES_NO''',
431: 1,SYSDATE,'Y','Y','Collection Method',p_version);
432:
433: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
434: NAME,
435: DATA_TYPE,
436: DEFAULT_VALUE,
437: SEQUENCE,

Line 449: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

445: VALUES(11,'ANALYZE_TABLES_ENABLED','VARCHAR2','N',7,
446: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
447: 1,SYSDATE,'Y','Y','Analyze Staging Tables',p_version);
448:
449: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
450: NAME,
451: DATA_TYPE,
452: DEFAULT_VALUE,
453: SEQUENCE,

Line 466: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

462: ' select decode(lookup_code, 1, ''YES_REPLACE'',2,''NO'',3,''YES_BUT_RETAIN_CP'') hidden, meaning display '||
463: 'from mfg_lookups where lookup_type=''MSC_X_ASL_SYS_YES_NO''',
464: 1,SYSDATE,'Y','Y','Collect Approved Supplier Lists (Supplier Capacities)',p_version);
465:
466: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
467: NAME,
468: DATA_TYPE,
469: DEFAULT_VALUE,
470: SEQUENCE,

Line 482: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

478: VALUES(11,'ATP_RULES_ENABLED','VARCHAR2','Y',9,
479: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
480: 1,SYSDATE,'Y','Y','Collect ATP Rules',p_version);
481:
482: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
483: NAME,
484: DATA_TYPE,
485: DEFAULT_VALUE,
486: SEQUENCE,

Line 498: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

494: VALUES(11,'BOM_ENABLED','VARCHAR2','Y',10,
495: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
496: 1,SYSDATE,'Y','Y','Collect Bill of Materials/Routings/Resources',p_version);
497:
498: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
499: NAME,
500: DATA_TYPE,
501: DEFAULT_VALUE,
502: SEQUENCE,

Line 514: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

510: VALUES(11,'BOR_ENABLED','VARCHAR2','Y',11,
511: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
512: 1,SYSDATE,'Y','Y','Collect Bills of Resources',p_version);
513:
514: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
515: NAME,
516: DATA_TYPE,
517: DEFAULT_VALUE,
518: SEQUENCE,

Line 530: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

526: VALUES(11,'CALENDAR_ENABLED','VARCHAR2','Y',12,
527: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
528: 1,SYSDATE,'Y','Y','Collect Calendars',p_version);
529:
530: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
531: NAME,
532: DATA_TYPE,
533: DEFAULT_VALUE,
534: SEQUENCE,

Line 546: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

542: VALUES(11,'DEMAND_CLASS_ENABLED','VARCHAR2','Y',13,
543: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
544: 1,SYSDATE,'Y','Y','Collect Demand Classes',p_version);
545:
546: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
547: NAME,
548: DATA_TYPE,
549: DEFAULT_VALUE,
550: SEQUENCE,

Line 562: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

558: VALUES(11,'ITEM_SUBST_ENABLED','VARCHAR2','Y',14,
559: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
560: 1,SYSDATE,'Y','Y','Collect End Item Substitutions',p_version);
561:
562: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
563: NAME,
564: DATA_TYPE,
565: DEFAULT_VALUE,
566: SEQUENCE,

Line 578: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

574: VALUES(11,'FORECAST_ENABLED','VARCHAR2','Y',15,
575: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
576: 1,SYSDATE,'Y','Y','Collect Forecasts',p_version);
577:
578: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
579: NAME,
580: DATA_TYPE,
581: DEFAULT_VALUE,
582: SEQUENCE,

Line 594: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

590: VALUES(11,'ITEM_ENABLED','VARCHAR2','Y',16,
591: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
592: 1,SYSDATE,'Y','Y','Collect Items',p_version);
593:
594: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
595: NAME,
596: DATA_TYPE,
597: DEFAULT_VALUE,
598: SEQUENCE,

Line 610: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

606: VALUES(11,'KPI_BIS_ENABLED','VARCHAR2','Y',17,
607: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
608: 1,SYSDATE,'Y','Y','Collect Key Performance Indicator Targets',p_version);
609:
610: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
611: NAME,
612: DATA_TYPE,
613: DEFAULT_VALUE,
614: SEQUENCE,

Line 626: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

622: VALUES(11,'MDS_ENABLED','VARCHAR2','Y',18,
623: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
624: 1,SYSDATE,'Y','Y','Collect Master Demand Schedules',p_version);
625:
626: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
627: NAME,
628: DATA_TYPE,
629: DEFAULT_VALUE,
630: SEQUENCE,

Line 642: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

638: VALUES(11,'MPS_ENABLED','VARCHAR2','Y',19,
639: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
640: 1,SYSDATE,'Y','Y','Collect Master Production Schedules',p_version);
641:
642: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
643: NAME,
644: DATA_TYPE,
645: DEFAULT_VALUE,
646: SEQUENCE,

Line 658: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

654: VALUES(11,'ON_HAND_ENABLED','VARCHAR2','Y',20,
655: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
656: 1,SYSDATE,'Y','Y','Collect On Hand',p_version);
657:
658: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
659: NAME,
660: DATA_TYPE,
661: DEFAULT_VALUE,
662: SEQUENCE,

Line 674: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

670: VALUES(11,'PARAMETER_ENABLED','VARCHAR2','Y',21,
671: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
672: 1,SYSDATE,'Y','Y','Collect Planning Parameters',p_version);
673:
674: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
675: NAME,
676: DATA_TYPE,
677: DEFAULT_VALUE,
678: SEQUENCE,

Line 690: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

686: VALUES(11,'PLANNER_ENABLED','VARCHAR2','Y',22,
687: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
688: 1,SYSDATE,'Y','Y','Planner',p_version);
689:
690: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
691: NAME,
692: DATA_TYPE,
693: DEFAULT_VALUE,
694: SEQUENCE,

Line 706: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

702: VALUES(11,'PO_RECEIPTS_ENABLED','VARCHAR2','Y',23,
703: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
704: 1,SYSDATE,'Y','Y','Collect PO Receipts',p_version);
705:
706: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
707: NAME,
708: DATA_TYPE,
709: DEFAULT_VALUE,
710: SEQUENCE,

Line 722: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

718: VALUES(11,'PROJECT_ENABLED','VARCHAR2','Y',24,
719: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
720: 1,SYSDATE,'Y','Y','Collect Projects / Tasks',p_version);
721:
722: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
723: NAME,
724: DATA_TYPE,
725: DEFAULT_VALUE,
726: SEQUENCE,

Line 738: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

734: VALUES(11,'PUR_REQ_PO_ENABLED','VARCHAR2','Y',25,
735: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
736: 1,SYSDATE,'Y','Y','Collect Purchase Orders / Purchase Requisitions',p_version);
737:
738: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
739: NAME,
740: DATA_TYPE,
741: DEFAULT_VALUE,
742: SEQUENCE,

Line 754: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

750: VALUES(11,'RESERVES_HARD_ENABLED','VARCHAR2','Y',26,
751: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
752: 1,SYSDATE,'Y','Y','Reservations',p_version);
753:
754: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
755: NAME,
756: DATA_TYPE,
757: DEFAULT_VALUE,
758: SEQUENCE,

Line 770: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

766: VALUES(11,'RESOURCE_AVAILABILITY','VARCHAR2','COLLECT_DATA',27,
767: 'select decode(lookup_code, 1, ''COLLECT_DATA'', 2, ''DO_NOT_COLLECT_DATA'', 3, ''REGENERATE_DATA'') hidden, meaning display from MFG_LOOKUPS where lookup_type=''MSC_NRA_ENABLED''',
768: 1,SYSDATE,'Y','Y','Collect Resources Availability',p_version);
769:
770: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
771: NAME,
772: DATA_TYPE,
773: DEFAULT_VALUE,
774: SEQUENCE,

Line 786: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

782: VALUES(11,'SAFE_STOCK_ENABLED','VARCHAR2','Y',28,
783: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
784: 1,SYSDATE,'Y','Y','Collect Safety Stock',p_version);
785:
786: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
787: NAME,
788: DATA_TYPE,
789: DEFAULT_VALUE,
790: SEQUENCE,

Line 802: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

798: VALUES(11,'SALES_ORDER_RTYPE','VARCHAR2','N',29,
799: 'select decode(lookup_code, 1, ''Y'', 2, ''N'') hidden, meaning display from mfg_lookups WHERE lookup_type = ''SYS_YES_NO''',
800: 1,SYSDATE,'Y','Y','Collect Sales Orders',p_version);
801:
802: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
803: NAME,
804: DATA_TYPE,
805: DEFAULT_VALUE,
806: SEQUENCE,

Line 818: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

814: VALUES(11,'SOURCING_HISTORY_ENABLED','VARCHAR2','N',30,
815: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
816: 1,SYSDATE,'Y','Y','Collect Sourcing History',p_version);
817:
818: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
819: NAME,
820: DATA_TYPE,
821: DEFAULT_VALUE,
822: SEQUENCE,

Line 834: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

830: VALUES(11,'SOURCING_ENABLED','VARCHAR2','Y',31,
831: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
832: 1,SYSDATE,'Y','Y','Collect Sourcing Rules',p_version);
833:
834: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
835: NAME,
836: DATA_TYPE,
837: DEFAULT_VALUE,
838: SEQUENCE,

Line 850: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

846: VALUES(11,'SUB_INV_ENABLED','VARCHAR2','Y',32,
847: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
848: 1,SYSDATE,'Y','Y','Collect Subinventories',p_version);
849:
850: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
851: NAME,
852: DATA_TYPE,
853: DEFAULT_VALUE,
854: SEQUENCE,

Line 866: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

862: VALUES(11,'SUPPLIER_RESPONSE_ENABLED','VARCHAR2','Y',33,
863: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
864: 1,SYSDATE,'Y','Y','Collect Supplier Responses',p_version);
865:
866: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
867: NAME,
868: DATA_TYPE,
869: DEFAULT_VALUE,
870: SEQUENCE,

Line 882: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

878: VALUES(11,'TP_CUSTOMER_ENABLED','VARCHAR2','Y',34,
879: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
880: 1,SYSDATE,'Y','Y','Collect Suppliers/Customers/Orgs',p_version);
881:
882: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
883: NAME,
884: DATA_TYPE,
885: DEFAULT_VALUE,
886: SEQUENCE,

Line 898: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

894: VALUES(11,'TRIP_ENABLED','VARCHAR2','Y',35,
895: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
896: 1,SYSDATE,'Y','Y','Collect Transportation Details',p_version);
897:
898: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
899: NAME,
900: DATA_TYPE,
901: DEFAULT_VALUE,
902: SEQUENCE,

Line 914: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

910: VALUES(11,'UNIT_NO_ENABLED','VARCHAR2','Y',36,
911: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
912: 1,SYSDATE,'Y','Y','Collect Unit Numbers',p_version);
913:
914: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
915: NAME,
916: DATA_TYPE,
917: DEFAULT_VALUE,
918: SEQUENCE,

Line 930: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

926: VALUES(11,'UOM_ENABLED','VARCHAR2','Y',37,
927: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
928: 1,SYSDATE,'Y','Y','Collect Units Of Measure',p_version);
929:
930: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
931: NAME,
932: DATA_TYPE,
933: DEFAULT_VALUE,
934: SEQUENCE,

Line 947: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

943: 'select decode(lookup_code, 1, ''NO'', 2, ''ENABLE_UCA'', 3, ''CREATE_USERS_ENABLE_UCA'') hidden, meaning display ' ||
944: 'from fnd_lookups where lookup_type = ''MSC_X_USER_COMPANY''',
945: 1,SYSDATE,'Y','Y','Collect User company Association',p_version);
946:
947: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
948: NAME,
949: DATA_TYPE,
950: DEFAULT_VALUE,
951: SEQUENCE,

Line 963: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

959: VALUES(11,'USER_SUPPLY_DEMAND','VARCHAR2','Y',39,
960: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
961: 1,SYSDATE,'Y','Y','Collect User Supplies and Demands',p_version);
962:
963: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
964: NAME,
965: DATA_TYPE,
966: DEFAULT_VALUE,
967: SEQUENCE,

Line 979: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

975: VALUES(11,'WIP_ENABLED','VARCHAR2','Y',40,
976: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
977: 1,SYSDATE,'Y','Y','Collect Work in Process',p_version);
978:
979: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
980: NAME,
981: DATA_TYPE,
982: DEFAULT_VALUE,
983: SEQUENCE,

Line 995: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

991: VALUES(11,'SALES_CHANNEL_ENABLED','VARCHAR2','N',41,
992: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
993: 1,SYSDATE,'Y','Y','Collect Sales Channel',p_version);
994:
995: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
996: NAME,
997: DATA_TYPE,
998: DEFAULT_VALUE,
999: SEQUENCE,

Line 1011: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1007: VALUES(11,'FISCAL_CALENDAR_ENABLED','VARCHAR2','N',42,
1008: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1009: 1,SYSDATE,'Y','Y','Collect Fiscal Calendar',p_version);
1010:
1011: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1012: NAME,
1013: DATA_TYPE,
1014: DEFAULT_VALUE,
1015: SEQUENCE,

Line 1027: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1023: VALUES(11,'ITERNAL_REPAIR_ENABLED','VARCHAR2','N',43,
1024: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1025: 1,SYSDATE,'Y','Y','Collect Internal Repair Orders',p_version);
1026:
1027: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1028: NAME,
1029: DATA_TYPE,
1030: DEFAULT_VALUE,
1031: SEQUENCE,

Line 1043: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1039: VALUES(11,'ETERNAL_REPAIR_ENABLED','VARCHAR2','N',44,
1040: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1041: 1,SYSDATE,'Y','Y','Collect External Repair Orders',p_version);
1042:
1043: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1044: NAME,
1045: DATA_TYPE,
1046: DEFAULT_VALUE,
1047: SEQUENCE,

Line 1059: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1055: VALUES(11,'PAYBACK_DEMAND_SUPPLY_ENABLED','VARCHAR2','N',45,
1056: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1057: 1,SYSDATE,'Y','Y','Enable Pay Back Demand Supply',p_version);
1058:
1059: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1060: NAME,
1061: DATA_TYPE,
1062: DEFAULT_VALUE,
1063: SEQUENCE,

Line 1075: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1071: VALUES(11,'CURRENCY_CONVERSION_ENABLED','VARCHAR2','N',46,
1072: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1073: 1,SYSDATE,'Y','Y','Enable Currency Conversion',p_version);
1074:
1075: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1076: NAME,
1077: DATA_TYPE,
1078: DEFAULT_VALUE,
1079: SEQUENCE,

Line 1093: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1089: 1,SYSDATE,'Y','Y','Enable Delivery Details',p_version);
1090:
1091:
1092:
1093: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1094: NAME,
1095: DATA_TYPE,
1096: DEFAULT_VALUE,
1097: SEQUENCE,

Line 1109: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1105: VALUES(11,'ODSTOTALWORKERNUM','NUMBER','3',48,NULL,
1106: 1,SYSDATE,'Y','Y','Number of workers',p_version);
1107:
1108:
1109: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1110: NAME,
1111: DATA_TYPE,
1112: DEFAULT_VALUE,
1113: SEQUENCE,

Line 1125: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1121: VALUES(11,'RECALC_RES_AVAILABILITY','VARCHAR2','Y',49,
1122: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1123: 1,SYSDATE,'Y','Y','Recalculate Sourcing History',p_version);
1124:
1125: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1126: NAME,
1127: DATA_TYPE,
1128: DEFAULT_VALUE,
1129: SEQUENCE,

Line 1145: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1141:
1142:
1143:
1144:
1145: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1146: NAME,
1147: DATA_TYPE,
1148: DEFAULT_VALUE,
1149: SEQUENCE,

Line 1162: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1158: 'FROM MSC_APPS_INSTANCES '||
1159: 'where instance_type IN (1,2,4) and enable_flag = 1',
1160: 1,SYSDATE,'Y','Y','Instance',p_version);
1161:
1162: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1163: NAME,
1164: DATA_TYPE,
1165: DEFAULT_VALUE,
1166: SEQUENCE,

Line 1178: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1174: VALUES(10,'COLLECTION_GROUP','VARCHAR','-999',2,
1175: 'select CODE hidden, ORG_GROUP Display FROM MSD_DEM_ORG_GROUPS_V ',
1176: 1,SYSDATE,'Y','Y','Shipment and Booking History -Collection Group',p_version);
1177:
1178: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1179: NAME,
1180: DATA_TYPE,
1181: DEFAULT_VALUE,
1182: SEQUENCE,

Line 1193: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1189: PARAM_VERSION)
1190: VALUES(10,'COLLECTION_METHOD','NUMBER',NULL,3,NULL,
1191: 1,SYSDATE,'Y','Y','Shipment and Booking History -Collection Method',p_version);
1192:
1193: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1194: NAME,
1195: DATA_TYPE,
1196: DEFAULT_VALUE,
1197: SEQUENCE,

Line 1208: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1204: PARAM_VERSION)
1205: VALUES(10,'DATE_RANGE_TYPE','NUMBER',NULL,4,NULL,
1206: 1,SYSDATE,'Y','Y','Data Range Type',p_version);
1207:
1208: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1209: NAME,
1210: DATA_TYPE,
1211: DEFAULT_VALUE,
1212: SEQUENCE,

Line 1223: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1219: PARAM_VERSION)
1220: VALUES(10,'HISTORY_COLLECTION_WINDOW','NUMBER',NULL,5,NULL,
1221: 1,SYSDATE,'N','Y','Shipment and Booking History - History Collection Window',p_version);
1222:
1223: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1224: NAME,
1225: DATA_TYPE,
1226: DEFAULT_VALUE,
1227: SEQUENCE,

Line 1238: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1234: PARAM_VERSION)
1235: VALUES(10,'DATE_FROM','DATE',NULL,6,NULL,
1236: 1,SYSDATE,'N','Y','Shipment and Booking History - Date From',p_version);
1237:
1238: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1239: NAME,
1240: DATA_TYPE,
1241: DEFAULT_VALUE,
1242: SEQUENCE,

Line 1253: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1249: PARAM_VERSION)
1250: VALUES(10,'DATE_TO','DATE',NULL,7,NULL,
1251: 1,SYSDATE,'N','Y','Shipment and Booking History - Date To',p_version);
1252:
1253: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1254: NAME,
1255: DATA_TYPE,
1256: DEFAULT_VALUE,
1257: SEQUENCE,

Line 1269: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1265: VALUES(10,'BH_BOOKED_ITEMS_BOOKED_DATE','VARCHAR','N',8,
1266: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1267: 1,SYSDATE,'Y','Y','Booking History - Booked Items - Booked Date',p_version);
1268:
1269: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1270: NAME,
1271: DATA_TYPE,
1272: DEFAULT_VALUE,
1273: SEQUENCE,

Line 1285: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1281: VALUES(10,'BH_BOOKED_ITEMS_REQUESTED_DATE','VARCHAR','N',9,
1282: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1283: 1,SYSDATE,'Y','Y','Booking History - Booked Items - Requested Date',p_version);
1284:
1285: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1286: NAME,
1287: DATA_TYPE,
1288: DEFAULT_VALUE,
1289: SEQUENCE,

Line 1301: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1297: VALUES(10,'BH_REQUESTED_ITEMS_BOOKED_DATE','VARCHAR','N',10,
1298: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1299: 1,SYSDATE,'Y','Y','Booking History - Requested Items - Booked Date',p_version);
1300:
1301: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1302: NAME,
1303: DATA_TYPE,
1304: DEFAULT_VALUE,
1305: SEQUENCE,

Line 1317: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1313: VALUES(10,'BH_REQUESTED_ITEMS_REQUESTED_DATE','VARCHAR','N',11,
1314: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1315: 1,SYSDATE,'Y','Y','Booking History - Requested Items - Requested Date',p_version);
1316:
1317: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1318: NAME,
1319: DATA_TYPE,
1320: DEFAULT_VALUE,
1321: SEQUENCE,

Line 1333: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1329: VALUES(10,'SH_SHIPPED_ITEMS_SHIPPED_DATE','VARCHAR','N',12,
1330: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1331: 1,SYSDATE,'Y','Y','ShipmentHistory - Shipped Items - Shipped Date',p_version);
1332:
1333: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1334: NAME,
1335: DATA_TYPE,
1336: DEFAULT_VALUE,
1337: SEQUENCE,

Line 1349: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1345: VALUES(10,'SH_SHIPPED_ITEMS_REQUESTED_DATE','VARCHAR','N',13,
1346: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1347: 1,SYSDATE,'Y','Y','ShipmentHistory - Shipped Items - Requested Date',p_version);
1348:
1349: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1350: NAME,
1351: DATA_TYPE,
1352: DEFAULT_VALUE,
1353: SEQUENCE,

Line 1365: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1361: VALUES(10,'SH_REQUESTED_ITEMS_SHIPPED_DATE','VARCHAR','N',14,
1362: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1363: 1,SYSDATE,'Y','Y','ShipmentHistory - Requested Items - Shipped Date',p_version);
1364:
1365: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1366: NAME,
1367: DATA_TYPE,
1368: DEFAULT_VALUE,
1369: SEQUENCE,

Line 1381: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1377: VALUES(10,'SH_REQUESTED_ITEMS_REQUESTED_DATE','VARCHAR','N',15,
1378: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1379: 1,SYSDATE,'Y','Y','ShipmentHistory - Requested Items - Requested Date',p_version);
1380:
1381: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1382: NAME,
1383: DATA_TYPE,
1384: DEFAULT_VALUE,
1385: SEQUENCE,

Line 1397: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1393: VALUES(10,'COLLECT_ISO','VARCHAR','N',16,
1394: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1395: 1,SYSDATE,'Y','Y','Collect Internal Sales Orders',p_version);
1396:
1397: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1398: NAME,
1399: DATA_TYPE,
1400: DEFAULT_VALUE,
1401: SEQUENCE,

Line 1413: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1409: VALUES(10,'COLLECT_ALL_ORDER_TYPES','VARCHAR','Y',17,
1410: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1411: 1,SYSDATE,'Y','Y','Collect All Order Types',p_version);
1412:
1413: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1414: NAME,
1415: DATA_TYPE,
1416: DEFAULT_VALUE,
1417: SEQUENCE,

Line 1427: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1423: DISPLAY_NAME,
1424: PARAM_VERSION)
1425: VALUES(10,'INCLUDE_ORDER_TYPES','VARCHAR','N',18,NULL,1,SYSDATE,'N','Y','Include Order types',p_version);
1426:
1427: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1428: NAME,
1429: DATA_TYPE,
1430: DEFAULT_VALUE,
1431: SEQUENCE,

Line 1442: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1438: PARAM_VERSION)
1439: VALUES(10,'EXCLUDE_ORDER_TYPES','VARCHAR','N',19,NULL,1,SYSDATE,'N','Y','Exclude Order types',p_version);
1440:
1441:
1442: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1443: NAME,
1444: DATA_TYPE,
1445: DEFAULT_VALUE,
1446: SEQUENCE,

Line 1459: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1455: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1456: 1,SYSDATE,'Y','Y','Launch Download',p_version);
1457:
1458:
1459: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1460: NAME,
1461: DATA_TYPE,
1462: DEFAULT_VALUE,
1463: SEQUENCE,

Line 1474: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1470: PARAM_VERSION)
1471: VALUES(10,'DATE_FROM3','DATE',NULL,21,NULL,
1472: 1,SYSDATE,'N','Y','Currency Conversions - Date From',p_version);
1473:
1474: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1475: NAME,
1476: DATA_TYPE,
1477: DEFAULT_VALUE,
1478: SEQUENCE,

Line 1489: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1485: PARAM_VERSION)
1486: VALUES(10,'DATE_TO3','DATE',NULL,22,NULL,
1487: 1,SYSDATE,'N','Y','Currency Conversions - Date To',p_version);
1488:
1489: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1490: NAME,
1491: DATA_TYPE,
1492: DEFAULT_VALUE,
1493: SEQUENCE,

Line 1505: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1501: VALUES(10,'COLLECT_ALL_CURRENCIES','VARCHAR','N',23,
1502: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1503: 1,SYSDATE,'Y','Y','Collect All Currency Conversions',p_version);
1504:
1505: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1506: NAME,
1507: DATA_TYPE,
1508: DEFAULT_VALUE,
1509: SEQUENCE,

Line 1520: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1516: PARAM_VERSION)
1517: VALUES(10,'INCLUDE_CURRENCY_LIST','VARCHAR',NULL,24,NULL,
1518: 1,SYSDATE,'N','Y','Include Currency List',p_version);
1519:
1520: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1521: NAME,
1522: DATA_TYPE,
1523: DEFAULT_VALUE,
1524: SEQUENCE,

Line 1535: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1531: PARAM_VERSION)
1532: VALUES(10,'EXCLUDE_CURRENCY_LIST','VARCHAR',NULL,25,NULL,
1533: 1,SYSDATE,'N','Y','Exclude Currency List',p_version);
1534:
1535: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1536: NAME,
1537: DATA_TYPE,
1538: DEFAULT_VALUE,
1539: SEQUENCE,

Line 1551: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1547: VALUES(10,'INCLUDE_ALL','VARCHAR','N',26,
1548: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1549: 1,SYSDATE,'Y','Y','Collect All Unit of Measures',p_version);
1550:
1551: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1552: NAME,
1553: DATA_TYPE,
1554: DEFAULT_VALUE,
1555: SEQUENCE,

Line 1566: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1562: PARAM_VERSION)
1563: VALUES(10,'INCLUDE_UOM_LIST','VARCHAR',NULL,27,NULL,
1564: 1,SYSDATE,'N','Y','Include Unit of Measures',p_version);
1565:
1566: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1567: NAME,
1568: DATA_TYPE,
1569: DEFAULT_VALUE,
1570: SEQUENCE,

Line 1581: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1577: PARAM_VERSION)
1578: VALUES(10,'EXCLUDE_UOM_LIST','VARCHAR',NULL,28,NULL,
1579: 1,SYSDATE,'N','Y','Exclude Unit of Measures',p_version);
1580:
1581: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1582: NAME,
1583: DATA_TYPE,
1584: DEFAULT_VALUE,
1585: SEQUENCE,

Line 1596: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1592: PARAM_VERSION)
1593: VALUES(10,'START_DATE','DATE',NULL,29,NULL,
1594: 1,SYSDATE,'Y','Y','Pricing Data - Date From',p_version);
1595:
1596: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1597: NAME,
1598: DATA_TYPE,
1599: DEFAULT_VALUE,
1600: SEQUENCE,

Line 1611: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1607: PARAM_VERSION)
1608: VALUES(10,'END_DATE','DATE',NULL,30,NULL,
1609: 1,SYSDATE,'Y','Y','Pricing Data - Date To',p_version);
1610:
1611: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1612: NAME,
1613: DATA_TYPE,
1614: DEFAULT_VALUE,
1615: SEQUENCE,

Line 1628: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1624: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1625: 1,SYSDATE,'Y','Y','Collect all Price Lists',p_version);
1626:
1627:
1628: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1629: NAME,
1630: DATA_TYPE,
1631: DEFAULT_VALUE,
1632: SEQUENCE,

Line 1643: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1639: PARAM_VERSION)
1640: VALUES(10,'INCLUDE_PRICE_LIST','VARCHAR',NULL,32,NULL,
1641: 1,SYSDATE,'N','Y','Include Price Lists',p_version);
1642:
1643: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1644: NAME,
1645: DATA_TYPE,
1646: DEFAULT_VALUE,
1647: SEQUENCE,

Line 1658: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1654: PARAM_VERSION)
1655: VALUES(10,'EXCLUDE_PRICE_LIST','VARCHAR',NULL,33,NULL,
1656: 1,SYSDATE,'N','Y','Exclude Price Lists',p_version);
1657:
1658: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1659: NAME,
1660: DATA_TYPE,
1661: DEFAULT_VALUE,
1662: SEQUENCE,

Line 1674: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1670: VALUES(10,'COLLECTION_GROUP1','VARCHAR','-999',34,
1671: 'select CODE hidden, ORG_GROUP Display FROM MSD_DEM_ORG_GROUPS_V ',
1672: 1,SYSDATE,'Y','Y','Supply Chain Intelligence Data - Collection Group',p_version);
1673:
1674: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1675: NAME,
1676: DATA_TYPE,
1677: DEFAULT_VALUE,
1678: SEQUENCE,

Line 1689: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1685: PARAM_VERSION)
1686: VALUES(10,'COLLECTION_METHOD1','NUMBER',NULL,35,NULL,
1687: 1,SYSDATE,'Y','Y','Supply Chain Intelligence Data - Collection Method',p_version);
1688:
1689: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1690: NAME,
1691: DATA_TYPE,
1692: DEFAULT_VALUE,
1693: SEQUENCE,

Line 1705: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1701: VALUES(10,'DATE_RANGE_TYPE1','NUMBER',NULL,36,NULL,
1702: 1,SYSDATE,'Y','Y','Data Range Type',p_version);
1703:
1704:
1705: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1706: NAME,
1707: DATA_TYPE,
1708: DEFAULT_VALUE,
1709: SEQUENCE,

Line 1722: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1718: 1,SYSDATE,'N','Y','Supply Chain Intelligence Data - History Collection Window',p_version);
1719:
1720:
1721:
1722: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1723: NAME,
1724: DATA_TYPE,
1725: DEFAULT_VALUE,
1726: SEQUENCE,

Line 1738: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1734: VALUES(10,'DATE_FROM1','DATE',NULL,38,NULL,
1735: 1,SYSDATE,'N','Y','Supply Chain Intelligence Data - Date From',p_version);
1736:
1737:
1738: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1739: NAME,
1740: DATA_TYPE,
1741: DEFAULT_VALUE,
1742: SEQUENCE,

Line 1754: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1750: VALUES(10,'DATE_TO1','DATE',NULL,39,NULL,
1751: 1,SYSDATE,'N','Y','Shipment and Booking History - Date To',p_version);
1752:
1753:
1754: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1755: NAME,
1756: DATA_TYPE,
1757: DEFAULT_VALUE,
1758: SEQUENCE,

Line 1769: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1765: PARAM_VERSION)
1766: VALUES(13,'NEW_PLAN_NAME','VARCHAR2',NULL,1,NULL,
1767: 1,SYSDATE,'Y','Y','New Plan Name',p_version);
1768:
1769: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1770: NAME,
1771: DATA_TYPE,
1772: DEFAULT_VALUE,
1773: SEQUENCE,

Line 1788: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1784: 'WHERE tl.id = tq.transfer_id AND tq.integration_type <> 1 AND tq.export_type = 1 '||
1785: 'AND tq.presentation_type = 1 AND msd_dem_upload_forecast.is_valid_scenario(tq.id) = 1 ',
1786: 1,SYSDATE,'Y','Y','Data Profile name of the Forecast',p_version);
1787:
1788: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1789: NAME,
1790: DATA_TYPE,
1791: DEFAULT_VALUE,
1792: SEQUENCE,

Line 1804: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1800: VALUES(13,'ARCHIVE_FLAG','NUMBER',2,3,
1801: 'select lookup_code hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1802: 1,sysdate,'Y','Y','Archive Forecast',p_version);
1803:
1804: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1805: NAME,
1806: DATA_TYPE,
1807: DEFAULT_VALUE,
1808: SEQUENCE,

Line 1819: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1815: PARAM_VERSION)
1816: VALUES(19,'NEW_PLAN_NAME','VARCHAR2',NULL,1,NULL,
1817: 1,SYSDATE,'Y','Y','New Plan Name',p_version);
1818:
1819: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1820: NAME,
1821: DATA_TYPE,
1822: DEFAULT_VALUE,
1823: SEQUENCE,

Line 1838: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1834: 'WHERE tl.id = tq.transfer_id AND tq.integration_type <> 1 AND tq.export_type = 1 '||
1835: 'AND tq.presentation_type = 1 AND msd_dem_upload_forecast.is_valid_scenario(tq.id) = 1 ',
1836: 1,SYSDATE,'Y','Y','Data Profile name of the Forecast',p_version);
1837:
1838: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1839: NAME,
1840: DATA_TYPE,
1841: DEFAULT_VALUE,
1842: SEQUENCE,

Line 2350: from msc_activity_parameters

2346: procedure populate_act_params_for_lov(p_activity_type in number) is
2347:
2348: cursor c_activity_params is
2349: select name,sql
2350: from msc_activity_parameters
2351: where activity_type = p_activity_type and sql is not null;
2352:
2353: l_count number :=0;
2354: l_param_name varchar2(80);

Line 2773: SELECT sequence,sql,default_value from msc_activity_parameters

2769:
2770: procedure populate_default_params(p_activity_type IN OUT NOCOPY number,param_default IN OUT NOCOPY varchar2) is
2771:
2772: cursor c_activity_params is
2773: SELECT sequence,sql,default_value from msc_activity_parameters
2774: where activity_type = p_activity_type and sql is not null and
2775: default_value is not null;
2776:
2777: l_param_sequence NUMBER;