APPS.PER_JOB_REQUIREMENTS_PKG2 SQL Statements

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

Line: 12

          SELECT '1'
          FROM PER_JOB_REQUIREMENTS PJR
          WHERE (ROWID <> X_Rowid
          OR     X_Rowid IS NULL)
          AND PJR.POSITION_ID = X_Position_Id
          AND PJR.ANALYSIS_CRITERIA_ID = X_Analysis_Criteria_Id;

Line: 30

PROCEDURE Insert_Row(X_Rowid                        IN OUT VARCHAR2,
                     X_Job_Requirement_Id                  IN OUT NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Analysis_Criteria_Id                NUMBER,
                     X_Comments                            VARCHAR2,
                     X_Date_From                           DATE,
                     X_Date_To                             DATE,
                     X_Essential                           VARCHAR2,
                     X_Job_Id                              NUMBER,
                     X_Position_Id                         NUMBER,
                     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
 ) IS
   CURSOR C IS SELECT rowid FROM PER_JOB_REQUIREMENTS

             WHERE job_requirement_id = X_Job_Requirement_Id;

Line: 70

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

Line: 83

  INSERT INTO PER_JOB_REQUIREMENTS(
          job_requirement_id,
          business_group_id,
          analysis_criteria_id,
          comments,
          date_from,
          date_to,
          essential,
          job_id,
          position_id,
          attribute_category,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
          attribute5,
          attribute6,
          attribute7,
          attribute8,
          attribute9,
          attribute10,
          attribute11,
          attribute12,
          attribute13,
          attribute14,
          attribute15,
          attribute16,
          attribute17,
          attribute18,
          attribute19,
          attribute20
         ) VALUES (
          X_Job_Requirement_Id,
          X_Business_Group_Id,
          X_Analysis_Criteria_Id,
          X_Comments,
          X_Date_From,
          X_Date_To,
          X_Essential,
          X_Job_Id,
          X_Position_Id,
          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
  );

Line: 152

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

Line: 157

END Insert_Row;

Line: 192

      SELECT *
      FROM   PER_JOB_REQUIREMENTS
      WHERE  rowid = X_Rowid
      FOR UPDATE of Job_Requirement_Id NOWAIT;

Line: 332

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Job_Requirement_Id                  NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Analysis_Criteria_Id                NUMBER,
                     X_Comments                            VARCHAR2,
                     X_Date_From                           DATE,
                     X_Date_To                             DATE,
                     X_Essential                           VARCHAR2,
                     X_Job_Id                              NUMBER,
                     X_Position_Id                         NUMBER,
                     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
) IS
BEGIN

  CHECK_DUP_REQS(X_Rowid,
                 X_Position_Id,
                 X_Analysis_Criteria_Id);

Line: 370

  UPDATE PER_JOB_REQUIREMENTS
  SET

    job_requirement_id                        =    X_Job_Requirement_Id,
    business_group_id                         =    X_Business_Group_Id,
    analysis_criteria_id                      =    X_Analysis_Criteria_Id,
    comments                                  =    X_Comments,
    date_from                                 =    X_Date_From,
    date_to                                   =    X_Date_To,
    essential                                 =    X_Essential,
    job_id                                    =    X_Job_Id,
    position_id                               =    X_Position_Id,
    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
  WHERE rowid = X_rowid;

Line: 407

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

Line: 412

END Update_Row;

Line: 414

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

Line: 421

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

Line: 425

END Delete_Row;