1 PACKAGE ghr_cpdf_ehris AS
2 /* $Header: ghrehris.pkh 120.3.12010000.2 2008/08/05 15:12:26 ubhat 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 p_report_date IN DATE,
81 p_count_only IN BOOLEAN);
82
83 TYPE t_tag_type IS RECORD
84 (tagname VARCHAR2(240),
85 tagvalue VARCHAR2(4000));
86 TYPE t_tags IS TABLE OF t_tag_type INDEX BY BINARY_INTEGER;
87 PROCEDURE WriteTagValues(p_cpdf_status GHR_CPDF_TEMP%rowtype,p_tags OUT NOCOPY t_tags);
88 PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type, p_tags t_tags );
89 PROCEDURE WriteAsciivalues(p_l_fp utl_file.file_type, p_tags t_tags,p_gen_txt_file IN VARCHAR2);
90
91 PROCEDURE ehri_status_main
92 ( errbuf OUT NOCOPY VARCHAR2
93 ,retcode OUT NOCOPY NUMBER
94 ,p_report_name IN VARCHAR2
95 ,p_agency_code IN VARCHAR2
96 ,p_agency_subelement IN VARCHAR2
97 ,p_report_date IN VARCHAR2
98 ,p_gen_xml_file IN VARCHAR2 DEFAULT 'N'
99 ,p_gen_txt_file IN VARCHAR2 DEFAULT 'Y'
100 );
101
102 PROCEDURE WritetoFile (p_input_file_name VARCHAR2
103 ,p_gen_xml_file IN VARCHAR2
104 ,p_gen_txt_file IN VARCHAR2);
105
106 g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
107 g_agency VARCHAR2(04);
108 g_report_date DATE;
109 g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
110 g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
111 g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
112 g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
113 g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
114 g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
115 g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
116 g_business_group_id PER_ASSIGNMENTS_F.business_group_id%TYPE;
117 -- Begin Bug# 4753092
118 g_message_name ghr_process_log.message_name%type;
119 -- End Bug# 4753092
120 END ghr_cpdf_ehris;