APPS.PQH_RMV_INS dependencies on PQH_RMV_SHD

Line 124: (p_rec in out nocopy pqh_rmv_shd.g_rec_type

120: --
121: -- {End Of Comments}
122: -- ----------------------------------------------------------------------------
123: Procedure insert_dml
124: (p_rec in out nocopy pqh_rmv_shd.g_rec_type
125: ) is
126: --
127: l_proc varchar2(72) := g_package||'insert_dml';
128: --

Line 185: pqh_rmv_shd.constraint_error

181: Exception
182: When hr_api.check_integrity_violated Then
183: -- A check constraint has been violated
184: --
185: pqh_rmv_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.parent_integrity_violated Then
188: -- Parent integrity has been violated
189: --

Line 190: pqh_rmv_shd.constraint_error

186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.parent_integrity_violated Then
188: -- Parent integrity has been violated
189: --
190: pqh_rmv_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --

Line 195: pqh_rmv_shd.constraint_error

191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: pqh_rmv_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When Others Then
198: --
199: Raise;

Line 240: (p_rec in out nocopy pqh_rmv_shd.g_rec_type

236: --
237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure pre_insert
240: (p_rec in out nocopy pqh_rmv_shd.g_rec_type
241: ) is
242: --
243: Cursor C_Sel1 is select pqh_rt_matrix_node_values_s.nextval from sys.dual;
244: --

Line 327: (p_rec in pqh_rmv_shd.g_rec_type

323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure post_insert
327: (p_rec in pqh_rmv_shd.g_rec_type
328: ) is
329: --
330: l_proc varchar2(72) := g_package||'post_insert';
331: --

Line 398: (p_rec in out nocopy pqh_rmv_shd.g_rec_type

394: -- ----------------------------------------------------------------------------
395: -- |---------------------------------< ins >----------------------------------|
396: -- ----------------------------------------------------------------------------
397: Procedure ins
398: (p_rec in out nocopy pqh_rmv_shd.g_rec_type
399: ) is
400: --
401: l_proc varchar2(72) := g_package||'ins';
402: --

Line 459: l_rec pqh_rmv_shd.g_rec_type;

455: ,p_node_value_id out nocopy number
456: ,p_object_version_number out nocopy number
457: ) is
458: --
459: l_rec pqh_rmv_shd.g_rec_type;
460: l_proc varchar2(72) := g_package||'ins';
461: --
462: Begin
463: hr_utility.set_location('Entering:'||l_proc, 5);

Line 469: pqh_rmv_shd.convert_args

465: -- Call conversion function to turn arguments into the
466: -- p_rec structure.
467: --
468: l_rec :=
469: pqh_rmv_shd.convert_args
470: (null
471: ,p_rate_matrix_node_id
472: ,p_short_code
473: ,p_char_value1