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.PQP_ERG_DEL dependencies on PQP_ERG_SHD

Line 87: (p_rec in pqp_erg_shd.g_rec_type

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

Line 95: pqp_erg_shd.g_api_dml := true; -- Set the api dml status

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

Line 102: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status

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

Line 109: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status

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

Line 110: pqp_erg_shd.constraint_error

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

Line 113: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status

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

Line 149: Procedure pre_delete(p_rec in pqp_erg_shd.g_rec_type) is

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

Line 191: Procedure post_delete(p_rec in pqp_erg_shd.g_rec_type) is

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

Line 203: => pqp_erg_shd.g_old_rec.exception_group_name

199: pqp_erg_rkd.after_delete
200: (p_exception_group_id
201: => p_rec.exception_group_id
202: ,p_exception_group_name_o
203: => pqp_erg_shd.g_old_rec.exception_group_name
204: ,p_exception_report_id_o
205: => pqp_erg_shd.g_old_rec.exception_report_id
206: ,p_legislation_code_o
207: => pqp_erg_shd.g_old_rec.legislation_code

Line 205: => pqp_erg_shd.g_old_rec.exception_report_id

201: => p_rec.exception_group_id
202: ,p_exception_group_name_o
203: => pqp_erg_shd.g_old_rec.exception_group_name
204: ,p_exception_report_id_o
205: => pqp_erg_shd.g_old_rec.exception_report_id
206: ,p_legislation_code_o
207: => pqp_erg_shd.g_old_rec.legislation_code
208: ,p_business_group_id_o
209: => pqp_erg_shd.g_old_rec.business_group_id

Line 207: => pqp_erg_shd.g_old_rec.legislation_code

203: => pqp_erg_shd.g_old_rec.exception_group_name
204: ,p_exception_report_id_o
205: => pqp_erg_shd.g_old_rec.exception_report_id
206: ,p_legislation_code_o
207: => pqp_erg_shd.g_old_rec.legislation_code
208: ,p_business_group_id_o
209: => pqp_erg_shd.g_old_rec.business_group_id
210: ,p_consolidation_set_id_o
211: => pqp_erg_shd.g_old_rec.consolidation_set_id

Line 209: => pqp_erg_shd.g_old_rec.business_group_id

205: => pqp_erg_shd.g_old_rec.exception_report_id
206: ,p_legislation_code_o
207: => pqp_erg_shd.g_old_rec.legislation_code
208: ,p_business_group_id_o
209: => pqp_erg_shd.g_old_rec.business_group_id
210: ,p_consolidation_set_id_o
211: => pqp_erg_shd.g_old_rec.consolidation_set_id
212: ,p_payroll_id_o
213: => pqp_erg_shd.g_old_rec.payroll_id

Line 211: => pqp_erg_shd.g_old_rec.consolidation_set_id

207: => pqp_erg_shd.g_old_rec.legislation_code
208: ,p_business_group_id_o
209: => pqp_erg_shd.g_old_rec.business_group_id
210: ,p_consolidation_set_id_o
211: => pqp_erg_shd.g_old_rec.consolidation_set_id
212: ,p_payroll_id_o
213: => pqp_erg_shd.g_old_rec.payroll_id
214: ,p_object_version_number_o
215: => pqp_erg_shd.g_old_rec.object_version_number

Line 213: => pqp_erg_shd.g_old_rec.payroll_id

209: => pqp_erg_shd.g_old_rec.business_group_id
210: ,p_consolidation_set_id_o
211: => pqp_erg_shd.g_old_rec.consolidation_set_id
212: ,p_payroll_id_o
213: => pqp_erg_shd.g_old_rec.payroll_id
214: ,p_object_version_number_o
215: => pqp_erg_shd.g_old_rec.object_version_number
216: );
217: --

Line 215: => pqp_erg_shd.g_old_rec.object_version_number

211: => pqp_erg_shd.g_old_rec.consolidation_set_id
212: ,p_payroll_id_o
213: => pqp_erg_shd.g_old_rec.payroll_id
214: ,p_object_version_number_o
215: => pqp_erg_shd.g_old_rec.object_version_number
216: );
217: --
218: exception
219: --

Line 235: (p_rec in pqp_erg_shd.g_rec_type

231: -- ----------------------------------------------------------------------------
232: -- |---------------------------------< del >----------------------------------|
233: -- ----------------------------------------------------------------------------
234: Procedure del
235: (p_rec in pqp_erg_shd.g_rec_type
236: ) is
237: --
238: l_proc varchar2(72) := g_package||'del';
239: l_rec pqp_erg_shd.g_rec_type;

Line 239: l_rec pqp_erg_shd.g_rec_type;

235: (p_rec in pqp_erg_shd.g_rec_type
236: ) is
237: --
238: l_proc varchar2(72) := g_package||'del';
239: l_rec pqp_erg_shd.g_rec_type;
240: --
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --

Line 247: pqp_erg_shd.lck

243: --
244: -- We must lock the row which we need to delete.
245: --
246:
247: pqp_erg_shd.lck
248: (p_rec.exception_group_id
249: ,p_rec.object_version_number
250: );
251: --

Line 255: l_rec.business_group_id := pqp_erg_shd.g_old_rec.business_group_id;

251: --
252: -- added by skutteti as the delete_validate needs the leg code and bg
253: --
254: l_rec := p_rec;
255: l_rec.business_group_id := pqp_erg_shd.g_old_rec.business_group_id;
256: l_rec.legislation_code := pqp_erg_shd.g_old_rec.legislation_code;
257: --
258: -- Call the supporting delete validate operation
259: --

Line 256: l_rec.legislation_code := pqp_erg_shd.g_old_rec.legislation_code;

252: -- added by skutteti as the delete_validate needs the leg code and bg
253: --
254: l_rec := p_rec;
255: l_rec.business_group_id := pqp_erg_shd.g_old_rec.business_group_id;
256: l_rec.legislation_code := pqp_erg_shd.g_old_rec.legislation_code;
257: --
258: -- Call the supporting delete validate operation
259: --
260: pqp_erg_bus.delete_validate(l_rec);

Line 284: l_rec pqp_erg_shd.g_rec_type;

280: (p_exception_group_id in number
281: ,p_object_version_number in number
282: ) is
283: --
284: l_rec pqp_erg_shd.g_rec_type;
285: l_proc varchar2(72) := g_package||'del';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);