APPS.MSD_DP_FORMULA_PARAMETER_PKG dependencies on MSD_DP_FORMULA_PARAMETERS

Line 63: from msd_dp_formula_parameters

59: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
60: begin
61: select LAST_UPDATED_BY, LAST_UPDATE_DATE
62: into db_luby, db_ludate
63: from msd_dp_formula_parameters
64: where DEMAND_PLAN_ID = l_demand_plan_id
65: and formula_id = l_formula_id
66: and where_used = p_where_used
67: and parameter_sequence = p_parameter_sequence;

Line 73: update msd_dp_formula_parameters

69: -- Test for customization and version
70: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
71: db_ludate, P_CUSTOM_MODE)) then
72: -- Update existing row
73: update msd_dp_formula_parameters
74: set enabled_flag = p_enabled_flag
75: ,mandatory_flag = p_mandatory_flag
76: ,parameter_type = p_parameter_type
77: ,parameter_component = p_parameter_component

Line 93: insert into msd_dp_formula_parameters

89: end if;
90: exception
91: when no_data_found then
92: -- Record doesn't exist - insert in all cases
93: insert into msd_dp_formula_parameters
94: (DEMAND_PLAN_ID
95: ,FORMULA_ID
96: ,WHERE_USED
97: ,PARAMETER_SEQUENCE