APPS.OTA_LEARNER_ENROLL_SS dependencies on FND_USER

Line 4: Type resp_id_tab is table of fnd_user_resp_groups.responsibility_id%type INDEX BY BINARY_INTEGER;

1: PACKAGE OTA_LEARNER_ENROLL_SS AUTHID CURRENT_USER as
2: /* $Header: otlnrenr.pkh 120.12 2010/11/12 13:47:12 shwnayak noship $ */
3:
4: Type resp_id_tab is table of fnd_user_resp_groups.responsibility_id%type INDEX BY BINARY_INTEGER;
5: Type sec_id_tab is table of fnd_user_resp_groups.security_group_id%type INDEX BY BINARY_INTEGER;
6:
7:
8: --

Line 5: Type sec_id_tab is table of fnd_user_resp_groups.security_group_id%type INDEX BY BINARY_INTEGER;

1: PACKAGE OTA_LEARNER_ENROLL_SS AUTHID CURRENT_USER as
2: /* $Header: otlnrenr.pkh 120.12 2010/11/12 13:47:12 shwnayak noship $ */
3:
4: Type resp_id_tab is table of fnd_user_resp_groups.responsibility_id%type INDEX BY BINARY_INTEGER;
5: Type sec_id_tab is table of fnd_user_resp_groups.security_group_id%type INDEX BY BINARY_INTEGER;
6:
7:
8: --
9: -- CSR_BOOKING_STATUS_ID retrieves a single booking_status_type_id for

Line 801: p_supervisor_username OUT NOCOPY fnd_user.user_name%TYPE,

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,
804: p_current_person_name OUT NOCOPY VARCHAR2,
805: p_current_username OUT NOCOPY VARCHAR2,