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

Line 55: (p_rec in out nocopy pqp_exr_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqp_exr_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

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

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: pqp_exr_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the pqp_exception_reports Row
69: --
70:

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

112: where exception_report_id = p_rec.exception_report_id;
113:
114: END IF;
115: --
116: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: --
120: Exception

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

119: --
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
124: pqp_exr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated

Line 124: pqp_exr_shd.constraint_error

120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
124: pqp_exr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

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

124: pqp_exr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
129: pqp_exr_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated

Line 129: pqp_exr_shd.constraint_error

125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
129: pqp_exr_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

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

129: pqp_exr_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
134: pqp_exr_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

Line 134: pqp_exr_shd.constraint_error

130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
134: pqp_exr_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
138: Raise;

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

133: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
134: pqp_exr_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
138: Raise;
139: End update_dml;
140: --
141: -- ----------------------------------------------------------------------------

Line 174: (p_rec in pqp_exr_shd.g_rec_type

170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure pre_update
174: (p_rec in pqp_exr_shd.g_rec_type
175: ) is
176: --
177: l_proc varchar2(72) := g_package||'pre_update';
178: --

Line 218: (p_rec in pqp_exr_shd.g_rec_type

214: --
215: -- {End Of Comments}
216: -- ----------------------------------------------------------------------------
217: Procedure post_update
218: (p_rec in pqp_exr_shd.g_rec_type
219: ) is
220: --
221: l_proc varchar2(72) := g_package||'post_update';
222: --

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

238: ,p_comparison_value => p_rec.comparison_value
239: ,p_object_version_number => p_rec.object_version_number
240: ,p_output_format_type => p_rec.output_format_type
241: ,p_variance_operator => p_rec.variance_operator
242: ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name
243: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
244: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
245: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
246: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id

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

239: ,p_object_version_number => p_rec.object_version_number
240: ,p_output_format_type => p_rec.output_format_type
241: ,p_variance_operator => p_rec.variance_operator
242: ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name
243: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
244: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
245: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
246: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
247: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id

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

240: ,p_output_format_type => p_rec.output_format_type
241: ,p_variance_operator => p_rec.variance_operator
242: ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name
243: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
244: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
245: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
246: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
247: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
248: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type

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

241: ,p_variance_operator => p_rec.variance_operator
242: ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name
243: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
244: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
245: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
246: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
247: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
248: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
249: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value

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

242: ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name
243: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
244: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
245: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
246: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
247: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
248: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
249: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
250: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type

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

243: ,p_legislation_code_o => pqp_exr_shd.g_old_rec.legislation_code
244: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
245: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
246: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
247: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
248: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
249: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
250: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
251: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value

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

244: ,p_business_group_id_o => pqp_exr_shd.g_old_rec.business_group_id
245: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
246: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
247: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
248: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
249: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
250: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
251: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
252: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number

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

245: ,p_currency_code_o => pqp_exr_shd.g_old_rec.currency_code
246: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
247: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
248: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
249: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
250: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
251: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
252: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number
253: ,p_output_format_type_o => pqp_exr_shd.g_old_rec.output_format_type

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

246: ,p_balance_type_id_o => pqp_exr_shd.g_old_rec.balance_type_id
247: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
248: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
249: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
250: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
251: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
252: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number
253: ,p_output_format_type_o => pqp_exr_shd.g_old_rec.output_format_type
254: ,p_variance_operator_o => pqp_exr_shd.g_old_rec.variance_operator

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

247: ,p_balance_dimension_id_o => pqp_exr_shd.g_old_rec.balance_dimension_id
248: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
249: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
250: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
251: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
252: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number
253: ,p_output_format_type_o => pqp_exr_shd.g_old_rec.output_format_type
254: ,p_variance_operator_o => pqp_exr_shd.g_old_rec.variance_operator
255: );

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

248: ,p_variance_type_o => pqp_exr_shd.g_old_rec.variance_type
249: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
250: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
251: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
252: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number
253: ,p_output_format_type_o => pqp_exr_shd.g_old_rec.output_format_type
254: ,p_variance_operator_o => pqp_exr_shd.g_old_rec.variance_operator
255: );
256: --

Line 253: ,p_output_format_type_o => pqp_exr_shd.g_old_rec.output_format_type

249: ,p_variance_value_o => pqp_exr_shd.g_old_rec.variance_value
250: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
251: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
252: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number
253: ,p_output_format_type_o => pqp_exr_shd.g_old_rec.output_format_type
254: ,p_variance_operator_o => pqp_exr_shd.g_old_rec.variance_operator
255: );
256: --
257: exception

