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.HR_TCP_PKG dependencies on HR_TEMPLATE_ITEM_CONTEXT_PAGES

Line 35: cursor C is select ROWID from HR_TEMPLATE_ITEM_CONTEXT_PAGES

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from HR_TEMPLATE_ITEM_CONTEXT_PAGES
36: where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID
37: ;
38: begin
39:

Line 47: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',

43: --
44:
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(

Line 61: insert into HR_TEMPLATE_ITEM_CONTEXT_PAGES (

57: --
58: -- Code Ends Here.
59: --
60:
61: insert into HR_TEMPLATE_ITEM_CONTEXT_PAGES (
62: CREATION_DATE,
63: TEMPLATE_ITEM_CONTEXT_PAGE_ID,
64: OBJECT_VERSION_NUMBER,
65: TEMPLATE_ITEM_CONTEXT_ID,

Line 102: from HR_TEMPLATE_ITEM_CONTEXT_PAGES

98: cursor c1 is select
99: TEMPLATE_ITEM_CONTEXT_PAGE_ID,
100: OBJECT_VERSION_NUMBER,
101: TEMPLATE_TAB_PAGE_ID
102: from HR_TEMPLATE_ITEM_CONTEXT_PAGES
103: where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID
104: for update of TEMPLATE_ITEM_CONTEXT_ID nowait;
105: begin
106: for tlinfo in c1 loop

Line 130: update HR_TEMPLATE_ITEM_CONTEXT_PAGES set

126: X_LAST_UPDATED_BY in NUMBER,
127: X_LAST_UPDATE_LOGIN in NUMBER
128: ) is
129: begin
130: update HR_TEMPLATE_ITEM_CONTEXT_PAGES set
131: TEMPLATE_ITEM_CONTEXT_PAGE_ID = X_TEMPLATE_ITEM_CONTEXT_PAGE_I,
132: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
133: TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID,
134: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 148: delete from HR_TEMPLATE_ITEM_CONTEXT_PAGES

144: procedure DELETE_ROW (
145: X_TEMPLATE_ITEM_CONTEXT_ID in NUMBER
146: ) is
147: begin
148: delete from HR_TEMPLATE_ITEM_CONTEXT_PAGES
149: where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID;
150:
151: if (sql%notfound) then
152: raise no_data_found;

Line 427: from hr_template_item_context_pages

423: begin
424:
425: select template_item_context_page_id
426: into x_tcp_id
427: from hr_template_item_context_pages
428: where template_tab_page_id = x_template_tab_page_id
429: and template_item_context_id = x_template_item_context_id;
430: -- row has been found so perform update
431: update HR_TEMPLATE_ITEM_CONTEXT_PAGES

Line 431: update HR_TEMPLATE_ITEM_CONTEXT_PAGES

427: from hr_template_item_context_pages
428: where template_tab_page_id = x_template_tab_page_id
429: and template_item_context_id = x_template_item_context_id;
430: -- row has been found so perform update
431: update HR_TEMPLATE_ITEM_CONTEXT_PAGES
432: set TEMPLATE_ITEM_CONTEXT_PAGE_ID = x_tcp_id,
433: OBJECT_VERSION_NUMBER = TO_NUMBER (x_object_version_number),
434: TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID,
435: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 449: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',

445: --
446:
447: BEGIN
448: PER_RIC_PKG.chk_integrity (
449: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
450: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
451: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
452: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
453: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(

Line 462: insert into HR_TEMPLATE_ITEM_CONTEXT_PAGES (

458: END;
459: --
460: -- Code Ends Here.
461: --
462: insert into HR_TEMPLATE_ITEM_CONTEXT_PAGES (
463: CREATION_DATE,
464: TEMPLATE_ITEM_CONTEXT_PAGE_ID,
465: OBJECT_VERSION_NUMBER,
466: TEMPLATE_ITEM_CONTEXT_ID,