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.3 2011/04/28 10:14:35 sidsaxen 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:

Line 77: p_entity_name => 'PER_CAGR_API_PARAMETERS',

73: --
74:
75: BEGIN
76: PER_RIC_PKG.chk_integrity (
77: p_entity_name => 'PER_CAGR_API_PARAMETERS',
78: p_ref_entity => 'PER_CAGR_APIS',
79: p_ref_column_name => 'CAGR_API_ID',
80: p_ref_col_value_number => X_CAGR_API_ID,
81: p_ref_col_value_varchar => NULL,

Line 90: insert into PER_CAGR_API_PARAMETERS (

86: --
87: -- Code Ends Here.
88: --
89:
90: insert into PER_CAGR_API_PARAMETERS (
91: DEFAULT_UOM,
92: CAGR_API_PARAM_ID,
93: DISPLAY_NAME,
94: CAGR_API_ID,

Line 133: p_entity_name => 'PER_CAGR_API_PARAMETERS_TL',

129: --
130:
131: BEGIN
132: PER_RIC_PKG.chk_integrity (
133: p_entity_name => 'PER_CAGR_API_PARAMETERS_TL',
134: p_ref_entity => 'PER_CAGR_API_PARAMETERS',
135: p_ref_column_name => 'CAGR_API_PARAM_ID',
136: p_ref_col_value_number => X_CAGR_API_PARAM_ID,
137: p_ref_col_value_varchar => NULL,

Line 134: p_ref_entity => 'PER_CAGR_API_PARAMETERS',

130:
131: BEGIN
132: PER_RIC_PKG.chk_integrity (
133: p_entity_name => 'PER_CAGR_API_PARAMETERS_TL',
134: p_ref_entity => 'PER_CAGR_API_PARAMETERS',
135: p_ref_column_name => 'CAGR_API_PARAM_ID',
136: p_ref_col_value_number => X_CAGR_API_PARAM_ID,
137: p_ref_col_value_varchar => NULL,
138: p_ref_col_value_date => NULL,

Line 146: insert into PER_CAGR_API_PARAMETERS_TL (

142: --
143: -- Code Ends Here.
144: --
145:
146: insert into PER_CAGR_API_PARAMETERS_TL (
147: LAST_UPDATE_LOGIN,
148: CREATED_BY,
149: CREATION_DATE,
150: LAST_UPDATE_DATE,

Line 170: from PER_CAGR_API_PARAMETERS_TL T

166: from FND_LANGUAGES L
167: where L.INSTALLED_FLAG in ('I', 'B')
168: and not exists
169: (select NULL
170: from PER_CAGR_API_PARAMETERS_TL T
171: where T.CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID
172: and T.LANGUAGE = L.LANGUAGE_CODE);
173:
174: open c;

Line 204: update per_cagr_api_parameters_tl set

200: X_CAGR_API_ID
201: );
202:
203:
204: update per_cagr_api_parameters_tl set
205: display_name = X_display_NAME,
206: last_update_date = sysdate,
207: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
208: last_update_login = 0,

Line 248: PER_CAGR_API_PARAMETERS_PKG.UPDATE_ROW(

244: else
245: user_id := 0;
246: end if;
247:
248: PER_CAGR_API_PARAMETERS_PKG.UPDATE_ROW(
249: X_CAGR_API_PARAM_ID => X_CAGR_API_PARAM_ID,
250: X_DEFAULT_UOM => X_DEFAULT_UOM,
251: X_CAGR_API_ID => X_CAGR_API_ID,
252: X_PARAMETER_NAME => X_PARAMETER_NAME,

Line 268: PER_CAGR_API_PARAMETERS_PKG.INSERT_ROW(

264:
265: exception
266: when NO_DATA_FOUND then
267:
268: PER_CAGR_API_PARAMETERS_PKG.INSERT_ROW(
269: X_ROWID => X_ROW_ID,
270: X_CAGR_API_PARAM_ID => X_CAGR_API_PARAM_ID,
271: X_DEFAULT_UOM => X_DEFAULT_UOM,
272: X_CAGR_API_ID => X_CAGR_API_ID,

Line 314: from PER_CAGR_API_PARAMETERS

310: UOM_PARAMETER,
311: UOM_LOOKUP,
312: HIDDEN,
313: OBJECT_VERSION_NUMBER
314: from PER_CAGR_API_PARAMETERS
315: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID
316: for update of CAGR_API_PARAM_ID nowait;
317: recinfo c%rowtype;
318:

Line 322: from PER_CAGR_API_PARAMETERS_TL

318:
319: cursor c1 is select
320: DISPLAY_NAME,
321: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
322: from PER_CAGR_API_PARAMETERS_TL
323: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID
324: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
325: for update of CAGR_API_PARAM_ID nowait;
326: begin

Line 389: update PER_CAGR_API_PARAMETERS set

385: X_LAST_UPDATED_BY in NUMBER,
386: X_LAST_UPDATE_LOGIN in NUMBER
387: ) is
388: begin
389: update PER_CAGR_API_PARAMETERS set
390: DEFAULT_UOM = X_DEFAULT_UOM,
391: CAGR_API_ID = X_CAGR_API_ID,
392: PARAMETER_NAME = X_PARAMETER_NAME,
393: DISPLAY_NAME = X_DISPLAY_NAME,

Line 409: update PER_CAGR_API_PARAMETERS_TL set

405: if (sql%notfound) then
406: raise no_data_found;
407: end if;
408:
409: update PER_CAGR_API_PARAMETERS_TL set
410: DISPLAY_NAME = X_DISPLAY_NAME,
411: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
412: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
413: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 427: delete from PER_CAGR_API_PARAMETERS_TL

423: procedure DELETE_ROW (
424: X_CAGR_API_PARAM_ID in NUMBER
425: ) is
426: begin
427: delete from PER_CAGR_API_PARAMETERS_TL
428: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID;
429:
430: if (sql%notfound) then
431: raise no_data_found;

Line 440: p_entity_name => 'PER_CAGR_API_PARAMETERS',

436: --
437:
438: BEGIN
439: PER_RIC_PKG.chk_integrity (
440: p_entity_name => 'PER_CAGR_API_PARAMETERS',
441: p_ref_entity => 'PER_CAGR_API_PARAMETERS_TL',
442: p_ref_column_name => 'CAGR_API_PARAM_ID',
443: p_ref_col_value_number => X_CAGR_API_PARAM_ID,
444: p_ref_col_value_varchar => NULL,

Line 441: p_ref_entity => 'PER_CAGR_API_PARAMETERS_TL',

437:
438: BEGIN
439: PER_RIC_PKG.chk_integrity (
440: p_entity_name => 'PER_CAGR_API_PARAMETERS',
441: p_ref_entity => 'PER_CAGR_API_PARAMETERS_TL',
442: p_ref_column_name => 'CAGR_API_PARAM_ID',
443: p_ref_col_value_number => X_CAGR_API_PARAM_ID,
444: p_ref_col_value_varchar => NULL,
445: p_ref_col_value_date => NULL,

Line 452: delete from PER_CAGR_API_PARAMETERS

448: END;
449: --
450: -- Code Ends Here.
451: --
452: delete from PER_CAGR_API_PARAMETERS
453: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID;
454:
455: if (sql%notfound) then
456: raise no_data_found;

Line 463: delete from PER_CAGR_API_PARAMETERS_TL T

459:
460: procedure ADD_LANGUAGE
461: is
462: begin
463: delete from PER_CAGR_API_PARAMETERS_TL T
464: where not exists
465: (select NULL
466: from PER_CAGR_API_PARAMETERS B
467: where B.CAGR_API_PARAM_ID = T.CAGR_API_PARAM_ID

Line 466: from PER_CAGR_API_PARAMETERS B

462: begin
463: delete from PER_CAGR_API_PARAMETERS_TL T
464: where not exists
465: (select NULL
466: from PER_CAGR_API_PARAMETERS B
467: where B.CAGR_API_PARAM_ID = T.CAGR_API_PARAM_ID
468: );
469:
470: update PER_CAGR_API_PARAMETERS_TL T set (

Line 470: update PER_CAGR_API_PARAMETERS_TL T set (

466: from PER_CAGR_API_PARAMETERS B
467: where B.CAGR_API_PARAM_ID = T.CAGR_API_PARAM_ID
468: );
469:
470: update PER_CAGR_API_PARAMETERS_TL T set (
471: DISPLAY_NAME
472: ) = (select
473: B.DISPLAY_NAME
474: from PER_CAGR_API_PARAMETERS_TL B

Line 474: from PER_CAGR_API_PARAMETERS_TL B

470: update PER_CAGR_API_PARAMETERS_TL T set (
471: DISPLAY_NAME
472: ) = (select
473: B.DISPLAY_NAME
474: from PER_CAGR_API_PARAMETERS_TL B
475: where B.CAGR_API_PARAM_ID = T.CAGR_API_PARAM_ID
476: and B.LANGUAGE = T.SOURCE_LANG)
477: where (
478: T.CAGR_API_PARAM_ID,

Line 483: from PER_CAGR_API_PARAMETERS_TL SUBB, PER_CAGR_API_PARAMETERS_TL SUBT

479: T.LANGUAGE
480: ) in (select
481: SUBT.CAGR_API_PARAM_ID,
482: SUBT.LANGUAGE
483: from PER_CAGR_API_PARAMETERS_TL SUBB, PER_CAGR_API_PARAMETERS_TL SUBT
484: where SUBB.CAGR_API_PARAM_ID = SUBT.CAGR_API_PARAM_ID
485: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
486: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
487: ));

Line 489: insert into PER_CAGR_API_PARAMETERS_TL (

485: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
486: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
487: ));
488:
489: insert into PER_CAGR_API_PARAMETERS_TL (
490: LAST_UPDATE_LOGIN,
491: CREATED_BY,
492: CREATION_DATE,
493: LAST_UPDATE_DATE,

Line 509: from PER_CAGR_API_PARAMETERS_TL B, FND_LANGUAGES L

505: B.CAGR_API_PARAM_ID,
506: B.DISPLAY_NAME,
507: L.LANGUAGE_CODE,
508: B.SOURCE_LANG
509: from PER_CAGR_API_PARAMETERS_TL B, FND_LANGUAGES L
510: where L.INSTALLED_FLAG in ('I', 'B')
511: and B.LANGUAGE = userenv('LANG')
512: and not exists
513: (select NULL

Line 514: from PER_CAGR_API_PARAMETERS_TL T

510: where L.INSTALLED_FLAG in ('I', 'B')
511: and B.LANGUAGE = userenv('LANG')
512: and not exists
513: (select NULL
514: from PER_CAGR_API_PARAMETERS_TL T
515: where T.CAGR_API_PARAM_ID = B.CAGR_API_PARAM_ID
516: and T.LANGUAGE = L.LANGUAGE_CODE);
517: end ADD_LANGUAGE;
518:

Line 519: end PER_CAGR_API_PARAMETERS_PKG;

515: where T.CAGR_API_PARAM_ID = B.CAGR_API_PARAM_ID
516: and T.LANGUAGE = L.LANGUAGE_CODE);
517: end ADD_LANGUAGE;
518:
519: end PER_CAGR_API_PARAMETERS_PKG;