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_LEARNING_PATHS

Line 14: FUNCTION get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,

10:
11: -- ---------------------------------------------------------------------------
12: -- |----------------------< get_enrollment_status >--------------------------|
13: -- ---------------------------------------------------------------------------
14: FUNCTION get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,
15: p_contact_id IN ota_learning_paths.contact_id%TYPE,
16: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,
17: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE DEFAULT NULL,
18: p_return_code IN VARCHAR2)

Line 15: p_contact_id IN ota_learning_paths.contact_id%TYPE,

11: -- ---------------------------------------------------------------------------
12: -- |----------------------< get_enrollment_status >--------------------------|
13: -- ---------------------------------------------------------------------------
14: FUNCTION get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,
15: p_contact_id IN ota_learning_paths.contact_id%TYPE,
16: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,
17: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE DEFAULT NULL,
18: p_return_code IN VARCHAR2)
19: RETURN VARCHAR2 IS

Line 98: PROCEDURE get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,

94: -- ---------------------------------------------------------------------------
95: -- |----------------------< get_enrollment_status >--------------------------|
96: -- ---------------------------------------------------------------------------
97: --
98: PROCEDURE get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,
99: p_contact_id IN ota_learning_paths.contact_id%TYPE,
100: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,
101: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
102: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,

Line 99: p_contact_id IN ota_learning_paths.contact_id%TYPE,

95: -- |----------------------< get_enrollment_status >--------------------------|
96: -- ---------------------------------------------------------------------------
97: --
98: PROCEDURE get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,
99: p_contact_id IN ota_learning_paths.contact_id%TYPE,
100: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,
101: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
102: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
103: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE,

Line 179: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,

175: --
176: -- ---------------------------------------------------------------------------
177: -- |----------------------< chk_enrollment_exist >--------------------------|
178: -- ---------------------------------------------------------------------------
179: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,
180: p_contact_id IN ota_learning_paths.contact_id%TYPE,
181: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
182: RETURN boolean
183: IS

Line 180: p_contact_id IN ota_learning_paths.contact_id%TYPE,

176: -- ---------------------------------------------------------------------------
177: -- |----------------------< chk_enrollment_exist >--------------------------|
178: -- ---------------------------------------------------------------------------
179: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,
180: p_contact_id IN ota_learning_paths.contact_id%TYPE,
181: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
182: RETURN boolean
183: IS
184: CURSOR chk_enr IS

Line 235: l_person_id ota_learning_paths.person_id%TYPE;

231:
232: l_proc VARCHAR2(72) := g_package|| 'calculate_lme_status';
233: l_enroll_status VARCHAR2(30);
234: l_date_status_changed DATE;
235: l_person_id ota_learning_paths.person_id%TYPE;
236: l_contact_id ota_learning_paths.contact_id%TYPE;
237: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
238: BEGIN
239:

Line 236: l_contact_id ota_learning_paths.contact_id%TYPE;

232: l_proc VARCHAR2(72) := g_package|| 'calculate_lme_status';
233: l_enroll_status VARCHAR2(30);
234: l_date_status_changed DATE;
235: l_person_id ota_learning_paths.person_id%TYPE;
236: l_contact_id ota_learning_paths.contact_id%TYPE;
237: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
238: BEGIN
239:
240: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 286: p_person_id IN ota_learning_paths.person_id%TYPE,

282: -- ---------------------------------------------------------------------------
283: -- |----------------------< get_lme_status >-----------------------------|
284: -- ---------------------------------------------------------------------------
285: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
286: p_person_id IN ota_learning_paths.person_id%TYPE,
287: p_contact_id IN ota_learning_paths.contact_id%TYPE)
288: RETURN VARCHAR2
289: IS
290:

Line 287: p_contact_id IN ota_learning_paths.contact_id%TYPE)

283: -- |----------------------< get_lme_status >-----------------------------|
284: -- ---------------------------------------------------------------------------
285: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
286: p_person_id IN ota_learning_paths.person_id%TYPE,
287: p_contact_id IN ota_learning_paths.contact_id%TYPE)
288: RETURN VARCHAR2
289: IS
290:
291: l_proc VARCHAR2(72) := g_package|| 'get_lme_status';

