1 Package psp_salary_cap_overrides_swi As
2 /* $Header: PSPSOSWS.pls 120.0 2005/11/20 23:56 dpaudel noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------< create_salary_cap_override >----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: psp_salary_cap_overrides_api.create_salary_cap_override
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_salary_cap_override
27 (p_validate in number default hr_api.g_false_num
28 ,p_funding_source_code in varchar2
29 ,p_project_id in number
30 ,p_start_date in date
31 ,p_end_date in date
32 ,p_currency_code in varchar2
33 ,p_annual_salary_cap in number
34 ,p_object_version_number in out nocopy number
35 ,p_salary_cap_override_id in number
36 ,p_return_status out nocopy varchar2
37 );
38 -- ----------------------------------------------------------------------------
39 -- |----------------------< delete_salary_cap_override >----------------------|
40 -- ----------------------------------------------------------------------------
41 -- {Start of comments}
42 --
43 -- Description:
44 -- This procedure is the self-service wrapper procedure to the following
45 -- API: psp_salary_cap_overrides_api.delete_salary_cap_override
46 --
47 -- Pre-requisites
48 -- All 'IN' parameters to this procedure have been appropriately derived.
49 --
50 -- Post Success:
51 -- p_return_status will return value indicating success.
52 --
53 -- Post Failure:
54 -- p_return_status will return value indication failure.
55 --
56 -- Access Status:
57 -- Internal Development use only.
58 --
59 -- {End of comments}
60 -- ----------------------------------------------------------------------------
61 PROCEDURE delete_salary_cap_override
62 (p_validate in number default hr_api.g_false_num
63 ,p_salary_cap_override_id in number
64 ,p_object_version_number in out nocopy number
65 ,p_return_status out nocopy varchar2
66 );
67 -- ----------------------------------------------------------------------------
68 -- |----------------------< update_salary_cap_override >----------------------|
69 -- ----------------------------------------------------------------------------
70 -- {Start of comments}
71 --
72 -- Description:
73 -- This procedure is the self-service wrapper procedure to the following
74 -- API: psp_salary_cap_overrides_api.update_salary_cap_override
75 --
76 -- Pre-requisites
77 -- All 'IN' parameters to this procedure have been appropriately derived.
78 --
79 -- Post Success:
80 -- p_return_status will return value indicating success.
81 --
82 -- Post Failure:
83 -- p_return_status will return value indication failure.
84 --
85 -- Access Status:
86 -- Internal Development use only.
87 --
88 -- {End of comments}
89 -- ----------------------------------------------------------------------------
90 PROCEDURE update_salary_cap_override
91 (p_validate in number default hr_api.g_false_num
92 ,p_salary_cap_override_id in number
93 ,p_funding_source_code in varchar2
94 ,p_project_id in number
95 ,p_start_date in date
96 ,p_end_date in date
97 ,p_currency_code in varchar2
98 ,p_annual_salary_cap in number
99 ,p_object_version_number in out nocopy number
100 ,p_return_status out nocopy varchar2
101 );
102 end psp_salary_cap_overrides_swi;