APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_ST_LEVEL_VALUES

Line 912: from msd_st_level_values a

908:
909: Cursor c_Update_Level_Values
910: is
911: select level_id, sr_level_pk,system_attribute1,system_attribute2,dp_enabled_flag
912: from msd_st_level_values a
913: where a.instance = p_instance_id
914: and rowid = ( select max(rowid)
915: from msd_st_level_values b
916: where a.instance = b.instance

Line 915: from msd_st_level_values b

911: select level_id, sr_level_pk,system_attribute1,system_attribute2,dp_enabled_flag
912: from msd_st_level_values a
913: where a.instance = p_instance_id
914: and rowid = ( select max(rowid)
915: from msd_st_level_values b
916: where a.instance = b.instance
917: and a.level_id = b.level_id
918: and a.sr_level_pk = b.sr_level_pk
919: and b.system_attribute1 is not null); -- assuming here that if there exist more than one record

Line 961: update msd_st_level_values

957:
958: if c_Update_Level_Values%ROWCOUNT > 0 then
959:
960: FORALL j IN lb_level_id.FIRST..lb_level_id.LAST
961: update msd_st_level_values
962: set system_attribute1 = lb_system_attribute1(j),
963: system_attribute2 = lb_system_attribute2(j),
964: dp_enabled_flag = lb_dp_enabled_flag(j)
965: where instance = p_instance_id

Line 986: delete from msd_st_level_values a where

982: Key - Instance + Level_Id + SR_LEVEL_PK
983: */
984:
985: if p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE then
986: delete from msd_st_level_values a where
987: a.instance = p_instance_id and
988: rowid <> (select max(rowid) from msd_st_level_values b
989: where a.instance = b.instance
990: and a.level_id = b.level_id

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

984:
985: if p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE then
986: delete from msd_st_level_values a where
987: a.instance = p_instance_id and
988: rowid <> (select max(rowid) from msd_st_level_values b
989: where a.instance = b.instance
990: and a.level_id = b.level_id
991: and a.sr_level_pk = b.sr_level_pk);
992: end if;

Line 1064: from msd_st_level_values a, msd_levels b

1060:
1061: /* Cursor for staging table */
1062: CURSOR c_st_level is
1063: select distinct a.instance, a.level_id
1064: from msd_st_level_values a, msd_levels b
1065: where a.level_id = b.level_id and
1066: a.instance <> 0 and
1067: b.level_type_code = 3 and
1068: a.instance = p_instance;

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

1126: Procedure Delete_Childless_Parent
1127:
1128: This procedure will delete any childless parent level value.
1129: First, We will determine whether destination talbe is Fact or Staging, then
1130: Navigate level_value from either (msd_st_level_values or msd_level_values).
1131: Check whether that level_id exist in level association table as
1132: parent level id.
1133: If it does, then navigate next level id, otherwise, delete it.
1134:

Line 1164: from msd_st_level_values

1160: */
1161:
1162: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )
1163: select '-999' , level_id, sr_level_pk, -999
1164: from msd_st_level_values
1165: where instance = p_instance_id and level_id = p_level_id
1166: minus
1167: select '-999' , parent_level_id, sr_parent_level_pk, -999
1168: from msd_st_level_associations

Line 1171: delete from msd_st_level_values a

1167: select '-999' , parent_level_id, sr_parent_level_pk, -999
1168: from msd_st_level_associations
1169: where instance = p_instance_id and parent_level_id = p_level_id ;
1170:
1171: delete from msd_st_level_values a
1172: where
1173: instance = p_instance_id and
1174: level_id = p_level_id and
1175: exists (select 1 from msd_backup_level_values b