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_MASS_CON_PROGRAM dependencies on GHR_PA_REQUESTS

Line 9: g_furlo_effective_date ghr_pa_requests.effective_date%type;

5: g_package varchar2(32) := 'GHR_MASS_CON_PROGRAM.';
6: l_information_type varchar2(40);
7: g_log_name varchar2(30);
8: g_log_text varchar2(2000);
9: g_furlo_effective_date ghr_pa_requests.effective_date%type;
10:
11: PROCEDURE get_pa_request_id_ovn (
12: p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,
13: p_effective_date in date,

Line 12: p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,

8: g_log_text varchar2(2000);
9: g_furlo_effective_date ghr_pa_requests.effective_date%type;
10:
11: PROCEDURE get_pa_request_id_ovn (
12: p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,
13: p_effective_date in date,
14: p_person_id in per_people_f.person_id%TYPE,
15: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
16: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,

Line 15: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,

11: PROCEDURE get_pa_request_id_ovn (
12: p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,
13: p_effective_date in date,
14: p_person_id in per_people_f.person_id%TYPE,
15: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
16: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
17: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE)
18:
19: IS

Line 16: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,

12: p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,
13: p_effective_date in date,
14: p_person_id in per_people_f.person_id%TYPE,
15: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
16: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
17: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE)
18:
19: IS
20:

Line 17: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE)

13: p_effective_date in date,
14: p_person_id in per_people_f.person_id%TYPE,
15: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
16: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
17: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE)
18:
19: IS
20:
21: l_proc varchar2(72) := g_package || 'get_pa_request_id_ovn';

Line 25: FROM ghr_pa_requests par

21: l_proc varchar2(72) := g_package || 'get_pa_request_id_ovn';
22: CURSOR cur_rpa IS
23: SELECT object_version_number,
24: pa_notification_id,rpa_type
25: FROM ghr_pa_requests par
26: WHERE pa_request_id =p_pa_request_id;
27:
28: BEGIN
29:

Line 59: p_noa_action in ghr_pa_requests.first_noa_code%TYPE,

55: END get_pa_request_id_ovn;
56:
57: PROCEDURE refresh_ei_details
58: (
59: p_noa_action in ghr_pa_requests.first_noa_code%TYPE,
60: p_effective_date in date,
61: p_person_id in per_people_f.person_id%TYPE,
62: p_pa_request_id in ghr_pa_requests.pa_request_id%type
63: )

Line 62: p_pa_request_id in ghr_pa_requests.pa_request_id%type

58: (
59: p_noa_action in ghr_pa_requests.first_noa_code%TYPE,
60: p_effective_date in date,
61: p_person_id in per_people_f.person_id%TYPE,
62: p_pa_request_id in ghr_pa_requests.pa_request_id%type
63: )
64:
65: IS
66:

Line 206: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype) is

202: ' Sql Err is '|| sqlerrm(sqlcode) || l_proc, 60);
203:
204: END refresh_ei_details;
205:
206: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype) is
207: Begin
208: insert into ghr_pa_request_shadow(
209: pa_request_id
210: ,academic_discipline

Line 316: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,

312: ,p_rpa_data.award_uom
313: ,p_rpa_data.award_percentage );
314: end create_shadow_row;
315:
316: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,
317: p_result out nocopy Boolean ) is
318: Begin
319: update ghr_pa_request_shadow
320: set

Line 412: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VDR');

408: g_equivalent_pay_plan := l_eql_pay_plan.equivalent_pay_plan;
409: END LOOP;
410: IF g_equivalent_pay_plan ='ES' THEN
411: p_first_lac1_record.first_action_la_code1 := 'VDR';
412: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VDR');
413: ELSE
414: p_first_lac1_record.first_action_la_code1 := 'VAJ';
415: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VAJ');
416: END IF;

Line 415: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VAJ');