Line 295: l_person_id ota_learning_paths.person_id%TYPE;

291: l_proc VARCHAR2(72) := g_package|| 'get_lme_status';
292: l_enroll_status VARCHAR2(30);
293: l_member_status_code VARCHAR2(30);
294: l_date_status_changed DATE;
295: l_person_id ota_learning_paths.person_id%TYPE;
296: l_contact_id ota_learning_paths.contact_id%TYPE;
297: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
298: BEGIN
299:

Line 296: l_contact_id ota_learning_paths.contact_id%TYPE;

292: l_enroll_status VARCHAR2(30);
293: l_member_status_code VARCHAR2(30);
294: l_date_status_changed DATE;
295: l_person_id ota_learning_paths.person_id%TYPE;
296: l_contact_id ota_learning_paths.contact_id%TYPE;
297: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
298: BEGIN
299:
300: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 394: PROCEDURE get_valid_enroll (p_person_id IN ota_learning_paths.person_id%TYPE

390:
391: -- ----------------------------------------------------------------------------
392: -- |---------------------------< get_valid_enroll >-------------------------|
393: -- ----------------------------------------------------------------------------
394: PROCEDURE get_valid_enroll (p_person_id IN ota_learning_paths.person_id%TYPE
395: ,p_contact_id IN ota_learning_paths.contact_id%TYPE
396: ,p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE
397: ,p_return_status OUT nocopy VARCHAR2)
398: IS

Line 395: ,p_contact_id IN ota_learning_paths.contact_id%TYPE

391: -- ----------------------------------------------------------------------------
392: -- |---------------------------< get_valid_enroll >-------------------------|
393: -- ----------------------------------------------------------------------------
394: PROCEDURE get_valid_enroll (p_person_id IN ota_learning_paths.person_id%TYPE
395: ,p_contact_id IN ota_learning_paths.contact_id%TYPE
396: ,p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE
397: ,p_return_status OUT nocopy VARCHAR2)
398: IS
399: l_enr_type VARCHAR2(30);

Line 746: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := p_learning_path_id;

742: --
743: -- Variables for IN/OUT parameters
744: --
745: -- Other variables
746: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := p_learning_path_id;
747: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
748: l_learning_path_section_id ota_lp_sections.learning_path_section_id%TYPE;
749: l_learning_path_member_id ota_learning_path_members.learning_path_member_id%TYPE;
750: l_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;

Line 767: l_path_source_code ota_learning_paths.path_source_code%TYPE;

763: l_member_status_code varchar2(30) := p_member_status_code;
764: l_exists boolean;
765:
766: l_proc varchar2(72) := g_package ||'create_talent_mgmt_lpm';
767: l_path_source_code ota_learning_paths.path_source_code%TYPE;
768: l_path_name ota_lp_sections_tl.name%TYPE := p_path_name;
769:
770: CURSOR csr_get_lp IS
771: SELECT lps.learning_path_id,

Line 774: FROM ota_learning_paths lps,

770: CURSOR csr_get_lp IS
771: SELECT lps.learning_path_id,
772: lpe.lp_enrollment_id,
773: lpc.learning_path_section_id
774: FROM ota_learning_paths lps,
775: ota_lp_enrollments lpe,
776: ota_lp_sections lpc
777: WHERE lps.learning_path_id = lpe.learning_path_id
778: AND lpc.learning_path_id = lps.learning_path_id

Line 1044: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := p_learning_path_id;

1040: -- Other variables
1041: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
1042: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
1043:
1044: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := p_learning_path_id;
1045: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
1046: l_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
1047: l_no_of_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
1048: l_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;

Line 1066: FROM ota_learning_paths lps,

1062: SELECT lps.learning_path_id,
1063: lps.object_version_number lps_ovn,
1064: lpe.lp_enrollment_id,
1065: lpe.object_version_number lpe_ovn
1066: FROM ota_learning_paths lps,
1067: ota_lp_enrollments lpe
1068: WHERE lps.learning_path_id = lpe.learning_path_id
1069: AND lps.path_source_code = 'TALENT_MGMT'
1070: AND lps.source_function_code = p_source_function_code