APPS.PQP_ERS_UPD dependencies on PQP_ERS_SHD

Line 55: (p_rec in out nocopy pqp_ers_shd.g_rec_type

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

Line 87: pqp_ers_shd.constraint_error

83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --
87: pqp_ers_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: pqp_ers_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: pqp_ers_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: pqp_ers_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: pqp_ers_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 pqp_ers_shd.g_rec_type

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

Line 181: (p_rec in pqp_ers_shd.g_rec_type

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

Line 200: -- => pqp_ers_shd.g_old_rec.exception_report_period

196: -- => p_rec.exception_report_period
197: -- ,p_object_version_number
198: -- => p_rec.object_version_number
199: -- ,p_exception_report_period_o
200: -- => pqp_ers_shd.g_old_rec.exception_report_period
201: -- ,p_object_version_number_o
202: -- => pqp_ers_shd.g_old_rec.object_version_number
203: -- );
204: null;

Line 202: -- => pqp_ers_shd.g_old_rec.object_version_number

198: -- => p_rec.object_version_number
199: -- ,p_exception_report_period_o
200: -- => pqp_ers_shd.g_old_rec.exception_report_period
201: -- ,p_object_version_number_o
202: -- => pqp_ers_shd.g_old_rec.object_version_number
203: -- );
204: null;
205: --
206: exception

Line 263: (p_rec in out nocopy pqp_ers_shd.g_rec_type

259: --
260: -- {End Of Comments}
261: -- ----------------------------------------------------------------------------
262: Procedure convert_defs
263: (p_rec in out nocopy pqp_ers_shd.g_rec_type
264: ) is
265: --
266: Begin
267: --

Line 275: pqp_ers_shd.g_old_rec.exception_report_period;

271: -- is being used then we must set to the 'current' argument value.
272: --
273: If (p_rec.exception_report_period = hr_api.g_varchar2) then
274: p_rec.exception_report_period :=
275: pqp_ers_shd.g_old_rec.exception_report_period;
276: End If;
277: --
278: End convert_defs;
279: --

Line 284: (p_rec in out nocopy pqp_ers_shd.g_rec_type

280: -- ----------------------------------------------------------------------------
281: -- |---------------------------------< upd >----------------------------------|
282: -- ----------------------------------------------------------------------------
283: Procedure upd
284: (p_rec in out nocopy pqp_ers_shd.g_rec_type
285: ) is
286: --
287: l_proc varchar2(72) := g_package||'upd';
288: --

Line 294: pqp_ers_shd.lck

290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: -- We must lock the row which we need to update.
293: --
294: pqp_ers_shd.lck
295: (p_rec.database_item_suffix
296: ,p_rec.legislation_code
297: ,p_rec.object_version_number
298: );

Line 342: l_rec pqp_ers_shd.g_rec_type;

338: ,p_object_version_number in out nocopy number
339: ,p_exception_report_period in varchar2
340: ) is
341: --
342: l_rec pqp_ers_shd.g_rec_type;
343: l_proc varchar2(72) := g_package||'upd';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);

Line 352: pqp_ers_shd.convert_args

348: -- Call conversion function to turn arguments into the
349: -- l_rec structure.
350: --
351: l_rec :=
352: pqp_ers_shd.convert_args
353: (p_database_item_suffix
354: ,p_legislation_code
355: ,p_exception_report_period
356: ,p_object_version_number