1 PACKAGE GHR_MTI_APP AS
2 /* $Header: ghmtiapp.pkh 120.1 2005/05/29 23:39:58 sumarimu noship $ */
3
4 mass_error exception;
5
6 procedure populate_and_create_52(p_errbuf out nocopy varchar2,
7 p_retcode out nocopy number,
8 p_business_group_id in number,
9 p_mtin_name in varchar2,
10 p_mtin_id in number,
11 p_effective_date in date);
12
13 function check_eligibility(p_person_id in number,
14 p_effective_date in date) return boolean;
15
16 procedure assign_to_sf52_rec(
17 p_person_id in number
18 ,p_position_id in number
19 ,p_job_id in number
20 ,p_employee_assignment_id in number
21 ,p_last_name in varchar2
22 ,p_first_name in varchar2
23 ,p_middle_names in varchar2
24 ,p_national_identifier in varchar2
25 ,p_date_of_birth in varchar2
26 ,p_effective_date in varchar2
27 ,p_position_title in varchar2
28 ,p_position_number in varchar2
29 ,p_position_seq_no in number
30 ,p_pay_plan in varchar2
31 ,p_occ_code in varchar2
32 ,p_organization_id in number
33 ,p_grade_id in number
34 ,p_grade_or_level in varchar2
35 ,p_pay_basis in varchar2
36 ,p_step_or_rate in varchar2
37 ,p_veterans_preference in varchar2
38 ,p_vet_preference_for_RIF in varchar2
39 ,p_FEGLI in varchar2
40 ,p_tenure in varchar2
41 ,p_annuitant_indicator in varchar2
42 ,p_pay_rate_determinant in varchar2
43 ,p_retirement_plan in varchar2
44 ,p_service_comp_date in varchar2
45 ,p_work_schedule in varchar2
46 ,p_position_occupied in varchar2
47 ,p_flsa_category in varchar2
48 ,p_appropriation_code1 in varchar2
49 ,p_appropriation_code2 in varchar2
50 ,p_bargaining_unit_status in varchar2
51 ,p_duty_station_location_id in number
52 ,p_duty_station_id in number
53 ,p_duty_station_code in varchar2
54 ,p_duty_station_desc in varchar2
55 ,p_functional_class in varchar2
56 ,p_citizenship in varchar2
57 ,p_veterans_status in varchar2
58 ,p_supervisory_status in varchar2
59 ,p_type_of_employment in varchar2
60 ,p_race_or_national_origin in varchar2
61 ,p_orig_appointment_auth_code1 in varchar2
62 ,p_handicap_code in varchar2
63 ,p_creditable_military_service in varchar2
64 ,p_previous_retirement_coverage in varchar2
65 ,p_frozen_service in varchar2
66 ,p_agency_code_transfer_from in varchar2
67 ,p_to_position_org_line1 IN varchar2
68 ,p_to_position_org_line2 IN varchar2
69 ,p_to_position_org_line3 IN varchar2
70 ,p_to_position_org_line4 IN varchar2
71 ,p_to_position_org_line5 IN varchar2
72 ,p_to_position_org_line6 IN varchar2
73 -- Changes 4093771
74 , p_to_basic_pay IN number
75 , p_to_adj_basic_pay IN number
76 , p_to_total_salary IN number
77 -- End Changes 4093771
78 ,p_lac_sf52_rec in ghr_pa_requests%rowtype
79 ,p_sf52_rec out nocopy ghr_pa_requests%rowtype);
80
81
82 procedure pr (msg varchar2,par1 in varchar2 default null,
83 par2 in varchar2 default null);
84 END;