1 Package pay_ie_sb_api AUTHID CURRENT_USER as
2 /* $Header: pyisbapi.pkh 120.0 2005/05/29 06:01:35 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< CREATE_IE_SB_DETAILS >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 ----------------------- ---- ---- -----------
18 -- p_validate N IN default false
19 -- p_effective_date Y IN
20 -- p_assignment_id Y IN
21 -- p_absence_start_date Y IN
22 -- p_absence_end_date Y IN
23 -- p_benefit_amount Y IN
24 -- p_benefit_type Y IN
25 -- p_calculation_option Y IN
26 -- p_reduced_tax_credit N IN default null
27 -- p_reduced_standard_cutoff N IN default null
28 -- p_incident_id N IN default null
29 -- p_social_benefit_id Y OUT
30 -- p_object_version_number Y OUT
31 -- p_effective_start_date Y OUT
32 -- p_effective_end_date Y OUT
33 --
34 --
35 -- Post Success:
36 --
37 --
38 -- Name Type Description
39 -- ---- ---- -----------
40 -- p_social_benefit_id out number
41 -- p_object_version_number out number
42 -- p_effective_start_date out date
43 -- p_effective_end_date out date
44 --
45 -- Post Failure:
46 --
47 --
48 -- Access Status:
49 -- Public.
50 --
51 -- {End Of Comments}
52 --
53 procedure create_ie_sb_details
54 (p_validate in boolean default false
55 ,p_effective_date in date
56 ,p_assignment_id in number
57 ,p_absence_start_date in date
58 ,p_absence_end_date in date
59 ,p_benefit_amount in number
60 ,p_benefit_type in varchar2
61 ,p_calculation_option in varchar2
62 ,p_reduced_tax_credit in number default null
63 ,p_reduced_standard_cutoff in number default null
64 ,p_incident_id in number default null
65 ,p_social_benefit_id out nocopy number
66 ,p_object_version_number out nocopy number
67 ,p_effective_start_date out nocopy date
68 ,p_effective_end_date out nocopy date
69 );
70 --
71 -- ----------------------------------------------------------------------------
72 -- |--------------------------< UPDATE_IE_SB_DETAILS >--------------------------|
73 -- ----------------------------------------------------------------------------
74 -- {Start Of Comments}
75 --
76 -- Description:
77 --
78 --
79 -- Prerequisites:
80 --
81 --
82 -- In Parameters:
83 -- Name Reqd Type Description
84 ----------------------- ---- ---- -----------
85 -- p_validate N IN default false
86 -- p_effective_date Y IN
87 -- p_datetrack_update_mode Y IN
88 -- p_absence_start_date Y IN
89 -- p_absence_end_date Y IN
90 -- p_benefit_amount Y IN
91 -- p_benefit_type Y IN
92 -- p_calculation_option Y IN
93 -- p_reduced_tax_credit N IN default null
94 -- p_reduced_standard_cutoff N IN default null
95 -- p_incident_id N IN default null
96 -- p_social_benefit_id Y IN
97 -- p_object_version_number Y IN OUT
98 -- p_effective_start_date Y OUT
99 -- p_effective_end_date Y OUT
100 --
101 --
102 -- Post Success:
103 --
104 --
105 -- Name Type Description
106 -- ---- ---- -----------
107 -- p_object_version_number IN OUT number
108 -- p_effective_start_date OUT date
109 -- p_effective_end_date OUT date
110 --
111 -- Post Failure:
112 --
113 --
114 -- Access Status:
115 -- Public.
116 --
117 -- {End Of Comments}
118 --
119 procedure update_ie_sb_details
120 (p_validate in boolean default false
121 ,p_effective_date in date
122 ,p_datetrack_update_mode in varchar2
123 ,p_absence_start_date in date default hr_api.g_date
124 ,p_absence_end_date in date default hr_api.g_date
125 ,p_benefit_amount in number default hr_api.g_number
126 ,p_benefit_type in varchar2 default hr_api.g_varchar2
127 ,p_calculation_option in varchar2 default hr_api.g_varchar2
128 ,p_reduced_tax_credit in number default hr_api.g_number
129 ,p_reduced_standard_cutoff in number default hr_api.g_number
130 ,p_incident_id in number default hr_api.g_number
131 ,p_social_benefit_id in number
132 ,p_object_version_number in out nocopy number
133 ,p_effective_start_date out nocopy date
134 ,p_effective_end_date out nocopy date
135 );
136 --
137 -- ----------------------------------------------------------------------------
138 -- |------------------------< DELETE_IE_SB_DETAILS >------------------------|
139 -- ----------------------------------------------------------------------------
140 -- {Start Of Comments}
141 --
142 -- Description: This process deletes Social Benefits details.
143 --
144 --
145 -- Prerequisites: pay_isb_del.del row handler for pay_ie_social_benefits_f table.
146 --
147 --
148 -- In Parameters:
149 -- Name Type Reqd Description
150 -- ------------------------------ ------- ------ ------------
151 -- P_VALIDATE IN N Default false
152 -- P_EFFECTIVE_DATE IN Y
153 -- P_DATETRACK_DELETE_MODE IN Y
154 -- P_SOCIAL_BENEFIT_ID IN Y
155 -- P_OBJECT_VERSION_NUMBER IN OUT
156 --
157 --
158 -- Post Success:
159 --
160 --
161 -- Name Type Description
162 -- ------------------------------ ------- -------------------
163 -- P_OBJECT_VERSION_NUMBER IN OUT
164 -- P_EFFECTIVE_START_DATE OUT
165 -- P_EFFECTIVE_END_DATE OUT
166 --
167 -- Post Failure:
168 --
169 --
170 -- Access Status:
171 -- Public.
172 --
173 -- {End Of Comments}--
174 procedure delete_ie_sb_details
175 (p_validate in boolean default false
176 ,p_effective_date in date
177 ,p_datetrack_delete_mode in varchar2
178 ,p_social_benefit_id in number
179 ,p_object_version_number in out nocopy number
180 ,p_effective_start_date out nocopy date
181 ,p_effective_end_date out nocopy date
182 );
183 --
184
185 end pay_ie_sb_api;