APPS.PER_CAGR_API_PARAMETERS_PKG dependencies on PER_CAGR_API_PARAMETERS_TL

Line 105: insert into PER_CAGR_API_PARAMETERS_TL (

101: X_LAST_UPDATED_BY,
102: X_LAST_UPDATE_LOGIN
103: );
104:
105: insert into PER_CAGR_API_PARAMETERS_TL (
106: LAST_UPDATE_LOGIN,
107: CREATED_BY,
108: CREATION_DATE,
109: LAST_UPDATE_DATE,

Line 129: from PER_CAGR_API_PARAMETERS_TL T

125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from PER_CAGR_API_PARAMETERS_TL T
130: where T.CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID
131: and T.LANGUAGE = L.LANGUAGE_CODE);
132:
133: open c;

Line 163: update per_cagr_api_parameters_tl set

159: X_CAGR_API_ID
160: );
161:
162:
163: update per_cagr_api_parameters_tl set
164: display_name = X_display_NAME,
165: last_update_date = sysdate,
166: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
167: last_update_login = 0,

Line 281: from PER_CAGR_API_PARAMETERS_TL

277:
278: cursor c1 is select
279: DISPLAY_NAME,
280: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
281: from PER_CAGR_API_PARAMETERS_TL
282: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID
283: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
284: for update of CAGR_API_PARAM_ID nowait;
285: begin

Line 368: update PER_CAGR_API_PARAMETERS_TL set

364: if (sql%notfound) then
365: raise no_data_found;
366: end if;
367:
368: update PER_CAGR_API_PARAMETERS_TL set
369: DISPLAY_NAME = X_DISPLAY_NAME,
370: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
371: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
372: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 386: delete from PER_CAGR_API_PARAMETERS_TL

382: procedure DELETE_ROW (
383: X_CAGR_API_PARAM_ID in NUMBER
384: ) is
385: begin
386: delete from PER_CAGR_API_PARAMETERS_TL
387: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID;
388:
389: if (sql%notfound) then
390: raise no_data_found;

Line 404: delete from PER_CAGR_API_PARAMETERS_TL T

400:
401: procedure ADD_LANGUAGE
402: is
403: begin
404: delete from PER_CAGR_API_PARAMETERS_TL T
405: where not exists
406: (select NULL
407: from PER_CAGR_API_PARAMETERS B
408: where B.CAGR_API_PARAM_ID = T.CAGR_API_PARAM_ID

Line 411: update PER_CAGR_API_PARAMETERS_TL T set (

407: from PER_CAGR_API_PARAMETERS B
408: where B.CAGR_API_PARAM_ID = T.CAGR_API_PARAM_ID
409: );
410:
411: update PER_CAGR_API_PARAMETERS_TL T set (
412: DISPLAY_NAME
413: ) = (select
414: B.DISPLAY_NAME
415: from PER_CAGR_API_PARAMETERS_TL B

Line 415: from PER_CAGR_API_PARAMETERS_TL B

411: update PER_CAGR_API_PARAMETERS_TL T set (
412: DISPLAY_NAME
413: ) = (select
414: B.DISPLAY_NAME
415: from PER_CAGR_API_PARAMETERS_TL B
416: where B.CAGR_API_PARAM_ID = T.CAGR_API_PARAM_ID
417: and B.LANGUAGE = T.SOURCE_LANG)
418: where (
419: T.CAGR_API_PARAM_ID,

Line 424: from PER_CAGR_API_PARAMETERS_TL SUBB, PER_CAGR_API_PARAMETERS_TL SUBT

420: T.LANGUAGE
421: ) in (select
422: SUBT.CAGR_API_PARAM_ID,
423: SUBT.LANGUAGE
424: from PER_CAGR_API_PARAMETERS_TL SUBB, PER_CAGR_API_PARAMETERS_TL SUBT
425: where SUBB.CAGR_API_PARAM_ID = SUBT.CAGR_API_PARAM_ID
426: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
427: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
428: ));

Line 430: insert into PER_CAGR_API_PARAMETERS_TL (

426: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
427: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
428: ));
429:
430: insert into PER_CAGR_API_PARAMETERS_TL (
431: LAST_UPDATE_LOGIN,
432: CREATED_BY,
433: CREATION_DATE,
434: LAST_UPDATE_DATE,

Line 450: from PER_CAGR_API_PARAMETERS_TL B, FND_LANGUAGES L

446: B.CAGR_API_PARAM_ID,
447: B.DISPLAY_NAME,
448: L.LANGUAGE_CODE,
449: B.SOURCE_LANG
450: from PER_CAGR_API_PARAMETERS_TL B, FND_LANGUAGES L
451: where L.INSTALLED_FLAG in ('I', 'B')
452: and B.LANGUAGE = userenv('LANG')
453: and not exists
454: (select NULL

Line 455: from PER_CAGR_API_PARAMETERS_TL T

451: where L.INSTALLED_FLAG in ('I', 'B')
452: and B.LANGUAGE = userenv('LANG')
453: and not exists
454: (select NULL
455: from PER_CAGR_API_PARAMETERS_TL T
456: where T.CAGR_API_PARAM_ID = B.CAGR_API_PARAM_ID
457: and T.LANGUAGE = L.LANGUAGE_CODE);
458: end ADD_LANGUAGE;
459: