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 1194: ghr_pa_requests_pkg.get_sf52_person_ddf_details (

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

Line 1253: ghr_pa_requests_pkg.get_sf52_asg_ddf_details (

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

Line 1266: ghr_pa_requests_pkg.get_lookup_meaning (800,

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

Line 1274: ghr_pa_requests_pkg.get_lookup_meaning (800,

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

Line 1281: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (

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

Line 1313: ghr_pa_requests_pkg.get_sf52_loc_ddf_details (

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

Line 1335: ghr_pa_requests_pkg.get_duty_station_details (

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

Line 1365: ghr_pa_requests_pkg.get_lookup_meaning (800,

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

Line 1570: ghr_pa_requests_pkg.get_lookup_meaning (800,

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

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

2833: --
2834: l_po_id := p_in_personnel_office_id;
2835: IF p_in_personnel_office_id IS NOT NULL
2836: THEN
2837: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (p_position_id => p_position_id,
2838: p_date_effective => p_effective_date,
2839: p_flsa_category => l_flsa_category,
2840: p_bargaining_unit_status => l_bargaining_unit_status,
2841: p_work_schedule => l_work_schedule,

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

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