APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_MAPPING_COMPONENTS

Line 1371: p_field_name IN hxc_mapping_components.field_name%TYPE

1367: -- ========================================================================
1368: -- This function gets building block information type id from a field name
1369: -- ========================================================================
1370: FUNCTION get_info_type_id(
1371: p_field_name IN hxc_mapping_components.field_name%TYPE
1372: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1373: )
1374: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1375: IS

Line 1379: p_field_name IN hxc_mapping_components.field_name%TYPE

1375: IS
1376: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1377:
1378: CURSOR c_info_type_id(
1379: p_field_name IN hxc_mapping_components.field_name%TYPE
1380: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1381: )
1382: IS
1383: SELECT mc.bld_blk_info_type_id

Line 1384: FROM hxc_mapping_components mc

1380: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1381: )
1382: IS
1383: SELECT mc.bld_blk_info_type_id
1384: FROM hxc_mapping_components mc
1385: ,hxc_mapping_comp_usages mcu
1386: ,hxc_mappings m
1387: ,hxc_retrieval_processes rp
1388: WHERE upper(mc.field_name) = upper(p_field_name)

Line 1518: l_segment hxc_mapping_components.segment%TYPE;

1514: IS
1515: l_att_count NUMBER;
1516: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1517: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1518: l_segment hxc_mapping_components.segment%TYPE;
1519:
1520: CURSOR csr_segment(
1521: p_retrieval_process_id NUMBER
1522: ,p_attribute_category VARCHAR2

Line 1527: from hxc_mapping_components mc

1523: ,p_field_name VARCHAR2
1524: )
1525: IS
1526: select mc.segment
1527: from hxc_mapping_components mc
1528: ,hxc_mapping_comp_usages mcu
1529: ,hxc_mappings m
1530: ,hxc_retrieval_processes rp
1531: ,hxc_bld_blk_info_types bbit