APPS.BEN_QIG_INS dependencies on BEN_QIG_SHD

Line 80: (p_rec in out nocopy ben_qig_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy ben_qig_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: ben_qig_shd.g_old_rec.effective_start_date

90: t.creation_date
91: from ben_qua_in_gr_rt_f t
92: where t.qua_in_gr_rt_id = p_rec.qua_in_gr_rt_id
93: and t.effective_start_date =
94: ben_qig_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 ben_qua_in_gr_rt_f.created_by%TYPE;

Line 258: ben_qig_shd.constraint_error

254: Exception
255: When hr_api.check_integrity_violated Then
256: -- A check constraint has been violated
257: --
258: ben_qig_shd.constraint_error
259: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
260: When hr_api.unique_integrity_violated Then
261: -- Unique integrity has been violated
262: --

Line 263: ben_qig_shd.constraint_error

259: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
260: When hr_api.unique_integrity_violated Then
261: -- Unique integrity has been violated
262: --
263: ben_qig_shd.constraint_error
264: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
265: When Others Then
266: --
267: Raise;

Line 274: (p_rec in out nocopy ben_qig_shd.g_rec_type

270: -- ----------------------------------------------------------------------------
271: -- |------------------------------< insert_dml >------------------------------|
272: -- ----------------------------------------------------------------------------
273: Procedure insert_dml
274: (p_rec in out nocopy ben_qig_shd.g_rec_type
275: ,p_effective_date in date
276: ,p_datetrack_mode in varchar2
277: ,p_validation_start_date in date
278: ,p_validation_end_date in date

Line 337: (p_rec in out nocopy ben_qig_shd.g_rec_type

333: --
334: -- {End Of Comments}
335: -- ----------------------------------------------------------------------------
336: Procedure pre_insert
337: (p_rec in out nocopy ben_qig_shd.g_rec_type
338: ,p_effective_date in date
339: ,p_datetrack_mode in varchar2
340: ,p_validation_start_date in date
341: ,p_validation_end_date in date

Line 429: (p_rec in ben_qig_shd.g_rec_type

425: --
426: -- {End Of Comments}
427: -- ----------------------------------------------------------------------------
428: Procedure post_insert
429: (p_rec in ben_qig_shd.g_rec_type
430: ,p_effective_date in date
431: ,p_datetrack_mode in varchar2
432: ,p_validation_start_date in date
433: ,p_validation_end_date in date

Line 583: ,p_rec in ben_qig_shd.g_rec_type

579: -- ----------------------------------------------------------------------------
580: Procedure ins_lck
581: (p_effective_date in date
582: ,p_datetrack_mode in varchar2
583: ,p_rec in ben_qig_shd.g_rec_type
584: ,p_validation_start_date out nocopy date
585: ,p_validation_end_date out nocopy date
586: ) is
587: --

Line 626: ,p_rec in out nocopy ben_qig_shd.g_rec_type

622: -- |---------------------------------< ins >----------------------------------|
623: -- ----------------------------------------------------------------------------
624: Procedure ins
625: (p_effective_date in date
626: ,p_rec in out nocopy ben_qig_shd.g_rec_type
627: ) is
628: --
629: l_proc varchar2(72) := g_package||'ins';
630: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 743: l_rec ben_qig_shd.g_rec_type;

739: ,p_effective_start_date out nocopy date
740: ,p_effective_end_date out nocopy date
741: ) is
742: --
743: l_rec ben_qig_shd.g_rec_type;
744: l_proc varchar2(72) := g_package||'ins';
745: --
746: Begin
747: hr_utility.set_location('Entering:'||l_proc, 5);

Line 753: ben_qig_shd.convert_args

749: -- Call conversion function to turn arguments into the
750: -- p_rec structure.
751: --
752: l_rec :=
753: ben_qig_shd.convert_args
754: (null
755: ,null
756: ,null
757: ,p_quar_in_grade_cd