1 PACKAGE ghr_ehri_dynrpt AUTHID CURRENT_USER AS
2 /* $Header: ghrehrid.pkh 120.4.12020000.1 2012/06/29 04:37:35 appldev ship $ */
3
4 -- Bug#2789704 declared the following exception
5 EHRI_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 PRAGMA RESTRICT_REFERENCES(format_amount,WNDS,WNPS);
54
55 PROCEDURE get_per_sit_perf_appraisal(p_person_id IN NUMBER
56 ,p_effective_date IN DATE
57 ,p_rating_of_record_level OUT NOCOPY VARCHAR2
58 ,p_rating_of_record_pattern OUT NOCOPY VARCHAR2
59 ,p_rating_of_record_period OUT NOCOPY DATE
60 ,p_rating_of_rec_period_starts OUT NOCOPY DATE);
61 PROCEDURE get_suffix_lname(p_last_name IN VARCHAR2,
62 p_report_date IN DATE,
63 p_suffix OUT NOCOPY VARCHAR2,
64 p_lname OUT NOCOPY VARCHAR2);
65
66
67 PROCEDURE populate_ghr_cpdf_temp(p_agency IN VARCHAR2
68 -- 8486208 added new parameter
69 ,p_agency_group IN VARCHAR2
70 ,p_start_date IN DATE
71 ,p_end_date IN DATE
72 ,p_count_only IN BOOLEAN DEFAULT FALSE);
73
74
75
76 --
77 TYPE t_tag_type IS RECORD
78 (tagname VARCHAR2(240),
79 tagvalue VARCHAR2(4000));
80 TYPE t_tags IS TABLE OF t_tag_type INDEX BY BINARY_INTEGER;
81 PROCEDURE WriteTagValues(p_cpdf_dynamic GHR_CPDF_TEMP%rowtype,p_tags OUT NOCOPY t_tags);
82 PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type, p_tags t_tags );
83 PROCEDURE WriteAsciivalues(p_l_fp utl_file.file_type, p_tags t_tags, p_gen_txt_file IN VARCHAR2);
84
85 PROCEDURE ehri_dynamics_main
86 ( errbuf OUT NOCOPY VARCHAR2
87 ,retcode OUT NOCOPY NUMBER
88 ,p_report_name IN VARCHAR2
89 ,p_agency_code IN VARCHAR2
90 ,p_agency_subelement IN VARCHAR2
91 -- 8486208 Added new parameter
92 ,p_agency_group IN VARCHAR2
93 ,p_start_date IN VARCHAR2
94 ,p_end_date IN VARCHAR2
95 ,p_gen_xml_file IN VARCHAR2 DEFAULT 'N'
96 ,p_gen_txt_file IN VARCHAR2 DEFAULT 'Y'
97 );
98
99
100 PROCEDURE WritetoFile (p_input_file_name IN VARCHAR2,
101 p_gen_xml_file IN VARCHAR2,
102 p_gen_txt_file IN VARCHAR2) ;
103
104 END ghr_ehri_dynrpt;