APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_ALIAS_UTILITY

Line 433: p_att_tab IN hxc_alias_utility.t_alias_att_info

429: /*ADVICE(408): Unreferenced parameter [552] */
430: IN NUMBER,
431: p_insert_detail IN hxc_timekeeper_process.t_time_info,
432: p_base_dff IN VARCHAR2,
433: p_att_tab IN hxc_alias_utility.t_alias_att_info
434: )
435: RETURN VARCHAR2 IS
436: att_dep_item NUMBER
437: /*ADVICE(416): NUMBER has no precision [315] */

Line 530: hxc_alias_utility.get_sfl_from_alias_value (new_att_catg),

526: INTO new_att_catg
527: FROM DUAL;
528: ELSE
529: SELECT DECODE (
530: hxc_alias_utility.get_sfl_from_alias_value (new_att_catg),
531: 'OT', 'PAEXPITDFF - OT',
532: 'PAEXPITDFF - ST'
533: )
534: INTO new_att_catg

Line 570: select decode(hxc_alias_utility.get_sfl_from_alias_value(new_att_catg),'OT','PAEXPITDFF - OT','PAEXPITDFF - ST')

566: SELECT decode(SUBSTR(new_att_catg,INSTR(new_att_catg,'ALIAS_SEPARATOR')+15),'OT','PAEXPITDFF - OT','PAEXPITDFF - ST')
567: INTO new_att_catg
568: FROM DUAL;
569: else
570: select decode(hxc_alias_utility.get_sfl_from_alias_value(new_att_catg),'OT','PAEXPITDFF - OT','PAEXPITDFF - ST')
571: INTO new_att_catg
572: FROM DUAL;
573: end if;
574: end if;*/

Line 2489: p_tbb_id_reference_table IN OUT NOCOPY hxc_alias_utility.t_tbb_id_reference,

2485: p_detail_ovn IN NUMBER,
2486: p_det_details IN OUT NOCOPY hxc_timekeeper_process.g_detail_data%TYPE,
2487: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
2488: p_attribute_category IN VARCHAR2,
2489: p_tbb_id_reference_table IN OUT NOCOPY hxc_alias_utility.t_tbb_id_reference,
2490: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
2491: p_timecard_index_info
2492: /*ADVICE(1974): Unreferenced parameter [552] */
2493: IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info

Line 2636: hxc_alias_utility.attribute_check (

2632:
2633: IF NVL (l_bldtyp_id, -999) <> -999 THEN
2634: l_attribute_found := FALSE;
2635: --l_attribute_index :=
2636: hxc_alias_utility.attribute_check (
2637: p_bld_blk_info_type_id => l_bldtyp_id,
2638: p_time_building_block_id => p_detail_id,
2639: p_attributes => p_attributes,
2640: p_tbb_id_reference_table => p_tbb_id_reference_table,

Line 3035: hxc_alias_utility.get_alias_definition_info (

3031: /*ADVICE(2484): NUMBER has no precision [315] */
3032: := 0;
3033: l_colmtype VARCHAR2 (10);
3034: BEGIN
3035: hxc_alias_utility.get_alias_definition_info (
3036: p_alias_definition_id => p_aliasid,
3037: p_alias_type => l_alias_type,
3038: p_reference_object => l_ref_obj,
3039: p_prompt => l_a

Line 3043: hxc_alias_utility.get_vset_table_type_select (

3039: p_prompt => l_a
3040: );
3041:
3042: IF l_alias_type = 'VALUE_SET_TABLE' THEN
3043: hxc_alias_utility.get_vset_table_type_select (
3044: p_alias_definition_id => p_aliasid,
3045: x_select => l_s_query,
3046: p_id_type => l_colmtype
3047: );

Line 3050: hxc_alias_utility.get_vset_indep_type_select (

3046: p_id_type => l_colmtype
3047: );
3048: l_s_query := 'select display_value,id_value from (' || l_s_query || ') ';
3049: ELSIF l_alias_type = 'VALUE_SET_INDEPENDENT' THEN
3050: hxc_alias_utility.get_vset_indep_type_select (
3051: p_alias_definition_id => p_aliasid,
3052: x_select => l_s_query
3053: );
3054: l_s_query := 'select display_value,id_value from (' || l_s_query || ') ';

Line 3057: hxc_alias_utility.get_otl_an_context_type_select (

3053: );
3054: l_s_query := 'select display_value,id_value from (' || l_s_query || ') ';
3055: l_colmtype := 'NUMBER';
3056: ELSIF l_alias_type = 'OTL_ALT_DDF' THEN
3057: hxc_alias_utility.get_otl_an_context_type_select (
3058: p_alias_definition_id => p_aliasid,
3059: p_timekeeper_person_type => p_person_type,
3060: x_select => l_s_query
3061: );

Line 3065: hxc_alias_utility.get_vset_none_type_property (

3061: );
3062: l_s_query := 'select display_value,id_value from (' || l_s_query || ') ';
3063: l_colmtype := 'NUMBER';
3064: ELSIF l_alias_type = 'VALUE_SET_NONE' THEN
3065: hxc_alias_utility.get_vset_none_type_property (
3066: p_alias_definition_id => p_aliasid,
3067: p_format_type => l_s_query,
3068: p_maximum_size => l_max_size,
3069: p_minimum_value => l_min_value,

Line 5853: l_alias_def_item HXC_ALIAS_UTILITY.t_alias_def_item;

5849: rownum < 2;
5850:
5851:
5852: l_abs_tab HXC_RETRIEVE_ABSENCES.ABS_TAB;
5853: l_alias_def_item HXC_ALIAS_UTILITY.t_alias_def_item;
5854:
5855: l_tk_prepop_info_counter binary_integer:=0;
5856: l_tk_prepop_info t_tk_prepop_info_type ;
5857:

Line 5996: HXC_ALIAS_UTILITY.get_alias_def_item (p_timekeeper_id => p_timekeeper_id,

5992: END IF;
5993:
5994:
5995:
5996: HXC_ALIAS_UTILITY.get_alias_def_item (p_timekeeper_id => p_timekeeper_id,
5997: p_alias_def_item => l_alias_def_item
5998: );
5999:
6000: if g_debug then