APPS.PSP_SALARY_CAPS_API dependencies on PSP_SALARY_CAPS

Line 1: Package Body psp_salary_caps_api as

1: Package Body psp_salary_caps_api as
2: /* $Header: PSPSCAIB.pls 120.0.12020000.2 2012/07/04 09:13:37 amnaraya ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' psp_salary_caps_api.';

2: /* $Header: PSPSCAIB.pls 120.0.12020000.2 2012/07/04 09:13:37 amnaraya ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' psp_salary_caps_api.';
7: p_legislation_code varchar(50):=hr_api.userenv_lang;
8:
9: --
10: -- ----------------------------------------------------------------------------

Line 56: psp_salary_caps_bk1.create_salary_cap_b

52: --
53: -- Call Before Process User Hook
54: --
55: begin
56: psp_salary_caps_bk1.create_salary_cap_b
57: ( p_funding_source_code => p_funding_source_code
58: , p_start_date => l_start_date
59: , p_end_date => l_end_date
60: , p_currency_code => p_currency_code

Line 96: psp_salary_caps_bk1.create_salary_cap_a

92: --
93: -- Call After Process User Hook
94: --
95: begin
96: psp_salary_caps_bk1.create_salary_cap_a
97: ( p_salary_cap_id => p_salary_cap_id
98: , p_funding_source_code => p_funding_source_code
99: , p_start_date => l_start_date
100: , p_end_date => l_end_date

Line 205: psp_salary_caps_bk2.update_salary_cap_b

201: --
202: -- Call Before Process User Hook
203: --
204: begin
205: psp_salary_caps_bk2.update_salary_cap_b
206: ( p_salary_cap_id => p_salary_cap_id
207: , p_funding_source_code => p_funding_source_code
208: , p_start_date => l_start_date
209: , p_end_date => l_end_date

Line 244: psp_salary_caps_bk2.update_salary_cap_a

240: --
241: -- Call After Process User Hook
242: --
243: begin
244: psp_salary_caps_bk2.update_salary_cap_a
245: ( p_salary_cap_id => p_salary_cap_id
246: , p_funding_source_code => p_funding_source_code
247: , p_start_date => l_start_date
248: , p_end_date => l_end_date

Line 335: psp_salary_caps_bk3.delete_salary_cap_b

331: --
332: -- Call Before Process User Hook
333: --
334: begin
335: psp_salary_caps_bk3.delete_salary_cap_b
336: ( p_salary_cap_id => p_salary_cap_id
337: );
338: exception
339: when hr_api.cannot_find_prog_unit then

Line 366: psp_salary_caps_bk3.delete_salary_cap_a

362: --
363: -- Call After Process User Hook
364: --
365: begin
366: psp_salary_caps_bk3.delete_salary_cap_a
367: ( p_salary_cap_id => p_salary_cap_id
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then

Line 430: from psp_salary_caps

426: ) is
427:
428: cursor c_salary_caps(p_old_start_date varchar2, p_old_end_date varchar2) is
429: select salary_cap_id
430: from psp_salary_caps
431: where trunc(start_date) = to_date(p_old_start_date,'DD/MM/YYYY')
432: and trunc(end_date) = to_date(p_old_end_date,'DD/MM/YYYY');
433:
434: l_salary_cap_id number;

Line 447: update psp_salary_caps

443:
444: if c_salary_caps%FOUND
445: then
446:
447: update psp_salary_caps
448: set start_date = to_date(p_new_start_date,'DD/MM/YYYY')
449: ,end_date = to_date(p_new_end_date,'DD/MM/YYYY')
450: ,annual_salary_cap = p_new_annual_salary_cap
451: where salary_cap_id = l_salary_cap_id

Line 463: end psp_salary_caps_api;

459: commit;
460:
461: end update_salary_cap_lct;
462:
463: end psp_salary_caps_api;