APPS.PQH_RHT_UPD dependencies on HR_API

Line 93: When hr_api.check_integrity_violated Then

89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: --
92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: pqh_rht_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then

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

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

Line 97: When hr_api.parent_integrity_violated Then

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

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

96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: pqh_rht_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: pqh_rht_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 101: When hr_api.unique_integrity_violated Then

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

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

100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: pqh_rht_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: Raise;
107: End update_dml;
108: --

Line 248: when hr_api.cannot_find_prog_unit then

244: );
245: --
246: exception
247: --
248: when hr_api.cannot_find_prog_unit then
249: --
250: hr_api.cannot_find_prog_unit_error
251: (p_module_name => 'pqh_routing_history'
252: ,p_hook_type => 'AU');

Line 250: hr_api.cannot_find_prog_unit_error

246: exception
247: --
248: when hr_api.cannot_find_prog_unit then
249: --
250: hr_api.cannot_find_prog_unit_error
251: (p_module_name => 'pqh_routing_history'
252: ,p_hook_type => 'AU');
253: --
254: end;

Line 318: If (p_rec.approval_cd = hr_api.g_varchar2) then

314: -- p_rec plsql record structure
315: -- to see if a system default is being used. If a system default
316: -- is being used then we must set to the 'current' argument value.
317: --
318: If (p_rec.approval_cd = hr_api.g_varchar2) then
319: p_rec.approval_cd :=
320: pqh_rht_shd.g_old_rec.approval_cd;
321: End If;
322: If (p_rec.comments = hr_api.g_varchar2) then

Line 322: If (p_rec.comments = hr_api.g_varchar2) then

318: If (p_rec.approval_cd = hr_api.g_varchar2) then
319: p_rec.approval_cd :=
320: pqh_rht_shd.g_old_rec.approval_cd;
321: End If;
322: If (p_rec.comments = hr_api.g_varchar2) then
323: p_rec.comments :=
324: pqh_rht_shd.g_old_rec.comments;
325: End If;
326: If (p_rec.forwarded_by_assignment_id = hr_api.g_number) then

Line 326: If (p_rec.forwarded_by_assignment_id = hr_api.g_number) then

322: If (p_rec.comments = hr_api.g_varchar2) then
323: p_rec.comments :=
324: pqh_rht_shd.g_old_rec.comments;
325: End If;
326: If (p_rec.forwarded_by_assignment_id = hr_api.g_number) then
327: p_rec.forwarded_by_assignment_id :=
328: pqh_rht_shd.g_old_rec.forwarded_by_assignment_id;
329: End If;
330: If (p_rec.forwarded_by_member_id = hr_api.g_number) then

Line 330: If (p_rec.forwarded_by_member_id = hr_api.g_number) then

326: If (p_rec.forwarded_by_assignment_id = hr_api.g_number) then
327: p_rec.forwarded_by_assignment_id :=
328: pqh_rht_shd.g_old_rec.forwarded_by_assignment_id;
329: End If;
330: If (p_rec.forwarded_by_member_id = hr_api.g_number) then
331: p_rec.forwarded_by_member_id :=
332: pqh_rht_shd.g_old_rec.forwarded_by_member_id;
333: End If;
334: If (p_rec.forwarded_by_position_id = hr_api.g_number) then

Line 334: If (p_rec.forwarded_by_position_id = hr_api.g_number) then

330: If (p_rec.forwarded_by_member_id = hr_api.g_number) then
331: p_rec.forwarded_by_member_id :=
332: pqh_rht_shd.g_old_rec.forwarded_by_member_id;
333: End If;
334: If (p_rec.forwarded_by_position_id = hr_api.g_number) then
335: p_rec.forwarded_by_position_id :=
336: pqh_rht_shd.g_old_rec.forwarded_by_position_id;
337: End If;
338: If (p_rec.forwarded_by_user_id = hr_api.g_number) then

Line 338: If (p_rec.forwarded_by_user_id = hr_api.g_number) then

334: If (p_rec.forwarded_by_position_id = hr_api.g_number) then
335: p_rec.forwarded_by_position_id :=
336: pqh_rht_shd.g_old_rec.forwarded_by_position_id;
337: End If;
338: If (p_rec.forwarded_by_user_id = hr_api.g_number) then
339: p_rec.forwarded_by_user_id :=
340: pqh_rht_shd.g_old_rec.forwarded_by_user_id;
341: End If;
342: If (p_rec.forwarded_by_role_id = hr_api.g_number) then

