APPS.PQH_OPG_UPD dependencies on PQH_OPG_SHD

Line 55: (p_rec in out nocopy pqh_opg_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_opg_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 87: pqh_opg_shd.constraint_error

83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --
87: pqh_opg_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --

Line 92: pqh_opg_shd.constraint_error

88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
92: pqh_opg_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --

Line 97: pqh_opg_shd.constraint_error

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
97: pqh_opg_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --
101: Raise;

Line 137: (p_rec in pqh_opg_shd.g_rec_type

133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update
137: (p_rec in pqh_opg_shd.g_rec_type
138: ) is
139: --
140: l_proc varchar2(72) := g_package||'pre_update';
141: --

Line 182: ,p_rec in pqh_opg_shd.g_rec_type

178: -- {End Of Comments}
179: -- ----------------------------------------------------------------------------
180: Procedure post_update
181: (p_effective_date in date
182: ,p_rec in pqh_opg_shd.g_rec_type
183: ) is
184: --
185: l_proc varchar2(72) := g_package||'post_update';
186: --

Line 204: => pqh_opg_shd.g_old_rec.operation_group_code

200: => p_rec.business_group_id
201: ,p_object_version_number
202: => p_rec.object_version_number
203: ,p_operation_group_code_o
204: => pqh_opg_shd.g_old_rec.operation_group_code
205: ,p_description_o
206: => pqh_opg_shd.g_old_rec.description
207: ,p_business_group_id_o
208: => pqh_opg_shd.g_old_rec.business_group_id

Line 206: => pqh_opg_shd.g_old_rec.description

202: => p_rec.object_version_number
203: ,p_operation_group_code_o
204: => pqh_opg_shd.g_old_rec.operation_group_code
205: ,p_description_o
206: => pqh_opg_shd.g_old_rec.description
207: ,p_business_group_id_o
208: => pqh_opg_shd.g_old_rec.business_group_id
209: ,p_object_version_number_o
210: => pqh_opg_shd.g_old_rec.object_version_number

Line 208: => pqh_opg_shd.g_old_rec.business_group_id

204: => pqh_opg_shd.g_old_rec.operation_group_code
205: ,p_description_o
206: => pqh_opg_shd.g_old_rec.description
207: ,p_business_group_id_o
208: => pqh_opg_shd.g_old_rec.business_group_id
209: ,p_object_version_number_o
210: => pqh_opg_shd.g_old_rec.object_version_number
211: );
212: --

Line 210: => pqh_opg_shd.g_old_rec.object_version_number

206: => pqh_opg_shd.g_old_rec.description
207: ,p_business_group_id_o
208: => pqh_opg_shd.g_old_rec.business_group_id
209: ,p_object_version_number_o
210: => pqh_opg_shd.g_old_rec.object_version_number
211: );
212: --
213: exception
214: --

Line 270: (p_rec in out nocopy pqh_opg_shd.g_rec_type

266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure convert_defs
270: (p_rec in out nocopy pqh_opg_shd.g_rec_type
271: ) is
272: --
273: Begin
274: --

Line 282: pqh_opg_shd.g_old_rec.operation_group_code;

278: -- is being used then we must set to the 'current' argument value.
279: --
280: If (p_rec.operation_group_code = hr_api.g_varchar2) then
281: p_rec.operation_group_code :=
282: pqh_opg_shd.g_old_rec.operation_group_code;
283: End If;
284: If (p_rec.description = hr_api.g_varchar2) then
285: p_rec.description :=
286: pqh_opg_shd.g_old_rec.description;

Line 286: pqh_opg_shd.g_old_rec.description;

282: pqh_opg_shd.g_old_rec.operation_group_code;
283: End If;
284: If (p_rec.description = hr_api.g_varchar2) then
285: p_rec.description :=
286: pqh_opg_shd.g_old_rec.description;
287: End If;
288: If (p_rec.business_group_id = hr_api.g_number) then
289: p_rec.business_group_id :=
290: pqh_opg_shd.g_old_rec.business_group_id;

Line 290: pqh_opg_shd.g_old_rec.business_group_id;

286: pqh_opg_shd.g_old_rec.description;
287: End If;
288: If (p_rec.business_group_id = hr_api.g_number) then
289: p_rec.business_group_id :=
290: pqh_opg_shd.g_old_rec.business_group_id;
291: End If;
292: --
293: End convert_defs;
294: --

Line 300: ,p_rec in out nocopy pqh_opg_shd.g_rec_type

296: -- |---------------------------------< upd >----------------------------------|
297: -- ----------------------------------------------------------------------------
298: Procedure upd
299: (p_effective_date in date
300: ,p_rec in out nocopy pqh_opg_shd.g_rec_type
301: ) is
302: --
303: l_proc varchar2(72) := g_package||'upd';
304: --

Line 311: pqh_opg_shd.lck

307: --
308: -- We must lock the row which we need to update.
309: --
310:
311: pqh_opg_shd.lck
312: (p_rec.operation_group_id
313: ,p_rec.object_version_number
314: );
315:

Line 365: l_rec pqh_opg_shd.g_rec_type;

361: ,p_description in varchar2 default hr_api.g_varchar2
362: ,p_business_group_id in number default hr_api.g_number
363: ) is
364: --
365: l_rec pqh_opg_shd.g_rec_type;
366: l_proc varchar2(72) := g_package||'upd';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);

Line 375: pqh_opg_shd.convert_args

371: -- Call conversion function to turn arguments into the
372: -- l_rec structure.
373: --
374: l_rec :=
375: pqh_opg_shd.convert_args
376: (p_operation_group_id
377: ,p_operation_group_code
378: ,p_description
379: ,p_business_group_id