APPS.PQH_RFE_INS dependencies on PQH_RFE_SHD

Line 124: (p_rec in out nocopy pqh_rfe_shd.g_rec_type

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

Line 165: pqh_rfe_shd.constraint_error

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

Line 170: pqh_rfe_shd.constraint_error

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

Line 175: pqh_rfe_shd.constraint_error

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

Line 220: (p_rec in out nocopy pqh_rfe_shd.g_rec_type

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

Line 308: ,p_rec in pqh_rfe_shd.g_rec_type

304: -- {End Of Comments}
305: -- ----------------------------------------------------------------------------
306: Procedure post_insert
307: (p_effective_date in date
308: ,p_rec in pqh_rfe_shd.g_rec_type
309: ) is
310: --
311: l_proc varchar2(72) := g_package||'post_insert';
312: --

Line 361: ,p_rec in out nocopy pqh_rfe_shd.g_rec_type

357: -- |---------------------------------< ins >----------------------------------|
358: -- ----------------------------------------------------------------------------
359: Procedure ins
360: (p_effective_date in date
361: ,p_rec in out nocopy pqh_rfe_shd.g_rec_type
362: ) is
363: --
364: l_proc varchar2(72) := g_package||'ins';
365: --

Line 415: l_rec pqh_rfe_shd.g_rec_type;

411: ,p_rate_factor_on_elmnt_id out nocopy number
412: ,p_object_version_number out nocopy number
413: ) is
414: --
415: l_rec pqh_rfe_shd.g_rec_type;
416: l_proc varchar2(72) := g_package||'ins';
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);

Line 425: pqh_rfe_shd.convert_args

421: -- Call conversion function to turn arguments into the
422: -- p_rec structure.
423: --
424: l_rec :=
425: pqh_rfe_shd.convert_args
426: (null
427: ,p_criteria_rate_element_id
428: ,p_criteria_rate_factor_id
429: ,p_rate_factor_val_record_tbl