APPS.PER_CAGR_APIS_PKG dependencies on PER_CAGR_APIS_TL

Line 71: insert into PER_CAGR_APIS_TL (

67: X_LAST_UPDATED_BY,
68: X_LAST_UPDATE_LOGIN
69: );
70:
71: insert into PER_CAGR_APIS_TL (
72: LAST_UPDATE_DATE,
73: LAST_UPDATED_BY,
74: CAGR_API_ID,
75: API_NAME,

Line 95: from PER_CAGR_APIS_TL T

91: from FND_LANGUAGES L
92: where L.INSTALLED_FLAG in ('I', 'B')
93: and not exists
94: (select NULL
95: from PER_CAGR_APIS_TL T
96: where T.CAGR_API_ID = X_CAGR_API_ID
97: and T.LANGUAGE = L.LANGUAGE_CODE);
98:
99: open c;

Line 124: update per_cagr_apis_tl set

120: X_CAGR_API_ID
121: );
122:
123:
124: update per_cagr_apis_tl set
125: api_name = X_API_NAME,
126: last_update_date = sysdate,
127: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
128: last_update_login = 0,

Line 204: from PER_CAGR_APIS_TL

200:
201: cursor c1 is select
202: API_NAME,
203: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
204: from PER_CAGR_APIS_TL
205: where CAGR_API_ID = X_CAGR_API_ID
206: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
207: for update of CAGR_API_ID nowait;
208: begin

Line 262: update PER_CAGR_APIS_TL set

258: if (sql%notfound) then
259: raise no_data_found;
260: end if;
261:
262: update PER_CAGR_APIS_TL set
263: API_NAME = X_API_NAME,
264: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
265: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
266: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 280: delete from PER_CAGR_APIS_TL

276: procedure DELETE_ROW (
277: X_CAGR_API_ID in NUMBER
278: ) is
279: begin
280: delete from PER_CAGR_APIS_TL
281: where CAGR_API_ID = X_CAGR_API_ID;
282:
283: if (sql%notfound) then
284: raise no_data_found;

Line 298: delete from PER_CAGR_APIS_TL T

294:
295: procedure ADD_LANGUAGE
296: is
297: begin
298: delete from PER_CAGR_APIS_TL T
299: where not exists
300: (select NULL
301: from PER_CAGR_APIS B
302: where B.CAGR_API_ID = T.CAGR_API_ID

Line 305: update PER_CAGR_APIS_TL T set (

301: from PER_CAGR_APIS B
302: where B.CAGR_API_ID = T.CAGR_API_ID
303: );
304:
305: update PER_CAGR_APIS_TL T set (
306: API_NAME
307: ) = (select
308: B.API_NAME
309: from PER_CAGR_APIS_TL B

Line 309: from PER_CAGR_APIS_TL B

305: update PER_CAGR_APIS_TL T set (
306: API_NAME
307: ) = (select
308: B.API_NAME
309: from PER_CAGR_APIS_TL B
310: where B.CAGR_API_ID = T.CAGR_API_ID
311: and B.LANGUAGE = T.SOURCE_LANG)
312: where (
313: T.CAGR_API_ID,

Line 318: from PER_CAGR_APIS_TL SUBB, PER_CAGR_APIS_TL SUBT

314: T.LANGUAGE
315: ) in (select
316: SUBT.CAGR_API_ID,
317: SUBT.LANGUAGE
318: from PER_CAGR_APIS_TL SUBB, PER_CAGR_APIS_TL SUBT
319: where SUBB.CAGR_API_ID = SUBT.CAGR_API_ID
320: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
321: and (SUBB.API_NAME <> SUBT.API_NAME
322: ));

Line 324: insert into PER_CAGR_APIS_TL (

320: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
321: and (SUBB.API_NAME <> SUBT.API_NAME
322: ));
323:
324: insert into PER_CAGR_APIS_TL (
325: LAST_UPDATE_DATE,
326: LAST_UPDATED_BY,
327: CAGR_API_ID,
328: API_NAME,

Line 344: from PER_CAGR_APIS_TL B, FND_LANGUAGES L

340: B.CREATED_BY,
341: B.CREATION_DATE,
342: L.LANGUAGE_CODE,
343: B.SOURCE_LANG
344: from PER_CAGR_APIS_TL B, FND_LANGUAGES L
345: where L.INSTALLED_FLAG in ('I', 'B')
346: and B.LANGUAGE = userenv('LANG')
347: and not exists
348: (select NULL

Line 349: from PER_CAGR_APIS_TL T

345: where L.INSTALLED_FLAG in ('I', 'B')
346: and B.LANGUAGE = userenv('LANG')
347: and not exists
348: (select NULL
349: from PER_CAGR_APIS_TL T
350: where T.CAGR_API_ID = B.CAGR_API_ID
351: and T.LANGUAGE = L.LANGUAGE_CODE);
352: end ADD_LANGUAGE;
353: