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_LIABILITY dependencies on MSD_ST_LEVEL_ASSOCIATIONS

Line 1251: from msd_st_level_associations_lb

1247: p_plan_id in number) is
1248:
1249: cursor c_duplicate is
1250: select level_id, sr_level_pk, parent_level_id
1251: from msd_st_level_associations_lb
1252: where plan_id = p_plan_id
1253: group by level_id, sr_level_pk, parent_level_id
1254: having count(*) > 1;
1255:

Line 1256: TYPE level_id_tab is table of msd_st_level_associations.level_id%TYPE;

1252: where plan_id = p_plan_id
1253: group by level_id, sr_level_pk, parent_level_id
1254: having count(*) > 1;
1255:
1256: TYPE level_id_tab is table of msd_st_level_associations.level_id%TYPE;
1257: TYPE sr_level_pk_tab IS TABLE OF msd_st_level_associations.sr_level_pk%TYPE;
1258:
1259: a_child_level_id level_id_tab;
1260: a_parent_level_id level_id_tab;

Line 1257: TYPE sr_level_pk_tab IS TABLE OF msd_st_level_associations.sr_level_pk%TYPE;

1253: group by level_id, sr_level_pk, parent_level_id
1254: having count(*) > 1;
1255:
1256: TYPE level_id_tab is table of msd_st_level_associations.level_id%TYPE;
1257: TYPE sr_level_pk_tab IS TABLE OF msd_st_level_associations.sr_level_pk%TYPE;
1258:
1259: a_child_level_id level_id_tab;
1260: a_parent_level_id level_id_tab;
1261: a_sr_level_pk sr_level_pk_tab;

Line 1276: delete from msd_st_level_associations_lb a where

1272: CLOSE c_duplicate;
1273:
1274: IF (a_child_level_id.exists(1)) THEN
1275: FOR i IN a_child_level_id.FIRST..a_child_level_id.LAST LOOP
1276: delete from msd_st_level_associations_lb a where
1277: a.plan_id = p_plan_id and
1278: a.level_id = a_child_level_id(i) and
1279: a.sr_level_pk = a_sr_level_pk(i) and
1280: a.parent_level_id = a_parent_level_id(i) and

Line 1281: rowid <> (select rowid from msd_st_level_associations_lb b

1277: a.plan_id = p_plan_id and
1278: a.level_id = a_child_level_id(i) and
1279: a.sr_level_pk = a_sr_level_pk(i) and
1280: a.parent_level_id = a_parent_level_id(i) and
1281: rowid <> (select rowid from msd_st_level_associations_lb b
1282: where b.plan_id = p_plan_id and
1283: b.level_id = a_child_level_id(i) and
1284: b.sr_level_pk = a_sr_level_pk(i) and
1285: b.parent_level_id = a_parent_level_id(i) and

Line 1392: DELETE FROM msd_st_level_associations_lb

1388: WHERE plan_id = p_plan_id AND level_id = p_level_id;
1389: END IF;
1390:
1391: -- fnd_file.put_line(fnd_file.log,'5.1:translate Level Values ' );
1392: DELETE FROM msd_st_level_associations_lb
1393: WHERE plan_id = p_plan_id AND
1394: level_id = p_level_id
1395: AND parent_level_id = p_parent_level_id;
1396: -- fnd_file.put_line(fnd_file.log,'5.2:translate Level Values ' );

Line 1682: from msd_st_level_associations_lb

1678:
1679: /* This cursur will select only new level associations */
1680: CURSOR c_new_rows IS
1681: (select sr_level_pk
1682: from msd_st_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

Line 1697: from msd_st_level_associations_lb

1693: /* This cursor need to be opened only after
1694: new associations are deleted from the staging table */
1695: CURSOR c_update_rows IS
1696: (select sr_level_pk, sr_parent_level_pk
1697: from msd_st_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

Line 1727: DELETE FROM msd_st_level_associations_lb

1723: /* First Delete fetched rows(new level associations) from staging,
1724: and then Insert them into Fact Table.
1725: */
1726: FORALL i IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
1727: DELETE FROM msd_st_level_associations_lb
1728: WHERE plan_id = p_plan_id and
1729: level_id = p_level_id and
1730: sr_level_pk = a_sr_level_pk(i) and
1731: parent_level_id = p_parent_level_id

Line 1894: from msd_st_level_associations_lb mla, msd_levels ml

1890: mla.plan_id,
1891: ml.level_type_code,
1892: mla.level_id,
1893: mla.parent_level_id
1894: from msd_st_level_associations_lb mla, msd_levels ml
1895: where mla.level_id = ml.level_id
1896: and ml.plan_type = 'LIABILITY'
1897: and mla.plan_id = p_plan_id ;
1898:

Line 1949: Delete from msd_st_level_associations_lb

1945:
1946:
1947: if (nvl(retcode,0) = 0 ) then
1948:
1949: Delete from msd_st_level_associations_lb
1950: where plan_id = Relationship_Rec.plan_id
1951: and level_id = Relationship_Rec.level_id
1952: and parent_level_id = Relationship_Rec.parent_level_id ;
1953:

Line 1992: Delete from msd_st_level_associations_lb

1988: Delete from msd_st_level_values_lb
1989: where plan_id = Relationship_Rec.plan_id
1990: and level_id = Relationship_Rec.level_id ;
1991:
1992: Delete from msd_st_level_associations_lb
1993: where plan_id = Relationship_Rec.plan_id
1994: and level_id = Relationship_Rec.level_id
1995: and parent_level_id = Relationship_Rec.parent_level_id ;
1996: