APPS.PER_BOOKINGS_PKG SQL Statements

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

Line: 35

SELECT 1
FROM   PER_PEOPLE_F PPF
WHERE  PPF.PERSON_ID         = to_number(P_Person_id)
AND    PPF.CURRENT_EMPLOYEE_FLAG = 'Y'
AND    l_New_Date between PPF.EFFECTIVE_START_DATE AND
       PPF.EFFECTIVE_END_DATE;

Line: 43

SELECT 1
FROM   PER_PEOPLE_F PPF
WHERE  PPF.PERSON_ID         = to_number(P_Person_id)
AND    PPF.CURRENT_APPLICANT_FLAG = 'Y'
AND    l_New_Date between PPF.EFFECTIVE_START_DATE AND
       PPF.EFFECTIVE_END_DATE;

Line: 51

SELECT 1
FROM   PER_PEOPLE_F PPF
WHERE  PPF.PERSON_ID         = to_number(P_Person_id)
AND    PPF.CURRENT_APPLICANT_FLAG = 'Y'
AND    PPF.CURRENT_EMPLOYEE_FLAG  = 'Y'
AND    l_New_Date between PPF.EFFECTIVE_START_DATE AND
       PPF.EFFECTIVE_END_DATE;

Line: 99

PROCEDURE Insert_Row(X_Rowid                        IN OUT NOCOPY VARCHAR2,
                     X_Booking_Id                   IN OUT NOCOPY NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Person_Id                           NUMBER,
                     X_Event_Id                            NUMBER,
                     X_Message                             VARCHAR2,
                     X_Token                               VARCHAR2,
		     X_Comments                            VARCHAR2,
                     X_Attribute_Category                  VARCHAR2,
                     X_Attribute1                          VARCHAR2,
                     X_Attribute2                          VARCHAR2,
                     X_Attribute3                          VARCHAR2,
                     X_Attribute4                          VARCHAR2,
                     X_Attribute5                          VARCHAR2,
                     X_Attribute6                          VARCHAR2,
                     X_Attribute7                          VARCHAR2,
                     X_Attribute8                          VARCHAR2,
                     X_Attribute9                          VARCHAR2,
                     X_Attribute10                         VARCHAR2,
                     X_Attribute11                         VARCHAR2,
                     X_Attribute12                         VARCHAR2,
                     X_Attribute13                         VARCHAR2,
                     X_Attribute14                         VARCHAR2,
                     X_Attribute15                         VARCHAR2,
                     X_Attribute16                         VARCHAR2,
                     X_Attribute17                         VARCHAR2,
                     X_Attribute18                         VARCHAR2,
                     X_Attribute19                         VARCHAR2,
                     X_Attribute20                         VARCHAR2,
                     X_Primary_Interviewer_Flag            VARCHAR2   default null
 ) IS

   L_DUMMY NUMBER;

Line: 134

   SELECT rowid FROM PER_BOOKINGS
   WHERE booking_id = X_Booking_Id;

Line: 138

   SELECT PER_BOOKINGS_S.NEXTVAL
   FROM SYS.DUAL;

Line: 142

   SELECT 1
   FROM  PER_BOOKINGS PB
   WHERE (PB.ROWID <> X_Rowid OR X_Rowid IS NULL)
   AND   PB.PERSON_ID = X_PERSON_ID
   AND   PB.BUSINESS_GROUP_ID + 0 = X_BUSINESS_GROUP_ID
   AND   PB.EVENT_ID = X_EVENT_ID;

Line: 170

  INSERT INTO PER_BOOKINGS(
          booking_id,
          business_group_id,
          person_id,
          event_id,
          comments,
          attribute_category,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
          attribute5,
          attribute6,
          attribute7,
          attribute8,
          attribute9,
          attribute10,
          attribute11,
          attribute12,
          attribute13,
          attribute14,
          attribute15,
          attribute16,
          attribute17,
          attribute18,
          attribute19,
          attribute20,
          primary_interviewer_flag
         ) VALUES (
          X_Booking_Id,
          X_Business_Group_Id,
          X_Person_Id,
          X_Event_Id,
          X_Comments,
          X_Attribute_Category,
          X_Attribute1,
          X_Attribute2,
          X_Attribute3,
          X_Attribute4,
          X_Attribute5,
          X_Attribute6,
          X_Attribute7,
          X_Attribute8,
          X_Attribute9,
          X_Attribute10,
          X_Attribute11,
          X_Attribute12,
          X_Attribute13,
          X_Attribute14,
          X_Attribute15,
          X_Attribute16,
          X_Attribute17,
          X_Attribute18,
          X_Attribute19,
          X_Attribute20,
          X_Primary_Interviewer_Flag
  );

