1 PACKAGE ghr_462 AUTHID CURRENT_USER AS
2 /* $Header: gh462sum.pkh 115.2 2003/07/31 00:13:45 sumarimu noship $ */
3 --
4 PROCEDURE populate_sum(
5 p_request_id in number
6 , p_agency_code in varchar2
7 , p_fiscal_year in number
8 , p_from_date in varchar2
9 , p_to_date in varchar2
10 , p_output_fname out nocopy varchar2);
11
12 TYPE XMLRec IS RECORD(
13 TagName VARCHAR2(50),
14 TagValue VARCHAR2(50));
15
16 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
17 vXMLTable tXMLTable;
18 vCtr NUMBER;
19
20 TYPE P4Matrix IS RECORD(
21 claims VARCHAR2(30),
22 bases VARCHAR2(30),
23 basevalues VARCHAR2(30),
24 fieldname VARCHAR2(30));
25
26 TYPE t_P4Matrix IS TABLE OF P4Matrix INDEX BY BINARY_INTEGER;
27 v_P4Matrix t_P4Matrix;
28
29
30 TYPE r_temp IS RECORD(
31 complaint_id NUMBER(15));
32
33 TYPE t_temp IS TABLE OF r_temp INDEX BY BINARY_INTEGER;
34 v_temp t_temp;
35
36
37 -- Procedure to Populate Part1- Precomplaint phase
38 PROCEDURE populate_part1(
39 p_from_date in date,
40 p_to_date in date,
41 p_agency_code in varchar2);
42
43 -- Procedure to populate Part 2- Formal Complaint phase
44 PROCEDURE populate_part2(
45 p_from_date in date,
46 p_to_date in date,
47 p_agency_code in varchar2);
48
49 -- Procedure to populate Part 4- Bases and Issues
50 PROCEDURE populate_part4(
51 p_from_date in date,
52 p_to_date in date,
53 p_agency_code in varchar2);
54
55 -- Procedure to populate Part 5- Summary of Closures by statute
56 PROCEDURE populate_part5(
57 p_from_date in date,
58 p_to_date in date,
59 p_agency_code in varchar2);
60
61 -- Procedure to populate Part 6- Summary of Closures by Category
62 PROCEDURE populate_part6(
63 p_from_date in date,
64 p_to_date in date,
65 p_agency_code in varchar2);
66
67 -- Procedure to populate Part 7- Summary of Complaints closed with corrective action
68 PROCEDURE populate_part7(
69 p_from_date in date,
70 p_to_date in date,
71 p_agency_code in varchar2);
72
73 -- Procedure to populate Part 8- Summary of Pending Complaints
74 PROCEDURE populate_part8(
75 p_from_date in date,
76 p_to_date in date,
77 p_agency_code in varchar2);
78
79 -- Procedure to populate Part 10- Summary of ADR Program activities - Precomplaint phase
80 PROCEDURE populate_part10(
81 p_from_date in date,
82 p_to_date in date,
83 p_agency_code in varchar2);
84
85 -- Procedure to populate Part 11- Summary of ADR Program activities - Formal Complaint phase
86 PROCEDURE populate_part11(
87 p_from_date in date,
88 p_to_date in date,
89 p_agency_code in varchar2);
90
91 -- Procedure to Write into XML file
92 PROCEDURE WritetoXML(
93 p_request_id in number,
94 p_agency_code in varchar,
95 p_fiscal_year in number,
96 p_from_date in date,
97 p_to_date in date,
98 p_output_fname out nocopy varchar2);
99
100 PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2);
101
102 PROCEDURE PopulatePart4Matrix;
103 END ghr_462;
104
105
[Home] [Help]