APPS.PQP_ERS_INS dependencies on PQP_ERS_SHD

Line 80: (p_rec in out nocopy pqp_ers_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure insert_dml
80: (p_rec in out nocopy pqp_ers_shd.g_rec_type
81: ) is
82: --
83: l_proc varchar2(72) := g_package||'insert_dml';
84: --

Line 113: pqp_ers_shd.constraint_error

109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: pqp_ers_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --

Line 118: pqp_ers_shd.constraint_error

114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: pqp_ers_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --

Line 123: pqp_ers_shd.constraint_error

119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: pqp_ers_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: --
127: Raise;

Line 168: (p_rec in out nocopy pqp_ers_shd.g_rec_type

164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure pre_insert
168: (p_rec in out nocopy pqp_ers_shd.g_rec_type
169: ) is
170: --
171:
172: Cursor C_Sel2 is

Line 250: (p_rec in pqp_ers_shd.g_rec_type

246: --
247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure post_insert
250: (p_rec in pqp_ers_shd.g_rec_type
251: ) is
252: --
253: l_proc varchar2(72) := g_package||'post_insert';
254: --

Line 288: (p_rec in out nocopy pqp_ers_shd.g_rec_type

284: -- ----------------------------------------------------------------------------
285: -- |---------------------------------< ins >----------------------------------|
286: -- ----------------------------------------------------------------------------
287: Procedure ins
288: (p_rec in out nocopy pqp_ers_shd.g_rec_type
289: ) is
290: --
291: l_proc varchar2(72) := g_package||'ins';
292: --

Line 335: l_rec pqp_ers_shd.g_rec_type;

331: ,p_legislation_code in varchar2
332: ,p_object_version_number out nocopy number
333: ) is
334: --
335: l_rec pqp_ers_shd.g_rec_type;
336: l_proc varchar2(72) := g_package||'ins';
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);

Line 345: pqp_ers_shd.convert_args

341: -- Call conversion function to turn arguments into the
342: -- p_rec structure.
343: --
344: l_rec :=
345: pqp_ers_shd.convert_args
346: (p_database_item_suffix
347: ,p_legislation_code
348: ,p_exception_report_period
349: ,null