APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on PER_PEOPLE_F

Line 967: l_delegate_id PER_PEOPLE_F.person_id%TYPE;

963: ,p_effective_date in varchar2) IS
964:
965: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
966: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
967: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
968: l_eventid ota_events.event_id%TYPE;
969: l_object_version_number number;
970: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
971: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

Line 1914: l_delegate_id PER_PEOPLE_F.person_id%TYPE;

1910: l_eventid ota_events.event_id%TYPE;
1911: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1912: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1913: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1914: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1915: l_object_version_number number;
1916: l_date_booking_placed date;
1917: l_current_date date;
1918: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

Line 2949: l_forward_to_person_id per_people_f.person_id%type;

2945: l_synchronous_flag ota_category_usages.synchronous_flag%type;
2946: l_online_flag ota_category_usages.online_flag%type;
2947: l_dm_status varchar2(20);
2948: l_approval_req_flag varchar2(100);
2949: l_forward_to_person_id per_people_f.person_id%type;
2950:
2951: BEGIN
2952:
2953: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

Line 3084: l_forward_to_person_id per_people_f.person_id%type;

3080: actid IN NUMBER,
3081: funcmode IN VARCHAR2,
3082: resultout OUT nocopy VARCHAR2 ) IS
3083:
3084: l_forward_to_person_id per_people_f.person_id%type;
3085: BEGIN
3086:
3087: IF (funcmode='RUN') THEN
3088: wf_engine.setItemAttrText (itemtype => itemtype