APPS.GHR_WGI_PKG dependencies on GHR_PA_REQUESTS_PKG

Line 142: -- For Update SF52 procedure (ghr_pa_requests_pkg.get_SF52_person_ddf_details)

138: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
139: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
140: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE
141: := 'N';
142: -- For Update SF52 procedure (ghr_pa_requests_pkg.get_SF52_person_ddf_details)
143: l_citizenship ghr_pa_requests.citizenship%TYPE;
144: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
145: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
146: l_veterans_status ghr_pa_requests.veterans_status%TYPE;

Line 148: -- For Update SF52 procedure From side data elements(ghr_pa_requests_pkg.SF52_from_data_elements)

144: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
145: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
146: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
147: l_scd_leave VARCHAR2 (150);
148: -- For Update SF52 procedure From side data elements(ghr_pa_requests_pkg.SF52_from_data_elements)
149: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
150: l_from_agency_code ghr_pa_requests.from_agency_code%TYPE;
151: l_from_agency_desc ghr_pa_requests.from_agency_desc%TYPE;
152: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;

Line 1192: ghr_pa_requests_pkg.get_sf52_person_ddf_details (

1188:
1189: --
1190: -- Get SF52 Person DDF details
1191: --
1192: ghr_pa_requests_pkg.get_sf52_person_ddf_details (
1193: p_person_id => l_person_id,
1194: p_date_effective => l_effective_date,
1195: p_citizenship => l_citizenship,
1196: p_veterans_preference => l_veterans_preference,

Line 1251: ghr_pa_requests_pkg.get_sf52_asg_ddf_details (

1247:
1248: --
1249: -- Get assignment details
1250: --
1251: ghr_pa_requests_pkg.get_sf52_asg_ddf_details (
1252: p_assignment_id => l_assignment_id,
1253: p_date_effective => l_effective_date,
1254: p_tenure => l_tenure,
1255: p_annuitant_indicator => l_annuitant_indicator,

Line 1264: ghr_pa_requests_pkg.get_lookup_meaning (800,

1260: --
1261: -- get fegli desc
1262: --
1263: l_annuitant_indicator_desc :=
1264: ghr_pa_requests_pkg.get_lookup_meaning (800,
1265: 'GHR_US_ANNUITANT INDICATOR',
1266: l_annuitant_indicator
1267: );
1268: --

Line 1272: ghr_pa_requests_pkg.get_lookup_meaning (800,

1268: --
1269: -- populate work schedule desc
1270: --
1271: l_work_schedule_desc :=
1272: ghr_pa_requests_pkg.get_lookup_meaning (800,
1273: 'GHR_US_WORK_SCHEDULE',
1274: l_work_schedule
1275: );
1276: --

Line 1279: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (

1275: );
1276: --
1277: -- Get position details
1278: --
1279: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (
1280: p_position_id => l_from_position_id,
1281: p_date_effective => l_effective_date,
1282: p_flsa_category => l_flsa_category,
1283: p_bargaining_unit_status => l_bargaining_unit_status,

Line 1311: ghr_pa_requests_pkg.get_sf52_loc_ddf_details (

1307:
1308: --
1309: -- Get location details
1310: --
1311: ghr_pa_requests_pkg.get_sf52_loc_ddf_details (
1312: p_location_id => l_location_id,
1313: p_duty_station_id => l_duty_station_id
1314: );
1315:

Line 1333: ghr_pa_requests_pkg.get_duty_station_details (

1329:
1330: --
1331: -- Get duty station details
1332: --
1333: ghr_pa_requests_pkg.get_duty_station_details (
1334: p_duty_station_id => l_duty_station_id,
1335: p_effective_date => l_effective_date,
1336: p_duty_station_code => l_duty_station_code,
1337: p_duty_station_desc => l_duty_station_desc

Line 1363: ghr_pa_requests_pkg.get_lookup_meaning (800,

1359: p_value => l_fegli,
1360: p_multiple_error_flag => l_multiple_error_flag
1361: );
1362: l_fegli_desc :=
1363: ghr_pa_requests_pkg.get_lookup_meaning (800,
1364: 'GHR_US_FEGLI',
1365: l_fegli
1366: );
1367:

Line 1568: ghr_pa_requests_pkg.get_lookup_meaning (800,

1564:
1565: IF l_retirement_plan IS NOT NULL
1566: THEN
1567: l_retirement_plan_desc :=
1568: ghr_pa_requests_pkg.get_lookup_meaning (800,
1569: 'GHR_US_RETIREMENT_PLAN',
1570: l_retirement_plan
1571: );
1572: END IF;

Line 2833: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (p_position_id => p_position_id,

2829: --
2830: l_po_id := p_in_personnel_office_id;
2831: IF p_in_personnel_office_id IS NOT NULL
2832: THEN
2833: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (p_position_id => p_position_id,
2834: p_date_effective => p_effective_date,
2835: p_flsa_category => l_flsa_category,
2836: p_bargaining_unit_status => l_bargaining_unit_status,
2837: p_work_schedule => l_work_schedule,

Line 2856: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (p_position_id => p_position_id,

2852: RETURN FALSE;
2853: END IF;
2854: ELSE
2855: ----------------Return PO ID also
2856: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (p_position_id => p_position_id,
2857: p_date_effective => p_effective_date,
2858: p_flsa_category => l_flsa_category,
2859: p_bargaining_unit_status => l_bargaining_unit_status,
2860: p_work_schedule => l_work_schedule,