APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_ST_LEVEL_VALUES

Line 995: from msd_st_level_values a

991:
992: Cursor c_Update_Level_Values
993: is
994: select level_id, sr_level_pk,system_attribute1,system_attribute2,dp_enabled_flag
995: from msd_st_level_values a
996: where a.instance = p_instance_id
997: and rowid = ( select max(rowid)
998: from msd_st_level_values b
999: where a.instance = b.instance

Line 998: from msd_st_level_values b

994: select level_id, sr_level_pk,system_attribute1,system_attribute2,dp_enabled_flag
995: from msd_st_level_values a
996: where a.instance = p_instance_id
997: and rowid = ( select max(rowid)
998: from msd_st_level_values b
999: where a.instance = b.instance
1000: and a.level_id = b.level_id
1001: and a.sr_level_pk = b.sr_level_pk
1002: and b.system_attribute1 is not null); -- assuming here that if there exist more than one record

Line 1044: update msd_st_level_values

1040:
1041: if c_Update_Level_Values%ROWCOUNT > 0 then
1042:
1043: FORALL j IN lb_level_id.FIRST..lb_level_id.LAST
1044: update msd_st_level_values
1045: set system_attribute1 = lb_system_attribute1(j),
1046: system_attribute2 = lb_system_attribute2(j),
1047: dp_enabled_flag = lb_dp_enabled_flag(j)
1048: where instance = p_instance_id

Line 1069: delete from msd_st_level_values a where

1065: Key - Instance + Level_Id + SR_LEVEL_PK
1066: */
1067:
1068: if p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE then
1069: delete from msd_st_level_values a where
1070: a.instance = p_instance_id and
1071: rowid <> (select max(rowid) from msd_st_level_values b
1072: where a.instance = b.instance
1073: and a.level_id = b.level_id

Line 1071: rowid <> (select max(rowid) from msd_st_level_values b

1067:
1068: if p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE then
1069: delete from msd_st_level_values a where
1070: a.instance = p_instance_id and
1071: rowid <> (select max(rowid) from msd_st_level_values b
1072: where a.instance = b.instance
1073: and a.level_id = b.level_id
1074: and a.sr_level_pk = b.sr_level_pk);
1075: end if;

Line 1147: from msd_st_level_values a, msd_levels b

1143:
1144: /* Cursor for staging table */
1145: CURSOR c_st_level is
1146: select distinct a.instance, a.level_id
1147: from msd_st_level_values a, msd_levels b
1148: where a.level_id = b.level_id and
1149: a.instance <> 0 and
1150: b.level_type_code = 3 and
1151: a.instance = p_instance;

Line 1213: Navigate level_value from either (msd_st_level_values or msd_level_values).

1209: Procedure Delete_Childless_Parent
1210:
1211: This procedure will delete any childless parent level value.
1212: First, We will determine whether destination talbe is Fact or Staging, then
1213: Navigate level_value from either (msd_st_level_values or msd_level_values).
1214: Check whether that level_id exist in level association table as
1215: parent level id.
1216: If it does, then navigate next level id, otherwise, delete it.
1217:

Line 1247: from msd_st_level_values

1243: */
1244:
1245: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )
1246: select '-999' , level_id, sr_level_pk, -999
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

Line 1254: delete from msd_st_level_values a

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
1256: instance = p_instance_id and
1257: level_id = p_level_id and
1258: exists (select 1 from msd_backup_level_values b