APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_LEVEL_ASSOCIATIONS

Line 894: from msd_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
894: from msd_level_associations
895: where instance = p_instance_id and level_id = p_level_id and
896: parent_level_id = p_parent_level_id);
897:
898:

Line 909: from msd_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
909: from msd_level_associations
910: where instance = p_instance_id and level_id = p_level_id and
911: parent_level_id = p_parent_level_id);
912:
913:

Line 915: TYPE sr_level_pk_tab is table of msd_level_associations.sr_level_pk%TYPE;

911: parent_level_id = p_parent_level_id);
912:
913:
914:
915: TYPE sr_level_pk_tab is table of msd_level_associations.sr_level_pk%TYPE;
916: TYPE sr_parent_level_pk_tab is table of msd_level_associations.sr_parent_level_pk%TYPE;
917:
918: a_sr_level_pk SR_LEVEL_PK_TAB;
919: a_sr_parent_level_pk SR_PARENT_LEVEL_PK_TAB;

Line 916: TYPE sr_parent_level_pk_tab is table of msd_level_associations.sr_parent_level_pk%TYPE;

912:
913:
914:
915: TYPE sr_level_pk_tab is table of msd_level_associations.sr_level_pk%TYPE;
916: TYPE sr_parent_level_pk_tab is table of msd_level_associations.sr_parent_level_pk%TYPE;
917:
918: a_sr_level_pk SR_LEVEL_PK_TAB;
919: a_sr_parent_level_pk SR_PARENT_LEVEL_PK_TAB;
920:

Line 945: INSERT INTO msd_level_associations(

941:
942: /* Insert new rows into fact table */
943: IF (a_sr_parent_level_pk.exists(1)) THEN
944: FORALL i IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
945: INSERT INTO msd_level_associations(
946: instance, level_id, sr_level_pk,
947: parent_level_id, sr_parent_level_pk,
948: last_update_date, last_updated_by,
949: creation_date, created_by, last_update_login,

Line 966: UPDATE msd_level_associations

962:
963: /* For updated level association */
964: IF (a_sr_level_pk.exists(1) and a_sr_parent_level_pk.exists(1)) THEN
965: FORALL i IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
966: UPDATE msd_level_associations
967: SET
968: sr_parent_level_pk = a_sr_parent_level_pk(i),
969: action_code = 'U',
970: last_refresh_num = p_seq_num,

Line 1006: from msd_level_associations

1002:
1003:
1004: CURSOR c_delete IS
1005: (select sr_level_pk, sr_parent_level_pk
1006: from msd_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

Line 1015: TYPE sr_level_pk_tab is table of msd_level_associations.sr_level_pk%TYPE;

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;
1016: TYPE sr_parent_level_pk_tab is table of msd_level_associations.sr_parent_level_pk%TYPE;
1017:
1018: a_sr_level_pk SR_LEVEL_PK_TAB;
1019: a_sr_parent_level_pk SR_PARENT_LEVEL_PK_TAB;

Line 1016: TYPE sr_parent_level_pk_tab is table of msd_level_associations.sr_parent_level_pk%TYPE;

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;
1016: TYPE sr_parent_level_pk_tab is table of msd_level_associations.sr_parent_level_pk%TYPE;
1017:
1018: a_sr_level_pk SR_LEVEL_PK_TAB;
1019: a_sr_parent_level_pk SR_PARENT_LEVEL_PK_TAB;
1020:

Line 1029: DELETE FROM msd_level_associations

1025: CLOSE c_delete;
1026:
1027: IF (a_sr_level_pk.exists(1)) THEN
1028: FORALL i IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
1029: DELETE FROM msd_level_associations
1030: WHERE instance = p_instance_id and
1031: level_id = p_level_id and
1032: sr_level_pk = a_sr_level_pk(i) and
1033: parent_level_id = p_parent_level_id and