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.PSP_EXTERNAL_EFFORT_LINES_API SQL Statements

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

Line: 14


procedure insert_external_effort_line
( p_validate                     in             boolean  default false
, p_batch_name                   in             varchar2
, p_distribution_date            in             date
, p_person_id                    in             number
, p_assignment_id                in             number
, p_currency_code                in             varchar2
, p_distribution_amount          in             number
, p_business_group_id            in             number
, p_set_of_books_id              in             number
, p_gl_code_combination_id       in             number   default null
, p_project_id                   in             number	 default null
, p_task_id                      in             number	 default null
, p_award_id                     in             number	 default null
, p_expenditure_organization_id  in             number	 default null
, p_expenditure_type             in             varchar2 default null
, p_attribute_category           in             varchar2 default null
, p_attribute1                   in             varchar2 default null
, p_attribute2                   in             varchar2 default null
, p_attribute3                   in             varchar2 default null
, p_attribute4                   in             varchar2 default null
, p_attribute5                   in             varchar2 default null
, p_attribute6                   in             varchar2 default null
, p_attribute7                   in             varchar2 default null
, p_attribute8                   in             varchar2 default null
, p_attribute9                   in             varchar2 default null
, p_attribute10                  in             varchar2 default null
, p_attribute11                  in             varchar2 default null
, p_attribute12                  in             varchar2 default null
, p_attribute13                  in             varchar2 default null
, p_attribute14                  in             varchar2 default null
, p_attribute15                  in             varchar2 default null
, p_object_version_number        in out nocopy  number
, p_external_effort_line_id         out nocopy  number
, p_return_status                   out	nocopy  boolean
)
IS
  --
  -- Declare cursors and local variables
  --
  l_proc                   varchar2(72) := g_package||'insert_external_effort_line';

Line: 63


  savepoint insert_external_effort_line;

Line: 82


    psp_external_effort_lines_bk1.insert_external_effort_line_b
		( p_batch_name                   =>   p_batch_name
		, p_distribution_date            =>   p_distribution_date
		, p_person_id                    =>   p_person_id
		, p_assignment_id                =>   p_assignment_id
		, p_currency_code                =>   p_currency_code
		, p_distribution_amount          =>   p_distribution_amount
		, p_business_group_id            =>   p_business_group_id
		, p_set_of_books_id              =>   p_set_of_books_id
		, p_gl_code_combination_id       =>   p_gl_code_combination_id
		, p_project_id                   =>   p_project_id
		, p_task_id                      =>   p_task_id
		, p_award_id                     =>   p_award_id
		, p_expenditure_organization_id  =>   p_expenditure_organization_id
		, p_expenditure_type             =>   p_expenditure_type
		, 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
		);

Line: 117


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

Line: 170


     psp_external_effort_lines_bk1.insert_external_effort_line_a
		( p_batch_name                   =>   p_batch_name
		, p_distribution_date            =>   p_distribution_date
		, p_person_id                    =>   p_person_id
		, p_assignment_id                =>   p_assignment_id
		, p_currency_code                =>   p_currency_code
		, p_distribution_amount          =>   p_distribution_amount
		, p_business_group_id            =>   p_business_group_id
		, p_set_of_books_id              =>   p_set_of_books_id
		, p_gl_code_combination_id       =>   p_gl_code_combination_id
		, p_project_id                   =>   p_project_id
		, p_task_id                      =>   p_task_id
		, p_award_id                     =>   p_award_id
		, p_expenditure_organization_id  =>   p_expenditure_organization_id
		, p_expenditure_type             =>   p_expenditure_type
		, 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_object_version_number        =>   l_object_version_number
		, p_external_effort_line_id      =>   l_external_effort_line_id
		, p_return_status                =>   l_return_status
		);

Line: 208


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

Line: 232


    rollback to insert_external_effort_line;

Line: 246


    rollback to insert_external_effort_line;

Line: 256


end insert_external_effort_line;

Line: 270


procedure update_external_effort_line
( p_validate                     in             boolean  default false
, p_external_effort_line_id      in             number
, p_batch_name                   in             varchar2 default hr_api.g_varchar2
, p_distribution_date            in             date     default hr_api.g_date
, p_person_id                    in             number   default hr_api.g_number
, p_assignment_id                in             number   default hr_api.g_number
, p_currency_code                in             varchar2 default hr_api.g_varchar2
, p_distribution_amount          in             number   default hr_api.g_number
, p_business_group_id            in             number   default hr_api.g_number
, p_set_of_books_id              in             number   default hr_api.g_number
, p_gl_code_combination_id       in             number   default hr_api.g_number
, p_project_id                   in             number   default hr_api.g_number
, p_task_id                      in             number   default hr_api.g_number
, p_award_id                     in             number   default hr_api.g_number
, p_expenditure_organization_id  in             number   default hr_api.g_number
, p_expenditure_type             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_object_version_number        in out nocopy  number
, p_return_status                   out	nocopy  boolean
) IS
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_external_effort_line';

