APPS.PER_CEI_UPD dependencies on PER_CEI_SHD

Line 55: (p_rec in out nocopy per_cei_shd.g_rec_type

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

Line 111: per_cei_shd.constraint_error

107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: --
111: per_cei_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --

Line 116: per_cei_shd.constraint_error

112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --
116: per_cei_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --

Line 121: per_cei_shd.constraint_error

117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: per_cei_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: --
125: Raise;

Line 161: (p_rec in per_cei_shd.g_rec_type

157: --
158: -- {End Of Comments}
159: -- ----------------------------------------------------------------------------
160: Procedure pre_update
161: (p_rec in per_cei_shd.g_rec_type
162: ) is
163: --
164: l_proc varchar2(72) := g_package||'pre_update';
165: --

Line 206: ,p_rec in per_cei_shd.g_rec_type

202: -- {End Of Comments}
203: -- ----------------------------------------------------------------------------
204: Procedure post_update
205: (p_effective_date in date
206: ,p_rec in per_cei_shd.g_rec_type
207: ) is
208: --
209: l_proc varchar2(72) := g_package||'post_update';
210: --

Line 237: ,p_item_name_o => per_cei_shd.g_old_rec.item_name

233: ,p_ben_rule_value_set_id => p_rec.ben_rule_value_set_id
234: ,p_mult_entries_allowed_flag => p_rec.mult_entries_allowed_flag
235: ,p_auto_create_entries_flag => p_rec.auto_create_entries_flag -- CEI Enh
236: ,p_opt_id => p_rec.opt_id
237: ,p_item_name_o => per_cei_shd.g_old_rec.item_name
238: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
239: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
240: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
241: ,p_column_size_o => per_cei_shd.g_old_rec.column_size

Line 238: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id

234: ,p_mult_entries_allowed_flag => p_rec.mult_entries_allowed_flag
235: ,p_auto_create_entries_flag => p_rec.auto_create_entries_flag -- CEI Enh
236: ,p_opt_id => p_rec.opt_id
237: ,p_item_name_o => per_cei_shd.g_old_rec.item_name
238: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
239: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
240: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
241: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
242: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code

Line 239: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id

235: ,p_auto_create_entries_flag => p_rec.auto_create_entries_flag -- CEI Enh
236: ,p_opt_id => p_rec.opt_id
237: ,p_item_name_o => per_cei_shd.g_old_rec.item_name
238: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
239: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
240: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
241: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
242: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
243: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id

Line 240: ,p_column_type_o => per_cei_shd.g_old_rec.column_type

236: ,p_opt_id => p_rec.opt_id
237: ,p_item_name_o => per_cei_shd.g_old_rec.item_name
238: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
239: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
240: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
241: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
242: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
243: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
244: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id

Line 241: ,p_column_size_o => per_cei_shd.g_old_rec.column_size

237: ,p_item_name_o => per_cei_shd.g_old_rec.item_name
238: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
239: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
240: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
241: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
242: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
243: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
244: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
245: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id

Line 242: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code

238: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
239: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
240: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
241: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
242: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
243: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
244: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
245: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
246: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id

Line 243: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id

239: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
240: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
241: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
242: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
243: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
244: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
245: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
246: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
247: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule

Line 244: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id

240: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
241: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
242: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
243: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
244: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
245: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
246: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
247: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
248: ,p_category_name_o => per_cei_shd.g_old_rec.category_name

Line 245: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id

241: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
242: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
243: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
244: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
245: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
246: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
247: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
248: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
249: ,p_uom_o => per_cei_shd.g_old_rec.uom

Line 246: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id

242: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
243: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
244: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
245: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
246: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
247: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
248: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
249: ,p_uom_o => per_cei_shd.g_old_rec.uom
250: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id

Line 247: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule

243: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
244: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
245: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
246: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
247: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
248: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
249: ,p_uom_o => per_cei_shd.g_old_rec.uom
250: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
251: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number

Line 248: ,p_category_name_o => per_cei_shd.g_old_rec.category_name

244: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
245: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
246: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
247: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
248: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
249: ,p_uom_o => per_cei_shd.g_old_rec.uom
250: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
251: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
252: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id

Line 249: ,p_uom_o => per_cei_shd.g_old_rec.uom

245: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
246: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
247: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
248: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
249: ,p_uom_o => per_cei_shd.g_old_rec.uom
250: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
251: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
252: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
253: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag

Line 250: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id

246: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
247: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
248: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
249: ,p_uom_o => per_cei_shd.g_old_rec.uom
250: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
251: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
252: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
253: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
254: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh

Line 251: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number

247: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
248: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
249: ,p_uom_o => per_cei_shd.g_old_rec.uom
250: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
251: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
252: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
253: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
254: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh
255: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id

Line 252: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id

248: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
249: ,p_uom_o => per_cei_shd.g_old_rec.uom
250: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
251: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
252: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
253: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
254: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh
255: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id
256: );

Line 253: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag

249: ,p_uom_o => per_cei_shd.g_old_rec.uom
250: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
251: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
252: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
253: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
254: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh
255: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id
256: );
257: --

