APPS.FND_SVC_COMP_PARAM_VALS_PKG dependencies on FND_SVC_COMP_PARAM_VALS_S

Line 181: update FND_SVC_COMP_PARAM_VALS set

177: -- It can update everything
178: --
179: if WF_EVENTS_PKG.g_Mode = 'UPGRADE' then
180:
181: update FND_SVC_COMP_PARAM_VALS set
182: COMPONENT_ID = X_COMPONENT_ID,
183: PARAMETER_ID = X_PARAMETER_ID,
184: PARAMETER_VALUE = X_PARAMETER_VALUE,
185: CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,

Line 215: update FND_SVC_COMP_PARAM_VALS set

211: -- It can update everything EXCEPT
212: -- > parameter_value
213: if WF_EVENTS_PKG.g_Mode = 'UPGRADE' then
214:
215: update FND_SVC_COMP_PARAM_VALS set
216: COMPONENT_ID = X_COMPONENT_ID,
217: PARAMETER_ID = X_PARAMETER_ID,
218: -- PARAMETER_VALUE = X_PARAMETER_VALUE, // limit column
219: CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,

Line 237: update FND_SVC_COMP_PARAM_VALS set

233: -- > startup_mode
234: -- > max_idle_time
235: else
236:
237: update FND_SVC_COMP_PARAM_VALS set
238: PARAMETER_VALUE = X_PARAMETER_VALUE,
239: OBJECT_VERSION_NUMBER = l_object_version_number,
240: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
241: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 268: update FND_SVC_COMP_PARAM_VALS set

264: -- It can update everything
265: --
266: else
267:
268: update FND_SVC_COMP_PARAM_VALS set
269: COMPONENT_ID = X_COMPONENT_ID,
270: PARAMETER_ID = X_PARAMETER_ID,
271: PARAMETER_VALUE = X_PARAMETER_VALUE,
272: CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,

Line 376: SELECT fnd_svc_comp_param_vals_s.nextval

372: X_LAST_UPDATE_LOGIN => 0);
373:
374: EXCEPTION
375: WHEN No_Data_Found THEN
376: SELECT fnd_svc_comp_param_vals_s.nextval
377: INTO l_component_parameter_id
378: FROM dual;
379:
380: FND_SVC_COMP_PARAM_VALS_PKG.INSERT_ROW (