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_KI_HNM_LOAD_API dependencies on HR_KI_HIERARCHY_NODE_MAPS

Line 23: cursor C is select ROWID from HR_KI_HIERARCHY_NODE_MAPS

19: X_LAST_UPDATE_LOGIN in NUMBER
20:
21: ) is
22:
23: cursor C is select ROWID from HR_KI_HIERARCHY_NODE_MAPS
24: where hierarchy_node_map_id = x_hierarchy_node_map_id;
25:
26: begin
27:

Line 28: select HR_KI_HIERARCHY_NODE_MAPS_S.NEXTVAL into x_hierarchy_node_map_id from sys.dual;

24: where hierarchy_node_map_id = x_hierarchy_node_map_id;
25:
26: begin
27:
28: select HR_KI_HIERARCHY_NODE_MAPS_S.NEXTVAL into x_hierarchy_node_map_id from sys.dual;
29:
30: insert into HR_KI_HIERARCHY_NODE_MAPS (
31: hierarchy_node_map_id,
32: TOPIC_ID,

Line 30: insert into HR_KI_HIERARCHY_NODE_MAPS (

26: begin
27:
28: select HR_KI_HIERARCHY_NODE_MAPS_S.NEXTVAL into x_hierarchy_node_map_id from sys.dual;
29:
30: insert into HR_KI_HIERARCHY_NODE_MAPS (
31: hierarchy_node_map_id,
32: TOPIC_ID,
33: HIERARCHY_ID,
34: USER_INTERFACE_ID,

Line 60: 'HR_KI_HIERARCHY_NODE_MAPS.insert_row');

56: if (c%notfound) then
57: close c;
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE',
60: 'HR_KI_HIERARCHY_NODE_MAPS.insert_row');
61: hr_utility.set_message_token('STEP','1');
62: hr_utility.raise_error;
63: end if;
64: close c;

Line 153: l_created_by HR_KI_HIERARCHY_NODE_MAPS.created_by%TYPE := 0;

149: )
150: is
151: l_proc VARCHAR2(31) := 'HR_KI_HNM_LOAD_API.LOAD_ROW';
152: l_rowid rowid;
153: l_created_by HR_KI_HIERARCHY_NODE_MAPS.created_by%TYPE := 0;
154: l_creation_date HR_KI_HIERARCHY_NODE_MAPS.creation_date%TYPE := SYSDATE;
155: l_last_update_date HR_KI_HIERARCHY_NODE_MAPS.last_update_date%TYPE := SYSDATE;
156: l_last_updated_by HR_KI_HIERARCHY_NODE_MAPS.last_updated_by%TYPE := 0;
157: l_last_update_login HR_KI_HIERARCHY_NODE_MAPS.last_update_login%TYPE := 0;

Line 154: l_creation_date HR_KI_HIERARCHY_NODE_MAPS.creation_date%TYPE := SYSDATE;

150: is
151: l_proc VARCHAR2(31) := 'HR_KI_HNM_LOAD_API.LOAD_ROW';
152: l_rowid rowid;
153: l_created_by HR_KI_HIERARCHY_NODE_MAPS.created_by%TYPE := 0;
154: l_creation_date HR_KI_HIERARCHY_NODE_MAPS.creation_date%TYPE := SYSDATE;
155: l_last_update_date HR_KI_HIERARCHY_NODE_MAPS.last_update_date%TYPE := SYSDATE;
156: l_last_updated_by HR_KI_HIERARCHY_NODE_MAPS.last_updated_by%TYPE := 0;
157: l_last_update_login HR_KI_HIERARCHY_NODE_MAPS.last_update_login%TYPE := 0;
158: l_hierarchy_node_map_id HR_KI_HIERARCHY_NODE_MAPS.hierarchy_node_map_id%TYPE;

Line 155: l_last_update_date HR_KI_HIERARCHY_NODE_MAPS.last_update_date%TYPE := SYSDATE;

151: l_proc VARCHAR2(31) := 'HR_KI_HNM_LOAD_API.LOAD_ROW';
152: l_rowid rowid;
153: l_created_by HR_KI_HIERARCHY_NODE_MAPS.created_by%TYPE := 0;
154: l_creation_date HR_KI_HIERARCHY_NODE_MAPS.creation_date%TYPE := SYSDATE;
155: l_last_update_date HR_KI_HIERARCHY_NODE_MAPS.last_update_date%TYPE := SYSDATE;
156: l_last_updated_by HR_KI_HIERARCHY_NODE_MAPS.last_updated_by%TYPE := 0;
157: l_last_update_login HR_KI_HIERARCHY_NODE_MAPS.last_update_login%TYPE := 0;
158: l_hierarchy_node_map_id HR_KI_HIERARCHY_NODE_MAPS.hierarchy_node_map_id%TYPE;
159:

