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

Line 49: hr_utility.set_location('Entering:'|| l_proc, 10);

45: l_update_change_insert varchar2(6); -- Char version of boolean OUT value
46: --
47: l_proc varchar2(72) := g_package||'get_update_mode_list';
48: begin
49: hr_utility.set_location('Entering:'|| l_proc, 10);
50: --
51: -- Define dynamic PL/SQL block with package procedure call
52: --
53: -- Note: The varchar2 variables are required because

Line 98: hr_utility.set_location(l_proc, 20);

94: -- Replace the literal (token) strings in the PL/SQL package procedure call
95: --
96: l_pl_sql := replace(l_pl_sql, '{Package_Name}', p_package_name);
97: l_pl_sql := replace(l_pl_sql, '{Procedure_Name}', p_procedure_name);
98: hr_utility.set_location(l_proc, 20);
99: --
100: -- Execute the Dynamic PL/SQL statement
101: --
102: -- Open dynamic cursor

Line 104: hr_utility.set_location(l_proc, 30);

100: -- Execute the Dynamic PL/SQL statement
101: --
102: -- Open dynamic cursor
103: l_cursor := dbms_sql.open_cursor;
104: hr_utility.set_location(l_proc, 30);
105: --
106: -- Parse dynamic PL/SQL
107: dbms_sql.parse(l_cursor, l_pl_sql, dbms_sql.v7);
108: hr_utility.set_location(l_proc, 40);

Line 108: hr_utility.set_location(l_proc, 40);

104: hr_utility.set_location(l_proc, 30);
105: --
106: -- Parse dynamic PL/SQL
107: dbms_sql.parse(l_cursor, l_pl_sql, dbms_sql.v7);
108: hr_utility.set_location(l_proc, 40);
109: --
110: -- Bind dynamic package procedure IN parameter values
111: dbms_sql.bind_variable(l_cursor, ':p_effective_date', p_effective_date);
112: dbms_sql.bind_variable(l_cursor, ':p_base_key_value', p_base_key_value);

Line 113: hr_utility.set_location(l_proc, 50);

109: --
110: -- Bind dynamic package procedure IN parameter values
111: dbms_sql.bind_variable(l_cursor, ':p_effective_date', p_effective_date);
112: dbms_sql.bind_variable(l_cursor, ':p_base_key_value', p_base_key_value);
113: hr_utility.set_location(l_proc, 50);
114: --
115: -- Bind dynamic PL/SQL local variable (OUT parameter) values
116: dbms_sql.bind_variable(l_cursor, ':correction', l_correction, c_out_len);
117: dbms_sql.bind_variable(l_cursor, ':update', l_update, c_out_len);

Line 122: hr_utility.set_location(l_proc, 60);

118: dbms_sql.bind_variable(l_cursor, ':update_override'
119: ,l_update_override, c_out_len);
120: dbms_sql.bind_variable(l_cursor, ':update_change_insert'
121: ,l_update_change_insert, c_out_len);
122: hr_utility.set_location(l_proc, 60);
123: --
124: -- Execute the dynamic PL/SQL block
125: l_execute := dbms_sql.execute(l_cursor);
126: hr_utility.set_location(l_proc, 70);

Line 126: hr_utility.set_location(l_proc, 70);

122: hr_utility.set_location(l_proc, 60);
123: --
124: -- Execute the dynamic PL/SQL block
125: l_execute := dbms_sql.execute(l_cursor);
126: hr_utility.set_location(l_proc, 70);
127: --
128: -- Obtain the OUT parameter, as varchar2 values.
129: --
130: dbms_sql.variable_value(l_cursor, ':correction', l_correction);

Line 135: hr_utility.set_location(l_proc, 80);

131: dbms_sql.variable_value(l_cursor, ':update', l_update);
132: dbms_sql.variable_value(l_cursor, ':update_override', l_update_override);
133: dbms_sql.variable_value(l_cursor, ':update_change_insert'
134: ,l_update_change_insert);
135: hr_utility.set_location(l_proc, 80);
136: --
137: -- Close Dynamic Cursor
138: --
139: dbms_sql.close_cursor(l_cursor);

Line 140: hr_utility.set_location(l_proc, 90);

136: --
137: -- Close Dynamic Cursor
138: --
139: dbms_sql.close_cursor(l_cursor);
140: hr_utility.set_location(l_proc, 90);
141: --
142: -- Convert the varchar2 values back into boolean so
143: -- they can be returned from this procedure.
144: --

Line 168: hr_utility.set_location(' Leaving:'|| l_proc, 100);