Line 342: If (p_rec.forwarded_by_role_id = hr_api.g_number) then

338: If (p_rec.forwarded_by_user_id = hr_api.g_number) then
339: p_rec.forwarded_by_user_id :=
340: pqh_rht_shd.g_old_rec.forwarded_by_user_id;
341: End If;
342: If (p_rec.forwarded_by_role_id = hr_api.g_number) then
343: p_rec.forwarded_by_role_id :=
344: pqh_rht_shd.g_old_rec.forwarded_by_role_id;
345: End If;
346: If (p_rec.forwarded_to_assignment_id = hr_api.g_number) then

Line 346: If (p_rec.forwarded_to_assignment_id = hr_api.g_number) then

342: If (p_rec.forwarded_by_role_id = hr_api.g_number) then
343: p_rec.forwarded_by_role_id :=
344: pqh_rht_shd.g_old_rec.forwarded_by_role_id;
345: End If;
346: If (p_rec.forwarded_to_assignment_id = hr_api.g_number) then
347: p_rec.forwarded_to_assignment_id :=
348: pqh_rht_shd.g_old_rec.forwarded_to_assignment_id;
349: End If;
350: If (p_rec.forwarded_to_member_id = hr_api.g_number) then

Line 350: If (p_rec.forwarded_to_member_id = hr_api.g_number) then

346: If (p_rec.forwarded_to_assignment_id = hr_api.g_number) then
347: p_rec.forwarded_to_assignment_id :=
348: pqh_rht_shd.g_old_rec.forwarded_to_assignment_id;
349: End If;
350: If (p_rec.forwarded_to_member_id = hr_api.g_number) then
351: p_rec.forwarded_to_member_id :=
352: pqh_rht_shd.g_old_rec.forwarded_to_member_id;
353: End If;
354: If (p_rec.forwarded_to_position_id = hr_api.g_number) then

Line 354: If (p_rec.forwarded_to_position_id = hr_api.g_number) then

350: If (p_rec.forwarded_to_member_id = hr_api.g_number) then
351: p_rec.forwarded_to_member_id :=
352: pqh_rht_shd.g_old_rec.forwarded_to_member_id;
353: End If;
354: If (p_rec.forwarded_to_position_id = hr_api.g_number) then
355: p_rec.forwarded_to_position_id :=
356: pqh_rht_shd.g_old_rec.forwarded_to_position_id;
357: End If;
358: If (p_rec.forwarded_to_user_id = hr_api.g_number) then

Line 358: If (p_rec.forwarded_to_user_id = hr_api.g_number) then

354: If (p_rec.forwarded_to_position_id = hr_api.g_number) then
355: p_rec.forwarded_to_position_id :=
356: pqh_rht_shd.g_old_rec.forwarded_to_position_id;
357: End If;
358: If (p_rec.forwarded_to_user_id = hr_api.g_number) then
359: p_rec.forwarded_to_user_id :=
360: pqh_rht_shd.g_old_rec.forwarded_to_user_id;
361: End If;
362: If (p_rec.forwarded_to_role_id = hr_api.g_number) then

Line 362: If (p_rec.forwarded_to_role_id = hr_api.g_number) then

358: If (p_rec.forwarded_to_user_id = hr_api.g_number) then
359: p_rec.forwarded_to_user_id :=
360: pqh_rht_shd.g_old_rec.forwarded_to_user_id;
361: End If;
362: If (p_rec.forwarded_to_role_id = hr_api.g_number) then
363: p_rec.forwarded_to_role_id :=
364: pqh_rht_shd.g_old_rec.forwarded_to_role_id;
365: End If;
366: If (p_rec.notification_date = hr_api.g_date) then

Line 366: If (p_rec.notification_date = hr_api.g_date) then

362: If (p_rec.forwarded_to_role_id = hr_api.g_number) then
363: p_rec.forwarded_to_role_id :=
364: pqh_rht_shd.g_old_rec.forwarded_to_role_id;
365: End If;
366: If (p_rec.notification_date = hr_api.g_date) then
367: p_rec.notification_date :=
368: pqh_rht_shd.g_old_rec.notification_date;
369: End If;
370: If (p_rec.pos_structure_version_id = hr_api.g_number) then

Line 370: If (p_rec.pos_structure_version_id = hr_api.g_number) then

366: If (p_rec.notification_date = hr_api.g_date) then
367: p_rec.notification_date :=
368: pqh_rht_shd.g_old_rec.notification_date;
369: End If;
370: If (p_rec.pos_structure_version_id = hr_api.g_number) then
371: p_rec.pos_structure_version_id :=
372: pqh_rht_shd.g_old_rec.pos_structure_version_id;
373: End If;
374: If (p_rec.routing_category_id = hr_api.g_number) then

Line 374: If (p_rec.routing_category_id = hr_api.g_number) then

370: If (p_rec.pos_structure_version_id = hr_api.g_number) then
371: p_rec.pos_structure_version_id :=
372: pqh_rht_shd.g_old_rec.pos_structure_version_id;
373: End If;
374: If (p_rec.routing_category_id = hr_api.g_number) then
375: p_rec.routing_category_id :=
376: pqh_rht_shd.g_old_rec.routing_category_id;
377: End If;
378: If (p_rec.transaction_category_id = hr_api.g_number) then

Line 378: If (p_rec.transaction_category_id = hr_api.g_number) then

374: If (p_rec.routing_category_id = hr_api.g_number) then
375: p_rec.routing_category_id :=
376: pqh_rht_shd.g_old_rec.routing_category_id;
377: End If;
378: If (p_rec.transaction_category_id = hr_api.g_number) then
379: p_rec.transaction_category_id :=
380: pqh_rht_shd.g_old_rec.transaction_category_id;
381: End If;
382: If (p_rec.transaction_id = hr_api.g_number) then

Line 382: If (p_rec.transaction_id = hr_api.g_number) then

378: If (p_rec.transaction_category_id = hr_api.g_number) then
379: p_rec.transaction_category_id :=
380: pqh_rht_shd.g_old_rec.transaction_category_id;
381: End If;
382: If (p_rec.transaction_id = hr_api.g_number) then
383: p_rec.transaction_id :=
384: pqh_rht_shd.g_old_rec.transaction_id;
385: End If;
386: If (p_rec.user_action_cd = hr_api.g_varchar2) then

Line 386: If (p_rec.user_action_cd = hr_api.g_varchar2) then

382: If (p_rec.transaction_id = hr_api.g_number) then
383: p_rec.transaction_id :=
384: pqh_rht_shd.g_old_rec.transaction_id;
385: End If;
386: If (p_rec.user_action_cd = hr_api.g_varchar2) then
387: p_rec.user_action_cd :=
388: pqh_rht_shd.g_old_rec.user_action_cd;
389: End If;
390: If (p_rec.from_range_name = hr_api.g_varchar2) then

Line 390: If (p_rec.from_range_name = hr_api.g_varchar2) then

386: If (p_rec.user_action_cd = hr_api.g_varchar2) then
387: p_rec.user_action_cd :=
388: pqh_rht_shd.g_old_rec.user_action_cd;
389: End If;
390: If (p_rec.from_range_name = hr_api.g_varchar2) then
391: p_rec.from_range_name :=
392: pqh_rht_shd.g_old_rec.from_range_name;
393: End If;
394: If (p_rec.to_range_name = hr_api.g_varchar2) then

Line 394: If (p_rec.to_range_name = hr_api.g_varchar2) then

390: If (p_rec.from_range_name = hr_api.g_varchar2) then
391: p_rec.from_range_name :=
392: pqh_rht_shd.g_old_rec.from_range_name;
393: End If;
394: If (p_rec.to_range_name = hr_api.g_varchar2) then
395: p_rec.to_range_name :=
396: pqh_rht_shd.g_old_rec.to_range_name;
397: End If;
398: If (p_rec.list_range_name = hr_api.g_varchar2) then

Line 398: If (p_rec.list_range_name = hr_api.g_varchar2) then

394: If (p_rec.to_range_name = hr_api.g_varchar2) then
395: p_rec.to_range_name :=
396: pqh_rht_shd.g_old_rec.to_range_name;
397: End If;
398: If (p_rec.list_range_name = hr_api.g_varchar2) then
399: p_rec.list_range_name :=
400: pqh_rht_shd.g_old_rec.list_range_name;
401: End If;
402:

Line 461: p_approval_cd in varchar2 default hr_api.g_varchar2,

