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_UCX_LOAD_API dependencies on HR_KI_UI_CONTEXTS

Line 20: update HR_KI_UI_CONTEXTS

16: ) is
17:
18: begin
19:
20: update HR_KI_UI_CONTEXTS
21: set
22: LABEL = X_LABEL,
23: LOCATION=X_LOCATION,
24: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 47: cursor C is select ROWID from HR_KI_UI_CONTEXTS

43: X_LAST_UPDATE_LOGIN in NUMBER
44:
45: ) is
46:
47: cursor C is select ROWID from HR_KI_UI_CONTEXTS
48: where ui_context_id = x_ui_context_id;
49:
50: begin
51:

Line 52: select HR_KI_UI_CONTEXTS_S.NEXTVAL into x_ui_context_id from sys.dual;

48: where ui_context_id = x_ui_context_id;
49:
50: begin
51:
52: select HR_KI_UI_CONTEXTS_S.NEXTVAL into x_ui_context_id from sys.dual;
53:
54: insert into HR_KI_UI_CONTEXTS (
55: ui_context_id,
56: ui_context_key,

Line 54: insert into HR_KI_UI_CONTEXTS (

50: begin
51:
52: select HR_KI_UI_CONTEXTS_S.NEXTVAL into x_ui_context_id from sys.dual;
53:
54: insert into HR_KI_UI_CONTEXTS (
55: ui_context_id,
56: ui_context_key,
57: user_interface_id,
58: label,

Line 86: 'HR_KI_UI_CONTEXTS.insert_row');

82: if (c%notfound) then
83: close c;
84: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
85: hr_utility.set_message_token('PROCEDURE',
86: 'HR_KI_UI_CONTEXTS.insert_row');
87: hr_utility.set_message_token('STEP','1');
88: hr_utility.raise_error;
89: end if;
90: close c;

Line 139: l_created_by HR_KI_UI_CONTEXTS.created_by%TYPE := 0;

135: )
136: is
137: l_proc VARCHAR2(31) := 'HR_KI_UCX_LOAD_API.LOAD_ROW';
138: l_rowid rowid;
139: l_created_by HR_KI_UI_CONTEXTS.created_by%TYPE := 0;
140: l_creation_date HR_KI_UI_CONTEXTS.creation_date%TYPE := SYSDATE;
141: l_last_update_date HR_KI_UI_CONTEXTS.last_update_date%TYPE := SYSDATE;
142: l_last_updated_by HR_KI_UI_CONTEXTS.last_updated_by%TYPE := 0;
143: l_last_update_login HR_KI_UI_CONTEXTS.last_update_login%TYPE := 0;

Line 140: l_creation_date HR_KI_UI_CONTEXTS.creation_date%TYPE := SYSDATE;

136: is
137: l_proc VARCHAR2(31) := 'HR_KI_UCX_LOAD_API.LOAD_ROW';
138: l_rowid rowid;
139: l_created_by HR_KI_UI_CONTEXTS.created_by%TYPE := 0;
140: l_creation_date HR_KI_UI_CONTEXTS.creation_date%TYPE := SYSDATE;
141: l_last_update_date HR_KI_UI_CONTEXTS.last_update_date%TYPE := SYSDATE;
142: l_last_updated_by HR_KI_UI_CONTEXTS.last_updated_by%TYPE := 0;
143: l_last_update_login HR_KI_UI_CONTEXTS.last_update_login%TYPE := 0;
144: l_ui_context_id HR_KI_UI_CONTEXTS.ui_context_id%TYPE;

Line 141: l_last_update_date HR_KI_UI_CONTEXTS.last_update_date%TYPE := SYSDATE;

137: l_proc VARCHAR2(31) := 'HR_KI_UCX_LOAD_API.LOAD_ROW';
138: l_rowid rowid;
139: l_created_by HR_KI_UI_CONTEXTS.created_by%TYPE := 0;
140: l_creation_date HR_KI_UI_CONTEXTS.creation_date%TYPE := SYSDATE;
141: l_last_update_date HR_KI_UI_CONTEXTS.last_update_date%TYPE := SYSDATE;
142: l_last_updated_by HR_KI_UI_CONTEXTS.last_updated_by%TYPE := 0;
143: l_last_update_login HR_KI_UI_CONTEXTS.last_update_login%TYPE := 0;
144: l_ui_context_id HR_KI_UI_CONTEXTS.ui_context_id%TYPE;
145: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;

Line 142: l_last_updated_by HR_KI_UI_CONTEXTS.last_updated_by%TYPE := 0;

138: l_rowid rowid;
139: l_created_by HR_KI_UI_CONTEXTS.created_by%TYPE := 0;
140: l_creation_date HR_KI_UI_CONTEXTS.creation_date%TYPE := SYSDATE;
141: l_last_update_date HR_KI_UI_CONTEXTS.last_update_date%TYPE := SYSDATE;
142: l_last_updated_by HR_KI_UI_CONTEXTS.last_updated_by%TYPE := 0;
143: l_last_update_login HR_KI_UI_CONTEXTS.last_update_login%TYPE := 0;
144: l_ui_context_id HR_KI_UI_CONTEXTS.ui_context_id%TYPE;
145: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;
146: l_object_version_number HR_KI_OPTION_TYPES.object_version_number%TYPE;

Line 143: l_last_update_login HR_KI_UI_CONTEXTS.last_update_login%TYPE := 0;

139: l_created_by HR_KI_UI_CONTEXTS.created_by%TYPE := 0;
140: l_creation_date HR_KI_UI_CONTEXTS.creation_date%TYPE := SYSDATE;
141: l_last_update_date HR_KI_UI_CONTEXTS.last_update_date%TYPE := SYSDATE;
142: l_last_updated_by HR_KI_UI_CONTEXTS.last_updated_by%TYPE := 0;
143: l_last_update_login HR_KI_UI_CONTEXTS.last_update_login%TYPE := 0;
144: l_ui_context_id HR_KI_UI_CONTEXTS.ui_context_id%TYPE;
145: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;
146: l_object_version_number HR_KI_OPTION_TYPES.object_version_number%TYPE;
147:

Line 144: l_ui_context_id HR_KI_UI_CONTEXTS.ui_context_id%TYPE;

140: l_creation_date HR_KI_UI_CONTEXTS.creation_date%TYPE := SYSDATE;
141: l_last_update_date HR_KI_UI_CONTEXTS.last_update_date%TYPE := SYSDATE;
142: l_last_updated_by HR_KI_UI_CONTEXTS.last_updated_by%TYPE := 0;
143: l_last_update_login HR_KI_UI_CONTEXTS.last_update_login%TYPE := 0;
144: l_ui_context_id HR_KI_UI_CONTEXTS.ui_context_id%TYPE;
145: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;
146: l_object_version_number HR_KI_OPTION_TYPES.object_version_number%TYPE;
147:
148:

Line 154: from HR_KI_UI_CONTEXTS uic,

150: db_ludate date; -- entity update date in db
151:
152: CURSOR C_APPL IS
153: select uic.ui_context_id,uic.object_version_number
154: from HR_KI_UI_CONTEXTS uic,
155: hr_ki_user_interfaces uit
156: where uic.user_interface_id = uit.user_interface_id
157: and upper(uic.ui_context_key)=upper(x_ui_context_key)
158: and upper(uit.user_interface_key)=upper(x_user_interface_key);

Line 207: from HR_KI_UI_CONTEXTS

203: else
204: close C_APPL;
205: select LAST_UPDATED_BY, LAST_UPDATE_DATE
206: into db_luby, db_ludate
207: from HR_KI_UI_CONTEXTS
208: where ui_context_id = l_ui_context_id;
209:
210:
211: if (fnd_load_util.upload_test(l_last_updated_by, l_last_update_date, db_luby,