1 PACKAGE ghr_cpdf_statrpt AS
2 /* $Header: ghrcpdfs.pkh 120.1.12000000.2 2007/03/01 07:22:25 vmididho noship $ */
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 PROCEDURE get_from_history_posiei
32 (
33 p_sr_position_id IN NUMBER
34 ,p_sr_report_date IN DATE
35 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
36 );
37 PROCEDURE get_from_history_gradef
38 (
39 p_sr_grade_id IN NUMBER
40 ,p_sr_report_date IN DATE
41 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
42 );
43 PROCEDURE get_from_history_jobdef
44 (
45 p_sr_job_id IN NUMBER
46 ,p_sr_report_date IN DATE
47 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
48 );
49 PROCEDURE get_from_history_dutsta
50 (
51 p_sr_location_id IN NUMBER
52 ,p_sr_report_date IN DATE
53 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
54 );
55 PROCEDURE get_from_history_payele
56 (
57 p_sr_assignment_id IN NUMBER
58 ,p_sr_report_date IN DATE
59 ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
60 );
61 PROCEDURE calc_is_foreign_duty_station
62 (p_report_date IN DATE
63 );
64 PROCEDURE get_suffix_lname(p_last_name IN VARCHAR2,
65 p_report_date IN DATE,
66 p_suffix OUT NOCOPY VARCHAR2,
67 p_lname OUT NOCOPY VARCHAR2);
68 PROCEDURE insert_row;
69 PROCEDURE purge_suppression;
70 PROCEDURE populate_ghr_cpdf_temp (p_agency IN VARCHAR2,
71 p_report_date IN DATE);
72
73 g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
74 g_agency VARCHAR2(04);
75 g_report_date DATE;
76 g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77 g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78 g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79 g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80 g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
81 g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
82 g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
83 --Begin Bug# 4168162
84 g_message_name ghr_process_log.message_name%type;
85 --End Bug# 4168162
86
87 END ghr_cpdf_statrpt;