APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_ST_LEVEL_ASSOCIATIONS

Line 277: DELETE FROM msd_st_level_associations

273: DELETE FROM msd_st_level_values
274: WHERE instance = p_instance_id AND level_id = p_level_id;
275: END IF;
276:
277: DELETE FROM msd_st_level_associations
278: WHERE instance = p_instance_id AND
279: level_id = p_level_id AND parent_level_id = p_parent_level_id;
280: END IF;
281:

Line 857: from msd_st_level_associations

853:
854: /* This cursur will select only new level associations */
855: CURSOR c_new_rows IS
856: (select sr_level_pk
857: from msd_st_level_associations
858: where instance = p_instance_id and level_id = p_level_id and
859: parent_level_id = p_parent_level_id
860: MINUS
861: select sr_level_pk

Line 872: from msd_st_level_associations

868: /* This cursor need to be opened only after
869: new associations are deleted from the staging table */
870: CURSOR c_update_rows IS
871: (select sr_level_pk, sr_parent_level_pk
872: from msd_st_level_associations
873: where instance = p_instance_id and level_id = p_level_id and
874: parent_level_id = p_parent_level_id
875: MINUS
876: select sr_level_pk, sr_parent_level_pk

Line 902: DELETE FROM msd_st_level_associations

898: /* First Delete fetched rows(new level associations) from staging,
899: and then Insert them into Fact Table.
900: */
901: FORALL i IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
902: DELETE FROM msd_st_level_associations
903: WHERE instance = p_instance_id and
904: level_id = p_level_id and
905: sr_level_pk = a_sr_level_pk(i) and
906: parent_level_id = p_parent_level_id

Line 979: from msd_st_level_associations

975: where instance = p_instance_id and level_id = p_level_id and
976: parent_level_id = p_parent_level_id
977: MINUS
978: select sr_level_pk, sr_parent_level_pk
979: from msd_st_level_associations
980: where instance = p_instance_id and level_id = p_level_id and
981: parent_level_id = p_parent_level_id);
982:
983: TYPE sr_level_pk_tab is table of msd_level_associations.sr_level_pk%TYPE;