DBA Data[Home] [Help]

APPS.FND_SVC_COMPONENTS_PKG dependencies on FND_SVC_COMPONENTS_S

Line 257: update FND_SVC_COMPONENTS set

253: -- It can update everything
254: --
255: if WF_EVENTS_PKG.g_Mode = 'UPGRADE' then
256:
257: update FND_SVC_COMPONENTS set
258: COMPONENT_NAME = X_COMPONENT_NAME,
259: -- COMPONENT_STATUS = X_COMPONENT_STATUS, // run-time data
260: COMPONENT_TYPE = X_COMPONENT_TYPE,
261: STARTUP_MODE = X_STARTUP_MODE,

Line 302: update FND_SVC_COMPONENTS set

298: -- > startup_mode
299: -- > max_idle_time
300: if WF_EVENTS_PKG.g_Mode = 'UPGRADE' then
301:
302: update FND_SVC_COMPONENTS set
303: COMPONENT_NAME = X_COMPONENT_NAME,
304: -- COMPONENT_STATUS = X_COMPONENT_STATUS, // run-time data
305: COMPONENT_TYPE = X_COMPONENT_TYPE,
306: -- STARTUP_MODE = X_STARTUP_MODE, // limit data

Line 334: update FND_SVC_COMPONENTS set

330: -- > startup_mode
331: -- > max_idle_time
332: else
333:
334: update FND_SVC_COMPONENTS set
335: STARTUP_MODE = X_STARTUP_MODE,
336: MAX_IDLE_TIME = X_MAX_IDLE_TIME,
337: OBJECT_VERSION_NUMBER = l_object_version_number,
338: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 365: update FND_SVC_COMPONENTS set

361: -- It can update everything
362: --
363: else
364:
365: update FND_SVC_COMPONENTS set
366: COMPONENT_NAME = X_COMPONENT_NAME,
367: -- COMPONENT_STATUS = X_COMPONENT_STATUS, // run-time data
368: COMPONENT_TYPE = X_COMPONENT_TYPE,
369: STARTUP_MODE = X_STARTUP_MODE,

Line 511: SELECT fnd_svc_components_s.nextval

507: X_LAST_UPDATE_LOGIN => 0);
508:
509: EXCEPTION
510: WHEN No_Data_Found THEN
511: SELECT fnd_svc_components_s.nextval
512: INTO l_component_id
513: FROM dual;
514:
515: FND_SVC_COMPONENTS_PKG.INSERT_ROW (