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_LRNG_PATH_MEMBER_UTIL dependencies on OTA_LP_ENROLLMENTS

Line 221: p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,

217: -- ---------------------------------------------------------------------------
218: -- |----------------------< calculate_lme_status >-----------------------------|
219: -- ---------------------------------------------------------------------------
220: PROCEDURE calculate_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
221: p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,
222: p_member_status_code OUT nocopy VARCHAR2,
223: p_completion_date OUT nocopy DATE)
224: IS
225:

Line 238: FROM ota_lp_enrollments lpe

234: hr_utility.set_location('Entering:'|| l_proc, 10);
235:
236: SELECT lpe.person_id, lpe.contact_id
237: INTO l_person_id , l_contact_id
238: FROM ota_lp_enrollments lpe
239: where lpe.lp_enrollment_id = p_lp_enrollment_id;
240:
241: get_enrollment_status(p_person_id => l_person_id,
242: p_contact_id => l_contact_id,

Line 337: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;

333: AND member_status_code = 'COMPLETED';
334:
335: l_proc VARCHAR2(72) := g_package|| 'get_lpc_completed_courses';
336:
337: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
338:
339: BEGIN
340:
341: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 411: p_person_id IN ota_lp_enrollments.person_id%TYPE,

407: -- ---------------------------------------------------------------------------
408: -- |----------------------< update_lme_enroll_status_chg >--------------------------|
409: -- ---------------------------------------------------------------------------
410: PROCEDURE update_lme_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,
411: p_person_id IN ota_lp_enrollments.person_id%TYPE,
412: p_contact_id IN ota_lp_enrollments.contact_id%TYPE,
413: p_lp_enrollment_ids OUT NOCOPY varchar2)
414: IS
415:

Line 412: p_contact_id IN ota_lp_enrollments.contact_id%TYPE,

408: -- |----------------------< update_lme_enroll_status_chg >--------------------------|
409: -- ---------------------------------------------------------------------------
410: PROCEDURE update_lme_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,
411: p_person_id IN ota_lp_enrollments.person_id%TYPE,
412: p_contact_id IN ota_lp_enrollments.contact_id%TYPE,
413: p_lp_enrollment_ids OUT NOCOPY varchar2)
414: IS
415:
416: l_proc VARCHAR2(72) := g_package|| 'update_lme_enroll_status_chg';

Line 436: ota_lp_enrollments olpe

