1 Package pay_pl_sii_swi AUTHID CURRENT_USER As
2 /* $Header: pypsdswi.pkh 120.0 2005/10/16 22:22 mseshadr noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-------------------------< create_pl_sii_details >------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pay_pl_sii_api.create_pl_sii_details
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_pl_sii_details
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_contract_category in varchar2
30 ,p_per_or_asg_id in number
31 ,p_business_group_id in number
32 ,p_emp_social_security_info in varchar2
33 ,p_old_age_contribution in varchar2 default null
34 ,p_pension_contribution in varchar2 default null
35 ,p_sickness_contribution in varchar2 default null
36 ,p_work_injury_contribution in varchar2 default null
37 ,p_labor_contribution in varchar2 default null
38 ,p_health_contribution in varchar2 default null
39 ,p_unemployment_contribution in varchar2 default null
40 ,p_old_age_cont_end_reason in varchar2 default null
41 ,p_pension_cont_end_reason in varchar2 default null
42 ,p_sickness_cont_end_reason in varchar2 default null
43 ,p_work_injury_cont_end_reason in varchar2 default null
44 ,p_labor_fund_cont_end_reason in varchar2 default null
45 ,p_health_cont_end_reason in varchar2 default null
46 ,p_unemployment_cont_end_reason in varchar2 default null
47 ,p_sii_details_id in number
48 ,p_object_version_number out nocopy number
49 ,p_effective_start_date out nocopy date
50 ,p_effective_end_date out nocopy date
51 ,p_return_status out nocopy varchar2
52 ,p_effective_date_warning out nocopy boolean
53 );
54 -- ----------------------------------------------------------------------------
55 -- |-------------------------< update_pl_sii_details >------------------------|
56 -- ----------------------------------------------------------------------------
57 -- {Start of comments}
58 --
59 -- Description:
60 -- This procedure is the self-service wrapper procedure to the following
61 -- API: pay_pl_sii_api.update_pl_sii_details
62 --
63 -- Pre-requisites
64 -- All 'IN' parameters to this procedure have been appropriately derived.
65 --
66 -- Post Success:
67 -- p_return_status will return value indicating success.
68 --
69 -- Post Failure:
70 -- p_return_status will return value indication failure.
71 --
72 -- Access Status:
73 -- Internal Development use only.
74 --
75 -- {End of comments}
76 -- ----------------------------------------------------------------------------
77 PROCEDURE update_pl_sii_details
78 (p_validate in number default hr_api.g_false_num
79 ,p_effective_date in date
80 ,p_datetrack_update_mode in varchar2
81 ,p_sii_details_id in number
82 ,p_object_version_number in out nocopy number
83 ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
84 ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
85 ,p_pension_contribution in varchar2 default hr_api.g_varchar2
86 ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
87 ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
88 ,p_labor_contribution in varchar2 default hr_api.g_varchar2
89 ,p_health_contribution in varchar2 default hr_api.g_varchar2
90 ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
91 ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
92 ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
93 ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
94 ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
95 ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
96 ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
97 ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
98 ,p_effective_start_date out nocopy date
99 ,p_effective_end_date out nocopy date
100 ,p_return_status out nocopy varchar2
101 );
102 -- ----------------------------------------------------------------------------
103 -- |-------------------------< delete_pl_sii_details >------------------------|
104 -- ----------------------------------------------------------------------------
105 -- {Start of comments}
106 --
107 -- Description:
108 -- This procedure is the self-service wrapper procedure to the following
109 -- API: pay_pl_sii_api.delete_pl_sii_details
110 --
111 -- Pre-requisites
112 -- All 'IN' parameters to this procedure have been appropriately derived.
113 --
114 -- Post Success:
115 -- p_return_status will return value indicating success.
116 --
117 -- Post Failure:
118 -- p_return_status will return value indication failure.
119 --
120 -- Access Status:
121 -- Internal Development use only.
122 --
123 -- {End of comments}
124 -- ----------------------------------------------------------------------------
125 PROCEDURE delete_pl_sii_details
126 (p_validate in number default hr_api.g_false_num
127 ,p_effective_date in date
128 ,p_datetrack_delete_mode in varchar2
129 ,p_sii_details_id in number
130 ,p_object_version_number in out nocopy number
131 ,p_effective_start_date out nocopy date
132 ,p_effective_end_date out nocopy date
133 ,p_return_status out nocopy varchar2
134 );
135 end pay_pl_sii_swi;