APPS.PQH_DE_VLDJOB_API SQL Statements

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

Line: 12

procedure Insert_Vldtn_Job
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_business_group_id             in  number
  ,P_WRKPLC_VLDTN_OP_ID            In  Number
  ,P_WRKPLC_JOB_ID                 In  Number
  ,P_DESCRIPTION                   In  Varchar2
  ,P_WRKPLC_VLDTN_JOB_ID           out nocopy Number
  ,p_object_version_number         out nocopy number) is
  --
  -- Declare cursors and local variables
  --

  l_proc  varchar2(72)    := g_package||'Insert_Vldtn_Job';

Line: 35

  savepoint Insert_Vldtn_Job;

Line: 44

   PQH_DE_VLDJOB_BK1.Insert_Vldtn_Job_b
   (p_effective_date             => L_Effective_Date
   ,p_business_group_id          => p_Business_Group_Id
   ,P_WRKPLC_VLDTN_OP_ID         => P_Wrkplc_Vldtn_Op_Id
   ,P_WRKPLC_JOB_ID              => P_Wrkplc_Job_Id
   ,P_DESCRIPTION                => P_Description);

Line: 55

        (p_module_name => 'Insert_Vldtn_Job'
        ,p_hook_type   => 'BP'
        );

Line: 77

     PQH_DE_VLDJOB_BK1.Insert_Vldtn_Job_a
     (p_effective_date               => l_Effective_Date
     ,p_business_group_id            => p_Business_group_Id
     ,p_WRKPLC_VLDTN_OP_ID           => p_WRKPLC_VLDTN_OP_ID
     ,p_WRKPLC_JOB_ID                => p_WRKPLC_JOB_ID
     ,P_DESCRIPTION                  => P_DESCRIPTION
     ,P_WRKPLC_VLDTN_JOB_ID          => l_WRKPLC_VLDTN_JOB_ID
     ,p_object_version_number        => l_object_version_number);

Line: 89

        (p_module_name => 'Insert_Vldtn_Job'
        ,p_hook_type   => 'AP'
        );

Line: 113

    rollback to Insert_Vldtn_job;

Line: 129

    rollback to Insert_Vldtn_Job;

Line: 132

end Insert_Vldtn_Job;

Line: 139

procedure Update_Vldtn_Job
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_business_group_id             in  number   Default hr_api.g_Number
  ,P_WRKPLC_VLDTN_OP_ID            In  Number   Default hr_api.g_Number
  ,P_WRKPLC_JOB_ID                 In  Number   Default hr_api.g_Number
  ,P_DESCRIPTION                   In  Varchar2 Default hr_api.g_Varchar2
  ,P_WRKPLC_VLDTN_JOB_ID           In  Number
  ,p_object_version_number         In  out nocopy number) Is

  l_proc  varchar2(72)    := g_package||'Update_Vldtn_Job';

Line: 158

  savepoint Update_Vldtn_Oprn;

Line: 168

   PQH_DE_VLDJOB_BK2.Update_Vldtn_Job_b
  (p_effective_date                => l_Effective_Date
  ,p_business_group_id             => p_business_group_id
  ,p_WRKPLC_VLDTN_OP_ID            => p_Wrkplc_Vldtn_OP_Id
  ,P_WRKPLC_JOB_ID                 => P_WRKPLC_JOB_ID
  ,P_DESCRIPTION                   => P_DESCRIPTION
  ,P_WRKPLC_VLDTN_JOB_ID           => P_WRKPLC_VLDTN_JOB_ID
  ,p_object_version_number         => l_object_version_number);

Line: 180

        (p_module_name => 'Update_Vldtn_Job'
        ,p_hook_type   => 'BP'
        );

Line: 200

   PQH_DE_VLDJOB_BK2.Update_Vldtn_JOB_a
  (p_effective_date                => l_Effective_Date
  ,p_business_group_id             => p_business_group_id
  ,p_WRKPLC_VLDTN_OP_ID            => p_Wrkplc_Vldtn_OP_Id
  ,P_WRKPLC_JOB_ID                 => P_WRKPLC_JOB_ID
  ,P_DESCRIPTION                   => P_DESCRIPTION
  ,P_WRKPLC_VLDTN_JOB_ID           => P_WRKPLC_VLDTN_JOB_ID
  ,p_object_version_number         => l_object_version_number);

Line: 212

        (p_module_name => 'Update_Vldtn_Job'
        ,p_hook_type   => 'AP'
        );

Line: 236

    rollback to Update_Vldtn_Job;

Line: 249

    rollback to Update_Vldtn_Job;

Line: 252

end Update_Vldtn_Job;

Line: 258

procedure delete_Vldtn_Job
  (p_validate                      in     boolean  default false
  ,p_WRKPLC_VLDTN_JOB_ID           In     Number
  ,p_object_version_number         In     number) Is   --

  -- Declare cursors and local variables
  --
  l_proc           varchar2(72) := g_package||'delete_Vldtn_Job';

Line: 272

  savepoint delete_Vldtn_Job;

Line: 277

  PQH_DE_VLDJOB_BK3.Delete_Vldtn_Job_b
  (p_WRKPLC_VLDTN_JOB_ID           =>   p_WRKPLC_VLDTN_JOB_ID
  ,p_object_version_number         =>   p_object_version_number);

Line: 283

        (p_module_name => 'delete_Vldtn_Job'
        ,p_hook_type   => 'BP');

Line: 297

   PQH_DE_VLDJOB_BK3.Delete_Vldtn_Job_a
  (p_WRKPLC_VLDTN_JOB_ID            => p_WRKPLC_VLDTN_JOB_ID
  ,p_object_version_number          => p_object_version_number);

Line: 304

        (p_module_name => 'delete_Vldtn_Job'
        ,p_hook_type   => 'AP');

Line: 323

    rollback to delete_Vldtn_Job;

Line: 334

    rollback to delete_Vldtn_Job;

Line: 337

end delete_Vldtn_Job;