164: p_update_change_insert := true;
165: else
166: p_update_change_insert := false;
167: end if;
168: hr_utility.set_location(' Leaving:'|| l_proc, 100);
169: exception
170: --
171: -- In case of an unexpected error ensure
172: -- that the Dynamic Cursor is closed.

Line 215: hr_utility.set_location('Entering:'|| l_proc, 10);

211: l_delete_next_change varchar2(6); -- Char version of boolean OUT value
212: --
213: l_proc varchar2(72) := g_package||'get_delete_mode_list';
214: begin
215: hr_utility.set_location('Entering:'|| l_proc, 10);
216: --
217: -- Define dynamic PL/SQL block with package procedure call
218: --
219: -- Note: The varchar2 variables are required because

Line 264: hr_utility.set_location(l_proc, 20);

260: -- Replace the literal (token) strings in the PL/SQL package procedure call
261: --
262: l_pl_sql := replace(l_pl_sql, '{Package_Name}', p_package_name);
263: l_pl_sql := replace(l_pl_sql, '{Procedure_Name}', p_procedure_name);
264: hr_utility.set_location(l_proc, 20);
265: --
266: -- Execute the Dynamic PL/SQL statement
267: --
268: -- Open dynamic cursor

Line 270: hr_utility.set_location(l_proc, 30);

266: -- Execute the Dynamic PL/SQL statement
267: --
268: -- Open dynamic cursor
269: l_cursor := dbms_sql.open_cursor;
270: hr_utility.set_location(l_proc, 30);
271: --
272: -- Parse dynamic PL/SQL
273: dbms_sql.parse(l_cursor, l_pl_sql, dbms_sql.v7);
274: hr_utility.set_location(l_proc, 40);

Line 274: hr_utility.set_location(l_proc, 40);

270: hr_utility.set_location(l_proc, 30);
271: --
272: -- Parse dynamic PL/SQL
273: dbms_sql.parse(l_cursor, l_pl_sql, dbms_sql.v7);
274: hr_utility.set_location(l_proc, 40);
275: --
276: -- Bind dynamic package procedure IN parameter values
277: dbms_sql.bind_variable(l_cursor, ':p_effective_date', p_effective_date);
278: dbms_sql.bind_variable(l_cursor, ':p_base_key_value', p_base_key_value);

Line 279: hr_utility.set_location(l_proc, 50);

275: --
276: -- Bind dynamic package procedure IN parameter values
277: dbms_sql.bind_variable(l_cursor, ':p_effective_date', p_effective_date);
278: dbms_sql.bind_variable(l_cursor, ':p_base_key_value', p_base_key_value);
279: hr_utility.set_location(l_proc, 50);
280: --
281: -- Bind dynamic PL/SQL local variable (OUT parameter) values
282: dbms_sql.bind_variable(l_cursor, ':zap', l_zap, c_out_len);
283: dbms_sql.bind_variable(l_cursor, ':delete', l_delete, c_out_len);

Line 288: hr_utility.set_location(l_proc, 60);

284: dbms_sql.bind_variable(l_cursor, ':future_change'
285: ,l_future_change, c_out_len);
286: dbms_sql.bind_variable(l_cursor, ':delete_next_change'
287: ,l_delete_next_change, c_out_len);
288: hr_utility.set_location(l_proc, 60);
289: --
290: -- Execute the dynamic PL/SQL block
291: l_execute := dbms_sql.execute(l_cursor);
292: hr_utility.set_location(l_proc, 70);

Line 292: hr_utility.set_location(l_proc, 70);

288: hr_utility.set_location(l_proc, 60);
289: --
290: -- Execute the dynamic PL/SQL block
291: l_execute := dbms_sql.execute(l_cursor);
292: hr_utility.set_location(l_proc, 70);
293: --
294: -- Obtain the OUT parameter, as varchar2 values.
295: --
296: dbms_sql.variable_value(l_cursor, ':zap', l_zap);

Line 301: hr_utility.set_location(l_proc, 80);

297: dbms_sql.variable_value(l_cursor, ':delete', l_delete);
298: dbms_sql.variable_value(l_cursor, ':future_change', l_future_change);
299: dbms_sql.variable_value(l_cursor, ':delete_next_change'
300: ,l_delete_next_change);
301: hr_utility.set_location(l_proc, 80);
302: --
303: -- Close Dynamic Cursor
304: --
305: dbms_sql.close_cursor(l_cursor);

Line 306: hr_utility.set_location(l_proc, 90);

