DBA Data[Home] [Help]

APPS.GHR_MTO_PKG dependencies on HR_GENERAL

Line 1079: HR_GENERAL.DECODE_LOOKUP('GHR_US_AGENCY_CODE_2',substr(l_agency_code,1,2)), --AVR

1075: l_org_func_code,
1076: l_appropriation_code1,
1077: l_appropriation_code2,
1078: l_position_organization,
1079: HR_GENERAL.DECODE_LOOKUP('GHR_US_AGENCY_CODE_2',substr(l_agency_code,1,2)), --AVR
1080: l_agency_code, -- p_to_position_org_line1 -- AVR
1081: ------- l_agency_code, -- p_first_noa_information1 (in earlier version)
1082: l_lac_sf52_rec,
1083: l_sf52_rec);

Line 1274: hr_general.decode_availability_status is return pos_aval_status description not the system code

1270: LOOP
1271: l_avail_status_id := per.availability_status_id;
1272: --Begin Bug# 13684234
1273: /* commented below code and added func get_pos_availability_status, since
1274: hr_general.decode_availability_status is return pos_aval_status description not the system code
1275: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1276: not in ('Eliminated','Frozen','Deleted') ) THEN*/
1277:
1278: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)

Line 1275: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)

1271: l_avail_status_id := per.availability_status_id;
1272: --Begin Bug# 13684234
1273: /* commented below code and added func get_pos_availability_status, since
1274: hr_general.decode_availability_status is return pos_aval_status description not the system code
1275: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1276: not in ('Eliminated','Frozen','Deleted') ) THEN*/
1277:
1278: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)
1279: NOT IN ('DELETED','FROZEN','ELIMINATED') THEN

Line 1452: hr_general.decode_availability_status is return pos_aval_status description not the system code

1448: -- Bug#4201666 Added the check to Restrict Eliminated, Frozen, Deleted Positions.
1449: l_avail_status_id := per_vacant.availability_status_id;
1450: --Begin Bug# 13684234
1451: /* commented below code and added func get_pos_availability_status, since
1452: hr_general.decode_availability_status is return pos_aval_status description not the system code
1453: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1454: not in ('Eliminated','Frozen','Deleted') ) THEN*/
1455:
1456: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)

Line 1453: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)

1449: l_avail_status_id := per_vacant.availability_status_id;
1450: --Begin Bug# 13684234
1451: /* commented below code and added func get_pos_availability_status, since
1452: hr_general.decode_availability_status is return pos_aval_status description not the system code
1453: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1454: not in ('Eliminated','Frozen','Deleted') ) THEN*/
1455:
1456: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)
1457: NOT IN ('DELETED','FROZEN','ELIMINATED') THEN