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.PER_CPA_UPD dependencies on HR_API

Line 90: When hr_api.check_integrity_violated Then

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

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

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

Line 95: When hr_api.parent_integrity_violated Then

91: -- A check constraint has been violated
92: --
93: per_cpa_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: per_cpa_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 100: When hr_api.unique_integrity_violated Then

96: -- Parent integrity has been violated
97: --
98: per_cpa_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: per_cpa_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: per_cpa_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: --
107: Raise;
108: End update_dml;

Line 226: when hr_api.cannot_find_prog_unit then

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

Line 228: hr_api.cannot_find_prog_unit_error

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

Line 292: If (p_rec.cagr_api_id = hr_api.g_number) then

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

Line 296: If (p_rec.display_name = hr_api.g_varchar2) then

292: If (p_rec.cagr_api_id = hr_api.g_number) then
293: p_rec.cagr_api_id :=
294: per_cpa_shd.g_old_rec.cagr_api_id;
295: End If;
296: If (p_rec.display_name = hr_api.g_varchar2) then
297: p_rec.display_name :=
298: per_cpa_shd.g_old_rec.display_name;
299: End If;
300: If (p_rec.parameter_name = hr_api.g_varchar2) then

Line 300: If (p_rec.parameter_name = hr_api.g_varchar2) then

296: If (p_rec.display_name = hr_api.g_varchar2) then
297: p_rec.display_name :=
298: per_cpa_shd.g_old_rec.display_name;
299: End If;
300: If (p_rec.parameter_name = hr_api.g_varchar2) then
301: p_rec.parameter_name :=
302: per_cpa_shd.g_old_rec.parameter_name;
303: End If;
304: If (p_rec.column_type = hr_api.g_varchar2) then

Line 304: If (p_rec.column_type = hr_api.g_varchar2) then

300: If (p_rec.parameter_name = hr_api.g_varchar2) then
301: p_rec.parameter_name :=
302: per_cpa_shd.g_old_rec.parameter_name;
303: End If;
304: If (p_rec.column_type = hr_api.g_varchar2) then
305: p_rec.column_type :=
306: per_cpa_shd.g_old_rec.column_type;
307: End If;
308: If (p_rec.column_size = hr_api.g_number) then

Line 308: If (p_rec.column_size = hr_api.g_number) then

304: If (p_rec.column_type = hr_api.g_varchar2) then
305: p_rec.column_type :=
306: per_cpa_shd.g_old_rec.column_type;
307: End If;
308: If (p_rec.column_size = hr_api.g_number) then
309: p_rec.column_size :=
310: per_cpa_shd.g_old_rec.column_size;
311: End If;
312: If (p_rec.uom_parameter = hr_api.g_varchar2) then

Line 312: If (p_rec.uom_parameter = hr_api.g_varchar2) then

308: If (p_rec.column_size = hr_api.g_number) then
309: p_rec.column_size :=
310: per_cpa_shd.g_old_rec.column_size;
311: End If;
312: If (p_rec.uom_parameter = hr_api.g_varchar2) then
313: p_rec.uom_parameter := per_cpa_shd.g_old_rec.uom_parameter;
314: End If;
315: --
316: If (p_rec.uom_lookup = hr_api.g_varchar2) then

Line 316: If (p_rec.uom_lookup = hr_api.g_varchar2) then

312: If (p_rec.uom_parameter = hr_api.g_varchar2) then
313: p_rec.uom_parameter := per_cpa_shd.g_old_rec.uom_parameter;
314: End If;
315: --
316: If (p_rec.uom_lookup = hr_api.g_varchar2) then
317: p_rec.uom_lookup := per_cpa_shd.g_old_rec.uom_lookup;
318: End If;
319: --
320: If (p_rec.default_uom = hr_api.g_varchar2) then

Line 320: If (p_rec.default_uom = hr_api.g_varchar2) then

316: If (p_rec.uom_lookup = hr_api.g_varchar2) then
317: p_rec.uom_lookup := per_cpa_shd.g_old_rec.uom_lookup;
318: End If;
319: --
320: If (p_rec.default_uom = hr_api.g_varchar2) then
321: p_rec.default_uom := per_cpa_shd.g_old_rec.default_uom;
322: End If;
323: --
324: If (p_rec.hidden = hr_api.g_varchar2) then

Line 324: If (p_rec.hidden = hr_api.g_varchar2) then

320: If (p_rec.default_uom = hr_api.g_varchar2) then
321: p_rec.default_uom := per_cpa_shd.g_old_rec.default_uom;
322: End If;
323: --
324: If (p_rec.hidden = hr_api.g_varchar2) then
325: p_rec.hidden := per_cpa_shd.g_old_rec.hidden;
326: End If;
327: End convert_defs;
328: --

Line 384: ,p_cagr_api_id in number default hr_api.g_number

