DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIME_DEPOSIT dependencies on HXC_MAPPING_COMPONENTS

Line 7: (segment hxc_mapping_components.segment%TYPE,

3:
4: g_debug boolean := hr_utility.debug_enabled;
5: --AI7
6: TYPE t_mapping_comp IS RECORD
7: (segment hxc_mapping_components.segment%TYPE,
8: field_name hxc_mapping_components.field_name%TYPE,
9: bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE,
10: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
11: building_block_category hxc_bld_blk_info_type_usages.building_block_category%TYPE);

Line 8: field_name hxc_mapping_components.field_name%TYPE,

4: g_debug boolean := hr_utility.debug_enabled;
5: --AI7
6: TYPE t_mapping_comp IS RECORD
7: (segment hxc_mapping_components.segment%TYPE,
8: field_name hxc_mapping_components.field_name%TYPE,
9: bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE,
10: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
11: building_block_category hxc_bld_blk_info_type_usages.building_block_category%TYPE);
12:

Line 9: bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE,

5: --AI7
6: TYPE t_mapping_comp IS RECORD
7: (segment hxc_mapping_components.segment%TYPE,
8: field_name hxc_mapping_components.field_name%TYPE,
9: bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE,
10: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
11: building_block_category hxc_bld_blk_info_type_usages.building_block_category%TYPE);
12:
13: TYPE t_mapping IS TABLE OF

Line 177: from hxc_mapping_components mc

173: mc.field_name,
174: bbui.building_block_category,
175: bbit.bld_blk_info_type_id,
176: bbit.bld_blk_info_type
177: from hxc_mapping_components mc
178: ,hxc_mapping_comp_usages mcu
179: ,hxc_mappings m
180: ,hxc_retrieval_processes rp
181: ,hxc_bld_blk_info_types bbit

Line 197: from hxc_mapping_components mc

193: mc.field_name,
194: bbui.building_block_category,
195: bbit.bld_blk_info_type_id,
196: bbit.bld_blk_info_type
197: from hxc_mapping_components mc
198: ,hxc_mapping_comp_usages mcu
199: ,hxc_mappings m
200: ,hxc_deposit_processes dp
201: ,hxc_bld_blk_info_types bbit

Line 1652: hxc_mapping_components mc,

1648: mc.segment,
1649: mc.field_name,
1650: bbui.building_block_category
1651: FROM
1652: hxc_mapping_components mc,
1653: hxc_bld_blk_info_type_usages bbui,
1654: hxc_bld_blk_info_types bbit
1655: WHERE
1656: mc.mapping_component_id in (Select mcu.mapping_component_id from

Line 1673: from hxc_mapping_components mc

1669:
1670: CURSOR csr_wtd_components(p_attribute_category VARCHAR2)
1671: IS
1672: select mc.segment, mc.field_name, bbui.building_block_category
1673: from hxc_mapping_components mc
1674: ,hxc_mapping_comp_usages mcu
1675: ,hxc_mappings m
1676: ,hxc_deposit_processes dp
1677: ,hxc_bld_blk_info_types bbit

Line 2325: from hxc_mapping_components mc

2321: CURSOR csr_mapping_components(p_deposit_process_id NUMBER
2322: ,p_bbit_id NUMBER)
2323: IS
2324: select mc.segment, mc.field_name,bbit.bld_blk_info_type
2325: from hxc_mapping_components mc
2326: ,hxc_mapping_comp_usages mcu
2327: ,hxc_mappings m
2328: ,hxc_deposit_processes dp
2329: ,hxc_bld_blk_info_types bbit

Line 2685: from hxc_mapping_components mc

2681: ,p_attribute_category VARCHAR2
2682: ,p_field_name VARCHAR2)
2683: IS
2684: select mc.segment
2685: from hxc_mapping_components mc
2686: ,hxc_mapping_comp_usages mcu
2687: ,hxc_mappings m
2688: ,hxc_retrieval_processes rp
2689: ,hxc_bld_blk_info_types bbit

Line 2701: l_segment hxc_mapping_components.segment%TYPE;

2697: AND bbit.bld_blk_info_type_id = bbui.bld_blk_info_type_id
2698: AND bbit.bld_blk_info_type = p_attribute_category;
2699:
2700: l_time_attribute_id hxc_time_attributes.time_attribute_id%TYPE;
2701: l_segment hxc_mapping_components.segment%TYPE;
2702: l_att_count NUMBER;
2703: l_mapping_component t_mapping_comp; --AI7
2704:
2705: l_proc varchar2(32);

Line 3897: l_component_row hxc_mapping_components%ROWTYPE;

3893: l_timecard hxc_time_attributes_api.timecard;
3894: l_attribute_index NUMBER;
3895: l_bld_blk_info_type_id NUMBER;
3896: l_mapping_comp_usage_id NUMBER;
3897: l_component_row hxc_mapping_components%ROWTYPE;
3898: l_exception EXCEPTION;
3899: l_update_required BOOLEAN := FALSE;
3900: l_attribute_update_req BOOLEAN := FALSE;
3901: l_date DATE := SYSDATE;