eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LEARNER_ENROLL_SS dependencies on PER_ALL_PEOPLE_F

Line 102: FROM per_all_people_f pp

98: ,loc.address_line_1 work_line1
99: ,loc.town_or_city work_city
100: ,pph.PHONE_NUMBER work_telephone
101: ,pfax.PHONE_NUMBER work_fax
102: FROM per_all_people_f pp
103: ,per_all_assignments_f asg
104: ,per_all_people_f p2
105: ,per_all_assignments_f asg2
106: ,per_person_types ppt

Line 104: ,per_all_people_f p2

100: ,pph.PHONE_NUMBER work_telephone
101: ,pfax.PHONE_NUMBER work_fax
102: FROM per_all_people_f pp
103: ,per_all_assignments_f asg
104: ,per_all_people_f p2
105: ,per_all_assignments_f asg2
106: ,per_person_types ppt
107: ,per_person_type_usages_f ptu
108: -- ,per_addresses ad

Line 137: AND pph.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'

133: -- AND trunc(sysdate)BETWEEN ad.date_from AND nvl(ad.date_to, trunc(sysdate))
134: and asg.organization_id = org.organization_id
135: and org.location_id = loc.location_id (+)
136: AND pph.PARENT_ID(+) = pp.PERSON_ID
137: AND pph.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'
138: AND pph.PHONE_TYPE(+) = 'W1'
139: AND trunc(sysdate) BETWEEN NVL(PPH.DATE_FROM(+), SYSDATE) AND NVL(PPH.DATE_TO(+), SYSDATE)
140: AND pfax.PARENT_ID(+) = pp.PERSON_ID
141: AND pfax.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'

Line 141: AND pfax.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'

137: AND pph.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'
138: AND pph.PHONE_TYPE(+) = 'W1'
139: AND trunc(sysdate) BETWEEN NVL(PPH.DATE_FROM(+), SYSDATE) AND NVL(PPH.DATE_TO(+), SYSDATE)
140: AND pfax.PARENT_ID(+) = pp.PERSON_ID
141: AND pfax.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'
142: AND pfax.PHONE_TYPE(+) = 'WF'
143: AND trunc(sysdate) BETWEEN NVL(pfax.DATE_FROM(+), SYSDATE) AND NVL(pfax.DATE_TO(+), SYSDATE)
144: order by asg.primary_flag desc; --Bug#6872547
145: --

Line 213: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

209: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
210: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
211: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
212: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
213: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
214: ,p_delegate_contact_id IN NUMBER
215: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type
216: , p_message_name out nocopy varchar2
217: ,p_tdb_information_category in varchar2 default null

Line 384: FUNCTION Get_Person_To_Enroll_Details (p_person_id per_all_people_f.PERSON_ID%TYPE)

380: --
381: -- {End Of Comments}
382: -- ----------------------------------------------------------------------------
383:
384: FUNCTION Get_Person_To_Enroll_Details (p_person_id per_all_people_f.PERSON_ID%TYPE)
385: RETURN csr_person_to_enroll_details%ROWTYPE;
386:
387: --
388: -- ----------------------------------------------------------------------------

Line 449: PROCEDURE Validate_enrollment(p_person_id IN per_all_people_f.PERSON_ID%TYPE,

445: --
446: -- {End Of Comments}
447: -- ----------------------------------------------------------------------------
448:
449: PROCEDURE Validate_enrollment(p_person_id IN per_all_people_f.PERSON_ID%TYPE,
450: p_delegate_contact_id IN NUMBER,
451: p_event_id IN VARCHAR2,
452: p_double_book OUT nocopy VARCHAR2);
453:

Line 802: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,

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,
806: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,

Line 803: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,

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,
806: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
807: p_creator_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,

Line 806: p_person_displayname OUT NOCOPY per_all_people_f.full_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,
806: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
807: p_creator_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
808: x_return_status OUT NOCOPY VARCHAR2);
809:
810: --

Line 807: p_creator_displayname 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,
806: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
807: p_creator_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
808: x_return_status OUT NOCOPY VARCHAR2);
809:
810: --
811: -- ----------------------------------------------------------------------------