APPS.BEN_PUM_UPD dependencies on BEN_PUM_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_pum_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_pum_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ben_pum_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_pum_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_pop_up_messages Row
68: --
69: update ben_pop_up_messages

Line 87: ben_pum_shd.g_api_dml := false; -- Unset the api dml status

83: end_date = p_rec.end_date,
84: no_formula_flag = p_rec.no_formula_flag
85: where pop_up_messages_id = p_rec.pop_up_messages_id;
86: --
87: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: --
91: Exception

Line 94: ben_pum_shd.g_api_dml := false; -- Unset the api dml status

90: --
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
95: ben_pum_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated

Line 95: ben_pum_shd.constraint_error

91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
95: ben_pum_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: ben_pum_shd.g_api_dml := false; -- Unset the api dml status

Line 99: ben_pum_shd.g_api_dml := false; -- Unset the api dml status

95: ben_pum_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
100: ben_pum_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated

Line 100: ben_pum_shd.constraint_error

96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
100: ben_pum_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: ben_pum_shd.g_api_dml := false; -- Unset the api dml status

Line 104: ben_pum_shd.g_api_dml := false; -- Unset the api dml status

100: ben_pum_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
105: ben_pum_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: ben_pum_shd.g_api_dml := false; -- Unset the api dml status

Line 105: ben_pum_shd.constraint_error

101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
105: ben_pum_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
109: Raise;

Line 108: ben_pum_shd.g_api_dml := false; -- Unset the api dml status

104: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
105: ben_pum_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
109: Raise;
110: End update_dml;
111: --
112: -- ----------------------------------------------------------------------------

Line 144: Procedure pre_update(p_rec in ben_pum_shd.g_rec_type) is

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

Line 187: p_effective_date in date,p_rec in ben_pum_shd.g_rec_type) is

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

Line 216: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name

212: ,p_start_date =>p_rec.start_date
213: ,p_end_date =>p_rec.end_date
214: ,p_no_formula_flag =>p_rec.no_formula_flag
215: ,p_effective_date =>p_effective_date
216: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name
217: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
218: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
219: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
220: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name

Line 217: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id

213: ,p_end_date =>p_rec.end_date
214: ,p_no_formula_flag =>p_rec.no_formula_flag
215: ,p_effective_date =>p_effective_date
216: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name
217: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
218: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
219: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
220: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
221: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name

Line 218: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name

214: ,p_no_formula_flag =>p_rec.no_formula_flag
215: ,p_effective_date =>p_effective_date
216: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name
217: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
218: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
219: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
220: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
221: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
222: ,p_message_o =>ben_pum_shd.g_old_rec.message

Line 219: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name

215: ,p_effective_date =>p_effective_date
216: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name
217: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
218: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
219: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
220: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
221: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
222: ,p_message_o =>ben_pum_shd.g_old_rec.message
223: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type

Line 220: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name

216: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name
217: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
218: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
219: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
220: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
221: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
222: ,p_message_o =>ben_pum_shd.g_old_rec.message
223: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
224: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id

Line 221: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name

217: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
218: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
219: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
220: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
221: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
222: ,p_message_o =>ben_pum_shd.g_old_rec.message
223: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
224: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
225: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number

Line 222: ,p_message_o =>ben_pum_shd.g_old_rec.message

218: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
219: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
220: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
221: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
222: ,p_message_o =>ben_pum_shd.g_old_rec.message
223: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
224: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
225: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
226: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date

Line 223: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type

219: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
220: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
221: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
222: ,p_message_o =>ben_pum_shd.g_old_rec.message
223: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
224: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
225: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
226: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
227: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date

Line 224: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id

220: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
221: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
222: ,p_message_o =>ben_pum_shd.g_old_rec.message
223: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
224: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
225: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
226: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
227: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date
228: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag

Line 225: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number

221: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
222: ,p_message_o =>ben_pum_shd.g_old_rec.message
223: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
224: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
225: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
226: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
227: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date
228: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag
229: );

Line 226: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date

222: ,p_message_o =>ben_pum_shd.g_old_rec.message
223: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
224: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
225: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
226: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
227: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date
228: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag
229: );
230: --

Line 227: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date

223: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
224: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
225: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
226: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
227: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date
228: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag
229: );
230: --
231: exception

Line 228: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag

224: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
225: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
226: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
227: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date
228: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag
229: );
230: --
231: exception
232: --

Line 290: Procedure convert_defs(p_rec in out nocopy ben_pum_shd.g_rec_type) is

286: -- Internal Row Handler Use Only.
287: --
288: -- {End Of Comments}
289: -- ----------------------------------------------------------------------------
290: Procedure convert_defs(p_rec in out nocopy ben_pum_shd.g_rec_type) is
291: --
292: l_proc varchar2(72) := g_package||'convert_defs';
293: --
294: Begin

Line 305: ben_pum_shd.g_old_rec.pop_name;

301: -- is being used then we must set to the 'current' argument value.
302: --
303: If (p_rec.pop_name = hr_api.g_varchar2) then
304: p_rec.pop_name :=
305: ben_pum_shd.g_old_rec.pop_name;
306: End If;
307: If (p_rec.formula_id = hr_api.g_number) then
308: p_rec.formula_id :=
309: ben_pum_shd.g_old_rec.formula_id;

Line 309: ben_pum_shd.g_old_rec.formula_id;

305: ben_pum_shd.g_old_rec.pop_name;
306: End If;
307: If (p_rec.formula_id = hr_api.g_number) then
308: p_rec.formula_id :=
309: ben_pum_shd.g_old_rec.formula_id;
310: End If;
311: If (p_rec.function_name = hr_api.g_varchar2) then
312: p_rec.function_name :=
313: ben_pum_shd.g_old_rec.function_name;

Line 313: ben_pum_shd.g_old_rec.function_name;

309: ben_pum_shd.g_old_rec.formula_id;
310: End If;
311: If (p_rec.function_name = hr_api.g_varchar2) then
312: p_rec.function_name :=
313: ben_pum_shd.g_old_rec.function_name;
314: End If;
315: If (p_rec.block_name = hr_api.g_varchar2) then
316: p_rec.block_name :=
317: ben_pum_shd.g_old_rec.block_name;

Line 317: ben_pum_shd.g_old_rec.block_name;

313: ben_pum_shd.g_old_rec.function_name;
314: End If;
315: If (p_rec.block_name = hr_api.g_varchar2) then
316: p_rec.block_name :=
317: ben_pum_shd.g_old_rec.block_name;
318: End If;
319: If (p_rec.field_name = hr_api.g_varchar2) then
320: p_rec.field_name :=
321: ben_pum_shd.g_old_rec.field_name;

Line 321: ben_pum_shd.g_old_rec.field_name;

317: ben_pum_shd.g_old_rec.block_name;
318: End If;
319: If (p_rec.field_name = hr_api.g_varchar2) then
320: p_rec.field_name :=
321: ben_pum_shd.g_old_rec.field_name;
322: End If;
323: If (p_rec.event_name = hr_api.g_varchar2) then
324: p_rec.event_name :=
325: ben_pum_shd.g_old_rec.event_name;

Line 325: ben_pum_shd.g_old_rec.event_name;

321: ben_pum_shd.g_old_rec.field_name;
322: End If;
323: If (p_rec.event_name = hr_api.g_varchar2) then
324: p_rec.event_name :=
325: ben_pum_shd.g_old_rec.event_name;
326: End If;
327: If (p_rec.message = hr_api.g_varchar2) then
328: p_rec.message :=
329: ben_pum_shd.g_old_rec.message;

Line 329: ben_pum_shd.g_old_rec.message;

