APPS.PQH_RNK_INS dependencies on PQH_RNK_SHD

Line 76: (p_rec in out nocopy pqh_rnk_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy pqh_rnk_shd.g_rec_type
77: ) is
78: --
79: l_proc constant varchar2(72) := g_package||'insert_dml';
80: --

Line 129: pqh_rnk_shd.constraint_error

125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: --
129: pqh_rnk_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: --

Line 134: pqh_rnk_shd.constraint_error

130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: --
134: pqh_rnk_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --

Line 139: pqh_rnk_shd.constraint_error

135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --
139: pqh_rnk_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: --
143: Raise;

Line 184: (p_rec in out nocopy pqh_rnk_shd.g_rec_type

180: --
181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure pre_insert
184: (p_rec in out nocopy pqh_rnk_shd.g_rec_type
185: ) is
186: --
187: Cursor C_Sel1 is select pqh_rank_processes_s.nextval from sys.dual;
188: --

Line 272: ,p_rec in pqh_rnk_shd.g_rec_type

268: -- {End Of Comments}
269: -- ----------------------------------------------------------------------------
270: Procedure post_insert
271: (p_effective_date in date
272: ,p_rec in pqh_rnk_shd.g_rec_type
273: ) is
274: --
275: l_proc constant varchar2(72) := g_package||'post_insert';
276: --

Line 332: ,p_rec in out nocopy pqh_rnk_shd.g_rec_type

328: -- |---------------------------------< ins >----------------------------------|
329: -- ----------------------------------------------------------------------------
330: Procedure ins
331: (p_effective_date in date
332: ,p_rec in out nocopy pqh_rnk_shd.g_rec_type
333: ) is
334: --
335: l_proc constant varchar2(72) := g_package||'ins';
336: --

Line 392: l_rec pqh_rnk_shd.g_rec_type;

388: ,p_rank_process_id out nocopy number
389: ,p_object_version_number out nocopy number
390: ) is
391: --
392: l_rec pqh_rnk_shd.g_rec_type;
393: l_proc constant varchar2(72) := g_package||'ins';
394: --
395: Begin
396: hr_utility.set_location('Entering:'||l_proc, 5);

Line 402: pqh_rnk_shd.convert_args

398: -- Call conversion function to turn arguments into the
399: -- p_rec structure.
400: --
401: l_rec :=
402: pqh_rnk_shd.convert_args
403: (null
404: ,p_pgm_id
405: ,p_pl_id
406: ,p_oipl_id