DBA Data[Home] [Help]

APPS.PAY_TXR_INS dependencies on PAY_TXR_SHD

Line 91: (p_rec in out nocopy pay_txr_shd.g_rec_type

87: --
88: -- {End Of Comments}
89: -- ----------------------------------------------------------------------------
90: Procedure insert_dml
91: (p_rec in out nocopy pay_txr_shd.g_rec_type
92: ) is
93: --
94: l_proc varchar2(72) := g_package||'insert_dml';
95: num number;

Line 146: pay_txr_shd.constraint_error

142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: --
146: pay_txr_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: --

Line 151: pay_txr_shd.constraint_error

147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: --
151: pay_txr_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: --

Line 156: pay_txr_shd.constraint_error

152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: --
156: pay_txr_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: --
160: hr_utility.trace('Exception in '||SQLERRM);

Line 202: (p_rec in out nocopy pay_txr_shd.g_rec_type

198: --
199: -- {End Of Comments}
200: -- ----------------------------------------------------------------------------
201: Procedure pre_insert
202: (p_rec in out nocopy pay_txr_shd.g_rec_type
203: ) is
204: --
205: Cursor C_Sel1 is
206: select taxability_rules_date_id

Line 417: ,p_rec in pay_txr_shd.g_rec_type

413: -- {End Of Comments}
414: -- ----------------------------------------------------------------------------
415: Procedure post_insert
416: (p_effective_date in date
417: ,p_rec in pay_txr_shd.g_rec_type
418: ) is
419: --
420: l_proc varchar2(72) := g_package||'post_insert';
421: --

Line 464: ,p_rec in out nocopy pay_txr_shd.g_rec_type

460: -- |---------------------------------< ins >----------------------------------|
461: -- ----------------------------------------------------------------------------
462: Procedure ins
463: (p_effective_date in date
464: ,p_rec in out nocopy pay_txr_shd.g_rec_type
465: ) is
466: --
467: l_proc varchar2(72) := g_package||'ins';
468: --

Line 518: l_rec pay_txr_shd.g_rec_type;

514: ,p_taxability_rules_date_id in number
515: ,p_secondary_classification_id in number default null
516: ) is
517: --
518: l_rec pay_txr_shd.g_rec_type;
519: l_proc varchar2(72) := g_package||'ins';
520: --
521: Begin
522: hr_utility.set_location('Entering:'||l_proc, 5);

Line 528: hr_utility.trace('Before calling pay_txr_shd.convert_args ');

524: --
525: -- Call conversion function to turn arguments into the
526: -- p_rec structure.
527: --
528: hr_utility.trace('Before calling pay_txr_shd.convert_args ');
529: l_rec :=
530: pay_txr_shd.convert_args
531: (p_jurisdiction_code
532: ,p_tax_type

Line 530: pay_txr_shd.convert_args

526: -- p_rec structure.
527: --
528: hr_utility.trace('Before calling pay_txr_shd.convert_args ');
529: l_rec :=
530: pay_txr_shd.convert_args
531: (p_jurisdiction_code
532: ,p_tax_type
533: ,p_tax_category
534: ,p_classification_id

Line 541: hr_utility.trace('After calling pay_txr_shd.convert_args ');

537: ,p_status
538: ,p_secondary_classification_id
539: );
540: --
541: hr_utility.trace('After calling pay_txr_shd.convert_args ');
542: -- Having converted the arguments into the pay_txr_rec
543: -- plsql record structure we call the corresponding record business process.
544: --
545: hr_utility.trace('Before calling pay_txr_ins.ins ');