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 1923: l_delegate_id PER_PEOPLE_F.person_id%TYPE;

1919: l_eventid ota_events.event_id%TYPE;
1920: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1921: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1922: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1923: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1924: l_object_version_number number;
1925: l_date_booking_placed date;
1926: l_current_date date;
1927: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

Line 2273: l_forward_to_person_id per_people_f.person_id%type;

2269: l_synchronous_flag ota_category_usages.synchronous_flag%type;
2270: l_online_flag ota_category_usages.online_flag%type;
2271: l_dm_status varchar2(20);
2272: l_approval_req_flag varchar2(100);
2273: l_forward_to_person_id per_people_f.person_id%type;
2274:
2275: BEGIN
2276:
2277: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

Line 2408: l_forward_to_person_id per_people_f.person_id%type;

2404: actid IN NUMBER,
2405: funcmode IN VARCHAR2,
2406: resultout OUT nocopy VARCHAR2 ) IS
2407:
2408: l_forward_to_person_id per_people_f.person_id%type;
2409: BEGIN
2410:
2411: IF (funcmode='RUN') THEN
2412: wf_engine.setItemAttrText (itemtype => itemtype