302: --
303: -- Close Dynamic Cursor
304: --
305: dbms_sql.close_cursor(l_cursor);
306: hr_utility.set_location(l_proc, 90);
307: --
308: -- Convert the varchar2 values back into boolean so
309: -- they can be returned from this procedure.
310: --

Line 334: hr_utility.set_location(' Leaving:'|| l_proc, 100);

330: p_delete_next_change := true;
331: else
332: p_delete_next_change := false;
333: end if;
334: hr_utility.set_location(' Leaving:'|| l_proc, 100);
335: exception
336: --
337: -- In case of an unexpected error ensure
338: -- that the Dynamic Cursor is closed.

Line 379: hr_utility.set_location('Entering:'|| l_proc, 10);

375: l_validation_end_date date; -- Bind value from Dynamic PL/SQL.
376: --
377: l_proc varchar2(72) := g_package||'lock_record';
378: begin
379: hr_utility.set_location('Entering:'|| l_proc, 10);
380: --
381: -- Define dynamic PL/SQL block with package procedure call
382: --
383: -- Note: The varchar2 variables are required because

Line 404: hr_utility.set_location(l_proc, 20);

400: --
401: l_pl_sql := replace(l_pl_sql, '{Package_Name}', p_package_name);
402: l_pl_sql := replace(l_pl_sql, '{Procedure_Name}', p_procedure_name);
403: l_pl_sql := replace(l_pl_sql, '{p_uid_item_name}', 'p_' || p_uid_item_name);
404: hr_utility.set_location(l_proc, 20);
405: --
406: -- Execute the Dynamic PL/SQL statement
407: --
408: -- Open dynamic cursor

Line 410: hr_utility.set_location(l_proc, 30);

406: -- Execute the Dynamic PL/SQL statement
407: --
408: -- Open dynamic cursor
409: l_cursor := dbms_sql.open_cursor;
410: hr_utility.set_location(l_proc, 30);
411: --
412: -- Parse dynamic PL/SQL
413: dbms_sql.parse(l_cursor, l_pl_sql, dbms_sql.v7);
414: hr_utility.set_location(l_proc, 40);

Line 414: hr_utility.set_location(l_proc, 40);

410: hr_utility.set_location(l_proc, 30);
411: --
412: -- Parse dynamic PL/SQL
413: dbms_sql.parse(l_cursor, l_pl_sql, dbms_sql.v7);
414: hr_utility.set_location(l_proc, 40);
415: --
416: -- Bind dynamic package procedure IN parameter values
417: dbms_sql.bind_variable(l_cursor, ':p_effective_date', p_effective_date);
418: dbms_sql.bind_variable(l_cursor, ':p_datetrack_mode', p_datetrack_mode);

Line 422: hr_utility.set_location(l_proc, 50);

418: dbms_sql.bind_variable(l_cursor, ':p_datetrack_mode', p_datetrack_mode);
419: dbms_sql.bind_variable(l_cursor, ':p_base_key_value', p_base_key_value);
420: dbms_sql.bind_variable(l_cursor, ':p_object_version_number',
421: p_object_version_number);
422: hr_utility.set_location(l_proc, 50);
423: --
424: -- Bind dynamic PL/SQL local variable (OUT parameter) values
425: dbms_sql.bind_variable(l_cursor, ':p_validation_start_date',
426: l_validation_start_date);

Line 429: hr_utility.set_location(l_proc, 60);

425: dbms_sql.bind_variable(l_cursor, ':p_validation_start_date',
426: l_validation_start_date);
427: dbms_sql.bind_variable(l_cursor, ':p_validation_end_date',
428: l_validation_end_date);
429: hr_utility.set_location(l_proc, 60);
430: --
431: -- Execute the dynamic PL/SQL block
432: l_execute := dbms_sql.execute(l_cursor);
433: hr_utility.set_location(l_proc, 70);

Line 433: hr_utility.set_location(l_proc, 70);