Line: 317


  savepoint update_external_effort_line;

Line: 335


    psp_external_effort_lines_bk2.update_external_effort_line_b
		( p_external_effort_line_id      =>   p_external_effort_line_id
		, p_batch_name                   =>   p_batch_name
		, p_distribution_date            =>   p_distribution_date
		, p_person_id                    =>   p_person_id
		, p_assignment_id                =>   p_assignment_id
		, p_currency_code                =>   p_currency_code
		, p_distribution_amount          =>   p_distribution_amount
		, p_business_group_id            =>   p_business_group_id
		, p_set_of_books_id              =>   p_set_of_books_id
		, p_gl_code_combination_id       =>   p_gl_code_combination_id
		, p_project_id                   =>   p_project_id
		, p_task_id                      =>   p_task_id
		, p_award_id                     =>   p_award_id
		, p_expenditure_organization_id  =>   p_expenditure_organization_id
		, p_expenditure_type             =>   p_expenditure_type
		, 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_object_version_number        =>   l_object_version_number
		);

Line: 372


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

Line: 424


    psp_external_effort_lines_bk2.update_external_effort_line_a
		( p_external_effort_line_id      =>   p_external_effort_line_id
		, p_batch_name                   =>   p_batch_name
		, p_distribution_date            =>   p_distribution_date
		, p_person_id                    =>   p_person_id
		, p_assignment_id                =>   p_assignment_id
		, p_currency_code                =>   p_currency_code
		, p_distribution_amount          =>   p_distribution_amount
		, p_business_group_id            =>   p_business_group_id
		, p_set_of_books_id              =>   p_set_of_books_id
		, p_gl_code_combination_id       =>   p_gl_code_combination_id
		, p_project_id                   =>   p_project_id
		, p_task_id                      =>   p_task_id
		, p_award_id                     =>   p_award_id
		, p_expenditure_organization_id  =>   p_expenditure_organization_id
		, p_expenditure_type             =>   p_expenditure_type
		, 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_object_version_number        =>   l_object_version_number
		, p_return_status                =>   l_return_status
		);

Line: 462


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

Line: 484


    rollback to update_external_effort_line;

Line: 497


    rollback to update_external_effort_line;

Line: 506


end update_external_effort_line;

Line: 516


procedure delete_external_effort_line
( p_validate                     in             boolean  default false
, p_external_effort_line_id      in             number
, p_object_version_number        in out nocopy  number
)
IS
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_effort_interface_line';

Line: 533


  savepoint delete_external_effort_line;

Line: 547


    psp_external_effort_lines_bk3.delete_external_effort_line_b
    ( p_external_effort_line_id	=>	p_external_effort_line_id
    , p_object_version_number   =>   l_object_version_number
    );

Line: 554


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

Line: 579


     psp_external_effort_lines_bk3.delete_external_effort_line_a
    ( p_external_effort_line_id	=>   p_external_effort_line_id
    , p_object_version_number   =>   l_object_version_number
    );

Line: 586


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

Line: 607


    rollback to delete_external_effort_line;

Line: 619


    rollback to delete_external_effort_line;

Line: 627


end delete_external_effort_line;

Line: 637


procedure delete_external_effort_line_batch
( p_validate                     in             boolean  default false
, p_batch_name                   in             varchar2
, p_person_id                    in             number   default hr_api.g_number
, p_assignment_id                in             number   default hr_api.g_number
, p_return_status                   out	nocopy  boolean
)
IS
  --
  -- Declare cursors and local variables
  --
  l_proc                   varchar2(72) := g_package||'delete_external_effort_line_batch';

Line: 654


  SELECT external_effort_line_id, object_version_number
  FROM   psp_external_effort_lines
  WHERE  batch_name = p_batch_name
  AND   (person_id = p_person_id OR p_person_id = hr_api.g_number)
  AND   (assignment_id=  p_assignment_id OR p_assignment_id = hr_api.g_number);

Line: 666


  savepoint delete_external_effort_line_batch;

Line: 672


    delete_effort_interface
      ( p_external_effort_line_id=>   l_external_effort_line_id
      , p_object_version_number  =>   l_object_version_number
      );

Line: 687


    rollback to delete_external_effort_line_batch;

Line: 698


    rollback to delete_external_effort_line_batch;

Line: 706


end delete_external_effort_line_batch;