APPS.PSP_SALARY_CAP_OVERRIDES_API SQL Statements

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

Line: 165

procedure update_salary_cap_override
  ( p_validate                   in     boolean  default false
  , p_salary_cap_override_id	in	number
  , p_funding_source_code    	in	varchar2
  , p_project_id             	in	number
  , p_start_date             	in	date
  , p_end_date               	in	date
  , p_currency_code          	in	varchar2
  , p_annual_salary_cap      	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: 181

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

Line: 189

  savepoint update_salary_cap_override;

Line: 205

    psp_salary_cap_overrides_bk2.update_salary_cap_override_b
		  ( p_salary_cap_override_id		=>	p_salary_cap_override_id
		  , p_funding_source_code    		=>	p_funding_source_code
		  , p_project_id             		=>	p_project_id
		  , p_start_date             		=>	p_start_date
		  , p_end_date               		=>	p_end_date
		  , p_currency_code          		=>	p_currency_code
		  , p_annual_salary_cap      		=>	p_annual_salary_cap
		  );

Line: 217

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

Line: 244

     psp_salary_cap_overrides_bk2.update_salary_cap_override_a
		  ( p_salary_cap_override_id		=>	p_salary_cap_override_id
		  , p_funding_source_code    		=>	p_funding_source_code
		  , p_project_id             		=>	p_project_id
		  , p_start_date             		=>	p_start_date
		  , p_end_date               		=>	p_end_date
		  , p_currency_code          		=>	p_currency_code
		  , p_annual_salary_cap      		=>	p_annual_salary_cap
		  );

Line: 256

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

Line: 278

    rollback to update_salary_cap_override;

Line: 290

    rollback to update_salary_cap_override;

Line: 298

end update_salary_cap_override;

Line: 309

procedure delete_salary_cap_override
  ( p_validate                     in  boolean  default false
  , p_salary_cap_override_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: 319

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

Line: 325

  savepoint delete_salary_cap_override;

Line: 335

    psp_salary_cap_overrides_bk3.delete_salary_cap_override_b
    (  	 p_salary_cap_override_id      	=>	p_salary_cap_override_id
    );

Line: 341

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

Line: 366

     psp_salary_cap_overrides_bk3.delete_salary_cap_override_a
      (	 p_salary_cap_override_id  =>	 p_salary_cap_override_id
      );

Line: 372

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

Line: 393

    rollback to delete_salary_cap_override;

Line: 405

    rollback to delete_salary_cap_override;

Line: 413

end delete_salary_cap_override;