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_LP_SECTIONS_TL

Line 615: from ota_lp_sections_tl lpct,ota_lp_sections lpc

611: l_number number;
612:
613: cursor csr_get_dup_lpc_rec(p_learning_path_id in number,p_section_name in varchar) is
614: select lpc.learning_path_section_id
615: from ota_lp_sections_tl lpct,ota_lp_sections lpc
616: where lpc.learning_path_section_id = lpct.learning_path_section_id
617: and lpct.language=userenv('LANG')
618: and lpc.learning_path_id = p_learning_path_id
619: and lpct.name = p_section_name ;

Line 638: ,p_section_name => p_section_name --ota_lp_sections_tl

634: ota_lp_section_api.create_lp_section(
635: p_effective_date => trunc(sysdate)
636: ,p_learning_path_section_id => l_learning_path_section_id
637: ,p_learning_path_id => p_learning_path_id
638: ,p_section_name => p_section_name --ota_lp_sections_tl
639: ,p_description => p_description -- ota_lp_sections_tl
640: ,p_section_sequence => p_section_sequence
641: ,p_completion_type_code => p_completion_type_code
642: ,p_business_group_id => p_business_group_id

Line 639: ,p_description => p_description -- ota_lp_sections_tl

635: p_effective_date => trunc(sysdate)
636: ,p_learning_path_section_id => l_learning_path_section_id
637: ,p_learning_path_id => p_learning_path_id
638: ,p_section_name => p_section_name --ota_lp_sections_tl
639: ,p_description => p_description -- ota_lp_sections_tl
640: ,p_section_sequence => p_section_sequence
641: ,p_completion_type_code => p_completion_type_code
642: ,p_business_group_id => p_business_group_id
643: ,p_object_version_number => l_object_version_number

Line 1084: from ota_lp_sections_tl lpct,ota_lp_sections lpc

1080:
1081:
1082: cursor csr_get_dup_lpc_rec(p_learning_path_id in number,p_section_name in varchar) is
1083: select lpc.learning_path_section_id
1084: from ota_lp_sections_tl lpct,ota_lp_sections lpc
1085: where lpc.learning_path_section_id = lpct.learning_path_section_id
1086: and lpct.language=userenv('LANG')
1087: and lpc.learning_path_id = p_learning_path_id
1088: and lpct.name = p_section_name ;

Line 1142: Insert into ota_lp_sections_tl

1138: ,p_learning_path_section_id => l_learning_path_section_id
1139: ,p_object_version_number => l_object_version_number);
1140:
1141:
1142: Insert into ota_lp_sections_tl
1143: (learning_path_section_id,
1144: Language,
1145: name,
1146: Description,