DBA Data[Home] [Help]

APPS.PAY_PBC_INS dependencies on PAY_PBC_SHD

Line 80: (p_rec in out nocopy pay_pbc_shd.g_rec_type

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

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

Line 258: pay_pbc_shd.constraint_error

254: Exception
255: When hr_api.check_integrity_violated Then
256: -- A check constraint has been violated
257: --
258: pay_pbc_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: pay_pbc_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: pay_pbc_shd.constraint_error
264: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
265: When Others Then
266: --
267: Raise;

Line 322: (p_rec in out nocopy pay_pbc_shd.g_rec_type

318: -- ----------------------------------------------------------------------------
319: -- |------------------------------< insert_dml >------------------------------|
320: -- ----------------------------------------------------------------------------
321: Procedure insert_dml
322: (p_rec in out nocopy pay_pbc_shd.g_rec_type
323: ,p_effective_date in date
324: ,p_datetrack_mode in varchar2
325: ,p_validation_start_date in date
326: ,p_validation_end_date in date

Line 385: (p_rec in out nocopy pay_pbc_shd.g_rec_type

381: --
382: -- {End Of Comments}
383: -- ----------------------------------------------------------------------------
384: Procedure pre_insert
385: (p_rec in out nocopy pay_pbc_shd.g_rec_type
386: ,p_effective_date in date
387: ,p_datetrack_mode in varchar2
388: ,p_validation_start_date in date
389: ,p_validation_end_date in date

Line 477: (p_rec in pay_pbc_shd.g_rec_type

473: --
474: -- {End Of Comments}
475: -- ----------------------------------------------------------------------------
476: Procedure post_insert
477: (p_rec in pay_pbc_shd.g_rec_type
478: ,p_effective_date in date
479: ,p_datetrack_mode in varchar2
480: ,p_validation_start_date in date
481: ,p_validation_end_date in date

Line 637: ,p_rec in pay_pbc_shd.g_rec_type

633: -- ----------------------------------------------------------------------------
634: Procedure ins_lck
635: (p_effective_date in date
636: ,p_datetrack_mode in varchar2
637: ,p_rec in pay_pbc_shd.g_rec_type
638: ,p_validation_start_date out nocopy date
639: ,p_validation_end_date out nocopy date
640: ) is
641: --

Line 677: ,p_rec in out nocopy pay_pbc_shd.g_rec_type

673: -- |---------------------------------< ins >----------------------------------|
674: -- ----------------------------------------------------------------------------
675: Procedure ins
676: (p_effective_date in date
677: ,p_rec in out nocopy pay_pbc_shd.g_rec_type
678: ) is
679: --
680: l_proc varchar2(72) := g_package||'ins';
681: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 794: l_rec pay_pbc_shd.g_rec_type;

790: ,p_effective_start_date out nocopy date
791: ,p_effective_end_date out nocopy date
792: ) is
793: --
794: l_rec pay_pbc_shd.g_rec_type;
795: l_proc varchar2(72) := g_package||'ins';
796: --
797: Begin
798: hr_utility.set_location('Entering:'||l_proc, 5);

Line 804: pay_pbc_shd.convert_args

800: -- Call conversion function to turn arguments into the
801: -- p_rec structure.
802: --
803: l_rec :=
804: pay_pbc_shd.convert_args
805: (null
806: ,p_category_name
807: ,null
808: ,null