1 Package ben_batch_parameter_api as
2 /* $Header: bebbpapi.pkh 120.0 2005/05/28 00:33:50 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_batch_parameter >------------------------|
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_batch_exe_cd No varchar2
18 -- p_thread_cnt_num No number
19 -- p_max_err_num No number
20 -- p_chunk_size No number
21 -- p_business_group_id Yes number Business Group of Record
22 -- p_effective_date Yes date Session Date.
23 --
24 -- Post Success:
25 --
26 -- Out Parameters:
27 -- Name Type Description
28 -- p_batch_parameter_id Yes number PK of record
29 -- p_object_version_number No number OVN of record
30 --
31 -- Post Failure:
32 --
33 -- Access Status:
34 -- Public.
35 --
36 -- {End Of Comments}
37 --
38 procedure create_batch_parameter
39 (p_validate in boolean default false
40 ,p_batch_parameter_id out nocopy number
41 ,p_batch_exe_cd in varchar2 default null
42 ,p_thread_cnt_num in number default null
43 ,p_max_err_num in number default null
44 ,p_chunk_size in number default null
45 ,p_business_group_id in number default null
46 ,p_object_version_number out nocopy number
47 ,p_effective_date in date);
48 -- ----------------------------------------------------------------------------
49 -- |------------------------< update_batch_parameter >------------------------|
50 -- ----------------------------------------------------------------------------
51 -- {Start Of Comments}
52 --
53 -- Description:
54 --
55 -- Prerequisites:
56 --
57 --
58 -- In Parameters:
59 -- Name Reqd Type Description
60 -- p_validate Yes boolean Commit or Rollback.
61 -- p_batch_parameter_id Yes number PK of record
62 -- p_batch_exe_cd No varchar2
63 -- p_thread_cnt_num No number
64 -- p_max_err_num No number
65 -- p_chunk_size No number
66 -- p_business_group_id Yes number Business Group of Record
67 -- p_effective_date Yes date Session Date.
68 --
69 -- Post Success:
70 --
71 -- Name Type Description
72 -- p_object_version_number No number OVN of record
73 --
74 -- Post Failure:
75 --
76 -- Access Status:
77 -- Public.
78 --
79 -- {End Of Comments}
80 --
81 procedure update_batch_parameter
82 (p_validate in boolean default false
83 ,p_batch_parameter_id in number
84 ,p_batch_exe_cd in varchar2 default hr_api.g_varchar2
85 ,p_thread_cnt_num in number default hr_api.g_number
86 ,p_max_err_num in number default hr_api.g_number
87 ,p_chunk_size in number default hr_api.g_number
88 ,p_business_group_id in number default hr_api.g_number
89 ,p_object_version_number in out nocopy number
90 ,p_effective_date in date);
91 --
92 -- ----------------------------------------------------------------------------
93 -- |------------------------< delete_batch_parameter >------------------------|
94 -- ----------------------------------------------------------------------------
95 -- {Start Of Comments}
96 --
97 -- Description:
98 --
99 -- Prerequisites:
100 --
101 --
102 -- In Parameters:
103 -- Name Reqd Type Description
104 -- p_validate Yes boolean Commit or Rollback.
105 -- p_batch_parameter_id Yes number PK of record
106 -- p_effective_date Yes date Session Date.
107 --
108 -- Post Success:
109 --
110 -- Name Type Description
111 -- p_object_version_number No number OVN of record
112 --
113 -- Post Failure:
114 --
115 -- Access Status:
116 -- Public.
117 --
118 -- {End Of Comments}
119 --
120 procedure delete_batch_parameter
121 (p_validate in boolean default false
122 ,p_batch_parameter_id in number
123 ,p_object_version_number in out nocopy number
124 ,p_effective_date in date);
125 --
126 -- ----------------------------------------------------------------------------
127 -- |----------------------------------< lck >---------------------------------|
128 -- ----------------------------------------------------------------------------
129 -- {Start Of Comments}
130 --
131 -- Description:
132 --
133 -- Prerequisites:
134 --
135 --
136 -- In Parameters:
137 -- Name Reqd Type Description
138 -- p_batch_parameter_id Yes number PK of record
139 -- p_object_version_number Yes number OVN of record
140 --
141 -- Post Success:
142 --
143 -- Name Type Description
144 --
145 -- Post Failure:
146 --
147 -- Access Status:
148 -- Public.
149 --
150 -- {End Of Comments}
151 --
152 procedure lck
153 (p_batch_parameter_id in number
154 ,p_object_version_number in number);
155 --
156 end ben_batch_parameter_api;