DBA Data[Home] [Help]

APPS.PAY_RCU_UPD dependencies on PAY_RCU_SHD

Line 55: (p_rec in out nocopy pay_rcu_shd.g_rec_type

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

Line 91: pay_rcu_shd.constraint_error

87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: --
91: pay_rcu_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_rcu_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_rcu_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_rcu_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_rcu_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_rcu_shd.g_rec_type

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

Line 186: ,p_rec in pay_rcu_shd.g_rec_type

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

Line 220: => pay_rcu_shd.g_old_rec.business_group_id

216: => p_rec.replace_run_flag
217: ,p_use_override_dates
218: => p_rec.use_override_dates
219: ,p_business_group_id_o
220: => pay_rcu_shd.g_old_rec.business_group_id
221: ,p_legislation_code_o
222: => pay_rcu_shd.g_old_rec.legislation_code
223: ,p_retro_component_id_o
224: => pay_rcu_shd.g_old_rec.retro_component_id

Line 222: => pay_rcu_shd.g_old_rec.legislation_code

218: => p_rec.use_override_dates
219: ,p_business_group_id_o
220: => pay_rcu_shd.g_old_rec.business_group_id
221: ,p_legislation_code_o
222: => pay_rcu_shd.g_old_rec.legislation_code
223: ,p_retro_component_id_o
224: => pay_rcu_shd.g_old_rec.retro_component_id
225: ,p_creator_id_o
226: => pay_rcu_shd.g_old_rec.creator_id

Line 224: => pay_rcu_shd.g_old_rec.retro_component_id

220: => pay_rcu_shd.g_old_rec.business_group_id
221: ,p_legislation_code_o
222: => pay_rcu_shd.g_old_rec.legislation_code
223: ,p_retro_component_id_o
224: => pay_rcu_shd.g_old_rec.retro_component_id
225: ,p_creator_id_o
226: => pay_rcu_shd.g_old_rec.creator_id
227: ,p_creator_type_o
228: => pay_rcu_shd.g_old_rec.creator_type

Line 226: => pay_rcu_shd.g_old_rec.creator_id

222: => pay_rcu_shd.g_old_rec.legislation_code
223: ,p_retro_component_id_o
224: => pay_rcu_shd.g_old_rec.retro_component_id
225: ,p_creator_id_o
226: => pay_rcu_shd.g_old_rec.creator_id
227: ,p_creator_type_o
228: => pay_rcu_shd.g_old_rec.creator_type
229: ,p_default_component_o
230: => pay_rcu_shd.g_old_rec.default_component

Line 228: => pay_rcu_shd.g_old_rec.creator_type

224: => pay_rcu_shd.g_old_rec.retro_component_id
225: ,p_creator_id_o
226: => pay_rcu_shd.g_old_rec.creator_id
227: ,p_creator_type_o
228: => pay_rcu_shd.g_old_rec.creator_type
229: ,p_default_component_o
230: => pay_rcu_shd.g_old_rec.default_component
231: ,p_reprocess_type_o
232: => pay_rcu_shd.g_old_rec.reprocess_type

Line 230: => pay_rcu_shd.g_old_rec.default_component

226: => pay_rcu_shd.g_old_rec.creator_id
227: ,p_creator_type_o
228: => pay_rcu_shd.g_old_rec.creator_type
229: ,p_default_component_o
230: => pay_rcu_shd.g_old_rec.default_component
231: ,p_reprocess_type_o
232: => pay_rcu_shd.g_old_rec.reprocess_type
233: ,p_object_version_number_o
234: => pay_rcu_shd.g_old_rec.object_version_number

Line 232: => pay_rcu_shd.g_old_rec.reprocess_type

228: => pay_rcu_shd.g_old_rec.creator_type
229: ,p_default_component_o
230: => pay_rcu_shd.g_old_rec.default_component
231: ,p_reprocess_type_o
232: => pay_rcu_shd.g_old_rec.reprocess_type
233: ,p_object_version_number_o
234: => pay_rcu_shd.g_old_rec.object_version_number
235: ,p_replace_run_flag_o
236: => pay_rcu_shd.g_old_rec.replace_run_flag

Line 234: => pay_rcu_shd.g_old_rec.object_version_number

230: => pay_rcu_shd.g_old_rec.default_component
231: ,p_reprocess_type_o
232: => pay_rcu_shd.g_old_rec.reprocess_type
233: ,p_object_version_number_o
234: => pay_rcu_shd.g_old_rec.object_version_number
235: ,p_replace_run_flag_o
236: => pay_rcu_shd.g_old_rec.replace_run_flag
237: ,p_use_override_dates_o
238: => pay_rcu_shd.g_old_rec.use_override_dates

Line 236: => pay_rcu_shd.g_old_rec.replace_run_flag

232: => pay_rcu_shd.g_old_rec.reprocess_type
233: ,p_object_version_number_o
234: => pay_rcu_shd.g_old_rec.object_version_number
235: ,p_replace_run_flag_o
236: => pay_rcu_shd.g_old_rec.replace_run_flag
237: ,p_use_override_dates_o
238: => pay_rcu_shd.g_old_rec.use_override_dates
239: );
240: --

Line 238: => pay_rcu_shd.g_old_rec.use_override_dates

234: => pay_rcu_shd.g_old_rec.object_version_number
235: ,p_replace_run_flag_o
236: => pay_rcu_shd.g_old_rec.replace_run_flag
237: ,p_use_override_dates_o
238: => pay_rcu_shd.g_old_rec.use_override_dates
239: );
240: --
241: exception
242: --

