APPS.OTA_REPROCESS_CLASSIC_UPGRADE dependencies on OTA_UPGRADE_LOG

Line 27: from ota_upgrade_log ;

23: l_upgrade_id number;
24: begin
25: select nvl(max(upgrade_id),1)
26: into l_upgrade_id
27: from ota_upgrade_log ;
28:
29: return l_upgrade_id +1 ;
30:
31: end get_next_upgrade_id;

Line 67: from ota_upgrade_log

63: -- ----------------------------------------------------------------------------
64: function get_conc_date_param(upg_id in number) return date is
65: cursor c_upg_date is
66: select process_date
67: from ota_upgrade_log
68: where upgrade_id = upg_id;
69:
70: l_ret date;
71: begin

Line 84: from ota_upgrade_log

80: -- ----------------------------------------------------------------------------
81: function check_errors(upg_id in number) return boolean is
82: cursor c_any_errors is
83: select 1
84: from ota_upgrade_log
85: where upgrade_id = upg_id
86: and log_type = 'E';
87:
88: l_ret boolean := false;

Line 397: INSERT INTO OTA_UPGRADE_LOG (

393: begin
394:
395: write_log('Starting Reprocess OTA Upgrade Concurrent Process ');
396:
397: INSERT INTO OTA_UPGRADE_LOG (
398: UPGRADE_ID,
399: TABLE_NAME,
400: SOURCE_PRIMARY_KEY,
401: OBJECT_VALUE,