APPS.PAY_ITR_INS dependencies on PAY_ITR_SHD

Line 58: (p_rec in out nocopy pay_itr_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy pay_itr_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 72: pay_itr_shd.g_old_rec.effective_start_date

68: t.creation_date
69: from pay_iterative_rules_f t
70: where t.iterative_rule_id = p_rec.iterative_rule_id
71: and t.effective_start_date =
72: pay_itr_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by pay_iterative_rules_f.created_by%TYPE;

Line 178: pay_itr_shd.constraint_error

174: Exception
175: When hr_api.check_integrity_violated Then
176: -- A check constraint has been violated
177: --
178: pay_itr_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: --

Line 183: pay_itr_shd.constraint_error

179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: --
183: pay_itr_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When Others Then
186: --
187: Raise;

Line 194: (p_rec in out nocopy pay_itr_shd.g_rec_type

190: -- ----------------------------------------------------------------------------
191: -- |------------------------------< insert_dml >------------------------------|
192: -- ----------------------------------------------------------------------------
193: Procedure insert_dml
194: (p_rec in out nocopy pay_itr_shd.g_rec_type
195: ,p_effective_date in date
196: ,p_datetrack_mode in varchar2
197: ,p_validation_start_date in date
198: ,p_validation_end_date in date

Line 257: (p_rec in out nocopy pay_itr_shd.g_rec_type

253: --
254: -- {End Of Comments}
255: -- ----------------------------------------------------------------------------
256: Procedure pre_insert
257: (p_rec in out nocopy pay_itr_shd.g_rec_type
258: ,p_effective_date in date
259: ,p_datetrack_mode in varchar2
260: ,p_validation_start_date in date
261: ,p_validation_end_date in date

Line 315: (p_rec in pay_itr_shd.g_rec_type

311: --
312: -- {End Of Comments}
313: -- ----------------------------------------------------------------------------
314: Procedure post_insert
315: (p_rec in pay_itr_shd.g_rec_type
316: ,p_effective_date in date
317: ,p_datetrack_mode in varchar2
318: ,p_validation_start_date in date
319: ,p_validation_end_date in date

Line 411: ,p_rec in pay_itr_shd.g_rec_type

407: -- ----------------------------------------------------------------------------
408: Procedure ins_lck
409: (p_effective_date in date
410: ,p_datetrack_mode in varchar2
411: ,p_rec in pay_itr_shd.g_rec_type
412: ,p_validation_start_date out nocopy date
413: ,p_validation_end_date out nocopy date
414: ) is
415: --

Line 451: ,p_rec in out nocopy pay_itr_shd.g_rec_type

447: -- |---------------------------------< ins >----------------------------------|
448: -- ----------------------------------------------------------------------------
449: Procedure ins
450: (p_effective_date in date
451: ,p_rec in out nocopy pay_itr_shd.g_rec_type
452: ) is
453: --
454: l_proc varchar2(72) := g_package||'ins';
455: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 533: l_rec pay_itr_shd.g_rec_type;

529: ,p_effective_start_date out nocopy date
530: ,p_effective_end_date out nocopy date
531: ) is
532: --
533: l_rec pay_itr_shd.g_rec_type;
534: l_proc varchar2(72) := g_package||'ins';
535: --
536: Begin
537: hr_utility.set_location('Entering:'||l_proc, 5);

Line 543: pay_itr_shd.convert_args

539: -- Call conversion function to turn arguments into the
540: -- p_rec structure.
541: --
542: l_rec :=
543: pay_itr_shd.convert_args
544: (null
545: ,p_element_type_id
546: ,null
547: ,null