Line 298: (p_rec in out nocopy pay_rcu_shd.g_rec_type

294: --
295: -- {End Of Comments}
296: -- ----------------------------------------------------------------------------
297: Procedure convert_defs
298: (p_rec in out nocopy pay_rcu_shd.g_rec_type
299: ) is
300: --
301: Begin
302: --

Line 310: pay_rcu_shd.g_old_rec.business_group_id;

306: -- is being used then we must set to the 'current' argument value.
307: --
308: If (p_rec.business_group_id = hr_api.g_number) then
309: p_rec.business_group_id :=
310: pay_rcu_shd.g_old_rec.business_group_id;
311: End If;
312: If (p_rec.legislation_code = hr_api.g_varchar2) then
313: p_rec.legislation_code :=
314: pay_rcu_shd.g_old_rec.legislation_code;

Line 314: pay_rcu_shd.g_old_rec.legislation_code;

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

Line 318: pay_rcu_shd.g_old_rec.retro_component_id;

314: pay_rcu_shd.g_old_rec.legislation_code;
315: End If;
316: If (p_rec.retro_component_id = hr_api.g_number) then
317: p_rec.retro_component_id :=
318: pay_rcu_shd.g_old_rec.retro_component_id;
319: End If;
320: If (p_rec.creator_id = hr_api.g_number) then
321: p_rec.creator_id :=
322: pay_rcu_shd.g_old_rec.creator_id;

Line 322: pay_rcu_shd.g_old_rec.creator_id;

318: pay_rcu_shd.g_old_rec.retro_component_id;
319: End If;
320: If (p_rec.creator_id = hr_api.g_number) then
321: p_rec.creator_id :=
322: pay_rcu_shd.g_old_rec.creator_id;
323: End If;
324: If (p_rec.creator_type = hr_api.g_varchar2) then
325: p_rec.creator_type :=
326: pay_rcu_shd.g_old_rec.creator_type;

Line 326: pay_rcu_shd.g_old_rec.creator_type;

322: pay_rcu_shd.g_old_rec.creator_id;
323: End If;
324: If (p_rec.creator_type = hr_api.g_varchar2) then
325: p_rec.creator_type :=
326: pay_rcu_shd.g_old_rec.creator_type;
327: End If;
328: If (p_rec.default_component = hr_api.g_varchar2) then
329: p_rec.default_component :=
330: pay_rcu_shd.g_old_rec.default_component;

Line 330: pay_rcu_shd.g_old_rec.default_component;

326: pay_rcu_shd.g_old_rec.creator_type;
327: End If;
328: If (p_rec.default_component = hr_api.g_varchar2) then
329: p_rec.default_component :=
330: pay_rcu_shd.g_old_rec.default_component;
331: End If;
332: If (p_rec.reprocess_type = hr_api.g_varchar2) then
333: p_rec.reprocess_type :=
334: pay_rcu_shd.g_old_rec.reprocess_type;

Line 334: pay_rcu_shd.g_old_rec.reprocess_type;

330: pay_rcu_shd.g_old_rec.default_component;
331: End If;
332: If (p_rec.reprocess_type = hr_api.g_varchar2) then
333: p_rec.reprocess_type :=
334: pay_rcu_shd.g_old_rec.reprocess_type;
335: End If;
336: If (p_rec.replace_run_flag = hr_api.g_varchar2) then
337: p_rec.replace_run_flag :=
338: pay_rcu_shd.g_old_rec.replace_run_flag;

Line 338: pay_rcu_shd.g_old_rec.replace_run_flag;

334: pay_rcu_shd.g_old_rec.reprocess_type;
335: End If;
336: If (p_rec.replace_run_flag = hr_api.g_varchar2) then
337: p_rec.replace_run_flag :=
338: pay_rcu_shd.g_old_rec.replace_run_flag;
339: End If;
340: If (p_rec.use_override_dates = hr_api.g_varchar2) then
341: p_rec.use_override_dates :=
342: pay_rcu_shd.g_old_rec.use_override_dates;

Line 342: pay_rcu_shd.g_old_rec.use_override_dates;

338: pay_rcu_shd.g_old_rec.replace_run_flag;
339: End If;
340: If (p_rec.use_override_dates = hr_api.g_varchar2) then
341: p_rec.use_override_dates :=
342: pay_rcu_shd.g_old_rec.use_override_dates;
343: End If;
344: --
345: End convert_defs;
346: --

Line 352: ,p_rec in out nocopy pay_rcu_shd.g_rec_type

348: -- |---------------------------------< upd >----------------------------------|
349: -- ----------------------------------------------------------------------------
350: Procedure upd
351: (p_effective_date in date
352: ,p_rec in out nocopy pay_rcu_shd.g_rec_type
353: ) is
354: --
355: l_proc varchar2(72) := g_package||'upd';
356: --

Line 362: pay_rcu_shd.lck

358: hr_utility.set_location('Entering:'||l_proc, 5);
359: --
360: -- We must lock the row which we need to update.
361: --
362: pay_rcu_shd.lck
363: (p_rec.retro_component_usage_id
364: ,p_rec.object_version_number
365: );
366: --

Line 417: l_rec pay_rcu_shd.g_rec_type;

413: ,p_replace_run_flag in varchar2 default hr_api.g_varchar2
414: ,p_use_override_dates in varchar2 default hr_api.g_varchar2
415: ) is
416: --
417: l_rec pay_rcu_shd.g_rec_type;
418: l_proc varchar2(72) := g_package||'upd';
419: --
420: Begin
421: hr_utility.set_location('Entering:'||l_proc, 5);

Line 427: pay_rcu_shd.convert_args

423: -- Call conversion function to turn arguments into the
424: -- l_rec structure.
425: --
426: l_rec :=
427: pay_rcu_shd.convert_args
428: (p_retro_component_usage_id
429: ,hr_api.g_number
430: ,hr_api.g_varchar2
431: ,p_retro_component_id