eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_SVC_COMPONENTS_PKG dependencies on FND_SVC_COMPONENTS

Line 1: package body FND_SVC_COMPONENTS_PKG as

1: package body FND_SVC_COMPONENTS_PKG as
2: /* $Header: AFSVCMTB.pls 115.5 2002/12/27 20:20:10 ankung noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 28: cursor C is select ROWID from FND_SVC_COMPONENTS

24: X_LAST_UPDATE_DATE in DATE,
25: X_LAST_UPDATED_BY in NUMBER,
26: X_LAST_UPDATE_LOGIN in NUMBER
27: ) is
28: cursor C is select ROWID from FND_SVC_COMPONENTS
29: where COMPONENT_ID = X_COMPONENT_ID
30: ;
31: begin
32: insert into FND_SVC_COMPONENTS (

Line 32: insert into FND_SVC_COMPONENTS (

28: cursor C is select ROWID from FND_SVC_COMPONENTS
29: where COMPONENT_ID = X_COMPONENT_ID
30: ;
31: begin
32: insert into FND_SVC_COMPONENTS (
33: COMPONENT_ID,
34: COMPONENT_NAME,
35: COMPONENT_STATUS,
36: COMPONENT_TYPE,

Line 88: wf_core.context('FND_SVC_COMPONENTS_PKG', 'Insert_Row', X_COMPONENT_ID, X_COMPONENT_NAME);

84: close c;
85:
86: exception
87: when others then
88: wf_core.context('FND_SVC_COMPONENTS_PKG', 'Insert_Row', X_COMPONENT_ID, X_COMPONENT_NAME);
89: raise;
90:
91: end INSERT_ROW;
92:

Line 127: from FND_SVC_COMPONENTS

123: CORRELATION_ID,
124: MAX_IDLE_TIME,
125: COMPONENT_STATUS_INFO,
126: OBJECT_VERSION_NUMBER
127: from FND_SVC_COMPONENTS
128: where COMPONENT_ID = X_COMPONENT_ID
129: for update of COMPONENT_ID nowait;
130:
131: recinfo c%rowtype;

Line 174: wf_core.context('FND_SVC_COMPONENTS_PKG', 'Lock_Row', X_COMPONENT_ID, X_COMPONENT_NAME);

170: return;
171:
172: exception
173: when others then
174: wf_core.context('FND_SVC_COMPONENTS_PKG', 'Lock_Row', X_COMPONENT_ID, X_COMPONENT_NAME);
175: raise;
176: end LOCK_ROW;
177:
178: procedure UPDATE_ROW (

Line 213: from FND_SVC_COMPONENTS

209: -- Allow update. Increment the database's OVN by 1
210: --
211: select OBJECT_VERSION_NUMBER
212: into l_object_version_number
213: from FND_SVC_COMPONENTS
214: where COMPONENT_ID = X_COMPONENT_ID;
215:
216: l_object_version_number := l_object_version_number + 1;
217:

Line 230: from FND_SVC_COMPONENTS

226: --
227:
228: select OBJECT_VERSION_NUMBER
229: into l_object_version_number
230: from FND_SVC_COMPONENTS
231: where COMPONENT_ID = X_COMPONENT_ID
232: for update;
233:
234: if (l_object_version_number = X_OBJECT_VERSION_NUMBER) then

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 393: wf_core.context('FND_SVC_COMPONENTS_PKG', 'Update_Row', X_COMPONENT_ID, X_COMPONENT_NAME);

389: end if;
390: end if;
391: exception
392: when others then
393: wf_core.context('FND_SVC_COMPONENTS_PKG', 'Update_Row', X_COMPONENT_ID, X_COMPONENT_NAME);
394: raise;
395: end UPDATE_ROW;
396:
397: procedure DELETE_ROW (

Line 406: from FND_SVC_COMPONENTS

402: begin
403:
404: select CUSTOMIZATION_LEVEL
405: into l_customization_level
406: from FND_SVC_COMPONENTS
407: where COMPONENT_ID = X_COMPONENT_ID;
408:
409: if l_customization_level = 'U' then
410:

Line 411: delete from FND_SVC_COMPONENTS

407: where COMPONENT_ID = X_COMPONENT_ID;
408:
409: if l_customization_level = 'U' then
410:
411: delete from FND_SVC_COMPONENTS
412: where COMPONENT_ID = X_COMPONENT_ID;
413:
414: if (sql%notfound) then
415: raise no_data_found;

Line 485: FROM fnd_svc_components

481:
482: BEGIN
483: SELECT component_id
484: INTO l_component_id
485: FROM fnd_svc_components
486: WHERE component_name = X_COMPONENT_NAME;
487:
488: FND_SVC_COMPONENTS_PKG.UPDATE_ROW (
489: X_COMPONENT_ID => l_component_id,

Line 488: FND_SVC_COMPONENTS_PKG.UPDATE_ROW (

484: INTO l_component_id
485: FROM fnd_svc_components
486: WHERE component_name = X_COMPONENT_NAME;
487:
488: FND_SVC_COMPONENTS_PKG.UPDATE_ROW (
489: X_COMPONENT_ID => l_component_id,
490: X_COMPONENT_NAME => X_COMPONENT_NAME,
491: X_COMPONENT_STATUS => X_COMPONENT_STATUS,
492: X_COMPONENT_TYPE => X_COMPONENT_TYPE,

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 (

Line 515: FND_SVC_COMPONENTS_PKG.INSERT_ROW (

511: SELECT fnd_svc_components_s.nextval
512: INTO l_component_id
513: FROM dual;
514:
515: FND_SVC_COMPONENTS_PKG.INSERT_ROW (
516: X_ROWID => row_id,
517: X_COMPONENT_ID => l_component_id,
518: X_COMPONENT_NAME => X_COMPONENT_NAME,
519: X_COMPONENT_STATUS => X_COMPONENT_STATUS,

Line 542: end FND_SVC_COMPONENTS_PKG;

538: end;
539: end LOAD_ROW;
540:
541:
542: end FND_SVC_COMPONENTS_PKG;