DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_ALIAS_UTILITY

Line 415: p_att_tab IN hxc_alias_utility.t_alias_att_info

411: /*ADVICE(408): Unreferenced parameter [552] */
412: IN NUMBER,
413: p_insert_detail IN hxc_timekeeper_process.t_time_info,
414: p_base_dff IN VARCHAR2,
415: p_att_tab IN hxc_alias_utility.t_alias_att_info
416: )
417: RETURN VARCHAR2 IS
418: att_dep_item NUMBER
419: /*ADVICE(416): NUMBER has no precision [315] */

Line 512: hxc_alias_utility.get_sfl_from_alias_value (new_att_catg),

508: INTO new_att_catg
509: FROM DUAL;
510: ELSE
511: SELECT DECODE (
512: hxc_alias_utility.get_sfl_from_alias_value (new_att_catg),
513: 'OT', 'PAEXPITDFF - OT',
514: 'PAEXPITDFF - ST'
515: )
516: INTO new_att_catg

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

548: SELECT decode(SUBSTR(new_att_catg,INSTR(new_att_catg,'ALIAS_SEPARATOR')+15),'OT','PAEXPITDFF - OT','PAEXPITDFF - ST')
549: INTO new_att_catg
550: FROM DUAL;
551: else
552: select decode(hxc_alias_utility.get_sfl_from_alias_value(new_att_catg),'OT','PAEXPITDFF - OT','PAEXPITDFF - ST')
553: INTO new_att_catg
554: FROM DUAL;
555: end if;
556: end if;*/

Line 2471: p_tbb_id_reference_table IN OUT NOCOPY hxc_alias_utility.t_tbb_id_reference,

2467: p_detail_ovn IN NUMBER,
2468: p_det_details IN OUT NOCOPY hxc_timekeeper_process.g_detail_data%TYPE,
2469: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
2470: p_attribute_category IN VARCHAR2,
2471: p_tbb_id_reference_table IN OUT NOCOPY hxc_alias_utility.t_tbb_id_reference,
2472: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
2473: p_timecard_index_info
2474: /*ADVICE(1974): Unreferenced parameter [552] */
2475: IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info

Line 2618: hxc_alias_utility.attribute_check (

2614:
2615: IF NVL (l_bldtyp_id, -999) <> -999 THEN
2616: l_attribute_found := FALSE;
2617: --l_attribute_index :=
2618: hxc_alias_utility.attribute_check (
2619: p_bld_blk_info_type_id => l_bldtyp_id,
2620: p_time_building_block_id => p_detail_id,
2621: p_attributes => p_attributes,
2622: p_tbb_id_reference_table => p_tbb_id_reference_table,

Line 3017: hxc_alias_utility.get_alias_definition_info (

3013: /*ADVICE(2484): NUMBER has no precision [315] */
3014: := 0;
3015: l_colmtype VARCHAR2 (10);
3016: BEGIN
3017: hxc_alias_utility.get_alias_definition_info (
3018: p_alias_definition_id => p_aliasid,
3019: p_alias_type => l_alias_type,
3020: p_reference_object => l_ref_obj,
3021: p_prompt => l_a

Line 3025: hxc_alias_utility.get_vset_table_type_select (

3021: p_prompt => l_a
3022: );
3023:
3024: IF l_alias_type = 'VALUE_SET_TABLE' THEN
3025: hxc_alias_utility.get_vset_table_type_select (
3026: p_alias_definition_id => p_aliasid,
3027: x_select => l_s_query,
3028: p_id_type => l_colmtype
3029: );

Line 3032: hxc_alias_utility.get_vset_indep_type_select (

3028: p_id_type => l_colmtype
3029: );
3030: l_s_query := 'select display_value,id_value from (' || l_s_query || ') ';
3031: ELSIF l_alias_type = 'VALUE_SET_INDEPENDENT' THEN
3032: hxc_alias_utility.get_vset_indep_type_select (
3033: p_alias_definition_id => p_aliasid,
3034: x_select => l_s_query
3035: );
3036: l_s_query := 'select display_value,id_value from (' || l_s_query || ') ';

Line 3039: hxc_alias_utility.get_otl_an_context_type_select (

3035: );
3036: l_s_query := 'select display_value,id_value from (' || l_s_query || ') ';
3037: l_colmtype := 'NUMBER';
3038: ELSIF l_alias_type = 'OTL_ALT_DDF' THEN
3039: hxc_alias_utility.get_otl_an_context_type_select (
3040: p_alias_definition_id => p_aliasid,
3041: p_timekeeper_person_type => p_person_type,
3042: x_select => l_s_query
3043: );

Line 3047: hxc_alias_utility.get_vset_none_type_property (

3043: );
3044: l_s_query := 'select display_value,id_value from (' || l_s_query || ') ';
3045: l_colmtype := 'NUMBER';
3046: ELSIF l_alias_type = 'VALUE_SET_NONE' THEN
3047: hxc_alias_utility.get_vset_none_type_property (
3048: p_alias_definition_id => p_aliasid,
3049: p_format_type => l_s_query,
3050: p_maximum_size => l_max_size,
3051: p_minimum_value => l_min_value,