DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_TIMEKEEPER_UTILITIES

Line 1: PACKAGE BODY hxc_timekeeper_utilities AS

1: PACKAGE BODY hxc_timekeeper_utilities AS
2: /* $Header: hxctkutil.pkb 120.30 2011/12/23 12:45:26 jnerella ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: -------------------------------------------------------------------------------
5: -- this procedure add a block in the block_table

Line 849: emp_tc_info OUT NOCOPY hxc_timekeeper_utilities.emptctab

845: PROCEDURE populate_tc_tab (
846: resource_id IN NUMBER,
847: tc_frdt IN DATE,
848: tc_todt IN DATE,
849: emp_tc_info OUT NOCOPY hxc_timekeeper_utilities.emptctab
850: ) IS
851: CURSOR get_tc_data (
852: p_resource_id NUMBER,
853: p_tc_frdt DATE,

Line 928: emp_qry_tc_info OUT NOCOPY hxc_timekeeper_utilities.emptctab

924: PROCEDURE populate_query_tc_tab (
925: resource_id IN NUMBER,
926: tc_frdt IN DATE,
927: tc_todt IN DATE,
928: emp_qry_tc_info OUT NOCOPY hxc_timekeeper_utilities.emptctab
929: ) IS
930: CURSOR get_tc_data (
931: p_resource_id NUMBER,
932: p_tc_frdt DATE,

Line 1003: p_spemp_tc_info IN hxc_timekeeper_utilities.emptctab,

999: PROCEDURE split_timecard (
1000: p_resource_id IN NUMBER,
1001: p_start_date IN DATE,
1002: p_end_date IN DATE,
1003: p_spemp_tc_info IN hxc_timekeeper_utilities.emptctab,
1004: p_tc_list OUT NOCOPY hxc_timecard_utilities.periods
1005: ) IS
1006: m_periods
1007: /*ADVICE(977): Unreferenced variable [553] */

