APPS.MSD_LIABILITY dependencies on MSD_LEVEL_ASSOCIATIONS

Line 1687: from msd_level_associations_lb

1683: where plan_id = p_plan_id and level_id = p_level_id and
1684: parent_level_id = p_parent_level_id
1685: MINUS
1686: select sr_level_pk
1687: from msd_level_associations_lb
1688: where plan_id = p_plan_id and level_id = p_level_id and
1689: parent_level_id = p_parent_level_id);
1690:
1691:

Line 1702: from msd_level_associations_lb

1698: where plan_id = p_plan_id and level_id = p_level_id and
1699: parent_level_id = p_parent_level_id
1700: MINUS
1701: select sr_level_pk, sr_parent_level_pk
1702: from msd_level_associations_lb
1703: where plan_id = p_plan_id and level_id = p_level_id and
1704: parent_level_id = p_parent_level_id);
1705:
1706:

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

1704: parent_level_id = p_parent_level_id);
1705:
1706:
1707:
1708: TYPE sr_level_pk_tab is table of msd_level_associations.sr_level_pk%TYPE;
1709: TYPE sr_parent_level_pk_tab is table of msd_level_associations.sr_parent_level_pk%TYPE;
1710:
1711: a_sr_level_pk SR_LEVEL_PK_TAB;
1712: a_sr_parent_level_pk SR_PARENT_LEVEL_PK_TAB;

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

1705:
1706:
1707:
1708: TYPE sr_level_pk_tab is table of msd_level_associations.sr_level_pk%TYPE;
1709: TYPE sr_parent_level_pk_tab is table of msd_level_associations.sr_parent_level_pk%TYPE;
1710:
1711: a_sr_level_pk SR_LEVEL_PK_TAB;
1712: a_sr_parent_level_pk SR_PARENT_LEVEL_PK_TAB;
1713:

Line 1738: INSERT INTO msd_level_associations_lb(

1734:
1735: /* Insert new rows into fact table */
1736: IF (a_sr_parent_level_pk.exists(1)) THEN
1737: FORALL i IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
1738: INSERT INTO msd_level_associations_lb(
1739: plan_id, level_id, sr_level_pk,
1740: parent_level_id, sr_parent_level_pk,
1741: last_update_date, last_updated_by,
1742: creation_date, created_by, last_update_login,

Line 1759: UPDATE msd_level_associations_lb

1755:
1756: /* For updated level association */
1757: IF (a_sr_level_pk.exists(1) and a_sr_parent_level_pk.exists(1)) THEN
1758: FORALL i IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
1759: UPDATE msd_level_associations_lb
1760: SET
1761: sr_parent_level_pk = a_sr_parent_level_pk(i),
1762: action_code = 'U',
1763: last_refresh_num = p_seq_num,

Line 2099: Delete from msd_level_associations_lb where plan_id = to_number (a_plan_id(i) );

2095:
2096: loop
2097: Delete from msd_level_values_lb where plan_id = to_number (a_plan_id(i) );
2098:
2099: Delete from msd_level_associations_lb where plan_id = to_number (a_plan_id(i) );
2100: commit ;
2101:
2102: end loop ;
2103: