1 PACKAGE ghr_cpdf_dynrpt AS
2 /* $Header: ghrcpdfd.pkh 120.2.12010000.1 2008/07/28 10:38:09 appldev ship $ */
3
4 -- Bug#2789704 declared the following exception
5 CPDF_DYNRPT_ERROR EXCEPTION;
6
7 PROCEDURE cleanup_table;
8
9 FUNCTION exclude_agency (p_agency_code IN VARCHAR2)
10 RETURN VARCHAR2;
11 PRAGMA RESTRICT_REFERENCES(exclude_agency,WNDS,WNPS);
12
13 FUNCTION exclude_noac (p_first_noac IN VARCHAR2
14 ,p_second_noac IN VARCHAR2
15 ,p_noa_family_code IN VARCHAR2)
16 RETURN VARCHAR2;
17 PRAGMA RESTRICT_REFERENCES(exclude_noac,WNDS,WNPS);
18
19 FUNCTION non_us_citizen_and_foreign_ds (p_citizenship IN VARCHAR2
20 ,p_duty_station_code IN VARCHAR2)
21 RETURN BOOLEAN;
22 PRAGMA RESTRICT_REFERENCES(non_us_citizen_and_foreign_ds,WNDS,WNPS);
23
24 FUNCTION exclude_position (p_position_id IN NUMBER
25 ,p_effective_date IN DATE)
26 RETURN BOOLEAN;
27 -- Bug#3231946 Added parameter p_duty_station_code.
28 FUNCTION get_loc_pay_area_code(p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE default NULL,
29 p_duty_station_code IN ghr_duty_stations_f.duty_station_code%TYPE default NULL,
30 p_effective_date IN DATE)
31 RETURN VARCHAR2;
32
33 FUNCTION get_equivalent_pay_plan(p_pay_plan IN ghr_pay_plans.pay_plan%TYPE)
34 RETURN VARCHAR2;
35
36 FUNCTION format_ni(p_ni IN VARCHAR2)
37 RETURN VARCHAR2;
38 PRAGMA RESTRICT_REFERENCES(format_ni,WNDS,WNPS);
39
40 FUNCTION format_noac(p_noac IN VARCHAR2)
41 RETURN VARCHAR2;
42 PRAGMA RESTRICT_REFERENCES(format_noac,WNDS,WNPS);
43
44 FUNCTION format_basic_pay(p_basic_pay IN NUMBER
45 ,p_pay_basis IN VARCHAR2
46 ,p_size IN NUMBER)
47 RETURN VARCHAR2;
48 PRAGMA RESTRICT_REFERENCES(format_basic_pay,WNDS,WNPS);
49
50 FUNCTION format_amount(p_amount IN NUMBER
51 ,p_size IN NUMBER)
52 RETURN VARCHAR2;
53
54 -- This function is added as per Bug 5417021
55 FUNCTION format_award_perc(p_amount IN NUMBER
56 ,p_size IN NUMBER)
57 RETURN VARCHAR2;
58
59 PRAGMA RESTRICT_REFERENCES(format_amount,WNDS,WNPS);
60
61 PROCEDURE get_per_sit_perf_appraisal(p_person_id IN NUMBER
62 ,p_effective_date IN DATE
63 ,p_rating_of_record_level OUT NOCOPY VARCHAR2
64 ,p_rating_of_record_pattern OUT NOCOPY VARCHAR2
65 ,p_rating_of_record_period OUT NOCOPY DATE);
66
67 PROCEDURE get_suffix_lname(p_last_name IN VARCHAR2,
68 p_report_date IN DATE,
69 p_suffix OUT NOCOPY VARCHAR2,
70 p_lname OUT NOCOPY VARCHAR2);
71
72 PROCEDURE populate_ghr_cpdf_temp(p_agency IN VARCHAR2
73 ,p_start_date IN DATE
74 ,p_end_date IN DATE
75 ,p_count_only IN BOOLEAN DEFAULT FALSE);
76
77 --
78 END ghr_cpdf_dynrpt;