Line 1077: hxc_timekeeper_utilities.get_emp_pref (

1073: l_emp_layout6 := NULL;
1074: l_emp_layout7 := NULL;
1075: l_emp_layout8 := NULL;
1076: l_emp_edits := NULL;
1077: hxc_timekeeper_utilities.get_emp_pref (
1078: p_resource_id,
1079: l_emp_negpref,
1080: l_emp_recpref,
1081: l_emp_appstyle,

Line 2104: l_proc := 'hxc_timekeeper_utilities'

2100: l_dummy NUMBER (1);
2101: BEGIN
2102: g_debug :=hr_utility.debug_enabled;
2103: if g_debug then
2104: l_proc := 'hxc_timekeeper_utilities'
2105: || 'tc_edit_allowed';
2106: hr_utility.set_location('Entering '||l_proc, 10);
2107: end if;
2108: --l_tc_status := hxc_timecard_search_pkg.get_timecard_status_code(p_timecard_id,p_Timecard_Ovn);

Line 2650: hxc_timekeeper_utilities.add_dff_attribute (

2646: --IF l_attribute_index = -1 THEN
2647: IF NOT (l_attribute_found) THEN
2648: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
2649: l_attribute_index := hxc_timekeeper_process.g_negative_index;
2650: hxc_timekeeper_utilities.add_dff_attribute (
2651: p_attribute => p_attributes,
2652: p_attribute_id => l_attribute_index,
2653: p_tbb_id => p_detail_id,
2654: p_tbb_ovn => p_detail_ovn,

Line 2702: hxc_timekeeper_utilities.add_dff_attribute (

2698: '|' || hxc_timekeeper_process.g_negative_index;
2699: END IF;
2700: ELSE
2701: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
2702: hxc_timekeeper_utilities.add_dff_attribute (
2703: p_attribute => p_attributes,
2704: p_attribute_id => l_attribute_index,
2705: p_tbb_id => p_detail_id,
2706: p_tbb_ovn => p_detail_ovn,

Line 2913: hxc_timekeeper_utilities.add_resource_to_perftab (

2909: CLOSE c_emp_terminateinfo;
2910: /*end of changes by senthil*/
2911: FOR l_index IN
2912: l_resource_table (l_resource_pref_index).start_index .. l_resource_table (l_resource_pref_index).stop_index LOOP
2913: hxc_timekeeper_utilities.add_resource_to_perftab (
2914: p_resource_id => l_resource_pref_index,
2915: p_pref_code => l_pref_table (l_index).preference_code,
2916: p_attribute1 => l_pref_table (l_index).attribute1,
2917: p_attribute2 => l_pref_table (l_index).attribute2,

Line 2947: p_periodname_list OUT NOCOPY hxc_timekeeper_utilities.t_group_list

2943: -- ----------------------------------------------------------------------------
2944: PROCEDURE get_group_period_list (
2945: p_group_id IN NUMBER,
2946: p_business_group_id IN NUMBER,
2947: p_periodname_list OUT NOCOPY hxc_timekeeper_utilities.t_group_list
2948: ) IS
2949: /*start of fix 5083261*/
2950: CURSOR c_pref_cursor IS
2951: select recurring_period_id rec_period,rownum periodname_index from (

Line 2964: hxc_timekeeper_utilities.t_group_list;

2960: /*ADVICE(2415): Unreferenced variable [553] */
2961: hxc_preference_evaluation.t_pref_table;
2962: l_periodname_list
2963: /*ADVICE(2418): Unreferenced variable [553] */
2964: hxc_timekeeper_utilities.t_group_list;
2965: l_pref_index
2966: /*ADVICE(2421): Unreferenced variable [553] */
2967: NUMBER
2968: /*ADVICE(2423): NUMBER has no precision [315] */

Line 3090: p_tk_layout_info OUT NOCOPY hxc_timekeeper_utilities.tk_layout_tab,

3086: -- Used in form to get alias information for all the Timekeeper layout attributes
3087: -- ----------------------------------------------------------------------------
3088: PROCEDURE populate_alias_table (
3089: p_timekeeper_id IN NUMBER,
3090: p_tk_layout_info OUT NOCOPY hxc_timekeeper_utilities.tk_layout_tab,
3091: p_att_alias_table OUT NOCOPY hxc_timekeeper_utilities.att_alias_list
3092: ) IS
3093: l_pref_table hxc_preference_evaluation.t_pref_table;
3094: l_index NUMBER

Line 3091: p_att_alias_table OUT NOCOPY hxc_timekeeper_utilities.att_alias_list

3087: -- ----------------------------------------------------------------------------
3088: PROCEDURE populate_alias_table (
3089: p_timekeeper_id IN NUMBER,
3090: p_tk_layout_info OUT NOCOPY hxc_timekeeper_utilities.tk_layout_tab,
3091: p_att_alias_table OUT NOCOPY hxc_timekeeper_utilities.att_alias_list
3092: ) IS
3093: l_pref_table hxc_preference_evaluation.t_pref_table;
3094: l_index NUMBER
3095: /*ADVICE(2548): NUMBER has no precision [315] */

Line 3151: hxc_timekeeper_utilities.g_default_rec_period:= l_pref_table (l_index).attribute6;

3147: p_tk_layout_info (1).tk_applset := l_pref_table (l_index).attribute5;
3148:
3149: -- Added for Enh 3303359
3150: -- Caching the pref value for Default Recurring Period
3151: hxc_timekeeper_utilities.g_default_rec_period:= l_pref_table (l_index).attribute6;
3152:
3153:
3154: ELSIF (l_pref_table (l_index).preference_code = 'TK_TCARD_CLA') THEN --CTK
3155: p_tk_layout_info (1).tk_audit_enabled := l_pref_table (l_index).attribute1;

Line 3648: hxc_timekeeper_utilities.g_tk_show_absences:= 1;

3644: if ( nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y'
3645: and nvl(l_pref_table (l_index).attribute1,'N') = 'Y'
3646: and nvl(l_pref_table (l_index).attribute5,'N') = 'Y') then
3647:
3648: hxc_timekeeper_utilities.g_tk_show_absences:= 1;
3649:
3650: else
3651:
3652: hxc_timekeeper_utilities.g_tk_show_absences:= 0;

Line 3652: hxc_timekeeper_utilities.g_tk_show_absences:= 0;

3648: hxc_timekeeper_utilities.g_tk_show_absences:= 1;
3649:
3650: else
3651:
3652: hxc_timekeeper_utilities.g_tk_show_absences:= 0;
3653:
3654: end if;
3655:
3656: END IF;

Line 3670: p_emptcinfo OUT NOCOPY hxc_timekeeper_utilities.emptctab

3666: PROCEDURE populate_disable_tc_tab (
3667: resource_id IN NUMBER,
3668: tc_frdt IN DATE,
3669: tc_todt IN DATE,
3670: p_emptcinfo OUT NOCOPY hxc_timekeeper_utilities.emptctab
3671: ) IS
3672: CURSOR get_tc_data (
3673: p_resource_id NUMBER,
3674: p_tc_frdt DATE,

Line 3726: p_emptcinfo OUT NOCOPY hxc_timekeeper_utilities.emptctab

3722: PROCEDURE new_timecard (
3723: p_resource_id IN NUMBER,
3724: p_start_date IN DATE,
3725: p_end_date IN DATE,
3726: p_emptcinfo OUT NOCOPY hxc_timekeeper_utilities.emptctab
3727: ) IS
3728: m_periods
3729: /*ADVICE(3159): Unreferenced variable [553] */
3730: VARCHAR2 (2000);

Line 3816: hxc_timekeeper_utilities.get_emp_pref (

3812: /*ADVICE(3239): This item should be defined in a deeper scope [558] */
3813: VARCHAR2 (150);
3814: BEGIN
3815: BEGIN
3816: hxc_timekeeper_utilities.get_emp_pref (
3817: p_resource_id,
3818: l_emp_negpref,
3819: l_emp_recpref,
3820: l_emp_appstyle,

Line 3845: hxc_timekeeper_utilities.get_resource_time_periods (

3841:
3842: END;
3843:
3844: l_newtab.DELETE;
3845: hxc_timekeeper_utilities.get_resource_time_periods (
3846: p_resource_id => p_resource_id,
3847: p_resource_type => 'PERSON',
3848: p_current_date => SYSDATE,
3849: p_max_date_in_futur => TO_DATE (p_end_date, 'dd-mm-rrrr') + 1,

Line 3893: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;

3889: indx binary_integer;
3890: l_detail_blocks hxc_tk_detail_temp_tab;
3891: cursor csr_tk is select * from hxc_tk_detail_temp;
3892: begin
3893: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;
3894: if p_action =1 then
3895: open csr_tk;
3896: loop
3897: j:=j+1;

Line 4083: hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab:=l_detail_blocks;

4079: end loop;
4080: END if;
4081: /* end of fix for 5398144 */
4082: end if;
4083: hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab:=l_detail_blocks;
4084: end;
4085:
4086:
4087: FUNCTION get_exp_type_from_alias (

Line 4655: (p_tk_prepop_info IN hxc_timekeeper_utilities.t_tk_prepop_info_type,

4651: ---------------------------------------------------------------------------------------------------
4652:
4653:
4654: PROCEDURE build_absence_prepop_table
4655: (p_tk_prepop_info IN hxc_timekeeper_utilities.t_tk_prepop_info_type,
4656: p_tk_abs_tab OUT NOCOPY hxc_timekeeper_process.t_tk_abs_tab_type,
4657: p_start_period IN DATE,
4658: p_end_period IN DATE,
4659: p_tc_start IN DATE,

Line 6126: END hxc_timekeeper_utilities;

6122:
6123: ------------------------------------------------------------------------------------------------
6124:
6125:
6126: END hxc_timekeeper_utilities;