APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_ST_LEVEL_ASSOCIATIONS

Line 1085: from msd_st_level_associations

1081: p_instance_id in number) is
1082:
1083: cursor c_duplicate is
1084: select level_id, sr_level_pk, parent_level_id
1085: from msd_st_level_associations
1086: where instance = p_instance_id
1087: group by level_id, sr_level_pk, parent_level_id
1088: having count(*) > 1;
1089:

Line 1090: TYPE level_id_tab is table of msd_st_level_associations.level_id%TYPE;

1086: where instance = p_instance_id
1087: group by level_id, sr_level_pk, parent_level_id
1088: having count(*) > 1;
1089:
1090: TYPE level_id_tab is table of msd_st_level_associations.level_id%TYPE;
1091: TYPE sr_level_pk_tab IS TABLE OF msd_st_level_associations.sr_level_pk%TYPE;
1092:
1093: a_child_level_id level_id_tab;
1094: a_parent_level_id level_id_tab;

Line 1091: TYPE sr_level_pk_tab IS TABLE OF msd_st_level_associations.sr_level_pk%TYPE;

1087: group by level_id, sr_level_pk, parent_level_id
1088: having count(*) > 1;
1089:
1090: TYPE level_id_tab is table of msd_st_level_associations.level_id%TYPE;
1091: TYPE sr_level_pk_tab IS TABLE OF msd_st_level_associations.sr_level_pk%TYPE;
1092:
1093: a_child_level_id level_id_tab;
1094: a_parent_level_id level_id_tab;
1095: a_sr_level_pk sr_level_pk_tab;

Line 1110: delete from msd_st_level_associations a where

1106: CLOSE c_duplicate;
1107:
1108: IF (a_child_level_id.exists(1)) THEN
1109: FOR i IN a_child_level_id.FIRST..a_child_level_id.LAST LOOP
1110: delete from msd_st_level_associations a where
1111: a.instance = p_instance_id and
1112: a.level_id = a_child_level_id(i) and
1113: a.sr_level_pk = a_sr_level_pk(i) and
1114: a.parent_level_id = a_parent_level_id(i) and

Line 1115: rowid <> (select rowid from msd_st_level_associations b

1111: a.instance = p_instance_id and
1112: a.level_id = a_child_level_id(i) and
1113: a.sr_level_pk = a_sr_level_pk(i) and
1114: a.parent_level_id = a_parent_level_id(i) and
1115: rowid <> (select rowid from msd_st_level_associations b
1116: where b.instance = p_instance_id and
1117: b.level_id = a_child_level_id(i) and
1118: b.sr_level_pk = a_sr_level_pk(i) and
1119: b.parent_level_id = a_parent_level_id(i) and

Line 1251: from msd_st_level_associations

1247: from msd_st_level_values
1248: where instance = p_instance_id and level_id = p_level_id
1249: minus
1250: select '-999' , parent_level_id, sr_parent_level_pk, -999
1251: from msd_st_level_associations
1252: where instance = p_instance_id and parent_level_id = p_level_id ;
1253:
1254: delete from msd_st_level_values a
1255: where

Line 1262: delete from msd_st_level_associations st_a

1258: exists (select 1 from msd_backup_level_values b
1259: where b.instance = '-999' and b.level_id = a.level_id and
1260: b.sr_level_pk = a.sr_level_pk and level_pk = -999);
1261:
1262: delete from msd_st_level_associations st_a
1263: where
1264: instance = p_instance_id and
1265: level_id = p_level_id and
1266: exists (select 1 from msd_backup_level_values st_b