PACKAGE: APPS.RCI_PROC_CERT_SUMM_PKG

Source

1 PACKAGE RCI_PROC_CERT_SUMM_PKG AUTHID CURRENT_USER as
2 /*$Header: rciproccerts.pls 120.7.12000000.1 2007/01/16 20:46:44 appldev ship $*/
3 
4 function get_default_year return varchar2;
5 PROCEDURE get_kpi(
6    p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
7   ,p_exp_source_sql     out NOCOPY VARCHAR2
8   ,p_exp_source_output  out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
9 
10 PROCEDURE get_proc_cert_result(
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_proc_cert_summary(
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 proc_cert_initial_load(
21    errbuf    IN OUT NOCOPY  VARCHAR2
22   ,retcode   IN OUT NOCOPY  NUMBER);
23 
24 PROCEDURE proc_cert_incremental_load(
25    errbuf    IN OUT NOCOPY  VARCHAR2
26   ,retcode   IN OUT NOCOPY  NUMBER);
27 /*todo remove this later
28 TYPE TIME_DIMENSIONS_RECORD IS RECORD
29 (
30 	 period_year number(15)
31 	 ,period_num number(15)
32 	 ,quarter_num number(15)
33 	 ,ent_period_id number
34 	 ,ent_qtr_id number
35 	 ,ent_year_id number
36 	 ,report_date_julian number
37 );
38 TYPE CERT_DETAIL_RECORD IS RECORD
39 (
40 	 cert_id amw_certification_b.certification_id%type
41      ,cert_status amw_certification_b.certification_status%type
42      ,cert_type amw_certification_b.certification_type%type
43 );
44 */
45 
46 PROCEDURE update_proc_cert_table(
47     p_process_id IN NUMBER,
48     p_org_id IN NUMBER,
49     p_cert_id IN NUMBER);
50 --todo remove this later
51 --    cert_rec IN CERT_DETAIL_RECORD,time_rec IN TIME_DIMENSIONS_RECORD);
52 
53 PROCEDURE get_proc_cert_details(
54    p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
55   ,p_exp_source_sql     out NOCOPY VARCHAR2
56   ,p_exp_source_output  out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
57 
58 END RCI_PROC_CERT_SUMM_PKG;
59