APPS.OTA_TRAINING_PLAN_UPGRADE dependencies on OTA_LP_SECTIONS

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 627: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_SECTIONS';

623:
624:
625: BEGIN
626: l_add_struct_d.extend(1);
627: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_SECTIONS';
628: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
629:
630: open csr_get_dup_lpc_rec(p_learning_path_id, p_section_name);
631: fetch csr_get_dup_lpc_rec into l_learning_path_section_id;

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 1122: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_SECTIONS';

1118: end if;
1119: FOR lp_rec IN csr_get_lp LOOP
1120: l_learning_path_id := lp_rec.learning_path_id;
1121: l_add_struct_d.extend(1);
1122: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_SECTIONS';
1123: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
1124:
1125: open csr_get_dup_lpc_rec(l_learning_path_id, lp_rec.name);
1126: fetch csr_get_dup_lpc_rec into l_learning_path_section_id;

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,