PACKAGE: APPS.RCI_COMPL_ENV_CHG_SUMM_PKG

Source

1 package rci_compl_env_chg_summ_pkg AUTHID CURRENT_USER as
2 /*$Header: rcicmpenvchgsums.pls 120.2 2005/12/09 12:00:39 appldev noship $*/
3 
4 /*** 12.09.2005 npanandi: added below procedure/functions ***/
5 PROCEDURE check_initial_load_setup (
6    x_global_start_date OUT NOCOPY DATE
7   ,x_rci_schema 	   OUT NOCOPY VARCHAR2);
8 
9 FUNCTION get_last_run_date ( p_fact_name VARCHAR2) RETURN DATE;
10 
11 FUNCTION err_mesg (
12    p_mesg      IN VARCHAR2
13   ,p_proc_name IN VARCHAR2 DEFAULT NULL
14   ,p_stmt_id   IN NUMBER DEFAULT -1) RETURN VARCHAR2 ;
15 /*** 12.09.2005 npanandi: ends procedure/functions ***/
16 
17 procedure initial_load(
18    errbuf    IN OUT NOCOPY  VARCHAR2
19   ,retcode   IN OUT NOCOPY  NUMBER);
20 
21 procedure incremental_load(
22    errbuf    IN OUT NOCOPY  VARCHAR2
23   ,retcode   IN OUT NOCOPY  NUMBER);
24 
25 function calculate_risks_chg(   cert_id in number,
26                                 org_id in number,
27                                 process_id in number) return number;
28 
29 function calculate_cntrl_chg(   cert_id in number,
30                                 org_id in number,
31                                 process_id in number) return number;
32 
33 PROCEDURE         get_summ_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
34                           x_custom_sql OUT NOCOPY VARCHAR2,
35                           x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
36 
37 end rci_compl_env_chg_summ_pkg;