DBA Data[Home] [Help]

APPS.PAY_TDF_DEL dependencies on PAY_TDF_SHD

Line 86: (p_rec in pay_tdf_shd.g_rec_type

82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in pay_tdf_shd.g_rec_type
87: ) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --

Line 94: pay_tdf_shd.g_api_dml := true; -- Set the api dml status

90: --
91: Begin
92: hr_utility.set_location('Entering:'||l_proc, 5);
93: --
94: pay_tdf_shd.g_api_dml := true; -- Set the api dml status
95: --
96: -- Delete the pay_time_definitions row.
97: --
98: delete from pay_time_definitions

Line 101: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status

97: --
98: delete from pay_time_definitions
99: where time_definition_id = p_rec.time_definition_id;
100: --
101: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: --
105: Exception

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

104: --
105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
109: pay_tdf_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status

Line 109: pay_tdf_shd.constraint_error

105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
109: pay_tdf_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;

Line 112: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status

108: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
109: pay_tdf_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;
114: End delete_dml;
115: --
116: -- ----------------------------------------------------------------------------

Line 148: Procedure pre_delete(p_rec in pay_tdf_shd.g_rec_type) is

144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_delete(p_rec in pay_tdf_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'pre_delete';
151: --
152: Begin

Line 190: Procedure post_delete(p_rec in pay_tdf_shd.g_rec_type) is

186: -- Internal Row Handler Use Only.
187: --
188: -- {End Of Comments}
189: -- -----------------------------------------------------------------------------
190: Procedure post_delete(p_rec in pay_tdf_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin

Line 207: => pay_tdf_shd.g_old_rec.short_name

203: pay_tdf_rkd.after_delete
204: (p_time_definition_id
205: => p_rec.time_definition_id
206: ,p_short_name_o
207: => pay_tdf_shd.g_old_rec.short_name
208: ,p_definition_name_o
209: => pay_tdf_shd.g_old_rec.definition_name
210: ,p_period_type_o
211: => pay_tdf_shd.g_old_rec.period_type

Line 209: => pay_tdf_shd.g_old_rec.definition_name

205: => p_rec.time_definition_id
206: ,p_short_name_o
207: => pay_tdf_shd.g_old_rec.short_name
208: ,p_definition_name_o
209: => pay_tdf_shd.g_old_rec.definition_name
210: ,p_period_type_o
211: => pay_tdf_shd.g_old_rec.period_type
212: ,p_period_unit_o
213: => pay_tdf_shd.g_old_rec.period_unit

Line 211: => pay_tdf_shd.g_old_rec.period_type

207: => pay_tdf_shd.g_old_rec.short_name
208: ,p_definition_name_o
209: => pay_tdf_shd.g_old_rec.definition_name
210: ,p_period_type_o
211: => pay_tdf_shd.g_old_rec.period_type
212: ,p_period_unit_o
213: => pay_tdf_shd.g_old_rec.period_unit
214: ,p_day_adjustment_o
215: => pay_tdf_shd.g_old_rec.day_adjustment

Line 213: => pay_tdf_shd.g_old_rec.period_unit

209: => pay_tdf_shd.g_old_rec.definition_name
210: ,p_period_type_o
211: => pay_tdf_shd.g_old_rec.period_type
212: ,p_period_unit_o
213: => pay_tdf_shd.g_old_rec.period_unit
214: ,p_day_adjustment_o
215: => pay_tdf_shd.g_old_rec.day_adjustment
216: ,p_dynamic_code_o
217: => pay_tdf_shd.g_old_rec.dynamic_code

Line 215: => pay_tdf_shd.g_old_rec.day_adjustment

211: => pay_tdf_shd.g_old_rec.period_type
212: ,p_period_unit_o
213: => pay_tdf_shd.g_old_rec.period_unit
214: ,p_day_adjustment_o
215: => pay_tdf_shd.g_old_rec.day_adjustment
216: ,p_dynamic_code_o
217: => pay_tdf_shd.g_old_rec.dynamic_code
218: ,p_business_group_id_o
219: => pay_tdf_shd.g_old_rec.business_group_id

Line 217: => pay_tdf_shd.g_old_rec.dynamic_code

213: => pay_tdf_shd.g_old_rec.period_unit
214: ,p_day_adjustment_o
215: => pay_tdf_shd.g_old_rec.day_adjustment
216: ,p_dynamic_code_o
217: => pay_tdf_shd.g_old_rec.dynamic_code
218: ,p_business_group_id_o
219: => pay_tdf_shd.g_old_rec.business_group_id
220: ,p_legislation_code_o
221: => pay_tdf_shd.g_old_rec.legislation_code

Line 219: => pay_tdf_shd.g_old_rec.business_group_id

215: => pay_tdf_shd.g_old_rec.day_adjustment
216: ,p_dynamic_code_o
217: => pay_tdf_shd.g_old_rec.dynamic_code
218: ,p_business_group_id_o
219: => pay_tdf_shd.g_old_rec.business_group_id
220: ,p_legislation_code_o
221: => pay_tdf_shd.g_old_rec.legislation_code
222: ,p_definition_type_o
223: => pay_tdf_shd.g_old_rec.definition_type

Line 221: => pay_tdf_shd.g_old_rec.legislation_code

217: => pay_tdf_shd.g_old_rec.dynamic_code
218: ,p_business_group_id_o
219: => pay_tdf_shd.g_old_rec.business_group_id
220: ,p_legislation_code_o
221: => pay_tdf_shd.g_old_rec.legislation_code
222: ,p_definition_type_o
223: => pay_tdf_shd.g_old_rec.definition_type
224: ,p_number_of_years_o
225: => pay_tdf_shd.g_old_rec.number_of_years

Line 223: => pay_tdf_shd.g_old_rec.definition_type

219: => pay_tdf_shd.g_old_rec.business_group_id
220: ,p_legislation_code_o
221: => pay_tdf_shd.g_old_rec.legislation_code
222: ,p_definition_type_o
223: => pay_tdf_shd.g_old_rec.definition_type
224: ,p_number_of_years_o
225: => pay_tdf_shd.g_old_rec.number_of_years
226: ,p_start_date_o
227: => pay_tdf_shd.g_old_rec.start_date

Line 225: => pay_tdf_shd.g_old_rec.number_of_years

221: => pay_tdf_shd.g_old_rec.legislation_code
222: ,p_definition_type_o
223: => pay_tdf_shd.g_old_rec.definition_type
224: ,p_number_of_years_o
225: => pay_tdf_shd.g_old_rec.number_of_years
226: ,p_start_date_o
227: => pay_tdf_shd.g_old_rec.start_date
228: ,p_period_time_definition_id_o
229: => pay_tdf_shd.g_old_rec.period_time_definition_id

Line 227: => pay_tdf_shd.g_old_rec.start_date

223: => pay_tdf_shd.g_old_rec.definition_type
224: ,p_number_of_years_o
225: => pay_tdf_shd.g_old_rec.number_of_years
226: ,p_start_date_o
227: => pay_tdf_shd.g_old_rec.start_date
228: ,p_period_time_definition_id_o
229: => pay_tdf_shd.g_old_rec.period_time_definition_id
230: ,p_creator_id_o
231: => pay_tdf_shd.g_old_rec.creator_id

Line 229: => pay_tdf_shd.g_old_rec.period_time_definition_id

225: => pay_tdf_shd.g_old_rec.number_of_years
226: ,p_start_date_o
227: => pay_tdf_shd.g_old_rec.start_date
228: ,p_period_time_definition_id_o
229: => pay_tdf_shd.g_old_rec.period_time_definition_id
230: ,p_creator_id_o
231: => pay_tdf_shd.g_old_rec.creator_id
232: ,p_creator_type_o
233: => pay_tdf_shd.g_old_rec.creator_type

Line 231: => pay_tdf_shd.g_old_rec.creator_id

227: => pay_tdf_shd.g_old_rec.start_date
228: ,p_period_time_definition_id_o
229: => pay_tdf_shd.g_old_rec.period_time_definition_id
230: ,p_creator_id_o
231: => pay_tdf_shd.g_old_rec.creator_id
232: ,p_creator_type_o
233: => pay_tdf_shd.g_old_rec.creator_type
234: ,p_object_version_number_o
235: => pay_tdf_shd.g_old_rec.object_version_number

Line 233: => pay_tdf_shd.g_old_rec.creator_type

229: => pay_tdf_shd.g_old_rec.period_time_definition_id
230: ,p_creator_id_o
231: => pay_tdf_shd.g_old_rec.creator_id
232: ,p_creator_type_o
233: => pay_tdf_shd.g_old_rec.creator_type
234: ,p_object_version_number_o
235: => pay_tdf_shd.g_old_rec.object_version_number
236: );
237: --

Line 235: => pay_tdf_shd.g_old_rec.object_version_number

231: => pay_tdf_shd.g_old_rec.creator_id
232: ,p_creator_type_o
233: => pay_tdf_shd.g_old_rec.creator_type
234: ,p_object_version_number_o
235: => pay_tdf_shd.g_old_rec.object_version_number
236: );
237: --
238: exception
239: --

Line 255: (p_rec in pay_tdf_shd.g_rec_type

251: -- ----------------------------------------------------------------------------
252: -- |---------------------------------< del >----------------------------------|
253: -- ----------------------------------------------------------------------------
254: Procedure del
255: (p_rec in pay_tdf_shd.g_rec_type
256: ) is
257: --
258: l_proc varchar2(72) := g_package||'del';
259: --

Line 265: pay_tdf_shd.lck

261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: -- We must lock the row which we need to delete.
264: --
265: pay_tdf_shd.lck
266: (p_rec.time_definition_id
267: ,p_rec.object_version_number
268: );
269: --

Line 302: l_rec pay_tdf_shd.g_rec_type;

298: (p_time_definition_id in number
299: ,p_object_version_number in number
300: ) is
301: --
302: l_rec pay_tdf_shd.g_rec_type;
303: l_proc varchar2(72) := g_package||'del';
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);