DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_DP_PARAMETERS_DS

Line 1769: FROM MSD_DP_PARAMETERS_DS

1765:
1766: BEGIN
1767:
1768: SELECT REFRESH_NUM INTO x_temp
1769: FROM MSD_DP_PARAMETERS_DS
1770: WHERE DEMAND_PLAN_ID = -1;
1771:
1772: UPDATE MSD_DP_PARAMETERS_DS
1773: SET REFRESH_NUM = p_seq_num

Line 1772: UPDATE MSD_DP_PARAMETERS_DS

1768: SELECT REFRESH_NUM INTO x_temp
1769: FROM MSD_DP_PARAMETERS_DS
1770: WHERE DEMAND_PLAN_ID = -1;
1771:
1772: UPDATE MSD_DP_PARAMETERS_DS
1773: SET REFRESH_NUM = p_seq_num
1774: WHERE DEMAND_PLAN_ID = -1;
1775:
1776: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1778: INSERT INTO MSD_DP_PARAMETERS_DS

1774: WHERE DEMAND_PLAN_ID = -1;
1775:
1776: EXCEPTION WHEN NO_DATA_FOUND THEN
1777:
1778: INSERT INTO MSD_DP_PARAMETERS_DS
1779: ( DEMAND_PLAN_ID,
1780: DATA_TYPE,
1781: PARAMETER_TYPE,
1782: PARAMETER_NAME,