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.15.12010000.4 2008/11/13 16:59:07 asrajago ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: -------------------------------------------------------------------------------
5: -- this procedure add a block in the block_table

Line 831: emp_tc_info OUT NOCOPY hxc_timekeeper_utilities.emptctab

827: PROCEDURE populate_tc_tab (
828: resource_id IN NUMBER,
829: tc_frdt IN DATE,
830: tc_todt IN DATE,
831: emp_tc_info OUT NOCOPY hxc_timekeeper_utilities.emptctab
832: ) IS
833: CURSOR get_tc_data (
834: p_resource_id NUMBER,
835: p_tc_frdt DATE,

Line 910: emp_qry_tc_info OUT NOCOPY hxc_timekeeper_utilities.emptctab

906: PROCEDURE populate_query_tc_tab (
907: resource_id IN NUMBER,
908: tc_frdt IN DATE,
909: tc_todt IN DATE,
910: emp_qry_tc_info OUT NOCOPY hxc_timekeeper_utilities.emptctab
911: ) IS
912: CURSOR get_tc_data (
913: p_resource_id NUMBER,
914: p_tc_frdt DATE,

Line 985: p_spemp_tc_info IN hxc_timekeeper_utilities.emptctab,

981: PROCEDURE split_timecard (
982: p_resource_id IN NUMBER,
983: p_start_date IN DATE,
984: p_end_date IN DATE,
985: p_spemp_tc_info IN hxc_timekeeper_utilities.emptctab,
986: p_tc_list OUT NOCOPY hxc_timecard_utilities.periods
987: ) IS
988: m_periods
989: /*ADVICE(977): Unreferenced variable [553] */

Line 1059: hxc_timekeeper_utilities.get_emp_pref (

1055: l_emp_layout6 := NULL;
1056: l_emp_layout7 := NULL;
1057: l_emp_layout8 := NULL;
1058: l_emp_edits := NULL;
1059: hxc_timekeeper_utilities.get_emp_pref (
1060: p_resource_id,
1061: l_emp_negpref,
1062: l_emp_recpref,
1063: l_emp_appstyle,

Line 2086: l_proc := 'hxc_timekeeper_utilities'

2082: l_dummy NUMBER (1);
2083: BEGIN
2084: g_debug :=hr_utility.debug_enabled;
2085: if g_debug then
2086: l_proc := 'hxc_timekeeper_utilities'
2087: || 'tc_edit_allowed';
2088: hr_utility.set_location('Entering '||l_proc, 10);
2089: end if;
2090: --l_tc_status := hxc_timecard_search_pkg.get_timecard_status_code(p_timecard_id,p_Timecard_Ovn);

Line 2632: hxc_timekeeper_utilities.add_dff_attribute (

2628: --IF l_attribute_index = -1 THEN
2629: IF NOT (l_attribute_found) THEN
2630: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
2631: l_attribute_index := hxc_timekeeper_process.g_negative_index;
2632: hxc_timekeeper_utilities.add_dff_attribute (
2633: p_attribute => p_attributes,
2634: p_attribute_id => l_attribute_index,
2635: p_tbb_id => p_detail_id,
2636: p_tbb_ovn => p_detail_ovn,

Line 2684: hxc_timekeeper_utilities.add_dff_attribute (

2680: '|' || hxc_timekeeper_process.g_negative_index;
2681: END IF;
2682: ELSE
2683: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
2684: hxc_timekeeper_utilities.add_dff_attribute (
2685: p_attribute => p_attributes,
2686: p_attribute_id => l_attribute_index,
2687: p_tbb_id => p_detail_id,
2688: p_tbb_ovn => p_detail_ovn,

Line 2895: hxc_timekeeper_utilities.add_resource_to_perftab (

2891: CLOSE c_emp_terminateinfo;
2892: /*end of changes by senthil*/
2893: FOR l_index IN
2894: l_resource_table (l_resource_pref_index).start_index .. l_resource_table (l_resource_pref_index).stop_index LOOP
2895: hxc_timekeeper_utilities.add_resource_to_perftab (
2896: p_resource_id => l_resource_pref_index,
2897: p_pref_code => l_pref_table (l_index).preference_code,
2898: p_attribute1 => l_pref_table (l_index).attribute1,
2899: p_attribute2 => l_pref_table (l_index).attribute2,

Line 2929: p_periodname_list OUT NOCOPY hxc_timekeeper_utilities.t_group_list

2925: -- ----------------------------------------------------------------------------
2926: PROCEDURE get_group_period_list (
2927: p_group_id IN NUMBER,
2928: p_business_group_id IN NUMBER,
2929: p_periodname_list OUT NOCOPY hxc_timekeeper_utilities.t_group_list
2930: ) IS
2931: /*start of fix 5083261*/
2932: CURSOR c_pref_cursor IS
2933: select recurring_period_id rec_period,rownum periodname_index from (

Line 2946: hxc_timekeeper_utilities.t_group_list;

2942: /*ADVICE(2415): Unreferenced variable [553] */
2943: hxc_preference_evaluation.t_pref_table;
2944: l_periodname_list
2945: /*ADVICE(2418): Unreferenced variable [553] */
2946: hxc_timekeeper_utilities.t_group_list;
2947: l_pref_index
2948: /*ADVICE(2421): Unreferenced variable [553] */
2949: NUMBER
2950: /*ADVICE(2423): NUMBER has no precision [315] */

Line 3072: p_tk_layout_info OUT NOCOPY hxc_timekeeper_utilities.tk_layout_tab,

3068: -- Used in form to get alias information for all the Timekeeper layout attributes
3069: -- ----------------------------------------------------------------------------
3070: PROCEDURE populate_alias_table (
3071: p_timekeeper_id IN NUMBER,
3072: p_tk_layout_info OUT NOCOPY hxc_timekeeper_utilities.tk_layout_tab,
3073: p_att_alias_table OUT NOCOPY hxc_timekeeper_utilities.att_alias_list
3074: ) IS
3075: l_pref_table hxc_preference_evaluation.t_pref_table;
3076: l_index NUMBER

Line 3073: p_att_alias_table OUT NOCOPY hxc_timekeeper_utilities.att_alias_list

3069: -- ----------------------------------------------------------------------------
3070: PROCEDURE populate_alias_table (
3071: p_timekeeper_id IN NUMBER,
3072: p_tk_layout_info OUT NOCOPY hxc_timekeeper_utilities.tk_layout_tab,
3073: p_att_alias_table OUT NOCOPY hxc_timekeeper_utilities.att_alias_list
3074: ) IS
3075: l_pref_table hxc_preference_evaluation.t_pref_table;
3076: l_index NUMBER
3077: /*ADVICE(2548): NUMBER has no precision [315] */

Line 3631: p_emptcinfo OUT NOCOPY hxc_timekeeper_utilities.emptctab

3627: PROCEDURE populate_disable_tc_tab (
3628: resource_id IN NUMBER,
3629: tc_frdt IN DATE,
3630: tc_todt IN DATE,
3631: p_emptcinfo OUT NOCOPY hxc_timekeeper_utilities.emptctab
3632: ) IS
3633: CURSOR get_tc_data (
3634: p_resource_id NUMBER,
3635: p_tc_frdt DATE,

Line 3687: p_emptcinfo OUT NOCOPY hxc_timekeeper_utilities.emptctab

3683: PROCEDURE new_timecard (
3684: p_resource_id IN NUMBER,
3685: p_start_date IN DATE,
3686: p_end_date IN DATE,
3687: p_emptcinfo OUT NOCOPY hxc_timekeeper_utilities.emptctab
3688: ) IS
3689: m_periods
3690: /*ADVICE(3159): Unreferenced variable [553] */
3691: VARCHAR2 (2000);

Line 3777: hxc_timekeeper_utilities.get_emp_pref (

3773: /*ADVICE(3239): This item should be defined in a deeper scope [558] */
3774: VARCHAR2 (150);
3775: BEGIN
3776: BEGIN
3777: hxc_timekeeper_utilities.get_emp_pref (
3778: p_resource_id,
3779: l_emp_negpref,
3780: l_emp_recpref,
3781: l_emp_appstyle,

Line 3806: hxc_timekeeper_utilities.get_resource_time_periods (

3802:
3803: END;
3804:
3805: l_newtab.DELETE;
3806: hxc_timekeeper_utilities.get_resource_time_periods (
3807: p_resource_id => p_resource_id,
3808: p_resource_type => 'PERSON',
3809: p_current_date => SYSDATE,
3810: p_max_date_in_futur => TO_DATE (p_end_date, 'dd-mm-rrrr') + 1,

Line 3854: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;

3850: indx binary_integer;
3851: l_detail_blocks hxc_tk_detail_temp_tab;
3852: cursor csr_tk is select * from hxc_tk_detail_temp;
3853: begin
3854: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;
3855: if p_action =1 then
3856: open csr_tk;
3857: loop
3858: j:=j+1;

Line 4044: hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab:=l_detail_blocks;

4040: end loop;
4041: END if;
4042: /* end of fix for 5398144 */
4043: end if;
4044: hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab:=l_detail_blocks;
4045: end;
4046:
4047:
4048: FUNCTION get_exp_type_from_alias (

Line 4085: END hxc_timekeeper_utilities;

4081: EXCEPTION
4082: WHEN NO_DATA_FOUND THEN
4083: RETURN FALSE;
4084: END;
4085: END hxc_timekeeper_utilities;