411: p_first_lac1_record.first_action_la_code1 := 'VDR';
412: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VDR');
413: ELSE
414: p_first_lac1_record.first_action_la_code1 := 'VAJ';
415: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VAJ');
416: END IF;
417: ELSIF p_noa_action ='292' THEN
418: p_first_lac1_record.first_action_la_code1 := 'CGM';
419: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','CGM');

Line 419: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','CGM');

415: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VAJ');
416: END IF;
417: ELSIF p_noa_action ='292' THEN
418: p_first_lac1_record.first_action_la_code1 := 'CGM';
419: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','CGM');
420:
421: END IF;
422: hr_utility.set_location('Leaving ' || l_proc,20);
423:

Line 436: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,

432: Procedure create_remarks
433: (p_noa_action IN VARCHAR2,
434: p_effective_date IN date,
435: p_person_id IN number,
436: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
437: p_work_schedule IN ghr_pa_requests.work_schedule%type,
438: p_fegli IN VARCHAR2,
439: p_fehb_plan IN VARCHAR2,
440: p_prd IN VARCHAR2

Line 437: p_work_schedule IN ghr_pa_requests.work_schedule%type,

433: (p_noa_action IN VARCHAR2,
434: p_effective_date IN date,
435: p_person_id IN number,
436: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
437: p_work_schedule IN ghr_pa_requests.work_schedule%type,
438: p_fegli IN VARCHAR2,
439: p_fehb_plan IN VARCHAR2,
440: p_prd IN VARCHAR2
441: )

Line 595: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

591:
592: procedure marpa_process
593: (
594: p_noa_action in VARCHAR2,
595: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
596: p_effective_date in date,
597: p_person_id in per_people_f.person_id%TYPE,
598: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,
599: p_log_text out nocopy varchar2

Line 598: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,

594: p_noa_action in VARCHAR2,
595: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
596: p_effective_date in date,
597: p_person_id in per_people_f.person_id%TYPE,
598: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,
599: p_log_text out nocopy varchar2
600: )
601: IS
602:

Line 604: l_pa_request_rec ghr_pa_requests%rowtype;

600: )
601: IS
602:
603: l_proc varchar2(72) := g_package || 'marpa_process';
604: l_pa_request_rec ghr_pa_requests%rowtype;
605: l_log_text varchar2(2000);
606: l_result boolean;
607: l_dummy varchar2(30);
608: l_dummy_number number;

Line 609: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

605: l_log_text varchar2(2000);
606: l_result boolean;
607: l_dummy varchar2(30);
608: l_dummy_number number;
609: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
610: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
611: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
612: l_object_version_number ghr_pa_requests.object_version_number%type;
613: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;

Line 610: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;

606: l_result boolean;
607: l_dummy varchar2(30);
608: l_dummy_number number;
609: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
610: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
611: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
612: l_object_version_number ghr_pa_requests.object_version_number%type;
613: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
614: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

Line 611: l_rpa_type ghr_pa_requests.rpa_type%TYPE;

607: l_dummy varchar2(30);
608: l_dummy_number number;
609: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
610: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
611: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
612: l_object_version_number ghr_pa_requests.object_version_number%type;
613: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
614: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
615: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;

Line 612: l_object_version_number ghr_pa_requests.object_version_number%type;

608: l_dummy_number number;
609: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
610: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
611: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
612: l_object_version_number ghr_pa_requests.object_version_number%type;
613: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
614: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
615: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
616: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

Line 613: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;

609: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
610: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
611: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
612: l_object_version_number ghr_pa_requests.object_version_number%type;
613: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
614: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
615: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
616: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
617: l_approval_date date;

Line 615: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;

611: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
612: l_object_version_number ghr_pa_requests.object_version_number%type;
613: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
614: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
615: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
616: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
617: l_approval_date date;
618: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
619: l_1_approval_status varchar2(10);

Line 618: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;

614: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
615: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
616: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
617: l_approval_date date;
618: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
619: l_1_approval_status varchar2(10);
620: l_u_prh_object_version_number number;
621: l_i_pa_routing_history_id number;
622: l_i_prh_object_version_number number;

