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

Line 48: Procedure update_dml(p_rec in out nocopy pqh_tct_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pqh_tct_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 93: pqh_tct_shd.constraint_error

89: --
90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: pqh_tct_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: pqh_tct_shd.constraint_error

Line 97: pqh_tct_shd.constraint_error

93: pqh_tct_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: pqh_tct_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: pqh_tct_shd.constraint_error

Line 101: pqh_tct_shd.constraint_error

97: pqh_tct_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: pqh_tct_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: Raise;
105: End update_dml;

Line 139: Procedure pre_update(p_rec in pqh_tct_shd.g_rec_type) is

135: -- Internal Row Handler Use Only.
136: --
137: -- {End Of Comments}
138: -- ----------------------------------------------------------------------------
139: Procedure pre_update(p_rec in pqh_tct_shd.g_rec_type) is
140: --
141: l_proc varchar2(72) := g_package||'pre_update';
142: --
143: Begin

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

178: --
179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure post_update(
182: p_effective_date in date,p_rec in pqh_tct_shd.g_rec_type) is
183: --
184: l_proc varchar2(72) := g_package||'post_update';
185: --
186: Begin

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

214: ,p_business_group_id => p_rec.business_group_id
215: ,p_setup_type_cd => p_rec.setup_type_cd
216: ,p_master_table_route_id =>p_rec.master_table_route_id
217: ,p_effective_date =>p_effective_date
218: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
219: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
220: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
221: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
222: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd

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

215: ,p_setup_type_cd => p_rec.setup_type_cd
216: ,p_master_table_route_id =>p_rec.master_table_route_id
217: ,p_effective_date =>p_effective_date
218: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
219: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
220: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
221: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
222: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
223: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd

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

216: ,p_master_table_route_id =>p_rec.master_table_route_id
217: ,p_effective_date =>p_effective_date
218: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
219: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
220: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
221: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
222: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
223: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
224: ,p_name_o =>pqh_tct_shd.g_old_rec.name

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

217: ,p_effective_date =>p_effective_date
218: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
219: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
220: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
221: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
222: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
223: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
224: ,p_name_o =>pqh_tct_shd.g_old_rec.name
225: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name

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

218: ,p_custom_wf_process_name_o =>pqh_tct_shd.g_old_rec.custom_wf_process_name
219: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
220: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
221: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
222: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
223: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
224: ,p_name_o =>pqh_tct_shd.g_old_rec.name
225: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
226: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd

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

219: ,p_custom_workflow_name_o =>pqh_tct_shd.g_old_rec.custom_workflow_name
220: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
221: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
222: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
223: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
224: ,p_name_o =>pqh_tct_shd.g_old_rec.name
225: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
226: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
227: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function

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

220: ,p_form_name_o =>pqh_tct_shd.g_old_rec.form_name
221: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
222: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
223: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
224: ,p_name_o =>pqh_tct_shd.g_old_rec.name
225: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
226: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
227: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
228: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag

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

221: ,p_freeze_status_cd_o =>pqh_tct_shd.g_old_rec.freeze_status_cd
222: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
223: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
224: ,p_name_o =>pqh_tct_shd.g_old_rec.name
225: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
226: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
227: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
228: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
229: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip

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

222: ,p_future_action_cd_o =>pqh_tct_shd.g_old_rec.future_action_cd
223: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
224: ,p_name_o =>pqh_tct_shd.g_old_rec.name
225: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
226: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
227: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
228: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
229: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
230: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag

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

223: ,p_member_cd_o =>pqh_tct_shd.g_old_rec.member_cd
224: ,p_name_o =>pqh_tct_shd.g_old_rec.name
225: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
226: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
227: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
228: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
229: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
230: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
231: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag

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

224: ,p_name_o =>pqh_tct_shd.g_old_rec.name
225: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
226: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
227: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
228: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
229: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
230: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
231: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
232: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days

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

225: ,p_short_name_o =>pqh_tct_shd.g_old_rec.short_name
226: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
227: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
228: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
229: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
230: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
231: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
232: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
233: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number

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

226: ,p_post_style_cd_o =>pqh_tct_shd.g_old_rec.post_style_cd
227: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
228: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
229: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
230: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
231: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
232: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
233: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
234: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id

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

227: ,p_post_txn_function_o =>pqh_tct_shd.g_old_rec.post_txn_function
228: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
229: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
230: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
231: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
232: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
233: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
234: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
235: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id

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

228: ,p_route_validated_txn_flag_o =>pqh_tct_shd.g_old_rec.route_validated_txn_flag
229: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
230: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
231: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
232: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
233: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
234: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
235: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
236: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd

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

229: ,p_prevent_approver_skip_o =>pqh_tct_shd.g_old_rec.prevent_approver_skip
230: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
231: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
232: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
233: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
234: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
235: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
236: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
237: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id

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

230: ,p_workflow_enable_flag_o =>pqh_tct_shd.g_old_rec.workflow_enable_flag
231: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
232: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
233: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
234: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
235: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
236: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
237: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
238: );

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

