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 44: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

40: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
41: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
42: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
43: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
44: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
45: -- Added for External LearnerSupport
46: ,p_delegate_contact_id IN NUMBER
47: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type
48: ,p_message_name out nocopy varchar2

Line 955: FROM per_all_people_f per,

951: assg.organization_id,
952: pcak.cost_allocation_keyflex_id,
953: pcak.concatenated_segments,
954: pcaf.proportion
955: FROM per_all_people_f per,
956: per_all_assignments_f assg,
957: pay_cost_allocations_f pcaf,
958: pay_cost_allocation_keyflex pcak
959: WHERE per.person_id = p_person_id

Line 973: CURSOR get_assignment(p_delegate_id per_all_people_f.person_id%TYPE) IS

969: AND trunc(sysdate) between nvl(per.effective_start_date,trunc(sysdate))
970: and nvl(per.effective_end_date,trunc(sysdate+1));
971:
972:
973: CURSOR get_assignment(p_delegate_id per_all_people_f.person_id%TYPE) IS
974: SELECT assg.assignment_id,
975: assg.business_group_id,
976: assg.organization_id
977: FROM per_all_people_f per,

Line 977: FROM per_all_people_f per,

973: CURSOR get_assignment(p_delegate_id per_all_people_f.person_id%TYPE) IS
974: SELECT assg.assignment_id,
975: assg.business_group_id,
976: assg.organization_id
977: FROM per_all_people_f per,
978: per_all_assignments_f assg
979: WHERE per.person_id = p_delegate_id
980: AND per.person_id = assg.person_id
981: AND trunc(sysdate) between nvl(assg.effective_start_date,trunc(sysdate))

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

1074: --
1075: -- {End Of Comments}
1076: -- ----------------------------------------------------------------------------
1077:
1078: FUNCTION Get_Person_To_Enroll_Details (p_person_id per_all_people_f.PERSON_ID%TYPE)
1079: RETURN csr_person_to_enroll_details%ROWTYPE
1080:
1081: IS
1082: --

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

1205: --
1206: -- {End Of Comments}
1207: -- ----------------------------------------------------------------------------
1208:
1209: PROCEDURE Validate_enrollment(p_person_id per_all_people_f.PERSON_ID%TYPE,
1210: p_delegate_contact_id IN NUMBER,
1211: p_event_id IN VARCHAR2,
1212: p_double_book out nocopy VARCHAR2 )
1213:

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

2429: PROCEDURE get_wf_attr_for_cancel_ntf
2430: (p_event_id IN ota_events.event_id%TYPE,
2431: p_person_id IN number,
2432: p_supervisor_username OUT NOCOPY fnd_user.user_name%TYPE,
2433: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,
2434: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,
2435: p_current_person_name OUT NOCOPY VARCHAR2,
2436: p_current_username OUT NOCOPY VARCHAR2,
2437: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,

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

2430: (p_event_id IN ota_events.event_id%TYPE,
2431: p_person_id IN number,
2432: p_supervisor_username OUT NOCOPY fnd_user.user_name%TYPE,
2433: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,
2434: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,
2435: p_current_person_name OUT NOCOPY VARCHAR2,
2436: p_current_username OUT NOCOPY VARCHAR2,
2437: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
2438: p_creator_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,

Line 2437: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,

2433: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,
2434: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,
2435: p_current_person_name OUT NOCOPY VARCHAR2,
2436: p_current_username OUT NOCOPY VARCHAR2,
2437: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
2438: p_creator_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
2439: x_return_status OUT NOCOPY VARCHAR2)
2440: IS
2441:

Line 2438: p_creator_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,

2434: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,
2435: p_current_person_name OUT NOCOPY VARCHAR2,
2436: p_current_username OUT NOCOPY VARCHAR2,
2437: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
2438: p_creator_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
2439: x_return_status OUT NOCOPY VARCHAR2)
2440: IS
2441:
2442: l_proc VARCHAR2(72) := g_package || 'get_wf_attr_for_cancel_ntf';

Line 2460: FROM per_all_people_f p

2456: --
2457: --Bug 3841658
2458: CURSOR display_name_csr (l_display_person_id IN NUMBER) IS
2459: SELECT full_name
2460: FROM per_all_people_f p
2461: WHERE person_id = l_display_person_id
2462: and trunc(SYSDATE) between effective_start_date and effective_end_date;
2463: --
2464:

Line 2468: per_all_people_f per

2464:
2465: CURSOR csr_supervisor_id IS
2466: SELECT a.supervisor_id, per.full_name
2467: FROM per_all_assignments_f a,
2468: per_all_people_f per
2469: WHERE a.person_id = p_person_id
2470: AND per.person_id = a.supervisor_id
2471: AND a.primary_flag = 'Y'
2472: AND trunc(sysdate)