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_OTY_LOAD_API dependencies on HR_KI_OPTION_TYPES

Line 24: update HR_KI_OPTION_TYPES

20:
21: begin
22:
23:
24: update HR_KI_OPTION_TYPES
25: set
26: DISPLAY_TYPE = X_DISPLAY_TYPE,
27: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
28: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 34: update HR_KI_OPTION_TYPES_TL set

30: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER+1
31: where OPTION_TYPE_ID = X_OPTION_TYPE_ID;
32:
33:
34: update HR_KI_OPTION_TYPES_TL set
35: OPTION_NAME = X_OPTION_NAME,
36: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
37: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
38: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 45: insert into HR_KI_OPTION_TYPES_TL (

41: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
42:
43: if (sql%notfound) then
44:
45: insert into HR_KI_OPTION_TYPES_TL (
46: OPTION_TYPE_ID,
47: OPTION_NAME,
48: CREATED_BY,
49: CREATION_DATE,

Line 69: from HR_KI_OPTION_TYPES_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from HR_KI_OPTION_TYPES_TL T
70: where T.OPTION_TYPE_ID = X_OPTION_TYPE_ID
71: and T.LANGUAGE = L.LANGUAGE_CODE);
72:
73: end if;

Line 91: cursor C is select ROWID from HR_KI_OPTION_TYPES

87: X_LAST_UPDATED_BY in NUMBER,
88: X_LAST_UPDATE_LOGIN in NUMBER
89: ) is
90:
91: cursor C is select ROWID from HR_KI_OPTION_TYPES
92: where option_type_id = X_OPTION_TYPE_ID;
93:
94: begin
95:

Line 96: select HR_KI_OPTION_TYPES_S.NEXTVAL into X_OPTION_TYPE_ID from sys.dual;

