APPS.OTA_CLASSIC_UPGRADE dependencies on OTA_DELEGATE_BOOKINGS

Line 2842: -- This procedure will update ota_delegate_bookings table records

2838: --
2839: -- ----------------------------------------------------------------------------
2840: -- |---------------------< upg_tdb_history_att_flags >-------------------------|
2841: -- ----------------------------------------------------------------------------
2842: -- This procedure will update ota_delegate_bookings table records
2843: -- a. successful_attendance_flag to 'Y' where it is NULL and enrollment status
2844: -- is 'Attended'
2845: -- b. is_history_flag to 'Y' where enrollment status is 'Attended'
2846: -- c. enrollment status to 'Attended' for online classes, if lo has 'Completed' / 'Passed' status.

Line 2878: FROM ota_delegate_bookings

2874: sponsor_assignment_id,
2875: delegate_assignment_id ,
2876: is_history_flag,
2877: booking_status_type_id
2878: FROM ota_delegate_bookings
2879: WHERE BOOKING_STATUS_TYPE_ID in
2880: (select booking_status_type_id from ota_booking_status_types
2881: where type ='P')
2882: AND RowID Between p_start_rowid and p_end_rowid ;

Line 2914: UPDATE /*+ ROWID (TDB) */ OTA_DELEGATE_BOOKINGS TDB

2910: l_tfl_ovn number;
2911: l_fin_line number;
2912: Begin
2913:
2914: UPDATE /*+ ROWID (TDB) */ OTA_DELEGATE_BOOKINGS TDB
2915: SET IS_HISTORY_FLAG = Decode(Is_History_flag,NULL,'Y',Is_History_Flag),
2916: successful_attendance_flag = Decode(successful_attendance_flag,NULL,'Y',successful_attendance_flag)
2917: WHERE BOOKING_STATUS_TYPE_ID in
2918: (select booking_status_type_id from ota_booking_status_types

Line 2986: add_log_entry( p_table_name=>'OTA_DELEGATE_BOOKINGS'

2982: p_sponsor_person_id => l_c_booking_id.sponsor_person_id,
2983: p_sponsor_assignment_id => l_c_booking_id.sponsor_assignment_id
2984: ) ;
2985:
2986: add_log_entry( p_table_name=>'OTA_DELEGATE_BOOKINGS'
2987: ,p_source_primary_key => l_c_booking_id.booking_id
2988: ,p_object_value => l_c_booking_id.booking_status_type_id
2989: ,p_message_text => 'Enrollment status updated successfully from '|| l_c_booking_id.booking_status_type_id || ' to ' || l_booking_status_type_id
2990: ,p_upgrade_id => p_update_id

Line 3004: add_log_entry( p_table_name=>'OTA_DELEGATE_BOOKINGS'

3000: when others then
3001: l_err_code := SQLCODE;
3002: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When Updating enrollment status to Attended');
3003:
3004: add_log_entry( p_table_name=>'OTA_DELEGATE_BOOKINGS'
3005: ,p_source_primary_key => l_c_booking_id.booking_id
3006: ,p_object_value => 'Error When Updating enrollment status to Attended for ID : ' || l_c_booking_id.booking_id
3007: ,p_message_text => l_err_msg
3008: ,p_upgrade_id => p_update_id

Line 3022: add_log_entry( p_table_name=>'OTA_DELEGATE_BOOKINGS'

3018: when others then
3019: l_err_code := SQLCODE;
3020: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When Updating Successful attendance and history flag for enrollments');
3021:
3022: add_log_entry( p_table_name=>'OTA_DELEGATE_BOOKINGS'
3023: ,p_source_primary_key => 1
3024: ,p_object_value => 'Error When Updating Successful attendance and history flag for class enrollments for ID range : ' || p_start_rowid || ' - ' || p_end_rowid
3025: ,p_message_text => l_err_msg
3026: ,p_upgrade_id => p_update_id