APPS.HXC_MAPPING_UTILITIES dependencies on HXC_GENERIC_RETRIEVAL_PKG

Line 67: RETURN hxc_generic_retrieval_pkg.t_field_mappings

63: -- ****************************************
64:
65: FUNCTION get_field_mappings (
66: p_mapping_id hxc_mappings.mapping_id%TYPE )
67: RETURN hxc_generic_retrieval_pkg.t_field_mappings
68: IS
69: --
70: l_mapping_record hxc_generic_retrieval_pkg.r_field_mappings;
71: l_mappings_table hxc_generic_retrieval_pkg.t_field_mappings;

Line 70: l_mapping_record hxc_generic_retrieval_pkg.r_field_mappings;

66: p_mapping_id hxc_mappings.mapping_id%TYPE )
67: RETURN hxc_generic_retrieval_pkg.t_field_mappings
68: IS
69: --
70: l_mapping_record hxc_generic_retrieval_pkg.r_field_mappings;
71: l_mappings_table hxc_generic_retrieval_pkg.t_field_mappings;
72: --
73: CURSOR csr_get_mappings IS
74: SELECT

Line 71: l_mappings_table hxc_generic_retrieval_pkg.t_field_mappings;

67: RETURN hxc_generic_retrieval_pkg.t_field_mappings
68: IS
69: --
70: l_mapping_record hxc_generic_retrieval_pkg.r_field_mappings;
71: l_mappings_table hxc_generic_retrieval_pkg.t_field_mappings;
72: --
73: CURSOR csr_get_mappings IS
74: SELECT
75: mpc.bld_blk_info_type_id

Line 192: , p_mappings_tab hxc_generic_retrieval_pkg.t_field_mappings )

188:
189:
190: FUNCTION compare_attributes ( p_new_attributes_table hxc_self_service_time_deposit.building_block_attribute_info
191: , p_old_attributes_table hxc_self_service_time_deposit.building_block_attribute_info
192: , p_mappings_tab hxc_generic_retrieval_pkg.t_field_mappings )
193: RETURN BOOLEAN IS
194:
195: l_changed BOOLEAN := FALSE;
196: l_attribute_row_found BOOLEAN := FALSE;

Line 209: , p_mappings_tab hxc_generic_retrieval_pkg.t_field_mappings

205: -- description
206: -- retruns true if the attribute is in the mapping
207:
208: FUNCTION in_mapping ( p_bld_blk_info_type_id NUMBER
209: , p_mappings_tab hxc_generic_retrieval_pkg.t_field_mappings
210: , p_attribute VARCHAR2 )
211: RETURN BOOLEAN IS
212:
213: l_return BOOLEAN := FALSE;

Line 660: t_mapping hxc_generic_retrieval_pkg.t_field_mappings;

656: -- ***************************************
657:
658: l_proc VARCHAR2(72);
659:
660: t_mapping hxc_generic_retrieval_pkg.t_field_mappings;
661:
662: r_new_atts hxc_self_service_time_deposit.attribute_info;
663: r_old_atts hxc_self_service_time_deposit.attribute_info;
664:

Line 965: , p_mappings_tab hxc_generic_retrieval_pkg.t_field_mappings

961: -- IF NEW flags are all N and changed flags N for bld blks
962: -- info types in mapping RETURN NOTCHANGED
963:
964: PROCEDURE chk_att_tco_not_changed ( p_time_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
965: , p_mappings_tab hxc_generic_retrieval_pkg.t_field_mappings
966: , p_decision IN OUT NOCOPY VARCHAR2
967: , p_bld_blk_info_tab IN OUT NOCOPY t_bld_blk_info ) IS
968:
969: l_changed VARCHAR2(10) := 'NOTCHANGED';