[Home] [Help]
182:
183:
184: hxc_self_service_time_deposit.set_app_hook_params
185: (p_building_blocks
186: => hxc_timecard_block_utils.convert_to_dpwr_blocks(p_blocks),
187: p_app_attributes => l_app_attributes,
188: p_messages => l_messages
189: );
190:
564: fetch c_pa_tr_id into l_projects_tr_id;
565: close c_pa_tr_id;
566:
567: l_timecard_start_time :=
568: hxc_timecard_block_utils.date_value
569: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
570: l_timecard_stop_time:=
571: hxc_timecard_block_utils.date_value
572: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time);
565: close c_pa_tr_id;
566:
567: l_timecard_start_time :=
568: hxc_timecard_block_utils.date_value
569: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
570: l_timecard_stop_time:=
571: hxc_timecard_block_utils.date_value
572: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time);
573:
567: l_timecard_start_time :=
568: hxc_timecard_block_utils.date_value
569: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
570: l_timecard_stop_time:=
571: hxc_timecard_block_utils.date_value
572: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time);
573:
574:
575: l_application_set_id := to_number
568: hxc_timecard_block_utils.date_value
569: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
570: l_timecard_stop_time:=
571: hxc_timecard_block_utils.date_value
572: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time);
573:
574:
575: l_application_set_id := to_number
576: (hxc_timecard_properties.find_property_value
737: null,
738: p_eval_date
739: ),
740: p_app_set_id => l_application_set_id,
741: p_timecard_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id,
742: p_timecard_ovn => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number,
743: p_time_building_blocks => p_old_style_blks,
744: p_time_att_info => l_app_attributes,
745: p_messages => l_old_messages
738: p_eval_date
739: ),
740: p_app_set_id => l_application_set_id,
741: p_timecard_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id,
742: p_timecard_ovn => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number,
743: p_time_building_blocks => p_old_style_blks,
744: p_time_att_info => l_app_attributes,
745: p_messages => l_old_messages
746: );
766: l_old_style_blks HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
767: l_old_style_attrs hxc_self_service_time_deposit.building_block_attribute_info;
768:
769: Begin
770: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks(p_blocks);
771: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes(p_attributes);
772: l_eval_date := fnd_date.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
773:
774: recipients_update_validation
768:
769: Begin
770: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks(p_blocks);
771: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes(p_attributes);
772: l_eval_date := fnd_date.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
773:
774: recipients_update_validation
775: (p_blocks => p_blocks,
776: p_attributes => p_attributes,
801: l_dummy number;
802:
803: Begin
804:
805: l_timecard_start_time := hxc_timecard_block_utils.date_value
806: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
807:
808: l_timecard_stop_time := hxc_timecard_block_utils.date_value
809: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time);
802:
803: Begin
804:
805: l_timecard_start_time := hxc_timecard_block_utils.date_value
806: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
807:
808: l_timecard_stop_time := hxc_timecard_block_utils.date_value
809: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time);
810:
804:
805: l_timecard_start_time := hxc_timecard_block_utils.date_value
806: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
807:
808: l_timecard_stop_time := hxc_timecard_block_utils.date_value
809: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time);
810:
811: open c_data_set(l_timecard_stop_time);
812: fetch c_data_set into l_dummy;
805: l_timecard_start_time := hxc_timecard_block_utils.date_value
806: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
807:
808: l_timecard_stop_time := hxc_timecard_block_utils.date_value
809: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time);
810:
811: open c_data_set(l_timecard_stop_time);
812: fetch c_data_set into l_dummy;
813: if c_data_set%found then
818: hxc_timecard.c_error,
819: null,
820: null,
821: hxc_timecard.c_hxc,
822: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id,
823: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number,
824: null,
825: null
826: );
819: null,
820: null,
821: hxc_timecard.c_hxc,
822: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id,
823: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number,
824: null,
825: null
826: );
827: else
843: l_old_style_blks HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
844: l_old_style_attrs hxc_self_service_time_deposit.building_block_attribute_info;
845:
846: Begin
847: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks
848: (p_blocks);
849:
850: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes
851: (p_attributes);
850: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes
851: (p_attributes);
852:
853: l_tc_start_date:= fnd_date.canonical_to_date
854: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
855: l_tc_end_date := fnd_date.canonical_to_date
856: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time);
857:
858: recipients_update_validation
852:
853: l_tc_start_date:= fnd_date.canonical_to_date
854: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
855: l_tc_end_date := fnd_date.canonical_to_date
856: (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time);
857:
858: recipients_update_validation
859: (p_blocks => p_blocks,
860: p_attributes => p_attributes,