459: ----------------------------------------------------------------------------
460:
461: FUNCTION CHK_FOR_SECURE_EVT (
462: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
463: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)
464: RETURN VARCHAR2;
465: PRAGMA RESTRICT_REFERENCES(CHK_FOR_SECURE_EVT, WNDS, WNPS);
466: --|--------------------------------------------------------------------------|
467: --|--< CHK_DELEGATE_OK_FOR_EVENT>-----------------------------------------|
489: ----------------------------------------------------------------------------
490:
491: FUNCTION CHK_DELEGATE_OK_FOR_EVENT (
492: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
493: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
494: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE
495: default null)
496: RETURN VARCHAR2;
497: PRAGMA RESTRICT_REFERENCES(CHK_DELEGATE_OK_FOR_EVENT, WNDS, WNPS);
490:
491: FUNCTION CHK_DELEGATE_OK_FOR_EVENT (
492: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
493: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
494: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE
495: default null)
496: RETURN VARCHAR2;
497: PRAGMA RESTRICT_REFERENCES(CHK_DELEGATE_OK_FOR_EVENT, WNDS, WNPS);
498:
656: --
657: ----------------------------------------------------------------------------
658:
659: FUNCTION CHK_FOR_RESTRICTED_EVT (
660: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)
661: RETURN VARCHAR2;
662: PRAGMA RESTRICT_REFERENCES(CHK_FOR_RESTRICTED_EVT, WNDS, WNPS);
663:
664: --|--------------------------------------------------------------------------|
723: ----------------------------------------------------------------------------
724:
725:
726: FUNCTION CHK_VALID_EVENT(
727: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
728: )
729: RETURN VARCHAR2;
730:
731: