APPS.OTA_CLASSIC_UPGRADE dependencies on OTA_LP_ENROLLMENTS

Line 3037: -- This procedure will update ota_lp_enrollments table record is_history_flag to 'Y'

3033: --
3034: -- ----------------------------------------------------------------------------
3035: -- |---------------------< upgrade_lp_history_flag >--------------------------|
3036: -- ----------------------------------------------------------------------------
3037: -- This procedure will update ota_lp_enrollments table record is_history_flag to 'Y'
3038: -- where learning path enrollment status is 'Completed'
3039:
3040: PROCEDURE upgrade_lp_history_flag(
3041: p_process_control IN varchar2,

Line 3056: UPDATE /*+ ROWID (LPE) */ OTA_LP_ENROLLMENTS LPE

3052: l_process_date ota_upgrade_log.process_date%Type;
3053:
3054: begin
3055:
3056: UPDATE /*+ ROWID (LPE) */ OTA_LP_ENROLLMENTS LPE
3057: SET IS_HISTORY_FLAG = 'Y'
3058: WHERE ROWID between p_start_rowid and p_end_rowid
3059: AND PATH_STATUS_CODE = 'COMPLETED'
3060: AND COMPLETION_DATE IS NOT NULL

Line 3070: add_log_entry( p_table_name=>'OTA_LP_ENROLLMENTS'

3066: when others then
3067: l_err_code := SQLCODE;
3068: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When Updating history flag for LP enrollments');
3069:
3070: add_log_entry( p_table_name=>'OTA_LP_ENROLLMENTS'
3071: ,p_source_primary_key => 1
3072: ,p_object_value => 'Error When Updating history flag for LP enrollments for ID range : ' || p_start_rowid || ' - ' || p_end_rowid
3073: ,p_message_text => l_err_msg
3074: ,p_upgrade_id => p_update_id