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_CMB_BUS dependencies on OTA_CERTIFICATION_MEMBERS

Line 31: , ota_certification_members cmb

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_certification_members cmb
32: where cmb.certification_member_id = p_certification_member_id
33: and pbg.business_group_id = cmb.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_certification_members cmb

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_certification_members cmb
102: where cmb.certification_member_id = p_certification_member_id
103: and pbg.business_group_id = cmb.business_group_id;
104: --
105: -- Declare local variables

Line 249: ,p_descflex_name => 'OTA_CERTIFICATION_MEMBERS'

245: -- b) During insert.
246: --
247: hr_dflex_utility.ins_or_upd_descflex_attribs
248: (p_appl_short_name => 'OTA'
249: ,p_descflex_name => 'OTA_CERTIFICATION_MEMBERS'
250: ,p_attribute_category => p_rec.attribute_category
251: ,p_attribute1_name => 'ATTRIBUTE1'
252: ,p_attribute1_value => p_rec.attribute1
253: ,p_attribute2_name => 'ATTRIBUTE2'

Line 386: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'

382: Begin
383: hr_utility.set_location(' Entering:' || l_proc,10);
384: --
385: IF hr_multi_message.no_exclusive_error
386: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
387: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
388: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
389: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
390: ) THEN

Line 387: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

383: hr_utility.set_location(' Entering:' || l_proc,10);
384: --
385: IF hr_multi_message.no_exclusive_error
386: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
387: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
388: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
389: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
390: ) THEN
391:

Line 388: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'

384: --
385: IF hr_multi_message.no_exclusive_error
386: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
387: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
388: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
389: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
390: ) THEN
391:
392: --

Line 389: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

385: IF hr_multi_message.no_exclusive_error
386: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
387: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
388: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
389: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
390: ) THEN
391:
392: --
393: OPEN csr_av_start_end_date;

Line 435: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'

431:
432: Exception
433: when app_exception.application_exception then
434: IF hr_multi_message.exception_add
435: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
436: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
437: ) THEN
438: raise;
439: END IF;

Line 436: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

432: Exception
433: when app_exception.application_exception then
434: IF hr_multi_message.exception_add
435: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
436: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
437: ) THEN
438: raise;
439: END IF;
440:

Line 478: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'

474: Begin
475: hr_utility.set_location(' Entering:' || l_proc,10);
476: --
477: IF hr_multi_message.no_exclusive_error
478: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
479: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
480: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
481: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
482: ) THEN

Line 479: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

475: hr_utility.set_location(' Entering:' || l_proc,10);
476: --
477: IF hr_multi_message.no_exclusive_error
478: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
479: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
480: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
481: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
482: ) THEN
483:

Line 480: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'

476: --
477: IF hr_multi_message.no_exclusive_error
478: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
479: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
480: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
481: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
482: ) THEN
483:
484: --

Line 481: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

477: IF hr_multi_message.no_exclusive_error
478: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
479: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
480: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
481: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
482: ) THEN
483:
484: --
485: OPEN csr_cert_start_end_date;

Line 527: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'

523:
524: Exception
525: when app_exception.application_exception then
526: IF hr_multi_message.exception_add
527: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
528: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
529: ) THEN
530: raise;
531: END IF;

Line 528: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

524: Exception
525: when app_exception.application_exception then
526: IF hr_multi_message.exception_add
527: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
528: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
529: ) THEN
530: raise;
531: END IF;
532:

Line 553: CURSOR csr_dup_cmb(p_activity_version_id ota_certification_members.object_id%type,

549: --
550: --
551: -- Cursor to get other certification components with the same activity_version
552:
553: CURSOR csr_dup_cmb(p_activity_version_id ota_certification_members.object_id%type,
554: p_certification_id ota_certification_members.certification_id%type,
555: p_certification_member_id ota_certification_members.certification_member_id%type)
556: is
557: SELECT

Line 554: p_certification_id ota_certification_members.certification_id%type,

550: --
551: -- Cursor to get other certification components with the same activity_version
552:
553: CURSOR csr_dup_cmb(p_activity_version_id ota_certification_members.object_id%type,
554: p_certification_id ota_certification_members.certification_id%type,
555: p_certification_member_id ota_certification_members.certification_member_id%type)
556: is
557: SELECT
558: start_date_active,

Line 555: p_certification_member_id ota_certification_members.certification_member_id%type)

