DBA Data[Home] [Help]

APPS.PAY_TXR_UPD dependencies on PAY_TXR_SHD

Line 55: (p_rec in out nocopy pay_txr_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pay_txr_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 94: pay_txr_shd.constraint_error

90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: --
94: pay_txr_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --

Line 99: pay_txr_shd.constraint_error

95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: pay_txr_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --

Line 104: pay_txr_shd.constraint_error

100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: pay_txr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then
107: --
108: Raise;

Line 144: (p_rec in pay_txr_shd.g_rec_type

140: --
141: -- {End Of Comments}
142: -- ----------------------------------------------------------------------------
143: Procedure pre_update
144: (p_rec in pay_txr_shd.g_rec_type
145: ) is
146: --
147: l_proc varchar2(72) := g_package||'pre_update';
148: --

Line 189: ,p_rec in pay_txr_shd.g_rec_type

185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure post_update
188: (p_effective_date in date
189: ,p_rec in pay_txr_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package||'post_update';
193: --

Line 215: => pay_txr_shd.g_old_rec.legislation_code

211: => p_rec.legislation_code
212: ,p_status
213: => p_rec.status
214: ,p_legislation_code_o
215: => pay_txr_shd.g_old_rec.legislation_code
216: ,p_status_o
217: => pay_txr_shd.g_old_rec.status
218: ,p_secondary_classification_id
219: => p_rec.secondary_classification_id

Line 217: => pay_txr_shd.g_old_rec.status

213: => p_rec.status
214: ,p_legislation_code_o
215: => pay_txr_shd.g_old_rec.legislation_code
216: ,p_status_o
217: => pay_txr_shd.g_old_rec.status
218: ,p_secondary_classification_id
219: => p_rec.secondary_classification_id
220: );
221: --

Line 279: (p_rec in out nocopy pay_txr_shd.g_rec_type

275: --
276: -- {End Of Comments}
277: -- ----------------------------------------------------------------------------
278: Procedure convert_defs
279: (p_rec in out nocopy pay_txr_shd.g_rec_type
280: ) is
281: --
282: Begin
283: --

Line 291: pay_txr_shd.g_old_rec.legislation_code;

287: -- is being used then we must set to the 'current' argument value.
288: --
289: If (p_rec.legislation_code = hr_api.g_varchar2) then
290: p_rec.legislation_code :=
291: pay_txr_shd.g_old_rec.legislation_code;
292: End If;
293: If (p_rec.status = hr_api.g_varchar2) then
294: p_rec.status :=
295: pay_txr_shd.g_old_rec.status;

Line 295: pay_txr_shd.g_old_rec.status;

291: pay_txr_shd.g_old_rec.legislation_code;
292: End If;
293: If (p_rec.status = hr_api.g_varchar2) then
294: p_rec.status :=
295: pay_txr_shd.g_old_rec.status;
296: End If;
297: --
298: End convert_defs;
299: --

Line 305: ,p_rec in out nocopy pay_txr_shd.g_rec_type

301: -- |---------------------------------< upd >----------------------------------|
302: -- ----------------------------------------------------------------------------
303: Procedure upd
304: (p_effective_date in date
305: ,p_rec in out nocopy pay_txr_shd.g_rec_type
306: ) is
307: --
308: l_proc varchar2(72) := g_package||'upd';
309: --

Line 315: pay_txr_shd.lck

311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: -- We must lock the row which we need to update.
314: --
315: pay_txr_shd.lck
316: (p_rec.jurisdiction_code
317: ,p_rec.tax_type
318: ,p_rec.tax_category
319: ,p_rec.classification_id

Line 373: l_rec pay_txr_shd.g_rec_type;

369: ,p_status in varchar2 default hr_api.g_varchar2
370: ,p_secondary_classification_id in number default hr_api.g_number
371: ) is
372: --
373: l_rec pay_txr_shd.g_rec_type;
374: l_proc varchar2(72) := g_package||'upd';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);

Line 383: pay_txr_shd.convert_args

379: -- Call conversion function to turn arguments into the
380: -- l_rec structure.
381: --
382: l_rec :=
383: pay_txr_shd.convert_args
384: (p_jurisdiction_code
385: ,p_tax_type
386: ,p_tax_category
387: ,p_classification_id