Line 254: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh

250: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
251: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
252: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
253: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
254: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh
255: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id
256: );
257: --
258: exception

Line 255: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id

251: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
252: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
253: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
254: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh
255: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id
256: );
257: --
258: exception
259: --

Line 315: (p_rec in out nocopy per_cei_shd.g_rec_type

311: --
312: -- {End Of Comments}
313: -- ----------------------------------------------------------------------------
314: Procedure convert_defs
315: (p_rec in out nocopy per_cei_shd.g_rec_type
316: ) is
317: --
318: Begin
319: --

Line 327: per_cei_shd.g_old_rec.item_name;

323: -- is being used then we must set to the 'current' argument value.
324: --
325: If (p_rec.item_name = hr_api.g_varchar2) then
326: p_rec.item_name :=
327: per_cei_shd.g_old_rec.item_name;
328: End If;
329: If (p_rec.element_type_id = hr_api.g_number) then
330: p_rec.element_type_id :=
331: per_cei_shd.g_old_rec.element_type_id;

Line 331: per_cei_shd.g_old_rec.element_type_id;

327: per_cei_shd.g_old_rec.item_name;
328: End If;
329: If (p_rec.element_type_id = hr_api.g_number) then
330: p_rec.element_type_id :=
331: per_cei_shd.g_old_rec.element_type_id;
332: End If;
333: If (p_rec.input_value_id = hr_api.g_varchar2) then
334: p_rec.input_value_id :=
335: per_cei_shd.g_old_rec.input_value_id;

Line 335: per_cei_shd.g_old_rec.input_value_id;

331: per_cei_shd.g_old_rec.element_type_id;
332: End If;
333: If (p_rec.input_value_id = hr_api.g_varchar2) then
334: p_rec.input_value_id :=
335: per_cei_shd.g_old_rec.input_value_id;
336: End If;
337: --
338: If (p_rec.column_type = hr_api.g_varchar2) then
339: p_rec.column_type :=

Line 340: per_cei_shd.g_old_rec.column_type;

336: End If;
337: --
338: If (p_rec.column_type = hr_api.g_varchar2) then
339: p_rec.column_type :=
340: per_cei_shd.g_old_rec.column_type;
341: End If;
342: --
343: If (p_rec.column_size = hr_api.g_number) then
344: p_rec.column_size :=

Line 345: per_cei_shd.g_old_rec.column_size;

341: End If;
342: --
343: If (p_rec.column_size = hr_api.g_number) then
344: p_rec.column_size :=
345: per_cei_shd.g_old_rec.column_size;
346: End If;
347: --
348: If (p_rec.legislation_code = hr_api.g_varchar2) then
349: p_rec.legislation_code :=

Line 350: per_cei_shd.g_old_rec.legislation_code;

346: End If;
347: --
348: If (p_rec.legislation_code = hr_api.g_varchar2) then
349: p_rec.legislation_code :=
350: per_cei_shd.g_old_rec.legislation_code;
351: End If;
352: If (p_rec.beneficial_rule = hr_api.g_varchar2) then
353: p_rec.beneficial_rule :=
354: per_cei_shd.g_old_rec.beneficial_rule;

Line 354: per_cei_shd.g_old_rec.beneficial_rule;

350: per_cei_shd.g_old_rec.legislation_code;
351: End If;
352: If (p_rec.beneficial_rule = hr_api.g_varchar2) then
353: p_rec.beneficial_rule :=
354: per_cei_shd.g_old_rec.beneficial_rule;
355: End If;
356: If (p_rec.cagr_api_id = hr_api.g_number) then
357: p_rec.cagr_api_id :=
358: per_cei_shd.g_old_rec.cagr_api_id;

Line 358: per_cei_shd.g_old_rec.cagr_api_id;

354: per_cei_shd.g_old_rec.beneficial_rule;
355: End If;
356: If (p_rec.cagr_api_id = hr_api.g_number) then
357: p_rec.cagr_api_id :=
358: per_cei_shd.g_old_rec.cagr_api_id;
359: End If;
360: If (p_rec.cagr_api_param_id = hr_api.g_number) then
361: p_rec.cagr_api_param_id :=
362: per_cei_shd.g_old_rec.cagr_api_param_id;

Line 362: per_cei_shd.g_old_rec.cagr_api_param_id;

358: per_cei_shd.g_old_rec.cagr_api_id;
359: End If;
360: If (p_rec.cagr_api_param_id = hr_api.g_number) then
361: p_rec.cagr_api_param_id :=
362: per_cei_shd.g_old_rec.cagr_api_param_id;
363: End If;
364:
365: If (p_rec.business_group_id = hr_api.g_number) then
366: p_rec.business_group_id :=

Line 367: per_cei_shd.g_old_rec.business_group_id;

363: End If;
364:
365: If (p_rec.business_group_id = hr_api.g_number) then
366: p_rec.business_group_id :=
367: per_cei_shd.g_old_rec.business_group_id;
368: End If;
369: If (p_rec.beneficial_rule = hr_api.g_varchar2) then
370: p_rec.beneficial_rule :=
371: per_cei_shd.g_old_rec.beneficial_rule;

Line 371: per_cei_shd.g_old_rec.beneficial_rule;

367: per_cei_shd.g_old_rec.business_group_id;
368: End If;
369: If (p_rec.beneficial_rule = hr_api.g_varchar2) then
370: p_rec.beneficial_rule :=
371: per_cei_shd.g_old_rec.beneficial_rule;
372: End If;
373: If (p_rec.category_name = hr_api.g_varchar2) then
374: p_rec.category_name :=
375: per_cei_shd.g_old_rec.category_name;

Line 375: per_cei_shd.g_old_rec.category_name;

371: per_cei_shd.g_old_rec.beneficial_rule;
372: End If;
373: If (p_rec.category_name = hr_api.g_varchar2) then
374: p_rec.category_name :=
375: per_cei_shd.g_old_rec.category_name;
376: End If;
377: If (p_rec.uom = hr_api.g_varchar2) then
378: p_rec.uom :=
379: per_cei_shd.g_old_rec.uom;

Line 379: per_cei_shd.g_old_rec.uom;

375: per_cei_shd.g_old_rec.category_name;
376: End If;
377: If (p_rec.uom = hr_api.g_varchar2) then
378: p_rec.uom :=
379: per_cei_shd.g_old_rec.uom;
380: End If;
381: If (p_rec.flex_value_set_id = hr_api.g_number) then
382: p_rec.flex_value_set_id :=
383: per_cei_shd.g_old_rec.flex_value_set_id;

Line 383: per_cei_shd.g_old_rec.flex_value_set_id;

379: per_cei_shd.g_old_rec.uom;
380: End If;
381: If (p_rec.flex_value_set_id = hr_api.g_number) then
382: p_rec.flex_value_set_id :=
383: per_cei_shd.g_old_rec.flex_value_set_id;
384: End If;
385:
386: If (p_rec.beneficial_formula_id = hr_api.g_number) then
387: p_rec.beneficial_formula_id :=

Line 388: per_cei_shd.g_old_rec.beneficial_formula_id;

384: End If;
385:
386: If (p_rec.beneficial_formula_id = hr_api.g_number) then
387: p_rec.beneficial_formula_id :=
388: per_cei_shd.g_old_rec.beneficial_formula_id;
389: End If;
390: --
391:
392: If (p_rec.ben_rule_value_set_id = hr_api.g_number) then

Line 394: per_cei_shd.g_old_rec.ben_rule_value_set_id;

390: --
391:
392: If (p_rec.ben_rule_value_set_id = hr_api.g_number) then
393: p_rec.ben_rule_value_set_id :=
394: per_cei_shd.g_old_rec.ben_rule_value_set_id;
395: End If;
396: --
397:
398: If (p_rec.mult_entries_allowed_flag = hr_api.g_varchar2) then

Line 400: per_cei_shd.g_old_rec.mult_entries_allowed_flag;

396: --
397:
398: If (p_rec.mult_entries_allowed_flag = hr_api.g_varchar2) then
399: p_rec.mult_entries_allowed_flag :=
400: per_cei_shd.g_old_rec.mult_entries_allowed_flag;
401: End If;
402: -- -- CEI Enh
403: IF (p_rec.auto_create_entries_flag = hr_api.g_varchar2) THEN -- CEI Enh
404: p_rec.auto_create_entries_flag := -- CEI Enh

Line 405: per_cei_shd.g_old_rec.auto_create_entries_flag; -- CEI Enh

401: End If;
402: -- -- CEI Enh
403: IF (p_rec.auto_create_entries_flag = hr_api.g_varchar2) THEN -- CEI Enh
404: p_rec.auto_create_entries_flag := -- CEI Enh
405: per_cei_shd.g_old_rec.auto_create_entries_flag; -- CEI Enh
406: END IF; -- CEI Enh
407: --
408: If (p_rec.opt_id = hr_api.g_number) then
409: p_rec.opt_id := per_cei_shd.g_old_rec.opt_id;

Line 409: p_rec.opt_id := per_cei_shd.g_old_rec.opt_id;

405: per_cei_shd.g_old_rec.auto_create_entries_flag; -- CEI Enh
406: END IF; -- CEI Enh
407: --
408: If (p_rec.opt_id = hr_api.g_number) then
409: p_rec.opt_id := per_cei_shd.g_old_rec.opt_id;
410: End If;
411: --
412: End convert_defs;
413: --

Line 419: ,p_rec in out nocopy per_cei_shd.g_rec_type

415: -- |---------------------------------< upd >----------------------------------|
416: -- ----------------------------------------------------------------------------
417: Procedure upd
418: (p_effective_date in date
419: ,p_rec in out nocopy per_cei_shd.g_rec_type
420: ) is
421: --
422: l_proc varchar2(72) := g_package||'upd';
423: --

Line 429: per_cei_shd.lck

425: hr_utility.set_location('Entering:'||l_proc, 5);
426: --
427: -- We must lock the row which we need to update.
428: --
429: per_cei_shd.lck
430: (p_rec.cagr_entitlement_item_id,
431: p_rec.object_version_number
432: );
433: --

Line 490: l_rec per_cei_shd.g_rec_type;

486: ,p_auto_create_entries_flag in varchar2 default hr_api.g_varchar2 -- CEI Enh
487:
488: ) is
489: --
490: l_rec per_cei_shd.g_rec_type;
491: l_proc varchar2(72) := g_package||'upd';
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);

Line 499: l_rec := per_cei_shd.convert_args

495: --
496: -- Call conversion function to turn arguments into the
497: -- l_rec structure.
498: --
499: l_rec := per_cei_shd.convert_args
500: (p_cagr_entitlement_item_id
501: ,p_item_name
502: ,p_element_type_id
503: ,p_input_value_id