551: -- Cursor to get other certification components with the same activity_version
552:
553: CURSOR csr_dup_cmb(p_activity_version_id ota_certification_members.object_id%type,
554: p_certification_id ota_certification_members.certification_id%type,
555: p_certification_member_id ota_certification_members.certification_member_id%type)
556: is
557: SELECT
558: start_date_active,
559: end_date_active

Line 560: FROM ota_certification_members

556: is
557: SELECT
558: start_date_active,
559: end_date_active
560: FROM ota_certification_members
561: WHERE certification_id = p_certification_id
562: and object_id = p_activity_version_id
563: and object_type = 'H'
564: and (p_certification_member_id is null OR not certification_member_id = p_certification_member_id);

Line 576: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'

572: Begin
573: hr_utility.set_location(' Entering:' || l_proc,10);
574: --
575: IF hr_multi_message.no_exclusive_error
576: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
577: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
578: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
579: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
580: ) THEN

Line 577: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

573: hr_utility.set_location(' Entering:' || l_proc,10);
574: --
575: IF hr_multi_message.no_exclusive_error
576: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
577: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
578: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
579: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
580: ) THEN
581:

Line 578: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'

574: --
575: IF hr_multi_message.no_exclusive_error
576: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
577: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
578: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
579: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
580: ) THEN
581:
582: for a_dup_cmb in csr_dup_cmb(p_activity_version_id, p_certification_id, p_cert_member_id) loop

Line 579: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

575: IF hr_multi_message.no_exclusive_error
576: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
577: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
578: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
579: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
580: ) THEN
581:
582: for a_dup_cmb in csr_dup_cmb(p_activity_version_id, p_certification_id, p_cert_member_id) loop
583:

Line 604: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'

600:
601: Exception
602: when app_exception.application_exception then
603: IF hr_multi_message.exception_add
604: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
605: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
606: ) THEN
607: raise;
608: END IF;

Line 605: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

601: Exception
602: when app_exception.application_exception then
603: IF hr_multi_message.exception_add
604: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
605: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
606: ) THEN
607: raise;
608: END IF;
609:

Line 632: CURSOR csr_dup_cmb(p_activity_version_id ota_certification_members.object_id%type,

628: --
629: --
630: -- Cursor to get other certification components with the same activity_version
631:
632: CURSOR csr_dup_cmb(p_activity_version_id ota_certification_members.object_id%type,
633: p_certification_id ota_certification_members.certification_id%type,
634: p_certification_member_id ota_certification_members.certification_member_id%type)
635: is
636: SELECT

Line 633: p_certification_id ota_certification_members.certification_id%type,

629: --
630: -- Cursor to get other certification components with the same activity_version
631:
632: CURSOR csr_dup_cmb(p_activity_version_id ota_certification_members.object_id%type,
633: p_certification_id ota_certification_members.certification_id%type,
634: p_certification_member_id ota_certification_members.certification_member_id%type)
635: is
636: SELECT
637: start_date_active,

Line 634: p_certification_member_id ota_certification_members.certification_member_id%type)

630: -- Cursor to get other certification components with the same activity_version
631:
632: CURSOR csr_dup_cmb(p_activity_version_id ota_certification_members.object_id%type,
633: p_certification_id ota_certification_members.certification_id%type,
634: p_certification_member_id ota_certification_members.certification_member_id%type)
635: is
636: SELECT
637: start_date_active,
638: end_date_active

Line 639: FROM ota_certification_members

635: is
636: SELECT
637: start_date_active,
638: end_date_active
639: FROM ota_certification_members
640: WHERE certification_id = p_certification_id
641: and object_id = p_activity_version_id
642: and object_type = 'H'
643: and (p_certification_member_id is null OR not certification_member_id = p_certification_member_id);

Line 658: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'

654:
655: p_return_status := 'S';
656:
657: IF hr_multi_message.no_exclusive_error
658: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
659: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
660: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
661: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
662: ) THEN

Line 659: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

655: p_return_status := 'S';
656:
657: IF hr_multi_message.no_exclusive_error
658: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
659: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
660: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
661: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
662: ) THEN
663:

Line 660: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'

656:
657: IF hr_multi_message.no_exclusive_error
658: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
659: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
660: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
661: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
662: ) THEN
663:
664: for a_dup_cmb in csr_dup_cmb(p_activity_version_id, p_certification_id, p_cert_member_id) loop

Line 661: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

657: IF hr_multi_message.no_exclusive_error
658: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
659: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
660: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
661: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
662: ) THEN
663:
664: for a_dup_cmb in csr_dup_cmb(p_activity_version_id, p_certification_id, p_cert_member_id) loop
665:

