1 Package PQH_DE_ins_END_REASONS_API as
2 /* $Header: pqpreapi.pkh 120.0 2005/05/29 02:17:39 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< <PQH_DE_ins_END_REASONS_API> >----------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API Creates the the master definition of PENSION_END_REASONS
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 --
18 --
19 -- Post Success:
20 --
21 --
22 -- Name Type Description
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 -- Public.
29 --
30 -- {End Of Comments}
31 --
32
33 procedure Insert_PENSION_END_REASONS
34 ( p_validate in boolean default false
35 ,p_effective_date in date
36 ,p_business_group_id in number
37 ,p_provider_organization_id in number
38 ,p_end_reason_number in varchar2
39 ,p_end_reason_short_name in varchar2
40 ,p_end_reason_description in varchar2
41 ,p_ins_end_reason_id out nocopy number
42 ,p_object_version_number out nocopy number
43 ) ;
44
45 procedure Update_PENSION_END_REASONS
46 ( p_validate in boolean default false
47 ,p_effective_date in date
48 ,p_ins_end_reason_id in number
49 ,p_object_version_number in out nocopy number
50 ,p_business_group_id in number default hr_api.g_number
51 ,p_provider_organization_id in number default hr_api.g_number
52 ,p_end_reason_number in varchar2 default hr_api.g_varchar2
53 ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
54 ,p_end_reason_description in varchar2 default hr_api.g_varchar2
55 );
56
57 procedure delete_PENSION_END_REASONS
58 (p_validate in boolean default false
59 ,p_ins_end_reason_id In Number
60 ,p_object_version_number In number);
61 --
62 end PQH_DE_ins_END_REASONS_API;
[Home] [Help]