1 Package ben_batch_elig_info_api AUTHID CURRENT_USER as
2 /* $Header: bebeiapi.pkh 120.0 2005/05/28 00:37:54 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_batch_elig_info >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_benefit_action_id Yes number
18 -- p_person_id Yes number
19 -- p_pgm_id No number
20 -- p_pl_id No number
21 -- p_oipl_id No number
22 -- p_elig_flag Yes varchar2
23 -- p_inelig_text No varchar2
24 -- p_business_group_id Yes number Business Group of Record
25 -- p_effective_date Yes date Session Date.
26 --
27 -- Post Success:
28 --
29 -- Out Parameters:
30 -- Name Type Description
31 -- p_batch_elig_id Yes number PK of record
32 -- p_object_version_number Yes number OVN of record
33 --
34 -- Post Failure:
35 --
36 -- Access Status:
37 -- Public.
38 --
39 -- {End Of Comments}
40 --
41 procedure create_batch_elig_info
42 (p_validate in boolean default false
43 ,p_batch_elig_id out nocopy number
44 ,p_benefit_action_id in number default null
45 ,p_person_id in number default null
46 ,p_pgm_id in number default null
47 ,p_pl_id in number default null
48 ,p_oipl_id in number default null
49 ,p_elig_flag in varchar2 default null
50 ,p_inelig_text in varchar2 default null
51 ,p_business_group_id in number default null
52 ,p_object_version_number out nocopy number
53 ,p_effective_date in date);
54 -- ----------------------------------------------------------------------------
55 -- |------------------------< update_batch_elig_info >------------------------|
56 -- ----------------------------------------------------------------------------
57 -- {Start Of Comments}
58 --
59 -- Description:
60 --
61 -- Prerequisites:
62 --
63 --
64 -- In Parameters:
65 -- Name Reqd Type Description
66 -- p_validate Yes boolean Commit or Rollback.
67 -- p_batch_elig_id Yes number PK of record
68 -- p_benefit_action_id Yes number
69 -- p_person_id Yes number
70 -- p_pgm_id No number
71 -- p_pl_id No number
72 -- p_oipl_id No number
73 -- p_elig_flag Yes varchar2
74 -- p_inelig_text No varchar2
75 -- p_business_group_id Yes number Business Group of Record
76 -- p_effective_date Yes date Session Date.
77 --
78 -- Post Success:
79 --
80 -- Name Type Description
84 --
81 -- p_object_version_number Yes number OVN of record
82 --
83 -- Post Failure:
85 -- Access Status:
86 -- Public.
87 --
88 -- {End Of Comments}
89 --
90 procedure update_batch_elig_info
91 (p_validate in boolean default false
92 ,p_batch_elig_id in number
93 ,p_benefit_action_id in number default hr_api.g_number
94 ,p_person_id in number default hr_api.g_number
95 ,p_pgm_id in number default hr_api.g_number
96 ,p_pl_id in number default hr_api.g_number
97 ,p_oipl_id in number default hr_api.g_number
98 ,p_elig_flag in varchar2 default hr_api.g_varchar2
99 ,p_inelig_text in varchar2 default hr_api.g_varchar2
100 ,p_business_group_id in number default hr_api.g_number
101 ,p_object_version_number in out nocopy number
102 ,p_effective_date in date);
103 --
104 -- ----------------------------------------------------------------------------
105 -- |------------------------< delete_batch_elig_info >------------------------|
106 -- ----------------------------------------------------------------------------
107 -- {Start Of Comments}
108 --
109 -- Description:
110 --
111 -- Prerequisites:
112 --
113 --
114 -- In Parameters:
115 -- Name Reqd Type Description
116 -- p_validate Yes boolean Commit or Rollback.
117 -- p_batch_elig_id Yes number PK of record
118 -- p_effective_date Yes date Session Date.
119 --
120 -- Post Success:
121 --
122 -- Name Type Description
123 -- p_object_version_number Yes number OVN of record
124 --
125 -- Post Failure:
126 --
127 -- Access Status:
128 -- Public.
129 --
130 -- {End Of Comments}
131 --
132 procedure delete_batch_elig_info
133 (p_validate in boolean default false
134 ,p_batch_elig_id in number
135 ,p_object_version_number in out nocopy number
136 ,p_effective_date in date);
137 --
138 -- ----------------------------------------------------------------------------
139 -- |----------------------------------< lck >---------------------------------|
140 -- ----------------------------------------------------------------------------
141 -- {Start Of Comments}
142 --
143 -- Description:
144 --
145 -- Prerequisites:
146 --
147 --
148 -- In Parameters:
149 -- Name Reqd Type Description
150 -- p_batch_elig_id Yes number PK of record
151 -- p_object_version_number Yes number OVN of record
152 --
153 -- Post Success:
154 --
155 -- Name Type Description
156 --
157 -- Post Failure:
158 --
159 -- Access Status:
160 -- Public.
161 --
162 -- {End Of Comments}
163 --
164 procedure lck
165 (p_batch_elig_id in number
166 ,p_object_version_number in number);
167 --
168 end ben_batch_elig_info_api;
[Home] [Help]