Line 156: l_last_updated_by HR_KI_HIERARCHY_NODE_MAPS.last_updated_by%TYPE := 0;

152: l_rowid rowid;
153: l_created_by HR_KI_HIERARCHY_NODE_MAPS.created_by%TYPE := 0;
154: l_creation_date HR_KI_HIERARCHY_NODE_MAPS.creation_date%TYPE := SYSDATE;
155: l_last_update_date HR_KI_HIERARCHY_NODE_MAPS.last_update_date%TYPE := SYSDATE;
156: l_last_updated_by HR_KI_HIERARCHY_NODE_MAPS.last_updated_by%TYPE := 0;
157: l_last_update_login HR_KI_HIERARCHY_NODE_MAPS.last_update_login%TYPE := 0;
158: l_hierarchy_node_map_id HR_KI_HIERARCHY_NODE_MAPS.hierarchy_node_map_id%TYPE;
159:
160:

Line 157: l_last_update_login HR_KI_HIERARCHY_NODE_MAPS.last_update_login%TYPE := 0;

153: l_created_by HR_KI_HIERARCHY_NODE_MAPS.created_by%TYPE := 0;
154: l_creation_date HR_KI_HIERARCHY_NODE_MAPS.creation_date%TYPE := SYSDATE;
155: l_last_update_date HR_KI_HIERARCHY_NODE_MAPS.last_update_date%TYPE := SYSDATE;
156: l_last_updated_by HR_KI_HIERARCHY_NODE_MAPS.last_updated_by%TYPE := 0;
157: l_last_update_login HR_KI_HIERARCHY_NODE_MAPS.last_update_login%TYPE := 0;
158: l_hierarchy_node_map_id HR_KI_HIERARCHY_NODE_MAPS.hierarchy_node_map_id%TYPE;
159:
160:
161: l_topic_id HR_KI_TOPICS.topic_id%TYPE;

Line 158: l_hierarchy_node_map_id HR_KI_HIERARCHY_NODE_MAPS.hierarchy_node_map_id%TYPE;

154: l_creation_date HR_KI_HIERARCHY_NODE_MAPS.creation_date%TYPE := SYSDATE;
155: l_last_update_date HR_KI_HIERARCHY_NODE_MAPS.last_update_date%TYPE := SYSDATE;
156: l_last_updated_by HR_KI_HIERARCHY_NODE_MAPS.last_updated_by%TYPE := 0;
157: l_last_update_login HR_KI_HIERARCHY_NODE_MAPS.last_update_login%TYPE := 0;
158: l_hierarchy_node_map_id HR_KI_HIERARCHY_NODE_MAPS.hierarchy_node_map_id%TYPE;
159:
160:
161: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
162: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;

Line 170: from hr_ki_hierarchy_node_maps nm,

166: db_ludate date; -- entity update date in db
167:
168: CURSOR C_APPL IS
169: select nm.hierarchy_node_map_id
170: from hr_ki_hierarchy_node_maps nm,
171: hr_ki_hierarchies h,
172: hr_ki_topics top
173: where nm.hierarchy_id = h.hierarchy_id
174: and nm.topic_id = top.topic_id

Line 182: from hr_ki_hierarchy_node_maps nm,

178: h.hierarchy_key = x_hierarchy_key
179:
180: union
181: select nm.hierarchy_node_map_id
182: from hr_ki_hierarchy_node_maps nm,
183: hr_ki_topics top,
184: hr_ki_user_interfaces ui
185: where nm.topic_id = top.topic_id
186: and nm.user_interface_id = ui.user_interface_id

Line 192: from hr_ki_hierarchy_node_maps nm,

188: and ui.user_interface_key =x_user_interface_key
189:
190: union
191: select nm.hierarchy_node_map_id
192: from hr_ki_hierarchy_node_maps nm,
193: hr_ki_user_interfaces ui,
194: hr_ki_hierarchies hi
195: where nm.hierarchy_id = hi.hierarchy_id
196: and nm.user_interface_id = ui.user_interface_id