DBA Data[Home] [Help]

APPS.GHR_API dependencies on GHR_PA_REQUESTS

Line 435: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type

431: ,basic_pay number
432: ,locality_adj number
433: ,adj_basic_pay number
434: ,other_pay number
435: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type
436: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
437: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
438: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
439: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type

Line 436: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type

432: ,locality_adj number
433: ,adj_basic_pay number
434: ,other_pay number
435: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type
436: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
437: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
438: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
439: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
440: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type

Line 437: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type

433: ,adj_basic_pay number
434: ,other_pay number
435: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type
436: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
437: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
438: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
439: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
440: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
441: ,position_id per_all_positions.position_id%type

Line 438: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type

434: ,other_pay number
435: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type
436: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
437: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
438: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
439: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
440: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
441: ,position_id per_all_positions.position_id%type
442: ,duty_station_location_id hr_locations.location_id%type

Line 439: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type

435: ,position_org_line1 ghr_pa_requests.from_position_org_line1%type
436: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
437: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
438: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
439: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
440: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
441: ,position_id per_all_positions.position_id%type
442: ,duty_station_location_id hr_locations.location_id%type
443: , work_schedule ghr_pa_requests.work_schedule%type

Line 440: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type

436: ,position_org_line2 ghr_pa_requests.from_position_org_line2%type
437: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
438: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
439: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
440: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
441: ,position_id per_all_positions.position_id%type
442: ,duty_station_location_id hr_locations.location_id%type
443: , work_schedule ghr_pa_requests.work_schedule%type
444: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type);

Line 443: , work_schedule ghr_pa_requests.work_schedule%type

439: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
440: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
441: ,position_id per_all_positions.position_id%type
442: ,duty_station_location_id hr_locations.location_id%type
443: , work_schedule ghr_pa_requests.work_schedule%type
444: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type);
445: --
446: type recruitment_bonus_type is record
447: (p_recruitment_bonus_flag varchar2(1)

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

1454:
1455: ------------------------------------------------------------------------------
1456:
1457: Procedure call_workflow
1458: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
1459: p_action_taken in ghr_pa_routing_history.action_taken%type,
1460: p_old_action_taken in ghr_pa_routing_history.action_taken%type default null,
1461: p_error in varchar2 default null
1462: );