[Home] [Help]
448:
449: FUNCTION changed(
450: p_detail_blocks IN OUT NOCOPY block_table
451: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
452: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
453: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
454: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
455: )
456: RETURN BOOLEAN
619:
620: FUNCTION is_empty(
621: p_detail_blocks IN OUT NOCOPY block_table
622: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
623: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
624: )
625: RETURN BOOLEAN
626: IS
627: l_block_index NUMBER;
662:
663: PROCEDURE link_ap_details(
664: p_detail_blocks IN OUT NOCOPY block_table
665: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
666: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
667: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
668: )
669: IS
670: l_block_index NUMBER;
713:
714: PROCEDURE link_ap_details_all(
715: p_detail_blocks IN OUT NOCOPY block_table
716: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
717: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
718: )
719: IS
720: l_block_index NUMBER;
721:
1875: ,p_start_time hxc_time_building_blocks.start_time%TYPE
1876: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
1877: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
1878: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
1879: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
1880: ,p_category_sequence hxc_approval_comps.approval_order%TYPE
1881: )
1882: IS
1883: SELECT application_period_id
1942: l_app_status_temp hxc_time_building_blocks.approval_status%TYPE := NULL;
1943: l_notif_status_temp VARCHAR2(150) := NULL;
1944: l_app_comp_id_temp hxc_app_period_summary.approval_comp_id%type;
1945: l_first_app_period BOOLEAN;
1946: l_time_category_id hxc_time_categories.time_category_id%TYPE := NULL;
1947: l_category_sequence hxc_app_period_summary.category_sequence%TYPE := NULL;
1948: l_creation_date DATE;
1949: t_attributes hxc_time_attributes_api.timecard;
1950: l_tc_ap_link_exists VARCHAR2(50) := NULL;
3178: ,p_period_start_date IN hxc_time_building_blocks.start_time%TYPE
3179: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE
3180: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
3181: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE
3182: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
3183: ,p_category_sequence IN hxc_app_period_summary.category_sequence%TYPE
3184: )
3185: RETURN VARCHAR2
3186: IS
3191: ,p_period_start_date hxc_time_building_blocks.start_time%TYPE
3192: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE
3193: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
3194: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE
3195: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
3196: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE
3197: )
3198: IS
3199: SELECT aps.approval_status
3463: l_last_updated_by number;
3464: l_process varchar2(1) := 'Y';
3465:
3466: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;
3467: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3468: l_category_sequence hxc_approval_comps.approval_order%TYPE;
3469: l_approval_item_key wf_items.item_key%type;
3470: l_is_blank varchar2(1) := NULL;
3471: