DBA Data[Home] [Help]

APPS.PAY_ESU_UPD dependencies on PAY_ESU_SHD

Line 55: (p_rec in out nocopy pay_esu_shd.g_rec_type

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

Line 88: pay_esu_shd.constraint_error

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

Line 93: pay_esu_shd.constraint_error

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

Line 98: pay_esu_shd.constraint_error

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

Line 138: (p_rec in pay_esu_shd.g_rec_type

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

Line 183: ,p_rec in pay_esu_shd.g_rec_type

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

Line 211: => pay_esu_shd.g_old_rec.business_group_id

207: => p_rec.retro_element_type_id
208: ,p_object_version_number
209: => p_rec.object_version_number
210: ,p_business_group_id_o
211: => pay_esu_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o
213: => pay_esu_shd.g_old_rec.legislation_code
214: ,p_time_span_id_o
215: => pay_esu_shd.g_old_rec.time_span_id

Line 213: => pay_esu_shd.g_old_rec.legislation_code

209: => p_rec.object_version_number
210: ,p_business_group_id_o
211: => pay_esu_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o
213: => pay_esu_shd.g_old_rec.legislation_code
214: ,p_time_span_id_o
215: => pay_esu_shd.g_old_rec.time_span_id
216: ,p_retro_component_usage_id_o
217: => pay_esu_shd.g_old_rec.retro_component_usage_id

Line 215: => pay_esu_shd.g_old_rec.time_span_id

211: => pay_esu_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o
213: => pay_esu_shd.g_old_rec.legislation_code
214: ,p_time_span_id_o
215: => pay_esu_shd.g_old_rec.time_span_id
216: ,p_retro_component_usage_id_o
217: => pay_esu_shd.g_old_rec.retro_component_usage_id
218: ,p_adjustment_type_o
219: => pay_esu_shd.g_old_rec.adjustment_type

Line 217: => pay_esu_shd.g_old_rec.retro_component_usage_id

213: => pay_esu_shd.g_old_rec.legislation_code
214: ,p_time_span_id_o
215: => pay_esu_shd.g_old_rec.time_span_id
216: ,p_retro_component_usage_id_o
217: => pay_esu_shd.g_old_rec.retro_component_usage_id
218: ,p_adjustment_type_o
219: => pay_esu_shd.g_old_rec.adjustment_type
220: ,p_retro_element_type_id_o
221: => pay_esu_shd.g_old_rec.retro_element_type_id

Line 219: => pay_esu_shd.g_old_rec.adjustment_type

215: => pay_esu_shd.g_old_rec.time_span_id
216: ,p_retro_component_usage_id_o
217: => pay_esu_shd.g_old_rec.retro_component_usage_id
218: ,p_adjustment_type_o
219: => pay_esu_shd.g_old_rec.adjustment_type
220: ,p_retro_element_type_id_o
221: => pay_esu_shd.g_old_rec.retro_element_type_id
222: ,p_object_version_number_o
223: => pay_esu_shd.g_old_rec.object_version_number

Line 221: => pay_esu_shd.g_old_rec.retro_element_type_id

217: => pay_esu_shd.g_old_rec.retro_component_usage_id
218: ,p_adjustment_type_o
219: => pay_esu_shd.g_old_rec.adjustment_type
220: ,p_retro_element_type_id_o
221: => pay_esu_shd.g_old_rec.retro_element_type_id
222: ,p_object_version_number_o
223: => pay_esu_shd.g_old_rec.object_version_number
224: );
225: --

Line 223: => pay_esu_shd.g_old_rec.object_version_number

219: => pay_esu_shd.g_old_rec.adjustment_type
220: ,p_retro_element_type_id_o
221: => pay_esu_shd.g_old_rec.retro_element_type_id
222: ,p_object_version_number_o
223: => pay_esu_shd.g_old_rec.object_version_number
224: );
225: --
226: exception
227: --

Line 283: (p_rec in out nocopy pay_esu_shd.g_rec_type

279: --
280: -- {End Of Comments}
281: -- ----------------------------------------------------------------------------
282: Procedure convert_defs
283: (p_rec in out nocopy pay_esu_shd.g_rec_type
284: ) is
285: --
286: Begin
287: --

Line 295: pay_esu_shd.g_old_rec.business_group_id;

291: -- is being used then we must set to the 'current' argument value.
292: --
293: If (p_rec.business_group_id = hr_api.g_number) then
294: p_rec.business_group_id :=
295: pay_esu_shd.g_old_rec.business_group_id;
296: End If;
297: If (p_rec.legislation_code = hr_api.g_varchar2) then
298: p_rec.legislation_code :=
299: pay_esu_shd.g_old_rec.legislation_code;

Line 299: pay_esu_shd.g_old_rec.legislation_code;

295: pay_esu_shd.g_old_rec.business_group_id;
296: End If;
297: If (p_rec.legislation_code = hr_api.g_varchar2) then
298: p_rec.legislation_code :=
299: pay_esu_shd.g_old_rec.legislation_code;
300: End If;
301: If (p_rec.time_span_id = hr_api.g_number) then
302: p_rec.time_span_id :=
303: pay_esu_shd.g_old_rec.time_span_id;

Line 303: pay_esu_shd.g_old_rec.time_span_id;

299: pay_esu_shd.g_old_rec.legislation_code;
300: End If;
301: If (p_rec.time_span_id = hr_api.g_number) then
302: p_rec.time_span_id :=
303: pay_esu_shd.g_old_rec.time_span_id;
304: End If;
305: If (p_rec.retro_component_usage_id = hr_api.g_number) then
306: p_rec.retro_component_usage_id :=
307: pay_esu_shd.g_old_rec.retro_component_usage_id;

Line 307: pay_esu_shd.g_old_rec.retro_component_usage_id;

303: pay_esu_shd.g_old_rec.time_span_id;
304: End If;
305: If (p_rec.retro_component_usage_id = hr_api.g_number) then
306: p_rec.retro_component_usage_id :=
307: pay_esu_shd.g_old_rec.retro_component_usage_id;
308: End If;
309: If (p_rec.adjustment_type = hr_api.g_varchar2) then
310: p_rec.adjustment_type :=
311: pay_esu_shd.g_old_rec.adjustment_type;

Line 311: pay_esu_shd.g_old_rec.adjustment_type;

307: pay_esu_shd.g_old_rec.retro_component_usage_id;
308: End If;
309: If (p_rec.adjustment_type = hr_api.g_varchar2) then
310: p_rec.adjustment_type :=
311: pay_esu_shd.g_old_rec.adjustment_type;
312: End If;
313: If (p_rec.retro_element_type_id = hr_api.g_number) then
314: p_rec.retro_element_type_id :=
315: pay_esu_shd.g_old_rec.retro_element_type_id;

Line 315: pay_esu_shd.g_old_rec.retro_element_type_id;

311: pay_esu_shd.g_old_rec.adjustment_type;
312: End If;
313: If (p_rec.retro_element_type_id = hr_api.g_number) then
314: p_rec.retro_element_type_id :=
315: pay_esu_shd.g_old_rec.retro_element_type_id;
316: End If;
317: --
318: End convert_defs;
319: --

Line 325: ,p_rec in out nocopy pay_esu_shd.g_rec_type

321: -- |---------------------------------< upd >----------------------------------|
322: -- ----------------------------------------------------------------------------
323: Procedure upd
324: (p_effective_date in date
325: ,p_rec in out nocopy pay_esu_shd.g_rec_type
326: ) is
327: --
328: l_proc varchar2(72) := g_package||'upd';
329: --

Line 335: pay_esu_shd.lck

331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: -- We must lock the row which we need to update.
334: --
335: pay_esu_shd.lck
336: (p_rec.element_span_usage_id
337: ,p_rec.object_version_number
338: );
339: --

Line 387: l_rec pay_esu_shd.g_rec_type;

383: ,p_retro_element_type_id in number default hr_api.g_number
384: ,p_adjustment_type in varchar2 default hr_api.g_varchar2
385: ) is
386: --
387: l_rec pay_esu_shd.g_rec_type;
388: l_proc varchar2(72) := g_package||'upd';
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);

Line 397: pay_esu_shd.convert_args

393: -- Call conversion function to turn arguments into the
394: -- l_rec structure.
395: --
396: l_rec :=
397: pay_esu_shd.convert_args
398: (p_element_span_usage_id
399: ,hr_api.g_number
400: ,hr_api.g_varchar2
401: ,p_time_span_id