eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CEI_DEL dependencies on PER_CEI_SHD

Line 52: (p_rec in per_cei_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in per_cei_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: per_cei_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: per_cei_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in per_cei_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in per_cei_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in per_cei_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in per_cei_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

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

162: begin
163: --
164: per_cei_rkd.after_delete
165: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
166: ,p_item_name_o => per_cei_shd.g_old_rec.item_name
167: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
168: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
169: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
170: ,p_column_size_o => per_cei_shd.g_old_rec.column_size

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

163: --
164: per_cei_rkd.after_delete
165: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
166: ,p_item_name_o => per_cei_shd.g_old_rec.item_name
167: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
168: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
169: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
170: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
171: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code

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

164: per_cei_rkd.after_delete
165: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
166: ,p_item_name_o => per_cei_shd.g_old_rec.item_name
167: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
168: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
169: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
170: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
171: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
172: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id

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

165: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
166: ,p_item_name_o => per_cei_shd.g_old_rec.item_name
167: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
168: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
169: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
170: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
171: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
172: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
173: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id

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

166: ,p_item_name_o => per_cei_shd.g_old_rec.item_name
167: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
168: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
169: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
170: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
171: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
172: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
173: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
174: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id

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

167: ,p_element_type_id_o => per_cei_shd.g_old_rec.element_type_id
168: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
169: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
170: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
171: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
172: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
173: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
174: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
175: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule

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

168: ,p_input_value_id_o => per_cei_shd.g_old_rec.input_value_id
169: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
170: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
171: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
172: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
173: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
174: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
175: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
176: ,p_category_name_o => per_cei_shd.g_old_rec.category_name

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

169: ,p_column_type_o => per_cei_shd.g_old_rec.column_type
170: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
171: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
172: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
173: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
174: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
175: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
176: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
177: ,p_uom_o => per_cei_shd.g_old_rec.uom

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

170: ,p_column_size_o => per_cei_shd.g_old_rec.column_size
171: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
172: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
173: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
174: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
175: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
176: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
177: ,p_uom_o => per_cei_shd.g_old_rec.uom
178: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id

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

171: ,p_legislation_code_o => per_cei_shd.g_old_rec.legislation_code
172: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
173: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
174: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
175: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
176: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
177: ,p_uom_o => per_cei_shd.g_old_rec.uom
178: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
179: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number

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

172: ,p_cagr_api_id_o => per_cei_shd.g_old_rec.cagr_api_id
173: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
174: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
175: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
176: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
177: ,p_uom_o => per_cei_shd.g_old_rec.uom
178: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
179: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
180: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id

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

173: ,p_cagr_api_param_id_o => per_cei_shd.g_old_rec.cagr_api_param_id
174: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
175: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
176: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
177: ,p_uom_o => per_cei_shd.g_old_rec.uom
178: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
179: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
180: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
181: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id

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

174: ,p_business_group_id_o => per_cei_shd.g_old_rec.business_group_id
175: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
176: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
177: ,p_uom_o => per_cei_shd.g_old_rec.uom
178: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
179: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
180: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
181: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
182: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag

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

175: ,p_beneficial_rule_o => per_cei_shd.g_old_rec.beneficial_rule
176: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
177: ,p_uom_o => per_cei_shd.g_old_rec.uom
178: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
179: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
180: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
181: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
182: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
183: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh

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

176: ,p_category_name_o => per_cei_shd.g_old_rec.category_name
177: ,p_uom_o => per_cei_shd.g_old_rec.uom
178: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
179: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
180: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
181: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
182: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
183: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh
184: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id);

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

177: ,p_uom_o => per_cei_shd.g_old_rec.uom
178: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
179: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
180: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
181: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
182: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
183: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh
184: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id);
185: --

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

178: ,p_flex_value_set_id_o => per_cei_shd.g_old_rec.flex_value_set_id
179: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
180: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
181: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
182: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
183: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh
184: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id);
185: --
186: exception

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

179: ,p_object_version_number_o => per_cei_shd.g_old_rec.object_version_number
180: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
181: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
182: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
183: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh
184: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id);
185: --
186: exception
187: --

Line 184: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id);

180: ,p_beneficial_formula_id_o => per_cei_shd.g_old_rec.beneficial_formula_id
181: ,p_ben_rule_value_set_id_o => per_cei_shd.g_old_rec.ben_rule_value_set_id
182: ,p_mult_entries_allowed_flag_o => per_cei_shd.g_old_rec.mult_entries_allowed_flag
183: ,p_auto_create_entries_flag_o => per_cei_shd.g_old_rec.auto_create_entries_flag -- CEI Enh
184: ,p_opt_id_o => per_cei_shd.g_old_rec.opt_id);
185: --
186: exception
187: --
188: when hr_api.cannot_find_prog_unit then

Line 203: (p_rec in per_cei_shd.g_rec_type

199: -- ----------------------------------------------------------------------------
200: -- |---------------------------------< del >----------------------------------|
201: -- ----------------------------------------------------------------------------
202: Procedure del
203: (p_rec in per_cei_shd.g_rec_type
204: ) is
205: --
206: l_proc varchar2(72) := g_package||'del';
207: --

Line 214: per_cei_shd.lck

210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: -- We must lock the row which we need to delete.
213: --
214: per_cei_shd.lck
215: (p_rec.cagr_entitlement_item_id,
216: p_rec.object_version_number
217: );
218: --

Line 246: l_rec per_cei_shd.g_rec_type;

242: ,p_object_version_number in number
243: ,p_effective_date in date
244: ) is
245: --
246: l_rec per_cei_shd.g_rec_type;
247: l_proc varchar2(72) := g_package||'del';
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);