APPS.PQP_RIW_ENROLL_WRAPPER dependencies on OTA_DELEGATE_BOOKINGS

Line 124: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;

120:
121: -- p_status_change_comments varchar2(30) default hr_api.g_varchar2;
122: -- p_update_finance_line varchar2(30) default hr_api.g_varchar2;
123: l_tfl_object_version_number number;
124: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
125: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
126: c_delegate_assignment_id number default null;
127: c_sponsor_assignment_id number default null;
128:

Line 125: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

121: -- p_status_change_comments varchar2(30) default hr_api.g_varchar2;
122: -- p_update_finance_line varchar2(30) default hr_api.g_varchar2;
123: l_tfl_object_version_number number;
124: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
125: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
126: c_delegate_assignment_id number default null;
127: c_sponsor_assignment_id number default null;
128:
129: --$ Get upload mode - "Create and Update" (C) or "Update Only" (U)

Line 146: FROM ota_delegate_bookings b

142:
143: CURSOR booking_csr
144: IS
145: SELECT b.date_booking_placed
146: FROM ota_delegate_bookings b
147: WHERE b.booking_id = p_booking_id;
148:
149:
150: CURSOR deleg_ass_id

Line 340: from ota_delegate_bookings where

336: --p_object_version_number := 1;
337: hr_utility.trace('SRK in wrapper_proc before update p_object_version_number '|| p_object_version_number);
338:
339: select object_version_number into l_object_version_number
340: from ota_delegate_bookings where
341: booking_id = l_booking_id;
342:
343: update_delegate_booking
344: (p_effective_date => p_effective_date

Line 877: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;

873: l_object_version_number number;
874: l_tfl_object_version_number number;
875: l_finance_line_id number;
876: --
877: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
878: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
879:
880:
881:

Line 878: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

874: l_tfl_object_version_number number;
875: l_finance_line_id number;
876: --
877: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
878: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
879:
880:
881:
882: CURSOR booking_csr

Line 885: FROM ota_delegate_bookings b

881:
882: CURSOR booking_csr
883: IS
884: SELECT b.date_booking_placed
885: FROM ota_delegate_bookings b
886: WHERE b.booking_id = p_booking_id;
887: --
888:
889: -- Other variables