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_FFA_UPD dependencies on HR_API

Line 87: When hr_api.check_integrity_violated Then

83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: --
90: pqp_ffa_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: --
90: pqp_ffa_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --
95: pqp_ffa_shd.constraint_error

Line 92: When hr_api.parent_integrity_violated Then

88: -- A check constraint has been violated
89: --
90: pqp_ffa_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --
95: pqp_ffa_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --
95: pqp_ffa_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: pqp_ffa_shd.constraint_error

Line 97: When hr_api.unique_integrity_violated Then

93: -- Parent integrity has been violated
94: --
95: pqp_ffa_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: pqp_ffa_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: pqp_ffa_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: --
104: Raise;
105: End update_dml;

Line 228: when hr_api.cannot_find_prog_unit then

224: );
225: --
226: exception
227: --
228: when hr_api.cannot_find_prog_unit then
229: --
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'PQP_FLXDU_FUNC_ATTRIBUTES'
232: ,p_hook_type => 'AU');

Line 230: hr_api.cannot_find_prog_unit_error

226: exception
227: --
228: when hr_api.cannot_find_prog_unit then
229: --
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'PQP_FLXDU_FUNC_ATTRIBUTES'
232: ,p_hook_type => 'AU');
233: --
234: end;

Line 293: If (p_rec.flxdu_func_name = hr_api.g_varchar2) then

289: -- p_rec plsql record structure
290: -- to see if a system default is being used. If a system default
291: -- is being used then we must set to the 'current' argument value.
292: --
293: If (p_rec.flxdu_func_name = hr_api.g_varchar2) then
294: p_rec.flxdu_func_name :=
295: pqp_ffa_shd.g_old_rec.flxdu_func_name;
296: End If;
297: If (p_rec.flxdu_func_source_type = hr_api.g_varchar2) then

Line 297: If (p_rec.flxdu_func_source_type = hr_api.g_varchar2) then

293: If (p_rec.flxdu_func_name = hr_api.g_varchar2) then
294: p_rec.flxdu_func_name :=
295: pqp_ffa_shd.g_old_rec.flxdu_func_name;
296: End If;
297: If (p_rec.flxdu_func_source_type = hr_api.g_varchar2) then
298: p_rec.flxdu_func_source_type :=
299: pqp_ffa_shd.g_old_rec.flxdu_func_source_type;
300: End If;
301: If (p_rec.flxdu_func_integrator_code = hr_api.g_varchar2) then

Line 301: If (p_rec.flxdu_func_integrator_code = hr_api.g_varchar2) then

297: If (p_rec.flxdu_func_source_type = hr_api.g_varchar2) then
298: p_rec.flxdu_func_source_type :=
299: pqp_ffa_shd.g_old_rec.flxdu_func_source_type;
300: End If;
301: If (p_rec.flxdu_func_integrator_code = hr_api.g_varchar2) then
302: p_rec.flxdu_func_integrator_code :=
303: pqp_ffa_shd.g_old_rec.flxdu_func_integrator_code;
304: End If;
305: If (p_rec.flxdu_func_xml_data = hr_api.g_varchar2) then

Line 305: If (p_rec.flxdu_func_xml_data = hr_api.g_varchar2) then

301: If (p_rec.flxdu_func_integrator_code = hr_api.g_varchar2) then
302: p_rec.flxdu_func_integrator_code :=
303: pqp_ffa_shd.g_old_rec.flxdu_func_integrator_code;
304: End If;
305: If (p_rec.flxdu_func_xml_data = hr_api.g_varchar2) then
306: p_rec.flxdu_func_xml_data :=
307: pqp_ffa_shd.g_old_rec.flxdu_func_xml_data;
308: End If;
309: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 309: If (p_rec.legislation_code = hr_api.g_varchar2) then

305: If (p_rec.flxdu_func_xml_data = hr_api.g_varchar2) then
306: p_rec.flxdu_func_xml_data :=
307: pqp_ffa_shd.g_old_rec.flxdu_func_xml_data;
308: End If;
309: If (p_rec.legislation_code = hr_api.g_varchar2) then
310: p_rec.legislation_code :=
311: pqp_ffa_shd.g_old_rec.legislation_code;
312: End If;
313: If (p_rec.description = hr_api.g_varchar2) then

Line 313: If (p_rec.description = hr_api.g_varchar2) then

