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