DBA Data[Home] [Help]

APPS.PAY_BTH_DEL dependencies on PAY_BTH_SHD

Line 52: (p_rec in pay_bth_shd.g_rec_type

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

Line 60: pay_bth_shd.g_api_dml := true; -- Set the api dml status

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: pay_bth_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the pay_batch_headers row.
63: --
64: delete from pay_batch_headers

Line 67: pay_bth_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from pay_batch_headers
65: where batch_id = p_rec.batch_id;
66: --
67: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

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

70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
75: pay_bth_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pay_bth_shd.g_api_dml := false; -- Unset the api dml status

Line 75: pay_bth_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
75: pay_bth_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;

Line 78: pay_bth_shd.g_api_dml := false; -- Unset the api dml status

74: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
75: pay_bth_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------

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

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in pay_bth_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 pay_bth_shd.g_rec_type) is

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

Line 168: => pay_bth_shd.g_old_rec.business_group_id

164: pay_bth_rkd.after_delete
165: (p_batch_id
166: => p_rec.batch_id
167: ,p_business_group_id_o
168: => pay_bth_shd.g_old_rec.business_group_id
169: ,p_batch_name_o
170: => pay_bth_shd.g_old_rec.batch_name
171: ,p_batch_status_o
172: => pay_bth_shd.g_old_rec.batch_status

Line 170: => pay_bth_shd.g_old_rec.batch_name

166: => p_rec.batch_id
167: ,p_business_group_id_o
168: => pay_bth_shd.g_old_rec.business_group_id
169: ,p_batch_name_o
170: => pay_bth_shd.g_old_rec.batch_name
171: ,p_batch_status_o
172: => pay_bth_shd.g_old_rec.batch_status
173: ,p_action_if_exists_o
174: => pay_bth_shd.g_old_rec.action_if_exists

Line 172: => pay_bth_shd.g_old_rec.batch_status

168: => pay_bth_shd.g_old_rec.business_group_id
169: ,p_batch_name_o
170: => pay_bth_shd.g_old_rec.batch_name
171: ,p_batch_status_o
172: => pay_bth_shd.g_old_rec.batch_status
173: ,p_action_if_exists_o
174: => pay_bth_shd.g_old_rec.action_if_exists
175: ,p_batch_reference_o
176: => pay_bth_shd.g_old_rec.batch_reference

Line 174: => pay_bth_shd.g_old_rec.action_if_exists

170: => pay_bth_shd.g_old_rec.batch_name
171: ,p_batch_status_o
172: => pay_bth_shd.g_old_rec.batch_status
173: ,p_action_if_exists_o
174: => pay_bth_shd.g_old_rec.action_if_exists
175: ,p_batch_reference_o
176: => pay_bth_shd.g_old_rec.batch_reference
177: ,p_batch_source_o
178: => pay_bth_shd.g_old_rec.batch_source

Line 176: => pay_bth_shd.g_old_rec.batch_reference

172: => pay_bth_shd.g_old_rec.batch_status
173: ,p_action_if_exists_o
174: => pay_bth_shd.g_old_rec.action_if_exists
175: ,p_batch_reference_o
176: => pay_bth_shd.g_old_rec.batch_reference
177: ,p_batch_source_o
178: => pay_bth_shd.g_old_rec.batch_source
179: ,p_batch_type_o
180: => pay_bth_shd.g_old_rec.batch_type

Line 178: => pay_bth_shd.g_old_rec.batch_source

174: => pay_bth_shd.g_old_rec.action_if_exists
175: ,p_batch_reference_o
176: => pay_bth_shd.g_old_rec.batch_reference
177: ,p_batch_source_o
178: => pay_bth_shd.g_old_rec.batch_source
179: ,p_batch_type_o
180: => pay_bth_shd.g_old_rec.batch_type
181: ,p_comments_o
182: => pay_bth_shd.g_old_rec.comments

Line 180: => pay_bth_shd.g_old_rec.batch_type

176: => pay_bth_shd.g_old_rec.batch_reference
177: ,p_batch_source_o
178: => pay_bth_shd.g_old_rec.batch_source
179: ,p_batch_type_o
180: => pay_bth_shd.g_old_rec.batch_type
181: ,p_comments_o
182: => pay_bth_shd.g_old_rec.comments
183: ,p_date_effective_changes_o
184: => pay_bth_shd.g_old_rec.date_effective_changes

Line 182: => pay_bth_shd.g_old_rec.comments

178: => pay_bth_shd.g_old_rec.batch_source
179: ,p_batch_type_o
180: => pay_bth_shd.g_old_rec.batch_type
181: ,p_comments_o
182: => pay_bth_shd.g_old_rec.comments
183: ,p_date_effective_changes_o
184: => pay_bth_shd.g_old_rec.date_effective_changes
185: ,p_purge_after_transfer_o
186: => pay_bth_shd.g_old_rec.purge_after_transfer

Line 184: => pay_bth_shd.g_old_rec.date_effective_changes

180: => pay_bth_shd.g_old_rec.batch_type
181: ,p_comments_o
182: => pay_bth_shd.g_old_rec.comments
183: ,p_date_effective_changes_o
184: => pay_bth_shd.g_old_rec.date_effective_changes
185: ,p_purge_after_transfer_o
186: => pay_bth_shd.g_old_rec.purge_after_transfer
187: ,p_reject_if_future_changes_o
188: => pay_bth_shd.g_old_rec.reject_if_future_changes

Line 186: => pay_bth_shd.g_old_rec.purge_after_transfer

182: => pay_bth_shd.g_old_rec.comments
183: ,p_date_effective_changes_o
184: => pay_bth_shd.g_old_rec.date_effective_changes
185: ,p_purge_after_transfer_o
186: => pay_bth_shd.g_old_rec.purge_after_transfer
187: ,p_reject_if_future_changes_o
188: => pay_bth_shd.g_old_rec.reject_if_future_changes
189: ,p_object_version_number_o
190: => pay_bth_shd.g_old_rec.object_version_number

Line 188: => pay_bth_shd.g_old_rec.reject_if_future_changes

184: => pay_bth_shd.g_old_rec.date_effective_changes
185: ,p_purge_after_transfer_o
186: => pay_bth_shd.g_old_rec.purge_after_transfer
187: ,p_reject_if_future_changes_o
188: => pay_bth_shd.g_old_rec.reject_if_future_changes
189: ,p_object_version_number_o
190: => pay_bth_shd.g_old_rec.object_version_number
191: ,p_reject_if_results_exists_o
192: => pay_bth_shd.g_old_rec.reject_if_results_exists

Line 190: => pay_bth_shd.g_old_rec.object_version_number

186: => pay_bth_shd.g_old_rec.purge_after_transfer
187: ,p_reject_if_future_changes_o
188: => pay_bth_shd.g_old_rec.reject_if_future_changes
189: ,p_object_version_number_o
190: => pay_bth_shd.g_old_rec.object_version_number
191: ,p_reject_if_results_exists_o
192: => pay_bth_shd.g_old_rec.reject_if_results_exists
193: ,p_purge_after_rollback_o
194: => pay_bth_shd.g_old_rec.purge_after_rollback

Line 192: => pay_bth_shd.g_old_rec.reject_if_results_exists

188: => pay_bth_shd.g_old_rec.reject_if_future_changes
189: ,p_object_version_number_o
190: => pay_bth_shd.g_old_rec.object_version_number
191: ,p_reject_if_results_exists_o
192: => pay_bth_shd.g_old_rec.reject_if_results_exists
193: ,p_purge_after_rollback_o
194: => pay_bth_shd.g_old_rec.purge_after_rollback
195: ,p_REJECT_ENTRY_NOT_REMOVED_o
196: => pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED

Line 194: => pay_bth_shd.g_old_rec.purge_after_rollback

190: => pay_bth_shd.g_old_rec.object_version_number
191: ,p_reject_if_results_exists_o
192: => pay_bth_shd.g_old_rec.reject_if_results_exists
193: ,p_purge_after_rollback_o
194: => pay_bth_shd.g_old_rec.purge_after_rollback
195: ,p_REJECT_ENTRY_NOT_REMOVED_o
196: => pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED
197: ,p_ROLLBACK_ENTRY_UPDATES_o
198: => pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES

Line 196: => pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED

192: => pay_bth_shd.g_old_rec.reject_if_results_exists
193: ,p_purge_after_rollback_o
194: => pay_bth_shd.g_old_rec.purge_after_rollback
195: ,p_REJECT_ENTRY_NOT_REMOVED_o
196: => pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED
197: ,p_ROLLBACK_ENTRY_UPDATES_o
198: => pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES
199: );
200: --