Line 1129: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

1125: END marpa_process;
1126:
1127: Procedure build_rpa
1128: ( p_noa_action in VARCHAR2,
1129: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
1130: p_effective_date in date,
1131: p_nte_date in varchar2,
1132: p_person_id in per_people_f.person_id%TYPE,
1133: p_assignment_id in per_assignments_f.assignment_id%TYPE,

Line 1146: l_pa_request_rec ghr_pa_requests%rowtype;

1142:
1143: l_proc varchar2(172) := g_package || 'build_rpa';
1144: l_dummy varchar2(30);
1145: l_dummy_number number;
1146: l_pa_request_rec ghr_pa_requests%rowtype;
1147: l_personnel_officer_name per_people_f.full_name%type;
1148: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1149: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
1150: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

Line 1148: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;

1144: l_dummy varchar2(30);
1145: l_dummy_number number;
1146: l_pa_request_rec ghr_pa_requests%rowtype;
1147: l_personnel_officer_name per_people_f.full_name%type;
1148: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1149: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
1150: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1151: l_multiple_error_flag boolean;
1152: l_scd_leave varchar2(30);

Line 1149: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;

1145: l_dummy_number number;
1146: l_pa_request_rec ghr_pa_requests%rowtype;
1147: l_personnel_officer_name per_people_f.full_name%type;
1148: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1149: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
1150: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1151: l_multiple_error_flag boolean;
1152: l_scd_leave varchar2(30);
1153: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

Line 1153: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

1149: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
1150: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1151: l_multiple_error_flag boolean;
1152: l_scd_leave varchar2(30);
1153: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
1154: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
1155: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1156: l_object_version_number ghr_pa_requests.object_version_number%type;
1157: l_log_text varchar2(2000);

Line 1154: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;

1150: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1151: l_multiple_error_flag boolean;
1152: l_scd_leave varchar2(30);
1153: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
1154: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
1155: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1156: l_object_version_number ghr_pa_requests.object_version_number%type;
1157: l_log_text varchar2(2000);
1158: l_routing_group_id ghr_pa_requests.routing_group_id%type;

Line 1155: l_rpa_type ghr_pa_requests.rpa_type%TYPE;

1151: l_multiple_error_flag boolean;
1152: l_scd_leave varchar2(30);
1153: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
1154: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
1155: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1156: l_object_version_number ghr_pa_requests.object_version_number%type;
1157: l_log_text varchar2(2000);
1158: l_routing_group_id ghr_pa_requests.routing_group_id%type;
1159: l_groupbox_id ghr_groupboxes.groupbox_id%type;

Line 1156: l_object_version_number ghr_pa_requests.object_version_number%type;

1152: l_scd_leave varchar2(30);
1153: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
1154: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
1155: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1156: l_object_version_number ghr_pa_requests.object_version_number%type;
1157: l_log_text varchar2(2000);
1158: l_routing_group_id ghr_pa_requests.routing_group_id%type;
1159: l_groupbox_id ghr_groupboxes.groupbox_id%type;
1160: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

Line 1158: l_routing_group_id ghr_pa_requests.routing_group_id%type;

1154: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
1155: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1156: l_object_version_number ghr_pa_requests.object_version_number%type;
1157: l_log_text varchar2(2000);
1158: l_routing_group_id ghr_pa_requests.routing_group_id%type;
1159: l_groupbox_id ghr_groupboxes.groupbox_id%type;
1160: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1161: l_prh_object_version_number ghr_pa_routing_history.object_version_number%type;
1162: l_duty_station_location_id hr_locations.location_id%TYPE;

Line 1170: l_first_noa_desc ghr_pa_requests.first_noa_desc%type;

1166: l_lac1 first_lac1_record;
1167: l_lac2 first_lac2_record;
1168: l_rpa_action varchar2(40);
1169: l_health_plan pay_element_entry_values_f.screen_entry_value%type;
1170: l_first_noa_desc ghr_pa_requests.first_noa_desc%type;
1171: l_savepoint varchar2(1);
1172: groupboxerr exception;
1173: rpaerror exception;
1174: ma_rpaerror exception;

Line 1228: l_pa_request_rec.noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family

1224: p_effective_date => l_pa_request_rec.effective_date,
1225: p_noa_id => l_pa_request_rec.first_noa_id,
1226: p_noa_desc => l_pa_request_rec.first_noa_desc
1227: );
1228: l_pa_request_rec.noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family
1229: (p_nature_of_action_id => l_pa_request_rec.first_noa_id);
1230:
1231: hr_utility.set_location(l_proc,20);
1232: ghr_pa_requests_pkg.get_person_details

