DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on HXT_TIME_COLLECTION

Line 1: PACKAGE BODY hxt_time_collection AS

1: PACKAGE BODY hxt_time_collection AS
2: /* $Header: hxttcol.pkb 120.8.12010000.2 2008/09/11 18:13:13 asrajago ship $ */
3:
4: /*-------------------------------------------------------------------------
5: ||

Line 12: g_package CONSTANT VARCHAR2 (33) := 'hxt_time_collection.';

8: -------------------------------------------------------------------------*/
9:
10: -- Global package name
11: g_debug BOOLEAN := hr_utility.debug_enabled;
12: g_package CONSTANT VARCHAR2 (33) := 'hxt_time_collection.';
13: g_cache BOOLEAN := TRUE;
14: g_max_tc_allowed PLS_INTEGER := fnd_profile.VALUE ('HXT_BATCH_SIZE');
15:
16: TYPE batch_info_rec IS RECORD (

Line 565: l_proc := 'hxt_time_collection.RECORD_TIME';

561: g_debug := hr_utility.debug_enabled;
562:
563: IF g_debug
564: THEN
565: l_proc := 'hxt_time_collection.RECORD_TIME';
566: hr_utility.set_location (l_proc, 10);
567: END IF;
568:
569: SAVEPOINT only_validate;

Line 3020: hxt_time_collection.delete_details (timecard_id,

3016: THEN
3017: RAISE l_sess_date_err;
3018: END IF;
3019:
3020: hxt_time_collection.delete_details (timecard_id,
3021: dt_update_mode,
3022: l_session_date,
3023: l_otm_error
3024: );

Line 3200: hr_utility.set_location ('hxt_time_collection.check_for_timecard',

3196: IS
3197: BEGIN
3198: IF g_debug
3199: THEN
3200: hr_utility.set_location ('hxt_time_collection.check_for_timecard',
3201: 10
3202: );
3203: END IF;
3204:

Line 3215: hr_utility.set_location ('hxt_time_collection.check_for_timecard',

3211: THEN
3212: hr_utility.TRACE ('Timecard id is:' || o_timecard_id);
3213: hr_utility.TRACE ('auto_gen_flag :' || o_auto_gen_flag);
3214: hr_utility.TRACE ('batch_id :' || g_batch_err_id);
3215: hr_utility.set_location ('hxt_time_collection.check_for_timecard',
3216: 20
3217: );
3218: END IF;
3219:

Line 3227: ('hxt_time_collection.check_for_timecard',

3223: THEN
3224: IF g_debug
3225: THEN
3226: hr_utility.set_location
3227: ('hxt_time_collection.check_for_timecard',
3228: 30
3229: );
3230: END IF;
3231:

Line 3238: ('hxt_time_collection.check_for_timecard',

3234: THEN
3235: IF g_debug
3236: THEN
3237: hr_utility.set_location
3238: ('hxt_time_collection.check_for_timecard',
3239: 40
3240: );
3241: END IF;
3242:

Line 3815: l_proc := 'hxt_time_collection.CREATE_HOLIDAY_HOURS';

3811: l_proc VARCHAR2 (100);
3812: BEGIN
3813: IF g_debug
3814: THEN
3815: l_proc := 'hxt_time_collection.CREATE_HOLIDAY_HOURS';
3816: hr_utility.set_location (l_proc, 10);
3817: hr_utility.TRACE ('i_start_date :' || i_start_date);
3818: hr_utility.TRACE ('i_end_date :' || i_end_date);
3819: hr_utility.TRACE ('i_hcl_id :' || i_hcl_id);

Line 4173: l_proc := 'hxt_time_collection.LOAD_POLICIES';

4169: g_debug := hr_utility.debug_enabled;
4170:
4171: IF g_debug
4172: THEN
4173: l_proc := 'hxt_time_collection.LOAD_POLICIES';
4174: hr_utility.set_location (l_proc, 10);
4175: END IF;
4176:
4177: p_hol_yn := 'N';

Line 4479: l_proc := 'hxt_time_collection.RECORD_HOURS_WORKED';

4475: l_changed_flag BOOLEAN;
4476: BEGIN
4477: IF g_debug
4478: THEN
4479: l_proc := 'hxt_time_collection.RECORD_HOURS_WORKED';
4480: hr_utility.set_location (l_proc, 10);
4481: END IF;
4482:
4483: /*Fetch additional assignment details about this employee*/

Line 4658: hxt_time_collection.adjust_timings

4654: hr_utility.set_location (l_proc, 110);
4655: hr_utility.TRACE ('before Adjust_Timings');
4656: END IF;
4657:
4658: hxt_time_collection.adjust_timings
4659: (p_timecard_source,
4660: i_assignment_id,
4661: i_person_id,
4662: i_date_worked,

Line 5407: 'hxt_time_collection',

5403: NULL -- late stop
5404: ,
5405: l_hol_yn,
5406: i_person_id,
5407: 'hxt_time_collection',
5408: l_hours_worked_id,
5409: i_timecard_id,
5410: i_date_worked,
5411: i_assignment_id,

Line 6076: l_proc := 'hxt_time_collection.ADJUST_TIMINGS';

6072: g_debug := hr_utility.debug_enabled;
6073:
6074: IF g_debug
6075: THEN
6076: l_proc := 'hxt_time_collection.ADJUST_TIMINGS';
6077: hr_utility.TRACE ('hxt_time_collection.ADJUST_TIMINGS BEGIN');
6078: hr_utility.set_location (l_proc, 10);
6079: hr_utility.TRACE ( 'p_time_in:'
6080: || TO_CHAR (p_time_in, 'dd-mon-yyyy hh24:mi:ss')

Line 6077: hr_utility.TRACE ('hxt_time_collection.ADJUST_TIMINGS BEGIN');

6073:
6074: IF g_debug
6075: THEN
6076: l_proc := 'hxt_time_collection.ADJUST_TIMINGS';
6077: hr_utility.TRACE ('hxt_time_collection.ADJUST_TIMINGS BEGIN');
6078: hr_utility.set_location (l_proc, 10);
6079: hr_utility.TRACE ( 'p_time_in:'
6080: || TO_CHAR (p_time_in, 'dd-mon-yyyy hh24:mi:ss')
6081: );

Line 6772: hr_utility.TRACE ('hxt_time_collection.ADJUST_TIMINGS END');

6768: p_code := 0;
6769:
6770: IF g_debug
6771: THEN
6772: hr_utility.TRACE ('hxt_time_collection.ADJUST_TIMINGS END');
6773: END IF;
6774: END adjust_timings;
6775:
6776: /**************************************************************

Line 6857: l_proc := 'hxt_time_collection.Check_Time_Overlap';

6853: l_proc VARCHAR2 (100);
6854: BEGIN
6855: IF g_debug
6856: THEN
6857: l_proc := 'hxt_time_collection.Check_Time_Overlap';
6858: hr_utility.set_location (l_proc, 10);
6859: END IF;
6860:
6861: --Check if overlap found

Line 6922: END hxt_time_collection;

6918:
6919: RETURN (l_diff);
6920: END reset_hours;
6921: --END SIR236
6922: END hxt_time_collection;