429: hr_utility.set_location(l_proc, 60);
430: --
431: -- Execute the dynamic PL/SQL block
432: l_execute := dbms_sql.execute(l_cursor);
433: hr_utility.set_location(l_proc, 70);
434: --
435: -- Obtain the OUT parameter, as varchar2 values.
436: --
437: dbms_sql.variable_value(l_cursor, ':p_validation_start_date',

Line 441: hr_utility.set_location(l_proc, 80);

437: dbms_sql.variable_value(l_cursor, ':p_validation_start_date',
438: l_validation_start_date);
439: dbms_sql.variable_value(l_cursor, ':p_validation_end_date',
440: l_validation_end_date);
441: hr_utility.set_location(l_proc, 80);
442: --
443: -- Close Dynamic Cursor
444: --
445: dbms_sql.close_cursor(l_cursor);

Line 446: hr_utility.set_location(l_proc, 90);

442: --
443: -- Close Dynamic Cursor
444: --
445: dbms_sql.close_cursor(l_cursor);
446: hr_utility.set_location(l_proc, 90);
447: --
448: -- Set Out parameters
449: --
450: p_validation_start_date := l_validation_start_date;

Line 452: hr_utility.set_location(' Leaving:'|| l_proc, 100);

448: -- Set Out parameters
449: --
450: p_validation_start_date := l_validation_start_date;
451: p_validation_end_date := l_validation_end_date;
452: hr_utility.set_location(' Leaving:'|| l_proc, 100);
453: exception
454: --
455: -- In case of an unexpected error ensure
456: -- that the Dynamic Cursor is closed.

Line 497: hr_utility.set_location('Entering:'|| l_proc, 10);

493:
494: --
495: l_proc varchar2(72) := g_package||'get_update_modes_and_dates';
496: begin
497: hr_utility.set_location('Entering:'|| l_proc, 10);
498: --
499: -- Define dynamic PL/SQL block with package procedure call
500: --
501: --

Line 524: 'hr_utility.set_location('||''''||'dyn sql'||''''||', 11);' ||

520: ',p_override_end_date => :p_override_end_date ' ||
521: ',p_upd_chg_start_date => :p_upd_chg_start_date ' ||
522: ',p_upd_chg_end_date => :p_upd_chg_end_date ' ||
523: '); ' ||
524: 'hr_utility.set_location('||''''||'dyn sql'||''''||', 11);' ||
525: ':p_correction :=
526: hr_api.boolean_to_constant(l_correction); ' ||
527: ':p_update := hr_api.boolean_to_constant(l_update); ' ||
528: ':p_update_override

Line 532: 'hr_utility.set_location('||''''||'dyn sql'||''''||', 12);' ||

528: ':p_update_override
529: := hr_api.boolean_to_constant(l_update_override); ' ||
530: ':p_update_change_insert
531: := hr_api.boolean_to_constant(l_update_change_insert); ' ||
532: 'hr_utility.set_location('||''''||'dyn sql'||''''||', 12);' ||
533: 'end;';
534: --
535: -- Replace the literal (token) strings in the PL/SQL package procedure call
536: --

Line 539: hr_utility.set_location(l_proc, 20);

535: -- Replace the literal (token) strings in the PL/SQL package procedure call
536: --
537: l_pl_sql := replace(l_pl_sql, '{Package_Name}', p_package_name);
538: l_pl_sql := replace(l_pl_sql, '{Procedure_Name}', p_procedure_name);
539: hr_utility.set_location(l_proc, 20);
540:
541: EXECUTE IMMEDIATE l_pl_sql USING p_effective_date,
542: p_base_key_value,
543: OUT p_correction_start_date,

Line 556: hr_utility.set_location('Leaving:'|| l_proc, 30);

552: OUT p_update,
553: OUT p_update_override,
554: OUT p_update_change_insert;
555:
556: hr_utility.set_location('Leaving:'|| l_proc, 30);
557: --
558: exception
559: --
560: -- In case of an unexpected error raise the error

Line 598: hr_utility.set_location('Entering:'|| l_proc, 10);

594: -- call source code text.
595: --
596: l_proc varchar2(72) := g_package||'get_delete_modes_and_dates';
597: begin
598: hr_utility.set_location('Entering:'|| l_proc, 10);
599: --
600: -- Define dynamic PL/SQL block with package procedure call
601: --
602: --

Line 635: hr_utility.set_location(l_proc, 20);

631: -- Replace the literal (token) strings in the PL/SQL package procedure call
632: --
633: l_pl_sql := replace(l_pl_sql, '{Package_Name}', p_package_name);
634: l_pl_sql := replace(l_pl_sql, '{Procedure_Name}', p_procedure_name);
635: hr_utility.set_location(l_proc, 20);
636:
637: EXECUTE IMMEDIATE l_pl_sql USING p_effective_date,
638: p_base_key_value,
639: OUT p_zap_start_date,

Line 652: hr_utility.set_location('Leaving:'|| l_proc, 30);

648: OUT p_delete,
649: OUT p_future_change,
650: OUT p_delete_next_change;
651:
652: hr_utility.set_location('Leaving:'|| l_proc, 30);
653: --
654: exception
655: --
656: -- In case of an unexpected error raise the error