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 80: pqh_tct_shd.constraint_error

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

Line 118: Procedure pre_delete(p_rec in pqh_tct_shd.g_rec_type) is

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

Line 161: p_effective_date in date,p_rec in pqh_tct_shd.g_rec_type) is

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

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

172: --
173: pqh_tct_rkd.after_delete
174: (
175: p_transaction_category_id =>p_rec.transaction_category_id
176: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
177: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
178: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
179: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
180: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd

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

173: pqh_tct_rkd.after_delete
174: (
175: p_transaction_category_id =>p_rec.transaction_category_id
176: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
177: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
178: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
179: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
180: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
181: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd

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

174: (
175: p_transaction_category_id =>p_rec.transaction_category_id
176: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
177: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
178: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
179: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
180: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
181: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
182: ,p_name_o =>pqh_tct_shd.g_old_rec.name

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

175: p_transaction_category_id =>p_rec.transaction_category_id
176: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
177: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
178: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
179: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
180: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
181: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
182: ,p_name_o =>pqh_tct_shd.g_old_rec.name
183: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name

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

176: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
177: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
178: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
179: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
180: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
181: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
182: ,p_name_o =>pqh_tct_shd.g_old_rec.name
183: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
184: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd

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

177: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
178: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
179: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
180: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
181: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
182: ,p_name_o =>pqh_tct_shd.g_old_rec.name
183: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
184: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
185: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function

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

178: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
179: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
180: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
181: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
182: ,p_name_o =>pqh_tct_shd.g_old_rec.name
183: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
184: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
185: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
186: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag

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

179: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
180: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
181: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
182: ,p_name_o =>pqh_tct_shd.g_old_rec.name
183: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
184: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
185: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
186: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
187: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip

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

180: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
181: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
182: ,p_name_o =>pqh_tct_shd.g_old_rec.name
183: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
184: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
185: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
186: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
187: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
188: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag

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

181: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
182: ,p_name_o =>pqh_tct_shd.g_old_rec.name
183: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
184: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
185: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
186: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
187: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
188: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
189: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag

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

182: ,p_name_o =>pqh_tct_shd.g_old_rec.name
183: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
184: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
185: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
186: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
187: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
188: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
189: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
190: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days

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

183: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
184: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
185: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
186: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
187: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
188: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
189: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
190: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
191: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number

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

184: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
185: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
186: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
187: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
188: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
189: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
190: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
191: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
192: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id

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

185: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
186: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
187: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
188: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
189: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
190: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
191: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
192: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
193: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id

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

186: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
187: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
188: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
189: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
190: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
191: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
192: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
193: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
194: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd

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

187: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
188: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
189: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
190: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
191: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
192: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
193: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
194: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
195: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id

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

188: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
189: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
190: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
191: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
192: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
193: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
194: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
195: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
196: );

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

189: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
190: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
191: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
192: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
193: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
194: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
195: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
196: );
197: --

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

190: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
191: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
192: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
193: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
194: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
195: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
196: );
197: --
198: exception

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

191: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
192: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
193: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
194: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
195: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
196: );
197: --
198: exception
199: --

Line 220: p_rec in pqh_tct_shd.g_rec_type

216: -- ----------------------------------------------------------------------------
217: Procedure del
218: (
219: p_effective_date in date,
220: p_rec in pqh_tct_shd.g_rec_type
221: ) is
222: --
223: l_proc varchar2(72) := g_package||'del';
224: --

Line 230: pqh_tct_shd.lck

226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: -- We must lock the row which we need to delete.
229: --
230: pqh_tct_shd.lck
231: (
232: p_rec.transaction_category_id,
233: p_rec.object_version_number
234: );

Line 265: l_rec pqh_tct_shd.g_rec_type;

261: p_transaction_category_id in number,
262: p_object_version_number in number
263: ) is
264: --
265: l_rec pqh_tct_shd.g_rec_type;
266: l_proc varchar2(72) := g_package||'del';
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);