231: ,p_enable_flag_o =>pqh_tct_shd.g_old_rec.enable_flag
232: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
233: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
234: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
235: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
236: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
237: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
238: );
239: --

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

232: ,p_timeout_days_o =>pqh_tct_shd.g_old_rec.timeout_days
233: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
234: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
235: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
236: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
237: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
238: );
239: --
240: exception

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

233: ,p_object_version_number_o =>pqh_tct_shd.g_old_rec.object_version_number
234: ,p_consolidated_table_route_i_o =>pqh_tct_shd.g_old_rec.consolidated_table_route_id
235: ,p_business_group_id_o => pqh_tct_shd.g_old_rec.business_group_id
236: ,p_setup_type_cd_o => pqh_tct_shd.g_old_rec.setup_type_cd
237: ,p_master_table_route_i_o =>pqh_tct_shd.g_old_rec.master_table_route_id
238: );
239: --
240: exception
241: --

Line 299: Procedure convert_defs(p_rec in out nocopy pqh_tct_shd.g_rec_type) is

295: -- Internal Row Handler Use Only.
296: --
297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure convert_defs(p_rec in out nocopy pqh_tct_shd.g_rec_type) is
300: --
301: l_proc varchar2(72) := g_package||'convert_defs';
302: --
303: Begin

Line 314: pqh_tct_shd.g_old_rec.custom_wf_process_name;

310: -- is being used then we must set to the 'current' argument value.
311: --
312: If (p_rec.custom_wf_process_name = hr_api.g_varchar2) then
313: p_rec.custom_wf_process_name :=
314: pqh_tct_shd.g_old_rec.custom_wf_process_name;
315: End If;
316: If (p_rec.custom_workflow_name = hr_api.g_varchar2) then
317: p_rec.custom_workflow_name :=
318: pqh_tct_shd.g_old_rec.custom_workflow_name;

Line 318: pqh_tct_shd.g_old_rec.custom_workflow_name;

314: pqh_tct_shd.g_old_rec.custom_wf_process_name;
315: End If;
316: If (p_rec.custom_workflow_name = hr_api.g_varchar2) then
317: p_rec.custom_workflow_name :=
318: pqh_tct_shd.g_old_rec.custom_workflow_name;
319: End If;
320: If (p_rec.form_name = hr_api.g_varchar2) then
321: p_rec.form_name :=
322: pqh_tct_shd.g_old_rec.form_name;

Line 322: pqh_tct_shd.g_old_rec.form_name;

318: pqh_tct_shd.g_old_rec.custom_workflow_name;
319: End If;
320: If (p_rec.form_name = hr_api.g_varchar2) then
321: p_rec.form_name :=
322: pqh_tct_shd.g_old_rec.form_name;
323: End If;
324: If (p_rec.freeze_status_cd = hr_api.g_varchar2) then
325: p_rec.freeze_status_cd :=
326: pqh_tct_shd.g_old_rec.freeze_status_cd;

Line 326: pqh_tct_shd.g_old_rec.freeze_status_cd;

322: pqh_tct_shd.g_old_rec.form_name;
323: End If;
324: If (p_rec.freeze_status_cd = hr_api.g_varchar2) then
325: p_rec.freeze_status_cd :=
326: pqh_tct_shd.g_old_rec.freeze_status_cd;
327: End If;
328: If (p_rec.future_action_cd = hr_api.g_varchar2) then
329: p_rec.future_action_cd :=
330: pqh_tct_shd.g_old_rec.future_action_cd;

Line 330: pqh_tct_shd.g_old_rec.future_action_cd;

326: pqh_tct_shd.g_old_rec.freeze_status_cd;
327: End If;
328: If (p_rec.future_action_cd = hr_api.g_varchar2) then
329: p_rec.future_action_cd :=
330: pqh_tct_shd.g_old_rec.future_action_cd;
331: End If;
332: If (p_rec.member_cd = hr_api.g_varchar2) then
333: p_rec.member_cd :=
334: pqh_tct_shd.g_old_rec.member_cd;

