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

Line 82: When hr_api.check_integrity_violated Then

78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pqh_att_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then

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

81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pqh_att_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: pqh_att_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 86: When hr_api.parent_integrity_violated Then

82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pqh_att_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: pqh_att_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then

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

85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: pqh_att_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated
92: pqh_att_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 90: When hr_api.unique_integrity_violated Then

86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: pqh_att_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated
92: pqh_att_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When Others Then

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

89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated
92: pqh_att_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When Others Then
95: Raise;
96: End update_dml;
97: --

Line 215: when hr_api.cannot_find_prog_unit then

211: );
212: --
213: exception
214: --
215: when hr_api.cannot_find_prog_unit then
216: --
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'pqh_attributes'
219: ,p_hook_type => 'AU');

Line 217: hr_api.cannot_find_prog_unit_error

213: exception
214: --
215: when hr_api.cannot_find_prog_unit then
216: --
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'pqh_attributes'
219: ,p_hook_type => 'AU');
220: --
221: end;

Line 285: If (p_rec.attribute_name = hr_api.g_varchar2) then

281: -- p_rec plsql record structure
282: -- to see if a system default is being used. If a system default
283: -- is being used then we must set to the 'current' argument value.
284: --
285: If (p_rec.attribute_name = hr_api.g_varchar2) then
286: p_rec.attribute_name :=
287: pqh_att_shd.g_old_rec.attribute_name;
288: End If;
289: If (p_rec.master_attribute_id = hr_api.g_number) then

Line 289: If (p_rec.master_attribute_id = hr_api.g_number) then

285: If (p_rec.attribute_name = hr_api.g_varchar2) then
286: p_rec.attribute_name :=
287: pqh_att_shd.g_old_rec.attribute_name;
288: End If;
289: If (p_rec.master_attribute_id = hr_api.g_number) then
290: p_rec.master_attribute_id :=
291: pqh_att_shd.g_old_rec.master_attribute_id;
292: End If;
293: If (p_rec.master_table_route_id = hr_api.g_number) then

Line 293: If (p_rec.master_table_route_id = hr_api.g_number) then

289: If (p_rec.master_attribute_id = hr_api.g_number) then
290: p_rec.master_attribute_id :=
291: pqh_att_shd.g_old_rec.master_attribute_id;
292: End If;
293: If (p_rec.master_table_route_id = hr_api.g_number) then
294: p_rec.master_table_route_id :=
295: pqh_att_shd.g_old_rec.master_table_route_id;
296: End If;
297: If (p_rec.column_name = hr_api.g_varchar2) then

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

293: If (p_rec.master_table_route_id = hr_api.g_number) then
294: p_rec.master_table_route_id :=
295: pqh_att_shd.g_old_rec.master_table_route_id;
296: End If;
297: If (p_rec.column_name = hr_api.g_varchar2) then
298: p_rec.column_name := pqh_att_shd.g_old_rec.column_name;
299: End If;
300: If (p_rec.column_type = hr_api.g_varchar2) then
301: p_rec.column_type := pqh_att_shd.g_old_rec.column_type;

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

296: End If;
297: If (p_rec.column_name = hr_api.g_varchar2) then
298: p_rec.column_name := pqh_att_shd.g_old_rec.column_name;
299: End If;
300: If (p_rec.column_type = hr_api.g_varchar2) then
301: p_rec.column_type := pqh_att_shd.g_old_rec.column_type;
302: End If;
303: If (p_rec.enable_flag = hr_api.g_varchar2) then
304: p_rec.enable_flag := pqh_att_shd.g_old_rec.enable_flag;

Line 303: If (p_rec.enable_flag = hr_api.g_varchar2) then

299: End If;
300: If (p_rec.column_type = hr_api.g_varchar2) then
301: p_rec.column_type := pqh_att_shd.g_old_rec.column_type;
302: End If;
303: If (p_rec.enable_flag = hr_api.g_varchar2) then
304: p_rec.enable_flag := pqh_att_shd.g_old_rec.enable_flag;
305: End If;
306: If (p_rec.width = hr_api.g_number) then
307: p_rec.width := pqh_att_shd.g_old_rec.width;

