PACKAGE: APPS.RCI_SIG_ACCT_EVAL_SUMM_PKG

Source

1 PACKAGE RCI_SIG_ACCT_EVAL_SUMM_PKG AUTHID CURRENT_USER AS
2 /*$Header: rcisgacs.pls 120.5.12000000.1 2007/01/16 20:46:47 appldev ship $*/
3 
4 PROCEDURE get_kpi(
5    p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
6   ,p_exp_source_sql     out NOCOPY VARCHAR2
7   ,p_exp_source_output  out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
8 
9 PROCEDURE get_sig_acct_eval_details(
10    p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
11   ,p_exp_source_sql     out NOCOPY VARCHAR2
12   ,p_exp_source_output  out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
13 
14 FUNCTION get_risk_count(p_org_id number) return number;
15 FUNCTION get_control_count(p_org_id number) return number;
16 FUNCTION get_latest_engagement(p_org_id number) return varchar2;
17 PROCEDURE get_org_details(
18    p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
19   ,p_exp_source_sql     out NOCOPY VARCHAR2
20   ,p_exp_source_output  out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
21 
22 PROCEDURE get_sig_acct_details(
23    p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
24   ,p_exp_source_sql     out NOCOPY VARCHAR2
25   ,p_exp_source_output  out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
26 
27 PROCEDURE get_sig_acct_eval_result(
28    p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
29   ,p_exp_source_sql     out NOCOPY VARCHAR2
30   ,p_exp_source_output  out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
31 
32 PROCEDURE get_sig_acct_eval_summ_result(
33    p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
34   ,p_exp_source_sql     out NOCOPY VARCHAR2
35   ,p_exp_source_output  out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
36 
37 PROCEDURE sig_acct_incremental_load(
38    errbuf    IN OUT NOCOPY  VARCHAR2
39   ,retcode   IN OUT NOCOPY  NUMBER);
40 
41 PROCEDURE sig_acct_initial_load(
42    errbuf    IN OUT NOCOPY  VARCHAR2
43   ,retcode   IN OUT NOCOPY  NUMBER);
44 
45 /*todo 01/06/2005 remove this--These 3 procedures from amwvfscb.pls
46 Procedure CountOrgsIneffCtrl_finitem
47     (P_STATEMENT_GROUP_ID in number, P_FINANCIAL_STATEMENT_ID in number,
48     P_FINANCIAL_ITEM_ID in number , p_org_with_ineffective_ctrls  OUT NOCOPY  number);
49 Procedure CountUnmittigatedRisk_finitem
50     (P_STATEMENT_GROUP_ID in number, P_FINANCIAL_STATEMENT_ID in number,
51     P_FINANCIAL_ITEM_ID in number , p_unmitigated_risks  OUT NOCOPY  number);
52 Procedure CountIneffectiveCtrls_finitem
53     (P_STATEMENT_GROUP_ID in number, P_FINANCIAL_STATEMENT_ID in number,
54     P_FINANCIAL_ITEM_ID in number , p_ineffective_controls  OUT NOCOPY  number);
55 */
56 FUNCTION get_unmiti_risks(p_cert_id number, p_org_id number) return number;
57 FUNCTION get_ineff_ctrls(p_cert_id number, p_org_id number) return number;
58 FUNCTION get_ineff_procs(p_cert_id number, p_org_id number) return number;
59 PROCEDURE get_org_def_details(
60    p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
61   ,p_exp_source_sql     out NOCOPY VARCHAR2
62   ,p_exp_source_output  out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
63 END RCI_SIG_ACCT_EVAL_SUMM_PKG;
64