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_NATURE_OF_ACTIONS

Line 249: p_nature_of_action_id IN ghr_nature_of_actions.nature_of_action_id%TYPE)

245: END get_full_name_unsecure;
246:
247:
248: FUNCTION get_noa_descriptor(
249: p_nature_of_action_id IN ghr_nature_of_actions.nature_of_action_id%TYPE)
250: RETURN VARCHAR2 IS
251:
252: l_ret_val ghr_nature_of_actions.description%TYPE := NULL;
253:

Line 252: l_ret_val ghr_nature_of_actions.description%TYPE := NULL;

248: FUNCTION get_noa_descriptor(
249: p_nature_of_action_id IN ghr_nature_of_actions.nature_of_action_id%TYPE)
250: RETURN VARCHAR2 IS
251:
252: l_ret_val ghr_nature_of_actions.description%TYPE := NULL;
253:
254: CURSOR cur_noa IS
255: SELECT noa.description
256: FROM ghr_nature_of_actions noa

Line 256: FROM ghr_nature_of_actions noa

252: l_ret_val ghr_nature_of_actions.description%TYPE := NULL;
253:
254: CURSOR cur_noa IS
255: SELECT noa.description
256: FROM ghr_nature_of_actions noa
257: WHERE noa.nature_of_action_id= p_nature_of_action_id;
258:
259: BEGIN
260: FOR cur_noa_rec IN cur_noa LOOP

Line 1320: ,p_nature_of_action_id IN OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE

1316: END get_user_person_id;
1317:
1318: PROCEDURE get_single_noac_for_fam (p_noa_family_code IN ghr_noa_families.noa_family_code%TYPE
1319: ,p_effective_date IN DATE
1320: ,p_nature_of_action_id IN OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE
1321: ,p_code IN OUT NOCOPY ghr_nature_of_actions.code%TYPE
1322: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE) IS
1323:
1324:

Line 1321: ,p_code IN OUT NOCOPY ghr_nature_of_actions.code%TYPE

1317:
1318: PROCEDURE get_single_noac_for_fam (p_noa_family_code IN ghr_noa_families.noa_family_code%TYPE
1319: ,p_effective_date IN DATE
1320: ,p_nature_of_action_id IN OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE
1321: ,p_code IN OUT NOCOPY ghr_nature_of_actions.code%TYPE
1322: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE) IS
1323:
1324:
1325: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;

Line 1322: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE) IS

1318: PROCEDURE get_single_noac_for_fam (p_noa_family_code IN ghr_noa_families.noa_family_code%TYPE
1319: ,p_effective_date IN DATE
1320: ,p_nature_of_action_id IN OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE
1321: ,p_code IN OUT NOCOPY ghr_nature_of_actions.code%TYPE
1322: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE) IS
1323:
1324:
1325: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
1326: l_code ghr_nature_of_actions.code%TYPE;

Line 1325: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;

1321: ,p_code IN OUT NOCOPY ghr_nature_of_actions.code%TYPE
1322: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE) IS
1323:
1324:
1325: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
1326: l_code ghr_nature_of_actions.code%TYPE;
1327: l_description ghr_nature_of_actions.description%TYPE;
1328:
1329: l_record_found BOOLEAN := FALSE;

Line 1326: l_code ghr_nature_of_actions.code%TYPE;

1322: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE) IS
1323:
1324:
1325: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
1326: l_code ghr_nature_of_actions.code%TYPE;
1327: l_description ghr_nature_of_actions.description%TYPE;
1328:
1329: l_record_found BOOLEAN := FALSE;
1330:

Line 1327: l_description ghr_nature_of_actions.description%TYPE;

1323:
1324:
1325: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
1326: l_code ghr_nature_of_actions.code%TYPE;
1327: l_description ghr_nature_of_actions.description%TYPE;
1328:
1329: l_record_found BOOLEAN := FALSE;
1330:
1331: CURSOR cur_noa IS

Line 1335: FROM ghr_nature_of_actions noa

1331: CURSOR cur_noa IS
1332: SELECT noa.nature_of_action_id
1333: ,noa.code
1334: ,noa.description
1335: FROM ghr_nature_of_actions noa
1336: ,ghr_noa_families naf
1337: WHERE naf.noa_family_code = p_noa_family_code
1338: AND naf.nature_of_action_id = noa.nature_of_action_id
1339: AND naf.enabled_flag = 'Y'

Line 1512: FUNCTION get_noa_pm_family (p_noa_code IN ghr_nature_of_actions.code%TYPE)

1508: END get_noa_pm_family;
1509: --
1510:
1511: -- As above except pass in a noa code and it returns the family it is in
1512: FUNCTION get_noa_pm_family (p_noa_code IN ghr_nature_of_actions.code%TYPE)
1513: RETURN VARCHAR2 IS
1514: --
1515: l_ret_val VARCHAR2(30) := NULL;
1516: --

Line 1521: ,ghr_nature_of_actions noa

1517: CURSOR c_naf IS
1518: SELECT naf.noa_family_code
1519: FROM ghr_families fam
1520: ,ghr_noa_families naf
1521: ,ghr_nature_of_actions noa
1522: WHERE fam.noa_family_code = naf.noa_family_code
1523: AND naf.nature_of_action_id = noa.nature_of_action_id
1524: AND noa.code = p_noa_code
1525: AND fam.proc_method_flag = 'Y';

Line 1732: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

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
1736: ,p_to_auo OUT NOCOPY NUMBER

Line 1819: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

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
1823: ,p_to_auo_ppi OUT NOCOPY VARCHAR2

Line 1897: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

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
1901: --

Line 2221: l_noa_code ghr_nature_of_actions.code%type;

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);
2223:
2224: CURSOR cur_par IS
2225: SELECT first_noa_code,second_noa_code