APPS.PQH_RMR_INS dependencies on PQH_RMR_SHD

Line 80: (p_rec in out nocopy pqh_rmr_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pqh_rmr_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date

Line 94: pqh_rmr_shd.g_old_rec.effective_start_date

90: t.creation_date
91: from pqh_rate_matrix_rates_f t
92: where t.rate_matrix_rate_id = p_rec.rate_matrix_rate_id
93: and t.effective_start_date =
94: pqh_rmr_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pqh_rate_matrix_rates_f.created_by%TYPE;

Line 204: pqh_rmr_shd.constraint_error

200: Exception
201: When hr_api.check_integrity_violated Then
202: -- A check constraint has been violated
203: --
204: pqh_rmr_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: --

Line 209: pqh_rmr_shd.constraint_error

205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: --
209: pqh_rmr_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When Others Then
212: --
213: Raise;

Line 268: (p_rec in out nocopy pqh_rmr_shd.g_rec_type

264: -- ----------------------------------------------------------------------------
265: -- |------------------------------< insert_dml >------------------------------|
266: -- ----------------------------------------------------------------------------
267: Procedure insert_dml
268: (p_rec in out nocopy pqh_rmr_shd.g_rec_type
269: ,p_effective_date in date
270: ,p_datetrack_mode in varchar2
271: ,p_validation_start_date in date
272: ,p_validation_end_date in date

Line 331: (p_rec in out nocopy pqh_rmr_shd.g_rec_type

327: --
328: -- {End Of Comments}
329: -- ----------------------------------------------------------------------------
330: Procedure pre_insert
331: (p_rec in out nocopy pqh_rmr_shd.g_rec_type
332: ,p_effective_date in date
333: ,p_datetrack_mode in varchar2
334: ,p_validation_start_date in date
335: ,p_validation_end_date in date

Line 423: (p_rec in pqh_rmr_shd.g_rec_type

419: --
420: -- {End Of Comments}
421: -- ----------------------------------------------------------------------------
422: Procedure post_insert
423: (p_rec in pqh_rmr_shd.g_rec_type
424: ,p_effective_date in date
425: ,p_datetrack_mode in varchar2
426: ,p_validation_start_date in date
427: ,p_validation_end_date in date

Line 527: ,p_rec in pqh_rmr_shd.g_rec_type

523: -- ----------------------------------------------------------------------------
524: Procedure ins_lck
525: (p_effective_date in date
526: ,p_datetrack_mode in varchar2
527: ,p_rec in pqh_rmr_shd.g_rec_type
528: ,p_validation_start_date out nocopy date
529: ,p_validation_end_date out nocopy date
530: ) is
531: --

Line 567: ,p_rec in out nocopy pqh_rmr_shd.g_rec_type

563: -- |---------------------------------< ins >----------------------------------|
564: -- ----------------------------------------------------------------------------
565: Procedure ins
566: (p_effective_date in date
567: ,p_rec in out nocopy pqh_rmr_shd.g_rec_type
568: ) is
569: --
570: l_proc varchar2(72) := g_package||'ins';
571: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 656: l_rec pqh_rmr_shd.g_rec_type;

652: ,p_effective_start_date out nocopy date
653: ,p_effective_end_date out nocopy date
654: ) is
655: --
656: l_rec pqh_rmr_shd.g_rec_type;
657: l_proc varchar2(72) := g_package||'ins';
658: --
659: Begin
660: hr_utility.set_location('Entering:'||l_proc, 5);

Line 666: pqh_rmr_shd.convert_args

662: -- Call conversion function to turn arguments into the
663: -- p_rec structure.
664: --
665: l_rec :=
666: pqh_rmr_shd.convert_args
667: (null
668: ,null
669: ,null
670: ,p_rate_matrix_node_id