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 954: FROM per_all_people_f per,

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

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

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

Line 976: FROM per_all_people_f per,

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

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

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

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

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

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

2421: PROCEDURE get_wf_attr_for_cancel_ntf
2422: (p_event_id IN ota_events.event_id%TYPE,
2423: p_person_id IN number,
2424: p_supervisor_username OUT NOCOPY fnd_user.user_name%TYPE,
2425: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,
2426: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,
2427: p_current_person_name OUT NOCOPY VARCHAR2,
2428: p_current_username OUT NOCOPY VARCHAR2,
2429: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,

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

2422: (p_event_id IN ota_events.event_id%TYPE,
2423: p_person_id IN number,
2424: p_supervisor_username OUT NOCOPY fnd_user.user_name%TYPE,
2425: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,
2426: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,
2427: p_current_person_name OUT NOCOPY VARCHAR2,
2428: p_current_username OUT NOCOPY VARCHAR2,
2429: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
2430: p_creator_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,

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

2425: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,
2426: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,
2427: p_current_person_name OUT NOCOPY VARCHAR2,
2428: p_current_username OUT NOCOPY VARCHAR2,
2429: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
2430: p_creator_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
2431: x_return_status OUT NOCOPY VARCHAR2)
2432: IS
2433:

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

2426: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,
2427: p_current_person_name OUT NOCOPY VARCHAR2,
2428: p_current_username OUT NOCOPY VARCHAR2,
2429: p_person_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
2430: p_creator_displayname OUT NOCOPY per_all_people_f.full_name%TYPE,
2431: x_return_status OUT NOCOPY VARCHAR2)
2432: IS
2433:
2434: l_proc VARCHAR2(72) := g_package || 'get_wf_attr_for_cancel_ntf';

Line 2452: FROM per_all_people_f p

2448: --
2449: --Bug 3841658
2450: CURSOR display_name_csr (l_display_person_id IN NUMBER) IS
2451: SELECT full_name
2452: FROM per_all_people_f p
2453: WHERE person_id = l_display_person_id
2454: and trunc(SYSDATE) between effective_start_date and effective_end_date;
2455: --
2456:

Line 2460: per_all_people_f per

2456:
2457: CURSOR csr_supervisor_id IS
2458: SELECT a.supervisor_id, per.full_name
2459: FROM per_all_assignments_f a,
2460: per_all_people_f per
2461: WHERE a.person_id = p_person_id
2462: AND per.person_id = a.supervisor_id
2463: AND a.primary_flag = 'Y'
2464: AND trunc(sysdate)