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.OTAFRUDT dependencies on HR_UTILITY

Line 19: hr_utility.trace ('PROCEDURE insert_data entered.');

15: IS
16: v_table_rowid varchar2(100);
17: v_user_table_id number;
18: BEGIN
19: hr_utility.trace ('PROCEDURE insert_data entered.');
20:
21: v_table_rowid := NULL;
22: v_user_table_id := NULL;
23:

Line 35: hr_utility.trace ('PROCEDURE insert_data exiting.');

31: P_USER_KEY_UNITS => P_USER_KEY_UNITS_ITD,
32: P_USER_TABLE_NAME => P_USER_TABLE_NAME_ITD,
33: P_USER_ROW_TITLE => P_USER_ROW_TITLE_ITD);
34:
35: hr_utility.trace ('PROCEDURE insert_data exiting.');
36: END insert_table_data;
37:
38:
39: --------------------------------------------------------------------------------

Line 62: hr_utility.trace ('PROCEDURE create table entered.');

58: v_legislation_code per_business_groups.legislation_code%TYPE;
59: v_user_table_name varchar (100);
60: BEGIN
61:
62: hr_utility.trace ('PROCEDURE create table entered.');
63:
64: SELECT legislation_code
65: INTO v_legislation_code
66: FROM per_business_groups

Line 73: hr_utility.trace ('inserting data into '||P_USER_TABLE_NAME_CT||' from create_table.');

69: OPEN user_table_name_csr;
70: FETCH user_table_name_csr INTO v_user_table_name;
71: --
72: IF user_table_name_csr%NOTFOUND THEN
73: hr_utility.trace ('inserting data into '||P_USER_TABLE_NAME_CT||' from create_table.');
74: --
75: insert_table_data (P_BUSINESS_GROUP_ID_ITD => P_BUSINESS_GROUP_ID_CT,
76: P_LEGISLATION_CODE_ITD => v_legislation_code,
77: P_APPLICATION_ID_ITD => P_APPLICATION_ID_CT,

Line 83: hr_utility.trace ('TABLE ALREADY EXISTS - create_table abandoned.');

79: P_USER_KEY_UNITS_ITD => P_USER_KEY_UNITS_CT,
80: P_USER_TABLE_NAME_ITD => P_USER_TABLE_NAME_CT,
81: P_USER_ROW_TITLE_ITD => P_USER_ROW_TITLE_CT);
82: ELSE
83: hr_utility.trace ('TABLE ALREADY EXISTS - create_table abandoned.');
84: END IF;
85:
86: hr_utility.trace ('PROCEDURE create table exiting.');
87:

Line 86: hr_utility.trace ('PROCEDURE create table exiting.');

82: ELSE
83: hr_utility.trace ('TABLE ALREADY EXISTS - create_table abandoned.');
84: END IF;
85:
86: hr_utility.trace ('PROCEDURE create table exiting.');
87:
88: exception
89: when others then
90: null;

Line 119: hr_utility.trace ('PROCEDURE create column entered.');

115: AND user_table_name = P_USER_TABLE_NAME_CC)
116: AND user_column_name = P_USER_COLUMN_NAME_CC;
117:
118: BEGIN
119: hr_utility.trace ('PROCEDURE create column entered.');
120:
121: SELECT user_table_id
122: INTO v_user_table_id
123: FROM pay_user_tables

Line 147: hr_utility.trace ('column entry already exists, column not entered.');

143: P_USER_COLUMN_NAME => P_USER_COLUMN_NAME_CC,
144: P_FORMULA_ID => NULL);
145: ELSE
146: --
147: hr_utility.trace ('column entry already exists, column not entered.');
148: --
149: END IF;
150:
151: hr_utility.trace ('PROCEDURE create column exiting.');

Line 151: hr_utility.trace ('PROCEDURE create column exiting.');

147: hr_utility.trace ('column entry already exists, column not entered.');
148: --
149: END IF;
150:
151: hr_utility.trace ('PROCEDURE create column exiting.');
152:
153: END create_column;
154:
155: --------------------------------------------------------------------------------

