DBA Data[Home] [Help]

APPS.GHR_API dependencies on GHR_PA_REQUESTS

Line 466: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type

462: ,basic_pay number
463: ,locality_adj number
464: ,adj_basic_pay number
465: ,other_pay number
466: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type
467: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
468: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
469: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
470: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type

Line 467: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type

463: ,locality_adj number
464: ,adj_basic_pay number
465: ,other_pay number
466: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type
467: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
468: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
469: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
470: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
471: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type

Line 468: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type

464: ,adj_basic_pay number
465: ,other_pay number
466: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type
467: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
468: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
469: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
470: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
471: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
472: ,position_id per_all_positions.position_id%type

Line 469: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type

465: ,other_pay number
466: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type
467: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
468: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
469: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
470: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
471: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
472: ,position_id per_all_positions.position_id%type
473: ,duty_station_location_id hr_locations.location_id%type

Line 470: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type

466: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type
467: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
468: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
469: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
470: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
471: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
472: ,position_id per_all_positions.position_id%type
473: ,duty_station_location_id hr_locations.location_id%type
474: , work_schedule ghr_pa_requests.work_schedule%type

Line 471: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type

467: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
468: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
469: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
470: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
471: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
472: ,position_id per_all_positions.position_id%type
473: ,duty_station_location_id hr_locations.location_id%type
474: , work_schedule ghr_pa_requests.work_schedule%type
475: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type);

Line 474: , work_schedule ghr_pa_requests.work_schedule%type

470: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
471: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
472: ,position_id per_all_positions.position_id%type
473: ,duty_station_location_id hr_locations.location_id%type
474: , work_schedule ghr_pa_requests.work_schedule%type
475: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type);
476: --
477: type recruitment_bonus_type is record
478: (p_recruitment_bonus_flag varchar2(1)

Line 1496: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,

1492:
1493: ------------------------------------------------------------------------------
1494:
1495: Procedure call_workflow
1496: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
1497: p_action_taken in ghr_pa_routing_history.action_taken%type,
1498: p_old_action_taken in ghr_pa_routing_history.action_taken%type default null,
1499: p_error in varchar2 default null
1500: );