432: olpe.no_of_mandatory_courses,
433: olme.member_status_code
434: FROM ota_learning_path_members olpm,
435: ota_lp_member_enrollments olme,
436: ota_lp_enrollments olpe
437: WHERE olpe.learning_path_id = olpm.learning_path_id
438: AND olpm.learning_path_member_id = olme.learning_path_member_id
439: AND olpe.lp_enrollment_id = olme.lp_enrollment_id
440: AND (( p_person_id IS NOT NULL AND olpe.person_id = p_person_id)

Line 450: l_completion_date ota_lp_enrollments.completion_date%TYPE;

446: l_lp_section_id ota_lp_sections.learning_path_section_id%TYPE;
447: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
448: l_enroll_type ota_booking_status_types.type%TYPE;
449: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
450: l_completion_date ota_lp_enrollments.completion_date%TYPE;
451: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
452: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE := 0;
453: l_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
454: l_section_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;

Line 452: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE := 0;

448: l_enroll_type ota_booking_status_types.type%TYPE;
449: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
450: l_completion_date ota_lp_enrollments.completion_date%TYPE;
451: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
452: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE := 0;
453: l_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
454: l_section_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
455:
456: --variables to store old values

Line 453: l_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;

449: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
450: l_completion_date ota_lp_enrollments.completion_date%TYPE;
451: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
452: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE := 0;
453: l_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
454: l_section_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
455:
456: --variables to store old values
457: l_old_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;

Line 454: l_section_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;

450: l_completion_date ota_lp_enrollments.completion_date%TYPE;
451: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
452: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE := 0;
453: l_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
454: l_section_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
455:
456: --variables to store old values
457: l_old_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
458: l_old_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;

Line 457: l_old_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;

453: l_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
454: l_section_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
455:
456: --variables to store old values
457: l_old_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
458: l_old_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
459: l_old_member_status ota_lp_member_enrollments.member_status_code%TYPE;
460:
461:

Line 458: l_old_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;

454: l_section_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
455:
456: --variables to store old values
457: l_old_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
458: l_old_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
459: l_old_member_status ota_lp_member_enrollments.member_status_code%TYPE;
460:
461:
462: BEGIN

Line 561: FROM ota_lp_enrollments lpe,

557: CURSOR csr_lpe_with_lme
558: IS
559: SELECT lpe.lp_enrollment_id,
560: lpe.path_status_code
561: FROM ota_lp_enrollments lpe,
562: ota_lp_member_enrollments lme
563: WHERE lpe.lp_enrollment_id = lme.lp_enrollment_id
564: AND lpe.path_status_code <> 'CANCELLED'
565: AND lme.lp_member_enrollment_id = p_lp_member_enrollment_id;

Line 570: FROM ota_lp_enrollments lpe

566:
567: CURSOR csr_lpe_update(csr_lp_enrollment_id number)
568: IS
569: SELECT lpe.object_version_number
570: FROM ota_lp_enrollments lpe
571: WHERE lpe.lp_enrollment_id = csr_lp_enrollment_id;
572:
573:
574: l_exists ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;

Line 575: l_object_version_number ota_lp_enrollments.object_version_number%type;

571: WHERE lpe.lp_enrollment_id = csr_lp_enrollment_id;
572:
573:
574: l_exists ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
575: l_object_version_number ota_lp_enrollments.object_version_number%type;
576: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
577: l_complete_ok varchar2(1);
578:
579: BEGIN

Line 576: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;

572:
573:
574: l_exists ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
575: l_object_version_number ota_lp_enrollments.object_version_number%type;
576: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
577: l_complete_ok varchar2(1);
578:
579: BEGIN
580: FOR rec1 in csr_lpe_with_lme LOOP

Line 612: p_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE,

608: END Update_lpe_lme_change;
609:
610:
611: Procedure Update_lpe_lme_change (p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
612: p_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE,
613: p_lp_enrollment_ids OUT NOCOPY VARCHAR2)
614: is
615:
616: CURSOR csr_lpe_with_lme

Line 622: FROM ota_lp_enrollments lpe,

618: SELECT lpe.lp_enrollment_id,
619: lpe.path_status_code,
620: lpe.learning_path_id,
621: lpe.no_of_mandatory_courses
622: FROM ota_lp_enrollments lpe,
623: ota_lp_member_enrollments lme
624: WHERE lpe.lp_enrollment_id = lme.lp_enrollment_id
625: AND lpe.path_status_code <> 'CANCELLED'
626: AND lme.lp_member_enrollment_id = p_lp_member_enrollment_id;

Line 632: FROM ota_lp_enrollments lpe

628:
629: CURSOR csr_lpe_update(csr_lp_enrollment_id number)
630: IS
631: SELECT lpe.object_version_number
632: FROM ota_lp_enrollments lpe
633: WHERE lpe.lp_enrollment_id = csr_lp_enrollment_id;
634:
635: l_exists ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
636: l_object_version_number ota_lp_enrollments.object_version_number%type;

Line 636: l_object_version_number ota_lp_enrollments.object_version_number%type;

632: FROM ota_lp_enrollments lpe
633: WHERE lpe.lp_enrollment_id = csr_lp_enrollment_id;
634:
635: l_exists ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
636: l_object_version_number ota_lp_enrollments.object_version_number%type;
637: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
638: l_completion_date DATE;
639: l_complete_ok varchar2(1);
640: l_lp_enrollment_ids varchar2(4000) := '';

Line 637: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;

633: WHERE lpe.lp_enrollment_id = csr_lp_enrollment_id;
634:
635: l_exists ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
636: l_object_version_number ota_lp_enrollments.object_version_number%type;
637: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
638: l_completion_date DATE;
639: l_complete_ok varchar2(1);
640: l_lp_enrollment_ids varchar2(4000) := '';
641:

Line 725: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;

721: -- Variables for IN/OUT parameters
722: --
723: -- Other variables
724: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := p_learning_path_id;
725: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
726: l_learning_path_section_id ota_lp_sections.learning_path_section_id%TYPE;
727: l_learning_path_member_id ota_learning_path_members.learning_path_member_id%TYPE;
728: l_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
729:

Line 753: ota_lp_enrollments lpe,

749: SELECT lps.learning_path_id,
750: lpe.lp_enrollment_id,
751: lpc.learning_path_section_id
752: FROM ota_learning_paths lps,
753: ota_lp_enrollments lpe,
754: ota_lp_sections lpc
755: WHERE lps.learning_path_id = lpe.learning_path_id
756: AND lpc.learning_path_id = lps.learning_path_id
757: AND lps.path_source_code = 'TALENT_MGMT'

Line 764: FROM ota_lp_enrollments

760: AND (p_assignment_id IS NULL OR (p_assignment_id IS NOT NULL AND lps.assignment_id = p_assignment_id));
761:
762: CURSOR csr_get_lpe IS
763: SELECT lp_enrollment_id
764: FROM ota_lp_enrollments
765: WHERE learning_path_id = l_learning_path_id
766: AND person_id = p_person_id;
767:
768: CURSOR csr_get_lpc IS

Line 1019: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;

1015: --
1016: -- Variables for IN/OUT parameters
1017: --
1018: -- Other variables
1019: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
1020: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
1021:
1022: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := p_learning_path_id;
1023: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;

Line 1023: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;

1019: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
1020: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
1021:
1022: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := p_learning_path_id;
1023: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
1024: l_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
1025: l_no_of_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
1026: l_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
1027: l_completion_date ota_lp_enrollments.completion_date%TYPE := null;

Line 1025: l_no_of_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;

1021:
1022: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := p_learning_path_id;
1023: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
1024: l_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
1025: l_no_of_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
1026: l_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
1027: l_completion_date ota_lp_enrollments.completion_date%TYPE := null;
1028:
1029: l_lp_ovn number;

Line 1026: l_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;

1022: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := p_learning_path_id;
1023: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
1024: l_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
1025: l_no_of_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
1026: l_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
1027: l_completion_date ota_lp_enrollments.completion_date%TYPE := null;
1028:
1029: l_lp_ovn number;
1030: l_lpe_ovn number;

Line 1027: l_completion_date ota_lp_enrollments.completion_date%TYPE := null;

1023: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
1024: l_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
1025: l_no_of_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
1026: l_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
1027: l_completion_date ota_lp_enrollments.completion_date%TYPE := null;
1028:
1029: l_lp_ovn number;
1030: l_lpe_ovn number;
1031: l_lme_ovn number;

Line 1045: ota_lp_enrollments lpe

1041: lps.object_version_number lps_ovn,
1042: lpe.lp_enrollment_id,
1043: lpe.object_version_number lpe_ovn
1044: FROM ota_learning_paths lps,
1045: ota_lp_enrollments lpe
1046: WHERE lps.learning_path_id = lpe.learning_path_id
1047: AND lps.path_source_code = 'TALENT_MGMT'
1048: AND lps.source_function_code = p_source_function_code
1049: AND (p_source_id IS NULL OR (p_source_id IS NOT NULL AND lps.source_id = p_source_id))