APPS.PQH_TCT_UPD dependencies on HR_API

Line 91: When hr_api.check_integrity_violated Then

87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
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

Line 94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 95: When hr_api.parent_integrity_violated Then

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
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then

Line 98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 99: When hr_api.unique_integrity_violated Then

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
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then

Line 102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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;
106: --

Line 242: when hr_api.cannot_find_prog_unit then

238: );
239: --
240: exception
241: --
242: when hr_api.cannot_find_prog_unit then
243: --
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'pqh_transaction_categories'
246: ,p_hook_type => 'AU');

Line 244: hr_api.cannot_find_prog_unit_error

240: exception
241: --
242: when hr_api.cannot_find_prog_unit then
243: --
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'pqh_transaction_categories'
246: ,p_hook_type => 'AU');
247: --
248: end;

Line 312: If (p_rec.custom_wf_process_name = hr_api.g_varchar2) then

308: -- p_rec plsql record structure
309: -- to see if a system default is being used. If a system default
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

Line 316: If (p_rec.custom_workflow_name = hr_api.g_varchar2) then

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;
319: End If;
320: If (p_rec.form_name = hr_api.g_varchar2) then

Line 320: If (p_rec.form_name = hr_api.g_varchar2) then

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;
323: End If;
324: If (p_rec.freeze_status_cd = hr_api.g_varchar2) then

Line 324: If (p_rec.freeze_status_cd = hr_api.g_varchar2) then

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;
327: End If;
328: If (p_rec.future_action_cd = hr_api.g_varchar2) then

Line 328: If (p_rec.future_action_cd = hr_api.g_varchar2) then

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;
331: End If;
332: If (p_rec.member_cd = hr_api.g_varchar2) then

Line 332: If (p_rec.member_cd = hr_api.g_varchar2) then

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;
335: End If;
336: If (p_rec.name = hr_api.g_varchar2) then

Line 336: If (p_rec.name = hr_api.g_varchar2) then

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;
339: End If;
340: If (p_rec.short_name = hr_api.g_varchar2) then

Line 340: If (p_rec.short_name = hr_api.g_varchar2) then

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;
343: End If;
344: If (p_rec.post_style_cd = hr_api.g_varchar2) then

Line 344: If (p_rec.post_style_cd = hr_api.g_varchar2) then

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;
347: End If;
348: If (p_rec.post_txn_function = hr_api.g_varchar2) then

Line 348: If (p_rec.post_txn_function = hr_api.g_varchar2) then

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;
351: End If;
352: If (p_rec.route_validated_txn_flag = hr_api.g_varchar2) then

Line 352: If (p_rec.route_validated_txn_flag = hr_api.g_varchar2) then

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;
355: End If;
356: If (p_rec.prevent_approver_skip = hr_api.g_varchar2) then

Line 356: If (p_rec.prevent_approver_skip = hr_api.g_varchar2) then

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;
359: End If;
360: If (p_rec.workflow_enable_flag = hr_api.g_varchar2) then

Line 360: If (p_rec.workflow_enable_flag = hr_api.g_varchar2) then

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;
363: End If;
364: If (p_rec.enable_flag = hr_api.g_varchar2) then

Line 364: If (p_rec.enable_flag = hr_api.g_varchar2) then

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;
367: End If;
368: If (p_rec.timeout_days = hr_api.g_number) then

Line 368: If (p_rec.timeout_days = hr_api.g_number) then

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;
371: End If;
372: If (p_rec.consolidated_table_route_id = hr_api.g_number) then

Line 372: If (p_rec.consolidated_table_route_id = hr_api.g_number) then

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;
375: End If;
376: If (p_rec.business_group_id = hr_api.g_number) then

Line 376: If (p_rec.business_group_id = hr_api.g_number) then

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;
379: End If;
380: If (p_rec.setup_type_cd = hr_api.g_varchar2) then

