APPS.MSD_SEED dependencies on MSD_HIERARCHIES

Line 823: insert into msd_hierarchies(

819:
820: PROCEDURE insert_hierarchies IS
821: begin
822:
823: insert into msd_hierarchies(
824: HIERARCHY_ID,
825: HIERARCHY_NAME,
826: DESCRIPTION,
827: DIMENSION_CODE,

Line 847: from msd_hierarchies

843: 1
844: FROM dual
845: where not exists (
846: select 1
847: from msd_hierarchies
848: where hierarchy_id = 1);
849:
850:
851: insert into msd_hierarchies(

Line 851: insert into msd_hierarchies(

847: from msd_hierarchies
848: where hierarchy_id = 1);
849:
850:
851: insert into msd_hierarchies(
852: HIERARCHY_ID,
853: HIERARCHY_NAME,
854: DESCRIPTION,
855: DIMENSION_CODE,

Line 875: from msd_hierarchies

871: 1
872: FROM dual
873: where not exists (
874: select 1
875: from msd_hierarchies
876: where hierarchy_id = 2);
877:
878:
879: insert into msd_hierarchies(

Line 879: insert into msd_hierarchies(

875: from msd_hierarchies
876: where hierarchy_id = 2);
877:
878:
879: insert into msd_hierarchies(
880: HIERARCHY_ID,
881: HIERARCHY_NAME,
882: DESCRIPTION,
883: DIMENSION_CODE,

Line 903: from msd_hierarchies

899: 1
900: FROM dual
901: where not exists (
902: select 1
903: from msd_hierarchies
904: where hierarchy_id = 4);
905:
906:
907: insert into msd_hierarchies(

Line 907: insert into msd_hierarchies(

903: from msd_hierarchies
904: where hierarchy_id = 4);
905:
906:
907: insert into msd_hierarchies(
908: HIERARCHY_ID,
909: HIERARCHY_NAME,
910: DESCRIPTION,
911: DIMENSION_CODE,

Line 931: from msd_hierarchies

927: 1
928: FROM dual
929: where not exists (
930: select 1
931: from msd_hierarchies
932: where hierarchy_id = 5);
933:
934:
935: insert into msd_hierarchies(

Line 935: insert into msd_hierarchies(

931: from msd_hierarchies
932: where hierarchy_id = 5);
933:
934:
935: insert into msd_hierarchies(
936: HIERARCHY_ID,
937: HIERARCHY_NAME,
938: DESCRIPTION,
939: DIMENSION_CODE,

Line 959: from msd_hierarchies

955: 1
956: FROM dual
957: where not exists (
958: select 1
959: from msd_hierarchies
960: where hierarchy_id = 6);
961:
962:
963: insert into msd_hierarchies(

Line 963: insert into msd_hierarchies(

959: from msd_hierarchies
960: where hierarchy_id = 6);
961:
962:
963: insert into msd_hierarchies(
964: HIERARCHY_ID,
965: HIERARCHY_NAME,
966: DESCRIPTION,
967: DIMENSION_CODE,

Line 987: from msd_hierarchies

983: 1
984: FROM dual
985: where not exists (
986: select 1
987: from msd_hierarchies
988: where hierarchy_id = 7);
989:
990:
991: insert into msd_hierarchies(

Line 991: insert into msd_hierarchies(

987: from msd_hierarchies
988: where hierarchy_id = 7);
989:
990:
991: insert into msd_hierarchies(
992: HIERARCHY_ID,
993: HIERARCHY_NAME,
994: DESCRIPTION,
995: DIMENSION_CODE,

Line 1015: from msd_hierarchies

1011: 1
1012: FROM dual
1013: where not exists (
1014: select 1
1015: from msd_hierarchies
1016: where hierarchy_id = 8);
1017:
1018:
1019: insert into msd_hierarchies(

Line 1019: insert into msd_hierarchies(

1015: from msd_hierarchies
1016: where hierarchy_id = 8);
1017:
1018:
1019: insert into msd_hierarchies(
1020: HIERARCHY_ID,
1021: HIERARCHY_NAME,
1022: DESCRIPTION,
1023: DIMENSION_CODE,

Line 1043: from msd_hierarchies

1039: 1
1040: FROM dual
1041: where not exists (
1042: select 1
1043: from msd_hierarchies
1044: where hierarchy_id = 9);
1045:
1046:
1047: insert into msd_hierarchies(

Line 1047: insert into msd_hierarchies(

1043: from msd_hierarchies
1044: where hierarchy_id = 9);
1045:
1046:
1047: insert into msd_hierarchies(
1048: HIERARCHY_ID,
1049: HIERARCHY_NAME,
1050: DESCRIPTION,
1051: DIMENSION_CODE,

Line 1071: from msd_hierarchies

1067: 1
1068: FROM dual
1069: where not exists (
1070: select 1
1071: from msd_hierarchies
1072: where hierarchy_id = 10);
1073:
1074: commit;
1075: