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 64: pqh_tca_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_tca_shd.constraint_error
65: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
66: When Others Then
67: Raise;
68: End delete_dml;

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

98: -- Internal Row Handler Use Only.
99: --
100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure pre_delete(p_rec in pqh_tca_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: Begin

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

141: --
142: -- {End Of Comments}
143: -- ----------------------------------------------------------------------------
144: Procedure post_delete(
145: p_effective_date in date,p_rec in pqh_tca_shd.g_rec_type) is
146: --
147: l_proc varchar2(72) := g_package||'post_delete';
148: --
149: Begin

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

156: --
157: pqh_tca_rkd.after_delete
158: (
159: p_txn_category_attribute_id =>p_rec.txn_category_attribute_id
160: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
161: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
162: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
163: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
164: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id

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

157: pqh_tca_rkd.after_delete
158: (
159: p_txn_category_attribute_id =>p_rec.txn_category_attribute_id
160: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
161: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
162: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
163: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
164: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
165: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name

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

158: (
159: p_txn_category_attribute_id =>p_rec.txn_category_attribute_id
160: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
161: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
162: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
163: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
164: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
165: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
166: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag

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

159: p_txn_category_attribute_id =>p_rec.txn_category_attribute_id
160: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
161: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
162: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
163: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
164: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
165: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
166: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
167: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag

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

160: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
161: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
162: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
163: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
164: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
165: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
166: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
167: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
168: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag

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

161: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
162: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
163: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
164: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
165: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
166: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
167: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
168: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
169: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag

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

162: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
163: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
164: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
165: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
166: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
167: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
168: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
169: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
170: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag

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

163: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
164: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
165: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
166: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
167: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
168: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
169: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
170: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
171: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd

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

164: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
165: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
166: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
167: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
168: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
169: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
170: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
171: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
172: );

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

165: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
166: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
167: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
168: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
169: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
170: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
171: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
172: );
173: --

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

166: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
167: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
168: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
169: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
170: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
171: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
172: );
173: --
174: exception

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

167: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
168: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
169: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
170: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
171: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
172: );
173: --
174: exception
175: --

Line 196: p_rec in pqh_tca_shd.g_rec_type

192: -- ----------------------------------------------------------------------------
193: Procedure del
194: (
195: p_effective_date in date,
196: p_rec in pqh_tca_shd.g_rec_type
197: ) is
198: --
199: l_proc varchar2(72) := g_package||'del';
200: --

Line 206: pqh_tca_shd.lck

202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: -- We must lock the row which we need to delete.
205: --
206: pqh_tca_shd.lck
207: (
208: p_rec.txn_category_attribute_id,
209: p_rec.object_version_number
210: );

Line 241: l_rec pqh_tca_shd.g_rec_type;

237: p_txn_category_attribute_id in number,
238: p_object_version_number in number
239: ) is
240: --
241: l_rec pqh_tca_shd.g_rec_type;
242: l_proc varchar2(72) := g_package||'del';
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);