DBA Data[Home] [Help]

APPS.HR_DEPLOYMENT_FACTOR_API SQL Statements

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

Line: 72

  select business_group_id
  from per_all_people_f
  where person_id=p_person_id
  and   rownum = 1; -- Added for bug 3387339.
Line: 311

procedure update_person_dpmt_factor
  (p_validate                     in     boolean  default false
  ,p_effective_date               in     date
  ,p_deployment_factor_id         in     number
  ,p_object_version_number        in out nocopy number
  ,p_work_any_country             in     varchar2 default hr_api.g_varchar2
  ,p_work_any_location            in     varchar2 default hr_api.g_varchar2
  ,p_relocate_domestically        in     varchar2 default hr_api.g_varchar2
  ,p_relocate_internationally     in     varchar2 default hr_api.g_varchar2
  ,p_travel_required              in     varchar2 default hr_api.g_varchar2
  ,p_country1                     in     varchar2 default hr_api.g_varchar2
  ,p_country2                     in     varchar2 default hr_api.g_varchar2
  ,p_country3                     in     varchar2 default hr_api.g_varchar2
  ,p_work_duration                in     varchar2 default hr_api.g_varchar2
  ,p_work_schedule                in     varchar2 default hr_api.g_varchar2
  ,p_work_hours                   in     varchar2 default hr_api.g_varchar2
  ,p_fte_capacity                 in     varchar2 default hr_api.g_varchar2
  ,p_visit_internationally        in     varchar2 default hr_api.g_varchar2
  ,p_only_current_location        in     varchar2 default hr_api.g_varchar2
  ,p_no_country1                  in     varchar2 default hr_api.g_varchar2
  ,p_no_country2                  in     varchar2 default hr_api.g_varchar2
  ,p_no_country3                  in     varchar2 default hr_api.g_varchar2
  ,p_comments                     in     varchar2 default hr_api.g_varchar2
  ,p_earliest_available_date      in     date     default hr_api.g_date
  ,p_available_for_transfer       in     varchar2 default hr_api.g_varchar2
  ,p_relocation_preference        in     varchar2 default hr_api.g_varchar2
  ,p_attribute_category           in     varchar2 default hr_api.g_varchar2
  ,p_attribute1                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute2                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute3                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute4                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute5                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute6                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute7                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute8                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute9                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute10                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute11                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute12                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute13                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute14                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute15                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute16                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute17                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute18                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute19                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute20                  in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date date;
Line: 364

  l_proc                varchar2(72) := g_package||'update_person_dpmt_factor';
Line: 374

  savepoint update_person_dpmt_factor;
Line: 398

    hr_deployment_factor_bk2.update_person_dpmt_factor_b
      (p_effective_date                => l_effective_date
      ,p_person_id                     => per_dpf_shd.g_old_rec.person_id
      ,p_business_group_id             => per_dpf_shd.g_old_rec.business_group_id
      ,p_work_any_country              => p_work_any_country
      ,p_work_any_location             => p_work_any_location
      ,p_relocate_domestically         => p_relocate_domestically
      ,p_relocate_internationally      => p_relocate_internationally
      ,p_travel_required               => p_travel_required
      ,p_country1                      => p_country1
      ,p_country2                      => p_country2
      ,p_country3                      => p_country3
      ,p_work_duration                 => p_work_duration
      ,p_work_schedule                 => p_work_schedule
      ,p_work_hours                    => p_work_hours
      ,p_fte_capacity                  => p_fte_capacity
      ,p_visit_internationally         => p_visit_internationally
      ,p_only_current_location         => p_only_current_location
      ,p_no_country1                   => p_no_country1
      ,p_no_country2                   => p_no_country2
      ,p_no_country3                   => p_no_country3
      ,p_comments                      => p_comments
      ,p_earliest_available_date       => l_earliest_available_date
      ,p_available_for_transfer        => p_available_for_transfer
      ,p_relocation_preference         => p_relocation_preference
      ,p_attribute_category            => p_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_deployment_factor_id          => p_deployment_factor_id
      ,p_object_version_number         => l_object_version_number
      );
Line: 450

        (p_module_name => 'update_person_dpmt_factor'
        ,p_hook_type   => 'BP'
        );
Line: 510

    hr_deployment_factor_bk2.update_person_dpmt_factor_a
      (p_effective_date                => l_effective_date
      ,p_person_id                     => per_dpf_shd.g_old_rec.person_id
      ,p_business_group_id             => per_dpf_shd.g_old_rec.business_group_id
      ,p_work_any_country              => p_work_any_country
      ,p_work_any_location             => p_work_any_location
      ,p_relocate_domestically         => p_relocate_domestically
      ,p_relocate_internationally      => p_relocate_internationally
      ,p_travel_required               => p_travel_required
      ,p_country1                      => p_country1
      ,p_country2                      => p_country2
      ,p_country3                      => p_country3
      ,p_work_duration                 => p_work_duration
      ,p_work_schedule                 => p_work_schedule
      ,p_work_hours                    => p_work_hours
      ,p_fte_capacity                  => p_fte_capacity
      ,p_visit_internationally         => p_visit_internationally
      ,p_only_current_location         => p_only_current_location
      ,p_no_country1                   => p_no_country1
      ,p_no_country2                   => p_no_country2
      ,p_no_country3                   => p_no_country3
      ,p_comments                      => p_comments
      ,p_earliest_available_date       => l_earliest_available_date
      ,p_available_for_transfer        => p_available_for_transfer
      ,p_relocation_preference         => p_relocation_preference
      ,p_attribute_category            => p_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_deployment_factor_id          => p_deployment_factor_id
      ,p_object_version_number         => l_object_version_number
      );
Line: 562

        (p_module_name => 'update_person_dpmt_factor'
        ,p_hook_type   => 'AP'
        );
Line: 584

    rollback to update_person_dpmt_factor;
Line: 596

    rollback to update_person_dpmt_factor;
Line: 604

end update_person_dpmt_factor;
Line: 667

  select business_group_id
  from hr_all_positions_f
  where position_id=p_position_id;
Line: 899

procedure update_position_dpmt_factor
  (p_validate                     in     boolean  default false
  ,p_effective_date               in     date
  ,p_deployment_factor_id         in     number
  ,p_object_version_number        in out nocopy number
  ,p_work_any_country             in     varchar2 default hr_api.g_varchar2
  ,p_work_any_location            in     varchar2 default hr_api.g_varchar2
  ,p_relocate_domestically        in     varchar2 default hr_api.g_varchar2
  ,p_relocate_internationally     in     varchar2 default hr_api.g_varchar2
  ,p_travel_required              in     varchar2 default hr_api.g_varchar2
  ,p_country1                     in     varchar2 default hr_api.g_varchar2
  ,p_country2                     in     varchar2 default hr_api.g_varchar2
  ,p_country3                     in     varchar2 default hr_api.g_varchar2
  ,p_work_duration                in     varchar2 default hr_api.g_varchar2
  ,p_work_schedule                in     varchar2 default hr_api.g_varchar2
  ,p_work_hours                   in     varchar2 default hr_api.g_varchar2
  ,p_fte_capacity                 in     varchar2 default hr_api.g_varchar2
  ,p_relocation_required          in     varchar2 default hr_api.g_varchar2
  ,p_passport_required            in     varchar2 default hr_api.g_varchar2
  ,p_location1                    in     varchar2 default hr_api.g_varchar2
  ,p_location2                    in     varchar2 default hr_api.g_varchar2
  ,p_location3                    in     varchar2 default hr_api.g_varchar2
  ,p_other_requirements           in     varchar2 default hr_api.g_varchar2
  ,p_service_minimum              in     varchar2 default hr_api.g_varchar2
  ,p_attribute_category           in     varchar2 default hr_api.g_varchar2
  ,p_attribute1                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute2                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute3                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute4                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute5                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute6                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute7                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute8                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute9                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute10                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute11                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute12                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute13                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute14                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute15                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute16                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute17                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute18                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute19                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute20                  in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date date;
Line: 949

  l_proc                varchar2(72) := g_package||'update_position_dpmt_factor';
Line: 959

  savepoint update_position_dpmt_factor;
Line: 982

    hr_deployment_factor_bk4.update_position_dpmt_factor_b
      (p_effective_date                => l_effective_date
      ,p_position_id                   => per_dpf_shd.g_old_rec.position_id
      ,p_business_group_id             => per_dpf_shd.g_old_rec.business_group_id
      ,p_work_any_country              => p_work_any_country
      ,p_work_any_location             => p_work_any_location
      ,p_relocate_domestically         => p_relocate_domestically
      ,p_relocate_internationally      => p_relocate_internationally
      ,p_travel_required               => p_travel_required
      ,p_country1                      => p_country1
      ,p_country2                      => p_country2
      ,p_country3                      => p_country3
      ,p_work_duration                 => p_work_duration
      ,p_work_schedule                 => p_work_schedule
      ,p_work_hours                    => p_work_hours
      ,p_fte_capacity                  => p_fte_capacity
      ,p_relocation_required           => p_relocation_required
      ,p_passport_required             => p_passport_required
      ,p_location1                     => p_location1
      ,p_location2                     => p_location2
      ,p_location3                     => p_location3
      ,p_other_requirements            => p_other_requirements
      ,p_service_minimum               => p_service_minimum
      ,p_attribute_category            => p_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_deployment_factor_id          => p_deployment_factor_id
      ,p_object_version_number         => l_object_version_number
      );
Line: 1032

        (p_module_name => 'update_position_dpmt_factor'
        ,p_hook_type   => 'BP'
        );
Line: 1090

    hr_deployment_factor_bk4.update_position_dpmt_factor_a
      (p_effective_date                => l_effective_date
      ,p_position_id                   => per_dpf_shd.g_old_rec.position_id
      ,p_business_group_id             => per_dpf_shd.g_old_rec.business_group_id
      ,p_work_any_country              => p_work_any_country
      ,p_work_any_location             => p_work_any_location
      ,p_relocate_domestically         => p_relocate_domestically
      ,p_relocate_internationally      => p_relocate_internationally
      ,p_travel_required               => p_travel_required
      ,p_country1                      => p_country1
      ,p_country2                      => p_country2
      ,p_country3                      => p_country3
      ,p_work_duration                 => p_work_duration
      ,p_work_schedule                 => p_work_schedule
      ,p_work_hours                    => p_work_hours
      ,p_fte_capacity                  => p_fte_capacity
      ,p_relocation_required           => p_relocation_required
      ,p_passport_required             => p_passport_required
      ,p_location1                     => p_location1
      ,p_location2                     => p_location2
      ,p_location3                     => p_location3
      ,p_other_requirements            => p_other_requirements
      ,p_service_minimum               => p_service_minimum
      ,p_attribute_category            => p_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_deployment_factor_id          => p_deployment_factor_id
      ,p_object_version_number         => l_object_version_number
      );
Line: 1140

        (p_module_name => 'update_position_dpmt_factor'
        ,p_hook_type   => 'AP'
        );
Line: 1162

    rollback to update_position_dpmt_factor;
Line: 1174

    rollback to update_position_dpmt_factor;
Line: 1182

end update_position_dpmt_factor;
Line: 1246

  select business_group_id
  from per_jobs_v
  where job_id=p_job_id;
Line: 1478

procedure update_job_dpmt_factor
  (p_validate                     in     boolean  default false
  ,p_effective_date               in     date
  ,p_deployment_factor_id         in     number
  ,p_object_version_number        in out nocopy number
  ,p_work_any_country             in     varchar2 default hr_api.g_varchar2
  ,p_work_any_location            in     varchar2 default hr_api.g_varchar2
  ,p_relocate_domestically        in     varchar2 default hr_api.g_varchar2
  ,p_relocate_internationally     in     varchar2 default hr_api.g_varchar2
  ,p_travel_required              in     varchar2 default hr_api.g_varchar2
  ,p_country1                     in     varchar2 default hr_api.g_varchar2
  ,p_country2                     in     varchar2 default hr_api.g_varchar2
  ,p_country3                     in     varchar2 default hr_api.g_varchar2
  ,p_work_duration                in     varchar2 default hr_api.g_varchar2
  ,p_work_schedule                in     varchar2 default hr_api.g_varchar2
  ,p_work_hours                   in     varchar2 default hr_api.g_varchar2
  ,p_fte_capacity                 in     varchar2 default hr_api.g_varchar2
  ,p_relocation_required          in     varchar2 default hr_api.g_varchar2
  ,p_passport_required            in     varchar2 default hr_api.g_varchar2
  ,p_location1                    in     varchar2 default hr_api.g_varchar2
  ,p_location2                    in     varchar2 default hr_api.g_varchar2
  ,p_location3                    in     varchar2 default hr_api.g_varchar2
  ,p_other_requirements           in     varchar2 default hr_api.g_varchar2
  ,p_service_minimum              in     varchar2 default hr_api.g_varchar2
  ,p_attribute_category           in     varchar2 default hr_api.g_varchar2
  ,p_attribute1                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute2                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute3                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute4                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute5                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute6                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute7                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute8                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute9                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute10                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute11                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute12                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute13                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute14                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute15                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute16                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute17                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute18                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute19                  in     varchar2 default hr_api.g_varchar2
  ,p_attribute20                  in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date date;
Line: 1528

  l_proc                varchar2(72) := g_package||'update_job_dpmt_factor';
Line: 1538

  savepoint update_job_dpmt_factor;
Line: 1561

    hr_deployment_factor_bk6.update_job_dpmt_factor_b
      (p_effective_date                => l_effective_date
      ,p_job_id                        => per_dpf_shd.g_old_rec.job_id
      ,p_business_group_id             => per_dpf_shd.g_old_rec.business_group_id
      ,p_work_any_country              => p_work_any_country
      ,p_work_any_location             => p_work_any_location
      ,p_relocate_domestically         => p_relocate_domestically
      ,p_relocate_internationally      => p_relocate_internationally
      ,p_travel_required               => p_travel_required
      ,p_country1                      => p_country1
      ,p_country2                      => p_country2
      ,p_country3                      => p_country3
      ,p_work_duration                 => p_work_duration
      ,p_work_schedule                 => p_work_schedule
      ,p_work_hours                    => p_work_hours
      ,p_fte_capacity                  => p_fte_capacity
      ,p_relocation_required           => p_relocation_required
      ,p_passport_required             => p_passport_required
      ,p_location1                     => p_location1
      ,p_location2                     => p_location2
      ,p_location3                     => p_location3
      ,p_other_requirements            => p_other_requirements
      ,p_service_minimum               => p_service_minimum
      ,p_attribute_category            => p_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_deployment_factor_id          => p_deployment_factor_id
      ,p_object_version_number         => l_object_version_number
      );
Line: 1611

        (p_module_name => 'update_job_dpmt_factor'
        ,p_hook_type   => 'BP'
        );
Line: 1669

    hr_deployment_factor_bk6.update_job_dpmt_factor_a
      (p_effective_date                => l_effective_date
      ,p_job_id                        => per_dpf_shd.g_old_rec.job_id
      ,p_business_group_id             => per_dpf_shd.g_old_rec.business_group_id
      ,p_work_any_country              => p_work_any_country
      ,p_work_any_location             => p_work_any_location
      ,p_relocate_domestically         => p_relocate_domestically
      ,p_relocate_internationally      => p_relocate_internationally
      ,p_travel_required               => p_travel_required
      ,p_country1                      => p_country1
      ,p_country2                      => p_country2
      ,p_country3                      => p_country3
      ,p_work_duration                 => p_work_duration
      ,p_work_schedule                 => p_work_schedule
      ,p_work_hours                    => p_work_hours
      ,p_fte_capacity                  => p_fte_capacity
      ,p_relocation_required           => p_relocation_required
      ,p_passport_required             => p_passport_required
      ,p_location1                     => p_location1
      ,p_location2                     => p_location2
      ,p_location3                     => p_location3
      ,p_other_requirements            => p_other_requirements
      ,p_service_minimum               => p_service_minimum
      ,p_attribute_category            => p_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_deployment_factor_id          => p_deployment_factor_id
      ,p_object_version_number         => l_object_version_number
      );
Line: 1719

        (p_module_name => 'update_job_dpmt_factor'
        ,p_hook_type   => 'AP'
        );
Line: 1741

    rollback to update_job_dpmt_factor;
Line: 1753

    rollback to update_job_dpmt_factor;
Line: 1761

end update_job_dpmt_factor;