PACKAGE: APPS.OPI_DBI_INV_CCA_OPM_PKG

Source

1 PACKAGE opi_dbi_inv_cca_opm_pkg AS
2 /*$Header: OPIDEICCAPS.pls 120.1 2005/08/02 04:54:06 visgupta noship $ */
3 
4 /**************************************************
5 * Package Level Constants
6 **************************************************/
7 
8 C_PRER12_SOURCE CONSTANT NUMBER := 3;
9 C_OPM_CCA_MARKER CONSTANT VARCHAR2(6) := 'OPMCCA';
10 C_CCA_MARKER CONSTANT VARCHAR2(3) := 'CCA';
11 C_PKG_NAME CONSTANT VARCHAR2 (50) := 'opi_dbi_inv_cca_opm_pkg';
12 C_ERRBUF_SIZE CONSTANT NUMBER := 300;
13 
14 /**************************************************
15 * Public Procedures
16 **************************************************/
17 
18 /* run_initial_load_opm
19 
20     Wrapper routine for the initial load of the cycle count accuracy ETL.
21 
22     Parameters:
23     retcode - 0 on successful completion, -1 on error and 1 for warning.
24     errbuf - empty on successful completion, message on error or warning
25     p_degree  - Is it still needed?
26 
27     History:
28     Date        Author              Action
29     04/03/04    Vedhanarayanan G    Defined specification.
30 
31 */
32 PROCEDURE run_initial_load_opm (errbuf    in out NOCOPY  VARCHAR2,
33                                 retcode   in out NOCOPY  NUMBER);
34 
35 
36 /* get_unit_cost
37 
38    Wrapper function for gmf_cmcomman.unit_cost with parallel enabled.
39 
40    History:
41    Date        Author              Action
42    03/06/04    Vedhanarayanan G    Defined specification.
43 
44 */
45 FUNCTION get_unit_cost(p_item_id IN NUMBER,
46                        p_whse_code IN VARCHAR2,
47                        p_orgn_code IN VARCHAR2,
48                        p_creation_date IN DATE)
49          RETURN NUMBER
50          PARALLEL_ENABLE;
51 
52 END opi_dbi_inv_cca_opm_pkg;