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

Line 55: (p_rec in out nocopy pqp_erg_shd.g_rec_type

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

Line 66: pqp_erg_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_erg_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the pqp_exception_report_groups Row
69: --
70: update pqp_exception_report_groups

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

79: ,object_version_number = p_rec.object_version_number
80: ,output_format = p_rec.output_format
81: where exception_group_id = p_rec.exception_group_id;
82: --
83: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception

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

86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
91: pqp_erg_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated

Line 91: pqp_erg_shd.constraint_error

87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
91: pqp_erg_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status

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

91: pqp_erg_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
96: pqp_erg_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated

Line 96: pqp_erg_shd.constraint_error

92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
96: pqp_erg_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status

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

96: pqp_erg_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
101: pqp_erg_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status

Line 101: pqp_erg_shd.constraint_error

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
101: pqp_erg_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
105: Raise;

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

100: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
101: pqp_erg_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
105: Raise;
106: End update_dml;
107: --
108: -- ----------------------------------------------------------------------------

Line 141: (p_rec in pqp_erg_shd.g_rec_type

137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure pre_update
141: (p_rec in pqp_erg_shd.g_rec_type
142: ) is
143: --
144: l_proc varchar2(72) := g_package||'pre_update';
145: --

Line 185: (p_rec in pqp_erg_shd.g_rec_type

181: --
182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure post_update
185: (p_rec in pqp_erg_shd.g_rec_type
186: ) is
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --

Line 212: => pqp_erg_shd.g_old_rec.exception_group_name

208: => p_rec.payroll_id
209: ,p_object_version_number
210: => p_rec.object_version_number
211: ,p_exception_group_name_o
212: => pqp_erg_shd.g_old_rec.exception_group_name
213: ,p_exception_report_id_o
214: => pqp_erg_shd.g_old_rec.exception_report_id
215: ,p_legislation_code_o
216: => pqp_erg_shd.g_old_rec.legislation_code

Line 214: => pqp_erg_shd.g_old_rec.exception_report_id

210: => p_rec.object_version_number
211: ,p_exception_group_name_o
212: => pqp_erg_shd.g_old_rec.exception_group_name
213: ,p_exception_report_id_o
214: => pqp_erg_shd.g_old_rec.exception_report_id
215: ,p_legislation_code_o
216: => pqp_erg_shd.g_old_rec.legislation_code
217: ,p_business_group_id_o
218: => pqp_erg_shd.g_old_rec.business_group_id

Line 216: => pqp_erg_shd.g_old_rec.legislation_code

212: => pqp_erg_shd.g_old_rec.exception_group_name
213: ,p_exception_report_id_o
214: => pqp_erg_shd.g_old_rec.exception_report_id
215: ,p_legislation_code_o
216: => pqp_erg_shd.g_old_rec.legislation_code
217: ,p_business_group_id_o
218: => pqp_erg_shd.g_old_rec.business_group_id
219: ,p_consolidation_set_id_o
220: => pqp_erg_shd.g_old_rec.consolidation_set_id

Line 218: => pqp_erg_shd.g_old_rec.business_group_id

214: => pqp_erg_shd.g_old_rec.exception_report_id
215: ,p_legislation_code_o
216: => pqp_erg_shd.g_old_rec.legislation_code
217: ,p_business_group_id_o
218: => pqp_erg_shd.g_old_rec.business_group_id
219: ,p_consolidation_set_id_o
220: => pqp_erg_shd.g_old_rec.consolidation_set_id
221: ,p_payroll_id_o
222: => pqp_erg_shd.g_old_rec.payroll_id

Line 220: => pqp_erg_shd.g_old_rec.consolidation_set_id

216: => pqp_erg_shd.g_old_rec.legislation_code
217: ,p_business_group_id_o
218: => pqp_erg_shd.g_old_rec.business_group_id
219: ,p_consolidation_set_id_o
220: => pqp_erg_shd.g_old_rec.consolidation_set_id
221: ,p_payroll_id_o
222: => pqp_erg_shd.g_old_rec.payroll_id
223: ,p_object_version_number_o
224: => pqp_erg_shd.g_old_rec.object_version_number

Line 222: => pqp_erg_shd.g_old_rec.payroll_id

218: => pqp_erg_shd.g_old_rec.business_group_id
219: ,p_consolidation_set_id_o
220: => pqp_erg_shd.g_old_rec.consolidation_set_id
221: ,p_payroll_id_o
222: => pqp_erg_shd.g_old_rec.payroll_id
223: ,p_object_version_number_o
224: => pqp_erg_shd.g_old_rec.object_version_number
225: );
226: --

Line 224: => pqp_erg_shd.g_old_rec.object_version_number

220: => pqp_erg_shd.g_old_rec.consolidation_set_id
221: ,p_payroll_id_o
222: => pqp_erg_shd.g_old_rec.payroll_id
223: ,p_object_version_number_o
224: => pqp_erg_shd.g_old_rec.object_version_number
225: );
226: --
227: exception
228: --

Line 284: (p_rec in out nocopy pqp_erg_shd.g_rec_type

280: --
281: -- {End Of Comments}
282: -- ----------------------------------------------------------------------------
283: Procedure convert_defs
284: (p_rec in out nocopy pqp_erg_shd.g_rec_type
285: ) is
286: --
287: Begin
288: --

Line 296: pqp_erg_shd.g_old_rec.exception_group_name;

292: -- is being used then we must set to the 'current' argument value.
293: --
294: If (p_rec.exception_group_name = hr_api.g_varchar2) then
295: p_rec.exception_group_name :=
296: pqp_erg_shd.g_old_rec.exception_group_name;
297: End If;
298: If (p_rec.exception_report_id = hr_api.g_number) then
299: p_rec.exception_report_id :=
300: pqp_erg_shd.g_old_rec.exception_report_id;

Line 300: pqp_erg_shd.g_old_rec.exception_report_id;

296: pqp_erg_shd.g_old_rec.exception_group_name;
297: End If;
298: If (p_rec.exception_report_id = hr_api.g_number) then
299: p_rec.exception_report_id :=
300: pqp_erg_shd.g_old_rec.exception_report_id;
301: End If;
302: If (p_rec.legislation_code = hr_api.g_varchar2) then
303: p_rec.legislation_code :=
304: pqp_erg_shd.g_old_rec.legislation_code;

Line 304: pqp_erg_shd.g_old_rec.legislation_code;

300: pqp_erg_shd.g_old_rec.exception_report_id;
301: End If;
302: If (p_rec.legislation_code = hr_api.g_varchar2) then
303: p_rec.legislation_code :=
304: pqp_erg_shd.g_old_rec.legislation_code;
305: End If;
306: If (p_rec.business_group_id = hr_api.g_number) then
307: p_rec.business_group_id :=
308: pqp_erg_shd.g_old_rec.business_group_id;

Line 308: pqp_erg_shd.g_old_rec.business_group_id;

304: pqp_erg_shd.g_old_rec.legislation_code;
305: End If;
306: If (p_rec.business_group_id = hr_api.g_number) then
307: p_rec.business_group_id :=
308: pqp_erg_shd.g_old_rec.business_group_id;
309: End If;
310: If (p_rec.consolidation_set_id = hr_api.g_number) then
311: p_rec.consolidation_set_id :=
312: pqp_erg_shd.g_old_rec.consolidation_set_id;

Line 312: pqp_erg_shd.g_old_rec.consolidation_set_id;

308: pqp_erg_shd.g_old_rec.business_group_id;
309: End If;
310: If (p_rec.consolidation_set_id = hr_api.g_number) then
311: p_rec.consolidation_set_id :=
312: pqp_erg_shd.g_old_rec.consolidation_set_id;
313: End If;
314: If (p_rec.payroll_id = hr_api.g_number) then
315: p_rec.payroll_id :=
316: pqp_erg_shd.g_old_rec.payroll_id;

Line 316: pqp_erg_shd.g_old_rec.payroll_id;

312: pqp_erg_shd.g_old_rec.consolidation_set_id;
313: End If;
314: If (p_rec.payroll_id = hr_api.g_number) then
315: p_rec.payroll_id :=
316: pqp_erg_shd.g_old_rec.payroll_id;
317: End If;
318: If (p_rec.output_format = hr_api.g_varchar2) then
319: p_rec.output_format :=
320: pqp_erg_shd.g_old_rec.output_format;

Line 320: pqp_erg_shd.g_old_rec.output_format;

316: pqp_erg_shd.g_old_rec.payroll_id;
317: End If;
318: If (p_rec.output_format = hr_api.g_varchar2) then
319: p_rec.output_format :=
320: pqp_erg_shd.g_old_rec.output_format;
321: End If;
322: --
323: End convert_defs;
324: --

Line 329: (p_rec in out nocopy pqp_erg_shd.g_rec_type

325: -- ----------------------------------------------------------------------------
326: -- |---------------------------------< upd >----------------------------------|
327: -- ----------------------------------------------------------------------------
328: Procedure upd
329: (p_rec in out nocopy pqp_erg_shd.g_rec_type
330: ) is
331: --
332: l_proc varchar2(72) := g_package||'upd';
333: --

Line 339: pqp_erg_shd.lck

335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: -- We must lock the row which we need to update.
338: --
339: pqp_erg_shd.lck
340: (p_rec.exception_group_id
341: ,p_rec.object_version_number
342: );
343: --

Line 385: l_rec pqp_erg_shd.g_rec_type;

381: ,p_payroll_id in number default hr_api.g_number
382: ,p_output_format in varchar2 default hr_api.g_varchar2
383: ) is
384: --
385: l_rec pqp_erg_shd.g_rec_type;
386: l_proc varchar2(72) := g_package||'upd';
387: --
388: Begin
389: hr_utility.set_location('Entering:'||l_proc, 5);

Line 395: pqp_erg_shd.convert_args

391: -- Call conversion function to turn arguments into the
392: -- l_rec structure.
393: --
394: l_rec :=
395: pqp_erg_shd.convert_args
396: (p_exception_group_id
397: ,p_exception_group_name
398: ,p_exception_report_id
399: ,p_legislation_code