DBA Data[Home] [Help]

APPS.HXC_MAPPING_UTILITIES dependencies on HXC_SELF_SERVICE_TIME_DEPOSIT

Line 190: FUNCTION compare_attributes ( p_new_attributes_table hxc_self_service_time_deposit.building_block_attribute_info

186: -- function which returns TRUE if any attribute has changed between
187: -- the old and new tables of attributes
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:

Line 191: , p_old_attributes_table hxc_self_service_time_deposit.building_block_attribute_info

187: -- the old and new tables of attributes
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;

Line 649: , p_time_building_blocks hxc_self_service_time_deposit.timecard_info

645: , p_timecard_ovn NUMBER
646: , p_start_date DATE
647: , p_end_date DATE
648: , p_last_status VARCHAR2
649: , p_time_building_blocks hxc_self_service_time_deposit.timecard_info
650: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
651: , p_called_from VARCHAR2 default 'APPROVALS' )
652: RETURN BOOLEAN IS
653:

Line 650: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info

646: , p_start_date DATE
647: , p_end_date DATE
648: , p_last_status VARCHAR2
649: , p_time_building_blocks hxc_self_service_time_deposit.timecard_info
650: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
651: , p_called_from VARCHAR2 default 'APPROVALS' )
652: RETURN BOOLEAN IS
653:
654: -- ***************************************

Line 662: r_new_atts hxc_self_service_time_deposit.attribute_info;

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:
665: t_old_attributes hxc_self_service_time_deposit.building_block_attribute_info;
666: t_new_attributes hxc_self_service_time_deposit.building_block_attribute_info;

Line 663: r_old_atts hxc_self_service_time_deposit.attribute_info;

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:
665: t_old_attributes hxc_self_service_time_deposit.building_block_attribute_info;
666: t_new_attributes hxc_self_service_time_deposit.building_block_attribute_info;
667:

Line 665: t_old_attributes hxc_self_service_time_deposit.building_block_attribute_info;

661:
662: r_new_atts hxc_self_service_time_deposit.attribute_info;
663: r_old_atts hxc_self_service_time_deposit.attribute_info;
664:
665: t_old_attributes hxc_self_service_time_deposit.building_block_attribute_info;
666: t_new_attributes hxc_self_service_time_deposit.building_block_attribute_info;
667:
668: l_parsed_attributes hxc_self_service_time_deposit.building_block_attribute_info;
669:

Line 666: t_new_attributes hxc_self_service_time_deposit.building_block_attribute_info;

662: r_new_atts hxc_self_service_time_deposit.attribute_info;
663: r_old_atts hxc_self_service_time_deposit.attribute_info;
664:
665: t_old_attributes hxc_self_service_time_deposit.building_block_attribute_info;
666: t_new_attributes hxc_self_service_time_deposit.building_block_attribute_info;
667:
668: l_parsed_attributes hxc_self_service_time_deposit.building_block_attribute_info;
669:
670: l_mapping_changed BOOLEAN := FALSE;

Line 668: l_parsed_attributes hxc_self_service_time_deposit.building_block_attribute_info;

664:
665: t_old_attributes hxc_self_service_time_deposit.building_block_attribute_info;
666: t_new_attributes hxc_self_service_time_deposit.building_block_attribute_info;
667:
668: l_parsed_attributes hxc_self_service_time_deposit.building_block_attribute_info;
669:
670: l_mapping_changed BOOLEAN := FALSE;
671: l_no_such_bb_id BOOLEAN := TRUE;
672: l_all_first_ovn BOOLEAN := TRUE;

Line 761: RETURN hxc_self_service_time_deposit.building_block_attribute_info IS

757: FUNCTION get_old_atts ( p_bb_id NUMBER
758: , p_bb_ovn NUMBER
759: , p_status VARCHAR2
760: , p_bld_blk_info_tab t_bld_blk_info )
761: RETURN hxc_self_service_time_deposit.building_block_attribute_info IS
762:
763: l_proc VARCHAR2(72);
764:
765: l_decr_ovn hxc_time_building_blocks.object_version_number%TYPE := 0;

Line 768: r_old_atts hxc_self_service_time_deposit.attribute_info;

764:
765: l_decr_ovn hxc_time_building_blocks.object_version_number%TYPE := 0;
766: l_attributes_exist BOOLEAN := TRUE;
767: l_old BINARY_INTEGER := 1;
768: r_old_atts hxc_self_service_time_deposit.attribute_info;
769: t_old_atts hxc_self_service_time_deposit.building_block_attribute_info;
770:
771:
772: CURSOR csr_get_old_atts ( p_decr_ovn NUMBER ) IS

Line 769: t_old_atts hxc_self_service_time_deposit.building_block_attribute_info;

765: l_decr_ovn hxc_time_building_blocks.object_version_number%TYPE := 0;
766: l_attributes_exist BOOLEAN := TRUE;
767: l_old BINARY_INTEGER := 1;
768: r_old_atts hxc_self_service_time_deposit.attribute_info;
769: t_old_atts hxc_self_service_time_deposit.building_block_attribute_info;
770:
771:
772: CURSOR csr_get_old_atts ( p_decr_ovn NUMBER ) IS
773: SELECT

Line 964: PROCEDURE chk_att_tco_not_changed ( p_time_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info

960: --
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:

Line 974: l_time_attributes hxc_self_service_time_deposit.building_block_attribute_info;

970: l_att_index BINARY_INTEGER;
971: l_map_index BINARY_INTEGER;
972: l_del_index BINARY_INTEGER;
973:
974: l_time_attributes hxc_self_service_time_deposit.building_block_attribute_info;
975:
976: l_proc VARCHAR2(72);
977:
978: BEGIN

Line 1469: , p_time_bld_blks hxc_self_service_time_deposit.timecard_info ) RETURN BOOLEAN IS

1465: , p_timecard_ovn NUMBER
1466: , p_start_date DATE
1467: , p_end_date DATE
1468: , p_last_status VARCHAR2
1469: , p_time_bld_blks hxc_self_service_time_deposit.timecard_info ) RETURN BOOLEAN IS
1470:
1471: l_proc VARCHAR2(72);
1472:
1473: r_bld_blks csr_get_timecard%rowtype;