Line 193: hr_utility.trace ('PROCEDURE create row entered.');

189: WHERE user_row_id = p_user_row_id
190: AND user_column_id = p_user_column_id;
191:
192: BEGIN
193: hr_utility.trace ('PROCEDURE create row entered.');
194: --
195: SELECT user_table_id, legislation_code
196: INTO v_user_table_id, v_legislation_code
197: FROM pay_user_tables

Line 212: hr_utility.trace ('Inserting row '||P_ROW_LOW_RANGE_OR_NAME_CR);

208: FROM dual;
209:
210: -- this insertion creates the row
211:
212: hr_utility.trace ('Inserting row '||P_ROW_LOW_RANGE_OR_NAME_CR);
213: hr_utility.trace (' INTO '||P_BUSINESS_GROUP_ID_CR);
214: INSERT INTO pay_user_rows_f (user_row_id,
215: effective_start_date,
216: effective_end_date,

Line 213: hr_utility.trace (' INTO '||P_BUSINESS_GROUP_ID_CR);

209:
210: -- this insertion creates the row
211:
212: hr_utility.trace ('Inserting row '||P_ROW_LOW_RANGE_OR_NAME_CR);
213: hr_utility.trace (' INTO '||P_BUSINESS_GROUP_ID_CR);
214: INSERT INTO pay_user_rows_f (user_row_id,
215: effective_start_date,
216: effective_end_date,
217: business_group_id,

Line 236: hr_utility.set_location ('Created row '||P_ROW_LOW_RANGE_OR_NAME_CR,1);

232: P_DISPLAY_SEQUENCE_CR,
233: NULL,
234: NULL);
235: --
236: hr_utility.set_location ('Created row '||P_ROW_LOW_RANGE_OR_NAME_CR,1);
237: --
238: ELSE
239: --
240: hr_utility.set_location ('row already exists, row not entered.', 202);

Line 240: hr_utility.set_location ('row already exists, row not entered.', 202);

236: hr_utility.set_location ('Created row '||P_ROW_LOW_RANGE_OR_NAME_CR,1);
237: --
238: ELSE
239: --
240: hr_utility.set_location ('row already exists, row not entered.', 202);
241: --
242: END IF;
243:
244: CLOSE user_row_id_csr;

Line 246: hr_utility.trace ('PROCEDURE create_row exiting');

242: END IF;
243:
244: CLOSE user_row_id_csr;
245:
246: hr_utility.trace ('PROCEDURE create_row exiting');
247: --
248: SELECT user_column_id
249: INTO v_user_column_id
250: FROM pay_user_columns_v

Line 258: hr_utility.set_location ('inserting instance', 10);

254: OPEN row_instance_csr (v_user_row_id, v_user_column_id);
255: FETCH row_instance_csr INTO v_user_column_instance_id;
256: IF row_instance_csr%NOTFOUND THEN
257: --
258: hr_utility.set_location ('inserting instance', 10);
259: PAY_USER_COLUMN_INSTANCES_PKG.INSERT_ROW
260: (P_ROWID => v_column_instance_rowid
261: ,P_USER_COLUMN_INSTANCE_ID => v_user_column_instance_id
262: ,P_EFFECTIVE_START_DATE => v_start_date

Line 272: hr_utility.set_location ('instance already exists', 10);

268: ,P_LEGISLATION_SUBGROUP => NULL
269: ,P_VALUE => P_VALUE_CR);
270: --
271: ELSE
272: hr_utility.set_location ('instance already exists', 10);
273: END IF;
274: END create_row;
275:
276: --------------------------------------------------------------------------------

Line 300: hr_utility.trace ('PROCEDURE create_from_lookup entered.');

296: FROM fnd_common_lookups
297: WHERE lookup_type = P_LOOKUP_TYPE;
298:
299: BEGIN
300: hr_utility.trace ('PROCEDURE create_from_lookup entered.');
301:
302: OPEN lookup_code_csr;
303: FETCH lookup_code_csr INTO v_lookup_code, v_meaning;
304: IF lookup_code_csr%FOUND THEN

Line 305: hr_utility.set_location ('Valid lookup: '||P_LOOKUP_TYPE, 40);

301:
302: OPEN lookup_code_csr;
303: FETCH lookup_code_csr INTO v_lookup_code, v_meaning;
304: IF lookup_code_csr%FOUND THEN
305: hr_utility.set_location ('Valid lookup: '||P_LOOKUP_TYPE, 40);
306:
307: create_table (P_BUSINESS_GROUP_ID_CT => P_BUSINESS_GROUP_ID,
308: P_APPLICATION_ID_CT => 800,
309: P_RANGE_OR_MATCH_CT => 'M',

Line 314: hr_utility.set_location ('Adding: '||P_USER_COLUMN_NAME, 50);

310: P_USER_KEY_UNITS_CT => P_USER_KEY_UNITS,
311: P_USER_TABLE_NAME_CT => P_LOOKUP_TYPE,
312: P_USER_ROW_TITLE_CT => P_LOOKUP_TYPE);
313:
314: hr_utility.set_location ('Adding: '||P_USER_COLUMN_NAME, 50);
315:
316: create_column (P_BUSINESS_GROUP_ID_CC => P_BUSINESS_GROUP_ID,
317: P_USER_TABLE_NAME_CC => P_LOOKUP_TYPE,
318: P_USER_COLUMN_NAME_CC => P_USER_COLUMN_NAME);

Line 324: hr_utility.trace ('sequence number: '||v_sequence);

320: LOOP
321: EXIT WHEN lookup_code_csr%NOTFOUND;
322:
323: IF P_REQUIRED_DEFAULTS = 'NONE' THEN
324: hr_utility.trace ('sequence number: '||v_sequence);
325: create_row (P_BUSINESS_GROUP_ID_CR => P_BUSINESS_GROUP_ID,
326: P_USER_TABLE_NAME_CR => P_LOOKUP_TYPE,
327: P_USER_COLUMN_NAME_CR => P_USER_COLUMN_NAME,
328: P_ROW_LOW_RANGE_OR_NAME_CR => v_lookup_code,

Line 332: hr_utility.trace ('sequence number: '||v_sequence);

328: P_ROW_LOW_RANGE_OR_NAME_CR => v_lookup_code,
329: P_DISPLAY_SEQUENCE_CR => v_sequence,
330: P_VALUE_CR => NULL);
331: ELSIF P_REQUIRED_DEFAULTS = 'QUICKCODE_VALUE' THEN
332: hr_utility.trace ('sequence number: '||v_sequence);
333: create_row (P_BUSINESS_GROUP_ID_CR => P_BUSINESS_GROUP_ID,
334: P_USER_TABLE_NAME_CR => P_LOOKUP_TYPE,
335: P_USER_COLUMN_NAME_CR => P_USER_COLUMN_NAME,
336: P_ROW_LOW_RANGE_OR_NAME_CR => v_lookup_code,

Line 340: hr_utility.trace ('sequence number: '||v_sequence);

336: P_ROW_LOW_RANGE_OR_NAME_CR => v_lookup_code,
337: P_DISPLAY_SEQUENCE_CR => v_sequence,
338: P_VALUE_CR => v_meaning);
339: ELSE
340: hr_utility.trace ('sequence number: '||v_sequence);
341: create_row (P_BUSINESS_GROUP_ID_CR => P_BUSINESS_GROUP_ID,
342: P_USER_TABLE_NAME_CR => P_LOOKUP_TYPE,
343: P_USER_COLUMN_NAME_CR => P_USER_COLUMN_NAME,
344: P_ROW_LOW_RANGE_OR_NAME_CR => v_lookup_code,

Line 354: hr_utility.trace ('PROCEDURE create_from_lookup exited.');

350: END LOOP;
351: END IF;
352: CLOSE lookup_code_csr;
353:
354: hr_utility.trace ('PROCEDURE create_from_lookup exited.');
355:
356: END;
357: --
358: procedure load_alternate_lookup (l_business_group_id in number)