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_PEV_DEL dependencies on PAY_PEV_SHD

Line 52: (p_rec in pay_pev_shd.g_rec_type

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

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

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

63: --
64: delete from pay_process_events
65: where process_event_id = p_rec.process_event_id;
66: --
67: pay_pev_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_pev_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_pev_shd.g_api_dml := false; -- Unset the api dml status
75: pay_pev_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pay_pev_shd.g_api_dml := false; -- Unset the api dml status

Line 75: pay_pev_shd.constraint_error

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

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

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

Line 168: => pay_pev_shd.g_old_rec.assignment_id

164: pay_pev_rkd.after_delete
165: (p_process_event_id
166: => p_rec.process_event_id
167: ,p_assignment_id_o
168: => pay_pev_shd.g_old_rec.assignment_id
169: ,p_effective_date_o
170: => pay_pev_shd.g_old_rec.effective_date
171: ,p_change_type_o
172: => pay_pev_shd.g_old_rec.change_type

Line 170: => pay_pev_shd.g_old_rec.effective_date

166: => p_rec.process_event_id
167: ,p_assignment_id_o
168: => pay_pev_shd.g_old_rec.assignment_id
169: ,p_effective_date_o
170: => pay_pev_shd.g_old_rec.effective_date
171: ,p_change_type_o
172: => pay_pev_shd.g_old_rec.change_type
173: ,p_status_o
174: => pay_pev_shd.g_old_rec.status

Line 172: => pay_pev_shd.g_old_rec.change_type

168: => pay_pev_shd.g_old_rec.assignment_id
169: ,p_effective_date_o
170: => pay_pev_shd.g_old_rec.effective_date
171: ,p_change_type_o
172: => pay_pev_shd.g_old_rec.change_type
173: ,p_status_o
174: => pay_pev_shd.g_old_rec.status
175: ,p_description_o
176: => pay_pev_shd.g_old_rec.description

Line 174: => pay_pev_shd.g_old_rec.status

170: => pay_pev_shd.g_old_rec.effective_date
171: ,p_change_type_o
172: => pay_pev_shd.g_old_rec.change_type
173: ,p_status_o
174: => pay_pev_shd.g_old_rec.status
175: ,p_description_o
176: => pay_pev_shd.g_old_rec.description
177: ,p_event_update_id_o
178: => pay_pev_shd.g_old_rec.event_update_id

Line 176: => pay_pev_shd.g_old_rec.description

172: => pay_pev_shd.g_old_rec.change_type
173: ,p_status_o
174: => pay_pev_shd.g_old_rec.status
175: ,p_description_o
176: => pay_pev_shd.g_old_rec.description
177: ,p_event_update_id_o
178: => pay_pev_shd.g_old_rec.event_update_id
179: ,p_business_group_id_o
180: => pay_pev_shd.g_old_rec.business_group_id

Line 178: => pay_pev_shd.g_old_rec.event_update_id

174: => pay_pev_shd.g_old_rec.status
175: ,p_description_o
176: => pay_pev_shd.g_old_rec.description
177: ,p_event_update_id_o
178: => pay_pev_shd.g_old_rec.event_update_id
179: ,p_business_group_id_o
180: => pay_pev_shd.g_old_rec.business_group_id
181: ,p_org_process_event_group_id_o
182: => pay_pev_shd.g_old_rec.org_process_event_group_id

Line 180: => pay_pev_shd.g_old_rec.business_group_id

176: => pay_pev_shd.g_old_rec.description
177: ,p_event_update_id_o
178: => pay_pev_shd.g_old_rec.event_update_id
179: ,p_business_group_id_o
180: => pay_pev_shd.g_old_rec.business_group_id
181: ,p_org_process_event_group_id_o
182: => pay_pev_shd.g_old_rec.org_process_event_group_id
183: ,p_surrogate_key_o
184: => pay_pev_shd.g_old_rec.surrogate_key

Line 182: => pay_pev_shd.g_old_rec.org_process_event_group_id

178: => pay_pev_shd.g_old_rec.event_update_id
179: ,p_business_group_id_o
180: => pay_pev_shd.g_old_rec.business_group_id
181: ,p_org_process_event_group_id_o
182: => pay_pev_shd.g_old_rec.org_process_event_group_id
183: ,p_surrogate_key_o
184: => pay_pev_shd.g_old_rec.surrogate_key
185: ,p_object_version_number_o
186: => pay_pev_shd.g_old_rec.object_version_number

Line 184: => pay_pev_shd.g_old_rec.surrogate_key

180: => pay_pev_shd.g_old_rec.business_group_id
181: ,p_org_process_event_group_id_o
182: => pay_pev_shd.g_old_rec.org_process_event_group_id
183: ,p_surrogate_key_o
184: => pay_pev_shd.g_old_rec.surrogate_key
185: ,p_object_version_number_o
186: => pay_pev_shd.g_old_rec.object_version_number
187: ,p_calculation_date_o
188: => pay_pev_shd.g_old_rec.calculation_date

Line 186: => pay_pev_shd.g_old_rec.object_version_number

182: => pay_pev_shd.g_old_rec.org_process_event_group_id
183: ,p_surrogate_key_o
184: => pay_pev_shd.g_old_rec.surrogate_key
185: ,p_object_version_number_o
186: => pay_pev_shd.g_old_rec.object_version_number
187: ,p_calculation_date_o
188: => pay_pev_shd.g_old_rec.calculation_date
189: ,p_retroactive_status_o
190: => pay_pev_shd.g_old_rec.retroactive_status

Line 188: => pay_pev_shd.g_old_rec.calculation_date

184: => pay_pev_shd.g_old_rec.surrogate_key
185: ,p_object_version_number_o
186: => pay_pev_shd.g_old_rec.object_version_number
187: ,p_calculation_date_o
188: => pay_pev_shd.g_old_rec.calculation_date
189: ,p_retroactive_status_o
190: => pay_pev_shd.g_old_rec.retroactive_status
191: ,p_noted_value_o
192: => pay_pev_shd.g_old_rec.noted_value

Line 190: => pay_pev_shd.g_old_rec.retroactive_status

186: => pay_pev_shd.g_old_rec.object_version_number
187: ,p_calculation_date_o
188: => pay_pev_shd.g_old_rec.calculation_date
189: ,p_retroactive_status_o
190: => pay_pev_shd.g_old_rec.retroactive_status
191: ,p_noted_value_o
192: => pay_pev_shd.g_old_rec.noted_value
193: );
194: --

Line 192: => pay_pev_shd.g_old_rec.noted_value

188: => pay_pev_shd.g_old_rec.calculation_date
189: ,p_retroactive_status_o
190: => pay_pev_shd.g_old_rec.retroactive_status
191: ,p_noted_value_o
192: => pay_pev_shd.g_old_rec.noted_value
193: );
194: --
195: exception
196: --

Line 212: (p_rec in pay_pev_shd.g_rec_type

208: -- ----------------------------------------------------------------------------
209: -- |---------------------------------< del >----------------------------------|
210: -- ----------------------------------------------------------------------------
211: Procedure del
212: (p_rec in pay_pev_shd.g_rec_type
213: ) is
214: --
215: l_proc varchar2(72) := g_package||'del';
216: --

Line 222: pay_pev_shd.lck

218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: -- We must lock the row which we need to delete.
221: --
222: pay_pev_shd.lck
223: (p_rec.process_event_id
224: ,p_rec.object_version_number
225: );
226: --

Line 253: l_rec pay_pev_shd.g_rec_type;

249: (p_process_event_id in number
250: ,p_object_version_number in number
251: ) is
252: --
253: l_rec pay_pev_shd.g_rec_type;
254: l_proc varchar2(72) := g_package||'del';
255: --
256: Begin
257: hr_utility.set_location('Entering:'||l_proc, 5);