PACKAGE: APPS.CSD_RETURNS_BI_PVT

Source

1 PACKAGE CSD_RETURNS_BI_PVT AUTHID CURRENT_USER AS
2 /* $Header: csdvrbis.pls 120.2 2011/02/23 22:27:25 swai noship $ */
3 
4   -- Global Varaiables
5   C_ERROR       CONSTANT VARCHAR2(1) := '2'; -- concurrent manager error code
6   C_WARNING     CONSTANT VARCHAR2(1) := '1'; -- concurrent manager warning code
7   C_OK          CONSTANT VARCHAR2(1) := '0'; -- concurrent manager success code
8 
9   C_CSD_RETURNS_BI_RCV_TXNS_F CONSTANT VARCHAR2(30) := 'CSD_RETURNS_BI_RCV_TXNS_F';
10   C_CSD_RETURNS_BI_MTL_TXNS_F CONSTANT VARCHAR2(30) := 'CSD_RETURNS_BI_MTL_TXNS_F';
11   C_CSD_RETURNS_BI_SHP_TXNS_F CONSTANT VARCHAR2(30) := 'CSD_RETURNS_BI_SHP_TXNS_F';
12 
13 /*--------------------------------------------------*/
14 /* procedure name: get_last_run_date                */
15 /* description   : procedure used to get            */
16 /*                 the last run date for the ETL    */
17 /*--------------------------------------------------*/
18 
19   FUNCTION get_last_run_date(p_fact_name VARCHAR2
20                              ) RETURN DATE;
21 
22 /*--------------------------------------------------*/
23 /* procedure name: initial_load_rcvtxns_etl         */
24 /* description   : procedure to load Receiving Txn  */
25 /*                 fact initially.                  */
26 /*--------------------------------------------------*/
27 
28   PROCEDURE initial_load_rcvtxns_etl(errbuf  IN OUT NOCOPY VARCHAR2,
29                                 retcode IN OUT NOCOPY VARCHAR2);
30 
31 /*--------------------------------------------------*/
32 /* swai: 12.2                                       */
33 /* procedure name: initial_load_shptxns_etl         */
34 /* description   : procedure to load Shipping Txn   */
35 /*                 fact initially.                  */
36 /*--------------------------------------------------*/
37 
38   PROCEDURE initial_load_shptxns_etl(errbuf  IN OUT NOCOPY VARCHAR2,
39                                 retcode IN OUT NOCOPY VARCHAR2);
40 
41 
42 /*--------------------------------------------------*/
43 /* procedure name: initial_load_mtltxns_etl         */
44 /* description   : procedure to load  Material Txn  */
45 /*                 fact initially.                  */
46 /*--------------------------------------------------*/
47 
48   PROCEDURE initial_load_mtltxns_etl(errbuf  IN OUT NOCOPY VARCHAR2,
49                                 retcode IN OUT NOCOPY VARCHAR2);
50 
51 /*--------------------------------------------------*/
52 /* procedure name: Initial_Load                     */
53 /* description   : procedure to load All Returns    */
54 /*                 Dashboard facts                  */
55 /*                 initially.                       */
56 /*--------------------------------------------------*/
57   PROCEDURE Initial_Load(errbuf  IN OUT NOCOPY VARCHAR2,
58                          retcode IN OUT NOCOPY varchar2,
59                          p_data_set IN VARCHAR2 := 'ALL');
60 
61 /*--------------------------------------------------*/
62 /* procedure name: Returns_Bi_Driver_Main           */
63 /* description   : procedure to load                */
64 /*                 fact  tables                     */
65 /*--------------------------------------------------*/
66 PROCEDURE Returns_Bi_Driver_Main (errbuf  IN OUT NOCOPY VARCHAR2,
67                                 retcode IN OUT NOCOPY VARCHAR2,
68                                 p_data_set IN VARCHAR2 := 'ALL');
69 
70 END CSD_RETURNS_BI_PVT;