APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_LEVEL_VALUES

Line 624: from msd_level_values

620: from msd_st_level_values
621: where instance = p_instance_id and level_id = p_level_id
622: MINUS
623: select sr_level_pk
624: from msd_level_values
625: where instance = p_instance_id and level_id = p_level_id;
626:
627: /* Cursor to find modified level values */
628: /* This cursor needs to be opend only after

Line 645: from msd_level_values

641: attribute1, attribute2, attribute3,
642: attribute4, attribute5,
643: level_value_desc,system_attribute1,system_attribute2, --jarorad
644: dp_enabled_flag --jarorad
645: from msd_level_values
646: where instance = p_instance_id and level_id = p_level_id);
647:
648:
649:

Line 698: INSERT INTO msd_level_values(

694: a_system_attribute2,a_dp_enabled_flag; --jarorad
695:
696: /* Insert new rows into fact table */
697: FORALL j IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
698: INSERT INTO msd_level_values(
699: instance, level_id, level_value,
700: sr_level_pk, level_pk, level_value_desc,
701: action_code, created_by_refresh_num, last_refresh_num,
702: last_update_date, last_updated_by,

Line 732: UPDATE msd_level_values

728: CLOSE c_update;
729:
730: IF (a_sr_level_pk.exists(1)) THEN
731: FORALL i IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
732: UPDATE msd_level_values
733: SET level_value = a_level_value(i),
734: attribute1 = a_attribute1(i),
735: attribute2 = a_attribute2(i),
736: attribute3 = a_attribute3(i),

Line 779: from msd_level_values

775: p_seq_num IN NUMBER) IS
776:
777: CURSOR c_delete IS
778: (select sr_level_pk
779: from msd_level_values
780: where instance = p_instance_id and level_id = p_level_id
781: MINUS
782: select sr_level_pk
783: from msd_st_level_values

Line 786: TYPE sr_level_pk_tab is table of msd_level_values.sr_level_pk%TYPE;

782: select sr_level_pk
783: from msd_st_level_values
784: where instance = p_instance_id and level_id = p_level_id);
785:
786: TYPE sr_level_pk_tab is table of msd_level_values.sr_level_pk%TYPE;
787: TYPE level_pk_tab is table of msd_level_values.level_pk%TYPE;
788: TYPE crn_tab is table of msd_level_values.created_by_refresh_num%TYPE;
789:
790: a_sr_level_pk SR_LEVEL_PK_TAB;

Line 787: TYPE level_pk_tab is table of msd_level_values.level_pk%TYPE;

783: from msd_st_level_values
784: where instance = p_instance_id and level_id = p_level_id);
785:
786: TYPE sr_level_pk_tab is table of msd_level_values.sr_level_pk%TYPE;
787: TYPE level_pk_tab is table of msd_level_values.level_pk%TYPE;
788: TYPE crn_tab is table of msd_level_values.created_by_refresh_num%TYPE;
789:
790: a_sr_level_pk SR_LEVEL_PK_TAB;
791: a_level_pk LEVEL_PK_TAB;

Line 788: TYPE crn_tab is table of msd_level_values.created_by_refresh_num%TYPE;

784: where instance = p_instance_id and level_id = p_level_id);
785:
786: TYPE sr_level_pk_tab is table of msd_level_values.sr_level_pk%TYPE;
787: TYPE level_pk_tab is table of msd_level_values.level_pk%TYPE;
788: TYPE crn_tab is table of msd_level_values.created_by_refresh_num%TYPE;
789:
790: a_sr_level_pk SR_LEVEL_PK_TAB;
791: a_level_pk LEVEL_PK_TAB;
792: a_crn CRN_TAB;

Line 803: DELETE FROM msd_level_values

799: CLOSE c_delete;
800:
801: IF (a_sr_level_pk.exists(1)) THEN
802: FORALL i IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
803: DELETE FROM msd_level_values
804: WHERE instance = p_instance_id and
805: level_id = p_level_id and
806: sr_level_pk = a_sr_level_pk(i)
807: RETURNING level_pk, created_by_refresh_num

Line 1785: v_sql := 'update msd_level_values lv '||

1781: v_sql varchar2(2000);
1782: begin
1783: -- this is dynamic sql because the pl/sql refuses to accept this
1784: -- query as valid.
1785: v_sql := 'update msd_level_values lv '||
1786: 'set level_pk = nvl((select level_pk '||
1787: 'from msd_backup_level_values bak '||
1788: 'where bak.level_id = ' || p_level_id ||
1789: ' and bak.instance = '''|| p_instance ||