1 PACKAGE psp_salary_cap_overrides_api AS
2 /* $Header: PSPSOAIS.pls 120.2 2006/07/06 13:27:59 tbalacha noship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_salary_cap_override >--------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- {Start Of Comments}
9 --
10 -- Description:
11 -- Creates salary cap override
12 --
13 -- Prerequisites:
14 -- Salary cap must exist for the defined date range
15 --
16 -- In Parameters:
17 -- Name Reqd Type Description
18 -- p_validate no boolean Identifier for validation of effort report line
19 -- p_funding_source_code yes varchar2 Funding Source code identifier
20 -- p_project_id yes number Identifier for Projects
21 -- p_start_date yes date Identifier for the salary cap start date
22 -- p_end_date yes date Identifier for the salary cap end date
23 -- p_currency_code yes varchar2 Currenct code identifier for the overide
24 -- p_annual_salary_cap yes number Identifier for annual cap
25 -- p_object_version_number yes number Object version number identifier
26 --
27 -- Post Success:
28 -- Salary cap override is created
29 --
30 --
31 -- Post Failure:
32 -- Salary cap override is not created and an error is raised
33 --
34 -- Access Status:
35 -- Internal Development Use Only.
36 --
37 -- {End Of Comments}
38 --
39
40 procedure create_salary_cap_override
41 (p_validate in boolean default false
42 , p_funding_source_code in varchar2
43 , p_project_id in number
44 , p_start_date in date
45 , p_end_date in date
46 , p_currency_code in varchar2
47 , p_annual_salary_cap in number
48 , p_object_version_number in out nocopy number
49 , p_salary_cap_override_id out nocopy number
50 , p_return_status out nocopy boolean
51 );
52 --
53 -- ----------------------------------------------------------------------------
54 -- |--------------------------< update_salary_cap_override >--------------------|
55 -- ----------------------------------------------------------------------------
56 --
57 -- {Start Of Comments}
58 --
59 -- Description:
60 -- Updates salary cap override
61 --
62 -- Prerequisites:
63 -- Salary cap must exist for the defined date range
64 --
65 -- In Parameters:
66 -- Name Reqd Type Description
67 -- p_validate no boolean Identifier for validation of effort report line
68 -- p_salary_cap_override_id yes number Identifier for salary cap override
69 -- p_funding_source_code yes varchar2 Funding Source code identifier
70 -- p_project_id yes number Identifier for Projects
71 -- p_start_date yes date Identifier for the salary cap start date
72 -- p_end_date yes date Identifier for the salary cap end date
73 -- p_currency_code yes varchar2 Currenct code identifier for the overide
74 -- p_annual_salary_cap yes number Identifier for annual cap
75 -- p_object_version_number yes number Object version number identifier
76 --
77 -- Post Success:
78 -- Salary cap override is updated
79 --
80 --
81 -- Post Failure:
82 -- Salary cap override is not updated and an error is raised
83 --
84 -- Access Status:
85 -- Internal Development Use Only.
86 --
87 -- {End Of Comments}
88 --
89 procedure update_salary_cap_override
90 (p_validate in boolean default false
91 , p_salary_cap_override_id in number
92 , p_funding_source_code in varchar2
93 , p_project_id in number
94 , p_start_date in date
95 , p_end_date in date
96 , p_currency_code in varchar2
97 , p_annual_salary_cap in number
98 , p_object_version_number in out nocopy number
99 , p_return_status out nocopy boolean
100 );
101 --
102 -- ----------------------------------------------------------------------------
103 -- |--------------------------< delete_salary_cap_override >----------------------|
104 -- ----------------------------------------------------------------------------
105 --
106 -- {Start Of Comments}
107 --
108 -- Description:
109 -- Delete salary cap override
110 --
111 -- Prerequisites:
112 -- None
113 --
114 -- In Parameters:
115 -- Name Reqd Type Description
116 -- p_validate no boolean Identifier for validation of effort report line
117 -- p_salary_cap_override_id yes number Identifier for salary cap override
118 -- p_object_version_number yes number Object version number identifier
119 --
120 -- Post Success:
121 -- Salary cap override is deleted
122 --
123 -- Post Failure:
124 -- Salary cap override is not deleted and an error is raised
125 --
126 -- Access Status:
127 -- Internal Development Use Only.
128 --
129 -- {End Of Comments}
130 --
131 procedure delete_salary_cap_override
132 (p_validate in boolean default false
133 , p_salary_cap_override_id in number
134 , p_object_version_number in out nocopy number
135 , p_return_status out nocopy boolean
136 );
137 end psp_salary_cap_overrides_api;