The following lines contain the word 'select', 'insert', 'update' or 'delete':
cursor csr_line is select null
from per_letter_request_lines r
where (X_letter_request_line_id is null
or X_letter_request_line_id <> r.letter_request_line_id)
and r.assignment_id = X_assignment_id
and r.letter_request_id = X_letter_request_id
and r.business_group_id + 0 = X_business_group_id;
select null
from per_letter_request_lines r
where (X_letter_request_line_id is null
or X_letter_request_line_id <> r.letter_request_line_id)
and r.letter_request_id = X_letter_request_id
and ((X_ota_event_id = ota_event_id and
ota_booking_id is null and
x_ota_booking_id is null)
or (X_ota_booking_id = ota_booking_id
and X_ota_booking_status_type_id = ota_booking_status_type_id));
'select title,course_start_date
from ota_events
where event_id = '||to_char(p_ota_event_id),
dbms_sql.v7);
'select event_title
, course_start_date
, delegate_full_name
from ota_delegate_bookings_v
where booking_id = '||to_char(p_ota_booking_id),
dbms_sql.v7);
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Letter_Request_Line_Id IN OUT NOCOPY NUMBER,
X_Business_Group_Id NUMBER,
X_Letter_Request_Id NUMBER,
X_Person_Id NUMBER,
X_Assignment_Id NUMBER,
X_Assignment_Status_Type_Id NUMBER,
X_Date_From DATE,
X_OTA_BOOKING_STATUS_TYPE_ID number,
X_OTA_BOOKING_ID number,
X_OTA_EVENT_ID number,
X_CONTRACT_ID IN NUMBER DEFAULT NULL
) IS
CURSOR C IS SELECT rowid FROM per_letter_request_lines
WHERE letter_request_line_id = X_Letter_Request_Line_Id;
CURSOR C2 IS SELECT per_letter_request_lines_s.nextval FROM sys.dual;
hr_utility.trace('Insert_Row');
INSERT INTO per_letter_request_lines(
letter_request_line_id,
business_group_id,
letter_request_id,
person_id,
assignment_id,
assignment_status_type_id,
date_from,
OTA_BOOKING_STATUS_TYPE_ID,
OTA_BOOKING_ID,
OTA_EVENT_ID,
CONTRACT_ID
) VALUES (
X_Letter_Request_Line_Id,
X_Business_Group_Id,
X_Letter_Request_Id,
X_Person_Id,
X_Assignment_Id,
X_Assignment_Status_Type_Id,
X_Date_From,
X_OTA_BOOKING_STATUS_TYPE_ID,
X_OTA_BOOKING_ID,
X_OTA_EVENT_ID,
X_CONTRACT_ID
);
hr_utility.set_message_token('PROCEDURE','Insert_Row');
END Insert_Row;
SELECT *
FROM per_letter_request_lines
WHERE rowid = X_Rowid
FOR UPDATE of letter_request_line_id NOWAIT;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
DELETE FROM per_letter_request_lines
WHERE rowid = X_Rowid;
hr_utility.set_message_token('PROCEDURE','Delete_Row');
END Delete_Row;