DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_PROCESS dependencies on HXC_ALIAS_UTILITY

Line 1102: p_processing_mode => hxc_alias_utility.c_tk_processing,

1098: p_blocks => l_timecard,
1099: p_start_time => tc_start,
1100: p_stop_time => tc_end,
1101: p_resource_id => p_timekeeper_id,
1102: p_processing_mode => hxc_alias_utility.c_tk_processing,
1103: p_messages => l_messages
1104: );
1105: --t_base_table--used to take the output of translator and convert into matrix
1106:

Line 5226: att_seg_tab hxc_alias_utility.t_alias_att_info;

5222: ;
5223: l_tc_status VARCHAR2 (15) := NULL;
5224: /*ADVICE(3652): Initialization to NULL is superfluous [417] */
5225:
5226: att_seg_tab hxc_alias_utility.t_alias_att_info;
5227: spemp_tc_list hxc_timecard_utilities.periods;
5228: spemp_tc_info hxc_timekeeper_utilities.emptctab;
5229: sp_index NUMBER
5230: /*ADVICE(3658): NUMBER has no precision [315] */

Line 5369: hxc_alias_utility.get_alias_att_info (p_timekeeper_id, att_seg_tab);

5365:
5366: --get the attributes information associated with timekeeper into att_seg_tab table.
5367:
5368: att_seg_tab.DELETE;
5369: hxc_alias_utility.get_alias_att_info (p_timekeeper_id, att_seg_tab);
5370: -- Now we have a table that contains all the indexes of the insert_table
5371: -- by resource_id
5372: -- Let start to build the time_building_block and attributes table by
5373: -- resource_id and deposit it.

Line 6975: p_blk_id => hxc_alias_utility.get_bld_blk_type_id ('LAYOUT'),

6971: p_attribute_id => g_negative_index,
6972: p_tbb_id => l_timecard_id,
6973: p_tbb_ovn => l_timecard_ovn,
6974: p_blk_type => 'LAYOUT',
6975: p_blk_id => hxc_alias_utility.get_bld_blk_type_id ('LAYOUT'),
6976: p_att_category => 'LAYOUT',
6977: p_att_1 => l_emp_layout1,
6978: p_att_2 => l_emp_layout2,
6979: p_att_3 => l_emp_layout3,

Line 7203: p_att_tab IN hxc_alias_utility.t_alias_att_info,

7199: -------------------------------------------------------------------------------
7200:
7201: PROCEDURE create_detail_structure (
7202: p_timekeeper_id IN NUMBER,
7203: p_att_tab IN hxc_alias_utility.t_alias_att_info,
7204: p_resource_id IN NUMBER,
7205: p_start_period IN DATE,
7206: p_end_period IN DATE,
7207: p_tc_frdt IN DATE,

Line 7264: l_tbb_id_reference_table hxc_alias_utility.t_tbb_id_reference;

7260: ;
7261: l_result
7262: /*ADVICE(5073): Unreferenced variable [553] */
7263: VARCHAR2 (10);
7264: l_tbb_id_reference_table hxc_alias_utility.t_tbb_id_reference;
7265: n
7266: /*ADVICE(5077): Unreferenced variable [553] */
7267: NUMBER
7268: /*ADVICE(5079): NUMBER has no precision [315] */

Line 7518: hxc_alias_utility.get_tbb_id_reference_table (

7514: --
7515:
7516: IF l_action = 'UPDATE' THEN -- create the tbb_id table reference
7517: -- for each time_building_block_id let create a reference attribute_id table
7518: hxc_alias_utility.get_tbb_id_reference_table (
7519: p_attributes => p_attributes,
7520: p_tbb_id_reference_table => l_tbb_id_reference_table
7521: );
7522: END IF;

Line 8413: hxc_alias_utility.attribute_check (

8409: AND NVL (bldtyp_id, -999) <> -999 THEN -- and l_detail_dff_found THEN
8410:
8411: l_attribute_found := FALSE;
8412: --l_attribute_index :=
8413: hxc_alias_utility.attribute_check (
8414: p_bld_blk_info_type_id => bldtyp_id,
8415: p_time_building_block_id => l_detail_id,
8416: p_attributes => p_attributes,
8417: p_tbb_id_reference_table => l_tbb_id_reference_table,

Line 8513: hxc_alias_utility.attribute_check (

8509: AND NVL (reason_bldtyp_id, -999) <> -999 THEN
8510:
8511: l_attribute_found := FALSE;
8512: --l_attribute_index :=
8513: hxc_alias_utility.attribute_check (
8514: p_bld_blk_info_type_id => reason_bldtyp_id, --pass reason info type id
8515: p_time_building_block_id => l_detail_id,
8516: p_attributes => p_attributes,
8517: p_tbb_id_reference_table => l_tbb_id_reference_table,

Line 8941: hxc_alias_utility.attribute_check (

8937: IF (p_tk_audit_enabled = 'Y') THEN
8938:
8939: l_attribute_found := FALSE;
8940: --l_attribute_index :=
8941: hxc_alias_utility.attribute_check (
8942: p_bld_blk_info_type_id => reason_bldtyp_id,
8943: p_time_building_block_id => l_detail_id,
8944: p_attributes => p_attributes,
8945: p_tbb_id_reference_table => l_tbb_id_reference_table,

Line 9060: hxc_alias_utility.attribute_check (

9056: IF (p_tk_audit_enabled = 'Y') THEN
9057:
9058: l_attribute_found := FALSE;
9059: --l_attribute_index :=
9060: hxc_alias_utility.attribute_check (
9061: p_bld_blk_info_type_id => reason_bldtyp_id,
9062: p_time_building_block_id => l_detail_id,
9063: p_attributes => p_attributes,
9064: p_tbb_id_reference_table => l_tbb_id_reference_table,