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_FR_SEED_PKG dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

194: v_start_date := TO_DATE ('01/01/1900', 'DD/MM/YYYY');
195: v_end_date := TO_DATE ('31/12/4712', 'DD/MM/YYYY');
196: -- Initialising the parameters
197:
198: hr_utility.trace ('PROCEDURE create row entered.');
199: --
200: SELECT user_table_id, legislation_code
201: INTO v_user_table_id, v_legislation_code
202: FROM pay_user_tables

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

213: FROM dual;
214:
215: -- this insertion creates the row
216:
217: hr_utility.trace ('Inserting row '||P_ROW_LOW_RANGE_OR_NAME_CR);
218: hr_utility.trace (' INTO '||P_BUSINESS_GROUP_ID_CR);
219: INSERT INTO pay_user_rows_f (user_row_id,
220: effective_start_date,
221: effective_end_date,

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

214:
215: -- this insertion creates the row
216:
217: hr_utility.trace ('Inserting row '||P_ROW_LOW_RANGE_OR_NAME_CR);
218: hr_utility.trace (' INTO '||P_BUSINESS_GROUP_ID_CR);
219: INSERT INTO pay_user_rows_f (user_row_id,
220: effective_start_date,
221: effective_end_date,
222: business_group_id,

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

237: P_DISPLAY_SEQUENCE_CR,
238: NULL,
239: NULL);
240: --
241: hr_utility.set_location ('Created row '||P_ROW_LOW_RANGE_OR_NAME_CR,1);
242: --
243: ELSE
244: --
245: hr_utility.set_location ('row already exists, row not entered.', 202);

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

241: hr_utility.set_location ('Created row '||P_ROW_LOW_RANGE_OR_NAME_CR,1);
242: --
243: ELSE
244: --
245: hr_utility.set_location ('row already exists, row not entered.', 202);
246: --
247: END IF;
248:
249: CLOSE user_row_id_csr;

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

247: END IF;
248:
249: CLOSE user_row_id_csr;
250:
251: hr_utility.trace ('PROCEDURE create_row exiting');
252: --
253: SELECT user_column_id
254: INTO v_user_column_id
255: FROM pay_user_columns_v

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

259: OPEN row_instance_csr (v_user_row_id, v_user_column_id);
260: FETCH row_instance_csr INTO v_user_column_instance_id;
261: IF row_instance_csr%NOTFOUND THEN
262: --
263: hr_utility.set_location ('inserting instance', 10);
264: PAY_USER_COLUMN_INSTANCES_PKG.INSERT_ROW
265: (P_ROWID => v_column_instance_rowid
266: ,P_USER_COLUMN_INSTANCE_ID => v_user_column_instance_id
267: ,P_EFFECTIVE_START_DATE => v_start_date

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

273: ,P_LEGISLATION_SUBGROUP => NULL
274: ,P_VALUE => P_VALUE_CR);
275: --
276: ELSE
277: hr_utility.set_location ('instance already exists', 10);
278: END IF;
279: END create_row;
280:
281: --------------------------------------------------------------------------------

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

301: FROM fnd_common_lookups
302: WHERE lookup_type = P_LOOKUP_TYPE;
303:
304: BEGIN
305: hr_utility.trace ('PROCEDURE create_from_lookup entered.');
306:
307: OPEN lookup_code_csr;
308: FETCH lookup_code_csr INTO v_lookup_code, v_meaning;
309: IF lookup_code_csr%FOUND THEN

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

306:
307: OPEN lookup_code_csr;
308: FETCH lookup_code_csr INTO v_lookup_code, v_meaning;
309: IF lookup_code_csr%FOUND THEN
310: hr_utility.set_location ('Valid lookup: '||P_LOOKUP_TYPE, 40);
311:
312: create_table (P_BUSINESS_GROUP_ID_CT => P_BUSINESS_GROUP_ID,
313: P_APPLICATION_ID_CT => 800,
314: P_RANGE_OR_MATCH_CT => 'M',

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

315: P_USER_KEY_UNITS_CT => P_USER_KEY_UNITS,
316: P_USER_TABLE_NAME_CT => P_LOOKUP_TYPE,
317: P_USER_ROW_TITLE_CT => P_LOOKUP_TYPE);
318:
319: hr_utility.set_location ('Adding: '||P_USER_COLUMN_NAME, 50);
320:
321: create_column (P_BUSINESS_GROUP_ID_CC => P_BUSINESS_GROUP_ID,
322: P_USER_TABLE_NAME_CC => P_LOOKUP_TYPE,
323: P_USER_COLUMN_NAME_CC => P_USER_COLUMN_NAME);

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

325: LOOP
326: EXIT WHEN lookup_code_csr%NOTFOUND;
327:
328: IF P_REQUIRED_DEFAULTS = 'NONE' THEN
329: hr_utility.trace ('sequence number: '||v_sequence);
330: create_row (P_BUSINESS_GROUP_ID_CR => P_BUSINESS_GROUP_ID,
331: P_USER_TABLE_NAME_CR => P_LOOKUP_TYPE,
332: P_USER_COLUMN_NAME_CR => P_USER_COLUMN_NAME,
333: P_ROW_LOW_RANGE_OR_NAME_CR => v_lookup_code,

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

333: P_ROW_LOW_RANGE_OR_NAME_CR => v_lookup_code,
334: P_DISPLAY_SEQUENCE_CR => v_sequence,
335: P_VALUE_CR => NULL);
336: ELSIF P_REQUIRED_DEFAULTS = 'QUICKCODE_VALUE' THEN
337: hr_utility.trace ('sequence number: '||v_sequence);
338: create_row (P_BUSINESS_GROUP_ID_CR => P_BUSINESS_GROUP_ID,
339: P_USER_TABLE_NAME_CR => P_LOOKUP_TYPE,
340: P_USER_COLUMN_NAME_CR => P_USER_COLUMN_NAME,
341: P_ROW_LOW_RANGE_OR_NAME_CR => v_lookup_code,

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

341: P_ROW_LOW_RANGE_OR_NAME_CR => v_lookup_code,
342: P_DISPLAY_SEQUENCE_CR => v_sequence,
343: P_VALUE_CR => v_meaning);
344: ELSE
345: hr_utility.trace ('sequence number: '||v_sequence);
346: create_row (P_BUSINESS_GROUP_ID_CR => P_BUSINESS_GROUP_ID,
347: P_USER_TABLE_NAME_CR => P_LOOKUP_TYPE,
348: P_USER_COLUMN_NAME_CR => P_USER_COLUMN_NAME,
349: P_ROW_LOW_RANGE_OR_NAME_CR => v_lookup_code,

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

355: END LOOP;
356: END IF;
357: CLOSE lookup_code_csr;
358:
359: hr_utility.trace ('PROCEDURE create_from_lookup exited.');
360:
361: END;
362:
363:

Line 389: hr_utility.trace ('PROCEDURE popcreate_from_person_types.');

385: -- Initialising the parameters
386: v_legislation_code := NULL; -- holds legislation code returned
387: -- Initialising the parameters
388:
389: hr_utility.trace ('PROCEDURE popcreate_from_person_types.');
390:
391: OPEN get_person_types_csr;
392: FETCH get_person_types_csr INTO v_user_person_type;
393: IF get_person_types_csr%FOUND THEN

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

391: OPEN get_person_types_csr;
392: FETCH get_person_types_csr INTO v_user_person_type;
393: IF get_person_types_csr%FOUND THEN
394:
395: hr_utility.set_location ('Adding: '||P_USER_COLUMN_NAME, 50);
396:
397: create_column (P_BUSINESS_GROUP_ID_CC => P_BUSINESS_GROUP_ID,
398: P_USER_TABLE_NAME_CC => P_USER_TABLE_NAME,
399: P_USER_COLUMN_NAME_CC => P_USER_COLUMN_NAME);

Line 404: hr_utility.set_location (' Adding: '||v_user_person_type || ' row', 60);

400:
401: LOOP
402: EXIT WHEN get_person_types_csr%NOTFOUND;
403:
404: hr_utility.set_location (' Adding: '||v_user_person_type || ' row', 60);
405: hr_utility.trace ('sequence number: '||v_sequence);
406: create_row (P_BUSINESS_GROUP_ID_CR => P_BUSINESS_GROUP_ID,
407: P_USER_TABLE_NAME_CR => P_USER_TABLE_NAME,
408: P_USER_COLUMN_NAME_CR => P_USER_COLUMN_NAME,

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

401: LOOP
402: EXIT WHEN get_person_types_csr%NOTFOUND;
403:
404: hr_utility.set_location (' Adding: '||v_user_person_type || ' row', 60);
405: hr_utility.trace ('sequence number: '||v_sequence);
406: create_row (P_BUSINESS_GROUP_ID_CR => P_BUSINESS_GROUP_ID,
407: P_USER_TABLE_NAME_CR => P_USER_TABLE_NAME,
408: P_USER_COLUMN_NAME_CR => P_USER_COLUMN_NAME,
409: P_ROW_LOW_RANGE_OR_NAME_CR => v_user_person_type,

Line 419: hr_utility.trace ('EXIT from Procedure create_from_person_type');

415: END LOOP;
416: END IF;
417: CLOSE get_person_types_csr;
418:
419: hr_utility.trace ('EXIT from Procedure create_from_person_type');
420:
421: END;
422:
423:

Line 13402: hr_utility.set_location('do_d2_seed_data', 5);

13398: ,p_required_defaults => 'None'
13399: ,p_default_value => NULL
13400: ,p_legislation_code => lc_legislation_code);
13401: --
13402: hr_utility.set_location('do_d2_seed_data', 5);
13403: --
13404: --------------------------------------------------------------------
13405: -- -------------- Do_seed_data ------------------------------------|
13406: -- This is the location where the final seeded data is done

Line 13410: hr_utility.set_location('***** do_mmo_seed_data - FR_STARTING_REASON -> ' || to_char(p_business_group_id) || '/' || lc_legislation_code, 5);

13406: -- This is the location where the final seeded data is done
13407: -- (combination table_name/column)
13408: ---------------------------------------------------------------------
13409: --
13410: hr_utility.set_location('***** do_mmo_seed_data - FR_STARTING_REASON -> ' || to_char(p_business_group_id) || '/' || lc_legislation_code, 5);
13411: --
13412: -- Seeded data for FR_STARTING_REASON (and all its related rows) / MMO_STARTING_CATEGORY
13413: --
13414: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_COMPANY','TR');

Line 13425: hr_utility.set_location('do_mmo_seed_data - FR_ENDING_REASON ', 10);

13421: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_PERMANENT','RD');
13422: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','RECLASS','AU');
13423: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','TEMPORARY_REPLACEMENT','AU');
13424: --
13425: hr_utility.set_location('do_mmo_seed_data - FR_ENDING_REASON ', 10);
13426: -- Seeded data for FR_ENDING_REASON (and all its related rows) / MMO_ENDING_CATEGORY
13427: --
13428: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_COMPANY','TR');
13429: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_ESTABLISHMENT','TR');

Line 13451: hr_utility.set_location('do_mmo_seed_data - Leaving ', 30);

13447: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY_WA','LA');
13448: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','R','RT');
13449: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','D','AU');
13450: --
13451: hr_utility.set_location('do_mmo_seed_data - Leaving ', 30);
13452: --
13453: per_alt_lookups_pkg.run_process
13454: (errbuf => lc_errbuf
13455: ,retcode => ln_retcode

Line 13547: hr_utility.set_location('do_d2_seed_data ', 10);

13543: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6841','Y');
13544: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6911','Y');
13545: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6921','Y');
13546: --
13547: hr_utility.set_location('do_d2_seed_data ', 10);
13548: --
13549: -- seeded data for FR_EMPLOYMENT / FR_D2_CATEGORY
13550: --
13551: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','FR','F');

Line 13918: hr_utility.set_location ('PROCESS COMPLETE!',100);

13914: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'RESIGNATION','FR_RESIGNATION');
13915: --
13916: -- any more termination reasons
13917:
13918: hr_utility.set_location ('PROCESS COMPLETE!',100);
13919:
13920: END seed_data;
13921:
13922: END hr_fr_seed_pkg;