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 360: ,p_rec in pay_txr_shd.g_rec_type

356: -- {End Of Comments}
357: -- ----------------------------------------------------------------------------
358: Procedure post_insert
359: (p_effective_date in date
360: ,p_rec in pay_txr_shd.g_rec_type
361: ) is
362: --
363: l_proc varchar2(72) := g_package||'post_insert';
364: --

Line 407: ,p_rec in out nocopy pay_txr_shd.g_rec_type

403: -- |---------------------------------< ins >----------------------------------|
404: -- ----------------------------------------------------------------------------
405: Procedure ins
406: (p_effective_date in date
407: ,p_rec in out nocopy pay_txr_shd.g_rec_type
408: ) is
409: --
410: l_proc varchar2(72) := g_package||'ins';
411: --

Line 461: l_rec pay_txr_shd.g_rec_type;

457: ,p_taxability_rules_date_id in number
458: ,p_secondary_classification_id in number default null
459: ) is
460: --
461: l_rec pay_txr_shd.g_rec_type;
462: l_proc varchar2(72) := g_package||'ins';
463: --
464: Begin
465: hr_utility.set_location('Entering:'||l_proc, 5);

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

467: --
468: -- Call conversion function to turn arguments into the
469: -- p_rec structure.
470: --
471: hr_utility.trace('Before calling pay_txr_shd.convert_args ');
472: l_rec :=
473: pay_txr_shd.convert_args
474: (p_jurisdiction_code
475: ,p_tax_type

Line 473: pay_txr_shd.convert_args

469: -- p_rec structure.
470: --
471: hr_utility.trace('Before calling pay_txr_shd.convert_args ');
472: l_rec :=
473: pay_txr_shd.convert_args
474: (p_jurisdiction_code
475: ,p_tax_type
476: ,p_tax_category
477: ,p_classification_id

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

480: ,p_status
481: ,p_secondary_classification_id
482: );
483: --
484: hr_utility.trace('After calling pay_txr_shd.convert_args ');
485: -- Having converted the arguments into the pay_txr_rec
486: -- plsql record structure we call the corresponding record business process.
487: --
488: hr_utility.trace('Before calling pay_txr_ins.ins ');