DBA Data[Home] [Help]

APPS.HXC_TER_DEL dependencies on HXC_TER_SHD

Line 54: (p_rec in hxc_ter_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure delete_dml
54: (p_rec in hxc_ter_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72);
58: --

Line 67: hxc_ter_shd.g_api_dml := true; -- Set the api dml status

63: l_proc := g_package||'delete_dml';
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: end if;
66: --
67: hxc_ter_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Delete the hxc_time_entry_rules row.
70: --
71: delete from hxc_time_entry_rules

Line 74: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status

70: --
71: delete from hxc_time_entry_rules
72: where time_entry_rule_id = p_rec.time_entry_rule_id;
73: --
74: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
75: --
76: if g_debug then
77: hr_utility.set_location(' Leaving:'||l_proc, 10);
78: end if;

Line 83: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status

79: --
80: Exception
81: When hr_api.child_integrity_violated then
82: -- Child integrity has been violated
83: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
84: hxc_ter_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status

Line 84: hxc_ter_shd.constraint_error

80: Exception
81: When hr_api.child_integrity_violated then
82: -- Child integrity has been violated
83: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
84: hxc_ter_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
88: Raise;

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

83: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
84: hxc_ter_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
88: Raise;
89: End delete_dml;
90: --
91: -- ----------------------------------------------------------------------------

Line 123: Procedure pre_delete(p_rec in hxc_ter_shd.g_rec_type) is

119: -- Internal Row Handler Use Only.
120: --
121: -- {End Of Comments}
122: -- ----------------------------------------------------------------------------
123: Procedure pre_delete(p_rec in hxc_ter_shd.g_rec_type) is
124: --
125: l_proc varchar2(72);
126: --
127: Begin

Line 170: Procedure post_delete(p_rec in hxc_ter_shd.g_rec_type) is

166: -- Internal Row Handler Use Only.
167: --
168: -- {End Of Comments}
169: -- -----------------------------------------------------------------------------
170: Procedure post_delete(p_rec in hxc_ter_shd.g_rec_type) is
171: --
172: l_proc varchar2(72);
173: --
174: Begin

Line 187: => hxc_ter_shd.g_old_rec.name

183: hxc_ter_rkd.after_delete
184: (p_time_entry_rule_id
185: => p_rec.time_entry_rule_id
186: ,p_name_o
187: => hxc_ter_shd.g_old_rec.name
188: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
189: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
190: ,p_mapping_id_o => hxc_ter_shd.g_old_rec.mapping_id
191: ,p_rule_usage_o

Line 188: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id

184: (p_time_entry_rule_id
185: => p_rec.time_entry_rule_id
186: ,p_name_o
187: => hxc_ter_shd.g_old_rec.name
188: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
189: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
190: ,p_mapping_id_o => hxc_ter_shd.g_old_rec.mapping_id
191: ,p_rule_usage_o
192: => hxc_ter_shd.g_old_rec.rule_usage

Line 189: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code

185: => p_rec.time_entry_rule_id
186: ,p_name_o
187: => hxc_ter_shd.g_old_rec.name
188: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
189: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
190: ,p_mapping_id_o => hxc_ter_shd.g_old_rec.mapping_id
191: ,p_rule_usage_o
192: => hxc_ter_shd.g_old_rec.rule_usage
193: ,p_formula_id_o

Line 190: ,p_mapping_id_o => hxc_ter_shd.g_old_rec.mapping_id

186: ,p_name_o
187: => hxc_ter_shd.g_old_rec.name
188: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
189: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
190: ,p_mapping_id_o => hxc_ter_shd.g_old_rec.mapping_id
191: ,p_rule_usage_o
192: => hxc_ter_shd.g_old_rec.rule_usage
193: ,p_formula_id_o
194: => hxc_ter_shd.g_old_rec.formula_id

Line 192: => hxc_ter_shd.g_old_rec.rule_usage

188: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
189: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
190: ,p_mapping_id_o => hxc_ter_shd.g_old_rec.mapping_id
191: ,p_rule_usage_o
192: => hxc_ter_shd.g_old_rec.rule_usage
193: ,p_formula_id_o
194: => hxc_ter_shd.g_old_rec.formula_id
195: ,p_description_o
196: => hxc_ter_shd.g_old_rec.description

Line 194: => hxc_ter_shd.g_old_rec.formula_id

190: ,p_mapping_id_o => hxc_ter_shd.g_old_rec.mapping_id
191: ,p_rule_usage_o
192: => hxc_ter_shd.g_old_rec.rule_usage
193: ,p_formula_id_o
194: => hxc_ter_shd.g_old_rec.formula_id
195: ,p_description_o
196: => hxc_ter_shd.g_old_rec.description
197: ,p_start_date_o
198: => hxc_ter_shd.g_old_rec.start_date

Line 196: => hxc_ter_shd.g_old_rec.description

192: => hxc_ter_shd.g_old_rec.rule_usage
193: ,p_formula_id_o
194: => hxc_ter_shd.g_old_rec.formula_id
195: ,p_description_o
196: => hxc_ter_shd.g_old_rec.description
197: ,p_start_date_o
198: => hxc_ter_shd.g_old_rec.start_date
199: ,p_end_date_o
200: => hxc_ter_shd.g_old_rec.end_date

Line 198: => hxc_ter_shd.g_old_rec.start_date

194: => hxc_ter_shd.g_old_rec.formula_id
195: ,p_description_o
196: => hxc_ter_shd.g_old_rec.description
197: ,p_start_date_o
198: => hxc_ter_shd.g_old_rec.start_date
199: ,p_end_date_o
200: => hxc_ter_shd.g_old_rec.end_date
201: ,p_object_version_number_o
202: => hxc_ter_shd.g_old_rec.object_version_number

Line 200: => hxc_ter_shd.g_old_rec.end_date

196: => hxc_ter_shd.g_old_rec.description
197: ,p_start_date_o
198: => hxc_ter_shd.g_old_rec.start_date
199: ,p_end_date_o
200: => hxc_ter_shd.g_old_rec.end_date
201: ,p_object_version_number_o
202: => hxc_ter_shd.g_old_rec.object_version_number
203: ,p_attribute_category_o
204: => hxc_hph_shd.g_old_rec.attribute_category

Line 202: => hxc_ter_shd.g_old_rec.object_version_number

198: => hxc_ter_shd.g_old_rec.start_date
199: ,p_end_date_o
200: => hxc_ter_shd.g_old_rec.end_date
201: ,p_object_version_number_o
202: => hxc_ter_shd.g_old_rec.object_version_number
203: ,p_attribute_category_o
204: => hxc_hph_shd.g_old_rec.attribute_category
205: ,p_attribute1_o
206: => hxc_hph_shd.g_old_rec.attribute1

Line 286: (p_rec in hxc_ter_shd.g_rec_type

282: -- ----------------------------------------------------------------------------
283: -- |---------------------------------< del >----------------------------------|
284: -- ----------------------------------------------------------------------------
285: Procedure del
286: (p_rec in hxc_ter_shd.g_rec_type
287: ) is
288: --
289: l_proc varchar2(72);
290: --

Line 301: hxc_ter_shd.lck

297: end if;
298: --
299: -- We must lock the row which we need to delete.
300: --
301: hxc_ter_shd.lck
302: (p_rec.time_entry_rule_id
303: ,p_rec.object_version_number
304: );
305: --

Line 332: l_rec hxc_ter_shd.g_rec_type;

328: (p_time_entry_rule_id in number
329: ,p_object_version_number in number
330: ) is
331: --
332: l_rec hxc_ter_shd.g_rec_type;
333: l_proc varchar2(72);
334: --
335: Begin
336: g_debug := hr_utility.debug_enabled;