Line 380: If (p_rec.setup_type_cd = hr_api.g_varchar2) then

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;
383: End If;
384: If (p_rec.master_table_route_id = hr_api.g_number) then

Line 384: If (p_rec.master_table_route_id = hr_api.g_number) then

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;
387: End If;
388: --

Line 446: p_custom_wf_process_name in varchar2 default hr_api.g_varchar2,

442: Procedure upd
443: (
444: p_effective_date in date,
445: p_transaction_category_id in number,
446: p_custom_wf_process_name in varchar2 default hr_api.g_varchar2,
447: p_custom_workflow_name in varchar2 default hr_api.g_varchar2,
448: p_form_name in varchar2 default hr_api.g_varchar2,
449: p_freeze_status_cd in varchar2 default hr_api.g_varchar2,
450: p_future_action_cd in varchar2 default hr_api.g_varchar2,

Line 447: p_custom_workflow_name in varchar2 default hr_api.g_varchar2,

443: (
444: p_effective_date in date,
445: p_transaction_category_id in number,
446: p_custom_wf_process_name in varchar2 default hr_api.g_varchar2,
447: p_custom_workflow_name in varchar2 default hr_api.g_varchar2,
448: p_form_name in varchar2 default hr_api.g_varchar2,
449: p_freeze_status_cd in varchar2 default hr_api.g_varchar2,
450: p_future_action_cd in varchar2 default hr_api.g_varchar2,
451: p_member_cd in varchar2 default hr_api.g_varchar2,

Line 448: p_form_name in varchar2 default hr_api.g_varchar2,

444: p_effective_date in date,
445: p_transaction_category_id in number,
446: p_custom_wf_process_name in varchar2 default hr_api.g_varchar2,
447: p_custom_workflow_name in varchar2 default hr_api.g_varchar2,
448: p_form_name in varchar2 default hr_api.g_varchar2,
449: p_freeze_status_cd in varchar2 default hr_api.g_varchar2,
450: p_future_action_cd in varchar2 default hr_api.g_varchar2,
451: p_member_cd in varchar2 default hr_api.g_varchar2,
452: p_name in varchar2 default hr_api.g_varchar2,

Line 449: p_freeze_status_cd in varchar2 default hr_api.g_varchar2,

445: p_transaction_category_id in number,
446: p_custom_wf_process_name in varchar2 default hr_api.g_varchar2,
447: p_custom_workflow_name in varchar2 default hr_api.g_varchar2,
448: p_form_name in varchar2 default hr_api.g_varchar2,
449: p_freeze_status_cd in varchar2 default hr_api.g_varchar2,
450: p_future_action_cd in varchar2 default hr_api.g_varchar2,
451: p_member_cd in varchar2 default hr_api.g_varchar2,
452: p_name in varchar2 default hr_api.g_varchar2,
453: p_short_name in varchar2 default hr_api.g_varchar2,

Line 450: p_future_action_cd in varchar2 default hr_api.g_varchar2,

446: p_custom_wf_process_name in varchar2 default hr_api.g_varchar2,
447: p_custom_workflow_name in varchar2 default hr_api.g_varchar2,
448: p_form_name in varchar2 default hr_api.g_varchar2,
449: p_freeze_status_cd in varchar2 default hr_api.g_varchar2,
450: p_future_action_cd in varchar2 default hr_api.g_varchar2,
451: p_member_cd in varchar2 default hr_api.g_varchar2,
452: p_name in varchar2 default hr_api.g_varchar2,
453: p_short_name in varchar2 default hr_api.g_varchar2,
454: p_post_style_cd in varchar2 default hr_api.g_varchar2,

Line 451: p_member_cd in varchar2 default hr_api.g_varchar2,

447: p_custom_workflow_name in varchar2 default hr_api.g_varchar2,
448: p_form_name in varchar2 default hr_api.g_varchar2,
449: p_freeze_status_cd in varchar2 default hr_api.g_varchar2,
450: p_future_action_cd in varchar2 default hr_api.g_varchar2,
451: p_member_cd in varchar2 default hr_api.g_varchar2,
452: p_name in varchar2 default hr_api.g_varchar2,
453: p_short_name in varchar2 default hr_api.g_varchar2,
454: p_post_style_cd in varchar2 default hr_api.g_varchar2,
455: p_post_txn_function in varchar2 default hr_api.g_varchar2,

Line 452: p_name in varchar2 default hr_api.g_varchar2,

448: p_form_name in varchar2 default hr_api.g_varchar2,
449: p_freeze_status_cd in varchar2 default hr_api.g_varchar2,
450: p_future_action_cd in varchar2 default hr_api.g_varchar2,
451: p_member_cd in varchar2 default hr_api.g_varchar2,
452: p_name in varchar2 default hr_api.g_varchar2,
453: p_short_name in varchar2 default hr_api.g_varchar2,
454: p_post_style_cd in varchar2 default hr_api.g_varchar2,
455: p_post_txn_function in varchar2 default hr_api.g_varchar2,
456: p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2,

Line 453: p_short_name in varchar2 default hr_api.g_varchar2,

449: p_freeze_status_cd in varchar2 default hr_api.g_varchar2,
450: p_future_action_cd in varchar2 default hr_api.g_varchar2,
451: p_member_cd in varchar2 default hr_api.g_varchar2,
452: p_name in varchar2 default hr_api.g_varchar2,
453: p_short_name in varchar2 default hr_api.g_varchar2,
454: p_post_style_cd in varchar2 default hr_api.g_varchar2,
455: p_post_txn_function in varchar2 default hr_api.g_varchar2,
456: p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2,
457: p_prevent_approver_skip in varchar2 default hr_api.g_varchar2,

Line 454: p_post_style_cd in varchar2 default hr_api.g_varchar2,

450: p_future_action_cd in varchar2 default hr_api.g_varchar2,
451: p_member_cd in varchar2 default hr_api.g_varchar2,
452: p_name in varchar2 default hr_api.g_varchar2,
453: p_short_name in varchar2 default hr_api.g_varchar2,
454: p_post_style_cd in varchar2 default hr_api.g_varchar2,
455: p_post_txn_function in varchar2 default hr_api.g_varchar2,
456: p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2,
457: p_prevent_approver_skip in varchar2 default hr_api.g_varchar2,
458: p_workflow_enable_flag in varchar2 default hr_api.g_varchar2,

Line 455: p_post_txn_function in varchar2 default hr_api.g_varchar2,

451: p_member_cd in varchar2 default hr_api.g_varchar2,
452: p_name in varchar2 default hr_api.g_varchar2,
453: p_short_name in varchar2 default hr_api.g_varchar2,
454: p_post_style_cd in varchar2 default hr_api.g_varchar2,
455: p_post_txn_function in varchar2 default hr_api.g_varchar2,
456: p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2,
457: p_prevent_approver_skip in varchar2 default hr_api.g_varchar2,
458: p_workflow_enable_flag in varchar2 default hr_api.g_varchar2,
459: p_enable_flag in varchar2 default hr_api.g_varchar2,

Line 456: p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2,

452: p_name in varchar2 default hr_api.g_varchar2,
453: p_short_name in varchar2 default hr_api.g_varchar2,
454: p_post_style_cd in varchar2 default hr_api.g_varchar2,
455: p_post_txn_function in varchar2 default hr_api.g_varchar2,
456: p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2,
457: p_prevent_approver_skip in varchar2 default hr_api.g_varchar2,
458: p_workflow_enable_flag in varchar2 default hr_api.g_varchar2,
459: p_enable_flag in varchar2 default hr_api.g_varchar2,
460: p_timeout_days in number default hr_api.g_number,

Line 457: p_prevent_approver_skip in varchar2 default hr_api.g_varchar2,

453: p_short_name in varchar2 default hr_api.g_varchar2,
454: p_post_style_cd in varchar2 default hr_api.g_varchar2,
455: p_post_txn_function in varchar2 default hr_api.g_varchar2,
456: p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2,
457: p_prevent_approver_skip in varchar2 default hr_api.g_varchar2,
458: p_workflow_enable_flag in varchar2 default hr_api.g_varchar2,
459: p_enable_flag in varchar2 default hr_api.g_varchar2,
460: p_timeout_days in number default hr_api.g_number,
461: p_object_version_number in out nocopy number,

Line 458: p_workflow_enable_flag in varchar2 default hr_api.g_varchar2,

454: p_post_style_cd in varchar2 default hr_api.g_varchar2,
455: p_post_txn_function in varchar2 default hr_api.g_varchar2,
456: p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2,
457: p_prevent_approver_skip in varchar2 default hr_api.g_varchar2,
458: p_workflow_enable_flag in varchar2 default hr_api.g_varchar2,
459: p_enable_flag in varchar2 default hr_api.g_varchar2,
460: p_timeout_days in number default hr_api.g_number,
461: p_object_version_number in out nocopy number,
462: p_consolidated_table_route_id in number default hr_api.g_number ,

Line 459: p_enable_flag in varchar2 default hr_api.g_varchar2,

455: p_post_txn_function in varchar2 default hr_api.g_varchar2,
456: p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2,
457: p_prevent_approver_skip in varchar2 default hr_api.g_varchar2,
458: p_workflow_enable_flag in varchar2 default hr_api.g_varchar2,
459: p_enable_flag in varchar2 default hr_api.g_varchar2,
460: p_timeout_days in number default hr_api.g_number,
461: p_object_version_number in out nocopy number,
462: p_consolidated_table_route_id in number default hr_api.g_number ,
463: p_business_group_id in number default hr_api.g_number ,

Line 460: p_timeout_days in number default hr_api.g_number,

456: p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2,
457: p_prevent_approver_skip in varchar2 default hr_api.g_varchar2,
458: p_workflow_enable_flag in varchar2 default hr_api.g_varchar2,
459: p_enable_flag in varchar2 default hr_api.g_varchar2,
460: p_timeout_days in number default hr_api.g_number,
461: p_object_version_number in out nocopy number,
462: p_consolidated_table_route_id in number default hr_api.g_number ,
463: p_business_group_id in number default hr_api.g_number ,
464: p_setup_type_cd in varchar2 default hr_api.g_varchar2,

Line 462: p_consolidated_table_route_id in number default hr_api.g_number ,

458: p_workflow_enable_flag in varchar2 default hr_api.g_varchar2,
459: p_enable_flag in varchar2 default hr_api.g_varchar2,
460: p_timeout_days in number default hr_api.g_number,
461: p_object_version_number in out nocopy number,
462: p_consolidated_table_route_id in number default hr_api.g_number ,
463: p_business_group_id in number default hr_api.g_number ,
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

Line 463: p_business_group_id in number default hr_api.g_number ,

459: p_enable_flag in varchar2 default hr_api.g_varchar2,
460: p_timeout_days in number default hr_api.g_number,
461: p_object_version_number in out nocopy number,
462: p_consolidated_table_route_id in number default hr_api.g_number ,
463: p_business_group_id in number default hr_api.g_number ,
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: --

Line 464: p_setup_type_cd in varchar2 default hr_api.g_varchar2,

460: p_timeout_days in number default hr_api.g_number,
461: p_object_version_number in out nocopy number,
462: p_consolidated_table_route_id in number default hr_api.g_number ,
463: p_business_group_id in number default hr_api.g_number ,
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;

Line 465: p_master_table_route_id in number default hr_api.g_number

461: p_object_version_number in out nocopy number,
462: p_consolidated_table_route_id in number default hr_api.g_number ,
463: p_business_group_id in number default hr_api.g_number ,
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';