DBA Data[Home] [Help]

APPS.PAY_DTE_UPD dependencies on PAY_DTE_SHD

Line 55: (p_rec in out nocopy pay_dte_shd.g_rec_type

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

Line 91: pay_dte_shd.constraint_error

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

Line 96: pay_dte_shd.constraint_error

92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: pay_dte_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --

Line 101: pay_dte_shd.constraint_error

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: pay_dte_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: --
105: Raise;

Line 141: (p_rec in pay_dte_shd.g_rec_type

137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure pre_update
141: (p_rec in pay_dte_shd.g_rec_type
142: ) is
143: --
144: l_proc varchar2(72) := g_package||'pre_update';
145: --

Line 186: ,p_rec in pay_dte_shd.g_rec_type

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

Line 216: => pay_dte_shd.g_old_rec.event_group_id

212: => p_rec.object_version_number
213: ,p_proration_style
214: => p_rec.proration_style
215: ,p_event_group_id_o
216: => pay_dte_shd.g_old_rec.event_group_id
217: ,p_dated_table_id_o
218: => pay_dte_shd.g_old_rec.dated_table_id
219: ,p_column_name_o
220: => pay_dte_shd.g_old_rec.column_name

Line 218: => pay_dte_shd.g_old_rec.dated_table_id

214: => p_rec.proration_style
215: ,p_event_group_id_o
216: => pay_dte_shd.g_old_rec.event_group_id
217: ,p_dated_table_id_o
218: => pay_dte_shd.g_old_rec.dated_table_id
219: ,p_column_name_o
220: => pay_dte_shd.g_old_rec.column_name
221: ,p_update_type_o
222: => pay_dte_shd.g_old_rec.update_type

Line 220: => pay_dte_shd.g_old_rec.column_name

216: => pay_dte_shd.g_old_rec.event_group_id
217: ,p_dated_table_id_o
218: => pay_dte_shd.g_old_rec.dated_table_id
219: ,p_column_name_o
220: => pay_dte_shd.g_old_rec.column_name
221: ,p_update_type_o
222: => pay_dte_shd.g_old_rec.update_type
223: ,p_business_group_id_o
224: => pay_dte_shd.g_old_rec.business_group_id

Line 222: => pay_dte_shd.g_old_rec.update_type

218: => pay_dte_shd.g_old_rec.dated_table_id
219: ,p_column_name_o
220: => pay_dte_shd.g_old_rec.column_name
221: ,p_update_type_o
222: => pay_dte_shd.g_old_rec.update_type
223: ,p_business_group_id_o
224: => pay_dte_shd.g_old_rec.business_group_id
225: ,p_legislation_code_o
226: => pay_dte_shd.g_old_rec.legislation_code

Line 224: => pay_dte_shd.g_old_rec.business_group_id

220: => pay_dte_shd.g_old_rec.column_name
221: ,p_update_type_o
222: => pay_dte_shd.g_old_rec.update_type
223: ,p_business_group_id_o
224: => pay_dte_shd.g_old_rec.business_group_id
225: ,p_legislation_code_o
226: => pay_dte_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o
228: => pay_dte_shd.g_old_rec.object_version_number

Line 226: => pay_dte_shd.g_old_rec.legislation_code

222: => pay_dte_shd.g_old_rec.update_type
223: ,p_business_group_id_o
224: => pay_dte_shd.g_old_rec.business_group_id
225: ,p_legislation_code_o
226: => pay_dte_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o
228: => pay_dte_shd.g_old_rec.object_version_number
229: ,p_proration_style_o
230: => pay_dte_shd.g_old_rec.proration_style

Line 228: => pay_dte_shd.g_old_rec.object_version_number

224: => pay_dte_shd.g_old_rec.business_group_id
225: ,p_legislation_code_o
226: => pay_dte_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o
228: => pay_dte_shd.g_old_rec.object_version_number
229: ,p_proration_style_o
230: => pay_dte_shd.g_old_rec.proration_style
231: );
232: --

Line 230: => pay_dte_shd.g_old_rec.proration_style

226: => pay_dte_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o
228: => pay_dte_shd.g_old_rec.object_version_number
229: ,p_proration_style_o
230: => pay_dte_shd.g_old_rec.proration_style
231: );
232: --
233: exception
234: --

