APPS.PSP_SALARY_CAPS_API SQL Statements

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

Line: 165

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

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

Line: 189

  savepoint update_salary_cap;

Line: 205

    psp_salary_caps_bk2.update_salary_cap_b
		  ( p_salary_cap_id             =>     p_salary_cap_id
		  , p_funding_source_code       =>     p_funding_source_code
		  , p_start_date         	=>     l_start_date
		  , p_end_date           	=>     l_end_date
		  , p_currency_code      	=>     p_currency_code
		  , p_annual_salary_cap  	=>     p_annual_salary_cap
		  , p_seed_flag          	=>     p_seed_flag
		  );

Line: 217

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

Line: 244

     psp_salary_caps_bk2.update_salary_cap_a
		  ( p_salary_cap_id             =>     p_salary_cap_id
		  , p_funding_source_code       =>     p_funding_source_code
		  , p_start_date         	=>     l_start_date
		  , p_end_date           	=>     l_end_date
		  , p_currency_code      	=>     p_currency_code
		  , p_annual_salary_cap  	=>     p_annual_salary_cap
		  , p_seed_flag          	=>     p_seed_flag
		  );

Line: 256

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

Line: 278

    rollback to update_salary_cap;

Line: 290

    rollback to update_salary_cap;

Line: 298

end update_salary_cap;

Line: 309

procedure delete_salary_cap
  ( p_validate                  in     boolean  default false
  , p_salary_cap_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';

Line: 325

  savepoint delete_salary_cap;

Line: 335

    psp_salary_caps_bk3.delete_salary_cap_b
    (  	 p_salary_cap_id      	=>	p_salary_cap_id
    );

Line: 341

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

Line: 366

     psp_salary_caps_bk3.delete_salary_cap_a
      (	 p_salary_cap_id  =>	 p_salary_cap_id
      );

Line: 372

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

Line: 393

    rollback to delete_salary_cap;

Line: 405

    rollback to delete_salary_cap;

Line: 413

end delete_salary_cap;

Line: 415

/* procedure update_salary_cap_lct is to do the updations to the data on the table psp_salry_caps*/

procedure update_salary_cap_lct
(p_old_start_date in varchar2,
p_old_end_date in varchar2,
p_new_start_date in varchar2,
p_new_end_date in varchar2,
p_old_annual_salary_cap	in number,
p_new_annual_salary_cap	in number,
p_funding_source_code in varchar2,
p_user_id in number
) is

cursor c_salary_caps(p_old_start_date varchar2, p_old_end_date varchar2) is
select salary_cap_id
from psp_salary_caps
where trunc(start_date) = to_date(p_old_start_date,'DD/MM/YYYY')
and trunc(end_date) = to_date(p_old_end_date,'DD/MM/YYYY');

Line: 447

	update psp_salary_caps
	set start_date = to_date(p_new_start_date,'DD/MM/YYYY')
		,end_date = to_date(p_new_end_date,'DD/MM/YYYY')
		,annual_salary_cap = p_new_annual_salary_cap
	where salary_cap_id = l_salary_cap_id
	and seed_flag = 'Y'
	and funding_source_code = 'NIH';

Line: 461

end update_salary_cap_lct;