1 PACKAGE ghr_cpdf_ehris AUTHID CURRENT_USER AS
2 /* $Header: ghrehris.pkh 120.6.12020000.1 2012/06/29 04:37:41 appldev ship $ */
3
4 CPDF_STATRPT_ERROR EXCEPTION;
5 PROCEDURE initialize_record;
6 PROCEDURE cleanup_table;
7 PROCEDURE get_from_history_asgnei
8 (
9 p_sr_assignment_id IN NUMBER
10 ,p_sr_report_date IN DATE
11 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
12 );
13 PROCEDURE get_from_history_people
14 (
15 p_sr_person_id IN NUMBER
16 ,p_sr_report_date IN DATE
17 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
18 );
19 PROCEDURE get_from_history_ancrit
20 (
21 p_sr_person_id IN NUMBER
22 ,p_sr_report_date IN DATE
23 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
24 );
25 PROCEDURE get_from_history_peopei
26 (
27 p_sr_person_id IN NUMBER
28 ,p_sr_report_date IN DATE
29 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
30 );
31
32 PROCEDURE get_from_per_wrkadd --Bug# 4725292
33 (
34 p_sr_person_id IN NUMBER
35 ,p_sr_report_date IN DATE
36 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
37 );
38 PROCEDURE get_from_history_posiei
39 (
40 p_sr_position_id IN NUMBER
41 ,p_sr_report_date IN DATE
42 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
43 );
44 PROCEDURE get_from_history_gradef
45 (
46 p_sr_grade_id IN NUMBER
47 ,p_sr_report_date IN DATE
48 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
49 );
50 PROCEDURE get_from_history_jobdef
51 (
52 p_sr_job_id IN NUMBER
53 ,p_sr_report_date IN DATE
54 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
55 );
56 PROCEDURE get_from_history_dutsta
57 (
58 p_sr_location_id IN NUMBER
59 ,p_sr_report_date IN DATE
60 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
61 );
62 PROCEDURE get_from_history_payele
63 (
64 p_sr_assignment_id IN NUMBER
65 ,p_sr_report_date IN DATE
66 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
67 );
68 PROCEDURE calc_is_foreign_duty_station
69 (p_report_date IN DATE
70 );
71 PROCEDURE get_suffix_lname(p_last_name in varchar2,
72 p_report_date in date,
73 p_suffix out NOCOPY varchar2,
74 p_lname out NOCOPY varchar2);
75
76 PROCEDURE insert_row;
77 PROCEDURE purge_suppression;
78
79 PROCEDURE populate_ghr_cpdf_temp (p_agency IN VARCHAR2,
80 -- 8486208 added new parameter
81 p_agency_group IN VARCHAR2,
82 p_report_date IN DATE,
83 p_count_only IN BOOLEAN);
84
85 TYPE t_tag_type IS RECORD
86 (tagname VARCHAR2(240),
87 tagvalue VARCHAR2(4000));
88 TYPE t_tags IS TABLE OF t_tag_type INDEX BY BINARY_INTEGER;
89 PROCEDURE WriteTagValues(p_cpdf_status GHR_CPDF_TEMP%rowtype,p_tags OUT NOCOPY t_tags);
90 PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type, p_tags t_tags );
91 PROCEDURE WriteAsciivalues(p_l_fp utl_file.file_type, p_tags t_tags,p_gen_txt_file IN VARCHAR2);
92
93 PROCEDURE ehri_status_main
94 ( errbuf OUT NOCOPY VARCHAR2
95 ,retcode OUT NOCOPY NUMBER
96 ,p_report_name IN VARCHAR2
97 ,p_agency_code IN VARCHAR2
98 ,p_agency_subelement IN VARCHAR2
99 -- 8486208 Added new parameter
100 ,p_agency_group IN VARCHAR2
101 ,p_report_date IN VARCHAR2
102 ,p_gen_xml_file IN VARCHAR2 DEFAULT 'N'
103 ,p_gen_txt_file IN VARCHAR2 DEFAULT 'Y'
104 );
105
106 PROCEDURE WritetoFile (p_input_file_name VARCHAR2
107 ,p_gen_xml_file IN VARCHAR2
108 ,p_gen_txt_file IN VARCHAR2);
109
110 g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
111 g_agency VARCHAR2(04);
112 g_report_date DATE;
113 g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
114 g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
115 g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
116 g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
117 g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
118 g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
119 g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
120 g_business_group_id PER_ASSIGNMENTS_F.business_group_id%TYPE;
121 -- Begin Bug# 4753092
122 g_message_name ghr_process_log.message_name%type;
123 -- End Bug# 4753092
124 END ghr_cpdf_ehris;