1 PACKAGE ghr_compl_agency_costs_pkg AUTHID CURRENT_USER AS
2 /* $Header: ghcstpkg.pkh 120.0 2005/05/29 03:05:23 appldev noship $ */
3
4 PROCEDURE get_entry_totals (p_complaint_id IN NUMBER
5 ,p_phase IN VARCHAR2
6 ,p_stage IN VARCHAR2
7 ,p_category IN VARCHAR2
8 ,p_phase_total OUT NOCOPY NUMBER
9 ,p_stage_total OUT NOCOPY NUMBER
10 ,p_category_total OUT NOCOPY NUMBER);
11
12 PROCEDURE get_summary_totals (p_complaint_id IN NUMBER
13 ,p_info_inquiry_info OUT NOCOPY NUMBER
14 ,p_info_inquiry_pre OUT NOCOPY NUMBER
15 ,p_info_inquiry_formal OUT NOCOPY NUMBER
16 ,p_pre_complaint_info OUT NOCOPY NUMBER
17 ,p_pre_complaint_pre OUT NOCOPY NUMBER
18 ,p_pre_complaint_formal OUT NOCOPY NUMBER
19 ,p_formal_info OUT NOCOPY NUMBER
20 ,p_formal_pre OUT NOCOPY NUMBER
21 ,p_formal_formal OUT NOCOPY NUMBER
22 ,p_investigation_info OUT NOCOPY NUMBER
23 ,p_investigation_pre OUT NOCOPY NUMBER
24 ,p_investigation_formal OUT NOCOPY NUMBER
25 ,p_hearing_info OUT NOCOPY NUMBER
26 ,p_hearing_pre OUT NOCOPY NUMBER
27 ,p_hearing_formal OUT NOCOPY NUMBER
28 ,p_fad_info OUT NOCOPY NUMBER
29 ,p_fad_pre OUT NOCOPY NUMBER
30 ,p_fad_formal OUT NOCOPY NUMBER
31 ,p_faa_info OUT NOCOPY NUMBER
32 ,p_faa_pre OUT NOCOPY NUMBER
33 ,p_faa_formal OUT NOCOPY NUMBER
34 ,p_appellate_info OUT NOCOPY NUMBER
35 ,p_appellate_pre OUT NOCOPY NUMBER
36 ,p_appellate_formal OUT NOCOPY NUMBER
37 ,p_civil_action_info OUT NOCOPY NUMBER
38 ,p_civil_action_pre OUT NOCOPY NUMBER
39 ,p_civil_action_formal OUT NOCOPY NUMBER
40 ,p_other_info OUT NOCOPY NUMBER
41 ,p_other_pre OUT NOCOPY NUMBER
42 ,p_other_formal OUT NOCOPY NUMBER
43 ,p_amendment_info OUT NOCOPY NUMBER
44 ,p_amendment_pre OUT NOCOPY NUMBER
45 ,p_amendment_formal OUT NOCOPY NUMBER
46 ,p_total_benefits_received OUT NOCOPY NUMBER);
47
48
49 END ghr_compl_agency_costs_pkg;
[Home] [Help]