Line 254: ,p_variance_operator_o => pqp_exr_shd.g_old_rec.variance_operator

250: ,p_comparison_type_o => pqp_exr_shd.g_old_rec.comparison_type
251: ,p_comparison_value_o => pqp_exr_shd.g_old_rec.comparison_value
252: ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number
253: ,p_output_format_type_o => pqp_exr_shd.g_old_rec.output_format_type
254: ,p_variance_operator_o => pqp_exr_shd.g_old_rec.variance_operator
255: );
256: --
257: exception
258: --

Line 314: (p_rec in out nocopy pqp_exr_shd.g_rec_type

310: --
311: -- {End Of Comments}
312: -- ----------------------------------------------------------------------------
313: Procedure convert_defs
314: (p_rec in out nocopy pqp_exr_shd.g_rec_type
315: ) is
316: --
317: Begin
318: --

Line 326: pqp_exr_shd.g_old_rec.exception_report_name;

322: -- is being used then we must set to the 'current' argument value.
323: --
324: If (p_rec.exception_report_name = hr_api.g_varchar2) then
325: p_rec.exception_report_name :=
326: pqp_exr_shd.g_old_rec.exception_report_name;
327: End If;
328: If (p_rec.legislation_code = hr_api.g_varchar2) then
329: p_rec.legislation_code :=
330: pqp_exr_shd.g_old_rec.legislation_code;

Line 330: pqp_exr_shd.g_old_rec.legislation_code;

326: pqp_exr_shd.g_old_rec.exception_report_name;
327: End If;
328: If (p_rec.legislation_code = hr_api.g_varchar2) then
329: p_rec.legislation_code :=
330: pqp_exr_shd.g_old_rec.legislation_code;
331: End If;
332: If (p_rec.business_group_id = hr_api.g_number) then
333: p_rec.business_group_id :=
334: pqp_exr_shd.g_old_rec.business_group_id;

Line 334: pqp_exr_shd.g_old_rec.business_group_id;

330: pqp_exr_shd.g_old_rec.legislation_code;
331: End If;
332: If (p_rec.business_group_id = hr_api.g_number) then
333: p_rec.business_group_id :=
334: pqp_exr_shd.g_old_rec.business_group_id;
335: End If;
336: If (p_rec.currency_code = hr_api.g_varchar2) then
337: p_rec.currency_code :=
338: pqp_exr_shd.g_old_rec.currency_code;

Line 338: pqp_exr_shd.g_old_rec.currency_code;

334: pqp_exr_shd.g_old_rec.business_group_id;
335: End If;
336: If (p_rec.currency_code = hr_api.g_varchar2) then
337: p_rec.currency_code :=
338: pqp_exr_shd.g_old_rec.currency_code;
339: End If;
340: If (p_rec.balance_type_id = hr_api.g_number) then
341: p_rec.balance_type_id :=
342: pqp_exr_shd.g_old_rec.balance_type_id;

Line 342: pqp_exr_shd.g_old_rec.balance_type_id;

338: pqp_exr_shd.g_old_rec.currency_code;
339: End If;
340: If (p_rec.balance_type_id = hr_api.g_number) then
341: p_rec.balance_type_id :=
342: pqp_exr_shd.g_old_rec.balance_type_id;
343: End If;
344: If (p_rec.balance_dimension_id = hr_api.g_number) then
345: p_rec.balance_dimension_id :=
346: pqp_exr_shd.g_old_rec.balance_dimension_id;

Line 346: pqp_exr_shd.g_old_rec.balance_dimension_id;

342: pqp_exr_shd.g_old_rec.balance_type_id;
343: End If;
344: If (p_rec.balance_dimension_id = hr_api.g_number) then
345: p_rec.balance_dimension_id :=
346: pqp_exr_shd.g_old_rec.balance_dimension_id;
347: End If;
348: If (p_rec.variance_type = hr_api.g_varchar2) then
349: p_rec.variance_type :=
350: pqp_exr_shd.g_old_rec.variance_type;

Line 350: pqp_exr_shd.g_old_rec.variance_type;

346: pqp_exr_shd.g_old_rec.balance_dimension_id;
347: End If;
348: If (p_rec.variance_type = hr_api.g_varchar2) then
349: p_rec.variance_type :=
350: pqp_exr_shd.g_old_rec.variance_type;
351: End If;
352: If (p_rec.variance_value = hr_api.g_number) then
353: p_rec.variance_value :=
354: pqp_exr_shd.g_old_rec.variance_value;

Line 354: pqp_exr_shd.g_old_rec.variance_value;

350: pqp_exr_shd.g_old_rec.variance_type;
351: End If;
352: If (p_rec.variance_value = hr_api.g_number) then
353: p_rec.variance_value :=
354: pqp_exr_shd.g_old_rec.variance_value;
355: End If;
356: If (p_rec.comparison_type = hr_api.g_varchar2) then
357: p_rec.comparison_type :=
358: pqp_exr_shd.g_old_rec.comparison_type;

Line 358: pqp_exr_shd.g_old_rec.comparison_type;

354: pqp_exr_shd.g_old_rec.variance_value;
355: End If;
356: If (p_rec.comparison_type = hr_api.g_varchar2) then
357: p_rec.comparison_type :=
358: pqp_exr_shd.g_old_rec.comparison_type;
359: End If;
360: If (p_rec.comparison_value = hr_api.g_number) then
361: p_rec.comparison_value :=
362: pqp_exr_shd.g_old_rec.comparison_value;

Line 362: pqp_exr_shd.g_old_rec.comparison_value;

358: pqp_exr_shd.g_old_rec.comparison_type;
359: End If;
360: If (p_rec.comparison_value = hr_api.g_number) then
361: p_rec.comparison_value :=
362: pqp_exr_shd.g_old_rec.comparison_value;
363: End If;
364: If (p_rec.output_format_type = hr_api.g_varchar2) then
365: p_rec.output_format_type :=
366: pqp_exr_shd.g_old_rec.output_format_type;

Line 366: pqp_exr_shd.g_old_rec.output_format_type;

362: pqp_exr_shd.g_old_rec.comparison_value;
363: End If;
364: If (p_rec.output_format_type = hr_api.g_varchar2) then
365: p_rec.output_format_type :=
366: pqp_exr_shd.g_old_rec.output_format_type;
367: End If;
368: If (p_rec.variance_operator = hr_api.g_varchar2) then
369: p_rec.variance_operator :=
370: pqp_exr_shd.g_old_rec.variance_operator;

Line 370: pqp_exr_shd.g_old_rec.variance_operator;

366: pqp_exr_shd.g_old_rec.output_format_type;
367: End If;
368: If (p_rec.variance_operator = hr_api.g_varchar2) then
369: p_rec.variance_operator :=
370: pqp_exr_shd.g_old_rec.variance_operator;
371: End If;
372: --
373: End convert_defs;
374: --

Line 379: (p_rec in out nocopy pqp_exr_shd.g_rec_type

375: -- ----------------------------------------------------------------------------
376: -- |---------------------------------< upd >----------------------------------|
377: -- ----------------------------------------------------------------------------
378: Procedure upd
379: (p_rec in out nocopy pqp_exr_shd.g_rec_type
380: ) is
381: --
382: l_proc varchar2(72) := g_package||'upd';
383: --

Line 389: pqp_exr_shd.lck

385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: -- We must lock the row which we need to update.
388: --
389: pqp_exr_shd.lck
390: (p_rec.exception_report_id
391: ,p_rec.object_version_number
392: );
393: --

Line 443: l_rec pqp_exr_shd.g_rec_type;

439: ,p_output_format_type in varchar2
440: ,p_variance_operator in varchar2
441: ) is
442: --
443: l_rec pqp_exr_shd.g_rec_type;
444: l_proc varchar2(72) := g_package||'upd';
445: --
446: Begin
447: hr_utility.set_location('Entering:'||l_proc, 5);

Line 453: pqp_exr_shd.convert_args

449: -- Call conversion function to turn arguments into the
450: -- l_rec structure.
451: --
452: l_rec :=
453: pqp_exr_shd.convert_args
454: (p_exception_report_id
455: ,p_exception_report_name
456: ,p_legislation_code
457: ,p_business_group_id