1 PACKAGE BEN_ELIG_OBJ_ELIG_PROFL_SWI AUTHID CURRENT_USER as
2 /* $Header: bebepswi.pkh 120.0 2005/05/28 00:39:45 appldev noship $ */
3 procedure create_ELIG_OBJ_ELIG_PROFL
4 (
5 p_validate in number default hr_api.g_false_num
6 ,p_elig_obj_elig_prfl_id in number
7 ,p_effective_start_date out nocopy date
8 ,p_effective_end_date out nocopy date
9 ,p_business_group_id in number default null
10 ,p_elig_obj_id in number default null
11 ,p_elig_prfl_id in number default null
12 ,p_mndtry_flag in varchar2 default 'N'
13 ,p_bep_attribute_category in varchar2 default null
14 ,p_bep_attribute1 in varchar2 default null
15 ,p_bep_attribute2 in varchar2 default null
16 ,p_bep_attribute3 in varchar2 default null
17 ,p_bep_attribute4 in varchar2 default null
18 ,p_bep_attribute5 in varchar2 default null
19 ,p_bep_attribute6 in varchar2 default null
20 ,p_bep_attribute7 in varchar2 default null
21 ,p_bep_attribute8 in varchar2 default null
22 ,p_bep_attribute9 in varchar2 default null
23 ,p_bep_attribute10 in varchar2 default null
24 ,p_bep_attribute11 in varchar2 default null
25 ,p_bep_attribute12 in varchar2 default null
26 ,p_bep_attribute13 in varchar2 default null
27 ,p_bep_attribute14 in varchar2 default null
28 ,p_bep_attribute15 in varchar2 default null
29 ,p_bep_attribute16 in varchar2 default null
30 ,p_bep_attribute17 in varchar2 default null
31 ,p_bep_attribute18 in varchar2 default null
32 ,p_bep_attribute19 in varchar2 default null
33 ,p_bep_attribute20 in varchar2 default null
34 ,p_object_version_number out nocopy number
35 ,p_effective_date in date
36 ,p_return_status out nocopy varchar2
37 );
38 -- ----------------------------------------------------------------------------
39 -- |----------------------< update_ELIG_OBJ_ELIG_PROFL >-----------------------|
40 -- ----------------------------------------------------------------------------
41 --
42 procedure update_ELIG_OBJ_ELIG_PROFL
43 (
44 p_validate in number default hr_api.g_false_num
45 ,p_elig_obj_elig_prfl_id in number
46 ,p_effective_start_date out nocopy date
47 ,p_effective_end_date out nocopy date
48 ,p_business_group_id in number default hr_api.g_number
49 ,p_elig_obj_id in number default hr_api.g_number
50 ,p_elig_prfl_id in number default hr_api.g_number
51 ,p_mndtry_flag in varchar2 default 'N'
52 ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
53 ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
54 ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
55 ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
56 ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
57 ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
58 ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
59 ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
60 ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
61 ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
62 ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
63 ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
64 ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
65 ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
66 ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
67 ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
68 ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
69 ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
70 ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
71 ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
72 ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
73 ,p_object_version_number in out nocopy number
74 ,p_effective_date in date
75 ,p_datetrack_mode in varchar2
76 ,p_return_status out nocopy varchar2
77 );
78 -- ----------------------------------------------------------------------------
79 -- |-----------------------< delete_ELIG_OBJ_ELIG_PROFL >-----------------------|
80 -- ----------------------------------------------------------------------------
81 --
82 procedure delete_ELIG_OBJ_ELIG_PROFL
83 (
84 p_validate in number default hr_api.g_false_num
85 ,p_elig_obj_elig_prfl_id in number
86 ,p_effective_start_date out nocopy date
87 ,p_effective_end_date out nocopy date
88 ,p_object_version_number in out nocopy number
89 ,p_effective_date in date
90 ,p_datetrack_mode in varchar2
91 ,p_return_status out nocopy varchar2
92 );
93 --
94 --
95 END; -- Package spec
96
[Home] [Help]