DBA Data[Home] [Help]

APPS.PAY_BDT_UPD dependencies on PAY_BDT_SHD

Line 55: (p_rec in out nocopy pay_bdt_shd.g_rec_type

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

Line 87: pay_bdt_shd.constraint_error

83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --
87: pay_bdt_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --

Line 92: pay_bdt_shd.constraint_error

88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
92: pay_bdt_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --

Line 97: pay_bdt_shd.constraint_error

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
97: pay_bdt_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --
101: Raise;

Line 137: (p_rec in pay_bdt_shd.g_rec_type

133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update
137: (p_rec in pay_bdt_shd.g_rec_type
138: ) is
139: --
140: l_proc varchar2(72) := g_package||'pre_update';
141: --

Line 181: (p_rec in pay_bdt_shd.g_rec_type

177: --
178: -- {End Of Comments}
179: -- ----------------------------------------------------------------------------
180: Procedure post_update
181: (p_rec in pay_bdt_shd.g_rec_type
182: ) is
183: --
184: l_proc varchar2(72) := g_package||'post_update';
185: --

Line 204: => pay_bdt_shd.g_old_rec.source_lang

200: => p_rec.database_item_suffix
201: ,p_description
202: => p_rec.description
203: ,p_source_lang_o
204: => pay_bdt_shd.g_old_rec.source_lang
205: ,p_dimension_name_o
206: => pay_bdt_shd.g_old_rec.dimension_name
207: ,p_database_item_suffix_o
208: => pay_bdt_shd.g_old_rec.database_item_suffix

Line 206: => pay_bdt_shd.g_old_rec.dimension_name

202: => p_rec.description
203: ,p_source_lang_o
204: => pay_bdt_shd.g_old_rec.source_lang
205: ,p_dimension_name_o
206: => pay_bdt_shd.g_old_rec.dimension_name
207: ,p_database_item_suffix_o
208: => pay_bdt_shd.g_old_rec.database_item_suffix
209: ,p_description_o
210: => pay_bdt_shd.g_old_rec.description

Line 208: => pay_bdt_shd.g_old_rec.database_item_suffix

204: => pay_bdt_shd.g_old_rec.source_lang
205: ,p_dimension_name_o
206: => pay_bdt_shd.g_old_rec.dimension_name
207: ,p_database_item_suffix_o
208: => pay_bdt_shd.g_old_rec.database_item_suffix
209: ,p_description_o
210: => pay_bdt_shd.g_old_rec.description
211: );
212: --

Line 210: => pay_bdt_shd.g_old_rec.description

206: => pay_bdt_shd.g_old_rec.dimension_name
207: ,p_database_item_suffix_o
208: => pay_bdt_shd.g_old_rec.database_item_suffix
209: ,p_description_o
210: => pay_bdt_shd.g_old_rec.description
211: );
212: --
213: exception
214: --

Line 270: (p_rec in out nocopy pay_bdt_shd.g_rec_type

266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure convert_defs
270: (p_rec in out nocopy pay_bdt_shd.g_rec_type
271: ) is
272: --
273: Begin
274: --

Line 282: pay_bdt_shd.g_old_rec.source_lang;

278: -- is being used then we must set to the 'current' argument value.
279: --
280: If (p_rec.source_lang = hr_api.g_varchar2) then
281: p_rec.source_lang :=
282: pay_bdt_shd.g_old_rec.source_lang;
283: End If;
284: If (p_rec.dimension_name = hr_api.g_varchar2) then
285: p_rec.dimension_name :=
286: pay_bdt_shd.g_old_rec.dimension_name;

Line 286: pay_bdt_shd.g_old_rec.dimension_name;

282: pay_bdt_shd.g_old_rec.source_lang;
283: End If;
284: If (p_rec.dimension_name = hr_api.g_varchar2) then
285: p_rec.dimension_name :=
286: pay_bdt_shd.g_old_rec.dimension_name;
287: End If;
288: If (p_rec.database_item_suffix = hr_api.g_varchar2) then
289: p_rec.database_item_suffix :=
290: pay_bdt_shd.g_old_rec.database_item_suffix;

Line 290: pay_bdt_shd.g_old_rec.database_item_suffix;

286: pay_bdt_shd.g_old_rec.dimension_name;
287: End If;
288: If (p_rec.database_item_suffix = hr_api.g_varchar2) then
289: p_rec.database_item_suffix :=
290: pay_bdt_shd.g_old_rec.database_item_suffix;
291: End If;
292: If (p_rec.description = hr_api.g_varchar2) then
293: p_rec.description :=
294: pay_bdt_shd.g_old_rec.description;

Line 294: pay_bdt_shd.g_old_rec.description;

290: pay_bdt_shd.g_old_rec.database_item_suffix;
291: End If;
292: If (p_rec.description = hr_api.g_varchar2) then
293: p_rec.description :=
294: pay_bdt_shd.g_old_rec.description;
295: End If;
296: --
297: End convert_defs;
298: --

Line 303: (p_rec in out nocopy pay_bdt_shd.g_rec_type

299: -- ----------------------------------------------------------------------------
300: -- |---------------------------------< upd >----------------------------------|
301: -- ----------------------------------------------------------------------------
302: Procedure upd
303: (p_rec in out nocopy pay_bdt_shd.g_rec_type
304: ) is
305: --
306: l_proc varchar2(72) := g_package||'upd';
307: --

Line 313: pay_bdt_shd.lck

309: hr_utility.set_location('Entering:'||l_proc, 5);
310: --
311: -- We must lock the row which we need to update.
312: --
313: pay_bdt_shd.lck
314: (p_rec.balance_dimension_id
315: ,p_rec.language
316: );
317: --

Line 360: l_rec pay_bdt_shd.g_rec_type;

356: ,p_database_item_suffix in varchar2 default hr_api.g_varchar2
357: ,p_description in varchar2 default hr_api.g_varchar2
358: ) is
359: --
360: l_rec pay_bdt_shd.g_rec_type;
361: l_proc varchar2(72) := g_package||'upd';
362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc, 5);

Line 370: pay_bdt_shd.convert_args

366: -- Call conversion function to turn arguments into the
367: -- l_rec structure.
368: --
369: l_rec :=
370: pay_bdt_shd.convert_args
371: (p_balance_dimension_id
372: ,p_language
373: ,p_source_lang
374: ,p_dimension_name