DBA Data[Home] [Help]

APPS.PAY_SE_SLSA_ARCHIVE dependencies on HR_UTILITY

Line 3: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY pay_se_slsa_archive AS
2: /* $Header: pyseslsa.pkb 120.1 2007/08/21 05:29:27 psingla noship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4: g_package VARCHAR2 (33) := 'PAY_SE_SLSA_ARCHIVE.';
5: g_payroll_action_id NUMBER;
6: -- Globals to pick up all the parameter
7: g_business_group_id NUMBER;

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

36: l_proc VARCHAR2 (40) := g_package || ' get parameter ';
37: BEGIN
38: --
39: IF g_debug THEN
40: hr_utility.set_location (' Entering Function GET_PARAMETER', 10);
41: END IF;
42:
43: l_start_pos := instr (' ' || p_parameter_string, l_delimiter || p_token || '=');
44:

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

68: END IF;
69:
70: --
71: IF g_debug THEN
72: hr_utility.set_location (' Leaving Function GET_PARAMETER', 20);
73: END IF;
74:
75: RETURN l_parameter;
76: END;

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

127: p_effective_date := lr_parameter_info.effective_date;
128: p_business_group_id := lr_parameter_info.bg_id;
129:
130: IF g_debug THEN
131: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS', 30);
132: END IF;
133: END get_all_parameters;
134: /* procedure to get the working hours and day for the business group */
135: PROCEDURE get_schedule_duration (

Line 198: hr_utility.set_location ('start date time ' || l_schedule (l_idx).start_date_time, 20);

194: -- dbms_output.put_line('Inside FREE_BUSY_TYPE' ||l_schedule(l_idx).FREE_BUSY_TYPE ) ;
195: IF l_first_band THEN
196: l_first_band := FALSE ;
197: l_ref_date := trunc (l_schedule (l_idx).start_date_time);
198: hr_utility.set_location ('start date time ' || l_schedule (l_idx).start_date_time, 20);
199: hr_utility.set_location ('end date time ' || l_schedule (l_idx).end_date_time, 20);
200:
201: IF (trunc (l_schedule (l_idx).end_date_time) = trunc (l_schedule (l_idx).start_date_time)) THEN
202: p_duration := p_duration

Line 199: hr_utility.set_location ('end date time ' || l_schedule (l_idx).end_date_time, 20);

195: IF l_first_band THEN
196: l_first_band := FALSE ;
197: l_ref_date := trunc (l_schedule (l_idx).start_date_time);
198: hr_utility.set_location ('start date time ' || l_schedule (l_idx).start_date_time, 20);
199: hr_utility.set_location ('end date time ' || l_schedule (l_idx).end_date_time, 20);
200:
201: IF (trunc (l_schedule (l_idx).end_date_time) = trunc (l_schedule (l_idx).start_date_time)) THEN
202: p_duration := p_duration
203: + (trunc (l_schedule (l_idx).end_date_time)

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

914: BEGIN
915: g_debug := TRUE ;
916:
917: IF g_debug THEN
918: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);
919: END IF;
920:
921: p_sql :=
922: 'SELECT DISTINCT person_id

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

1018: END LOOP;
1019: END IF; -- FOR G_LEGAL_EMPLOYER
1020: --END IF; -- G_Archive End
1021: IF g_debug THEN
1022: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
1023: END IF;
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: -- Return cursor that selects no rows

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

1034: p_chunk IN NUMBER
1035: ) IS
1036: BEGIN
1037: IF g_debug THEN
1038: hr_utility.set_location (' Entering Procedure ASSIGNMENT_ACTION_CODE', 60);
1039: END IF;
1040: END assignment_action_code;
1041: /* INITIALIZATION CODE */
1042: PROCEDURE initialization_code (

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

1043: p_payroll_action_id IN NUMBER
1044: ) IS
1045: BEGIN
1046: IF g_debug THEN
1047: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE', 80);
1048: END IF;
1049: END initialization_code;
1050: /* ARCHIVE CODE */
1051: PROCEDURE archive_code (

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

1053: p_effective_date IN DATE
1054: ) IS
1055: BEGIN
1056: IF g_debug THEN
1057: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);
1058: END IF;
1059: END archive_code;
1060: END pay_se_slsa_archive;