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_TRAINING_PLAN_UPGRADE dependencies on OTA_CLASSIC_UPGRADE

Line 129: ota_classic_upgrade.add_log_entry( p_table_name => 'MIGRATE_'||p_source_table

125: Exception
126: when others then
127: l_err_code := SQLCODE;
128: l_err_msg := nvl(substr(SQLERRM,1,2000),'migrate_dff_contexts - segments');
129: ota_classic_upgrade.add_log_entry( p_table_name => 'MIGRATE_'||p_source_table
130: ,p_source_primary_key => substr(dff_context.application_id||'|'||
131: dff_context.descriptive_flexfield_name||'|'||
132: I.application_column_name,1,80)
133: ,p_object_value => 'migrate_dff_contexts'

Line 136: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)

132: I.application_column_name,1,80)
133: ,p_object_value => 'migrate_dff_contexts'
134: ,p_message_text => l_err_msg
135: ,p_upgrade_id => p_update_id
136: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
137: ,p_log_type => LP_LOG_TYPE_E
138: ,p_upgrade_name => LP_UPGRADE_NAME );
139: End;
140:

Line 147: ota_classic_upgrade.add_log_entry( p_table_name => 'MIGRATE_'||p_source_table

143: Exception
144: when others then
145: l_err_code := SQLCODE;
146: l_err_msg := nvl(substr(SQLERRM,1,2000),'migrate_dff_contexts');
147: ota_classic_upgrade.add_log_entry( p_table_name => 'MIGRATE_'||p_source_table
148: ,p_source_primary_key => substr( dff_context.application_id||
149: dff_context.descriptive_flexfield_name,
150: 1,80)
151: ,p_object_value => 'migrate_dff_contexts'

Line 154: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)

150: 1,80)
151: ,p_object_value => 'migrate_dff_contexts'
152: ,p_message_text => l_err_msg
153: ,p_upgrade_id => p_update_id
154: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
155: ,p_log_type => LP_LOG_TYPE_E
156: ,p_upgrade_name => LP_UPGRADE_NAME );
157: End;
158: End Loop;

Line 572: ota_classic_upgrade.add_log_entry( p_table_name=>p_table_name

568: when others then
569: l_err_code := SQLCODE;
570: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When creating Learning Path for Training Plan ');
571:
572: ota_classic_upgrade.add_log_entry( p_table_name=>p_table_name
573: ,p_source_primary_key => p_training_plan_id || p_business_group_id
574: ,p_business_group_id => p_business_group_id
575: ,p_object_value => p_name
576: ,p_message_text => l_err_msg

Line 578: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)

574: ,p_business_group_id => p_business_group_id
575: ,p_object_value => p_name
576: ,p_message_text => l_err_msg
577: ,p_upgrade_id => p_upgrade_id
578: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
579: ,p_log_type => LP_LOG_TYPE_E
580: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
581: end;
582: end if;

Line 580: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());

576: ,p_message_text => l_err_msg
577: ,p_upgrade_id => p_upgrade_id
578: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
579: ,p_log_type => LP_LOG_TYPE_E
580: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
581: end;
582: end if;
583: close csr_get_dup_lps_rec;
584: p_learning_path_id := l_learning_path_id;

Line 650: ota_classic_upgrade.add_log_entry( p_table_name=>p_table_name

646: when others then
647: l_err_code := SQLCODE;
648: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When creating Learning Path Sections ');
649:
650: ota_classic_upgrade.add_log_entry( p_table_name=>p_table_name
651: ,p_source_primary_key => p_business_group_id
652: ,p_business_group_id => p_business_group_id
653: ,p_object_value => p_section_name
654: ,p_message_text => l_err_msg

Line 656: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)

652: ,p_business_group_id => p_business_group_id
653: ,p_object_value => p_section_name
654: ,p_message_text => l_err_msg
655: ,p_upgrade_id => p_upgrade_id
656: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
657: ,p_log_type => LP_LOG_TYPE_E
658: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
659:
660: End;

Line 658: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());

