1 Package pqh_de_ins_end_reasons_swi AUTHID CURRENT_USER As
2 /* $Header: pqpreswi.pkh 115.1 2002/12/03 20:42:17 rpasapul noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------< delete_pension_end_reasons >----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqh_de_ins_end_reasons_api.delete_pension_end_reasons
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 delete_pension_end_reasons
27 (p_validate in number default hr_api.g_false_num
28 ,p_ins_end_reason_id in number
29 ,p_object_version_number in number
30 ,p_return_status out nocopy varchar2
31 );
32 -- ----------------------------------------------------------------------------
33 -- |----------------------< insert_pension_end_reasons >----------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start of comments}
36 --
37 -- Description:
38 -- This procedure is the self-service wrapper procedure to the following
39 -- API: pqh_de_ins_end_reasons_api.insert_pension_end_reasons
40 --
41 -- Pre-requisites
42 -- All 'IN' parameters to this procedure have been appropriately derived.
43 --
44 -- Post Success:
45 -- p_return_status will return value indicating success.
46 --
47 -- Post Failure:
48 -- p_return_status will return value indication failure.
49 --
50 -- Access Status:
51 -- Internal Development use only.
52 --
53 -- {End of comments}
54 -- ----------------------------------------------------------------------------
55 PROCEDURE insert_pension_end_reasons
56 (p_validate in number default hr_api.g_false_num
57 ,p_effective_date in date
58 ,p_business_group_id in number
59 ,p_provider_organization_id in number
60 ,p_end_reason_number in varchar2
61 ,p_end_reason_short_name in varchar2
62 ,p_end_reason_description in varchar2
63 ,p_ins_end_reason_id out nocopy number
64 ,p_object_version_number out nocopy number
65 ,p_return_status out nocopy varchar2
66 );
67 -- ----------------------------------------------------------------------------
68 -- |----------------------< update_pension_end_reasons >----------------------|
69 -- ----------------------------------------------------------------------------
70 -- {Start of comments}
71 --
72 -- Description:
73 -- This procedure is the self-service wrapper procedure to the following
74 -- API: pqh_de_ins_end_reasons_api.update_pension_end_reasons
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_pension_end_reasons
91 (p_validate in number default hr_api.g_false_num
92 ,p_effective_date in date
93 ,p_ins_end_reason_id in number
94 ,p_object_version_number in out nocopy number
95 ,p_business_group_id in number default hr_api.g_number
96 ,p_provider_organization_id in number default hr_api.g_number
97 ,p_end_reason_number in varchar2 default hr_api.g_varchar2
98 ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
99 ,p_end_reason_description in varchar2 default hr_api.g_varchar2
100 ,p_return_status out nocopy varchar2
101 );
102 end pqh_de_ins_end_reasons_swi;