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.PAY_PEU_DEL dependencies on PAY_PEU_SHD

Line 52: (p_rec in pay_peu_shd.g_rec_type

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

Line 60: pay_peu_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_peu_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the pay_event_updates row.
63: --
64: delete from pay_event_updates

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

63: --
64: delete from pay_event_updates
65: where event_update_id = p_rec.event_update_id;
66: --
67: pay_peu_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_peu_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_peu_shd.g_api_dml := false; -- Unset the api dml status
75: pay_peu_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pay_peu_shd.g_api_dml := false; -- Unset the api dml status

Line 75: pay_peu_shd.constraint_error

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

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

74: pay_peu_shd.g_api_dml := false; -- Unset the api dml status
75: pay_peu_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pay_peu_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_peu_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_peu_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_peu_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_peu_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => pay_peu_shd.g_old_rec.table_name

164: pay_peu_rkd.after_delete
165: (p_event_update_id
166: => p_rec.event_update_id
167: ,p_table_name_o
168: => pay_peu_shd.g_old_rec.table_name
169: ,p_column_name_o
170: => pay_peu_shd.g_old_rec.column_name
171: ,p_dated_table_id_o
172: => pay_peu_shd.g_old_rec.dated_table_id

Line 170: => pay_peu_shd.g_old_rec.column_name

166: => p_rec.event_update_id
167: ,p_table_name_o
168: => pay_peu_shd.g_old_rec.table_name
169: ,p_column_name_o
170: => pay_peu_shd.g_old_rec.column_name
171: ,p_dated_table_id_o
172: => pay_peu_shd.g_old_rec.dated_table_id
173: ,p_business_group_id_o
174: => pay_peu_shd.g_old_rec.business_group_id

Line 172: => pay_peu_shd.g_old_rec.dated_table_id

168: => pay_peu_shd.g_old_rec.table_name
169: ,p_column_name_o
170: => pay_peu_shd.g_old_rec.column_name
171: ,p_dated_table_id_o
172: => pay_peu_shd.g_old_rec.dated_table_id
173: ,p_business_group_id_o
174: => pay_peu_shd.g_old_rec.business_group_id
175: ,p_legislation_code_o
176: => pay_peu_shd.g_old_rec.legislation_code

Line 174: => pay_peu_shd.g_old_rec.business_group_id

170: => pay_peu_shd.g_old_rec.column_name
171: ,p_dated_table_id_o
172: => pay_peu_shd.g_old_rec.dated_table_id
173: ,p_business_group_id_o
174: => pay_peu_shd.g_old_rec.business_group_id
175: ,p_legislation_code_o
176: => pay_peu_shd.g_old_rec.legislation_code
177: ,p_change_type_o
178: => pay_peu_shd.g_old_rec.change_type

Line 176: => pay_peu_shd.g_old_rec.legislation_code

172: => pay_peu_shd.g_old_rec.dated_table_id
173: ,p_business_group_id_o
174: => pay_peu_shd.g_old_rec.business_group_id
175: ,p_legislation_code_o
176: => pay_peu_shd.g_old_rec.legislation_code
177: ,p_change_type_o
178: => pay_peu_shd.g_old_rec.change_type
179: ,p_event_type_o
180: => pay_peu_shd.g_old_rec.event_type

Line 178: => pay_peu_shd.g_old_rec.change_type

174: => pay_peu_shd.g_old_rec.business_group_id
175: ,p_legislation_code_o
176: => pay_peu_shd.g_old_rec.legislation_code
177: ,p_change_type_o
178: => pay_peu_shd.g_old_rec.change_type
179: ,p_event_type_o
180: => pay_peu_shd.g_old_rec.event_type
181: ,p_object_version_number_o
182: => pay_peu_shd.g_old_rec.object_version_number

Line 180: => pay_peu_shd.g_old_rec.event_type

176: => pay_peu_shd.g_old_rec.legislation_code
177: ,p_change_type_o
178: => pay_peu_shd.g_old_rec.change_type
179: ,p_event_type_o
180: => pay_peu_shd.g_old_rec.event_type
181: ,p_object_version_number_o
182: => pay_peu_shd.g_old_rec.object_version_number
183: );
184: --

Line 182: => pay_peu_shd.g_old_rec.object_version_number

178: => pay_peu_shd.g_old_rec.change_type
179: ,p_event_type_o
180: => pay_peu_shd.g_old_rec.event_type
181: ,p_object_version_number_o
182: => pay_peu_shd.g_old_rec.object_version_number
183: );
184: --
185: exception
186: --

Line 202: (p_rec in pay_peu_shd.g_rec_type

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

Line 212: pay_peu_shd.lck

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

Line 243: l_rec pay_peu_shd.g_rec_type;

239: (p_event_update_id in number
240: ,p_object_version_number in number
241: ) is
242: --
243: l_rec pay_peu_shd.g_rec_type;
244: l_proc varchar2(72) := g_package||'del';
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);