309: If (p_rec.legislation_code = hr_api.g_varchar2) then
310: p_rec.legislation_code :=
311: pqp_ffa_shd.g_old_rec.legislation_code;
312: End If;
313: If (p_rec.description = hr_api.g_varchar2) then
314: p_rec.description :=
315: pqp_ffa_shd.g_old_rec.description;
316: End If;
317: --

Line 377: ,p_flxdu_func_name in varchar2 default hr_api.g_varchar2

373: -- ----------------------------------------------------------------------------
374: Procedure upd
375: (p_flxdu_func_attribute_id in number
376: ,p_object_version_number in out nocopy number
377: ,p_flxdu_func_name in varchar2 default hr_api.g_varchar2
378: ,p_flxdu_func_source_type in varchar2 default hr_api.g_varchar2
379: ,p_flxdu_func_integrator_code in varchar2 default hr_api.g_varchar2
380: ,p_flxdu_func_xml_data in varchar2 default hr_api.g_varchar2
381: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 378: ,p_flxdu_func_source_type in varchar2 default hr_api.g_varchar2

374: Procedure upd
375: (p_flxdu_func_attribute_id in number
376: ,p_object_version_number in out nocopy number
377: ,p_flxdu_func_name in varchar2 default hr_api.g_varchar2
378: ,p_flxdu_func_source_type in varchar2 default hr_api.g_varchar2
379: ,p_flxdu_func_integrator_code in varchar2 default hr_api.g_varchar2
380: ,p_flxdu_func_xml_data in varchar2 default hr_api.g_varchar2
381: ,p_legislation_code in varchar2 default hr_api.g_varchar2
382: ,p_description in varchar2 default hr_api.g_varchar2

Line 379: ,p_flxdu_func_integrator_code in varchar2 default hr_api.g_varchar2

375: (p_flxdu_func_attribute_id in number
376: ,p_object_version_number in out nocopy number
377: ,p_flxdu_func_name in varchar2 default hr_api.g_varchar2
378: ,p_flxdu_func_source_type in varchar2 default hr_api.g_varchar2
379: ,p_flxdu_func_integrator_code in varchar2 default hr_api.g_varchar2
380: ,p_flxdu_func_xml_data in varchar2 default hr_api.g_varchar2
381: ,p_legislation_code in varchar2 default hr_api.g_varchar2
382: ,p_description in varchar2 default hr_api.g_varchar2
383: ) is

Line 380: ,p_flxdu_func_xml_data in varchar2 default hr_api.g_varchar2

376: ,p_object_version_number in out nocopy number
377: ,p_flxdu_func_name in varchar2 default hr_api.g_varchar2
378: ,p_flxdu_func_source_type in varchar2 default hr_api.g_varchar2
379: ,p_flxdu_func_integrator_code in varchar2 default hr_api.g_varchar2
380: ,p_flxdu_func_xml_data in varchar2 default hr_api.g_varchar2
381: ,p_legislation_code in varchar2 default hr_api.g_varchar2
382: ,p_description in varchar2 default hr_api.g_varchar2
383: ) is
384: --

Line 381: ,p_legislation_code in varchar2 default hr_api.g_varchar2

377: ,p_flxdu_func_name in varchar2 default hr_api.g_varchar2
378: ,p_flxdu_func_source_type in varchar2 default hr_api.g_varchar2
379: ,p_flxdu_func_integrator_code in varchar2 default hr_api.g_varchar2
380: ,p_flxdu_func_xml_data in varchar2 default hr_api.g_varchar2
381: ,p_legislation_code in varchar2 default hr_api.g_varchar2
382: ,p_description in varchar2 default hr_api.g_varchar2
383: ) is
384: --
385: l_rec pqp_ffa_shd.g_rec_type;

Line 382: ,p_description in varchar2 default hr_api.g_varchar2

378: ,p_flxdu_func_source_type in varchar2 default hr_api.g_varchar2
379: ,p_flxdu_func_integrator_code in varchar2 default hr_api.g_varchar2
380: ,p_flxdu_func_xml_data in varchar2 default hr_api.g_varchar2
381: ,p_legislation_code in varchar2 default hr_api.g_varchar2
382: ,p_description in varchar2 default hr_api.g_varchar2
383: ) is
384: --
385: l_rec pqp_ffa_shd.g_rec_type;
386: l_proc varchar2(72) := g_package||'upd';