DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_DP_PARAMETERS_DS

Line 1737: FROM MSD_DP_PARAMETERS_DS

1733:
1734: BEGIN
1735:
1736: SELECT REFRESH_NUM INTO x_temp
1737: FROM MSD_DP_PARAMETERS_DS
1738: WHERE DEMAND_PLAN_ID = -1;
1739:
1740: UPDATE MSD_DP_PARAMETERS_DS
1741: SET REFRESH_NUM = p_seq_num

Line 1740: UPDATE MSD_DP_PARAMETERS_DS

1736: SELECT REFRESH_NUM INTO x_temp
1737: FROM MSD_DP_PARAMETERS_DS
1738: WHERE DEMAND_PLAN_ID = -1;
1739:
1740: UPDATE MSD_DP_PARAMETERS_DS
1741: SET REFRESH_NUM = p_seq_num
1742: WHERE DEMAND_PLAN_ID = -1;
1743:
1744: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1746: INSERT INTO MSD_DP_PARAMETERS_DS

1742: WHERE DEMAND_PLAN_ID = -1;
1743:
1744: EXCEPTION WHEN NO_DATA_FOUND THEN
1745:
1746: INSERT INTO MSD_DP_PARAMETERS_DS
1747: ( DEMAND_PLAN_ID,
1748: DATA_TYPE,
1749: PARAMETER_TYPE,
1750: PARAMETER_NAME,