APPS.PQH_DE_VLDJOBFTR_API SQL Statements

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

Line: 12

procedure Insert_Vldtn_JobFtr
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_business_group_id             in  number
  ,P_WRKPLC_VLDTN_OPR_JOB_ID       In  Number
  ,P_JOB_FEATURE_Code              In  Varchar2
  ,P_Wrkplc_Vldtn_Opr_job_Type     In  Varchar2
  ,P_WRKPLC_VLDTN_JOBFTR_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_Jobftr';

Line: 35

  savepoint Insert_Vldtn_JobFtr;

Line: 44

   PQH_DE_VLDJOBFTR_BK1.Insert_Vldtn_JobFtr_b
   (p_effective_date             => L_Effective_Date
   ,p_business_group_id          => p_Business_Group_Id
   ,P_WRKPLC_VLDTN_OPR_JOB_ID    => P_Wrkplc_Vldtn_Opr_Job_Id
   ,P_JOB_FEATURE_CODE           => P_Job_Feature_Code
   ,P_Wrkplc_Vldtn_Opr_job_Type  => P_Wrkplc_Vldtn_Opr_Job_Type);

Line: 55

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

Line: 77

     PQH_DE_VLDJOBFTR_BK1.Insert_Vldtn_JobFtr_a
     (p_effective_date               => l_Effective_Date
     ,p_business_group_id            => p_Business_group_Id
     ,p_WRKPLC_VLDTN_OPR_JOB_ID      => p_WRKPLC_VLDTN_OPR_JOB_ID
     ,p_Job_Feature_Code             => p_Job_feature_Code
     ,P_Wrkplc_Vldtn_Opr_job_Type    => P_Wrkplc_Vldtn_Opr_Job_Type
     ,P_WRKPLC_VLDTN_JOBFTR_ID       => l_WRKPLC_VLDTN_JOBFTR_ID
     ,p_object_version_number        => l_object_version_number);

Line: 89

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

Line: 113

    rollback to Insert_Vldtn_jobftr;

Line: 129

    rollback to Insert_Vldtn_Jobftr;

Line: 132

end Insert_Vldtn_Jobftr;

Line: 139

procedure Update_Vldtn_Jobftr
  (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_OPR_JOB_ID       In  Number   Default hr_api.g_Number
  ,p_JOB_FEATURE_CODE              In  Varchar2 Default hr_api.g_Varchar2
  ,P_Wrkplc_Vldtn_Opr_job_Type     In  Varchar2 Default hr_api.g_Varchar2
  ,P_WRKPLC_VLDTN_JOBFTR_ID        In  Number
  ,p_object_version_number         In  out nocopy number) Is

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

Line: 158

  savepoint Update_Vldtn_JObFtr;

Line: 168

   PQH_DE_VLDJOBftr_BK2.Update_Vldtn_Jobftr_b
  (p_effective_date                => l_Effective_Date
  ,p_business_group_id             => p_business_group_id
  ,p_WRKPLC_VLDTN_OPR_JOB_ID       => p_Wrkplc_Vldtn_OPR_JOB_Id
  ,P_Job_Feature_Code              => P_Job_Feature_Code
  ,P_Wrkplc_Vldtn_Opr_job_Type     => P_Wrkplc_Vldtn_Opr_Job_Type
  ,P_WRKPLC_VLDTN_JOBFTR_ID        => P_WRKPLC_VLDTN_JOBFTR_ID
  ,p_object_version_number         => l_object_version_number);

Line: 180

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

Line: 200

   PQH_DE_VLDJOBFTR_BK2.Update_Vldtn_JOBFTR_a
  (p_effective_date                => l_Effective_Date
  ,p_business_group_id             => p_business_group_id
  ,p_WRKPLC_VLDTN_OPR_JOB_ID       => p_Wrkplc_Vldtn_OPR_JOB_Id
  ,P_JOB_FEATURE_CODE              => P_JOB_FEATURE_CODE
  ,P_Wrkplc_Vldtn_Opr_job_Type     => P_Wrkplc_Vldtn_Opr_Job_Type
  ,P_WRKPLC_VLDTN_JOBFTR_ID        => P_WRKPLC_VLDTN_JOBFTR_ID
  ,p_object_version_number         => l_object_version_number);

Line: 212

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

Line: 236

    rollback to Update_Vldtn_Jobftr;

Line: 249

    rollback to Update_Vldtn_Jobftr;

Line: 252

end Update_Vldtn_Jobftr;

Line: 258

procedure delete_Vldtn_Jobftr
  (p_validate                      in     boolean  default false
  ,p_WRKPLC_VLDTN_JOBFTR_ID        In     Number
  ,p_object_version_number         In     number) Is   --

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

Line: 272

  savepoint delete_Vldtn_Jobftr;

Line: 277

  PQH_DE_VLDJOBFTR_BK3.Delete_Vldtn_JobFTR_b
  (p_WRKPLC_VLDTN_JOBFTR_ID        =>   p_WRKPLC_VLDTN_JOBFTR_ID
  ,p_object_version_number         =>   p_object_version_number);

Line: 283

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

Line: 297

   PQH_DE_VLDJOBFTR_BK3.Delete_Vldtn_Jobftr_a
  (p_WRKPLC_VLDTN_JOBFTR_ID         => p_WRKPLC_VLDTN_JOBFTR_ID
  ,p_object_version_number          => p_object_version_number);

Line: 304

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

Line: 323

    rollback to delete_Vldtn_Jobftr;

Line: 334

    rollback to delete_Vldtn_Jobftr;

Line: 337

end delete_Vldtn_Jobftr;