1 PACKAGE psp_salary_caps_api AUTHID CURRENT_USER AS
2 /* $Header: PSPSCAIS.pls 120.2.12020000.2 2012/07/04 09:14:43 amnaraya ship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_salary_cap >----------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- {Start Of Comments}
9 --
10 -- Description:
11 -- Creates Salary cap for a funding source
12 --
13 -- Prerequisites:
14 -- Funding source must exist
15 --
16 -- In Parameters:
17 -- Name Reqd Type Description
18 --
19 -- p_validate no boolean Identifier for validation of salary cap
20 -- p_funding_source_code yes varchar2 Identifier for funding source code
21 -- p_start_date yes date Identifier for salary cap start date
22 -- p_end_date yes date Identifier for salary cap end date
23 -- p_currency_code yes varchar2 Identifier for currency code for salary cap
24 -- p_annual_salary_cap yes number Identifier for annual salary cap
25 -- p_seed_flag yes varchar2 Seed flag identifier for differentiation
26 -- p_object_version_number yes number Identifier for object version number
27 --
28 -- Post Success:
29 -- Funding source is created
30 --
31 --
32 -- Post Failure:
33 -- Funding source is not created and an error is raised
34 --
35 -- Access Status:
36 -- Internal Development Use Only.
37 --
38 -- {End Of Comments}
39 --
40
41 procedure create_salary_cap
42 ( p_validate in boolean default false
43 , p_funding_source_code in varchar2
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_seed_flag in varchar2
49 , p_object_version_number in out nocopy number
50 , p_salary_cap_id out nocopy number
51 , p_return_status out nocopy boolean
52 );
53 --
54 -- ----------------------------------------------------------------------------
55 -- |--------------------------< update_salary_cap >--------------------|
56 -- ----------------------------------------------------------------------------
57 --
58 -- {Start Of Comments}
59 --
60 -- Description:
61 -- Update Salary cap for a funding source
62 --
63 -- Prerequisites:
64 -- Funding source must exist
65 --
66 -- In Parameters:
67 -- Name Reqd Type Description
68 --
69 -- p_validate no boolean Identifier for validation of salary cap
70 -- p_funding_source_code yes varchar2 Identifier for funding source code
71 -- p_start_date yes date Identifier for salary cap start date
72 -- p_end_date yes date Identifier for salary cap end date
73 -- p_currency_code yes varchar2 Identifier for currency code for salary cap
74 -- p_annual_salary_cap yes number Identifier for annual salary cap
75 -- p_seed_flag yes varchar2 Seed flag identifier for differentiation
76 -- p_object_version_number yes number Identifier for object version number
77 -- p_salary_cap_id yes number Identifier for salary cap id for querying
78 --
79 -- Post Success:
80 -- Funding source is updated
81 --
82 --
83 -- Post Failure:
84 -- Funding source is not updated and an error is raised
85 --
86 -- Access Status:
87 -- Internal Development Use Only.
88 --
89 -- {End Of Comments}
90 --
91 procedure update_salary_cap
92 ( p_validate in boolean default false
93 , p_salary_cap_id in number
94 , p_funding_source_code in varchar2
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_seed_flag in varchar2
100 , p_object_version_number in out nocopy number
101 , p_return_status out nocopy boolean
102 );
103 --
104 -- ----------------------------------------------------------------------------
105 -- |--------------------------< delete_salary_cap >----------------------|
106 -- ----------------------------------------------------------------------------
107 --
108 -- {Start Of Comments}
109 --
110 -- Description:
111 -- Delete Salary cap for a funding source
112 --
113 -- Prerequisites:
114 -- none
115 --
116 -- In Parameters:
117 -- Name Reqd Type Description
118 --
119 -- p_validate no boolean Identifier for validation of salary cap
120 -- p_object_version_number yes number Identifier for object version number
121 -- p_salary_cap_id yes number Identifier for salary cap id for querying
122 --
123 -- Post Success:
124 -- Funding source is deleted
125 --
126 --
127 -- Post Failure:
128 -- Funding source is not deleted and an error is raised
129 --
130 -- Access Status:
131 -- Internal Development Use Only.
132 --
133 -- {End Of Comments}
134 --
135 procedure delete_salary_cap
136 ( p_validate in boolean default false
137 , p_salary_cap_id in number
138 , p_object_version_number in out nocopy number
139 , p_return_status out nocopy boolean
140 );
141
142 /* Procedure update_salary_cap_lct is to do updates to the data already inserted
143 into psp_salary_caps table*/
144
145 procedure update_salary_cap_lct
146 (p_old_start_date in varchar2,
147 p_old_end_date in varchar2,
148 p_new_start_date in varchar2,
149 p_new_end_date in varchar2,
150 p_old_annual_salary_cap in number,
151 p_new_annual_salary_cap in number,
152 p_funding_source_code in varchar2,
153 p_user_id in number
154 );
155 end psp_salary_caps_api;
[Home] [Help]