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_CRT_BUS dependencies on OTA_CERTIFICATIONS_B

Line 31: , ota_certifications_b crt

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_certifications_b crt
32: where crt.certification_id = p_certification_id
33: and pbg.business_group_id = crt.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_certifications_b crt

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_certifications_b crt
102: where crt.certification_id = p_certification_id
103: and pbg.business_group_id = crt.business_group_id;
104: --
105: -- Declare local variables

Line 372: (p_certification_id IN ota_certifications_b.certification_id%TYPE

368:
369: End chk_non_updateable_args;
370:
371: PROCEDURE chk_should_warn
372: (p_certification_id IN ota_certifications_b.certification_id%TYPE
373: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
374: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
375: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
376: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE

Line 373: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE

369: End chk_non_updateable_args;
370:
371: PROCEDURE chk_should_warn
372: (p_certification_id IN ota_certifications_b.certification_id%TYPE
373: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
374: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
375: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
376: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
377: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE

Line 374: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE

370:
371: PROCEDURE chk_should_warn
372: (p_certification_id IN ota_certifications_b.certification_id%TYPE
373: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
374: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
375: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
376: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
377: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
378: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE

Line 375: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE

371: PROCEDURE chk_should_warn
372: (p_certification_id IN ota_certifications_b.certification_id%TYPE
373: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
374: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
375: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
376: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
377: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
378: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
379: , p_return_status OUT NOCOPY VARCHAR2)

Line 376: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE

372: (p_certification_id IN ota_certifications_b.certification_id%TYPE
373: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
374: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
375: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
376: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
377: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
378: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
379: , p_return_status OUT NOCOPY VARCHAR2)
380: IS

Line 377: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE

373: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
374: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
375: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
376: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
377: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
378: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
379: , p_return_status OUT NOCOPY VARCHAR2)
380: IS
381: --

Line 378: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE

374: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
375: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
376: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
377: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
378: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
379: , p_return_status OUT NOCOPY VARCHAR2)
380: IS
381: --
382:

Line 392: FROM ota_certifications_b c

388: c.renewal_duration,
389: c.validity_duration,
390: c.validity_start_type,
391: c.renewable_flag
392: FROM ota_certifications_b c
393: WHERE certification_id = p_certification_id;
394:
395: l_proc VARCHAR2(72) := g_package|| 'chk_should_warn';
396:

Line 397: l_old_init_compl_date ota_certifications_b.initial_completion_date%TYPE;

393: WHERE certification_id = p_certification_id;
394:
395: l_proc VARCHAR2(72) := g_package|| 'chk_should_warn';
396:
397: l_old_init_compl_date ota_certifications_b.initial_completion_date%TYPE;
398: l_old_init_compl_duration ota_certifications_b.initial_completion_duration%TYPE;
399: l_old_renew_duration ota_certifications_b.renewal_duration%TYPE;
400: l_old_valid_duration ota_certifications_b.validity_duration%TYPE;
401: l_old_start_type ota_certifications_b.validity_start_type%TYPE;

Line 398: l_old_init_compl_duration ota_certifications_b.initial_completion_duration%TYPE;

394:
395: l_proc VARCHAR2(72) := g_package|| 'chk_should_warn';
396:
397: l_old_init_compl_date ota_certifications_b.initial_completion_date%TYPE;
398: l_old_init_compl_duration ota_certifications_b.initial_completion_duration%TYPE;
399: l_old_renew_duration ota_certifications_b.renewal_duration%TYPE;
400: l_old_valid_duration ota_certifications_b.validity_duration%TYPE;
401: l_old_start_type ota_certifications_b.validity_start_type%TYPE;
402: l_old_renew_flag ota_certifications_b.renewable_flag%TYPE;

Line 399: l_old_renew_duration ota_certifications_b.renewal_duration%TYPE;

395: l_proc VARCHAR2(72) := g_package|| 'chk_should_warn';
396:
397: l_old_init_compl_date ota_certifications_b.initial_completion_date%TYPE;
398: l_old_init_compl_duration ota_certifications_b.initial_completion_duration%TYPE;
399: l_old_renew_duration ota_certifications_b.renewal_duration%TYPE;
400: l_old_valid_duration ota_certifications_b.validity_duration%TYPE;
401: l_old_start_type ota_certifications_b.validity_start_type%TYPE;
402: l_old_renew_flag ota_certifications_b.renewable_flag%TYPE;
403:

Line 400: l_old_valid_duration ota_certifications_b.validity_duration%TYPE;

396:
397: l_old_init_compl_date ota_certifications_b.initial_completion_date%TYPE;
398: l_old_init_compl_duration ota_certifications_b.initial_completion_duration%TYPE;
399: l_old_renew_duration ota_certifications_b.renewal_duration%TYPE;
400: l_old_valid_duration ota_certifications_b.validity_duration%TYPE;
401: l_old_start_type ota_certifications_b.validity_start_type%TYPE;
402: l_old_renew_flag ota_certifications_b.renewable_flag%TYPE;
403:
404: l_init_compl_date_changed BOOLEAN;

Line 401: l_old_start_type ota_certifications_b.validity_start_type%TYPE;

397: l_old_init_compl_date ota_certifications_b.initial_completion_date%TYPE;
398: l_old_init_compl_duration ota_certifications_b.initial_completion_duration%TYPE;
399: l_old_renew_duration ota_certifications_b.renewal_duration%TYPE;
400: l_old_valid_duration ota_certifications_b.validity_duration%TYPE;
401: l_old_start_type ota_certifications_b.validity_start_type%TYPE;
402: l_old_renew_flag ota_certifications_b.renewable_flag%TYPE;
403:
404: l_init_compl_date_changed BOOLEAN;
405: l_init_compl_dur_changed BOOLEAN;

Line 402: l_old_renew_flag ota_certifications_b.renewable_flag%TYPE;

398: l_old_init_compl_duration ota_certifications_b.initial_completion_duration%TYPE;
399: l_old_renew_duration ota_certifications_b.renewal_duration%TYPE;
400: l_old_valid_duration ota_certifications_b.validity_duration%TYPE;
401: l_old_start_type ota_certifications_b.validity_start_type%TYPE;
402: l_old_renew_flag ota_certifications_b.renewable_flag%TYPE;
403:
404: l_init_compl_date_changed BOOLEAN;
405: l_init_compl_dur_changed BOOLEAN;
406: l_renew_dur_changed BOOLEAN;

Line 460: (p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE

456: -- ----------------------------------------------------------------------------
457: -- |---------------------------< chk_renewable_cert >-------------------------|
458: -- ----------------------------------------------------------------------------
459: PROCEDURE chk_renewable_cert
460: (p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
461: ,p_validity_duration IN ota_certifications_b.validity_duration%TYPE
462: ,p_certification_id IN ota_certifications_b.certification_id%type
463: ) IS
464: --

Line 461: ,p_validity_duration IN ota_certifications_b.validity_duration%TYPE

457: -- |---------------------------< chk_renewable_cert >-------------------------|
458: -- ----------------------------------------------------------------------------
459: PROCEDURE chk_renewable_cert
460: (p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
461: ,p_validity_duration IN ota_certifications_b.validity_duration%TYPE
462: ,p_certification_id IN ota_certifications_b.certification_id%type
463: ) IS
464: --
465: l_proc VARCHAR2(72) := g_package|| 'chk_renewable_cert';

Line 462: ,p_certification_id IN ota_certifications_b.certification_id%type

458: -- ----------------------------------------------------------------------------
459: PROCEDURE chk_renewable_cert
460: (p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
461: ,p_validity_duration IN ota_certifications_b.validity_duration%TYPE
462: ,p_certification_id IN ota_certifications_b.certification_id%type
463: ) IS
464: --
465: l_proc VARCHAR2(72) := g_package|| 'chk_renewable_cert';
466: --

Line 484: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.VALIDITY_DURATION') THEN

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

Line 499: (p_validity_duration IN ota_certifications_b.validity_duration%TYPE

495: -- ----------------------------------------------------------------------------
496: -- |---------------------------< chk_renew_duration >-------------------------|
497: -- ----------------------------------------------------------------------------
498: PROCEDURE chk_renew_duration
499: (p_validity_duration IN ota_certifications_b.validity_duration%TYPE
500: ,p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
501: ) IS
502: --
503: l_proc VARCHAR2(72) := g_package|| 'chk_renew_duration';

Line 500: ,p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE

496: -- |---------------------------< chk_renew_duration >-------------------------|
497: -- ----------------------------------------------------------------------------
498: PROCEDURE chk_renew_duration
499: (p_validity_duration IN ota_certifications_b.validity_duration%TYPE
500: ,p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
501: ) IS
502: --
503: l_proc VARCHAR2(72) := g_package|| 'chk_renew_duration';
504: --

Line 523: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.VALIDITY_DURATION') THEN

519:
520: WHEN app_exception.application_exception THEN
521:
522: IF hr_multi_message.exception_add
523: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.VALIDITY_DURATION') THEN
524:
525: hr_utility.set_location(' Leaving:'||l_proc, 92);
526: RAISE;
527:

Line 539: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%TYPE

535: -- |---------------------------< chk_init_completion >-------------------------|
536: -- ----------------------------------------------------------------------------
537: PROCEDURE chk_init_completion
538: (p_effective_date in date
539: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%TYPE
540: ,p_init_compl_duration IN ota_certifications_b.initial_completion_duration%TYPE
541: ,p_start_date_active IN ota_certifications_b.start_date_active%type
542: ,p_end_date_active IN ota_certifications_b.end_date_active%type
543: ) IS

Line 540: ,p_init_compl_duration IN ota_certifications_b.initial_completion_duration%TYPE

536: -- ----------------------------------------------------------------------------
537: PROCEDURE chk_init_completion
538: (p_effective_date in date
539: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%TYPE
540: ,p_init_compl_duration IN ota_certifications_b.initial_completion_duration%TYPE
541: ,p_start_date_active IN ota_certifications_b.start_date_active%type
542: ,p_end_date_active IN ota_certifications_b.end_date_active%type
543: ) IS
544: --

Line 541: ,p_start_date_active IN ota_certifications_b.start_date_active%type

537: PROCEDURE chk_init_completion
538: (p_effective_date in date
539: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%TYPE
540: ,p_init_compl_duration IN ota_certifications_b.initial_completion_duration%TYPE
541: ,p_start_date_active IN ota_certifications_b.start_date_active%type
542: ,p_end_date_active IN ota_certifications_b.end_date_active%type
543: ) IS
544: --
545: l_proc VARCHAR2(72) := g_package|| 'chk_init_completion';

Line 542: ,p_end_date_active IN ota_certifications_b.end_date_active%type

538: (p_effective_date in date
539: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%TYPE
540: ,p_init_compl_duration IN ota_certifications_b.initial_completion_duration%TYPE
541: ,p_start_date_active IN ota_certifications_b.start_date_active%type
542: ,p_end_date_active IN ota_certifications_b.end_date_active%type
543: ) IS
544: --
545: l_proc VARCHAR2(72) := g_package|| 'chk_init_completion';
546: l_current_year number;

Line 604: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.initial_completion_duration'

600:
601: WHEN app_exception.application_exception THEN
602:
603: IF hr_multi_message.exception_add
604: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.initial_completion_duration'
605: ,p_associated_column2 => 'OTA_CERTIFICATIONS_B.initial_completion_date') THEN
606:
607: hr_utility.set_location(' Leaving:'||l_proc, 92);
608: RAISE;

Line 605: ,p_associated_column2 => 'OTA_CERTIFICATIONS_B.initial_completion_date') THEN

601: WHEN app_exception.application_exception THEN
602:
603: IF hr_multi_message.exception_add
604: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.initial_completion_duration'
605: ,p_associated_column2 => 'OTA_CERTIFICATIONS_B.initial_completion_date') THEN
606:
607: hr_utility.set_location(' Leaving:'||l_proc, 92);
608: RAISE;
609:

Line 620: (p_start_date IN ota_certifications_b.start_date_active%TYPE

616: -- ----------------------------------------------------------------------------
617: -- |---------------------------< chk_date_range >-------------------------|
618: -- ----------------------------------------------------------------------------
619: PROCEDURE chk_date_range
620: (p_start_date IN ota_certifications_b.start_date_active%TYPE
621: ,p_end_date IN ota_certifications_b.end_date_active%type
622: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%type
623: ) IS
624: --

Line 621: ,p_end_date IN ota_certifications_b.end_date_active%type

617: -- |---------------------------< chk_date_range >-------------------------|
618: -- ----------------------------------------------------------------------------
619: PROCEDURE chk_date_range
620: (p_start_date IN ota_certifications_b.start_date_active%TYPE
621: ,p_end_date IN ota_certifications_b.end_date_active%type
622: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%type
623: ) IS
624: --
625: l_proc VARCHAR2(72) := g_package|| 'chk_date_range';

Line 622: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%type

618: -- ----------------------------------------------------------------------------
619: PROCEDURE chk_date_range
620: (p_start_date IN ota_certifications_b.start_date_active%TYPE
621: ,p_end_date IN ota_certifications_b.end_date_active%type
622: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%type
623: ) IS
624: --
625: l_proc VARCHAR2(72) := g_package|| 'chk_date_range';
626: --

Line 652: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.start_date_active') THEN

648:
649: WHEN app_exception.application_exception THEN
650:
651: IF hr_multi_message.exception_add
652: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.start_date_active') THEN
653:
654: hr_utility.set_location(' Leaving:'||l_proc, 92);
655: RAISE;
656:

Line 667: ,p_notify_days IN ota_certifications_b.notify_days_before_expire%type

663: -- |---------------------------< chk_notify_days >-------------------------|
664: -- ----------------------------------------------------------------------------
665: PROCEDURE chk_notify_days
666: (p_effective_date IN date
667: ,p_notify_days IN ota_certifications_b.notify_days_before_expire%type
668: ,p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%type
669: ,p_initial_completion_date IN ota_certifications_b.initial_completion_date%type
670: ,p_validity_duration IN ota_certifications_b.validity_duration%type
671: ,p_certification_id IN ota_certifications_b.certification_id%type

Line 668: ,p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%type

664: -- ----------------------------------------------------------------------------
665: PROCEDURE chk_notify_days
666: (p_effective_date IN date
667: ,p_notify_days IN ota_certifications_b.notify_days_before_expire%type
668: ,p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%type
669: ,p_initial_completion_date IN ota_certifications_b.initial_completion_date%type
670: ,p_validity_duration IN ota_certifications_b.validity_duration%type
671: ,p_certification_id IN ota_certifications_b.certification_id%type
672: ) IS

Line 669: ,p_initial_completion_date IN ota_certifications_b.initial_completion_date%type

665: PROCEDURE chk_notify_days
666: (p_effective_date IN date
667: ,p_notify_days IN ota_certifications_b.notify_days_before_expire%type
668: ,p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%type
669: ,p_initial_completion_date IN ota_certifications_b.initial_completion_date%type
670: ,p_validity_duration IN ota_certifications_b.validity_duration%type
671: ,p_certification_id IN ota_certifications_b.certification_id%type
672: ) IS
673: --

Line 670: ,p_validity_duration IN ota_certifications_b.validity_duration%type

666: (p_effective_date IN date
667: ,p_notify_days IN ota_certifications_b.notify_days_before_expire%type
668: ,p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%type
669: ,p_initial_completion_date IN ota_certifications_b.initial_completion_date%type
670: ,p_validity_duration IN ota_certifications_b.validity_duration%type
671: ,p_certification_id IN ota_certifications_b.certification_id%type
672: ) IS
673: --
674: l_proc VARCHAR2(72) := g_package|| 'chk_notify_days';

Line 671: ,p_certification_id IN ota_certifications_b.certification_id%type

667: ,p_notify_days IN ota_certifications_b.notify_days_before_expire%type
668: ,p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%type
669: ,p_initial_completion_date IN ota_certifications_b.initial_completion_date%type
670: ,p_validity_duration IN ota_certifications_b.validity_duration%type
671: ,p_certification_id IN ota_certifications_b.certification_id%type
672: ) IS
673: --
674: l_proc VARCHAR2(72) := g_package|| 'chk_notify_days';
675: l_max_value number;

Line 722: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.notify_days_before_expire') THEN

718:
719: WHEN app_exception.application_exception THEN
720:
721: IF hr_multi_message.exception_add
722: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.notify_days_before_expire') THEN
723:
724: hr_utility.set_location(' Leaving:'||l_proc, 92);
725: RAISE;
726:

Line 738: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%type

734: -- |---------------------------< chk_init_compl_date >-------------------------|
735: -- ----------------------------------------------------------------------------
736: PROCEDURE chk_init_compl_date
737: (p_effective_date IN date
738: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%type
739: ,p_certification_id IN ota_certifications_b.certification_id%type
740: ) IS
741: --
742: l_proc VARCHAR2(72) := g_package|| 'chk_init_compl_date';

Line 739: ,p_certification_id IN ota_certifications_b.certification_id%type

735: -- ----------------------------------------------------------------------------
736: PROCEDURE chk_init_compl_date
737: (p_effective_date IN date
738: ,p_init_compl_date IN ota_certifications_b.initial_completion_date%type
739: ,p_certification_id IN ota_certifications_b.certification_id%type
740: ) IS
741: --
742: l_proc VARCHAR2(72) := g_package|| 'chk_init_compl_date';
743:

Line 764: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.initial_completion_date') THEN

760:
761: WHEN app_exception.application_exception THEN
762:
763: IF hr_multi_message.exception_add
764: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.initial_completion_date') THEN
765:
766: hr_utility.set_location(' Leaving:'||l_proc, 92);
767: RAISE;
768:

Line 779: (p_validity_duration IN ota_certifications_b.validity_duration%type

775: -- ----------------------------------------------------------------------------
776: -- |---------------------------< chk_validity_duration >-------------------------|
777: -- ----------------------------------------------------------------------------
778: PROCEDURE chk_validity_duration
779: (p_validity_duration IN ota_certifications_b.validity_duration%type
780: ) IS
781: --
782: l_proc VARCHAR2(72) := g_package|| 'chk_validity_duration';
783: --

Line 802: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.validity_duration') THEN

798:
799: WHEN app_exception.application_exception THEN
800:
801: IF hr_multi_message.exception_add
802: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.validity_duration') THEN
803:
804: hr_utility.set_location(' Leaving:'||l_proc, 92);
805: RAISE;
806:

Line 816: (p_init_compl_date IN ota_certifications_b.initial_completion_date%type

812: -- ----------------------------------------------------------------------------
813: -- |---------------------------< chk_date_based_cert >-------------------------|
814: -- ----------------------------------------------------------------------------
815: PROCEDURE chk_date_based_cert
816: (p_init_compl_date IN ota_certifications_b.initial_completion_date%type
817: ,p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
818: ,p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
819: ,p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
820: ) IS

Line 817: ,p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE

813: -- |---------------------------< chk_date_based_cert >-------------------------|
814: -- ----------------------------------------------------------------------------
815: PROCEDURE chk_date_based_cert
816: (p_init_compl_date IN ota_certifications_b.initial_completion_date%type
817: ,p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
818: ,p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
819: ,p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
820: ) IS
821: --

Line 818: ,p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE

814: -- ----------------------------------------------------------------------------
815: PROCEDURE chk_date_based_cert
816: (p_init_compl_date IN ota_certifications_b.initial_completion_date%type
817: ,p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
818: ,p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
819: ,p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
820: ) IS
821: --
822: l_proc VARCHAR2(72) := g_package|| 'chk_date_based_cert';

Line 819: ,p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE

815: PROCEDURE chk_date_based_cert
816: (p_init_compl_date IN ota_certifications_b.initial_completion_date%type
817: ,p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
818: ,p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
819: ,p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
820: ) IS
821: --
822: l_proc VARCHAR2(72) := g_package|| 'chk_date_based_cert';
823: --

Line 849: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.validity_start_type') THEN

845:
846: WHEN app_exception.application_exception THEN
847:
848: IF hr_multi_message.exception_add
849: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.validity_start_type') THEN
850:
851: hr_utility.set_location(' Leaving:'||l_proc, 92);
852: RAISE;
853:

Line 946: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.START_DATE_ACTIVE'

942:
943: Exception
944: when app_exception.application_exception then
945: IF hr_multi_message.exception_add
946: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.START_DATE_ACTIVE'
947: ,p_associated_column2 => 'OTA_CERTIFICATIONS_B.END_DATE_ACTIVE'
948: ) THEN
949: raise;
950: END IF;

Line 947: ,p_associated_column2 => 'OTA_CERTIFICATIONS_B.END_DATE_ACTIVE'

943: Exception
944: when app_exception.application_exception then
945: IF hr_multi_message.exception_add
946: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.START_DATE_ACTIVE'
947: ,p_associated_column2 => 'OTA_CERTIFICATIONS_B.END_DATE_ACTIVE'
948: ) THEN
949: raise;
950: END IF;
951:

Line 960: (p_start_date IN ota_certifications_b.start_date_active%TYPE

956: -- ----------------------------------------------------------------------------
957: -- |---------------------------< chk_cmb_dates >-------------------------|
958: -- ----------------------------------------------------------------------------
959: PROCEDURE chk_cmb_dates
960: (p_start_date IN ota_certifications_b.start_date_active%TYPE
961: ,p_end_date IN ota_certifications_b.end_date_active%type
962: ,p_cert_id IN ota_certifications_b.certification_id%type
963: ) IS
964: --

Line 961: ,p_end_date IN ota_certifications_b.end_date_active%type

957: -- |---------------------------< chk_cmb_dates >-------------------------|
958: -- ----------------------------------------------------------------------------
959: PROCEDURE chk_cmb_dates
960: (p_start_date IN ota_certifications_b.start_date_active%TYPE
961: ,p_end_date IN ota_certifications_b.end_date_active%type
962: ,p_cert_id IN ota_certifications_b.certification_id%type
963: ) IS
964: --
965: CURSOR csr_has_cmb is

Line 962: ,p_cert_id IN ota_certifications_b.certification_id%type

958: -- ----------------------------------------------------------------------------
959: PROCEDURE chk_cmb_dates
960: (p_start_date IN ota_certifications_b.start_date_active%TYPE
961: ,p_end_date IN ota_certifications_b.end_date_active%type
962: ,p_cert_id IN ota_certifications_b.certification_id%type
963: ) IS
964: --
965: CURSOR csr_has_cmb is
966: SELECT 'Y'

Line 1027: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.START_DATE_ACTIVE'

1023:
1024: Exception
1025: when app_exception.application_exception then
1026: IF hr_multi_message.exception_add
1027: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.START_DATE_ACTIVE'
1028: ,p_associated_column2 => 'OTA_CERTIFICATIONS_B.END_DATE_ACTIVE'
1029: ) THEN
1030: raise;
1031: END IF;

Line 1028: ,p_associated_column2 => 'OTA_CERTIFICATIONS_B.END_DATE_ACTIVE'

1024: Exception
1025: when app_exception.application_exception then
1026: IF hr_multi_message.exception_add
1027: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.START_DATE_ACTIVE'
1028: ,p_associated_column2 => 'OTA_CERTIFICATIONS_B.END_DATE_ACTIVE'
1029: ) THEN
1030: raise;
1031: END IF;
1032:

Line 1038: (p_certification_id IN ota_certifications_b.certification_id%TYPE

1034:
1035: END chk_cmb_dates;
1036:
1037: PROCEDURE chk_upd_exis_subscr
1038: (p_certification_id IN ota_certifications_b.certification_id%TYPE
1039: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
1040: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
1041: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
1042: , p_notify_days IN ota_certifications_b.notify_days_before_expire%type)

Line 1039: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE

1035: END chk_cmb_dates;
1036:
1037: PROCEDURE chk_upd_exis_subscr
1038: (p_certification_id IN ota_certifications_b.certification_id%TYPE
1039: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
1040: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
1041: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
1042: , p_notify_days IN ota_certifications_b.notify_days_before_expire%type)
1043: IS

Line 1040: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE

1036:
1037: PROCEDURE chk_upd_exis_subscr
1038: (p_certification_id IN ota_certifications_b.certification_id%TYPE
1039: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
1040: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
1041: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
1042: , p_notify_days IN ota_certifications_b.notify_days_before_expire%type)
1043: IS
1044: --

Line 1041: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE

1037: PROCEDURE chk_upd_exis_subscr
1038: (p_certification_id IN ota_certifications_b.certification_id%TYPE
1039: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
1040: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
1041: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
1042: , p_notify_days IN ota_certifications_b.notify_days_before_expire%type)
1043: IS
1044: --
1045:

Line 1042: , p_notify_days IN ota_certifications_b.notify_days_before_expire%type)

1038: (p_certification_id IN ota_certifications_b.certification_id%TYPE
1039: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
1040: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
1041: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
1042: , p_notify_days IN ota_certifications_b.notify_days_before_expire%type)
1043: IS
1044: --
1045:
1046: CURSOR csr_exis_subscr