APPS.MSD_LIABILITY dependencies on MSD_LEVEL_VALUES_LB

Line 717: from msd_level_values_lb lv

713: AND dp_dimension_code <> 'TIM'
714: AND dh.hierarchy_id = hl.hierarchy_id
715: AND level_id NOT IN
716: (select distinct level_id
717: from msd_level_values_lb lv
718: where lv.plan_id = p_plan_id
719: );
720:
721:

Line 1544: from msd_level_values_lb

1540: from msd_st_level_values_lb
1541: where plan_id = p_plan_id and level_id = p_level_id
1542: MINUS
1543: select sr_level_pk
1544: from msd_level_values_lb
1545: where plan_id = p_plan_id and level_id = p_level_id;
1546:
1547: /* Cursor to find modified level values */
1548: /* This cursor needs to be opend only after

Line 1559: from msd_level_values_lb

1555: where plan_id = p_plan_id and level_id = p_level_id
1556: MINUS
1557: select sr_level_pk, level_value,
1558: level_value_desc
1559: from msd_level_values_lb
1560: where plan_id = p_plan_id and level_id = p_level_id);
1561:
1562:
1563:

Line 1610: INSERT INTO msd_level_values_lb(

1606: /* Insert new rows into fact table */
1607: FORALL j IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
1608:
1609:
1610: INSERT INTO msd_level_values_lb(
1611: plan_id, level_id, level_value,
1612: sr_level_pk, level_pk, level_value_desc,
1613: action_code, created_by_refresh_num, last_refresh_num,
1614: last_update_date, last_updated_by,

Line 1639: UPDATE msd_level_values_lb

1635: CLOSE c_update;
1636:
1637: IF (a_sr_level_pk.exists(1)) THEN
1638: FORALL i IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
1639: UPDATE msd_level_values_lb
1640: SET level_value = a_level_value(i),
1641: level_value_desc = a_level_value_desc(i),
1642: action_code = 'U',
1643: last_refresh_num = p_seq_num,

Line 2069: TYPE plan_id_tab IS TABLE OF msd_level_values_lb.plan_id%TYPE;

2065: retcode OUT NOCOPY VARCHAR2
2066: )
2067:
2068: IS
2069: TYPE plan_id_tab IS TABLE OF msd_level_values_lb.plan_id%TYPE;
2070:
2071:
2072: /*This cursor return all the plan ids that are there in levels values table but do not have a plan defined for them */
2073: CURSOR c_plans

Line 2077: from msd_level_values_lb

2073: CURSOR c_plans
2074: is
2075: select
2076: plan_id plan_id
2077: from msd_level_values_lb
2078: minus
2079: Select
2080: liab_plan_id plan_id
2081: from msd_demand_plans ;

Line 2097: Delete from msd_level_values_lb where plan_id = to_number (a_plan_id(i) );

2093:
2094: FOR i IN 1..a_plan_id.count
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: