DBA Data[Home] [Help]

APPS.PAY_SE_TRNA_ARCHIVE dependencies on HR_UTILITY

Line 10: g_debug BOOLEAN := hr_utility.debug_enabled;

6:
7: TYPE lock_table IS TABLE OF lock_rec
8: INDEX BY BINARY_INTEGER;
9:
10: g_debug BOOLEAN := hr_utility.debug_enabled;
11: g_package VARCHAR2 (33) := 'pay_se_trna_archive.';
12: g_payroll_action_id NUMBER;
13: -- Globals to pick up all the parameter
14: g_business_group_id NUMBER;

Line 51: hr_utility.set_location (' Entering Function GET_PARAMETER', 10);

47: l_proc VARCHAR2 (40) := g_package || ' get parameter ';
48: BEGIN
49: --
50: IF g_debug THEN
51: hr_utility.set_location (' Entering Function GET_PARAMETER', 10);
52: END IF;
53:
54: g_debug := FALSE ;
55: l_start_pos := instr (' ' || p_parameter_string, l_delimiter || p_token || '=');

Line 84: hr_utility.set_location (' Leaving Function GET_PARAMETER', 20);

80: END IF;
81:
82: --
83: IF g_debug THEN
84: hr_utility.set_location (' Leaving Function GET_PARAMETER', 20);
85: END IF;
86:
87: RETURN l_parameter;
88: END;

Line 228: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS', 30);

224: INTO p_emp_catg
225: FROM dual;
226:
227: IF g_debug THEN
228: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS', 30);
229: END IF;
230: END get_all_parameters;
231: /* RANGE CODE */
232: PROCEDURE range_code (

Line 268: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);

264: l_prev_avg_women_count NUMBER;
265: -- Archiving the data , as this will fire once
266: BEGIN
267: IF g_debug THEN
268: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);
269: END IF;
270:
271: p_sql :=
272: 'SELECT DISTINCT person_id

Line 363: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);

359: END LOOP;
360:
361: --END IF; -- G_Archive End
362: IF g_debug THEN
363: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
364: END IF;
365: EXCEPTION
366: WHEN OTHERS THEN
367: -- Return cursor that selects no rows

Line 487: hr_utility.set_location ('Entering Procedure ASSIGNMENT_ACTION_CODE', 60);

483: l_emp_precedence_date DATE;
484: l_emp_type VARCHAR2 (10);
485: BEGIN
486: IF g_debug THEN
487: hr_utility.set_location ('Entering Procedure ASSIGNMENT_ACTION_CODE', 60);
488: END IF;
489:
490: pay_se_trna_archive.get_all_parameters (
491: p_payroll_action_id,

Line 736: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE', 80);

732: p_payroll_action_id IN NUMBER
733: ) IS
734: BEGIN
735: IF g_debug THEN
736: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE', 80);
737: END IF;
738: END initialization_code;
739: /* ARCHIVE CODE */
740: PROCEDURE archive_code (

Line 746: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);

742: p_effective_date IN DATE
743: ) IS
744: BEGIN
745: IF g_debug THEN
746: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);
747: END IF;
748: END archive_code;
749: END pay_se_trna_archive;