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_TCA_DEL dependencies on PQH_TCA_SHD

Line 45: Procedure delete_dml(p_rec in pqh_tca_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_tca_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 78: pqh_tca_shd.constraint_error

74: --
75: Exception
76: When hr_api.child_integrity_violated then
77: -- Child integrity has been violated
78: pqh_tca_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When Others Then
81: Raise;
82: End delete_dml;

Line 116: Procedure pre_delete(p_rec in pqh_tca_shd.g_rec_type) is

112: -- Internal Row Handler Use Only.
113: --
114: -- {End Of Comments}
115: -- ----------------------------------------------------------------------------
116: Procedure pre_delete(p_rec in pqh_tca_shd.g_rec_type) is
117: --
118: l_proc varchar2(72) := g_package||'pre_delete';
119: --
120: Begin

Line 159: p_effective_date in date,p_rec in pqh_tca_shd.g_rec_type) is

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure post_delete(
159: p_effective_date in date,p_rec in pqh_tca_shd.g_rec_type) is
160: --
161: l_proc varchar2(72) := g_package||'post_delete';
162: --
163: Begin

Line 174: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id

170: --
171: pqh_tca_rkd.after_delete
172: (
173: p_txn_category_attribute_id =>p_rec.txn_category_attribute_id
174: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
175: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
176: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
177: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
178: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id

Line 175: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id

171: pqh_tca_rkd.after_delete
172: (
173: p_txn_category_attribute_id =>p_rec.txn_category_attribute_id
174: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
175: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
176: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
177: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
178: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
179: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name

Line 176: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id

172: (
173: p_txn_category_attribute_id =>p_rec.txn_category_attribute_id
174: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
175: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
176: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
177: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
178: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
179: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
180: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag

Line 177: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number

173: p_txn_category_attribute_id =>p_rec.txn_category_attribute_id
174: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
175: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
176: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
177: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
178: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
179: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
180: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
181: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag

Line 178: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id

174: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
175: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
176: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
177: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
178: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
179: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
180: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
181: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
182: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag

Line 179: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name

175: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
176: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
177: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
178: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
179: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
180: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
181: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
182: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
183: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag

Line 180: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag

176: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
177: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
178: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
179: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
180: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
181: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
182: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
183: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
184: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag

Line 181: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag

177: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
178: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
179: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
180: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
181: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
182: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
183: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
184: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
185: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd

Line 182: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag

178: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
179: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
180: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
181: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
182: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
183: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
184: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
185: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
186: );

Line 183: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag

179: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
180: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
181: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
182: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
183: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
184: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
185: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
186: );
187: --

Line 184: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag

180: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
181: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
182: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
183: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
184: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
185: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
186: );
187: --
188: exception

Line 185: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd

181: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
182: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
183: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
184: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
185: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
186: );
187: --
188: exception
189: --

Line 210: p_rec in pqh_tca_shd.g_rec_type

206: -- ----------------------------------------------------------------------------
207: Procedure del
208: (
209: p_effective_date in date,
210: p_rec in pqh_tca_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'del';
214: --

Line 220: pqh_tca_shd.lck

216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: -- We must lock the row which we need to delete.
219: --
220: pqh_tca_shd.lck
221: (
222: p_rec.txn_category_attribute_id,
223: p_rec.object_version_number
224: );

Line 255: l_rec pqh_tca_shd.g_rec_type;

251: p_txn_category_attribute_id in number,
252: p_object_version_number in number
253: ) is
254: --
255: l_rec pqh_tca_shd.g_rec_type;
256: l_proc varchar2(72) := g_package||'del';
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);