DBA Data[Home] [Help]

APPS.PQH_RMN_INS dependencies on PQH_RMN_SHD

Line 124: (p_rec in out nocopy pqh_rmn_shd.g_rec_type

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

Line 171: pqh_rmn_shd.constraint_error

167: Exception
168: When hr_api.check_integrity_violated Then
169: -- A check constraint has been violated
170: --
171: pqh_rmn_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: --

Line 176: pqh_rmn_shd.constraint_error

172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: --
176: pqh_rmn_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: --

Line 181: pqh_rmn_shd.constraint_error

177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: --
181: pqh_rmn_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When Others Then
184: --
185: Raise;

Line 226: (p_rec in out nocopy pqh_rmn_shd.g_rec_type

222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure pre_insert
226: (p_rec in out nocopy pqh_rmn_shd.g_rec_type
227: ) is
228: --
229: Cursor C_Sel1 is select pqh_rate_matrix_nodes_s.nextval from sys.dual;
230: --

Line 313: (p_rec in pqh_rmn_shd.g_rec_type

309: --
310: -- {End Of Comments}
311: -- ----------------------------------------------------------------------------
312: Procedure post_insert
313: (p_rec in pqh_rmn_shd.g_rec_type
314: ) is
315: --
316: l_proc varchar2(72) := g_package||'post_insert';
317: --

Line 370: (p_rec in out nocopy pqh_rmn_shd.g_rec_type

366: -- ----------------------------------------------------------------------------
367: -- |---------------------------------< ins >----------------------------------|
368: -- ----------------------------------------------------------------------------
369: Procedure ins
370: (p_rec in out nocopy pqh_rmn_shd.g_rec_type
371: ) is
372: --
373: l_proc varchar2(72) := g_package||'ins';
374: --

Line 424: l_rec pqh_rmn_shd.g_rec_type;

420: ,p_rate_matrix_node_id out nocopy number
421: ,p_object_version_number out nocopy number
422: ) is
423: --
424: l_rec pqh_rmn_shd.g_rec_type;
425: l_proc varchar2(72) := g_package||'ins';
426: --
427: Begin
428: hr_utility.set_location('Entering:'||l_proc, 5);

Line 434: pqh_rmn_shd.convert_args

430: -- Call conversion function to turn arguments into the
431: -- p_rec structure.
432: --
433: l_rec :=
434: pqh_rmn_shd.convert_args
435: (null
436: ,p_short_code
437: ,p_pl_id
438: ,p_level_number