Line 1232: ghr_pa_requests_pkg.get_person_details

1228: l_pa_request_rec.noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family
1229: (p_nature_of_action_id => l_pa_request_rec.first_noa_id);
1230:
1231: hr_utility.set_location(l_proc,20);
1232: ghr_pa_requests_pkg.get_person_details
1233: (p_person_id => p_person_id
1234: ,p_effective_date => p_effective_date
1235: ,p_national_identifier => l_pa_request_rec.employee_national_identifier
1236: ,p_date_of_birth => l_pa_request_rec.employee_date_of_birth

Line 1243: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

1239: ,p_middle_names => l_pa_request_rec.employee_middle_names
1240: );
1241:
1242: If p_person_id is not null then
1243: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
1244: (p_person_id => p_person_id,
1245: p_effective_date => p_effective_date);
1246: End if;
1247:

Line 1298: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1294:
1295: hr_utility.set_location(l_proc,30);
1296: l_pa_request_rec.duty_station_location_id := l_duty_station_location_id;
1297:
1298: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1299: (p_location_id => l_duty_station_location_id
1300: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1301:
1302: ghr_pa_requests_pkg.get_duty_station_details

Line 1302: ghr_pa_requests_pkg.get_duty_station_details

1298: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1299: (p_location_id => l_duty_station_location_id
1300: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1301:
1302: ghr_pa_requests_pkg.get_duty_station_details
1303: (p_duty_station_id => l_pa_request_rec.duty_station_id
1304: ,p_effective_date => l_pa_request_rec.effective_date
1305: ,p_duty_station_code => l_pa_request_rec.duty_station_code
1306: ,p_duty_station_desc => l_pa_request_rec.duty_station_desc);

Line 1361: ghr_pa_requests_pkg.get_sf52_pos_ddf_details

1357: l_pa_request_rec.to_pay_plan := l_pa_request_rec.from_pay_plan;
1358: END IF;
1359:
1360: hr_utility.set_location(l_proc,40);
1361: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
1362: (p_position_id => p_position_id
1363: ,p_date_Effective => l_pa_request_rec.effective_date
1364: ,p_flsa_category => l_pa_request_rec.flsa_category
1365: ,p_bargaining_unit_status => l_pa_request_rec.bargaining_unit_status

Line 1391: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning

1387: ,p_effective_date => p_effective_date);
1388:
1389: hr_utility.set_location('Agency Code ' || l_pa_request_rec.agency_code ,52);
1390:
1391: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning
1392: (800
1393: ,'GHR_US_AGENCY_CODE'
1394: ,l_pa_request_rec.agency_code
1395: );

Line 1397: ghr_pa_requests_pkg.get_SF52_person_ddf_details

1393: ,'GHR_US_AGENCY_CODE'
1394: ,l_pa_request_rec.agency_code
1395: );
1396:
1397: ghr_pa_requests_pkg.get_SF52_person_ddf_details
1398: (p_person_id => l_pa_request_rec.person_id,
1399: p_date_effective => l_pa_request_rec.effective_date,
1400: p_citizenship => l_pa_request_rec.citizenship,
1401: p_veterans_preference => l_pa_request_rec.veterans_preference,

Line 1421: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

1417: p_year_degree_attained => l_pa_request_rec.year_degree_attained
1418: );
1419:
1420: hr_utility.set_location(l_proc,80);
1421: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
1422: (p_assignment_id => l_pa_request_rec.employee_assignment_id
1423: ,p_date_effective => l_pa_request_rec.effective_date
1424: ,p_tenure => l_pa_request_rec.tenure
1425: ,p_annuitant_indicator => l_pa_request_rec.annuitant_indicator

Line 1432: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning

1428: ,p_part_time_hours => l_pa_request_rec.part_time_hours
1429: );
1430:
1431: -- Annuitant_indicator
1432: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning
1433: (800
1434: ,'GHR_US_ANNUITANT_INDICATOR'
1435: ,l_pa_request_rec.annuitant_indicator
1436: );

Line 1439: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning

1435: ,l_pa_request_rec.annuitant_indicator
1436: );
1437:
1438: --WORK_SCHEDULE
1439: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning
1440: (800
1441: ,'GHR_US_WORK_SCHEDULE'
1442: ,l_pa_request_rec.work_schedule
1443: );

