APPS.OTA_LEARNER_ENROLL_SS dependencies on OTA_EVENTS

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

518:
519: FUNCTION CHK_FOR_SECURE_EVT (
520: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
521: ,p_delegate_contact_id IN NUMBER
522: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)
523: RETURN VARCHAR2;
524: --PRAGMA RESTRICT_REFERENCES(CHK_FOR_SECURE_EVT, WNDS, WNPS);
525:
526:

Line 554: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

550: ----------------------------------------------------------------------------
551:
552: FUNCTION CHK_DELEGATE_OK_FOR_EVENT (
553: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
554: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
555: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE
556: default null)
557: RETURN VARCHAR2;
558: --Modified for bug#5032859

Line 555: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE

551:
552: FUNCTION CHK_DELEGATE_OK_FOR_EVENT (
553: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
554: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
555: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE
556: default null)
557: RETURN VARCHAR2;
558: --Modified for bug#5032859
559: --PRAGMA RESTRICT_REFERENCES(CHK_DELEGATE_OK_FOR_EVENT, WNDS, WNPS);

Line 617: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE,

613: --
614: ----------------------------------------------------------------------------
615:
616: FUNCTION CHK_FOR_RESTRICTED_EVT (
617: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE,
618: p_delegate_contact_id IN NUMBER)
619: RETURN VARCHAR2;
620: --PRAGMA RESTRICT_REFERENCES(CHK_FOR_RESTRICTED_EVT, WNDS, WNPS);
621:

Line 794: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

790: ----------------------------------------------------------------------------
791:
792:
793: FUNCTION CHK_VALID_EVENT(
794: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
795: )
796: RETURN VARCHAR2;
797:
798: PROCEDURE get_wf_attr_for_cancel_ntf

Line 799: (p_event_id IN ota_events.event_id%TYPE,

795: )
796: RETURN VARCHAR2;
797:
798: PROCEDURE get_wf_attr_for_cancel_ntf
799: (p_event_id IN ota_events.event_id%TYPE,
800: p_person_id IN number,
801: p_supervisor_username OUT NOCOPY fnd_user.user_name%TYPE,
802: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,
803: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,