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 173: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,

169: --
170: -- ---------------------------------------------------------------------------
171: -- |----------------------< chk_enrollment_exist >--------------------------|
172: -- ---------------------------------------------------------------------------
173: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,
174: p_contact_id IN ota_learning_paths.contact_id%TYPE,
175: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
176: RETURN boolean
177: IS

Line 174: p_contact_id IN ota_learning_paths.contact_id%TYPE,

170: -- ---------------------------------------------------------------------------
171: -- |----------------------< chk_enrollment_exist >--------------------------|
172: -- ---------------------------------------------------------------------------
173: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,
174: p_contact_id IN ota_learning_paths.contact_id%TYPE,
175: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
176: RETURN boolean
177: IS
178: CURSOR chk_enr IS

Line 229: l_person_id ota_learning_paths.person_id%TYPE;

225:
226: l_proc VARCHAR2(72) := g_package|| 'calculate_lme_status';
227: l_enroll_status VARCHAR2(30);
228: l_date_status_changed DATE;
229: l_person_id ota_learning_paths.person_id%TYPE;
230: l_contact_id ota_learning_paths.contact_id%TYPE;
231:
232: BEGIN
233:

Line 230: l_contact_id ota_learning_paths.contact_id%TYPE;

226: l_proc VARCHAR2(72) := g_package|| 'calculate_lme_status';
227: l_enroll_status VARCHAR2(30);
228: l_date_status_changed DATE;
229: l_person_id ota_learning_paths.person_id%TYPE;
230: l_contact_id ota_learning_paths.contact_id%TYPE;
231:
232: BEGIN
233:
234: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 277: p_person_id IN ota_learning_paths.person_id%TYPE,

273: -- ---------------------------------------------------------------------------
274: -- |----------------------< get_lme_status >-----------------------------|
275: -- ---------------------------------------------------------------------------
276: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
277: p_person_id IN ota_learning_paths.person_id%TYPE,
278: p_contact_id IN ota_learning_paths.contact_id%TYPE)
279: RETURN VARCHAR2
280: IS
281:

Line 278: p_contact_id IN ota_learning_paths.contact_id%TYPE)

274: -- |----------------------< get_lme_status >-----------------------------|
275: -- ---------------------------------------------------------------------------
276: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
277: p_person_id IN ota_learning_paths.person_id%TYPE,
278: p_contact_id IN ota_learning_paths.contact_id%TYPE)
279: RETURN VARCHAR2
280: IS
281:
282: l_proc VARCHAR2(72) := g_package|| 'get_lme_status';

Line 286: l_person_id ota_learning_paths.person_id%TYPE;

282: l_proc VARCHAR2(72) := g_package|| 'get_lme_status';
283: l_enroll_status VARCHAR2(30);
284: l_member_status_code VARCHAR2(30);
285: l_date_status_changed DATE;
286: l_person_id ota_learning_paths.person_id%TYPE;
287: l_contact_id ota_learning_paths.contact_id%TYPE;
288:
289: BEGIN
290:

Line 287: l_contact_id ota_learning_paths.contact_id%TYPE;

283: l_enroll_status VARCHAR2(30);
284: l_member_status_code VARCHAR2(30);
285: l_date_status_changed DATE;
286: l_person_id ota_learning_paths.person_id%TYPE;
287: l_contact_id ota_learning_paths.contact_id%TYPE;
288:
289: BEGIN
290:
291: hr_utility.set_location('Entering:'|| l_proc, 10);

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

379:
380: -- ----------------------------------------------------------------------------
381: -- |---------------------------< get_valid_enroll >-------------------------|
382: -- ----------------------------------------------------------------------------
383: PROCEDURE get_valid_enroll (p_person_id IN ota_learning_paths.person_id%TYPE
384: ,p_contact_id IN ota_learning_paths.contact_id%TYPE
385: ,p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE
386: ,p_return_status OUT nocopy VARCHAR2)
387: IS

Line 384: ,p_contact_id IN ota_learning_paths.contact_id%TYPE

380: -- ----------------------------------------------------------------------------
381: -- |---------------------------< get_valid_enroll >-------------------------|
382: -- ----------------------------------------------------------------------------
383: PROCEDURE get_valid_enroll (p_person_id IN ota_learning_paths.person_id%TYPE
384: ,p_contact_id IN ota_learning_paths.contact_id%TYPE
385: ,p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE
386: ,p_return_status OUT nocopy VARCHAR2)
387: IS
388: l_enr_type VARCHAR2(30);

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

720: --
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;

Line 745: l_path_source_code ota_learning_paths.path_source_code%TYPE;

741: l_member_status_code varchar2(30) := p_member_status_code;
742: l_exists boolean;
743:
744: l_proc varchar2(72) := g_package ||'create_talent_mgmt_lpm';
745: l_path_source_code ota_learning_paths.path_source_code%TYPE;
746: l_path_name ota_lp_sections_tl.name%TYPE := p_path_name;
747:
748: CURSOR csr_get_lp IS
749: SELECT lps.learning_path_id,

Line 752: FROM ota_learning_paths lps,

748: CURSOR csr_get_lp IS
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

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

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;
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;

Line 1044: FROM ota_learning_paths lps,

1040: SELECT lps.learning_path_id,
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