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_EXR_DEL dependencies on PQP_EXR_SHD

Line 86: (p_rec in pqp_exr_shd.g_rec_type

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

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

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

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

97: --
98: delete from pqp_exception_reports
99: where exception_report_id = p_rec.exception_report_id;
100: --
101: pqp_exr_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: pqp_exr_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: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
109: pqp_exr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

Line 109: pqp_exr_shd.constraint_error

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

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

108: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
109: pqp_exr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pqp_exr_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 pqp_exr_shd.g_rec_type) is

144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_delete(p_rec in pqp_exr_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 pqp_exr_shd.g_rec_type) is

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

Line 203: ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name

199: delete_app_ownerships('EXCEPTION_REPORT_ID', p_rec.exception_report_id);
200: --
201: pqp_exr_rkd.after_delete
202: (p_exception_report_id => p_rec.exception_report_id
203: ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name
204: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
205: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
206: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
207: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id

Line 204: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code

200: --
201: pqp_exr_rkd.after_delete
202: (p_exception_report_id => p_rec.exception_report_id
203: ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name
204: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
205: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
206: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
207: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
208: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id

Line 205: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id

201: pqp_exr_rkd.after_delete
202: (p_exception_report_id => p_rec.exception_report_id
203: ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name
204: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
205: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
206: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
207: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
208: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
209: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type

Line 206: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code

202: (p_exception_report_id => p_rec.exception_report_id
203: ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name
204: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
205: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
206: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
207: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
208: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
209: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
210: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value

Line 207: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id

203: ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name
204: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
205: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
206: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
207: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
208: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
209: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
210: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
211: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type

Line 208: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id

204: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
205: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
206: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
207: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
208: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
209: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
210: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
211: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
212: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value

Line 209: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type

205: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
206: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
207: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
208: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
209: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
210: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
211: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
212: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
213: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number

Line 210: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value

206: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
207: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
208: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
209: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
210: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
211: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
212: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
213: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number
214: );

Line 211: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type

207: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
208: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
209: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
210: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
211: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
212: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
213: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number
214: );
215: --

Line 212: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value

208: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
209: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
210: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
211: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
212: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
213: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number
214: );
215: --
216: exception

Line 213: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number

209: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
210: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
211: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
212: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
213: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number
214: );
215: --
216: exception
217: --

Line 233: (p_rec in pqp_exr_shd.g_rec_type

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

Line 243: pqp_exr_shd.lck

239: hr_utility.set_location('Entering:'||l_proc, 5);
240: --
241: -- We must lock the row which we need to delete.
242: --
243: pqp_exr_shd.lck
244: (p_rec.exception_report_id
245: ,p_rec.object_version_number
246: );
247: --

Line 277: l_rec pqp_exr_shd.g_rec_type;

273: (p_exception_report_id in number
274: ,p_object_version_number in number
275: ) is
276: --
277: l_rec pqp_exr_shd.g_rec_type;
278: l_proc varchar2(72) := g_package||'del';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);