eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_LEVEL_ORG_ASSCNS

Line 1628: delete from msd_level_org_asscns

1624: /* Bug # 3745624. Delete all level org asscns only when Complete Refresh = 'y' else delete only those values which
1625: exist in msd_st_level_org_asscns */
1626: elsif (p_delete_flag = 'Y') then
1627:
1628: delete from msd_level_org_asscns
1629: where instance = p_instance_id
1630: and level_id = p_lvl_id;
1631:
1632: v_dest_table := 'MSD_LEVEL_ORG_ASSCNS';

Line 1632: v_dest_table := 'MSD_LEVEL_ORG_ASSCNS';

1628: delete from msd_level_org_asscns
1629: where instance = p_instance_id
1630: and level_id = p_lvl_id;
1631:
1632: v_dest_table := 'MSD_LEVEL_ORG_ASSCNS';
1633:
1634: elsif (p_delete_flag = 'N') then
1635:
1636: for c_delete_cur in c_delete loop

Line 1638: delete from msd_level_org_asscns

1634: elsif (p_delete_flag = 'N') then
1635:
1636: for c_delete_cur in c_delete loop
1637:
1638: delete from msd_level_org_asscns
1639: where instance = p_instance_id
1640: and level_id = p_lvl_id
1641: and sr_level_pk = c_delete_cur.sr_level_pk
1642: and org_level_id = c_delete_cur.org_level_id

Line 1647: v_dest_table := 'MSD_LEVEL_ORG_ASSCNS';

1643: and org_sr_level_pk = c_delete_cur.org_sr_level_pk;
1644:
1645: end loop;
1646:
1647: v_dest_table := 'MSD_LEVEL_ORG_ASSCNS';
1648:
1649: end if;
1650:
1651: /** Insert Data **/

Line 1655: insert into msd_level_org_asscns

1651: /** Insert Data **/
1652:
1653: if (p_source_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1654:
1655: insert into msd_level_org_asscns
1656: ( INSTANCE,
1657: LEVEL_ID,
1658: SR_LEVEL_PK,
1659: ORG_LEVEL_ID,