DBA Data[Home] [Help]

APPS.OTA_EL_ENROLL_SS dependencies on OTA_EVENTS

Line 463: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)

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

Line 493: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

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

Line 494: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE

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:

Line 660: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)

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

Line 727: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

723: ----------------------------------------------------------------------------
724:
725:
726: FUNCTION CHK_VALID_EVENT(
727: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
728: )
729: RETURN VARCHAR2;
730:
731: