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
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
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
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: (
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
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
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
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
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
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: );
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);
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
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;