DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_PROCESS dependencies on HXC_ALIAS_UTILITY

Line 1046: p_processing_mode => hxc_alias_utility.c_tk_processing,

1042: p_blocks => l_timecard,
1043: p_start_time => tc_start,
1044: p_stop_time => tc_end,
1045: p_resource_id => p_timekeeper_id,
1046: p_processing_mode => hxc_alias_utility.c_tk_processing,
1047: p_messages => l_messages
1048: );
1049: --t_base_table--used to take the output of translator and convert into matrix
1050:

Line 4230: att_seg_tab hxc_alias_utility.t_alias_att_info;

4226: ;
4227: l_tc_status VARCHAR2 (15) := NULL;
4228: /*ADVICE(3652): Initialization to NULL is superfluous [417] */
4229:
4230: att_seg_tab hxc_alias_utility.t_alias_att_info;
4231: spemp_tc_list hxc_timecard_utilities.periods;
4232: spemp_tc_info hxc_timekeeper_utilities.emptctab;
4233: sp_index NUMBER
4234: /*ADVICE(3658): NUMBER has no precision [315] */

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

4298:
4299: --get the attributes information associated with timekeeper into att_seg_tab table.
4300:
4301: att_seg_tab.DELETE;
4302: hxc_alias_utility.get_alias_att_info (p_timekeeper_id, att_seg_tab);
4303: -- Now we have a table that contains all the indexes of the insert_table
4304: -- by resource_id
4305: -- Let start to build the time_building_block and attributes table by
4306: -- resource_id and deposit it.

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

5558: p_attribute_id => g_negative_index,
5559: p_tbb_id => l_timecard_id,
5560: p_tbb_ovn => l_timecard_ovn,
5561: p_blk_type => 'LAYOUT',
5562: p_blk_id => hxc_alias_utility.get_bld_blk_type_id ('LAYOUT'),
5563: p_att_category => 'LAYOUT',
5564: p_att_1 => l_emp_layout1,
5565: p_att_2 => l_emp_layout2,
5566: p_att_3 => l_emp_layout3,

Line 5735: p_att_tab IN hxc_alias_utility.t_alias_att_info,

5731: -------------------------------------------------------------------------------
5732:
5733: PROCEDURE create_detail_structure (
5734: p_timekeeper_id IN NUMBER,
5735: p_att_tab IN hxc_alias_utility.t_alias_att_info,
5736: p_resource_id IN NUMBER,
5737: p_start_period IN DATE,
5738: p_end_period IN DATE,
5739: p_tc_frdt IN DATE,

Line 5796: l_tbb_id_reference_table hxc_alias_utility.t_tbb_id_reference;

5792: ;
5793: l_result
5794: /*ADVICE(5073): Unreferenced variable [553] */
5795: VARCHAR2 (10);
5796: l_tbb_id_reference_table hxc_alias_utility.t_tbb_id_reference;
5797: n
5798: /*ADVICE(5077): Unreferenced variable [553] */
5799: NUMBER
5800: /*ADVICE(5079): NUMBER has no precision [315] */

Line 6040: hxc_alias_utility.get_tbb_id_reference_table (

6036: --
6037:
6038: IF l_action = 'UPDATE' THEN -- create the tbb_id table reference
6039: -- for each time_building_block_id let create a reference attribute_id table
6040: hxc_alias_utility.get_tbb_id_reference_table (
6041: p_attributes => p_attributes,
6042: p_tbb_id_reference_table => l_tbb_id_reference_table
6043: );
6044: END IF;

Line 6823: hxc_alias_utility.attribute_check (

6819: AND NVL (bldtyp_id, -999) <> -999 THEN -- and l_detail_dff_found THEN
6820:
6821: l_attribute_found := FALSE;
6822: --l_attribute_index :=
6823: hxc_alias_utility.attribute_check (
6824: p_bld_blk_info_type_id => bldtyp_id,
6825: p_time_building_block_id => l_detail_id,
6826: p_attributes => p_attributes,
6827: p_tbb_id_reference_table => l_tbb_id_reference_table,

Line 6901: hxc_alias_utility.attribute_check (

6897: AND NVL (reason_bldtyp_id, -999) <> -999 THEN
6898:
6899: l_attribute_found := FALSE;
6900: --l_attribute_index :=
6901: hxc_alias_utility.attribute_check (
6902: p_bld_blk_info_type_id => reason_bldtyp_id, --pass reason info type id
6903: p_time_building_block_id => l_detail_id,
6904: p_attributes => p_attributes,
6905: p_tbb_id_reference_table => l_tbb_id_reference_table,

Line 7167: hxc_alias_utility.attribute_check (

7163: IF (p_tk_audit_enabled = 'Y') THEN
7164:
7165: l_attribute_found := FALSE;
7166: --l_attribute_index :=
7167: hxc_alias_utility.attribute_check (
7168: p_bld_blk_info_type_id => reason_bldtyp_id,
7169: p_time_building_block_id => l_detail_id,
7170: p_attributes => p_attributes,
7171: p_tbb_id_reference_table => l_tbb_id_reference_table,

Line 7259: hxc_alias_utility.attribute_check (

7255: IF (p_tk_audit_enabled = 'Y') THEN
7256:
7257: l_attribute_found := FALSE;
7258: --l_attribute_index :=
7259: hxc_alias_utility.attribute_check (
7260: p_bld_blk_info_type_id => reason_bldtyp_id,
7261: p_time_building_block_id => l_detail_id,
7262: p_attributes => p_attributes,
7263: p_tbb_id_reference_table => l_tbb_id_reference_table,