[Home] [Help]
600:
601: FUNCTION changed(
602: p_detail_blocks IN OUT NOCOPY block_table
603: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
604: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
605: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
606: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
607: )
608: RETURN BOOLEAN
771:
772: FUNCTION is_empty(
773: p_detail_blocks IN OUT NOCOPY block_table
774: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
775: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
776: )
777: RETURN BOOLEAN
778: IS
779: l_block_index NUMBER;
814:
815: PROCEDURE link_ap_details(
816: p_detail_blocks IN OUT NOCOPY block_table
817: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
818: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
819: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
820: )
821: IS
822: l_block_index NUMBER;
865:
866: PROCEDURE link_ap_details_all(
867: p_detail_blocks IN OUT NOCOPY block_table
868: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
869: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
870: )
871: IS
872: l_block_index NUMBER;
873:
2054: ,p_start_time hxc_time_building_blocks.start_time%TYPE
2055: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
2056: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
2057: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
2058: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
2059: ,p_category_sequence hxc_approval_comps.approval_order%TYPE
2060: )
2061: IS
2062: SELECT application_period_id
2121: l_app_status_temp hxc_time_building_blocks.approval_status%TYPE := NULL;
2122: l_notif_status_temp VARCHAR2(150) := NULL;
2123: l_app_comp_id_temp hxc_app_period_summary.approval_comp_id%type;
2124: l_first_app_period BOOLEAN;
2125: l_time_category_id hxc_time_categories.time_category_id%TYPE := NULL;
2126: l_category_sequence hxc_app_period_summary.category_sequence%TYPE := NULL;
2127: l_creation_date DATE;
2128: t_attributes hxc_time_attributes_api.timecard;
2129: l_tc_ap_link_exists VARCHAR2(50) := NULL;
3809: ,p_period_start_date IN hxc_time_building_blocks.start_time%TYPE
3810: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE
3811: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
3812: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE
3813: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
3814: ,p_category_sequence IN hxc_app_period_summary.category_sequence%TYPE
3815: )
3816: RETURN VARCHAR2
3817: IS
3822: ,p_period_start_date hxc_time_building_blocks.start_time%TYPE
3823: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE
3824: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
3825: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE
3826: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
3827: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE
3828: )
3829: IS
3830: SELECT aps.approval_status
4094: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.process_appl_periods';
4095: l_last_updated_by number;
4096:
4097: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;
4098: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4099: l_category_sequence hxc_approval_comps.approval_order%TYPE;
4100: l_approval_item_key wf_items.item_key%type;
4101: l_is_blank varchar2(1) := NULL;
4102: l_process varchar2(1) := 'Y';