apps.ota_delegate_booking_api.update_delegate_booking

Oracle Apps Interview QuestionsCategory: Othersapps.ota_delegate_booking_api.update_delegate_booking
Anonymous asked 8 years ago

Hi ,I have manually changed the Enrollement status of training from Enrolled to Completed using  apps.ota_delegate_booking_api.update_delegate_booking api..when I check from the application the status of training is changed but the completion date is not reflecting.Can u pls help if I am missing something.
apps.ota_delegate_booking_api.update_delegate_booking (
      P_EFFECTIVE_DATE => TRUNC (SYSDATE),
      P_BOOKING_ID => rec_emp.BOOKING_ID,
      p_administrator => L_USER_ID,
      p_object_version_number => rec_emp.object_version_number,
      p_booking_status_type_id => x_booking_status_type_id,
      P_BUSINESS_GROUP_ID => L_BUS_GRP_ID,
      P_EVENT_ID => rec_emp.EVENT_ID,
      P_INTERNAL_BOOKING_FLAG => rec_emp.INTERNAL_BOOKING_FLAG,
      p_number_of_places => rec_emp.number_of_places,
      p_date_status_changed => TRUNC (SYSDATE),
      p_status_change_comments => x_status_change_comments,
      p_successful_attendance_flag => ‘Y’,
      p_tfl_object_version_number => x_tfl_object_version_number,
      p_finance_line_id => x_finance_line_id );

      —
      COMMIT;
 
thanks