بتاريخ: 10 يناير 201214 سنة comment_219565 salam o3alykom i am migrating the time attendace to OTL modulefirst i create Temp tablethe data loaded from excel to the temp tablethe API i am using is hxc_timestore_deposit.create_time_entryand the table i want to insert the data into is hxc_time_building_blocks and this is the API which i execute it declarel_time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;l_tbl_attributes_info hxc_self_service_time_deposit.app_attributes_info;l_tbl_timecard_info hxc_self_service_time_deposit.timecard_info;beginhxc_timestore_deposit.create_time_entry (p_start_time=> fnd_date.canonical_to_date('2012/01/07 09:00:00'),p_stop_time=> fnd_date.canonical_to_date('2012/01/07 17:00:00'),p_resource_id=> 651,p_resource_type => 'PERSON',p_app_blocks=> l_tbl_timecard_info,p_app_attributes=> l_tbl_attributes_info,p_time_building_block_id=> l_time_building_block_id);end;Procedure sucessfully completed but no new record inserted in the tablePealse any one can help me ?????? تقديم بلاغ
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.