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_LP_SECTION_API dependencies on OTA_LP_SECTIONS

Line 285: l_old_comp_type ota_lp_sections.completion_type_code%TYPE;

281: l_object_version_number number := p_object_version_number;
282: l_effective_date date;
283:
284: l_lpm_ovn ota_learning_path_members.object_version_number%TYPE;
285: l_old_comp_type ota_lp_sections.completion_type_code%TYPE;
286: l_no_of_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE := p_no_of_mandatory_courses;
287:
288: CURSOR comp_type IS
289: SELECT completion_type_code

Line 286: l_no_of_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE := p_no_of_mandatory_courses;

282: l_effective_date date;
283:
284: l_lpm_ovn ota_learning_path_members.object_version_number%TYPE;
285: l_old_comp_type ota_lp_sections.completion_type_code%TYPE;
286: l_no_of_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE := p_no_of_mandatory_courses;
287:
288: CURSOR comp_type IS
289: SELECT completion_type_code
290: FROM ota_lp_sections

Line 290: FROM ota_lp_sections

286: l_no_of_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE := p_no_of_mandatory_courses;
287:
288: CURSOR comp_type IS
289: SELECT completion_type_code
290: FROM ota_lp_sections
291: WHERE learning_path_section_id = p_learning_path_section_id;
292:
293: CURSOR get_lpms IS
294: SELECT learning_path_member_id,