eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CLASSIC_UPGRADE dependencies on OTA_UPGRADE_LOG

Line 20: from ota_upgrade_log

16: return date is
17: l_process_date date;
18: cursor process_date is
19: select max(process_date)
20: from ota_upgrade_log
21: where upgrade_id = p_upgrade_id
22: and upgrade_name = p_upgrade_name
23: and source_primary_key = '-1';
24: begin

Line 45: from ota_upgrade_log ;

41: l_upgrade_id number;
42: begin
43: select nvl(max(upgrade_id),1)
44: into l_upgrade_id
45: from ota_upgrade_log ;
46:
47: return l_upgrade_id +1 ;
48:
49: end get_next_upgrade_id;

Line 727: l_upgrade_id ota_upgrade_log.upgrade_id%Type;

723:
724:
725: l_err_code varchar2(72);
726: l_err_msg varchar2(2000);
727: l_upgrade_id ota_upgrade_log.upgrade_id%Type;
728: l_process_date ota_upgrade_log.process_date%Type;
729:
730: begin
731:

Line 728: l_process_date ota_upgrade_log.process_date%Type;

724:
725: l_err_code varchar2(72);
726: l_err_msg varchar2(2000);
727: l_upgrade_id ota_upgrade_log.upgrade_id%Type;
728: l_process_date ota_upgrade_log.process_date%Type;
729:
730: begin
731:
732: /* In Ota_booking_deals table Category field was the equivalent lookup_code

Line 2442: Insert into ota_upgrade_log(upgrade_id,table_name,business_group_id,source_primary_key,object_value,message_text,process_date,log_type,upgrade_name)

2438: l_err_msg varchar2(2000);
2439:
2440: begin
2441:
2442: Insert into ota_upgrade_log(upgrade_id,table_name,business_group_id,source_primary_key,object_value,message_text,process_date,log_type,upgrade_name)
2443: Values(p_upgrade_id,p_table_name,p_business_group_id,p_source_primary_key,p_object_value,p_message_text,p_process_date,p_log_type,p_upgrade_name) ;
2444:
2445: Exception
2446: When Others then

Line 2448: From Ota_Upgrade_Log

2444:
2445: Exception
2446: When Others then
2447: Select Nvl(Max(source_primary_key),0)+1 into l_upgrade_id
2448: From Ota_Upgrade_Log
2449: Where Table_name = 'OTA_UPGRADE_LOG' ;
2450:
2451: l_err_code := SQLCODE;
2452: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When trapping Logging errors');

Line 2449: Where Table_name = 'OTA_UPGRADE_LOG' ;

2445: Exception
2446: When Others then
2447: Select Nvl(Max(source_primary_key),0)+1 into l_upgrade_id
2448: From Ota_Upgrade_Log
2449: Where Table_name = 'OTA_UPGRADE_LOG' ;
2450:
2451: l_err_code := SQLCODE;
2452: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When trapping Logging errors');
2453: Begin

Line 2454: Insert into ota_upgrade_log(upgrade_id,table_name,business_group_id,source_primary_key,object_value,message_text,process_date,Target_primary_key,log_type,upgrade_name)

2450:
2451: l_err_code := SQLCODE;
2452: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When trapping Logging errors');
2453: Begin
2454: Insert into ota_upgrade_log(upgrade_id,table_name,business_group_id,source_primary_key,object_value,message_text,process_date,Target_primary_key,log_type,upgrade_name)
2455: Values(p_upgrade_id,'OTA_UPGRADE_LOG',p_business_group_id,l_upgrade_id,p_table_name,p_message_text,p_process_date,p_source_primary_key,p_log_type,p_upgrade_name) ;
2456: Exception
2457: When Dup_val_on_index then
2458: Null;

Line 2455: Values(p_upgrade_id,'OTA_UPGRADE_LOG',p_business_group_id,l_upgrade_id,p_table_name,p_message_text,p_process_date,p_source_primary_key,p_log_type,p_upgrade_name) ;

2451: l_err_code := SQLCODE;
2452: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When trapping Logging errors');
2453: Begin
2454: Insert into ota_upgrade_log(upgrade_id,table_name,business_group_id,source_primary_key,object_value,message_text,process_date,Target_primary_key,log_type,upgrade_name)
2455: Values(p_upgrade_id,'OTA_UPGRADE_LOG',p_business_group_id,l_upgrade_id,p_table_name,p_message_text,p_process_date,p_source_primary_key,p_log_type,p_upgrade_name) ;
2456: Exception
2457: When Dup_val_on_index then
2458: Null;
2459: End ;

Line 2859: l_upgrade_id ota_upgrade_log.upgrade_id%Type;

2855: l_rows_processed number := 0;
2856:
2857: l_err_code varchar2(72);
2858: l_err_msg varchar2(2000);
2859: l_upgrade_id ota_upgrade_log.upgrade_id%Type;
2860: l_process_date ota_upgrade_log.process_date%Type;
2861:
2862: l_event_id number;
2863: l_business_group_id number;

Line 2860: l_process_date ota_upgrade_log.process_date%Type;

2856:
2857: l_err_code varchar2(72);
2858: l_err_msg varchar2(2000);
2859: l_upgrade_id ota_upgrade_log.upgrade_id%Type;
2860: l_process_date ota_upgrade_log.process_date%Type;
2861:
2862: l_event_id number;
2863: l_business_group_id number;
2864: l_learning_object_id ota_learning_objects.learning_object_id%Type ;

Line 3051: l_upgrade_id ota_upgrade_log.upgrade_id%Type;

3047: l_rows_processed number := 0;
3048:
3049: l_err_code varchar2(72);
3050: l_err_msg varchar2(2000);
3051: l_upgrade_id ota_upgrade_log.upgrade_id%Type;
3052: l_process_date ota_upgrade_log.process_date%Type;
3053:
3054: begin
3055:

Line 3052: l_process_date ota_upgrade_log.process_date%Type;

3048:
3049: l_err_code varchar2(72);
3050: l_err_msg varchar2(2000);
3051: l_upgrade_id ota_upgrade_log.upgrade_id%Type;
3052: l_process_date ota_upgrade_log.process_date%Type;
3053:
3054: begin
3055:
3056: UPDATE /*+ ROWID (LPE) */ OTA_LP_ENROLLMENTS LPE