APPS.MSD_DP_PARAMETER_PKG dependencies on MSD_DP_PARAMETERS

Line 77: from msd_dp_parameters

73: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
74: begin
75: select LAST_UPDATED_BY, LAST_UPDATE_DATE
76: into db_luby, db_ludate
77: from msd_dp_parameters
78: where DEMAND_PLAN_ID = l_demand_plan_id
79: and PARAMETER_TYPE = P_PARAMETER_TYPE
80: and (PARAMETER_NAME is null
81: or PARAMETER_NAME = P_PARAMETER_NAME);

Line 87: update msd_dp_parameters

83: -- Test for customization and version
84: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
85: db_ludate, P_CUSTOM_MODE)) then
86: -- Update existing row
87: update msd_dp_parameters
88: set capacity_usage_ratio = p_capacity_usage_ratio ,
89: supply_plan_flag = p_supply_plan_flag ,
90: last_update_date = f_ludate ,
91: start_date = to_date(P_START_DATE, 'YYYY/MM/DD'),

Line 125: insert into msd_dp_parameters

121: end if;
122: exception
123: when no_data_found then
124: -- Record doesn't exist - insert in all cases
125: insert into msd_dp_parameters
126: (DEMAND_PLAN_ID
127: ,PARAMETER_ID
128: ,PARAMETER_TYPE
129: ,PARAMETER_NAME

Line 163: ,msd_dp_parameters_s.nextval

159: ARCHIVED_FOR_PARAMETER
160: )
161: values
162: (l_demand_plan_id
163: ,msd_dp_parameters_s.nextval
164: ,P_PARAMETER_TYPE
165: ,P_PARAMETER_NAME
166: ,to_date(P_START_DATE, 'YYYY/MM/DD')
167: ,to_date(P_END_DATE, 'YYYY/MM/DD')