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.PER_CAGR_API_PARAMETERS_PKG dependencies on PER_CAGR_API_PARAMETERS

Line 1: package body PER_CAGR_API_PARAMETERS_PKG as

1: package body PER_CAGR_API_PARAMETERS_PKG as
2: /* $Header: pecaplct.pkb 120.1.12000000.2 2007/05/15 08:52:52 ghshanka ship $ */
3:
4:
5: procedure KEY_TO_IDS (

Line 20: from PER_CAGR_API_PARAMETERS cap,

16: where API.API_NAME = X_API_NAME;
17:
18: cursor CSR_CAGR_DISPLAY_NAME ( X_DISPLAY_NAME VARCHAR2, X_API_NAME VARCHAR2 ) is
19: select cap.CAGR_API_PARAM_ID
20: from PER_CAGR_API_PARAMETERS cap,
21: PER_CAGR_APIS api
22: where cap.DISPLAY_NAME = X_DISPLAY_NAME
23: and cap.cagr_api_id = api.cagr_Api_id
24: and api.api_name = X_API_NAME;

Line 27: select PER_CAGR_API_PARAMETERS_S.nextval

23: and cap.cagr_api_id = api.cagr_Api_id
24: and api.api_name = X_API_NAME;
25:
26: cursor CSR_SEQUENCE is
27: select PER_CAGR_API_PARAMETERS_S.nextval
28: from dual;
29:
30: begin
31: open CSR_CAGR_API ( X_API_NAME );

Line 65: cursor C is select ROWID from PER_CAGR_API_PARAMETERS

61: X_LAST_UPDATE_DATE in DATE,
62: X_LAST_UPDATED_BY in NUMBER,
63: X_LAST_UPDATE_LOGIN in NUMBER
64: ) is
65: cursor C is select ROWID from PER_CAGR_API_PARAMETERS
66: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID
67: ;
68: begin
69: insert into PER_CAGR_API_PARAMETERS (

Line 69: insert into PER_CAGR_API_PARAMETERS (

65: cursor C is select ROWID from PER_CAGR_API_PARAMETERS
66: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID
67: ;
68: begin
69: insert into PER_CAGR_API_PARAMETERS (
70: DEFAULT_UOM,
71: CAGR_API_PARAM_ID,
72: DISPLAY_NAME,
73: CAGR_API_ID,

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 207: PER_CAGR_API_PARAMETERS_PKG.UPDATE_ROW(

203: else
204: user_id := 0;
205: end if;
206:
207: PER_CAGR_API_PARAMETERS_PKG.UPDATE_ROW(
208: X_CAGR_API_PARAM_ID => X_CAGR_API_PARAM_ID,
209: X_DEFAULT_UOM => X_DEFAULT_UOM,
210: X_CAGR_API_ID => X_CAGR_API_ID,
211: X_PARAMETER_NAME => X_PARAMETER_NAME,

Line 227: PER_CAGR_API_PARAMETERS_PKG.INSERT_ROW(

223:
224: exception
225: when NO_DATA_FOUND then
226:
227: PER_CAGR_API_PARAMETERS_PKG.INSERT_ROW(
228: X_ROWID => X_ROW_ID,
229: X_CAGR_API_PARAM_ID => X_CAGR_API_PARAM_ID,
230: X_DEFAULT_UOM => X_DEFAULT_UOM,
231: X_CAGR_API_ID => X_CAGR_API_ID,

Line 273: from PER_CAGR_API_PARAMETERS

269: UOM_PARAMETER,
270: UOM_LOOKUP,
271: HIDDEN,
272: OBJECT_VERSION_NUMBER
273: from PER_CAGR_API_PARAMETERS
274: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID
275: for update of CAGR_API_PARAM_ID nowait;
276: recinfo c%rowtype;
277:

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 348: update PER_CAGR_API_PARAMETERS set

344: X_LAST_UPDATED_BY in NUMBER,
345: X_LAST_UPDATE_LOGIN in NUMBER
346: ) is
347: begin
348: update PER_CAGR_API_PARAMETERS set
349: DEFAULT_UOM = X_DEFAULT_UOM,
350: CAGR_API_ID = X_CAGR_API_ID,
351: PARAMETER_NAME = X_PARAMETER_NAME,
352: DISPLAY_NAME = X_DISPLAY_NAME,

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 393: delete from PER_CAGR_API_PARAMETERS

389: if (sql%notfound) then
390: raise no_data_found;
391: end if;
392:
393: delete from PER_CAGR_API_PARAMETERS
394: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID;
395:
396: if (sql%notfound) then
397: 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 407: from PER_CAGR_API_PARAMETERS B

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
409: );
410:
411: update PER_CAGR_API_PARAMETERS_TL T set (

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:

Line 460: end PER_CAGR_API_PARAMETERS_PKG;

456: where T.CAGR_API_PARAM_ID = B.CAGR_API_PARAM_ID
457: and T.LANGUAGE = L.LANGUAGE_CODE);
458: end ADD_LANGUAGE;
459:
460: end PER_CAGR_API_PARAMETERS_PKG;