Line 687: (p_object_id IN ota_certification_members.object_id%TYPE

683: End chk_dup_cmb_dates;
684: --
685: --
686: PROCEDURE chk_if_dup_cmb_exists
687: (p_object_id IN ota_certification_members.object_id%TYPE
688: ,p_certification_id IN ota_certification_members.certification_id%TYPE
689: , p_return_status OUT NOCOPY VARCHAR2)
690: IS
691: --

Line 688: ,p_certification_id IN ota_certification_members.certification_id%TYPE

684: --
685: --
686: PROCEDURE chk_if_dup_cmb_exists
687: (p_object_id IN ota_certification_members.object_id%TYPE
688: ,p_certification_id IN ota_certification_members.certification_id%TYPE
689: , p_return_status OUT NOCOPY VARCHAR2)
690: IS
691: --
692: --

Line 696: cursor sel_cmb_exists(p_object_id ota_certification_members.object_id%type,

692: --
693: v_exists varchar2(1);
694: v_proc varchar2(72) := g_package||'chk_if_dup_cmb_exists';
695: --
696: cursor sel_cmb_exists(p_object_id ota_certification_members.object_id%type,
697: p_certification_id ota_certification_members.certification_id%type) is
698: select 'Y'
699: from ota_certification_members cmb
700: where cmb.object_id = p_object_id

Line 697: p_certification_id ota_certification_members.certification_id%type) is

693: v_exists varchar2(1);
694: v_proc varchar2(72) := g_package||'chk_if_dup_cmb_exists';
695: --
696: cursor sel_cmb_exists(p_object_id ota_certification_members.object_id%type,
697: p_certification_id ota_certification_members.certification_id%type) is
698: select 'Y'
699: from ota_certification_members cmb
700: where cmb.object_id = p_object_id
701: and cmb.certification_id = p_certification_id;

Line 699: from ota_certification_members cmb

695: --
696: cursor sel_cmb_exists(p_object_id ota_certification_members.object_id%type,
697: p_certification_id ota_certification_members.certification_id%type) is
698: select 'Y'
699: from ota_certification_members cmb
700: where cmb.object_id = p_object_id
701: and cmb.certification_id = p_certification_id;
702: --
703: Begin

Line 730: (p_cert_mbr_id IN ota_certification_members.certification_member_id%TYPE

726:
727: END chk_if_dup_cmb_exists;
728:
729: PROCEDURE chk_should_warn_delete
730: (p_cert_mbr_id IN ota_certification_members.certification_member_id%TYPE
731: , p_return_status OUT NOCOPY VARCHAR2)
732: IS
733: --
734: v_proc varchar2(72) := g_package||'chk_should_warn_delete';

Line 736: cursor csr_cmb_info(p_cert_mbr_id ota_certification_members.certification_member_id%type) is

732: IS
733: --
734: v_proc varchar2(72) := g_package||'chk_should_warn_delete';
735: --
736: cursor csr_cmb_info(p_cert_mbr_id ota_certification_members.certification_member_id%type) is
737: select certification_id
738: from ota_certification_members
739: where certification_member_id = p_cert_mbr_id and
740: (end_date_active is null or

Line 738: from ota_certification_members

734: v_proc varchar2(72) := g_package||'chk_should_warn_delete';
735: --
736: cursor csr_cmb_info(p_cert_mbr_id ota_certification_members.certification_member_id%type) is
737: select certification_id
738: from ota_certification_members
739: where certification_member_id = p_cert_mbr_id and
740: (end_date_active is null or
741: end_date_active > sysdate);
742:

Line 744: p_cert_mbr_id ota_certification_members.certification_member_id%type,

740: (end_date_active is null or
741: end_date_active > sysdate);
742:
743: cursor csr_cmb_exists(
744: p_cert_mbr_id ota_certification_members.certification_member_id%type,
745: p_certification_id ota_certifications_b.certification_id%type) is
746: select 'Y'
747: from ota_certification_members cmb
748: where cmb.certification_id = p_certification_id

Line 747: from ota_certification_members cmb

743: cursor csr_cmb_exists(
744: p_cert_mbr_id ota_certification_members.certification_member_id%type,
745: p_certification_id ota_certifications_b.certification_id%type) is
746: select 'Y'
747: from ota_certification_members cmb
748: where cmb.certification_id = p_certification_id
749: and cmb.certification_member_id <> p_cert_mbr_id
750: and (cmb.end_date_active is null or
751: cmb.end_date_active > sysdate);