APPS.FND_SVC_COMP_PARAMS_PKG dependencies on FND_SVC_COMP_PARAMS_B

Line 22: cursor C is select ROWID from FND_SVC_COMP_PARAMS_B

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from FND_SVC_COMP_PARAMS_B
23: where PARAMETER_ID = X_PARAMETER_ID
24: ;
25: begin
26: insert into FND_SVC_COMP_PARAMS_B (

Line 26: insert into FND_SVC_COMP_PARAMS_B (

22: cursor C is select ROWID from FND_SVC_COMP_PARAMS_B
23: where PARAMETER_ID = X_PARAMETER_ID
24: ;
25: begin
26: insert into FND_SVC_COMP_PARAMS_B (
27: OBJECT_VERSION_NUMBER,
28: PARAMETER_ID,
29: PARAMETER_NAME,
30: COMPONENT_TYPE,

Line 124: from FND_SVC_COMP_PARAMS_B

120: REQUIRED_FLAG,
121: ALLOW_RELOAD_FLAG,
122: ENCRYPTED_FLAG,
123: CUSTOMIZATION_LEVEL
124: from FND_SVC_COMP_PARAMS_B
125: where PARAMETER_ID = X_PARAMETER_ID
126: for update of PARAMETER_ID nowait;
127: recinfo c%rowtype;
128:

Line 210: from FND_SVC_COMP_PARAMS_B

206: -- Allow update. Increment the database's OVN by 1
207: --
208: select OBJECT_VERSION_NUMBER
209: into l_object_version_number
210: from FND_SVC_COMP_PARAMS_B
211: where PARAMETER_ID = X_PARAMETER_ID;
212:
213: l_object_version_number := l_object_version_number + 1;
214:

Line 227: from FND_SVC_COMP_PARAMS_B

223: --
224:
225: select OBJECT_VERSION_NUMBER
226: into l_object_version_number
227: from FND_SVC_COMP_PARAMS_B
228: where PARAMETER_ID = X_PARAMETER_ID
229: for update;
230:
231: if (l_object_version_number = X_OBJECT_VERSION_NUMBER) then

Line 243: update FND_SVC_COMP_PARAMS_B set

239: end if;
240:
241: end if;
242:
243: update FND_SVC_COMP_PARAMS_B set
244: OBJECT_VERSION_NUMBER = l_object_version_number,
245: PARAMETER_NAME = X_PARAMETER_NAME,
246: COMPONENT_TYPE = X_COMPONENT_TYPE,
247: DEFAULT_PARAMETER_VALUE = X_DEFAULT_PARAMETER_VALUE,

Line 292: delete from FND_SVC_COMP_PARAMS_B

288: if (sql%notfound) then
289: raise no_data_found;
290: end if;
291:
292: delete from FND_SVC_COMP_PARAMS_B
293: where PARAMETER_ID = X_PARAMETER_ID;
294:
295: if (sql%notfound) then
296: raise no_data_found;

Line 311: from FND_SVC_COMP_PARAMS_B B

307: begin
308: delete from FND_SVC_COMP_PARAMS_TL T
309: where not exists
310: (select NULL
311: from FND_SVC_COMP_PARAMS_B B
312: where B.PARAMETER_ID = T.PARAMETER_ID
313: );
314:
315: update FND_SVC_COMP_PARAMS_TL T set (

Line 403: FROM fnd_svc_comp_params_b

399:
400: BEGIN
401: SELECT parameter_id
402: INTO l_parameter_id
403: FROM fnd_svc_comp_params_b
404: WHERE component_type = x_component_type
405: AND parameter_name = x_parameter_name;
406:
407: FND_SVC_COMP_PARAMS_PKG.UPDATE_ROW (

Line 425: SELECT fnd_svc_comp_params_b_s.nextval

421: X_LAST_UPDATE_LOGIN => 0);
422:
423: EXCEPTION
424: WHEN No_Data_Found THEN
425: SELECT fnd_svc_comp_params_b_s.nextval
426: INTO l_parameter_id
427: FROM dual;
428:
429: