APPS.PER_LETTER_REQUEST_LINES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

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;

Line: 22

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));

Line: 89

      'select title,course_start_date
       from  ota_events
       where event_id = '||to_char(p_ota_event_id),
       dbms_sql.v7);

Line: 110

      '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);

Line: 134

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;

Line: 150

   CURSOR C2 IS SELECT per_letter_request_lines_s.nextval FROM sys.dual;

Line: 154

hr_utility.trace('Insert_Row');

Line: 161

   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
  );

Line: 191

       hr_utility.set_message_token('PROCEDURE','Insert_Row');

Line: 196

END Insert_Row;

Line: 211

      SELECT *
      FROM   per_letter_request_lines
      WHERE  rowid = X_Rowid
      FOR UPDATE of letter_request_line_id   NOWAIT;

Line: 269

PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
  DELETE FROM per_letter_request_lines
  WHERE  rowid = X_Rowid;

Line: 276

       hr_utility.set_message_token('PROCEDURE','Delete_Row');

Line: 280

END Delete_Row;