325: ben_pum_shd.g_old_rec.event_name;
326: End If;
327: If (p_rec.message = hr_api.g_varchar2) then
328: p_rec.message :=
329: ben_pum_shd.g_old_rec.message;
330: End If;
331: If (p_rec.message_type = hr_api.g_varchar2) then
332: p_rec.message_type :=
333: ben_pum_shd.g_old_rec.message_type;

Line 333: ben_pum_shd.g_old_rec.message_type;

329: ben_pum_shd.g_old_rec.message;
330: End If;
331: If (p_rec.message_type = hr_api.g_varchar2) then
332: p_rec.message_type :=
333: ben_pum_shd.g_old_rec.message_type;
334: End If;
335: If (p_rec.business_group_id = hr_api.g_number) then
336: p_rec.business_group_id :=
337: ben_pum_shd.g_old_rec.business_group_id;

Line 337: ben_pum_shd.g_old_rec.business_group_id;

333: ben_pum_shd.g_old_rec.message_type;
334: End If;
335: If (p_rec.business_group_id = hr_api.g_number) then
336: p_rec.business_group_id :=
337: ben_pum_shd.g_old_rec.business_group_id;
338: End If;
339: If (p_rec.start_date = hr_api.g_date) then
340: p_rec.start_date :=
341: ben_pum_shd.g_old_rec.start_date;

Line 341: ben_pum_shd.g_old_rec.start_date;

337: ben_pum_shd.g_old_rec.business_group_id;
338: End If;
339: If (p_rec.start_date = hr_api.g_date) then
340: p_rec.start_date :=
341: ben_pum_shd.g_old_rec.start_date;
342: End If;
343: If (p_rec.end_date = hr_api.g_date) then
344: p_rec.end_date :=
345: ben_pum_shd.g_old_rec.end_date;

Line 345: ben_pum_shd.g_old_rec.end_date;

341: ben_pum_shd.g_old_rec.start_date;
342: End If;
343: If (p_rec.end_date = hr_api.g_date) then
344: p_rec.end_date :=
345: ben_pum_shd.g_old_rec.end_date;
346: End If;
347: If (p_rec.no_formula_flag = hr_api.g_varchar2) then
348: p_rec.no_formula_flag :=
349: ben_pum_shd.g_old_rec.no_formula_flag;

Line 349: ben_pum_shd.g_old_rec.no_formula_flag;

345: ben_pum_shd.g_old_rec.end_date;
346: End If;
347: If (p_rec.no_formula_flag = hr_api.g_varchar2) then
348: p_rec.no_formula_flag :=
349: ben_pum_shd.g_old_rec.no_formula_flag;
350: End If;
351: --
352: hr_utility.set_location(' Leaving:'||l_proc, 10);
353: --

Line 362: p_rec in out nocopy ben_pum_shd.g_rec_type

358: -- ----------------------------------------------------------------------------
359: Procedure upd
360: (
361: p_effective_date in date,
362: p_rec in out nocopy ben_pum_shd.g_rec_type
363: ) is
364: --
365: l_proc varchar2(72) := g_package||'upd';
366: --

Line 372: ben_pum_shd.lck

368: hr_utility.set_location('Entering:'||l_proc, 5);
369: --
370: -- We must lock the row which we need to update.
371: --
372: ben_pum_shd.lck
373: (
374: p_rec.pop_up_messages_id,
375: p_rec.object_version_number
376: );

Line 424: l_rec ben_pum_shd.g_rec_type;

420: p_end_date in date default hr_api.g_date,
421: p_no_formula_flag in varchar2 default hr_api.g_varchar2
422: ) is
423: --
424: l_rec ben_pum_shd.g_rec_type;
425: l_proc varchar2(72) := g_package||'upd';
426: --
427: Begin
428: hr_utility.set_location('Entering:'||l_proc, 5);

Line 434: ben_pum_shd.convert_args

430: -- Call conversion function to turn arguments into the
431: -- l_rec structure.
432: --
433: l_rec :=
434: ben_pum_shd.convert_args
435: (
436: p_pop_up_messages_id,
437: p_pop_name,
438: p_formula_id,