92: where option_type_id = X_OPTION_TYPE_ID;
93:
94: begin
95:
96: select HR_KI_OPTION_TYPES_S.NEXTVAL into X_OPTION_TYPE_ID from sys.dual;
97:
98: insert into HR_KI_OPTION_TYPES (
99: OPTION_TYPE_ID,
100: OPTION_TYPE_KEY,

Line 98: insert into HR_KI_OPTION_TYPES (

94: begin
95:
96: select HR_KI_OPTION_TYPES_S.NEXTVAL into X_OPTION_TYPE_ID from sys.dual;
97:
98: insert into HR_KI_OPTION_TYPES (
99: OPTION_TYPE_ID,
100: OPTION_TYPE_KEY,
101: DISPLAY_TYPE,
102: CREATION_DATE,

Line 121: insert into HR_KI_OPTION_TYPES_TL (

117: 1
118: );
119:
120:
121: insert into HR_KI_OPTION_TYPES_TL (
122: OPTION_TYPE_ID,
123: OPTION_NAME,
124: CREATED_BY,
125: CREATION_DATE,

Line 145: from HR_KI_OPTION_TYPES_TL T

141: from FND_LANGUAGES L
142: where L.INSTALLED_FLAG in ('I', 'B')
143: and not exists
144: (select NULL
145: from HR_KI_OPTION_TYPES_TL T
146: where T.OPTION_TYPE_ID = X_OPTION_TYPE_ID
147: and T.LANGUAGE = L.LANGUAGE_CODE);
148:
149: open c;

Line 155: 'hr_ki_option_types.insert_row');

151: if (c%notfound) then
152: close c;
153: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
154: hr_utility.set_message_token('PROCEDURE',
155: 'hr_ki_option_types.insert_row');
156: hr_utility.set_message_token('STEP','1');
157: hr_utility.raise_error;
158: end if;
159: close c;

Line 177: l_created_by HR_KI_OPTION_TYPES.created_by%TYPE := 0;

173: )
174: is
175: l_proc VARCHAR2(31) := 'HR_KI_OTY_LOAD_API.LOAD_ROW';
176: l_rowid rowid;
177: l_created_by HR_KI_OPTION_TYPES.created_by%TYPE := 0;
178: l_creation_date HR_KI_OPTION_TYPES.creation_date%TYPE := SYSDATE;
179: l_last_update_date HR_KI_OPTION_TYPES.last_update_date%TYPE := SYSDATE;
180: l_last_updated_by HR_KI_OPTION_TYPES.last_updated_by%TYPE := 0;
181: l_last_update_login HR_KI_OPTION_TYPES.last_update_login%TYPE := 0;

Line 178: l_creation_date HR_KI_OPTION_TYPES.creation_date%TYPE := SYSDATE;

174: is
175: l_proc VARCHAR2(31) := 'HR_KI_OTY_LOAD_API.LOAD_ROW';
176: l_rowid rowid;
177: l_created_by HR_KI_OPTION_TYPES.created_by%TYPE := 0;
178: l_creation_date HR_KI_OPTION_TYPES.creation_date%TYPE := SYSDATE;
179: l_last_update_date HR_KI_OPTION_TYPES.last_update_date%TYPE := SYSDATE;
180: l_last_updated_by HR_KI_OPTION_TYPES.last_updated_by%TYPE := 0;
181: l_last_update_login HR_KI_OPTION_TYPES.last_update_login%TYPE := 0;
182: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;

Line 179: l_last_update_date HR_KI_OPTION_TYPES.last_update_date%TYPE := SYSDATE;

175: l_proc VARCHAR2(31) := 'HR_KI_OTY_LOAD_API.LOAD_ROW';
176: l_rowid rowid;
177: l_created_by HR_KI_OPTION_TYPES.created_by%TYPE := 0;
178: l_creation_date HR_KI_OPTION_TYPES.creation_date%TYPE := SYSDATE;
179: l_last_update_date HR_KI_OPTION_TYPES.last_update_date%TYPE := SYSDATE;
180: l_last_updated_by HR_KI_OPTION_TYPES.last_updated_by%TYPE := 0;
181: l_last_update_login HR_KI_OPTION_TYPES.last_update_login%TYPE := 0;
182: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;
183: l_object_version_number HR_KI_OPTION_TYPES.object_version_number%TYPE;

Line 180: l_last_updated_by HR_KI_OPTION_TYPES.last_updated_by%TYPE := 0;

176: l_rowid rowid;
177: l_created_by HR_KI_OPTION_TYPES.created_by%TYPE := 0;
178: l_creation_date HR_KI_OPTION_TYPES.creation_date%TYPE := SYSDATE;
179: l_last_update_date HR_KI_OPTION_TYPES.last_update_date%TYPE := SYSDATE;
180: l_last_updated_by HR_KI_OPTION_TYPES.last_updated_by%TYPE := 0;
181: l_last_update_login HR_KI_OPTION_TYPES.last_update_login%TYPE := 0;
182: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;
183: l_object_version_number HR_KI_OPTION_TYPES.object_version_number%TYPE;
184:

Line 181: l_last_update_login HR_KI_OPTION_TYPES.last_update_login%TYPE := 0;

177: l_created_by HR_KI_OPTION_TYPES.created_by%TYPE := 0;
178: l_creation_date HR_KI_OPTION_TYPES.creation_date%TYPE := SYSDATE;
179: l_last_update_date HR_KI_OPTION_TYPES.last_update_date%TYPE := SYSDATE;
180: l_last_updated_by HR_KI_OPTION_TYPES.last_updated_by%TYPE := 0;
181: l_last_update_login HR_KI_OPTION_TYPES.last_update_login%TYPE := 0;
182: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;
183: l_object_version_number HR_KI_OPTION_TYPES.object_version_number%TYPE;
184:
185: db_luby number; -- entity owner in db

Line 182: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;

178: l_creation_date HR_KI_OPTION_TYPES.creation_date%TYPE := SYSDATE;
179: l_last_update_date HR_KI_OPTION_TYPES.last_update_date%TYPE := SYSDATE;
180: l_last_updated_by HR_KI_OPTION_TYPES.last_updated_by%TYPE := 0;
181: l_last_update_login HR_KI_OPTION_TYPES.last_update_login%TYPE := 0;
182: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;
183: l_object_version_number HR_KI_OPTION_TYPES.object_version_number%TYPE;
184:
185: db_luby number; -- entity owner in db
186: db_ludate date; -- entity update date in db

Line 183: l_object_version_number HR_KI_OPTION_TYPES.object_version_number%TYPE;

179: l_last_update_date HR_KI_OPTION_TYPES.last_update_date%TYPE := SYSDATE;
180: l_last_updated_by HR_KI_OPTION_TYPES.last_updated_by%TYPE := 0;
181: l_last_update_login HR_KI_OPTION_TYPES.last_update_login%TYPE := 0;
182: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;
183: l_object_version_number HR_KI_OPTION_TYPES.object_version_number%TYPE;
184:
185: db_luby number; -- entity owner in db
186: db_ludate date; -- entity update date in db
187:

Line 191: from HR_KI_OPTION_TYPES

187:
188:
189: CURSOR C_APPL IS
190: select option_type_id,object_version_number
191: from HR_KI_OPTION_TYPES
192: where upper(option_type_key) = upper(X_OPTION_TYPE_KEY);
193:
194: begin
195: --

Line 234: from HR_KI_OPTION_TYPES

230: else
231: close C_APPL;
232: select LAST_UPDATED_BY, LAST_UPDATE_DATE
233: into db_luby, db_ludate
234: from HR_KI_OPTION_TYPES
235: where option_type_id = l_option_type_id;
236:
237:
238: if (fnd_load_util.upload_test(l_last_updated_by, l_last_update_date, db_luby,

Line 266: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;

262: X_CUSTOM_MODE in varchar2,
263: X_LAST_UPDATE_DATE in varchar2
264: )
265: is
266: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;
267:
268: f_luby number; -- entity owner in file
269: f_ludate date; -- entity update date in file
270: db_luby number; -- entity owner in db

Line 281: from HR_KI_OPTION_TYPES

277: hr_general.g_data_migrator_mode := 'Y';
278: --
279:
280: select option_type_id into l_option_type_id
281: from HR_KI_OPTION_TYPES
282: where upper(option_type_key) = upper(X_OPTION_TYPE_KEY);
283:
284:
285: -- Translate owner to file_last_updated_by

Line 294: from HR_KI_OPTION_TYPES_TL

290:
291: begin
292: select LAST_UPDATED_BY, LAST_UPDATE_DATE
293: into db_luby, db_ludate
294: from HR_KI_OPTION_TYPES_TL
295: where
296: LANGUAGE = userenv('LANG')
297: and option_type_id = l_option_type_id;
298:

Line 303: UPDATE HR_KI_OPTION_TYPES_TL

299: -- Test for customization and version
300: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
301: db_ludate,X_CUSTOM_MODE)) then
302:
303: UPDATE HR_KI_OPTION_TYPES_TL
304: SET
305: OPTION_NAME = X_OPTION_NAME,
306: LAST_UPDATE_DATE = f_ludate ,
307: LAST_UPDATED_BY = f_luby,