654: ,p_message_text => l_err_msg
655: ,p_upgrade_id => p_upgrade_id
656: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
657: ,p_log_type => LP_LOG_TYPE_E
658: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
659:
660: End;
661: end if;
662: close csr_get_dup_lpc_rec;

Line 726: ota_classic_upgrade.add_log_entry( p_table_name=>p_table_name

722: when others then
723: l_err_code := SQLCODE;
724: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When creating Learning Path Member for Training Plan Member');
725: --p_course_sequence := p_course_sequence-1;
726: ota_classic_upgrade.add_log_entry( p_table_name=>p_table_name
727: ,p_source_primary_key => p_training_plan_member_id
728: ,p_business_group_id => p_business_group_id
729: ,p_object_value => p_activity_version_id
730: ,p_message_text => l_err_msg

Line 732: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)

728: ,p_business_group_id => p_business_group_id
729: ,p_object_value => p_activity_version_id
730: ,p_message_text => l_err_msg
731: ,p_upgrade_id => p_upgrade_id
732: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
733: ,p_log_type => LP_LOG_TYPE_E
734: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
735:
736: End;

Line 734: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());

730: ,p_message_text => l_err_msg
731: ,p_upgrade_id => p_upgrade_id
732: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
733: ,p_log_type => LP_LOG_TYPE_E
734: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
735:
736: End;
737: else
738: l_learning_path_member_id := get_lp_mem_map(p_learning_path_id

Line 880: ota_classic_upgrade.add_log_entry( p_table_name=>p_table_name

876: when others then
877: l_err_code := SQLCODE;
878: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When creating Learning Path Member Enrollment for Training Plan Member');
879:
880: ota_classic_upgrade.add_log_entry( p_table_name=>p_table_name
881: ,p_source_primary_key => p_training_plan_member_id
882: ,p_business_group_id => p_business_group_id
883: ,p_object_value => p_learning_path_member_id
884: ,p_message_text => l_err_msg

Line 886: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)

882: ,p_business_group_id => p_business_group_id
883: ,p_object_value => p_learning_path_member_id
884: ,p_message_text => l_err_msg
885: ,p_upgrade_id => p_upgrade_id
886: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
887: ,p_log_type => LP_LOG_TYPE_E
888: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
889:
890: l_lp_member_enrollment_id := -1;

Line 888: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());

884: ,p_message_text => l_err_msg
885: ,p_upgrade_id => p_upgrade_id
886: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
887: ,p_log_type => LP_LOG_TYPE_E
888: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
889:
890: l_lp_member_enrollment_id := -1;
891:
892: End;

Line 1029: ota_classic_upgrade.add_log_entry( p_table_name=>p_table_name

1025: when others then
1026: l_err_code := SQLCODE;
1027: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When creating Learning Path Enrollments for Training Plan ');
1028:
1029: ota_classic_upgrade.add_log_entry( p_table_name=>p_table_name
1030: ,p_source_primary_key => p_training_plan_id
1031: ,p_business_group_id => p_business_group_id
1032: ,p_object_value => p_name
1033: ,p_message_text => l_err_msg

Line 1035: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)

1031: ,p_business_group_id => p_business_group_id
1032: ,p_object_value => p_name
1033: ,p_message_text => l_err_msg
1034: ,p_upgrade_id => p_upgrade_id
1035: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
1036: ,p_log_type => LP_LOG_TYPE_E
1037: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
1038:
1039: End;

Line 1037: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());

1033: ,p_message_text => l_err_msg
1034: ,p_upgrade_id => p_upgrade_id
1035: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPGRADE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
1036: ,p_log_type => LP_LOG_TYPE_E
1037: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
1038:
1039: End;
1040:
1041: else

Line 1107: ota_classic_upgrade.add_log_entry( p_table_name=> 'DUMMY'

1103: from ota_upgrade_log
1104: where upgrade_name = LP_UPGRADE_NAME;
1105:
1106: if l_upgrade_id is null then
1107: ota_classic_upgrade.add_log_entry( p_table_name=> 'DUMMY'
1108: ,p_source_primary_key => 1
1109: ,p_business_group_id => null
1110: ,p_object_value => null
1111: ,p_message_text => 'Starting LP Upgrade'

Line 1113: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)

1109: ,p_business_group_id => null
1110: ,p_object_value => null
1111: ,p_message_text => 'Starting LP Upgrade'
1112: ,p_upgrade_id => 1
1113: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
1114: ,p_log_type => LP_LOG_TYPE_N
1115: ,p_upgrade_name => LP_UPGRADE_NAME );
1116:
1117: commit;

Line 1171: ota_classic_upgrade.add_log_entry( p_table_name=> 'CREATE_LPC_FOR_TPS_FOR_CAT'

1167: when others then
1168: l_err_code := SQLCODE;
1169: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When creating Learning Path Sections for Training Plan ');
1170:
1171: ota_classic_upgrade.add_log_entry( p_table_name=> 'CREATE_LPC_FOR_TPS_FOR_CAT'
1172: ,p_source_primary_key => lp_rec.business_group_id
1173: ,p_business_group_id => lp_rec.business_group_id
1174: ,p_object_value => lp_rec.name
1175: ,p_message_text => l_err_msg

Line 1177: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)

1173: ,p_business_group_id => lp_rec.business_group_id
1174: ,p_object_value => lp_rec.name
1175: ,p_message_text => l_err_msg
1176: ,p_upgrade_id => p_update_id
1177: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
1178: ,p_log_type => LP_LOG_TYPE_E
1179: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
1180:
1181: End;

Line 1179: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());

1175: ,p_message_text => l_err_msg
1176: ,p_upgrade_id => p_update_id
1177: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
1178: ,p_log_type => LP_LOG_TYPE_E
1179: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
1180:
1181: End;
1182: end if;
1183: close csr_get_dup_lpc_rec;

Line 2379: ota_classic_upgrade.add_log_entry( p_table_name=>'UPDATE_LP_ENROLLMENTS'

2375: when others then
2376: l_err_code := SQLCODE;
2377: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When updating Learning Path Enrollments ');
2378: --p_course_sequence := p_course_sequence-1;
2379: ota_classic_upgrade.add_log_entry( p_table_name=>'UPDATE_LP_ENROLLMENTS'
2380: ,p_source_primary_key => l_lp_enrollment_id
2381: ,p_business_group_id => l_lp_enrollment_id
2382: ,p_object_value => l_lp_object_version_number
2383: ,p_message_text => l_err_msg

Line 2385: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)

2381: ,p_business_group_id => l_lp_enrollment_id
2382: ,p_object_value => l_lp_object_version_number
2383: ,p_message_text => l_err_msg
2384: ,p_upgrade_id => p_update_id
2385: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
2386: ,p_log_type => LP_LOG_TYPE_E
2387: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
2388:
2389:

Line 2387: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());

2383: ,p_message_text => l_err_msg
2384: ,p_upgrade_id => p_update_id
2385: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
2386: ,p_log_type => LP_LOG_TYPE_E
2387: ,p_upgrade_name => LP_UPGRADE_NAME );--ota_classic_upgrade.get_process_date());
2388:
2389:
2390:
2391: end;

Line 2456: ota_classic_upgrade.add_log_entry( p_table_name=> 'DUMMY'

2452: WHERE lpe.lp_enrollment_id between p_start_pkid and p_end_pkid;
2453:
2454: p_rows_processed := l_rows_processed;
2455:
2456: ota_classic_upgrade.add_log_entry( p_table_name=> 'DUMMY'
2457: ,p_source_primary_key => p_update_id
2458: ,p_business_group_id => null
2459: ,p_object_value => null
2460: ,p_message_text => 'Done with LP upgrade'

Line 2462: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)

2458: ,p_business_group_id => null
2459: ,p_object_value => null
2460: ,p_message_text => 'Done with LP upgrade'
2461: ,p_upgrade_id => p_update_id
2462: ,p_process_date => ota_classic_upgrade.get_process_date(P_UPDATE_ID,LP_UPGRADE_NAME)--trunc(sysdate)
2463: ,p_log_type => LP_LOG_TYPE_N
2464: ,p_upgrade_name => LP_UPGRADE_NAME );
2465:
2466: END REMOVE_DATE_REST;