380: Procedure upd
381: (p_effective_date in date
382: ,p_cagr_api_param_id in number
383: ,p_object_version_number in out nocopy number
384: ,p_cagr_api_id in number default hr_api.g_number
385: ,p_display_name in varchar2 default hr_api.g_varchar2
386: ,p_parameter_name in varchar2 default hr_api.g_varchar2
387: ,p_column_type in varchar2 default hr_api.g_varchar2
388: ,p_column_size in number default hr_api.g_number

Line 385: ,p_display_name in varchar2 default hr_api.g_varchar2

381: (p_effective_date in date
382: ,p_cagr_api_param_id in number
383: ,p_object_version_number in out nocopy number
384: ,p_cagr_api_id in number default hr_api.g_number
385: ,p_display_name in varchar2 default hr_api.g_varchar2
386: ,p_parameter_name in varchar2 default hr_api.g_varchar2
387: ,p_column_type in varchar2 default hr_api.g_varchar2
388: ,p_column_size in number default hr_api.g_number
389: ,p_uom_parameter in varchar2 default hr_api.g_varchar2

Line 386: ,p_parameter_name in varchar2 default hr_api.g_varchar2

382: ,p_cagr_api_param_id in number
383: ,p_object_version_number in out nocopy number
384: ,p_cagr_api_id in number default hr_api.g_number
385: ,p_display_name in varchar2 default hr_api.g_varchar2
386: ,p_parameter_name in varchar2 default hr_api.g_varchar2
387: ,p_column_type in varchar2 default hr_api.g_varchar2
388: ,p_column_size in number default hr_api.g_number
389: ,p_uom_parameter in varchar2 default hr_api.g_varchar2
390: ,p_uom_lookup in varchar2 default hr_api.g_varchar2

Line 387: ,p_column_type in varchar2 default hr_api.g_varchar2

383: ,p_object_version_number in out nocopy number
384: ,p_cagr_api_id in number default hr_api.g_number
385: ,p_display_name in varchar2 default hr_api.g_varchar2
386: ,p_parameter_name in varchar2 default hr_api.g_varchar2
387: ,p_column_type in varchar2 default hr_api.g_varchar2
388: ,p_column_size in number default hr_api.g_number
389: ,p_uom_parameter in varchar2 default hr_api.g_varchar2
390: ,p_uom_lookup in varchar2 default hr_api.g_varchar2
391: ,p_default_uom in varchar2 default hr_api.g_varchar2

Line 388: ,p_column_size in number default hr_api.g_number

384: ,p_cagr_api_id in number default hr_api.g_number
385: ,p_display_name in varchar2 default hr_api.g_varchar2
386: ,p_parameter_name in varchar2 default hr_api.g_varchar2
387: ,p_column_type in varchar2 default hr_api.g_varchar2
388: ,p_column_size in number default hr_api.g_number
389: ,p_uom_parameter in varchar2 default hr_api.g_varchar2
390: ,p_uom_lookup in varchar2 default hr_api.g_varchar2
391: ,p_default_uom in varchar2 default hr_api.g_varchar2
392: ,p_hidden in varchar2 default hr_api.g_varchar2

Line 389: ,p_uom_parameter in varchar2 default hr_api.g_varchar2

385: ,p_display_name in varchar2 default hr_api.g_varchar2
386: ,p_parameter_name in varchar2 default hr_api.g_varchar2
387: ,p_column_type in varchar2 default hr_api.g_varchar2
388: ,p_column_size in number default hr_api.g_number
389: ,p_uom_parameter in varchar2 default hr_api.g_varchar2
390: ,p_uom_lookup in varchar2 default hr_api.g_varchar2
391: ,p_default_uom in varchar2 default hr_api.g_varchar2
392: ,p_hidden in varchar2 default hr_api.g_varchar2
393: ) is

Line 390: ,p_uom_lookup in varchar2 default hr_api.g_varchar2

386: ,p_parameter_name in varchar2 default hr_api.g_varchar2
387: ,p_column_type in varchar2 default hr_api.g_varchar2
388: ,p_column_size in number default hr_api.g_number
389: ,p_uom_parameter in varchar2 default hr_api.g_varchar2
390: ,p_uom_lookup in varchar2 default hr_api.g_varchar2
391: ,p_default_uom in varchar2 default hr_api.g_varchar2
392: ,p_hidden in varchar2 default hr_api.g_varchar2
393: ) is
394: --

Line 391: ,p_default_uom in varchar2 default hr_api.g_varchar2

387: ,p_column_type in varchar2 default hr_api.g_varchar2
388: ,p_column_size in number default hr_api.g_number
389: ,p_uom_parameter in varchar2 default hr_api.g_varchar2
390: ,p_uom_lookup in varchar2 default hr_api.g_varchar2
391: ,p_default_uom in varchar2 default hr_api.g_varchar2
392: ,p_hidden in varchar2 default hr_api.g_varchar2
393: ) is
394: --
395: l_rec per_cpa_shd.g_rec_type;

Line 392: ,p_hidden in varchar2 default hr_api.g_varchar2

388: ,p_column_size in number default hr_api.g_number
389: ,p_uom_parameter in varchar2 default hr_api.g_varchar2
390: ,p_uom_lookup in varchar2 default hr_api.g_varchar2
391: ,p_default_uom in varchar2 default hr_api.g_varchar2
392: ,p_hidden in varchar2 default hr_api.g_varchar2
393: ) is
394: --
395: l_rec per_cpa_shd.g_rec_type;
396: l_proc varchar2(72) := g_package||'upd';