[Home] [Help]
PACKAGE: APPS.BEN_BATCH_RANGES_API
Source
1 Package ben_batch_ranges_api AUTHID CURRENT_USER as
2 /* $Header: beranapi.pkh 115.4 2002/12/11 11:35:36 lakrish ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_batch_ranges >---------------------------|
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_range_status_cd Yes varchar2
19 -- p_starting_person_action_id Yes number
20 -- p_ending_person_action_id Yes number
21 -- p_effective_date Yes date Session Date.
22 --
23 -- Post Success:
24 --
25 -- Out Parameters:
26 -- Name Type Description
27 -- p_range_id Yes number PK of record
28 -- p_object_version_number No number OVN of record
29 --
30 -- Post Failure:
31 --
32 -- Access Status:
33 -- Public.
34 --
35 -- {End Of Comments}
36 --
37 procedure create_batch_ranges
38 (p_validate in boolean default false
39 ,p_range_id out nocopy number
40 ,p_benefit_action_id in number default null
41 ,p_range_status_cd in varchar2 default null
42 ,p_starting_person_action_id in number default null
43 ,p_ending_person_action_id in number default null
44 ,p_object_version_number out nocopy number
45 ,p_effective_date in date);
46 -- ----------------------------------------------------------------------------
47 -- |------------------------< update_batch_ranges >---------------------------|
48 -- ----------------------------------------------------------------------------
49 -- {Start Of Comments}
50 --
51 -- Description:
52 --
53 -- Prerequisites:
54 --
55 --
56 -- In Parameters:
57 -- Name Reqd Type Description
58 -- p_validate Yes boolean Commit or Rollback.
59 -- p_range_id Yes number PK of record
60 -- p_benefit_action_id Yes number
61 -- p_range_status_cd Yes varchar2
62 -- p_starting_person_action_id Yes number
63 -- p_ending_person_action_id Yes number
64 -- p_effective_date Yes date Session Date.
65 --
66 -- Post Success:
67 --
68 -- Name Type Description
69 -- p_object_version_number No number OVN of record
70 --
71 -- Post Failure:
72 --
73 -- Access Status:
74 -- Public.
75 --
76 -- {End Of Comments}
77 --
78 procedure update_batch_ranges
79 (p_validate in boolean default false
80 ,p_range_id in number
81 ,p_benefit_action_id in number default hr_api.g_number
82 ,p_range_status_cd in varchar2 default hr_api.g_varchar2
83 ,p_starting_person_action_id in number default hr_api.g_number
84 ,p_ending_person_action_id in number default hr_api.g_number
85 ,p_object_version_number in out nocopy number
86 ,p_effective_date in date);
87 --
88 -- ----------------------------------------------------------------------------
89 -- |------------------------< delete_batch_ranges >---------------------------|
90 -- ----------------------------------------------------------------------------
91 -- {Start Of Comments}
92 --
93 -- Description:
94 --
95 -- Prerequisites:
96 --
97 --
98 -- In Parameters:
99 -- Name Reqd Type Description
100 -- p_validate Yes boolean Commit or Rollback.
101 -- p_range_id Yes number PK of record
102 -- p_effective_date Yes date Session Date.
103 --
104 -- Post Success:
105 --
106 -- Name Type Description
107 -- p_object_version_number No number OVN of record
108 --
109 -- Post Failure:
110 --
111 -- Access Status:
112 -- Public.
113 --
114 -- {End Of Comments}
115 --
116 procedure delete_batch_ranges
117 (p_validate in boolean default false
118 ,p_range_id in number
119 ,p_object_version_number in out nocopy number
120 ,p_effective_date in date);
121 --
122 -- ----------------------------------------------------------------------------
123 -- |----------------------------------< lck >---------------------------------|
124 -- ----------------------------------------------------------------------------
125 -- {Start Of Comments}
126 --
127 -- Description:
128 --
129 -- Prerequisites:
130 --
131 --
132 -- In Parameters:
133 -- Name Reqd Type Description
134 -- p_range_id Yes number PK of record
135 -- p_object_version_number Yes number OVN of record
136 --
137 -- Post Success:
138 --
139 -- Name Type Description
140 --
141 -- Post Failure:
142 --
143 -- Access Status:
144 -- Public.
145 --
146 -- {End Of Comments}
147 --
148 procedure lck
149 (p_range_id in number
150 ,p_object_version_number in number);
151 --
152 end ben_batch_ranges_api;