APPS.OTA_LEARNER_ENROLL_SS dependencies on OTA_EVENTS

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

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

Line 553: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

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

Line 554: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE

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

Line 616: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE,

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

Line 793: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

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

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

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