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

Line 31: , ota_lp_enrollments lpe

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ota_lp_enrollments lpe
32: where lpe.lp_enrollment_id = p_lp_enrollment_id
33: and pbg.business_group_id = lpe.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_lp_enrollments lpe

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_lp_enrollments lpe
102: where lpe.lp_enrollment_id = p_lp_enrollment_id
103: and pbg.business_group_id = lpe.business_group_id;
104: --
105: -- Declare local variables

Line 269: ,p_descflex_name => 'OTA_LP_ENROLLMENTS'

265: -- b) During insert.
266: --
267: hr_dflex_utility.ins_or_upd_descflex_attribs
268: (p_appl_short_name => 'OTA'
269: ,p_descflex_name => 'OTA_LP_ENROLLMENTS'
270: ,p_attribute_category => p_rec.attribute_category
271: ,p_attribute1_name => 'ATTRIBUTE1'
272: ,p_attribute1_value => p_rec.attribute1
273: ,p_attribute2_name => 'ATTRIBUTE2'

Line 427: Procedure chk_person_contact (p_person_id ota_lp_enrollments.person_id%TYPE,

423: --
424: -- ---------------------------------------------------------------------------
425: -- |-------------------------< chk_person_contact >---------------------------|
426: -- ---------------------------------------------------------------------------
427: Procedure chk_person_contact (p_person_id ota_lp_enrollments.person_id%TYPE,
428: p_contact_id ota_lp_enrollments.contact_id%TYPE)
429: is
430: --
431: l_proc varchar2(72) := g_package||'chk_person_contact';

Line 428: p_contact_id ota_lp_enrollments.contact_id%TYPE)

424: -- ---------------------------------------------------------------------------
425: -- |-------------------------< chk_person_contact >---------------------------|
426: -- ---------------------------------------------------------------------------
427: Procedure chk_person_contact (p_person_id ota_lp_enrollments.person_id%TYPE,
428: p_contact_id ota_lp_enrollments.contact_id%TYPE)
429: is
430: --
431: l_proc varchar2(72) := g_package||'chk_person_contact';
432:

Line 484: p_associated_column1 => 'OTA_LP_ENROLLMENTS.PERSON_ID') THEN

480: EXCEPTION
481:
482: WHEN app_exception.application_exception THEN
483: IF hr_multi_message.exception_add(
484: p_associated_column1 => 'OTA_LP_ENROLLMENTS.PERSON_ID') THEN
485: hr_utility.set_location(' Leaving:'||l_proc, 52);
486: RAISE;
487:
488: END IF;

Line 499: ,p_path_status_code IN ota_lp_enrollments.path_status_code%TYPE

495: -- ----------------------------------------------------------------------------
496: --
497: PROCEDURE chk_path_status_code
498: (p_effective_date IN date
499: ,p_path_status_code IN ota_lp_enrollments.path_status_code%TYPE
500: ) IS
501: --
502: l_proc varchar2(72) := g_package|| 'chk_path_status_code';
503: --

Line 532: p_associated_column1 => 'OTA_LP_ENROLLMENTS.PATH_STATUS_CODE') THEN

528: --MULTI MESSAGE SUPPORT
529: EXCEPTION
530: WHEN app_exception.application_exception THEN
531: IF hr_multi_message.exception_add(
532: p_associated_column1 => 'OTA_LP_ENROLLMENTS.PATH_STATUS_CODE') THEN
533: hr_utility.set_location(' Leaving:'||l_proc, 32);
534: RAISE;
535:
536: END IF;

Line 547: ,p_enrollment_source_code IN ota_lp_enrollments.enrollment_source_code%TYPE

543: -- ----------------------------------------------------------------------------
544: --
545: PROCEDURE chk_enrollment_source_code
546: (p_effective_date IN date
547: ,p_enrollment_source_code IN ota_lp_enrollments.enrollment_source_code%TYPE
548: ) IS
549: --
550: l_proc varchar2(72) := g_package|| 'chk_enrollment_source_code';
551: --

Line 580: p_associated_column1 => 'OTA_LP_ENROLLMENTS.ENROLLMENT_SOURCE_CODE') THEN

576: --MULTI MESSAGE SUPPORT
577: EXCEPTION
578: WHEN app_exception.application_exception THEN
579: IF hr_multi_message.exception_add(
580: p_associated_column1 => 'OTA_LP_ENROLLMENTS.ENROLLMENT_SOURCE_CODE') THEN
581: hr_utility.set_location(' Leaving:'||l_proc, 32);
582: RAISE;
583:
584: END IF;

Line 595: (p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)

591: -- |-----------------------------------------------|
592: -- ----------------------------------------------------------------------------
593: --
594: PROCEDURE chk_del_lp_enrollment_id
595: (p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)
596: IS
597: --
598: l_exists varchar2(1);
599: l_proc varchar2(72) := g_package|| 'chk_del_lp_enrollment_id';

Line 642: ( p_learning_path_id IN ota_lp_enrollments.learning_path_id%TYPE

638: -- |-----------------------------------------------|
639: -- ----------------------------------------------------------------------------
640: --
641: PROCEDURE check_duplicate_subscription
642: ( p_learning_path_id IN ota_lp_enrollments.learning_path_id%TYPE
643: ,p_contact_id IN ota_lp_enrollments.contact_id%TYPE default NULL
644: ,p_person_id IN ota_lp_enrollments.person_id%TYPE default NULL)
645: IS
646: --

Line 643: ,p_contact_id IN ota_lp_enrollments.contact_id%TYPE default NULL

639: -- ----------------------------------------------------------------------------
640: --
641: PROCEDURE check_duplicate_subscription
642: ( p_learning_path_id IN ota_lp_enrollments.learning_path_id%TYPE
643: ,p_contact_id IN ota_lp_enrollments.contact_id%TYPE default NULL
644: ,p_person_id IN ota_lp_enrollments.person_id%TYPE default NULL)
645: IS
646: --
647: l_exists varchar2(1);

Line 644: ,p_person_id IN ota_lp_enrollments.person_id%TYPE default NULL)

640: --
641: PROCEDURE check_duplicate_subscription
642: ( p_learning_path_id IN ota_lp_enrollments.learning_path_id%TYPE
643: ,p_contact_id IN ota_lp_enrollments.contact_id%TYPE default NULL
644: ,p_person_id IN ota_lp_enrollments.person_id%TYPE default NULL)
645: IS
646: --
647: l_exists varchar2(1);
648: l_proc varchar2(72) := g_package|| 'check_duplicate_subscription';

Line 652: FROM ota_lp_enrollments lpe

648: l_proc varchar2(72) := g_package|| 'check_duplicate_subscription';
649:
650: CURSOR csr_lp_enr_id IS
651: SELECT null
652: FROM ota_lp_enrollments lpe
653: WHERE lpe.learning_path_id = p_learning_path_id
654: AND ( lpe.person_id = p_person_id and lpe.contact_id IS NULL
655: OR lpe.contact_id = p_contact_id and lpe.person_id IS NULL)
656: AND lpe.path_status_code <> 'CANCELLED';