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 PQH_ATT_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pqh_att_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pqh_att_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 84: pqh_att_shd.constraint_error

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
87: -- Parent integrity has been violated
88: pqh_att_shd.constraint_error

Line 88: pqh_att_shd.constraint_error

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
91: -- Unique integrity has been violated
92: pqh_att_shd.constraint_error

Line 92: pqh_att_shd.constraint_error

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
95: Raise;
96: End update_dml;

Line 130: Procedure pre_update(p_rec in pqh_att_shd.g_rec_type) is

126: -- Internal Row Handler Use Only.
127: --
128: -- {End Of Comments}
129: -- ----------------------------------------------------------------------------
130: Procedure pre_update(p_rec in pqh_att_shd.g_rec_type) is
131: --
132: l_proc varchar2(72) := g_package||'pre_update';
133: --
134: Begin

Line 173: p_effective_date in date,p_rec in pqh_att_shd.g_rec_type) is

169: --
170: -- {End Of Comments}
171: -- ----------------------------------------------------------------------------
172: Procedure post_update(
173: p_effective_date in date,p_rec in pqh_att_shd.g_rec_type) is
174: --
175: l_proc varchar2(72) := g_package||'post_update';
176: --
177: Begin

Line 200: ,p_attribute_name_o =>pqh_att_shd.g_old_rec.attribute_name

196: ,p_effective_date =>p_effective_date
197: ,p_region_itemname =>p_rec.region_itemname
198: ,p_attribute_itemname =>p_rec.attribute_itemname
199: ,p_decode_function_name =>p_rec.decode_function_name
200: ,p_attribute_name_o =>pqh_att_shd.g_old_rec.attribute_name
201: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
202: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
203: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
204: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type

Line 201: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id

197: ,p_region_itemname =>p_rec.region_itemname
198: ,p_attribute_itemname =>p_rec.attribute_itemname
199: ,p_decode_function_name =>p_rec.decode_function_name
200: ,p_attribute_name_o =>pqh_att_shd.g_old_rec.attribute_name
201: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
202: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
203: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
204: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
205: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag

Line 202: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id

198: ,p_attribute_itemname =>p_rec.attribute_itemname
199: ,p_decode_function_name =>p_rec.decode_function_name
200: ,p_attribute_name_o =>pqh_att_shd.g_old_rec.attribute_name
201: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
202: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
203: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
204: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
205: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
206: ,p_width_o =>pqh_att_shd.g_old_rec.width

Line 203: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name

199: ,p_decode_function_name =>p_rec.decode_function_name
200: ,p_attribute_name_o =>pqh_att_shd.g_old_rec.attribute_name
201: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
202: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
203: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
204: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
205: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
206: ,p_width_o =>pqh_att_shd.g_old_rec.width
207: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number

Line 204: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type

200: ,p_attribute_name_o =>pqh_att_shd.g_old_rec.attribute_name
201: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
202: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
203: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
204: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
205: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
206: ,p_width_o =>pqh_att_shd.g_old_rec.width
207: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
208: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname

Line 205: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag

201: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
202: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
203: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
204: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
205: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
206: ,p_width_o =>pqh_att_shd.g_old_rec.width
207: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
208: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
209: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname

Line 206: ,p_width_o =>pqh_att_shd.g_old_rec.width

202: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
203: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
204: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
205: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
206: ,p_width_o =>pqh_att_shd.g_old_rec.width
207: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
208: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
209: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname
210: ,p_decode_function_name_o =>pqh_att_shd.g_old_rec.decode_function_name

Line 207: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number

203: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
204: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
205: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
206: ,p_width_o =>pqh_att_shd.g_old_rec.width
207: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
208: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
209: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname
210: ,p_decode_function_name_o =>pqh_att_shd.g_old_rec.decode_function_name
211: );

Line 208: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname

204: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
205: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
206: ,p_width_o =>pqh_att_shd.g_old_rec.width
207: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
208: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
209: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname
210: ,p_decode_function_name_o =>pqh_att_shd.g_old_rec.decode_function_name
211: );
212: --

Line 209: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname

205: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
206: ,p_width_o =>pqh_att_shd.g_old_rec.width
207: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
208: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
209: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname
210: ,p_decode_function_name_o =>pqh_att_shd.g_old_rec.decode_function_name
211: );
212: --
213: exception

Line 210: ,p_decode_function_name_o =>pqh_att_shd.g_old_rec.decode_function_name

206: ,p_width_o =>pqh_att_shd.g_old_rec.width
207: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
208: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
209: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname
210: ,p_decode_function_name_o =>pqh_att_shd.g_old_rec.decode_function_name
211: );
212: --
213: exception
214: --

Line 272: Procedure convert_defs(p_rec in out nocopy pqh_att_shd.g_rec_type) is

268: -- Internal Row Handler Use Only.
269: --
270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure convert_defs(p_rec in out nocopy pqh_att_shd.g_rec_type) is
273: --
274: l_proc varchar2(72) := g_package||'convert_defs';
275: --
276: Begin

Line 287: pqh_att_shd.g_old_rec.attribute_name;

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
290: p_rec.master_attribute_id :=
291: pqh_att_shd.g_old_rec.master_attribute_id;

Line 291: pqh_att_shd.g_old_rec.master_attribute_id;

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
294: p_rec.master_table_route_id :=
295: pqh_att_shd.g_old_rec.master_table_route_id;

Line 295: pqh_att_shd.g_old_rec.master_table_route_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
298: p_rec.column_name := pqh_att_shd.g_old_rec.column_name;
299: End If;

Line 298: p_rec.column_name := pqh_att_shd.g_old_rec.column_name;

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;
302: End If;

Line 301: p_rec.column_type := pqh_att_shd.g_old_rec.column_type;

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;
305: End If;

Line 304: p_rec.enable_flag := pqh_att_shd.g_old_rec.enable_flag;

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;
308: End If;

Line 307: p_rec.width := pqh_att_shd.g_old_rec.width;

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;
311: End If;

Line 310: p_rec.region_itemname := pqh_att_shd.g_old_rec.region_itemname;

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;
314: End If;

Line 313: p_rec.attribute_itemname := pqh_att_shd.g_old_rec.attribute_itemname;

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;
317: End If;

Line 316: p_rec.decode_function_name := pqh_att_shd.g_old_rec.decode_function_name;

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);
320: --

Line 329: p_rec in out nocopy pqh_att_shd.g_rec_type

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

Line 339: pqh_att_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: pqh_att_shd.lck
340: (
341: p_rec.attribute_id,
342: p_rec.object_version_number
343: );

Line 389: l_rec pqh_att_shd.g_rec_type;

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';
391: --
392: Begin
393: hr_utility.set_location('Entering:'||l_proc, 5);

Line 399: pqh_att_shd.convert_args

395: -- Call conversion function to turn arguments into the
396: -- l_rec structure.
397: --
398: l_rec :=
399: pqh_att_shd.convert_args
400: (
401: p_attribute_id,
402: p_attribute_name,
403: p_master_attribute_id,