APPS.PQH_CRF_INS dependencies on PQH_CRF_SHD

Line 124: (p_rec in out nocopy pqh_crf_shd.g_rec_type

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

Line 163: pqh_crf_shd.constraint_error

159: Exception
160: When hr_api.check_integrity_violated Then
161: -- A check constraint has been violated
162: --
163: pqh_crf_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.parent_integrity_violated Then
166: -- Parent integrity has been violated
167: --

Line 168: pqh_crf_shd.constraint_error

164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.parent_integrity_violated Then
166: -- Parent integrity has been violated
167: --
168: pqh_crf_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: --

Line 173: pqh_crf_shd.constraint_error

169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: --
173: pqh_crf_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When Others Then
176: --
177: Raise;

Line 218: (p_rec in out nocopy pqh_crf_shd.g_rec_type

214: --
215: -- {End Of Comments}
216: -- ----------------------------------------------------------------------------
217: Procedure pre_insert
218: (p_rec in out nocopy pqh_crf_shd.g_rec_type
219: ) is
220: --
221: Cursor C_Sel1 is select pqh_criteria_rate_factors_s.nextval from sys.dual;
222: --

Line 305: (p_rec in pqh_crf_shd.g_rec_type

301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure post_insert
305: (p_rec in pqh_crf_shd.g_rec_type
306: ) is
307: --
308: l_proc varchar2(72) := g_package||'post_insert';
309: --

Line 354: (p_rec in out nocopy pqh_crf_shd.g_rec_type

350: -- ----------------------------------------------------------------------------
351: -- |---------------------------------< ins >----------------------------------|
352: -- ----------------------------------------------------------------------------
353: Procedure ins
354: (p_rec in out nocopy pqh_crf_shd.g_rec_type
355: ) is
356: --
357: l_proc varchar2(72) := g_package||'ins';
358: --

Line 404: l_rec pqh_crf_shd.g_rec_type;

400: ,p_criteria_rate_factor_id out nocopy number
401: ,p_object_version_number out nocopy number
402: ) is
403: --
404: l_rec pqh_crf_shd.g_rec_type;
405: l_proc varchar2(72) := g_package||'ins';
406: --
407: Begin
408: hr_utility.set_location('Entering:'||l_proc, 5);

Line 414: pqh_crf_shd.convert_args

410: -- Call conversion function to turn arguments into the
411: -- p_rec structure.
412: --
413: l_rec :=
414: pqh_crf_shd.convert_args
415: (null
416: ,p_criteria_rate_defn_id
417: ,p_parent_rate_matrix_id
418: ,p_parent_criteria_rate_defn_id