APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_ST_LEVEL_ASSOCIATIONS

Line 280: DELETE FROM msd_st_level_associations

276: DELETE FROM msd_st_level_values
277: WHERE instance = p_instance_id AND level_id = p_level_id;
278: END IF;
279:
280: DELETE FROM msd_st_level_associations
281: WHERE instance = p_instance_id AND
282: level_id = p_level_id AND parent_level_id = p_parent_level_id;
283: END IF;
284:

Line 889: from msd_st_level_associations

885:
886: /* This cursur will select only new level associations */
887: CURSOR c_new_rows IS
888: (select sr_level_pk
889: from msd_st_level_associations
890: where instance = p_instance_id and level_id = p_level_id and
891: parent_level_id = p_parent_level_id
892: MINUS
893: select sr_level_pk

Line 904: from msd_st_level_associations

900: /* This cursor need to be opened only after
901: new associations are deleted from the staging table */
902: CURSOR c_update_rows IS
903: (select sr_level_pk, sr_parent_level_pk
904: from msd_st_level_associations
905: where instance = p_instance_id and level_id = p_level_id and
906: parent_level_id = p_parent_level_id
907: MINUS
908: select sr_level_pk, sr_parent_level_pk

Line 934: DELETE FROM msd_st_level_associations

930: /* First Delete fetched rows(new level associations) from staging,
931: and then Insert them into Fact Table.
932: */
933: FORALL i IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
934: DELETE FROM msd_st_level_associations
935: WHERE instance = p_instance_id and
936: level_id = p_level_id and
937: sr_level_pk = a_sr_level_pk(i) and
938: parent_level_id = p_parent_level_id

Line 1011: from msd_st_level_associations

1007: where instance = p_instance_id and level_id = p_level_id and
1008: parent_level_id = p_parent_level_id
1009: MINUS
1010: select sr_level_pk, sr_parent_level_pk
1011: from msd_st_level_associations
1012: where instance = p_instance_id and level_id = p_level_id and
1013: parent_level_id = p_parent_level_id);
1014:
1015: TYPE sr_level_pk_tab is table of msd_level_associations.sr_level_pk%TYPE;