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_TCT_DEL dependencies on PQH_TCT_SHD

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

Line 64: pqh_tct_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_tct_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_tct_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_tct_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_tct_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_tct_shd.g_rec_type) is
146: --
147: l_proc varchar2(72) := g_package||'post_delete';
148: --
149: Begin

Line 160: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name

156: --
157: pqh_tct_rkd.after_delete
158: (
159: p_transaction_category_id =>p_rec.transaction_category_id
160: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
161: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
162: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
163: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
164: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd

Line 161: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name

157: pqh_tct_rkd.after_delete
158: (
159: p_transaction_category_id =>p_rec.transaction_category_id
160: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
161: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
162: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
163: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
164: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
165: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd

Line 162: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name

158: (
159: p_transaction_category_id =>p_rec.transaction_category_id
160: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
161: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
162: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
163: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
164: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
165: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
166: ,p_name_o =>pqh_tct_shd.g_old_rec.name

Line 163: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd

159: p_transaction_category_id =>p_rec.transaction_category_id
160: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
161: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
162: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
163: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
164: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
165: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
166: ,p_name_o =>pqh_tct_shd.g_old_rec.name
167: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name

Line 164: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd

160: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
161: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
162: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
163: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
164: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
165: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
166: ,p_name_o =>pqh_tct_shd.g_old_rec.name
167: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
168: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd

Line 165: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd

161: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
162: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
163: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
164: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
165: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
166: ,p_name_o =>pqh_tct_shd.g_old_rec.name
167: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
168: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
169: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function

Line 166: ,p_name_o =>pqh_tct_shd.g_old_rec.name

162: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
163: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
164: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
165: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
166: ,p_name_o =>pqh_tct_shd.g_old_rec.name
167: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
168: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
169: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
170: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag

Line 167: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name

163: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
164: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
165: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
166: ,p_name_o =>pqh_tct_shd.g_old_rec.name
167: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
168: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
169: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
170: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
171: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip

Line 168: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd

164: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
165: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
166: ,p_name_o =>pqh_tct_shd.g_old_rec.name
167: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
168: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
169: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
170: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
171: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
172: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag

Line 169: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function

165: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
166: ,p_name_o =>pqh_tct_shd.g_old_rec.name
167: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
168: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
169: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
170: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
171: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
172: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
173: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag

Line 170: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag

166: ,p_name_o =>pqh_tct_shd.g_old_rec.name
167: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
168: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
169: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
170: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
171: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
172: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
173: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
174: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days

Line 171: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip

167: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
168: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
169: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
170: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
171: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
172: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
173: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
174: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
175: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number

Line 172: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag

168: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
169: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
170: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
171: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
172: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
173: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
174: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
175: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
176: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id

Line 173: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag

169: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
170: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
171: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
172: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
173: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
174: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
175: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
176: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
177: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id

Line 174: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days

170: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
171: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
172: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
173: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
174: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
175: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
176: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
177: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
178: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd

Line 175: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number

171: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
172: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
173: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
174: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
175: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
176: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
177: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
178: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
179: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id

Line 176: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id

172: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
173: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
174: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
175: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
176: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
177: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
178: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
179: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
180: );

Line 177: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id

173: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
174: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
175: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
176: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
177: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
178: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
179: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
180: );
181: --

Line 178: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd

174: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
175: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
176: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
177: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
178: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
179: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
180: );
181: --
182: exception

Line 179: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id

175: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
176: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
177: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
178: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
179: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
180: );
181: --
182: exception
183: --

Line 204: p_rec in pqh_tct_shd.g_rec_type

200: -- ----------------------------------------------------------------------------
201: Procedure del
202: (
203: p_effective_date in date,
204: p_rec in pqh_tct_shd.g_rec_type
205: ) is
206: --
207: l_proc varchar2(72) := g_package||'del';
208: --

Line 214: pqh_tct_shd.lck

210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: -- We must lock the row which we need to delete.
213: --
214: pqh_tct_shd.lck
215: (
216: p_rec.transaction_category_id,
217: p_rec.object_version_number
218: );

Line 249: l_rec pqh_tct_shd.g_rec_type;

245: p_transaction_category_id in number,
246: p_object_version_number in number
247: ) is
248: --
249: l_rec pqh_tct_shd.g_rec_type;
250: l_proc varchar2(72) := g_package||'del';
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);