Line 198: => pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES

194: => pay_bth_shd.g_old_rec.purge_after_rollback
195: ,p_REJECT_ENTRY_NOT_REMOVED_o
196: => pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED
197: ,p_ROLLBACK_ENTRY_UPDATES_o
198: => pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES
199: );
200: --
201: exception
202: --

Line 218: (p_rec in pay_bth_shd.g_rec_type

214: -- ----------------------------------------------------------------------------
215: -- |---------------------------------< del >----------------------------------|
216: -- ----------------------------------------------------------------------------
217: Procedure del
218: (p_rec in pay_bth_shd.g_rec_type
219: ) is
220: --
221: l_proc varchar2(72) := g_package||'del';
222: --

Line 228: pay_bth_shd.lck

224: hr_utility.set_location('Entering:'||l_proc, 5);
225: --
226: -- We must lock the row which we need to delete.
227: --
228: pay_bth_shd.lck
229: (p_rec.batch_id
230: ,p_rec.object_version_number
231: );
232: --

Line 259: l_rec pay_bth_shd.g_rec_type;

255: (p_batch_id in number
256: ,p_object_version_number in number
257: ) is
258: --
259: l_rec pay_bth_shd.g_rec_type;
260: l_proc varchar2(72) := g_package||'del';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);