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 489: hr_utility.set_location ('Entering Procedure ASSIGNMENT_ACTION_CODE', 60);

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

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

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

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

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