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_COMP_PARAM_VALS_PKG dependencies on FND_SVC_COMP_PARAM_VALS

Line 1: package body FND_SVC_COMP_PARAM_VALS_PKG as

1: package body FND_SVC_COMP_PARAM_VALS_PKG as
2: /* $Header: AFSVCVTB.pls 115.6 2002/12/27 20:33:49 ankung noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 18: cursor C is select ROWID from FND_SVC_COMP_PARAM_VALS

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from FND_SVC_COMP_PARAM_VALS
19: where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID
20: ;
21: begin
22: insert into FND_SVC_COMP_PARAM_VALS (

Line 22: insert into FND_SVC_COMP_PARAM_VALS (

18: cursor C is select ROWID from FND_SVC_COMP_PARAM_VALS
19: where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID
20: ;
21: begin
22: insert into FND_SVC_COMP_PARAM_VALS (
23: COMPONENT_PARAMETER_ID,
24: COMPONENT_ID,
25: PARAMETER_ID,
26: PARAMETER_VALUE,

Line 59: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Insert_Row', X_COMPONENT_PARAMETER_ID);

55: close c;
56:
57: exception
58: when others then
59: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Insert_Row', X_COMPONENT_PARAMETER_ID);
60: raise;
61: end INSERT_ROW;
62:
63:

Line 78: from FND_SVC_COMP_PARAM_VALS

74: PARAMETER_ID,
75: PARAMETER_VALUE,
76: CUSTOMIZATION_LEVEL,
77: OBJECT_VERSION_NUMBER
78: from FND_SVC_COMP_PARAM_VALS
79: where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID
80: for update of COMPONENT_PARAMETER_ID nowait;
81:
82: recinfo c%rowtype;

Line 108: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Lock_Row', X_COMPONENT_PARAMETER_ID);

104: return;
105:
106: exception
107: when others then
108: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Lock_Row', X_COMPONENT_PARAMETER_ID);
109: raise;
110: end LOCK_ROW;
111:
112: procedure UPDATE_ROW (

Line 137: from FND_SVC_COMP_PARAM_VALS

133: -- Allow update. Increment the database's OVN by 1
134: --
135: select OBJECT_VERSION_NUMBER
136: into l_object_version_number
137: from FND_SVC_COMP_PARAM_VALS
138: where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID;
139:
140: l_object_version_number := l_object_version_number + 1;
141:

Line 154: from FND_SVC_COMP_PARAM_VALS

150: --
151:
152: select OBJECT_VERSION_NUMBER
153: into l_object_version_number
154: from FND_SVC_COMP_PARAM_VALS
155: where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID
156: for update;
157:
158: if (l_object_version_number = X_OBJECT_VERSION_NUMBER) then

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 287: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Update_Row', X_COMPONENT_PARAMETER_ID);

283: end if;
284:
285: exception
286: when others then
287: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Update_Row', X_COMPONENT_PARAMETER_ID);
288: raise;
289: end UPDATE_ROW;
290:
291: procedure DELETE_ROW (

Line 299: from FND_SVC_COMP_PARAM_VALS

295: begin
296:
297: select CUSTOMIZATION_LEVEL
298: into l_customization_level
299: from FND_SVC_COMP_PARAM_VALS
300: where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID;
301:
302: if l_customization_level = 'U' then
303:

Line 304: delete from FND_SVC_COMP_PARAM_VALS

300: where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID;
301:
302: if l_customization_level = 'U' then
303:
304: delete from FND_SVC_COMP_PARAM_VALS
305: where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID;
306:
307: if (sql%notfound) then
308: raise no_data_found;

Line 313: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Delete_Row', X_COMPONENT_PARAMETER_ID);

309: end if;
310: end if;
311: exception
312: when others then
313: wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Delete_Row', X_COMPONENT_PARAMETER_ID);
314: raise;
315:
316: end DELETE_ROW;
317:

Line 359: FROM fnd_svc_comp_param_vals

355: BEGIN
356:
357: SELECT component_parameter_id
358: INTO l_component_parameter_id
359: FROM fnd_svc_comp_param_vals
360: WHERE component_id = l_component_id
361: AND parameter_id = l_parameter_id;
362:
363: FND_SVC_COMP_PARAM_VALS_PKG.UPDATE_ROW (

Line 363: FND_SVC_COMP_PARAM_VALS_PKG.UPDATE_ROW (

359: FROM fnd_svc_comp_param_vals
360: WHERE component_id = l_component_id
361: AND parameter_id = l_parameter_id;
362:
363: FND_SVC_COMP_PARAM_VALS_PKG.UPDATE_ROW (
364: X_COMPONENT_PARAMETER_ID => l_component_parameter_id,
365: X_COMPONENT_ID => l_component_id,
366: X_PARAMETER_ID => l_parameter_id,
367: X_PARAMETER_VALUE => X_PARAMETER_VALUE,

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 (

Line 380: FND_SVC_COMP_PARAM_VALS_PKG.INSERT_ROW (

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 (
381: X_ROWID => row_id,
382: X_COMPONENT_PARAMETER_ID => l_component_parameter_id,
383: X_COMPONENT_ID => l_component_id,
384: X_PARAMETER_ID => l_parameter_id,

Line 397: end FND_SVC_COMP_PARAM_VALS_PKG;

393: END;
394: end LOAD_ROW;
395:
396:
397: end FND_SVC_COMP_PARAM_VALS_PKG;