APPS.PA_EX_PAY_UTILS SQL Statements

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

Line: 11

PROCEDURE Insert_Row
(
                x_rowid                         IN OUT NOCOPY VARCHAR2,
                x_business_group_id             IN     NUMBER,
                x_payroll_id                    IN OUT NOCOPY NUMBER,
                x_payroll_name                  IN     VARCHAR2,
                x_effective_start_date          IN     DATE,
                x_effective_end_date            IN     DATE,
                x_payroll_provider_name         IN     VARCHAR2,
                x_active_flag                   IN     VARCHAR2,
                x_priority                      IN     NUMBER,
                x_description                   IN     VARCHAR2,
                x_creation_date                 IN     DATE,
                x_created_by                    IN     NUMBER,
                x_last_update_date              IN     DATE,
                x_last_updated_by               IN     NUMBER,
                x_last_update_login             IN     NUMBER
)
IS

   CURSOR c IS
      SELECT ROWID
      FROM   pa_pay_external_payroll
      WHERE  payroll_id = x_payroll_id;

Line: 39

   INSERT INTO pa_pay_external_payroll
   (
      BUSINESS_GROUP_ID,
      PAYROLL_ID,
      PAYROLL_NAME,
      EFFECTIVE_START_DATE,
      EFFECTIVE_END_DATE,
      PAYROLL_PROVIDER_NAME,
      ACTIVE_FLAG,
      PRIORITY,
      DESCRIPTION,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_LOGIN
   )
   VALUES
   (
      X_BUSINESS_GROUP_ID,
      pa_pay_external_payroll_s.NEXTVAL,
      X_PAYROLL_NAME,
      X_EFFECTIVE_START_DATE,
      X_EFFECTIVE_END_DATE,
      X_PAYROLL_PROVIDER_NAME,
      X_ACTIVE_FLAG,
      X_PRIORITY,
      X_DESCRIPTION,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_CREATION_DATE,
      X_CREATED_BY,
      X_LAST_UPDATE_LOGIN
   )
   RETURNING payroll_id INTO x_payroll_id;

Line: 83

END Insert_Row;

Line: 107

      SELECT *
      FROM   pa_pay_external_payroll
      WHERE  payroll_id = x_payroll_id
      FOR UPDATE OF payroll_id NOWAIT;

Line: 167

PROCEDURE Update_Row
(
                x_business_group_id             IN     NUMBER,
                x_payroll_id                    IN     NUMBER,
                x_payroll_name                  IN     VARCHAR2,
                x_effective_start_date          IN     DATE,
                x_effective_end_date            IN     DATE,
                x_payroll_provider_name         IN     VARCHAR2,
                x_active_flag                   IN     VARCHAR2,
                x_priority                      IN     NUMBER,
                x_description                   IN     VARCHAR2,
                x_creation_date                 IN     DATE,
                x_created_by                    IN     NUMBER,
                x_last_update_date              IN     DATE,
                x_last_updated_by               IN     NUMBER,
                x_last_update_login             IN     NUMBER
)
IS

BEGIN

   UPDATE pa_pay_external_payroll
   SET    BUSINESS_GROUP_ID               = X_BUSINESS_GROUP_ID,
          PAYROLL_NAME                    = X_PAYROLL_NAME,
          EFFECTIVE_START_DATE            = X_EFFECTIVE_START_DATE,
          EFFECTIVE_END_DATE              = X_EFFECTIVE_END_DATE,
          PAYROLL_PROVIDER_NAME           = X_PAYROLL_PROVIDER_NAME,
          ACTIVE_FLAG                     = X_ACTIVE_FLAG,
          PRIORITY                        = X_PRIORITY,
          DESCRIPTION                     = X_DESCRIPTION,
          LAST_UPDATE_DATE                = X_LAST_UPDATE_DATE,
          LAST_UPDATED_BY                 = X_LAST_UPDATED_BY,
          LAST_UPDATE_LOGIN               = X_LAST_UPDATE_LOGIN
   WHERE  PAYROLL_ID  = X_PAYROLL_ID;

Line: 203

END Update_Row;

Line: 213

PROCEDURE Delete_Row
(
   X_PAYROLL_ID in NUMBER
)
IS
BEGIN
   DELETE FROM pa_pay_external_payroll
   WHERE payroll_id = x_payroll_id;

Line: 227

END Delete_Row;