DBA Data[Home] [Help]

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 1194: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1190: VALUES(10,'COLLECTION_METHOD','NUMBER',NULL,3,
1191: 'select lookup_code,meaning from fnd_lookup_values_vl flv WHERE flv.lookup_type = ''MSD_DEM_COLL_METHODS''',
1192: 1,SYSDATE,'Y','Y','Shipment and Booking History -Collection Method',p_version);
1193:
1194: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1195: NAME,
1196: DATA_TYPE,
1197: DEFAULT_VALUE,
1198: SEQUENCE,

Line 1210: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1206: VALUES(10,'DATE_RANGE_TYPE','NUMBER',NULL,4,
1207: ' select lookup_code,meaning from fnd_lookup_values_vl where lookup_type = ''MSD_DEM_DATE_RANGE_TYPES''',
1208: 1,SYSDATE,'Y','Y','Date Range Type',p_version);
1209:
1210: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1211: NAME,
1212: DATA_TYPE,
1213: DEFAULT_VALUE,
1214: SEQUENCE,

Line 1225: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1240: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1255: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1271: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1287: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1303: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1319: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1335: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1351: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1367: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1383: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1399: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1415: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1429: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1444: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1461: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1476: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1491: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1507: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1522: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1537: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1553: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1568: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1583: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1598: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1613: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1630: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1645: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1660: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1676: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1692: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1688: VALUES(10,'COLLECTION_METHOD1','NUMBER',NULL,35,
1689: 'select lookup_code,meaning from fnd_lookup_values_vl flv WHERE flv.lookup_type = ''MSD_DEM_COLL_METHODS''',
1690: 1,SYSDATE,'Y','Y','Supply Chain Intelligence Data - Collection Method',p_version);
1691:
1692: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1693: NAME,
1694: DATA_TYPE,
1695: DEFAULT_VALUE,
1696: SEQUENCE,

Line 1709: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

1705: 'select lookup_code,meaning from fnd_lookup_values_vl where lookup_type = ''MSD_DEM_DATE_RANGE_TYPES''',
1706: 1,SYSDATE,'Y','Y','Date Range Type',p_version);
1707:
1708:
1709: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1710: NAME,
1711: DATA_TYPE,
1712: DEFAULT_VALUE,
1713: SEQUENCE,

Line 1726: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1742: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1758: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1773: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1792: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1808: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1823: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 1842: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

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

Line 2353: from msc_activity_parameters

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

Line 2776: SELECT sequence,sql,default_value from msc_activity_parameters

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