Line 334: pqh_tct_shd.g_old_rec.member_cd;

330: pqh_tct_shd.g_old_rec.future_action_cd;
331: End If;
332: If (p_rec.member_cd = hr_api.g_varchar2) then
333: p_rec.member_cd :=
334: pqh_tct_shd.g_old_rec.member_cd;
335: End If;
336: If (p_rec.name = hr_api.g_varchar2) then
337: p_rec.name :=
338: pqh_tct_shd.g_old_rec.name;

Line 338: pqh_tct_shd.g_old_rec.name;

334: pqh_tct_shd.g_old_rec.member_cd;
335: End If;
336: If (p_rec.name = hr_api.g_varchar2) then
337: p_rec.name :=
338: pqh_tct_shd.g_old_rec.name;
339: End If;
340: If (p_rec.short_name = hr_api.g_varchar2) then
341: p_rec.short_name :=
342: pqh_tct_shd.g_old_rec.short_name;

Line 342: pqh_tct_shd.g_old_rec.short_name;

338: pqh_tct_shd.g_old_rec.name;
339: End If;
340: If (p_rec.short_name = hr_api.g_varchar2) then
341: p_rec.short_name :=
342: pqh_tct_shd.g_old_rec.short_name;
343: End If;
344: If (p_rec.post_style_cd = hr_api.g_varchar2) then
345: p_rec.post_style_cd :=
346: pqh_tct_shd.g_old_rec.post_style_cd;

Line 346: pqh_tct_shd.g_old_rec.post_style_cd;

342: pqh_tct_shd.g_old_rec.short_name;
343: End If;
344: If (p_rec.post_style_cd = hr_api.g_varchar2) then
345: p_rec.post_style_cd :=
346: pqh_tct_shd.g_old_rec.post_style_cd;
347: End If;
348: If (p_rec.post_txn_function = hr_api.g_varchar2) then
349: p_rec.post_txn_function :=
350: pqh_tct_shd.g_old_rec.post_txn_function;

Line 350: pqh_tct_shd.g_old_rec.post_txn_function;

346: pqh_tct_shd.g_old_rec.post_style_cd;
347: End If;
348: If (p_rec.post_txn_function = hr_api.g_varchar2) then
349: p_rec.post_txn_function :=
350: pqh_tct_shd.g_old_rec.post_txn_function;
351: End If;
352: If (p_rec.route_validated_txn_flag = hr_api.g_varchar2) then
353: p_rec.route_validated_txn_flag :=
354: pqh_tct_shd.g_old_rec.route_validated_txn_flag;

Line 354: pqh_tct_shd.g_old_rec.route_validated_txn_flag;

350: pqh_tct_shd.g_old_rec.post_txn_function;
351: End If;
352: If (p_rec.route_validated_txn_flag = hr_api.g_varchar2) then
353: p_rec.route_validated_txn_flag :=
354: pqh_tct_shd.g_old_rec.route_validated_txn_flag;
355: End If;
356: If (p_rec.prevent_approver_skip = hr_api.g_varchar2) then
357: p_rec.prevent_approver_skip :=
358: pqh_tct_shd.g_old_rec.prevent_approver_skip;

Line 358: pqh_tct_shd.g_old_rec.prevent_approver_skip;

354: pqh_tct_shd.g_old_rec.route_validated_txn_flag;
355: End If;
356: If (p_rec.prevent_approver_skip = hr_api.g_varchar2) then
357: p_rec.prevent_approver_skip :=
358: pqh_tct_shd.g_old_rec.prevent_approver_skip;
359: End If;
360: If (p_rec.workflow_enable_flag = hr_api.g_varchar2) then
361: p_rec.workflow_enable_flag :=
362: pqh_tct_shd.g_old_rec.workflow_enable_flag;

Line 362: pqh_tct_shd.g_old_rec.workflow_enable_flag;

358: pqh_tct_shd.g_old_rec.prevent_approver_skip;
359: End If;
360: If (p_rec.workflow_enable_flag = hr_api.g_varchar2) then
361: p_rec.workflow_enable_flag :=
362: pqh_tct_shd.g_old_rec.workflow_enable_flag;
363: End If;
364: If (p_rec.enable_flag = hr_api.g_varchar2) then
365: p_rec.enable_flag :=
366: pqh_tct_shd.g_old_rec.enable_flag;

