[Home] [Help]
PACKAGE: APPS.OPI_DBI_COGS_OPM_PKG
Source
1 PACKAGE opi_dbi_cogs_opm_pkg AUTHID CURRENT_USER AS
2 /*$Header: OPIDECOGSPS.pls 115.1 2004/03/10 22:11:01 weizhou noship $ */
3
4 /**************************************************
5 * Package Level Constants
6 **************************************************/
7
8 g_ERROR CONSTANT NUMBER := -1; -- concurrent manager error code
9 g_WARNING CONSTANT NUMBER := 1; -- concurrent manager warning code
10 g_OK CONSTANT NUMBER := 0; -- concurrent manager success code
11
12 /**************************************************
13 * Package Level User Defined Exceptions for functions
14 **************************************************/
15
16
17
18 /**************************************************
19 * Package Level User Defined Exceptions for ETL stages
20 **************************************************/
21
22 /* complete_refresh_OPM_margin
23
24 Wrapper routine for the initial load of cogs for OPM ETL.
25
26 Parameters:
27 retcode - 0 on successful completion, -1 on error and 1 for warning.
28 errbuf - empty on successful completion, message on error or warning
29 p_degree - Is it still needed?
30
31 History:
32 Date Author Action
33 04/03/04 Vedhanarayanan G Defined specification.
34
35 */
36 PROCEDURE complete_refresh_OPM_margin (errbuf in out NOCOPY VARCHAR2,
37 retcode in out NOCOPY VARCHAR2,
38 p_degree in NUMBER DEFAULT 0);
39
40
41 /* refresh_OPM_margin
42
43 Wrapper routine for the incremental load of cogs for OPM ETL.
44
45 Parameters:
46 retcode - 0 on successful completion, -1 on error and 1 for warning.
47 errbuf - empty on successful completion, message on error or warning
48
49 History:
50 Date Author Action
51 04/03/04 Vedhanarayanan G Defined specification.
52
53 */
54 PROCEDURE refresh_OPM_margin (errbuf in out NOCOPY VARCHAR2,
55 retcode in out NOCOPY VARCHAR2);
56
57 END opi_dbi_cogs_opm_pkg;