APPS.PQH_DE_VLDDEF_API SQL Statements

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

Line: 12

procedure Insert_Vldtn_Defn
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_business_group_id             in  number
  ,p_VALIDATION_NAME               In  Varchar2
  ,p_EMPLOYMENT_TYPE               In  Varchar2
  ,p_REMUNERATION_REGULATION       In  Varchar2
  ,p_WRKPLC_VLDTN_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_Defn';

Line: 35

  savepoint Insert_Vldtn_Defn;

Line: 44

    PQH_DE_VLDDEF_BK1.Insert_Vldtn_Defn_b
      (p_effective_date           => l_effective_date
      ,p_business_group_id        => p_business_group_Id
      ,p_VALIDATION_NAME          => p_VALIDATION_NAME
      ,p_EMPLOYMENT_TYPE          => p_EMPLOYMENT_TYPE
      ,p_REMUNERATION_REGULATION  => p_REMUNERATION_REGULATION);

Line: 54

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

Line: 75

  PQH_DE_VLDDEF_BK1.Insert_Vldtn_Defn_a
  (p_effective_date               => l_effective_date
  ,p_business_group_id            => p_business_group_id
  ,p_VALIDATION_NAME              => p_VALIDATION_NAME
  ,p_EMPLOYMENT_TYPE              => p_EMPLOYMENT_TYPE
  ,p_REMUNERATION_REGULATION      => p_REMUNERATION_REGULATION
  ,p_WRKPLC_VLDTN_ID              => l_WRKPLC_VLDTN_ID
  ,p_object_version_number        => l_object_version_Number);

Line: 87

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

Line: 111

    rollback to Insert_Vldtn_Defn;

Line: 127

    rollback to Insert_Vldtn_Defn;

Line: 130

end Insert_Vldtn_Defn;

Line: 137

procedure Update_Vldtn_Defn
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_business_group_id             in     number   Default hr_api.g_Number
  ,p_VALIDATION_NAME               In     Varchar2 Default hr_api.g_Varchar2
  ,p_EMPLOYMENT_TYPE               In     Varchar2 Default hr_api.g_Varchar2
  ,p_REMUNERATION_REGULATION       In     Varchar2 Default hr_api.g_Varchar2
  ,p_WRKPLC_VLDTN_ID               In     number
  ,p_object_version_number         In out nocopy number) Is

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

Line: 156

  savepoint Update_Vldtn_Defn;

Line: 166

  PQH_DE_VLDDEF_BK2.Update_Vldtn_Defn_b
  (p_effective_date              => l_effective_date
  ,p_business_group_id           => p_business_group_id
  ,p_VALIDATION_NAME             => p_Validation_name
  ,p_EMPLOYMENT_TYPE             => P_employment_type
  ,p_REMUNERATION_REGULATION     => p_remuneration_Regulation
  ,p_WRKPLC_VLDTN_ID             => p_Wrkplc_vldtn_id
  ,p_object_version_number       => l_Object_Version_number);

Line: 177

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

Line: 196

  PQH_DE_VLDDEF_BK2.Update_Vldtn_Defn_a
  (p_effective_date              => l_effective_date
  ,p_business_group_id           => p_business_group_id
  ,p_VALIDATION_NAME             => p_VALIDATION_NAME
  ,p_EMPLOYMENT_TYPE             => p_EMPLOYMENT_TYPE
  ,p_REMUNERATION_REGULATION     => p_REMUNERATION_REGULATION
  ,p_WRKPLC_VLDTN_ID             => p_WRKPLC_VLDTN_ID
  ,p_object_version_number       => l_Object_Version_Number);

Line: 209

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

Line: 233

    rollback to Update_Vldtn_Defn;

Line: 246

    rollback to Update_Vldtn_Defn;

Line: 249

end Update_Vldtn_Defn;

Line: 255

procedure delete_Vldtn_Defn
  (p_validate                      in     boolean  default false
  ,p_WRKPLC_VLDTN_ID               In     Number
  ,p_object_version_number         In     number) Is   --

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

Line: 269

  savepoint delete_Vldtn_Defn;

Line: 274

  PQH_DE_VLDDEF_BK3.Delete_Vldtn_Defn_b
  (p_WRKPLC_VLDTN_ID               =>   p_WRKPLC_VLDTN_ID
  ,p_object_version_number         =>   p_object_version_number);

Line: 280

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

Line: 294

   PQH_DE_VLDDEF_BK3.Delete_Vldtn_Defn_a
  (p_WRKPLC_VLDTN_ID                => p_WRKPLC_VLDTN_ID
  ,p_object_version_number          => p_object_version_number);

Line: 301

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

Line: 320

    rollback to delete_Vldtn_Defn;

Line: 331

    rollback to delete_Vldtn_Defn;

Line: 334

end delete_Vldtn_Defn;