APPS.OTA_LP_MEMBER_API dependencies on OTA_LEARNING_PATH_MEMBERS

Line 454: FROM ota_learning_path_members lpm

450: p_learning_path_member_id in number)
451: IS
452: CURSOR csr_get_lpm_sequence IS
453: SELECT lpm.course_sequence, lpm.learning_path_id
454: FROM ota_learning_path_members lpm
455: WHERE lpm.learning_path_member_id = p_learning_path_member_id;
456:
457: CURSOR get_lpms(p_learning_path_id IN NUMBER, p_course_sequence IN NUMBER) IS
458: SELECT lpm.learning_path_member_id, lpm.object_version_number, lpm.course_sequence

Line 459: FROM ota_learning_path_members lpm

455: WHERE lpm.learning_path_member_id = p_learning_path_member_id;
456:
457: CURSOR get_lpms(p_learning_path_id IN NUMBER, p_course_sequence IN NUMBER) IS
458: SELECT lpm.learning_path_member_id, lpm.object_version_number, lpm.course_sequence
459: FROM ota_learning_path_members lpm
460: WHERE lpm.learning_path_id = p_learning_path_id
461: AND lpm.course_sequence > p_course_sequence
462: ORDER BY course_sequence;
463:

Line 464: l_course_sequence ota_learning_path_members.course_sequence%TYPE;

460: WHERE lpm.learning_path_id = p_learning_path_id
461: AND lpm.course_sequence > p_course_sequence
462: ORDER BY course_sequence;
463:
464: l_course_sequence ota_learning_path_members.course_sequence%TYPE;
465: l_learning_path_id ota_learning_path_members.learning_path_id%TYPE;
466: l_lpm_rec get_lpms%ROWTYPE;
467: l_sequence ota_learning_path_members.course_sequence%TYPE;
468: l_proc varchar2(72) := g_package||' order course sequence';

Line 465: l_learning_path_id ota_learning_path_members.learning_path_id%TYPE;

461: AND lpm.course_sequence > p_course_sequence
462: ORDER BY course_sequence;
463:
464: l_course_sequence ota_learning_path_members.course_sequence%TYPE;
465: l_learning_path_id ota_learning_path_members.learning_path_id%TYPE;
466: l_lpm_rec get_lpms%ROWTYPE;
467: l_sequence ota_learning_path_members.course_sequence%TYPE;
468: l_proc varchar2(72) := g_package||' order course sequence';
469: BEGIN

Line 467: l_sequence ota_learning_path_members.course_sequence%TYPE;

463:
464: l_course_sequence ota_learning_path_members.course_sequence%TYPE;
465: l_learning_path_id ota_learning_path_members.learning_path_id%TYPE;
466: l_lpm_rec get_lpms%ROWTYPE;
467: l_sequence ota_learning_path_members.course_sequence%TYPE;
468: l_proc varchar2(72) := g_package||' order course sequence';
469: BEGIN
470: hr_utility.set_location('Entering:'|| l_proc, 10);
471: OPEN csr_get_lpm_sequence;