Line 1455: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

1451: ,p_effective_date => l_pa_request_rec.effective_date
1452: ,p_value => l_pa_request_rec.fegli
1453: ,p_multiple_error_flag => l_multiple_error_flag
1454: );
1455: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
1456: (800
1457: ,'GHR_US_FEGLI'
1458: ,l_pa_request_rec.fegli
1459: );

Line 1472: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning

1468: ,p_value => l_pa_request_rec.retirement_plan
1469: ,p_multiple_error_flag => l_multiple_error_flag
1470: );
1471:
1472: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning
1473: (800
1474: ,'GHR_US_RETIREMENT_PLAN'
1475: ,l_pa_request_rec.retirement_plan
1476: );

Line 1866: l_rpa_type ghr_pa_requests.rpa_type%type;

1862: l_agency varchar2(50);
1863: l_noa_action ghr_nature_of_actions.code%type;
1864: l_proc varchar2(172) := g_package || 'main_concurrent_program';
1865: l_effective_date date;
1866: l_rpa_type ghr_pa_requests.rpa_type%type;
1867: l_prog_name varchar2(30);
1868: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
1869: l_elig_flag BOOLEAN := FALSE;
1870: l_emergency_ess_emp VARCHAR2(20);

Line 1960: SELECT par.rpa_type,par.effective_date from ghr_pa_requests par

1956: AND substr(ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id,l_eff_date),1,2) = nvl(l_agency,substr(ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id,l_eff_date),1,2))
1957: ORDER BY ppf.person_id;
1958:
1959: CURSOR get_rpa_type (p_person_id number,p_assignment_id number) IS
1960: SELECT par.rpa_type,par.effective_date from ghr_pa_requests par
1961: where par.person_id = p_person_id
1962: AND par.employee_assignment_id = p_assignment_id
1963: AND par.effective_date < l_effective_date
1964: AND par.rpa_type='MFL'

Line 1968: from ghr_pa_requests b

1964: AND par.rpa_type='MFL'
1965: AND par.first_noa_code IN ('472')
1966: AND par.pa_notification_id IS NOT NULL
1967: AND not exists (select 1
1968: from ghr_pa_requests b
1969: where person_id = p_person_id
1970: and altered_pa_request_id = par.pa_request_id
1971: and first_noa_code = '001'
1972: and second_noa_code = par.first_noa_code)

Line 2010: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

2006: hr_utility.set_location('SSN: '||per.national_identifier,2000);
2007: hr_utility.set_location('Position Id: '||per.position_id,2000);
2008: hr_utility.set_location('BG Id: '||per.business_group_id,2000);
2009: l_full_name := per.last_name||','|| per.first_name||' '||per.middle_names;
2010: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
2011: (p_person_id => per.person_id,
2012: p_effective_date => l_effective_date);
2013:
2014: ghr_history_fetch.fetch_asgei