The following lines contain the word 'select', 'insert', 'update' or 'delete':
Cursor C_Sel1 is select OTA_BATCH_RANGES_S.nextval from sys.dual;
insert into OTA_BATCH_RANGES
(RANGE_ID,
BATCH_SOURCE_CD, -- newly added
BATCH_ACTION_ID,
RANGE_STATUS_CD,
STARTING_PERSON_ACTION_ID,
ENDING_PERSON_ACTION_ID,
OBJECT_VERSION_NUMBER
)
values
(l_range_id,
p_batch_source_cd,
p_batch_action_id,
p_range_status_cd,
p_starting_person_action_id,
p_ending_person_action_id,
l_object_verion_number
);
Cursor C_Sel1 is select OTA_BULK_ENR_REQUESTS_S.nextval from sys.dual;
insert into OTA_BULK_ENR_REQUESTS
(BULK_ENR_REQUEST_ID,
REQUESTOR_ID,
OBJECT_TYPE,
BUSINESS_GROUP_ID,
CONC_PROGRAM_REQUEST_ID,
OBJECT_ID)
values
(l_bulk_enr_request_id,
p_requestor_id,
p_object_type,
p_business_group_id,
p_conc_program_request_id,
p_object_id
);
Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;
insert into ota_bulk_enr_req_members
(PERSON_ACTION_ID,
PERSON_ID,
BULK_ENR_REQUEST_ID,
ACTION_STATUS_CD,
ASSIGNMENT_ID,
ENROLLMENT_STATUS,
ERROR_MESSAGE,
BOOKING_ID,
MBR_BG_ID
)
values
(l_person_action_id,
p_person_id,
p_bulk_enr_request_id,
p_action_status_cd,
p_assignment_id,
p_enrollment_status,
p_error_message,
p_booking_id,
p_business_group_id
);