Line: 233

    HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','INSERT_ROW');

Line: 238

END Insert_Row;

Line: 271

      SELECT *
      FROM   PER_BOOKINGS
      WHERE  rowid = X_Rowid
      FOR UPDATE of Booking_Id NOWAIT;

Line: 401

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Booking_Id                          NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Person_Id                           NUMBER,
                     X_Event_Id                            NUMBER,
		     X_Message                             VARCHAR2,
                     X_Token                               VARCHAR2,
                     X_Comments                            VARCHAR2,
                     X_Attribute_Category                  VARCHAR2,
                     X_Attribute1                          VARCHAR2,
                     X_Attribute2                          VARCHAR2,
                     X_Attribute3                          VARCHAR2,
                     X_Attribute4                          VARCHAR2,
                     X_Attribute5                          VARCHAR2,
                     X_Attribute6                          VARCHAR2,
                     X_Attribute7                          VARCHAR2,
                     X_Attribute8                          VARCHAR2,
                     X_Attribute9                          VARCHAR2,
                     X_Attribute10                         VARCHAR2,
                     X_Attribute11                         VARCHAR2,
                     X_Attribute12                         VARCHAR2,
                     X_Attribute13                         VARCHAR2,
                     X_Attribute14                         VARCHAR2,
                     X_Attribute15                         VARCHAR2,
                     X_Attribute16                         VARCHAR2,
                     X_Attribute17                         VARCHAR2,
                     X_Attribute18                         VARCHAR2,
                     X_Attribute19                         VARCHAR2,
                     X_Attribute20                         VARCHAR2,
                     X_Primary_Interviewer_Flag            VARCHAR2   default null
) IS

   L_DUMMY NUMBER;

Line: 436

   SELECT 1
   FROM  PER_BOOKINGS PB
   WHERE (PB.ROWID <> X_Rowid OR X_Rowid IS NULL)
   AND   PB.PERSON_ID = X_PERSON_ID
   AND   PB.BUSINESS_GROUP_ID + 0 = X_BUSINESS_GROUP_ID
   AND   PB.EVENT_ID = X_EVENT_ID;

Line: 461

  UPDATE PER_BOOKINGS
  SET

    booking_id                                =    X_Booking_Id,
    business_group_id                         =    X_Business_Group_Id,
    person_id                                 =    X_Person_Id,
    event_id                                  =    X_Event_Id,
    comments                                  =    X_Comments,
    attribute_category                        =    X_Attribute_Category,
    attribute1                                =    X_Attribute1,
    attribute2                                =    X_Attribute2,
    attribute3                                =    X_Attribute3,
    attribute4                                =    X_Attribute4,
    attribute5                                =    X_Attribute5,
    attribute6                                =    X_Attribute6,
    attribute7                                =    X_Attribute7,
    attribute8                                =    X_Attribute8,
    attribute9                                =    X_Attribute9,
    attribute10                               =    X_Attribute10,
    attribute11                               =    X_Attribute11,
    attribute12                               =    X_Attribute12,
    attribute13                               =    X_Attribute13,
    attribute14                               =    X_Attribute14,
    attribute15                               =    X_Attribute15,
    attribute16                               =    X_Attribute16,
    attribute17                               =    X_Attribute17,
    attribute18                               =    X_Attribute18,
    attribute19                               =    X_Attribute19,
    attribute20                               =    X_Attribute20,
    primary_interviewer_flag                  =    X_Primary_Interviewer_Flag
  WHERE rowid = X_rowid;

Line: 495

    HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','UPDATE_ROW');

Line: 500

END Update_Row;

Line: 502

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

Line: 509

    HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','DELETE_ROW');

Line: 513

END Delete_Row;