APPS.FND_SVC_COMP_PARAMS_PKG dependencies on FND_SVC_COMP_PARAMS_TL

Line 58: insert into FND_SVC_COMP_PARAMS_TL (

54: X_LAST_UPDATED_BY,
55: X_LAST_UPDATE_LOGIN
56: );
57:
58: insert into FND_SVC_COMP_PARAMS_TL (
59: PARAMETER_ID,
60: DISPLAY_NAME,
61: DESCRIPTION,
62: CREATION_DATE,

Line 84: from FND_SVC_COMP_PARAMS_TL T

80: from WF_LANGUAGES L
81: where L.INSTALLED_FLAG = 'Y'
82: and not exists
83: (select NULL
84: from FND_SVC_COMP_PARAMS_TL T
85: where T.PARAMETER_ID = X_PARAMETER_ID
86: and T.LANGUAGE = L.CODE);
87:
88: open c;

Line 133: from FND_SVC_COMP_PARAMS_TL

129: cursor c1 is select
130: DISPLAY_NAME,
131: DESCRIPTION,
132: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
133: from FND_SVC_COMP_PARAMS_TL
134: where PARAMETER_ID = X_PARAMETER_ID
135: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
136: for update of PARAMETER_ID nowait;
137: begin

Line 261: update FND_SVC_COMP_PARAMS_TL set

257: if (sql%notfound) then
258: raise no_data_found;
259: end if;
260:
261: update FND_SVC_COMP_PARAMS_TL set
262: DISPLAY_NAME = X_DISPLAY_NAME,
263: DESCRIPTION = X_DESCRIPTION,
264: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
265: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 285: delete from FND_SVC_COMP_PARAMS_TL

281: procedure DELETE_ROW (
282: X_PARAMETER_ID in NUMBER
283: ) is
284: begin
285: delete from FND_SVC_COMP_PARAMS_TL
286: where PARAMETER_ID = X_PARAMETER_ID;
287:
288: if (sql%notfound) then
289: raise no_data_found;

Line 308: delete from FND_SVC_COMP_PARAMS_TL T

304:
305: procedure ADD_LANGUAGE
306: is
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

Line 315: update FND_SVC_COMP_PARAMS_TL T set (

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 (
316: DISPLAY_NAME,
317: DESCRIPTION
318: ) = (select
319: B.DISPLAY_NAME,

Line 321: from FND_SVC_COMP_PARAMS_TL B

317: DESCRIPTION
318: ) = (select
319: B.DISPLAY_NAME,
320: B.DESCRIPTION
321: from FND_SVC_COMP_PARAMS_TL B
322: where B.PARAMETER_ID = T.PARAMETER_ID
323: and B.LANGUAGE = T.SOURCE_LANG)
324: where (
325: T.PARAMETER_ID,

Line 330: from FND_SVC_COMP_PARAMS_TL SUBB, FND_SVC_COMP_PARAMS_TL SUBT

326: T.LANGUAGE
327: ) in (select
328: SUBT.PARAMETER_ID,
329: SUBT.LANGUAGE
330: from FND_SVC_COMP_PARAMS_TL SUBB, FND_SVC_COMP_PARAMS_TL SUBT
331: where SUBB.PARAMETER_ID = SUBT.PARAMETER_ID
332: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
333: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
334: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 339: insert into FND_SVC_COMP_PARAMS_TL (

335: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
336: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
337: ));
338:
339: insert into FND_SVC_COMP_PARAMS_TL (
340: PARAMETER_ID,
341: DISPLAY_NAME,
342: DESCRIPTION,
343: CREATION_DATE,

Line 361: from FND_SVC_COMP_PARAMS_TL B, WF_LANGUAGES L

357: B.LAST_UPDATED_BY,
358: B.LAST_UPDATE_LOGIN,
359: L.CODE,
360: B.SOURCE_LANG
361: from FND_SVC_COMP_PARAMS_TL B, WF_LANGUAGES L
362: where L.INSTALLED_FLAG = 'Y'
363: and B.LANGUAGE = userenv('LANG')
364: and not exists
365: (select NULL

Line 366: from FND_SVC_COMP_PARAMS_TL T

362: where L.INSTALLED_FLAG = 'Y'
363: and B.LANGUAGE = userenv('LANG')
364: and not exists
365: (select NULL
366: from FND_SVC_COMP_PARAMS_TL T
367: where T.PARAMETER_ID = B.PARAMETER_ID
368: and T.LANGUAGE = L.CODE);
369: end ADD_LANGUAGE;
370:

Line 462: UPDATE FND_SVC_COMP_PARAMS_TL

458:
459: --
460: -- Only update rows that have not been altered by user
461: --
462: UPDATE FND_SVC_COMP_PARAMS_TL
463: SET display_name = X_DISPLAY_NAME,
464: description = X_DESCRIPTION,
465: source_lang = userenv('LANG'),
466: last_update_date = sysdate,