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.GHR_PA_REQUESTS_PKG dependencies on GHR_PA_REQUESTS

Line 1: PACKAGE BODY ghr_pa_requests_pkg AS

1: PACKAGE BODY ghr_pa_requests_pkg AS
2: /* $Header: ghparqst.pkb 120.8.12020000.2 2012/07/05 14:40:31 amnaraya ship $ */
3:
4: -- For a particuar NOA Family this function returns the procesing method for a given
5: -- item in a form

Line 386: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE

382: RAISE;
383:
384: END get_default_routing_group;
385:
386: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
387: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
388: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
389: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
390: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE

Line 961: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE

957:
958: PROCEDURE get_SF52_to_data_elements
959: (p_position_id IN hr_all_positions_f.position_id%TYPE
960: ,p_effective_date IN date default sysdate
961: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE
962: ,p_grade_id IN OUT NOCOPY number
963: ,p_job_id IN OUT NOCOPY number
964: ,p_organization_id IN OUT NOCOPY number
965: ,p_location_id IN OUT NOCOPY number

Line 1054: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

1050: END LOOP;
1051: --
1052:
1053: IF l_assignment_id IS NOT NULL THEN
1054: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
1055: (p_assignment_id => l_assignment_id
1056: ,p_date_effective => p_effective_date
1057: ,p_tenure => l_dummy
1058: ,p_annuitant_indicator => l_dummy

Line 1188: PROCEDURE get_rei_org_lines (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE

1184:
1185: -- This procedure only really needs to be called for realignment. For this NOA the 6 'address' lines seen
1186: -- on the to side should come from the 'position organization' on the PAR extra info (if given)
1187: --
1188: PROCEDURE get_rei_org_lines (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
1189: ,p_organization_id IN OUT NOCOPY VARCHAR2
1190: ,p_position_org_line1 OUT NOCOPY varchar2
1191: ,p_position_org_line2 OUT NOCOPY varchar2
1192: ,p_position_org_line3 OUT NOCOPY varchar2

Line 1587: FROM ghr_pa_requests par

1583: RETURN BOOLEAN IS
1584: --
1585: CURSOR c_par IS
1586: SELECT 1
1587: FROM ghr_pa_requests par
1588: WHERE par.pa_request_id = p_pa_request_id
1589: AND par.pa_notification_id IS NOT NULL;
1590: --
1591: BEGIN

Line 1731: PROCEDURE get_corr_other_pay(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE

1727:
1728: END check_valid_person_id;
1729: --
1730:
1731: PROCEDURE get_corr_other_pay(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
1732: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
1733: ,p_to_basic_pay OUT NOCOPY NUMBER
1734: ,p_to_adj_basic_pay OUT NOCOPY NUMBER
1735: ,p_to_auo_ppi OUT NOCOPY VARCHAR2

Line 1770: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;

1766: --- ,p_open_pay_fields => l_open_pay_fields_caps
1767: --- ,p_message_set => l_message_set_caps);
1768: ---
1769: ---
1770: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;
1771: BEGIN
1772: ghr_corr_canc_SF52.build_corrected_SF52(p_pa_request_id => p_pa_request_id
1773: ,p_noa_code_correct => p_noa_code
1774: ,p_sf52_data_result => l_ghr_pa_request_rec);

Line 1818: PROCEDURE get_corr_rpa_other_pay(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE

1814:
1815:
1816: END get_corr_other_pay;
1817:
1818: PROCEDURE get_corr_rpa_other_pay(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
1819: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
1820: ,p_from_basic_pay OUT NOCOPY NUMBER
1821: ,p_to_basic_pay OUT NOCOPY NUMBER
1822: ,p_to_adj_basic_pay OUT NOCOPY NUMBER

Line 1841: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;

1837: ,p_from_step_or_rate OUT NOCOPY VARCHAR2
1838: ,p_to_step_or_rate OUT NOCOPY VARCHAR2
1839: -- Corr Warn
1840: ) IS
1841: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;
1842: BEGIN
1843: ghr_corr_canc_SF52.build_corrected_SF52(p_pa_request_id => p_pa_request_id
1844: ,p_noa_code_correct => p_noa_code
1845: ,p_sf52_data_result => l_ghr_pa_request_rec);

Line 1896: PROCEDURE get_corr_award (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE

1892:
1893: --
1894: -- This procedure gets the amounts that are not displayed in a correction form that
1895: -- are needed to do an award
1896: PROCEDURE get_corr_award (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
1897: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
1898: ,p_from_basic_pay OUT NOCOPY NUMBER
1899: ,p_from_pay_basis OUT NOCOPY VARCHAR2
1900: ) IS

Line 1902: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;

1898: ,p_from_basic_pay OUT NOCOPY NUMBER
1899: ,p_from_pay_basis OUT NOCOPY VARCHAR2
1900: ) IS
1901: --
1902: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;
1903: BEGIN
1904: ghr_corr_canc_SF52.build_corrected_SF52(p_pa_request_id => p_pa_request_id
1905: ,p_noa_code_correct => p_noa_code
1906: ,p_sf52_data_result => l_ghr_pa_request_rec);

Line 2024: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE

2020: END get_full_name_fml;
2021:
2022: FUNCTION get_upd34_pay_basis (p_person_id IN per_people_f.person_id%TYPE
2023: ,p_position_id IN per_positions.position_id%type
2024: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE
2025: ,p_noa_code IN varchar2 DEFAULT NULL
2026: ,p_pa_request_id IN NUMBER DEFAULT NULL
2027: ,p_effective_date IN DATE)
2028: RETURN VARCHAR2 IS

Line 2110: from ghr_pa_requests par

2106:
2107: CURSOR c_par is
2108: select par.effective_date effective_date,
2109: par.pa_request_id
2110: from ghr_pa_requests par
2111: where par.person_id = p_person_id
2112: and par.effective_date >= p_date
2113: and par.pa_notification_id is not null
2114: and par.first_noa_code <> '001'

Line 2127: ,ghr_pa_requests par

2123: /*CURSOR c_par IS
2124: SELECT par.effective_date effective_date
2125: ,par.altered_pa_request_id
2126: FROM ghr_pa_routing_history prh
2127: ,ghr_pa_requests par
2128: WHERE par.person_id = p_person_id
2129: AND par.effective_date >= p_date
2130: AND prh.pa_request_id = par.pa_request_id
2131: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)

Line 2218: FUNCTION temp_step_true (p_pa_request_id IN ghr_pa_requests.pa_request_id%type)

2214: end if;
2215:
2216: END update34_implement_cancel;
2217:
2218: FUNCTION temp_step_true (p_pa_request_id IN ghr_pa_requests.pa_request_id%type)
2219: RETURN BOOLEAN IS
2220:
2221: l_noa_code ghr_nature_of_actions.code%type;
2222: l_temp_step VARCHAR2(60);

Line 2226: FROM ghr_pa_requests

2222: l_temp_step VARCHAR2(60);
2223:
2224: CURSOR cur_par IS
2225: SELECT first_noa_code,second_noa_code
2226: FROM ghr_pa_requests
2227: WHERE pa_request_id = p_pa_request_id;
2228:
2229: CURSOR cur_temp_step IS
2230: SELECT rei_information3 temp_step

Line 2521: END ghr_pa_requests_pkg;

2517: return upper(l_system_type_cd);
2518: end get_pos_availability_status;
2519: --End Bug# 13684234
2520:
2521: END ghr_pa_requests_pkg;