APPS.PER_RECRUIT_ACTIVITY_FOR_PKG SQL Statements

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

Line: 36

    SELECT 1
    FROM   per_recruitment_activity_for
    WHERE  recruitment_activity_id = p_recruitment_activity_id
    AND    vacancy_id		   = p_vacancy_id ;

Line: 72

    SELECT recf.recruitment_activity_id
    FROM   per_recruitment_activity_for recf
    WHERE  recf.recruitment_activity_id = P_recruitment_activity_id
    AND    recf.business_group_id + 0       = P_Business_group_id;

Line: 108

PROCEDURE Insert_Row(X_Rowid                        IN OUT NOCOPY VARCHAR2,
                     X_Recruitment_Activity_For_Id         IN OUT NOCOPY NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Vacancy_Id                          NUMBER,
                     X_Recruitment_Activity_Id             NUMBER)
IS
   CURSOR C IS
            SELECT rowid
            FROM PER_RECRUITMENT_ACTIVITY_FOR
            WHERE recruitment_activity_for_id = X_Recruitment_Activity_For_Id;

Line: 121

               SELECT per_recruitment_activity_for_s.nextval
               FROM sys.dual;

Line: 137

  INSERT INTO PER_RECRUITMENT_ACTIVITY_FOR
         (recruitment_activity_for_id,
          business_group_id,
          vacancy_id,
          recruitment_activity_id)
   VALUES (
          X_Recruitment_Activity_For_Id,
          X_Business_Group_Id,
          X_Vacancy_Id,
          X_Recruitment_Activity_Id );

Line: 154

                                 'per_recruit_activity_for_pkg.insert_row');

Line: 159

END Insert_Row;

Line: 181

      SELECT *
      FROM   PER_RECRUITMENT_ACTIVITY_FOR
      WHERE  rowid = X_Rowid
      FOR UPDATE of Recruitment_Activity_For_Id NOWAIT;

Line: 233

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Recruitment_Activity_For_Id         NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Vacancy_Id                          NUMBER,
                     X_Recruitment_Activity_Id             NUMBER)
IS
BEGIN
   --
   -- Check that the vacancy id has not already been used for this
   -- recruitment activity
   --
   chk_vacancy_unique ( p_recruitment_activity_id => X_recruitment_activity_id,
			p_vacancy_id		  => X_vacancy_id ) ;

Line: 247

  UPDATE PER_RECRUITMENT_ACTIVITY_FOR
  SET

   recruitment_activity_for_id               =    X_Recruitment_Activity_For_Id,
   business_group_id                         =    X_Business_Group_Id,
   vacancy_id                                =    X_Vacancy_Id,
   recruitment_activity_id                   =    X_Recruitment_Activity_Id
  WHERE rowid = X_rowid;

Line: 259

                                 'per_recruit_activity_for_pkg.update_row');

Line: 264

END Update_Row;

Line: 278

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

Line: 286

                                 'per_recruit_activity_for_pkg.delete_row');

Line: 290

END Delete_Row;