Line 290: (p_rec in out nocopy pay_dte_shd.g_rec_type

286: --
287: -- {End Of Comments}
288: -- ----------------------------------------------------------------------------
289: Procedure convert_defs
290: (p_rec in out nocopy pay_dte_shd.g_rec_type
291: ) is
292: --
293: Begin
294: --

Line 302: pay_dte_shd.g_old_rec.event_group_id;

298: -- is being used then we must set to the 'current' argument value.
299: --
300: If (p_rec.event_group_id = hr_api.g_number) then
301: p_rec.event_group_id :=
302: pay_dte_shd.g_old_rec.event_group_id;
303: End If;
304: If (p_rec.dated_table_id = hr_api.g_number) then
305: p_rec.dated_table_id :=
306: pay_dte_shd.g_old_rec.dated_table_id;

Line 306: pay_dte_shd.g_old_rec.dated_table_id;

302: pay_dte_shd.g_old_rec.event_group_id;
303: End If;
304: If (p_rec.dated_table_id = hr_api.g_number) then
305: p_rec.dated_table_id :=
306: pay_dte_shd.g_old_rec.dated_table_id;
307: End If;
308: If (p_rec.column_name = hr_api.g_varchar2) then
309: p_rec.column_name :=
310: pay_dte_shd.g_old_rec.column_name;

Line 310: pay_dte_shd.g_old_rec.column_name;

306: pay_dte_shd.g_old_rec.dated_table_id;
307: End If;
308: If (p_rec.column_name = hr_api.g_varchar2) then
309: p_rec.column_name :=
310: pay_dte_shd.g_old_rec.column_name;
311: End If;
312: If (p_rec.update_type = hr_api.g_varchar2) then
313: p_rec.update_type :=
314: pay_dte_shd.g_old_rec.update_type;

Line 314: pay_dte_shd.g_old_rec.update_type;

310: pay_dte_shd.g_old_rec.column_name;
311: End If;
312: If (p_rec.update_type = hr_api.g_varchar2) then
313: p_rec.update_type :=
314: pay_dte_shd.g_old_rec.update_type;
315: End If;
316: If (p_rec.business_group_id = hr_api.g_number) then
317: p_rec.business_group_id :=
318: pay_dte_shd.g_old_rec.business_group_id;

Line 318: pay_dte_shd.g_old_rec.business_group_id;

314: pay_dte_shd.g_old_rec.update_type;
315: End If;
316: If (p_rec.business_group_id = hr_api.g_number) then
317: p_rec.business_group_id :=
318: pay_dte_shd.g_old_rec.business_group_id;
319: End If;
320: If (p_rec.legislation_code = hr_api.g_varchar2) then
321: p_rec.legislation_code :=
322: pay_dte_shd.g_old_rec.legislation_code;

Line 322: pay_dte_shd.g_old_rec.legislation_code;

318: pay_dte_shd.g_old_rec.business_group_id;
319: End If;
320: If (p_rec.legislation_code = hr_api.g_varchar2) then
321: p_rec.legislation_code :=
322: pay_dte_shd.g_old_rec.legislation_code;
323: End If;
324: If (p_rec.proration_style = hr_api.g_varchar2) then
325: p_rec.proration_style :=
326: pay_dte_shd.g_old_rec.proration_style;

Line 326: pay_dte_shd.g_old_rec.proration_style;

322: pay_dte_shd.g_old_rec.legislation_code;
323: End If;
324: If (p_rec.proration_style = hr_api.g_varchar2) then
325: p_rec.proration_style :=
326: pay_dte_shd.g_old_rec.proration_style;
327: End If;
328: --
329: End convert_defs;
330: --

Line 336: ,p_rec in out nocopy pay_dte_shd.g_rec_type

332: -- |---------------------------------< upd >----------------------------------|
333: -- ----------------------------------------------------------------------------
334: Procedure upd
335: (p_effective_date in date
336: ,p_rec in out nocopy pay_dte_shd.g_rec_type
337: ) is
338: --
339: l_proc varchar2(72) := g_package||'upd';
340: --

Line 346: pay_dte_shd.lck

342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: -- We must lock the row which we need to update.
345: --
346: pay_dte_shd.lck
347: (p_rec.datetracked_event_id
348: ,p_rec.object_version_number
349: );
350: --

Line 395: l_rec pay_dte_shd.g_rec_type;

391: ,p_legislation_code in varchar2 default hr_api.g_varchar2
392: ,p_proration_style in varchar2 default hr_api.g_varchar2
393: ) is
394: --
395: l_rec pay_dte_shd.g_rec_type;
396: l_proc varchar2(72) := g_package||'upd';
397: --
398: Begin
399: hr_utility.set_location('Entering:'||l_proc, 5);

Line 405: pay_dte_shd.convert_args

401: -- Call conversion function to turn arguments into the
402: -- l_rec structure.
403: --
404: l_rec :=
405: pay_dte_shd.convert_args
406: (p_datetracked_event_id
407: ,p_event_group_id
408: ,p_dated_table_id
409: ,p_column_name