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_ORGANIZATION_ACCOUNTS_API SQL Statements

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

Line: 273


procedure update_organization_account
		( p_validate                     in     boolean  default false
		, p_organization_account_id    	in	number
		, p_gl_code_combination_id     	in	number
		, p_project_id                 	in	number
		, p_expenditure_organization_id	in	number
		, p_expenditure_type           	in	varchar2
		, p_task_id                    	in	number
		, p_award_id                   	in	number
		, p_comments                   	in	varchar2
		, p_attribute_category         	in	varchar2
		, p_attribute1                 	in	varchar2
		, p_attribute2                 	in	varchar2
		, p_attribute3                 	in	varchar2
		, p_attribute4                 	in	varchar2
		, p_attribute5                 	in	varchar2
		, p_attribute6                 	in	varchar2
		, p_attribute7                 	in	varchar2
		, p_attribute8                 	in	varchar2
		, p_attribute9                 	in	varchar2
		, p_attribute10                	in	varchar2
		, p_attribute11                	in	varchar2
		, p_attribute12                	in	varchar2
		, p_attribute13                	in	varchar2
		, p_attribute14                	in	varchar2
		, p_attribute15                	in	varchar2
		, p_set_of_books_id            	in	number
		, p_account_type_code          	in	varchar2
		, p_start_date_active          	in	date
		, p_business_group_id          	in	number
		, p_end_date_active            	in	date
		, p_organization_id            	in	number
		, p_poeta_start_date           	in	date
		, p_poeta_end_date             	in	date
		, p_funding_source_code         in      varchar2
		, p_object_version_number      	in	out nocopy	number
		, p_return_status               out	nocopy      boolean
) is
  --
  -- Declare cursors and local variables
  --
	l_object_version_number  number(9);

Line: 315


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

Line: 326


  savepoint update_organization_account;

Line: 344


    psp_organization_accounts_bk2.update_organization_account_b
		( p_organization_account_id    		=>		p_organization_account_id
		, p_gl_code_combination_id     		=>		 p_gl_code_combination_id
		, p_project_id                 		=>		 p_project_id
		, p_expenditure_organization_id		=>		 p_expenditure_organization_id
		, p_expenditure_type           		=>		 p_expenditure_type
		, p_task_id                    		=>		 p_task_id
		, p_award_id                   		=>		 p_award_id
		, 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_set_of_books_id            		=>		 p_set_of_books_id
		, p_account_type_code          		=>		 p_account_type_code
		, p_start_date_active          		=>		 l_start_date_active
		, p_business_group_id          		=>		 p_business_group_id
		, p_end_date_active            		=>		 l_end_date_active
		, p_organization_id            		=>		 p_organization_id
		, p_poeta_start_date           		=>		 l_poeta_start_date
		, p_poeta_end_date             		=>		 l_poeta_end_date
		, p_funding_source_code 	        =>	         p_funding_source_code
                );

Line: 382


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

Line: 435


     psp_organization_accounts_bk2.update_organization_account_a
		( p_organization_account_id    		=>		p_organization_account_id
		, p_gl_code_combination_id     		=>		 p_gl_code_combination_id
		, p_project_id                 		=>		 p_project_id
		, p_expenditure_organization_id		=>		 p_expenditure_organization_id
		, p_expenditure_type           		=>		 p_expenditure_type
		, p_task_id                    		=>		 p_task_id
		, p_award_id                   		=>		 p_award_id
		, 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_set_of_books_id            		=>		 p_set_of_books_id
		, p_account_type_code          		=>		 p_account_type_code
		, p_start_date_active          		=>		 l_start_date_active
		, p_business_group_id          		=>		 p_business_group_id
		, p_end_date_active            		=>		 l_end_date_active
		, p_organization_id            		=>		 p_organization_id
		, p_poeta_start_date           		=>		 l_poeta_start_date
		, p_poeta_end_date             		=>		 l_poeta_end_date
	 	, p_funding_source_code 	 =>		        p_funding_source_code
	 	);

Line: 473


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

Line: 495


    rollback to update_organization_account;

Line: 507


    rollback to update_organization_account;

Line: 515


end update_organization_account;

Line: 526


procedure delete_organization_account
  ( p_validate                     in     boolean  default false
  , p_organization_account_id    	in	number
  , p_object_version_number      	in	out nocopy	number
  , p_return_status               out	nocopy      boolean
  ) is
  --
  -- Declare cursors and local variables
  --
	l_object_version_number  number(9);

Line: 536


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

Line: 542


  savepoint delete_organization_account;

Line: 552


    psp_organization_accounts_bk3.delete_organization_account_b
    (  	 p_organization_account_id      	=>	p_organization_account_id
    );

Line: 558


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

Line: 583


     psp_organization_accounts_bk3.delete_organization_account_a
      (	 p_organization_account_id  =>	 p_organization_account_id
      );

Line: 589


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

Line: 610


    rollback to delete_organization_account;

Line: 622


    rollback to delete_organization_account;

Line: 630


end delete_organization_account;