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_INITIALIZATION_WF dependencies on PER_PEOPLE_F

Line 59: l_owner_name per_people_f.full_name%type;

55: l_order_number oe_order_headers.order_number%type;
56: l_header_id oe_order_headers.header_id%type;
57: l_process wf_activities.name%type := upper(p_process);
58: l_itemkey wf_items.item_key%type := to_char(p_line_id);
59: l_owner_name per_people_f.full_name%type;
60: l_event_title ota_events_tl.title%type; --MLS change _tl added
61: l_owner_id ota_events.owner_id%type;
62: l_email_address per_people_f.email_address%type;
63: l_full_name per_people_f.full_name%type;

Line 62: l_email_address per_people_f.email_address%type;

58: l_itemkey wf_items.item_key%type := to_char(p_line_id);
59: l_owner_name per_people_f.full_name%type;
60: l_event_title ota_events_tl.title%type; --MLS change _tl added
61: l_owner_id ota_events.owner_id%type;
62: l_email_address per_people_f.email_address%type;
63: l_full_name per_people_f.full_name%type;
64:
65:
66: CURSOR C_ORDER

Line 63: l_full_name per_people_f.full_name%type;

59: l_owner_name per_people_f.full_name%type;
60: l_event_title ota_events_tl.title%type; --MLS change _tl added
61: l_owner_id ota_events.owner_id%type;
62: l_email_address per_people_f.email_address%type;
63: l_full_name per_people_f.full_name%type;
64:
65:
66: CURSOR C_ORDER
67: IS

Line 695: l_person_id per_people_f.person_id%type;

691:
692: l_location_id ota_events.location_id %type;
693: l_event_type ota_events.event_type%type;
694:
695: l_person_id per_people_f.person_id%type;
696:
697: l_object_type varchar2(240);
698: l_location_name hr_locations_all_tl.location_code%type;
699: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

Line 1229: l_person_id per_people_f.person_id%type;

1225: and lpt.Language= USERENV('LANG')
1226: and lp.Learning_path_id = lpe.Learning_path_id
1227: and lpe.lp_enrollment_id = p_lp_enrollment_id;
1228:
1229: l_person_id per_people_f.person_id%type;
1230: l_LP_name ota_learning_paths_tl.name%type;
1231: l_start_date ota_learning_paths.start_date_active%type;
1232: l_process wf_activities.name%type := 'OTA_LP_JSP_PRC';
1233: l_item_key wf_items.item_key%type;

Line 1352: FROM per_people_f pp

1348: -- get full name
1349: CURSOR csr_person_name (crs_person_id number) IS
1350: SELECT
1351: pp.full_name
1352: FROM per_people_f pp
1353: WHERE pp.person_id = crs_person_id
1354: AND trunc(sysdate) BETWEEN pp.effective_start_date AND pp.effective_end_date;
1355: -- get supervisor name
1356: CURSOR csr_supervisor_id IS