APPS.PER_LETTER_REQUESTS_PKG SQL Statements

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

Line: 14

cursor csr_request is select null
		       from   per_letter_requests
		       where  (X_letter_request_id is null
		       or     (letter_request_id <> X_letter_request_id
		       and    X_letter_request_id is not null))
		       and    business_group_id + 0   = X_business_group_id
		       and    letter_type_id      = X_letter_type_id
                       and    nvl(vacancy_id,-1)  = nvl(X_Vacancy_ID,-1)
                       and    date_from           = X_date_from
		       and    request_status      = 'PENDING';

Line: 49

   is cursor c is select null
		  from per_letter_request_lines
		  where  letter_request_id = X_letter_request_id;

Line: 74

PROCEDURE confirm_delete_lines (X_letter_request_id   in     NUMBER,
				X_business_group_id   in     NUMBER,
				X_request_lines_exist in out nocopy BOOLEAN) is
--
   cursor c is select null
		  from per_letter_request_lines
		  where  letter_request_id = X_letter_request_id;

Line: 96

  hr_utility.set_location('PER_LETTER_REQUESTS_PKG.confirm_delete_lines', 1);

Line: 98

end confirm_delete_lines;

Line: 100

PROCEDURE Insert_Row(X_Rowid                        IN OUT nocopy VARCHAR2,
                     X_Letter_Request_Id            IN OUT nocopy NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Letter_Type_Id                      NUMBER,
                     X_Date_From                           DATE,
                     X_Request_Status                      VARCHAR2,
                     X_Auto_Or_Manual                      VARCHAR2,
		     X_VACANCY_ID	                   NUMBER,
                     X_EVENT_ID                            NUMBER
 ) IS
   CURSOR C IS SELECT rowid FROM per_letter_requests
             WHERE  letter_request_id = X_Letter_Request_Id;

Line: 113

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

Line: 121

   INSERT INTO per_letter_requests(
          letter_request_id,
          business_group_id,
          letter_type_id,
          date_from,
          request_status,
          auto_or_manual,
	  vacancy_id,
          event_id
         ) VALUES (
          X_Letter_Request_Id,
          X_Business_Group_Id,
          X_Letter_Type_Id,
          X_Date_From,
          X_Request_Status,
          X_Auto_Or_Manual,
          X_Vacancy_ID,
	  X_Event_ID
  );

Line: 145

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

Line: 150

END Insert_Row;

Line: 164

      SELECT *
      FROM   per_letter_requests
      WHERE  rowid = X_Rowid
      FOR UPDATE of letter_request_id            NOWAIT;

Line: 212

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Letter_Request_Id                   NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Letter_Type_Id                      NUMBER,
                     X_Date_From                           DATE,
                     X_Request_Status                      VARCHAR2,
                     X_Auto_Or_Manual                      VARCHAR2,
                     X_VACANCY_ID	                   NUMBER,
		     X_EVENT_ID	 	                   NUMBER
) IS
BEGIN
  --
  UPDATE per_letter_requests
  SET
    letter_request_id                         =    X_Letter_Request_Id,
    business_group_id                         =    X_Business_Group_Id,
    letter_type_id                            =    X_Letter_Type_Id,
    date_from                                 =    X_Date_From,
    request_status                            =    X_Request_Status,
    auto_or_manual                            =    X_Auto_Or_Manual,
    vacancy_id 	                              =    X_Vacancy_ID,
    event_id 	                              =    X_Event_ID
  WHERE rowid = X_rowid;

Line: 238

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

Line: 243

END Update_Row;

Line: 245

PROCEDURE Delete_Row(X_Rowid VARCHAR2,
		     X_Letter_Request_Id NUMBER) is
--
cursor csr_lines is select null
                    from per_letter_request_lines
		    where letter_request_id = X_letter_request_id;

Line: 264

    DELETE FROM per_letter_request_lines
    WHERE letter_Request_Id = X_letter_request_id;

Line: 269

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

Line: 276

  DELETE FROM per_letter_requests
  WHERE  rowid = X_Rowid;

Line: 281

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

Line: 286

END Delete_Row;