Line 306: If (p_rec.width = hr_api.g_number) then

302: End If;
303: If (p_rec.enable_flag = hr_api.g_varchar2) then
304: p_rec.enable_flag := pqh_att_shd.g_old_rec.enable_flag;
305: End If;
306: If (p_rec.width = hr_api.g_number) then
307: p_rec.width := pqh_att_shd.g_old_rec.width;
308: End If;
309: If (p_rec.region_itemname = hr_api.g_varchar2) then
310: p_rec.region_itemname := pqh_att_shd.g_old_rec.region_itemname;

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

305: End If;
306: If (p_rec.width = hr_api.g_number) then
307: p_rec.width := pqh_att_shd.g_old_rec.width;
308: End If;
309: If (p_rec.region_itemname = hr_api.g_varchar2) then
310: p_rec.region_itemname := pqh_att_shd.g_old_rec.region_itemname;
311: End If;
312: If (p_rec.attribute_itemname = hr_api.g_varchar2) then
313: p_rec.attribute_itemname := pqh_att_shd.g_old_rec.attribute_itemname;

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

308: End If;
309: If (p_rec.region_itemname = hr_api.g_varchar2) then
310: p_rec.region_itemname := pqh_att_shd.g_old_rec.region_itemname;
311: End If;
312: If (p_rec.attribute_itemname = hr_api.g_varchar2) then
313: p_rec.attribute_itemname := pqh_att_shd.g_old_rec.attribute_itemname;
314: End If;
315: If (p_rec.decode_function_name = hr_api.g_varchar2) then
316: p_rec.decode_function_name := pqh_att_shd.g_old_rec.decode_function_name;

Line 315: If (p_rec.decode_function_name = hr_api.g_varchar2) then

311: End If;
312: If (p_rec.attribute_itemname = hr_api.g_varchar2) then
313: p_rec.attribute_itemname := pqh_att_shd.g_old_rec.attribute_itemname;
314: End If;
315: If (p_rec.decode_function_name = hr_api.g_varchar2) then
316: p_rec.decode_function_name := pqh_att_shd.g_old_rec.decode_function_name;
317: End If;
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 376: p_attribute_name in varchar2 default hr_api.g_varchar2,

372: Procedure upd
373: (
374: p_effective_date in date,
375: p_attribute_id in number,
376: p_attribute_name in varchar2 default hr_api.g_varchar2,
377: p_master_attribute_id in number default hr_api.g_number,
378: p_master_table_route_id in number default hr_api.g_number,
379: p_column_name in varchar2 default hr_api.g_varchar2,
380: p_column_type in varchar2 default hr_api.g_varchar2,

Line 377: p_master_attribute_id in number default hr_api.g_number,

373: (
374: p_effective_date in date,
375: p_attribute_id in number,
376: p_attribute_name in varchar2 default hr_api.g_varchar2,
377: p_master_attribute_id in number default hr_api.g_number,
378: p_master_table_route_id in number default hr_api.g_number,
379: p_column_name in varchar2 default hr_api.g_varchar2,
380: p_column_type in varchar2 default hr_api.g_varchar2,
381: p_enable_flag in varchar2 default hr_api.g_varchar2,

Line 378: p_master_table_route_id in number default hr_api.g_number,

374: p_effective_date in date,
375: p_attribute_id in number,
376: p_attribute_name in varchar2 default hr_api.g_varchar2,
377: p_master_attribute_id in number default hr_api.g_number,
378: p_master_table_route_id in number default hr_api.g_number,
379: p_column_name in varchar2 default hr_api.g_varchar2,
380: p_column_type in varchar2 default hr_api.g_varchar2,
381: p_enable_flag in varchar2 default hr_api.g_varchar2,
382: p_width in number default hr_api.g_number,

Line 379: p_column_name in varchar2 default hr_api.g_varchar2,

375: p_attribute_id in number,
376: p_attribute_name in varchar2 default hr_api.g_varchar2,
377: p_master_attribute_id in number default hr_api.g_number,
378: p_master_table_route_id in number default hr_api.g_number,
379: p_column_name in varchar2 default hr_api.g_varchar2,
380: p_column_type in varchar2 default hr_api.g_varchar2,
381: p_enable_flag in varchar2 default hr_api.g_varchar2,
382: p_width in number default hr_api.g_number,
383: p_object_version_number in out nocopy number,

Line 380: p_column_type in varchar2 default hr_api.g_varchar2,

376: p_attribute_name in varchar2 default hr_api.g_varchar2,
377: p_master_attribute_id in number default hr_api.g_number,
378: p_master_table_route_id in number default hr_api.g_number,
379: p_column_name in varchar2 default hr_api.g_varchar2,
380: p_column_type in varchar2 default hr_api.g_varchar2,
381: p_enable_flag in varchar2 default hr_api.g_varchar2,
382: p_width in number default hr_api.g_number,
383: p_object_version_number in out nocopy number,
384: p_region_itemname in varchar2 default hr_api.g_varchar2,

Line 381: p_enable_flag in varchar2 default hr_api.g_varchar2,

377: p_master_attribute_id in number default hr_api.g_number,
378: p_master_table_route_id in number default hr_api.g_number,
379: p_column_name in varchar2 default hr_api.g_varchar2,
380: p_column_type in varchar2 default hr_api.g_varchar2,
381: p_enable_flag in varchar2 default hr_api.g_varchar2,
382: p_width in number default hr_api.g_number,
383: p_object_version_number in out nocopy number,
384: p_region_itemname in varchar2 default hr_api.g_varchar2,
385: p_attribute_itemname in varchar2 default hr_api.g_varchar2,

Line 382: p_width in number default hr_api.g_number,

378: p_master_table_route_id in number default hr_api.g_number,
379: p_column_name in varchar2 default hr_api.g_varchar2,
380: p_column_type in varchar2 default hr_api.g_varchar2,
381: p_enable_flag in varchar2 default hr_api.g_varchar2,
382: p_width in number default hr_api.g_number,
383: p_object_version_number in out nocopy number,
384: p_region_itemname in varchar2 default hr_api.g_varchar2,
385: p_attribute_itemname in varchar2 default hr_api.g_varchar2,
386: p_decode_function_name in varchar2 default hr_api.g_varchar2

Line 384: p_region_itemname in varchar2 default hr_api.g_varchar2,

380: p_column_type in varchar2 default hr_api.g_varchar2,
381: p_enable_flag in varchar2 default hr_api.g_varchar2,
382: p_width in number default hr_api.g_number,
383: p_object_version_number in out nocopy number,
384: p_region_itemname in varchar2 default hr_api.g_varchar2,
385: p_attribute_itemname in varchar2 default hr_api.g_varchar2,
386: p_decode_function_name in varchar2 default hr_api.g_varchar2
387: ) is
388: --

Line 385: p_attribute_itemname in varchar2 default hr_api.g_varchar2,

381: p_enable_flag in varchar2 default hr_api.g_varchar2,
382: p_width in number default hr_api.g_number,
383: p_object_version_number in out nocopy number,
384: p_region_itemname in varchar2 default hr_api.g_varchar2,
385: p_attribute_itemname in varchar2 default hr_api.g_varchar2,
386: p_decode_function_name in varchar2 default hr_api.g_varchar2
387: ) is
388: --
389: l_rec pqh_att_shd.g_rec_type;

Line 386: p_decode_function_name in varchar2 default hr_api.g_varchar2

382: p_width in number default hr_api.g_number,
383: p_object_version_number in out nocopy number,
384: p_region_itemname in varchar2 default hr_api.g_varchar2,
385: p_attribute_itemname in varchar2 default hr_api.g_varchar2,
386: p_decode_function_name in varchar2 default hr_api.g_varchar2
387: ) is
388: --
389: l_rec pqh_att_shd.g_rec_type;
390: l_proc varchar2(72) := g_package||'upd';