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_APIS_PKG dependencies on PER_CAGR_APIS

Line 1: package body PER_CAGR_APIS_PKG as

1: package body PER_CAGR_APIS_PKG as
2: /* $Header: peapilct.pkb 120.2 2011/04/28 10:18:02 sidsaxen ship $ */
3:
4: procedure KEY_TO_IDS (
5: X_API_NAME in VARCHAR2,

Line 14: from PER_CAGR_APIS API

10: cursor CSR_CAGR_API_NAME (
11: X_API_NAME VARCHAR2
12: ) is
13: select API.CAGR_API_ID
14: from PER_CAGR_APIS API
15: where API.API_NAME = X_API_NAME;
16:
17: cursor CSR_SEQUENCE is
18: select PER_CAGR_APIS_S.nextval

Line 18: select PER_CAGR_APIS_S.nextval

14: from PER_CAGR_APIS API
15: where API.API_NAME = X_API_NAME;
16:
17: cursor CSR_SEQUENCE is
18: select PER_CAGR_APIS_S.nextval
19: from dual;
20:
21: begin
22:

Line 45: cursor C is select ROWID from PER_CAGR_APIS

41: X_LAST_UPDATE_DATE in DATE,
42: X_LAST_UPDATED_BY in NUMBER,
43: X_LAST_UPDATE_LOGIN in NUMBER
44: ) is
45: cursor C is select ROWID from PER_CAGR_APIS
46: where CAGR_API_ID = X_CAGR_API_ID
47: ;
48: begin
49: insert into PER_CAGR_APIS (

Line 49: insert into PER_CAGR_APIS (

45: cursor C is select ROWID from PER_CAGR_APIS
46: where CAGR_API_ID = X_CAGR_API_ID
47: ;
48: begin
49: insert into PER_CAGR_APIS (
50: OBJECT_VERSION_NUMBER,
51: CATEGORY_NAME,
52: API_NAME,
53: CAGR_API_ID,

Line 78: p_entity_name => 'PER_CAGR_APIS_TL',

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

Line 79: p_ref_entity => 'PER_CAGR_APIS',

75:
76: BEGIN
77: PER_RIC_PKG.chk_integrity (
78: p_entity_name => 'PER_CAGR_APIS_TL',
79: p_ref_entity => 'PER_CAGR_APIS',
80: p_ref_column_name => 'CAGR_API_ID',
81: p_ref_col_value_number => X_CAGR_API_ID,
82: p_ref_col_value_varchar => NULL,
83: p_ref_col_value_date => NULL,

Line 91: insert into PER_CAGR_APIS_TL (

87: --
88: -- Code Ends Here.
89: --
90:
91: insert into PER_CAGR_APIS_TL (
92: LAST_UPDATE_DATE,
93: LAST_UPDATED_BY,
94: CAGR_API_ID,
95: API_NAME,

Line 115: from PER_CAGR_APIS_TL T

111: from FND_LANGUAGES L
112: where L.INSTALLED_FLAG in ('I', 'B')
113: and not exists
114: (select NULL
115: from PER_CAGR_APIS_TL T
116: where T.CAGR_API_ID = X_CAGR_API_ID
117: and T.LANGUAGE = L.LANGUAGE_CODE);
118:
119: open c;

Line 144: update per_cagr_apis_tl set

140: X_CAGR_API_ID
141: );
142:
143:
144: update per_cagr_apis_tl set
145: api_name = X_API_NAME,
146: last_update_date = sysdate,
147: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
148: last_update_login = 0,

Line 179: PER_CAGR_APIS_PKG.UPDATE_ROW (

175: else
176: user_id := 0;
177: end if;
178:
179: PER_CAGR_APIS_PKG.UPDATE_ROW (
180: X_CAGR_API_ID => X_CAGR_API_ID,
181: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
182: X_CATEGORY_NAME => X_CATEGORY_NAME,
183: X_API_NAME => X_API_NAME,

Line 192: PER_CAGR_APIS_PKG.INSERT_ROW(

188: exception
189: when NO_DATA_FOUND then
190:
191:
192: PER_CAGR_APIS_PKG.INSERT_ROW(
193: X_ROWID => X_ROW_ID,
194: X_CAGR_API_ID => X_CAGR_API_ID,
195: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
196: X_CATEGORY_NAME => X_CATEGORY_NAME,

Line 216: from PER_CAGR_APIS

212: ) is
213: cursor c is select
214: OBJECT_VERSION_NUMBER,
215: CATEGORY_NAME
216: from PER_CAGR_APIS
217: where CAGR_API_ID = X_CAGR_API_ID
218: for update of CAGR_API_ID nowait;
219: recinfo c%rowtype;
220:

Line 224: from PER_CAGR_APIS_TL

220:
221: cursor c1 is select
222: API_NAME,
223: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
224: from PER_CAGR_APIS_TL
225: where CAGR_API_ID = X_CAGR_API_ID
226: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
227: for update of CAGR_API_ID nowait;
228: begin

Line 270: update PER_CAGR_APIS set

266: X_LAST_UPDATED_BY in NUMBER,
267: X_LAST_UPDATE_LOGIN in NUMBER
268: ) is
269: begin
270: update PER_CAGR_APIS set
271: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
272: CATEGORY_NAME = X_CATEGORY_NAME,
273: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
274: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 282: update PER_CAGR_APIS_TL set

278: if (sql%notfound) then
279: raise no_data_found;
280: end if;
281:
282: update PER_CAGR_APIS_TL set
283: API_NAME = X_API_NAME,
284: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
285: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
286: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 300: delete from PER_CAGR_APIS_TL

296: procedure DELETE_ROW (
297: X_CAGR_API_ID in NUMBER
298: ) is
299: begin
300: delete from PER_CAGR_APIS_TL
301: where CAGR_API_ID = X_CAGR_API_ID;
302:
303: if (sql%notfound) then
304: raise no_data_found;

Line 313: p_entity_name => 'PER_CAGR_APIS',

309: --
310:
311: BEGIN
312: PER_RIC_PKG.chk_integrity (
313: p_entity_name => 'PER_CAGR_APIS',
314: p_ref_entity => 'PER_CAGR_APIS_TL',
315: p_ref_column_name => 'CAGR_API_ID',
316: p_ref_col_value_number => X_CAGR_API_ID,
317: p_ref_col_value_varchar => NULL,

Line 314: p_ref_entity => 'PER_CAGR_APIS_TL',

310:
311: BEGIN
312: PER_RIC_PKG.chk_integrity (
313: p_entity_name => 'PER_CAGR_APIS',
314: p_ref_entity => 'PER_CAGR_APIS_TL',
315: p_ref_column_name => 'CAGR_API_ID',
316: p_ref_col_value_number => X_CAGR_API_ID,
317: p_ref_col_value_varchar => NULL,
318: p_ref_col_value_date => NULL,

Line 325: delete from PER_CAGR_APIS

321: END;
322: --
323: -- Code Ends Here.
324: --
325: delete from PER_CAGR_APIS
326: where CAGR_API_ID = X_CAGR_API_ID;
327:
328: if (sql%notfound) then
329: raise no_data_found;

Line 336: delete from PER_CAGR_APIS_TL T

332:
333: procedure ADD_LANGUAGE
334: is
335: begin
336: delete from PER_CAGR_APIS_TL T
337: where not exists
338: (select NULL
339: from PER_CAGR_APIS B
340: where B.CAGR_API_ID = T.CAGR_API_ID

Line 339: from PER_CAGR_APIS B

335: begin
336: delete from PER_CAGR_APIS_TL T
337: where not exists
338: (select NULL
339: from PER_CAGR_APIS B
340: where B.CAGR_API_ID = T.CAGR_API_ID
341: );
342:
343: update PER_CAGR_APIS_TL T set (

Line 343: update PER_CAGR_APIS_TL T set (

339: from PER_CAGR_APIS B
340: where B.CAGR_API_ID = T.CAGR_API_ID
341: );
342:
343: update PER_CAGR_APIS_TL T set (
344: API_NAME
345: ) = (select
346: B.API_NAME
347: from PER_CAGR_APIS_TL B

Line 347: from PER_CAGR_APIS_TL B

343: update PER_CAGR_APIS_TL T set (
344: API_NAME
345: ) = (select
346: B.API_NAME
347: from PER_CAGR_APIS_TL B
348: where B.CAGR_API_ID = T.CAGR_API_ID
349: and B.LANGUAGE = T.SOURCE_LANG)
350: where (
351: T.CAGR_API_ID,

Line 356: from PER_CAGR_APIS_TL SUBB, PER_CAGR_APIS_TL SUBT

352: T.LANGUAGE
353: ) in (select
354: SUBT.CAGR_API_ID,
355: SUBT.LANGUAGE
356: from PER_CAGR_APIS_TL SUBB, PER_CAGR_APIS_TL SUBT
357: where SUBB.CAGR_API_ID = SUBT.CAGR_API_ID
358: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
359: and (SUBB.API_NAME <> SUBT.API_NAME
360: ));

Line 362: insert into PER_CAGR_APIS_TL (

358: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
359: and (SUBB.API_NAME <> SUBT.API_NAME
360: ));
361:
362: insert into PER_CAGR_APIS_TL (
363: LAST_UPDATE_DATE,
364: LAST_UPDATED_BY,
365: CAGR_API_ID,
366: API_NAME,

Line 382: from PER_CAGR_APIS_TL B, FND_LANGUAGES L

378: B.CREATED_BY,
379: B.CREATION_DATE,
380: L.LANGUAGE_CODE,
381: B.SOURCE_LANG
382: from PER_CAGR_APIS_TL B, FND_LANGUAGES L
383: where L.INSTALLED_FLAG in ('I', 'B')
384: and B.LANGUAGE = userenv('LANG')
385: and not exists
386: (select NULL

Line 387: from PER_CAGR_APIS_TL T

383: where L.INSTALLED_FLAG in ('I', 'B')
384: and B.LANGUAGE = userenv('LANG')
385: and not exists
386: (select NULL
387: from PER_CAGR_APIS_TL T
388: where T.CAGR_API_ID = B.CAGR_API_ID
389: and T.LANGUAGE = L.LANGUAGE_CODE);
390: end ADD_LANGUAGE;
391:

Line 393: end PER_CAGR_APIS_PKG;

389: and T.LANGUAGE = L.LANGUAGE_CODE);
390: end ADD_LANGUAGE;
391:
392:
393: end PER_CAGR_APIS_PKG;