eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_MAINTAIN_PROPOSAL_SWI SQL Statements

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

Line: 301


PROCEDURE delete_proposal_component
  (p_component_id                 in     number
  ,p_validation_strength          in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in     number
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 315


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

Line: 321


  savepoint delete_proposal_component_swi;

Line: 341


  hr_maintain_proposal_api.delete_proposal_component
    (p_component_id                 => p_component_id
    ,p_validation_strength          => p_validation_strength
    ,p_object_version_number        => p_object_version_number
    ,p_validate                     => l_validate
    );

Line: 369


    rollback to delete_proposal_component_swi;

Line: 383


    rollback to delete_proposal_component_swi;

Line: 393


end delete_proposal_component;

Line: 397


PROCEDURE delete_salary_proposal
  (p_pay_proposal_id              in     number
  ,p_business_group_id            in     number
  ,p_object_version_number        in     number
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 412


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

Line: 418


  savepoint delete_salary_proposal_swi;

Line: 438


  hr_maintain_proposal_api.delete_salary_proposal
    (p_pay_proposal_id              => p_pay_proposal_id
    ,p_business_group_id            => p_business_group_id
    ,p_object_version_number        => p_object_version_number
    ,p_validate                     => l_validate
    ,p_salary_warning               => l_salary_warning
    );

Line: 467


    rollback to delete_salary_proposal_swi;

Line: 481


    rollback to delete_salary_proposal_swi;

Line: 491


end delete_salary_proposal;

Line: 495


PROCEDURE insert_proposal_component
  (p_component_id                    out nocopy number
  ,p_pay_proposal_id              in     number
  ,p_business_group_id            in     number
  ,p_approved                     in     varchar2
  ,p_component_reason             in     varchar2
  ,p_change_amount_n              in     number    default hr_api.g_number
  ,p_change_percentage            in     number    default hr_api.g_number
  ,p_comments                     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
  ,p_validation_strength          in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number           out nocopy number
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 537


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

Line: 543


  savepoint insert_proposal_component_swi;

Line: 563


  hr_maintain_proposal_api.insert_proposal_component
    (p_component_id                 => p_component_id
    ,p_pay_proposal_id              => p_pay_proposal_id
    ,p_business_group_id            => p_business_group_id
    ,p_approved                     => p_approved
    ,p_component_reason             => p_component_reason
    ,p_change_amount_n              => p_change_amount_n
    ,p_change_percentage            => p_change_percentage
    ,p_comments                     => p_comments
    ,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_validation_strength          => p_validation_strength
    ,p_object_version_number        => p_object_version_number
    ,p_validate                     => l_validate
    );

Line: 619


    rollback to insert_proposal_component_swi;

Line: 635


    rollback to insert_proposal_component_swi;

Line: 647


end insert_proposal_component;

Line: 651


PROCEDURE insert_salary_proposal
  (p_pay_proposal_id              in number
  ,p_assignment_id                in     number
  ,p_business_group_id            in     number
  ,p_change_date                  in     date      default hr_api.g_date
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_next_sal_review_date         in     date      default hr_api.g_date
  ,p_proposal_reason              in     varchar2  default hr_api.g_varchar2
  ,p_proposed_salary_n            in     number    default hr_api.g_number
  ,p_forced_ranking               in     number    default hr_api.g_number
  ,p_date_to            	  in     date      default hr_general.end_of_time
  ,p_performance_review_id        in     number    default hr_api.g_number
  ,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
  ,p_object_version_number           out nocopy number
  ,p_multiple_components          in     varchar2  default hr_api.g_varchar2
  ,p_approved                     in     varchar2  default hr_api.g_varchar2
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_element_entry_id             in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 704


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

Line: 711


HR_MAINTAIN_PROPOSAL_API.g_deleted_from_oa:='Y';

Line: 717


  savepoint insert_salary_proposal_swi;

Line: 741


  hr_maintain_proposal_api.insert_salary_proposal
    (p_pay_proposal_id              => l_pay_proposal_id
    ,p_assignment_id                => p_assignment_id
    ,p_business_group_id            => p_business_group_id
    ,p_change_date                  => p_change_date
    ,p_comments                     => p_comments
    ,p_next_sal_review_date         => p_next_sal_review_date
    ,p_proposal_reason              => p_proposal_reason
    ,p_proposed_salary_n            => p_proposed_salary_n
    ,p_forced_ranking               => p_forced_ranking
    ,p_date_to			    => p_date_to
    ,p_performance_review_id        => p_performance_review_id
    ,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_object_version_number        => p_object_version_number
    ,p_multiple_components          => p_multiple_components
    ,p_approved                     => p_approved
    ,p_validate                     => l_validate
    ,p_element_entry_id             => p_element_entry_id
    ,p_inv_next_sal_date_warning    => l_inv_next_sal_date_warning
    ,p_proposed_salary_warning      => l_proposed_salary_warning
    ,p_approved_warning             => l_approved_warning
    ,p_payroll_warning              => l_payroll_warning
    );

Line: 806


    rollback to insert_salary_proposal_swi;

Line: 823


    rollback to insert_salary_proposal_swi;

Line: 836


end insert_salary_proposal;

Line: 840


PROCEDURE update_proposal_component
  (p_component_id                 in     number
  ,p_approved                     in     varchar2  default hr_api.g_varchar2
  ,p_component_reason             in     varchar2  default hr_api.g_varchar2
  ,p_change_amount_n              in     number    default hr_api.g_number
  ,p_change_percentage            in     number    default hr_api.g_number
  ,p_comments                     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
  ,p_validation_strength          in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 881


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

Line: 887


  savepoint update_proposal_component_swi;

Line: 908


  hr_maintain_proposal_api.update_proposal_component
    (p_component_id                 => p_component_id
    ,p_approved                     => p_approved
    ,p_component_reason             => p_component_reason
    ,p_change_amount_n              => p_change_amount_n
    ,p_change_percentage            => p_change_percentage
    ,p_comments                     => p_comments
    ,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_validation_strength          => p_validation_strength
    ,p_object_version_number        => p_object_version_number
    ,p_validate                     => l_validate
    );

Line: 962


    rollback to update_proposal_component_swi;

Line: 977


    rollback to update_proposal_component_swi;

Line: 988


end update_proposal_component;

Line: 992


PROCEDURE update_salary_proposal
  (p_pay_proposal_id              in     number
  ,p_change_date                  in     date      default hr_api.g_date
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_next_sal_review_date         in     date      default hr_api.g_date
  ,p_proposal_reason              in     varchar2  default hr_api.g_varchar2
  ,p_proposed_salary_n            in     number    default hr_api.g_number
  ,p_forced_ranking               in     number    default hr_api.g_number
  ,p_date_to			  in     date      default hr_api.g_date
  ,p_performance_review_id        in     number    default hr_api.g_number
  ,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
  ,p_object_version_number        in out nocopy number
  ,p_multiple_components          in     varchar2  default hr_api.g_varchar2
  ,p_approved                     in     varchar2  default hr_api.g_varchar2
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 1041


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

Line: 1049


HR_MAINTAIN_PROPOSAL_API.g_deleted_from_oa:='Y';

Line: 1054


  savepoint update_salary_proposal_swi;

Line: 1075


  hr_maintain_proposal_api.update_salary_proposal
    (p_pay_proposal_id              => p_pay_proposal_id
    ,p_change_date                  => p_change_date
    ,p_comments                     => p_comments
    ,p_next_sal_review_date         => p_next_sal_review_date
    ,p_proposal_reason              => p_proposal_reason
    ,p_proposed_salary_n            => p_proposed_salary_n
    ,p_forced_ranking               => p_forced_ranking
    ,p_date_to			    => p_date_to
    ,p_performance_review_id        => p_performance_review_id
    ,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_object_version_number        => p_object_version_number
    ,p_multiple_components          => p_multiple_components
    ,p_approved                     => p_approved
    ,p_validate                     => l_validate
    ,p_inv_next_sal_date_warning    => l_inv_next_sal_date_warning
    ,p_proposed_salary_warning      => l_proposed_salary_warning
    ,p_approved_warning             => l_approved_warning
    ,p_payroll_warning              => l_payroll_warning
    );

Line: 1137


    rollback to update_salary_proposal_swi;

Line: 1152


    rollback to update_salary_proposal_swi;

Line: 1163


end update_salary_proposal;

Line: 1210


     hr_maintain_proposal_swi.update_salary_proposal
     (p_pay_proposal_id              =>       l_pay_proposal_id
     ,p_change_date                  =>       hr_transaction_swi.getDateValue(l_CommitNode,'ChangeDate')
     ,p_comments                     =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
     ,p_next_sal_review_date         =>       hr_transaction_swi.getDateValue(l_CommitNode,'NextSalReviewDate')
     ,p_proposal_reason              =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposalReason')
     ,p_proposed_salary_n            =>       hr_transaction_swi.getNumberValue(l_CommitNode,'ProposedSalaryN')
     ,p_forced_ranking               =>       hr_transaction_swi.getNumberValue(l_CommitNode,'ForcedRanking')
     ,p_date_to			     =>       hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
     ,p_performance_review_id        =>       hr_transaction_swi.getNumberValue(l_CommitNode,'PerformanceReviewId')
     ,p_attribute_category           =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
     ,p_attribute1                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
     ,p_attribute2                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
     ,p_attribute3                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
     ,p_attribute4                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
     ,p_attribute5                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
     ,p_attribute6                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
     ,p_attribute7                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
     ,p_attribute8                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
     ,p_attribute9                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
     ,p_attribute10                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
     ,p_attribute11                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
     ,p_attribute12                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
     ,p_attribute13                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
     ,p_attribute14                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
     ,p_attribute15                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
     ,p_attribute16                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
     ,p_attribute17                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
     ,p_attribute18                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
     ,p_attribute19                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
     ,p_attribute20                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
     ,p_object_version_number        =>       l_object_version_number
     ,p_multiple_components          =>       'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'MultipleComponents')
     ,p_approved                     =>       'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'Approved')
     ,p_validate                     =>       p_validate
     ,p_return_status                =>       l_return_status
     );

Line: 1252


     hr_maintain_proposal_swi.delete_salary_proposal
     (p_pay_proposal_id              =>       hr_transaction_swi.getNumberValue(l_CommitNode,'PayProposalId')
     ,p_business_group_id            =>       hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId')
     ,p_object_version_number        =>       l_object_version_number
     ,p_validate                     =>       p_validate
     ,p_return_status                =>       l_return_status
     );