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_TEMPLATE_ITEM_CONTEXTS_PKG dependencies on HR_TEMPLATE_ITEM_CONTEXTS_B

Line 36: cursor C is select ROWID from HR_TEMPLATE_ITEM_CONTEXTS_B

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

Line 48: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',

44: --
45:
46: BEGIN
47: PER_RIC_PKG.chk_integrity (
48: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
49: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
50: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
51: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
52: PER_RIC_PKG.ref_info_rec('HR_ITEM_CONTEXTS', PER_RIC_PKG.column_info_tbl(

Line 62: insert into HR_TEMPLATE_ITEM_CONTEXTS_B (

58: --
59: -- Code Ends Here.
60: --
61:
62: insert into HR_TEMPLATE_ITEM_CONTEXTS_B (
63: TEMPLATE_ITEM_CONTEXT_ID,
64: OBJECT_VERSION_NUMBER,
65: TEMPLATE_ITEM_ID,
66: CONTEXT_TYPE,

Line 107: from HR_TEMPLATE_ITEM_CONTEXTS_B

103: OBJECT_VERSION_NUMBER,
104: TEMPLATE_ITEM_ID,
105: CONTEXT_TYPE,
106: ITEM_CONTEXT_ID
107: from HR_TEMPLATE_ITEM_CONTEXTS_B
108: where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID
109: for update of TEMPLATE_ITEM_CONTEXT_ID nowait;
110: begin
111: for tlinfo in c1 loop

Line 137: update HR_TEMPLATE_ITEM_CONTEXTS_B set

133: X_LAST_UPDATED_BY in NUMBER,
134: X_LAST_UPDATE_LOGIN in NUMBER
135: ) is
136: begin
137: update HR_TEMPLATE_ITEM_CONTEXTS_B set
138: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
139: TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID,
140: CONTEXT_TYPE = X_CONTEXT_TYPE,
141: ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID,

Line 164: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',

160: --
161:
162: BEGIN
163: PER_RIC_PKG.chk_integrity (
164: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXT_PAGES', PER_RIC_PKG.column_info_tbl(

Line 177: delete from HR_TEMPLATE_ITEM_CONTEXTS_B

173: END;
174: --
175: -- Code Ends Here.
176: --
177: delete from HR_TEMPLATE_ITEM_CONTEXTS_B
178: where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID;
179:
180: if (sql%notfound) then
181: raise no_data_found;

Line 325: from hr_template_item_contexts_b ticb

321:
322: begin
323: select template_item_context_id
324: into x_template_item_context_id
325: from hr_template_item_contexts_b ticb
326: where ticb.template_item_id = x_template_item_id
327: and ticb.item_context_id = x_item_context_id;
328: exception
329: when no_data_found then

Line 330: select hr_template_item_contexts_b_s.nextval

326: where ticb.template_item_id = x_template_item_id
327: and ticb.item_context_id = x_item_context_id;
328: exception
329: when no_data_found then
330: select hr_template_item_contexts_b_s.nextval
331: into x_template_item_context_id
332: from dual;
333: end;
334: