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_DEL dependencies on PQH_ATT_SHD

Line 45: Procedure delete_dml(p_rec in pqh_att_shd.g_rec_type) is

41: -- Internal Row Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in pqh_att_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 84: pqh_att_shd.constraint_error

80: --
81: Exception
82: When hr_api.child_integrity_violated then
83: -- Child integrity has been violated
84: pqh_att_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: Raise;
88: End delete_dml;

Line 122: Procedure pre_delete(p_rec in pqh_att_shd.g_rec_type) is

118: -- Internal Row Handler Use Only.
119: --
120: -- {End Of Comments}
121: -- ----------------------------------------------------------------------------
122: Procedure pre_delete(p_rec in pqh_att_shd.g_rec_type) is
123: --
124: l_proc varchar2(72) := g_package||'pre_delete';
125: --
126: Begin

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

161: --
162: -- {End Of Comments}
163: -- ----------------------------------------------------------------------------
164: Procedure post_delete(
165: p_effective_date in date,p_rec in pqh_att_shd.g_rec_type) is
166: --
167: l_proc varchar2(72) := g_package||'post_delete';
168: --
169: Begin

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

176: --
177: pqh_att_rkd.after_delete
178: (
179: p_attribute_id =>p_rec.attribute_id
180: ,p_attribute_name_o =>pqh_att_shd.g_old_rec.attribute_name
181: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
182: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
183: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
184: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type

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

177: pqh_att_rkd.after_delete
178: (
179: p_attribute_id =>p_rec.attribute_id
180: ,p_attribute_name_o =>pqh_att_shd.g_old_rec.attribute_name
181: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
182: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
183: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
184: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
185: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag

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

178: (
179: p_attribute_id =>p_rec.attribute_id
180: ,p_attribute_name_o =>pqh_att_shd.g_old_rec.attribute_name
181: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
182: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
183: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
184: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
185: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
186: ,p_width_o =>pqh_att_shd.g_old_rec.width

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

179: p_attribute_id =>p_rec.attribute_id
180: ,p_attribute_name_o =>pqh_att_shd.g_old_rec.attribute_name
181: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
182: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
183: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
184: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
185: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
186: ,p_width_o =>pqh_att_shd.g_old_rec.width
187: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number

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

180: ,p_attribute_name_o =>pqh_att_shd.g_old_rec.attribute_name
181: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
182: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
183: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
184: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
185: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
186: ,p_width_o =>pqh_att_shd.g_old_rec.width
187: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
188: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname

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

181: ,p_master_attribute_id_o =>pqh_att_shd.g_old_rec.master_attribute_id
182: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
183: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
184: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
185: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
186: ,p_width_o =>pqh_att_shd.g_old_rec.width
187: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
188: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
189: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname

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

182: ,p_master_table_route_id_o =>pqh_att_shd.g_old_rec.master_table_route_id
183: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
184: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
185: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
186: ,p_width_o =>pqh_att_shd.g_old_rec.width
187: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
188: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
189: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname
190: ,p_decode_function_name_o =>pqh_att_shd.g_old_rec.decode_function_name

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

183: ,p_column_name_o =>pqh_att_shd.g_old_rec.column_name
184: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
185: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
186: ,p_width_o =>pqh_att_shd.g_old_rec.width
187: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
188: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
189: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname
190: ,p_decode_function_name_o =>pqh_att_shd.g_old_rec.decode_function_name
191: );

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

184: ,p_column_type_o =>pqh_att_shd.g_old_rec.column_type
185: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
186: ,p_width_o =>pqh_att_shd.g_old_rec.width
187: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
188: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
189: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname
190: ,p_decode_function_name_o =>pqh_att_shd.g_old_rec.decode_function_name
191: );
192: --

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

185: ,p_enable_flag_o =>pqh_att_shd.g_old_rec.enable_flag
186: ,p_width_o =>pqh_att_shd.g_old_rec.width
187: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
188: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
189: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname
190: ,p_decode_function_name_o =>pqh_att_shd.g_old_rec.decode_function_name
191: );
192: --
193: exception

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

186: ,p_width_o =>pqh_att_shd.g_old_rec.width
187: ,p_object_version_number_o =>pqh_att_shd.g_old_rec.object_version_number
188: ,p_region_itemname_o =>pqh_att_shd.g_old_rec.region_itemname
189: ,p_attribute_itemname_o =>pqh_att_shd.g_old_rec.attribute_itemname
190: ,p_decode_function_name_o =>pqh_att_shd.g_old_rec.decode_function_name
191: );
192: --
193: exception
194: --

Line 215: p_rec in pqh_att_shd.g_rec_type

211: -- ----------------------------------------------------------------------------
212: Procedure del
213: (
214: p_effective_date in date,
215: p_rec in pqh_att_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'del';
219: --

Line 225: pqh_att_shd.lck

221: hr_utility.set_location('Entering:'||l_proc, 5);
222: --
223: -- We must lock the row which we need to delete.
224: --
225: pqh_att_shd.lck
226: (
227: p_rec.attribute_id,
228: p_rec.object_version_number
229: );

Line 260: l_rec pqh_att_shd.g_rec_type;

256: p_attribute_id in number,
257: p_object_version_number in number
258: ) is
259: --
260: l_rec pqh_att_shd.g_rec_type;
261: l_proc varchar2(72) := g_package||'del';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);