457: Procedure upd
458: (
459: p_effective_date in date,
460: p_routing_history_id in number,
461: p_approval_cd in varchar2 default hr_api.g_varchar2,
462: p_comments in varchar2 default hr_api.g_varchar2,
463: p_forwarded_by_assignment_id in number default hr_api.g_number,
464: p_forwarded_by_member_id in number default hr_api.g_number,
465: p_forwarded_by_position_id in number default hr_api.g_number,

Line 462: p_comments in varchar2 default hr_api.g_varchar2,

458: (
459: p_effective_date in date,
460: p_routing_history_id in number,
461: p_approval_cd in varchar2 default hr_api.g_varchar2,
462: p_comments in varchar2 default hr_api.g_varchar2,
463: p_forwarded_by_assignment_id in number default hr_api.g_number,
464: p_forwarded_by_member_id in number default hr_api.g_number,
465: p_forwarded_by_position_id in number default hr_api.g_number,
466: p_forwarded_by_user_id in number default hr_api.g_number,

Line 463: p_forwarded_by_assignment_id in number default hr_api.g_number,

459: p_effective_date in date,
460: p_routing_history_id in number,
461: p_approval_cd in varchar2 default hr_api.g_varchar2,
462: p_comments in varchar2 default hr_api.g_varchar2,
463: p_forwarded_by_assignment_id in number default hr_api.g_number,
464: p_forwarded_by_member_id in number default hr_api.g_number,
465: p_forwarded_by_position_id in number default hr_api.g_number,
466: p_forwarded_by_user_id in number default hr_api.g_number,
467: p_forwarded_by_role_id in number default hr_api.g_number,

Line 464: p_forwarded_by_member_id in number default hr_api.g_number,

460: p_routing_history_id in number,
461: p_approval_cd in varchar2 default hr_api.g_varchar2,
462: p_comments in varchar2 default hr_api.g_varchar2,
463: p_forwarded_by_assignment_id in number default hr_api.g_number,
464: p_forwarded_by_member_id in number default hr_api.g_number,
465: p_forwarded_by_position_id in number default hr_api.g_number,
466: p_forwarded_by_user_id in number default hr_api.g_number,
467: p_forwarded_by_role_id in number default hr_api.g_number,
468: p_forwarded_to_assignment_id in number default hr_api.g_number,

Line 465: p_forwarded_by_position_id in number default hr_api.g_number,

461: p_approval_cd in varchar2 default hr_api.g_varchar2,
462: p_comments in varchar2 default hr_api.g_varchar2,
463: p_forwarded_by_assignment_id in number default hr_api.g_number,
464: p_forwarded_by_member_id in number default hr_api.g_number,
465: p_forwarded_by_position_id in number default hr_api.g_number,
466: p_forwarded_by_user_id in number default hr_api.g_number,
467: p_forwarded_by_role_id in number default hr_api.g_number,
468: p_forwarded_to_assignment_id in number default hr_api.g_number,
469: p_forwarded_to_member_id in number default hr_api.g_number,

Line 466: p_forwarded_by_user_id in number default hr_api.g_number,

462: p_comments in varchar2 default hr_api.g_varchar2,
463: p_forwarded_by_assignment_id in number default hr_api.g_number,
464: p_forwarded_by_member_id in number default hr_api.g_number,
465: p_forwarded_by_position_id in number default hr_api.g_number,
466: p_forwarded_by_user_id in number default hr_api.g_number,
467: p_forwarded_by_role_id in number default hr_api.g_number,
468: p_forwarded_to_assignment_id in number default hr_api.g_number,
469: p_forwarded_to_member_id in number default hr_api.g_number,
470: p_forwarded_to_position_id in number default hr_api.g_number,

Line 467: p_forwarded_by_role_id in number default hr_api.g_number,

463: p_forwarded_by_assignment_id in number default hr_api.g_number,
464: p_forwarded_by_member_id in number default hr_api.g_number,
465: p_forwarded_by_position_id in number default hr_api.g_number,
466: p_forwarded_by_user_id in number default hr_api.g_number,
467: p_forwarded_by_role_id in number default hr_api.g_number,
468: p_forwarded_to_assignment_id in number default hr_api.g_number,
469: p_forwarded_to_member_id in number default hr_api.g_number,
470: p_forwarded_to_position_id in number default hr_api.g_number,
471: p_forwarded_to_user_id in number default hr_api.g_number,

Line 468: p_forwarded_to_assignment_id in number default hr_api.g_number,

464: p_forwarded_by_member_id in number default hr_api.g_number,
465: p_forwarded_by_position_id in number default hr_api.g_number,
466: p_forwarded_by_user_id in number default hr_api.g_number,
467: p_forwarded_by_role_id in number default hr_api.g_number,
468: p_forwarded_to_assignment_id in number default hr_api.g_number,
469: p_forwarded_to_member_id in number default hr_api.g_number,
470: p_forwarded_to_position_id in number default hr_api.g_number,
471: p_forwarded_to_user_id in number default hr_api.g_number,
472: p_forwarded_to_role_id in number default hr_api.g_number,

Line 469: p_forwarded_to_member_id in number default hr_api.g_number,

465: p_forwarded_by_position_id in number default hr_api.g_number,
466: p_forwarded_by_user_id in number default hr_api.g_number,
467: p_forwarded_by_role_id in number default hr_api.g_number,
468: p_forwarded_to_assignment_id in number default hr_api.g_number,
469: p_forwarded_to_member_id in number default hr_api.g_number,
470: p_forwarded_to_position_id in number default hr_api.g_number,
471: p_forwarded_to_user_id in number default hr_api.g_number,
472: p_forwarded_to_role_id in number default hr_api.g_number,
473: p_notification_date in date default hr_api.g_date,

Line 470: p_forwarded_to_position_id in number default hr_api.g_number,

466: p_forwarded_by_user_id in number default hr_api.g_number,
467: p_forwarded_by_role_id in number default hr_api.g_number,
468: p_forwarded_to_assignment_id in number default hr_api.g_number,
469: p_forwarded_to_member_id in number default hr_api.g_number,
470: p_forwarded_to_position_id in number default hr_api.g_number,
471: p_forwarded_to_user_id in number default hr_api.g_number,
472: p_forwarded_to_role_id in number default hr_api.g_number,
473: p_notification_date in date default hr_api.g_date,
474: p_pos_structure_version_id in number default hr_api.g_number,

Line 471: p_forwarded_to_user_id in number default hr_api.g_number,

467: p_forwarded_by_role_id in number default hr_api.g_number,
468: p_forwarded_to_assignment_id in number default hr_api.g_number,
469: p_forwarded_to_member_id in number default hr_api.g_number,
470: p_forwarded_to_position_id in number default hr_api.g_number,
471: p_forwarded_to_user_id in number default hr_api.g_number,
472: p_forwarded_to_role_id in number default hr_api.g_number,
473: p_notification_date in date default hr_api.g_date,
474: p_pos_structure_version_id in number default hr_api.g_number,
475: p_routing_category_id in number default hr_api.g_number,

Line 472: p_forwarded_to_role_id in number default hr_api.g_number,

468: p_forwarded_to_assignment_id in number default hr_api.g_number,
469: p_forwarded_to_member_id in number default hr_api.g_number,
470: p_forwarded_to_position_id in number default hr_api.g_number,
471: p_forwarded_to_user_id in number default hr_api.g_number,
472: p_forwarded_to_role_id in number default hr_api.g_number,
473: p_notification_date in date default hr_api.g_date,
474: p_pos_structure_version_id in number default hr_api.g_number,
475: p_routing_category_id in number default hr_api.g_number,
476: p_transaction_category_id in number default hr_api.g_number,

Line 473: p_notification_date in date default hr_api.g_date,

469: p_forwarded_to_member_id in number default hr_api.g_number,
470: p_forwarded_to_position_id in number default hr_api.g_number,
471: p_forwarded_to_user_id in number default hr_api.g_number,
472: p_forwarded_to_role_id in number default hr_api.g_number,
473: p_notification_date in date default hr_api.g_date,
474: p_pos_structure_version_id in number default hr_api.g_number,
475: p_routing_category_id in number default hr_api.g_number,
476: p_transaction_category_id in number default hr_api.g_number,
477: p_transaction_id in number default hr_api.g_number,

Line 474: p_pos_structure_version_id in number default hr_api.g_number,

470: p_forwarded_to_position_id in number default hr_api.g_number,
471: p_forwarded_to_user_id in number default hr_api.g_number,
472: p_forwarded_to_role_id in number default hr_api.g_number,
473: p_notification_date in date default hr_api.g_date,
474: p_pos_structure_version_id in number default hr_api.g_number,
475: p_routing_category_id in number default hr_api.g_number,
476: p_transaction_category_id in number default hr_api.g_number,
477: p_transaction_id in number default hr_api.g_number,
478: p_user_action_cd in varchar2 default hr_api.g_varchar2,

Line 475: p_routing_category_id in number default hr_api.g_number,

471: p_forwarded_to_user_id in number default hr_api.g_number,
472: p_forwarded_to_role_id in number default hr_api.g_number,
473: p_notification_date in date default hr_api.g_date,
474: p_pos_structure_version_id in number default hr_api.g_number,
475: p_routing_category_id in number default hr_api.g_number,
476: p_transaction_category_id in number default hr_api.g_number,
477: p_transaction_id in number default hr_api.g_number,
478: p_user_action_cd in varchar2 default hr_api.g_varchar2,
479: p_from_range_name in varchar2 default hr_api.g_varchar2,

Line 476: p_transaction_category_id in number default hr_api.g_number,

472: p_forwarded_to_role_id in number default hr_api.g_number,
473: p_notification_date in date default hr_api.g_date,
474: p_pos_structure_version_id in number default hr_api.g_number,
475: p_routing_category_id in number default hr_api.g_number,
476: p_transaction_category_id in number default hr_api.g_number,
477: p_transaction_id in number default hr_api.g_number,
478: p_user_action_cd in varchar2 default hr_api.g_varchar2,
479: p_from_range_name in varchar2 default hr_api.g_varchar2,
480: p_to_range_name in varchar2 default hr_api.g_varchar2,

Line 477: p_transaction_id in number default hr_api.g_number,

473: p_notification_date in date default hr_api.g_date,
474: p_pos_structure_version_id in number default hr_api.g_number,
475: p_routing_category_id in number default hr_api.g_number,
476: p_transaction_category_id in number default hr_api.g_number,
477: p_transaction_id in number default hr_api.g_number,
478: p_user_action_cd in varchar2 default hr_api.g_varchar2,
479: p_from_range_name in varchar2 default hr_api.g_varchar2,
480: p_to_range_name in varchar2 default hr_api.g_varchar2,
481: p_list_range_name in varchar2 default hr_api.g_varchar2,

Line 478: p_user_action_cd in varchar2 default hr_api.g_varchar2,

474: p_pos_structure_version_id in number default hr_api.g_number,
475: p_routing_category_id in number default hr_api.g_number,
476: p_transaction_category_id in number default hr_api.g_number,
477: p_transaction_id in number default hr_api.g_number,
478: p_user_action_cd in varchar2 default hr_api.g_varchar2,
479: p_from_range_name in varchar2 default hr_api.g_varchar2,
480: p_to_range_name in varchar2 default hr_api.g_varchar2,
481: p_list_range_name in varchar2 default hr_api.g_varchar2,
482: p_object_version_number in out nocopy number

Line 479: p_from_range_name in varchar2 default hr_api.g_varchar2,

475: p_routing_category_id in number default hr_api.g_number,
476: p_transaction_category_id in number default hr_api.g_number,
477: p_transaction_id in number default hr_api.g_number,
478: p_user_action_cd in varchar2 default hr_api.g_varchar2,
479: p_from_range_name in varchar2 default hr_api.g_varchar2,
480: p_to_range_name in varchar2 default hr_api.g_varchar2,
481: p_list_range_name in varchar2 default hr_api.g_varchar2,
482: p_object_version_number in out nocopy number
483: ) is

Line 480: p_to_range_name in varchar2 default hr_api.g_varchar2,

476: p_transaction_category_id in number default hr_api.g_number,
477: p_transaction_id in number default hr_api.g_number,
478: p_user_action_cd in varchar2 default hr_api.g_varchar2,
479: p_from_range_name in varchar2 default hr_api.g_varchar2,
480: p_to_range_name in varchar2 default hr_api.g_varchar2,
481: p_list_range_name in varchar2 default hr_api.g_varchar2,
482: p_object_version_number in out nocopy number
483: ) is
484: --

Line 481: p_list_range_name in varchar2 default hr_api.g_varchar2,

477: p_transaction_id in number default hr_api.g_number,
478: p_user_action_cd in varchar2 default hr_api.g_varchar2,
479: p_from_range_name in varchar2 default hr_api.g_varchar2,
480: p_to_range_name in varchar2 default hr_api.g_varchar2,
481: p_list_range_name in varchar2 default hr_api.g_varchar2,
482: p_object_version_number in out nocopy number
483: ) is
484: --
485: l_rec pqh_rht_shd.g_rec_type;