1 PACKAGE RCI_OPEN_REMED_SUMM_PKG AUTHID CURRENT_USER AS
2 /*$Header: rciopnrs.pls 120.5.12000000.1 2007/01/16 20:46:35 appldev ship $*/
3 -- Purpose: Briefly explain the functionality of the package
4 --
5 -- MODIFICATION HISTORY
6 -- Person Date Comments
7 -- --------- ------ ------------------------------------------
8 -- Enter package declarations as shown below
9
10 PROCEDURE get_kpi(
11 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
12 ,p_exp_source_sql out NOCOPY VARCHAR2
13 ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
14
15 PROCEDURE get_open_remediation_result(
16 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
17 ,p_exp_source_sql out NOCOPY VARCHAR2
18 ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
19
20 PROCEDURE get_findings_details(
21 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
22 ,p_exp_source_sql out NOCOPY VARCHAR2
23 ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
24 PROCEDURE get_remediations_details(
25 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
26 ,p_exp_source_sql out NOCOPY VARCHAR2
27 ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
28
29 PROCEDURE open_remed_act_initial_load(
30 errbuf IN OUT NOCOPY VARCHAR2
31 ,retcode IN OUT NOCOPY NUMBER);
32
33 PROCEDURE open_remed_act_increment_load(
34 errbuf IN OUT NOCOPY VARCHAR2
35 ,retcode IN OUT NOCOPY NUMBER);
36
37 /*
38 PROCEDURE open_remed_act_initial_load(
39 errbuf IN OUT NOCOPY VARCHAR2
40 ,retcode IN OUT NOCOPY NUMBER);
41 PROCEDURE open_remed_act_incremental_load(
42 errbuf IN OUT NOCOPY VARCHAR2
43 ,retcode IN OUT NOCOPY NUMBER);
44 */
45
46 PROCEDURE fn_Get_Bucket_Id(age_in_days Number, v_1 out NOCOPY Number, v_2 out NOCOPY Number, v_3 out NOCOPY Number, v_4 out NOCOPY Number);
47
48 FUNCTION get_last_day(date_id NUMBER, type VARCHAR2) RETURN varchar2;
49
50 procedure insert_findings_initial_load(
51 errbuf IN OUT NOCOPY VARCHAR2
52 ,retcode IN OUT NOCOPY NUMBER);
53
54 procedure insert_findings_increment_load(
55 errbuf IN OUT NOCOPY VARCHAR2
56 ,retcode IN OUT NOCOPY NUMBER);
57
58 procedure insert_remeds_initial_load(
59 errbuf IN OUT NOCOPY VARCHAR2
60 ,retcode IN OUT NOCOPY NUMBER);
61
62 procedure insert_remeds_increment_load(
63 errbuf IN OUT NOCOPY VARCHAR2
64 ,retcode IN OUT NOCOPY NUMBER);
65
66 /** 12.16.2005 npanandi: added check_initial_load_setup below **/
67 PROCEDURE check_initial_load_setup (
68 x_global_start_date OUT NOCOPY DATE
69 ,x_rci_schema OUT NOCOPY VARCHAR2);
70
71 /** 12.16.2005 npanandi: added err_mesg below **/
72 FUNCTION err_mesg (
73 p_mesg IN VARCHAR2
74 ,p_proc_name IN VARCHAR2 DEFAULT NULL
75 ,p_stmt_id IN NUMBER DEFAULT -1) RETURN VARCHAR2 ;
76
77 END RCI_OPEN_REMED_SUMM_PKG;