Line 366: pqh_tct_shd.g_old_rec.enable_flag;

362: pqh_tct_shd.g_old_rec.workflow_enable_flag;
363: End If;
364: If (p_rec.enable_flag = hr_api.g_varchar2) then
365: p_rec.enable_flag :=
366: pqh_tct_shd.g_old_rec.enable_flag;
367: End If;
368: If (p_rec.timeout_days = hr_api.g_number) then
369: p_rec.timeout_days :=
370: pqh_tct_shd.g_old_rec.timeout_days;

Line 370: pqh_tct_shd.g_old_rec.timeout_days;

366: pqh_tct_shd.g_old_rec.enable_flag;
367: End If;
368: If (p_rec.timeout_days = hr_api.g_number) then
369: p_rec.timeout_days :=
370: pqh_tct_shd.g_old_rec.timeout_days;
371: End If;
372: If (p_rec.consolidated_table_route_id = hr_api.g_number) then
373: p_rec.consolidated_table_route_id :=
374: pqh_tct_shd.g_old_rec.consolidated_table_route_id;

Line 374: pqh_tct_shd.g_old_rec.consolidated_table_route_id;

370: pqh_tct_shd.g_old_rec.timeout_days;
371: End If;
372: If (p_rec.consolidated_table_route_id = hr_api.g_number) then
373: p_rec.consolidated_table_route_id :=
374: pqh_tct_shd.g_old_rec.consolidated_table_route_id;
375: End If;
376: If (p_rec.business_group_id = hr_api.g_number) then
377: p_rec.business_group_id :=
378: pqh_tct_shd.g_old_rec.business_group_id;

Line 378: pqh_tct_shd.g_old_rec.business_group_id;

374: pqh_tct_shd.g_old_rec.consolidated_table_route_id;
375: End If;
376: If (p_rec.business_group_id = hr_api.g_number) then
377: p_rec.business_group_id :=
378: pqh_tct_shd.g_old_rec.business_group_id;
379: End If;
380: If (p_rec.setup_type_cd = hr_api.g_varchar2) then
381: p_rec.setup_type_cd :=
382: pqh_tct_shd.g_old_rec.setup_type_cd;

Line 382: pqh_tct_shd.g_old_rec.setup_type_cd;

378: pqh_tct_shd.g_old_rec.business_group_id;
379: End If;
380: If (p_rec.setup_type_cd = hr_api.g_varchar2) then
381: p_rec.setup_type_cd :=
382: pqh_tct_shd.g_old_rec.setup_type_cd;
383: End If;
384: If (p_rec.master_table_route_id = hr_api.g_number) then
385: p_rec.master_table_route_id :=
386: pqh_tct_shd.g_old_rec.master_table_route_id;

Line 386: pqh_tct_shd.g_old_rec.master_table_route_id;

382: pqh_tct_shd.g_old_rec.setup_type_cd;
383: End If;
384: If (p_rec.master_table_route_id = hr_api.g_number) then
385: p_rec.master_table_route_id :=
386: pqh_tct_shd.g_old_rec.master_table_route_id;
387: End If;
388: --
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: --

Line 399: p_rec in out nocopy pqh_tct_shd.g_rec_type

395: -- ----------------------------------------------------------------------------
396: Procedure upd
397: (
398: p_effective_date in date,
399: p_rec in out nocopy pqh_tct_shd.g_rec_type
400: ) is
401: --
402: l_proc varchar2(72) := g_package||'upd';
403: --

Line 409: pqh_tct_shd.lck

405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: -- We must lock the row which we need to update.
408: --
409: pqh_tct_shd.lck
410: (
411: p_rec.transaction_category_id,
412: p_rec.object_version_number
413: );

Line 468: l_rec pqh_tct_shd.g_rec_type;

464: p_setup_type_cd in varchar2 default hr_api.g_varchar2,
465: p_master_table_route_id in number default hr_api.g_number
466: ) is
467: --
468: l_rec pqh_tct_shd.g_rec_type;
469: l_proc varchar2(72) := g_package||'upd';
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);

Line 478: pqh_tct_shd.convert_args

474: -- Call conversion function to turn arguments into the
475: -- l_rec structure.
476: --
477: l_rec :=
478: pqh_tct_shd.convert_args
479: (
480: p_transaction_category_id,
481: p_custom_wf_process_name,
482: p_custom_workflow_name,