PACKAGE: APPS.OPI_DBI_WIP_SCRAP_INIT_PKG

Source

1 PACKAGE opi_dbi_wip_scrap_init_pkg AUTHID CURRENT_USER AS
2 /*$Header: OPIDSCRAPIS.pls 115.0 2003/06/11 19:59:56 digupta noship $ */
3 
4 /*  Wrapper routine for OPI WIP scrap data extraction for initial load
5     which will be visible to the user.
6 */
7 PROCEDURE collect_wip_scrap_init (errbuf OUT NOCOPY VARCHAR2,
8                                   retcode OUT NOCOPY NUMBER);
9 
10 
11 /*  Common utilities for scrap initial and incremental load.
12 */
13 PROCEDURE compute_wip_scrap_conv_rates (errbuf OUT NOCOPY VARCHAR2,
14                                         retcode OUT NOCOPY NUMBER,
15                                         p_opi_schema IN VARCHAR2) ;
16 
17 
18 FUNCTION check_global_setup
19     RETURN BOOLEAN;
20 
21 
22 
23 /* refresh the scrap related MVs
24     Refresh the 3 MV's in this order:
25     1. OPI_COMP_SCR_MV
26     2. OPI_PROD_SCR_MV
27     3. OPI_SCRAP_SUM_MV
28 */
29 PROCEDURE refresh (errbuf OUT NOCOPY VARCHAR2,
30                    retcode OUT NOCOPY NUMBER);
31 
32 
33 
34 END opi_dbi_wip_scrap_init_pkg;