APPS.MSD_SEED dependencies on MSD_LEVELS

Line 7: insert into msd_levels (

3:
4: PROCEDURE insert_levels IS
5: begin
6:
7: insert into msd_levels (
8: LEVEL_ID,
9: LEVEL_NAME,
10: DESCRIPTION,
11: DIMENSION_CODE,

Line 31: from msd_levels

27: 1
28: FROM dual
29: where not exists (
30: select 1
31: from msd_levels
32: where level_id = 1);
33:
34:
35: insert into msd_levels (

Line 35: insert into msd_levels (

31: from msd_levels
32: where level_id = 1);
33:
34:
35: insert into msd_levels (
36: LEVEL_ID,
37: LEVEL_NAME,
38: DESCRIPTION,
39: DIMENSION_CODE,

Line 59: from msd_levels

55: 1
56: FROM dual
57: where not exists (
58: select 1
59: from msd_levels
60: where level_id = 2);
61:
62:
63: insert into msd_levels (

Line 63: insert into msd_levels (

59: from msd_levels
60: where level_id = 2);
61:
62:
63: insert into msd_levels (
64: LEVEL_ID,
65: LEVEL_NAME,
66: DESCRIPTION,
67: DIMENSION_CODE,

Line 87: from msd_levels

83: 1
84: FROM dual
85: where not exists (
86: select 1
87: from msd_levels
88: where level_id = 3);
89:
90: insert into msd_levels (
91: LEVEL_ID,

Line 90: insert into msd_levels (

86: select 1
87: from msd_levels
88: where level_id = 3);
89:
90: insert into msd_levels (
91: LEVEL_ID,
92: LEVEL_NAME,
93: DESCRIPTION,
94: DIMENSION_CODE,

Line 114: from msd_levels

110: 1
111: FROM dual
112: where not exists (
113: select 1
114: from msd_levels
115: where level_id = 7);
116:
117:
118: insert into msd_levels (

Line 118: insert into msd_levels (

114: from msd_levels
115: where level_id = 7);
116:
117:
118: insert into msd_levels (
119: LEVEL_ID,
120: LEVEL_NAME,
121: DESCRIPTION,
122: DIMENSION_CODE,

Line 142: from msd_levels

138: 1
139: FROM dual
140: where not exists (
141: select 1
142: from msd_levels
143: where level_id = 8);
144:
145:
146: insert into msd_levels (

Line 146: insert into msd_levels (

142: from msd_levels
143: where level_id = 8);
144:
145:
146: insert into msd_levels (
147: LEVEL_ID,
148: LEVEL_NAME,
149: DESCRIPTION,
150: DIMENSION_CODE,

Line 170: from msd_levels

166: 1
167: FROM dual
168: where not exists (
169: select 1
170: from msd_levels
171: where level_id = 9);
172:
173:
174: insert into msd_levels (

Line 174: insert into msd_levels (

170: from msd_levels
171: where level_id = 9);
172:
173:
174: insert into msd_levels (
175: LEVEL_ID,
176: LEVEL_NAME,
177: DESCRIPTION,
178: DIMENSION_CODE,

Line 198: from msd_levels

194: 1
195: FROM dual
196: where not exists (
197: select 1
198: from msd_levels
199: where level_id = 10);
200:
201:
202: insert into msd_levels (

Line 202: insert into msd_levels (

198: from msd_levels
199: where level_id = 10);
200:
201:
202: insert into msd_levels (
203: LEVEL_ID,
204: LEVEL_NAME,
205: DESCRIPTION,
206: DIMENSION_CODE,

Line 226: from msd_levels

222: 1
223: FROM dual
224: where not exists (
225: select 1
226: from msd_levels
227: where level_id = 11);
228:
229:
230: insert into msd_levels (

Line 230: insert into msd_levels (

226: from msd_levels
227: where level_id = 11);
228:
229:
230: insert into msd_levels (
231: LEVEL_ID,
232: LEVEL_NAME,
233: DESCRIPTION,
234: DIMENSION_CODE,

Line 254: from msd_levels

250: 1
251: FROM dual
252: where not exists (
253: select 1
254: from msd_levels
255: where level_id = 12);
256:
257:
258: insert into msd_levels (

Line 258: insert into msd_levels (

254: from msd_levels
255: where level_id = 12);
256:
257:
258: insert into msd_levels (
259: LEVEL_ID,
260: LEVEL_NAME,
261: DESCRIPTION,
262: DIMENSION_CODE,

Line 282: from msd_levels

278: 1
279: FROM dual
280: where not exists (
281: select 1
282: from msd_levels
283: where level_id = 13);
284:
285:
286: insert into msd_levels (

Line 286: insert into msd_levels (

282: from msd_levels
283: where level_id = 13);
284:
285:
286: insert into msd_levels (
287: LEVEL_ID,
288: LEVEL_NAME,
289: DESCRIPTION,
290: DIMENSION_CODE,

Line 310: from msd_levels

306: 1
307: FROM dual
308: where not exists (
309: select 1
310: from msd_levels
311: where level_id = 14);
312:
313:
314: insert into msd_levels (

Line 314: insert into msd_levels (

310: from msd_levels
311: where level_id = 14);
312:
313:
314: insert into msd_levels (
315: LEVEL_ID,
316: LEVEL_NAME,
317: DESCRIPTION,
318: DIMENSION_CODE,

Line 338: from msd_levels

334: 1
335: FROM dual
336: where not exists (
337: select 1
338: from msd_levels
339: where level_id = 15);
340:
341:
342: insert into msd_levels (

Line 342: insert into msd_levels (

338: from msd_levels
339: where level_id = 15);
340:
341:
342: insert into msd_levels (
343: LEVEL_ID,
344: LEVEL_NAME,
345: DESCRIPTION,
346: DIMENSION_CODE,

Line 366: from msd_levels

362: 1
363: FROM dual
364: where not exists (
365: select 1
366: from msd_levels
367: where level_id = 16);
368:
369:
370: insert into msd_levels (

Line 370: insert into msd_levels (

366: from msd_levels
367: where level_id = 16);
368:
369:
370: insert into msd_levels (
371: LEVEL_ID,
372: LEVEL_NAME,
373: DESCRIPTION,
374: DIMENSION_CODE,

Line 394: from msd_levels

390: 1
391: FROM dual
392: where not exists (
393: select 1
394: from msd_levels
395: where level_id = 17);
396:
397:
398: insert into msd_levels (

Line 398: insert into msd_levels (

394: from msd_levels
395: where level_id = 17);
396:
397:
398: insert into msd_levels (
399: LEVEL_ID,
400: LEVEL_NAME,
401: DESCRIPTION,
402: DIMENSION_CODE,

Line 422: from msd_levels

418: 1
419: FROM dual
420: where not exists (
421: select 1
422: from msd_levels
423: where level_id = 18);
424:
425:
426: insert into msd_levels (

Line 426: insert into msd_levels (

422: from msd_levels
423: where level_id = 18);
424:
425:
426: insert into msd_levels (
427: LEVEL_ID,
428: LEVEL_NAME,
429: DESCRIPTION,
430: DIMENSION_CODE,

Line 450: from msd_levels

446: 1
447: FROM dual
448: where not exists (
449: select 1
450: from msd_levels
451: where level_id = 19);
452:
453:
454: insert into msd_levels (

Line 454: insert into msd_levels (

450: from msd_levels
451: where level_id = 19);
452:
453:
454: insert into msd_levels (
455: LEVEL_ID,
456: LEVEL_NAME,
457: DESCRIPTION,
458: DIMENSION_CODE,

Line 478: from msd_levels

474: 1
475: FROM dual
476: where not exists (
477: select 1
478: from msd_levels
479: where level_id = 20);
480:
481:
482: insert into msd_levels (

Line 482: insert into msd_levels (

478: from msd_levels
479: where level_id = 20);
480:
481:
482: insert into msd_levels (
483: LEVEL_ID,
484: LEVEL_NAME,
485: DESCRIPTION,
486: DIMENSION_CODE,

Line 506: from msd_levels

502: 1
503: FROM dual
504: where not exists (
505: select 1
506: from msd_levels
507: where level_id = 21);
508:
509:
510: insert into msd_levels (

Line 510: insert into msd_levels (

506: from msd_levels
507: where level_id = 21);
508:
509:
510: insert into msd_levels (
511: LEVEL_ID,
512: LEVEL_NAME,
513: DESCRIPTION,
514: DIMENSION_CODE,

Line 534: from msd_levels

530: 1
531: FROM dual
532: where not exists (
533: select 1
534: from msd_levels
535: where level_id = 22);
536:
537:
538: insert into msd_levels (

Line 538: insert into msd_levels (

534: from msd_levels
535: where level_id = 22);
536:
537:
538: insert into msd_levels (
539: LEVEL_ID,
540: LEVEL_NAME,
541: DESCRIPTION,
542: DIMENSION_CODE,

Line 562: from msd_levels

558: 1
559: FROM dual
560: where not exists (
561: select 1
562: from msd_levels
563: where level_id = 23);
564:
565:
566: insert into msd_levels (

Line 566: insert into msd_levels (

562: from msd_levels
563: where level_id = 23);
564:
565:
566: insert into msd_levels (
567: LEVEL_ID,
568: LEVEL_NAME,
569: DESCRIPTION,
570: DIMENSION_CODE,

Line 590: from msd_levels

586: 1
587: FROM dual
588: where not exists (
589: select 1
590: from msd_levels
591: where level_id = 24);
592:
593:
594: insert into msd_levels (

Line 594: insert into msd_levels (

590: from msd_levels
591: where level_id = 24);
592:
593:
594: insert into msd_levels (
595: LEVEL_ID,
596: LEVEL_NAME,
597: DESCRIPTION,
598: DIMENSION_CODE,

Line 618: from msd_levels

614: 1
615: FROM dual
616: where not exists (
617: select 1
618: from msd_levels
619: where level_id = 25);
620:
621:
622: insert into msd_levels (

Line 622: insert into msd_levels (

618: from msd_levels
619: where level_id = 25);
620:
621:
622: insert into msd_levels (
623: LEVEL_ID,
624: LEVEL_NAME,
625: DESCRIPTION,
626: DIMENSION_CODE,

Line 646: from msd_levels

642: 1
643: FROM dual
644: where not exists (
645: select 1
646: from msd_levels
647: where level_id = 26);
648:
649:
650: insert into msd_levels (

Line 650: insert into msd_levels (

646: from msd_levels
647: where level_id = 26);
648:
649:
650: insert into msd_levels (
651: LEVEL_ID,
652: LEVEL_NAME,
653: DESCRIPTION,
654: DIMENSION_CODE,

Line 674: from msd_levels

670: 1
671: FROM dual
672: where not exists (
673: select 1
674: from msd_levels
675: where level_id = 27);
676:
677:
678: insert into msd_levels (

Line 678: insert into msd_levels (

674: from msd_levels
675: where level_id = 27);
676:
677:
678: insert into msd_levels (
679: LEVEL_ID,
680: LEVEL_NAME,
681: DESCRIPTION,
682: DIMENSION_CODE,

Line 702: from msd_levels

698: 1
699: FROM dual
700: where not exists (
701: select 1
702: from msd_levels
703: where level_id = 28);
704:
705:
706: insert into msd_levels (

Line 706: insert into msd_levels (

702: from msd_levels
703: where level_id = 28);
704:
705:
706: insert into msd_levels (
707: LEVEL_ID,
708: LEVEL_NAME,
709: DESCRIPTION,
710: DIMENSION_CODE,

Line 730: from msd_levels

726: 1
727: FROM dual
728: where not exists (
729: select 1
730: from msd_levels
731: where level_id = 29);
732:
733:
734: insert into msd_levels (

Line 734: insert into msd_levels (

730: from msd_levels
731: where level_id = 29);
732:
733:
734: insert into msd_levels (
735: LEVEL_ID,
736: LEVEL_NAME,
737: DESCRIPTION,
738: DIMENSION_CODE,

Line 758: from msd_levels

754: 1
755: FROM dual
756: where not exists (
757: select 1
758: from msd_levels
759: where level_id = 30);
760:
761:
762: insert into msd_levels (

Line 762: insert into msd_levels (

758: from msd_levels
759: where level_id = 30);
760:
761:
762: insert into msd_levels (
763: LEVEL_ID,
764: LEVEL_NAME,
765: DESCRIPTION,
766: DIMENSION_CODE,

Line 786: from msd_levels

782: 1
783: FROM dual
784: where not exists (
785: select 1
786: from msd_levels
787: where level_id = 32);
788:
789:
790: insert into msd_levels (

Line 790: insert into msd_levels (

786: from msd_levels
787: where level_id = 32);
788:
789:
790: insert into msd_levels (
791: LEVEL_ID,
792: LEVEL_NAME,
793: DESCRIPTION,
794: DIMENSION_CODE,

Line 814: from msd_levels

810: 1
811: FROM dual
812: where not exists (
813: select 1
814: from msd_levels
815: where level_id = 33);
816:
817: commit;
818: end;