[Home] [Help]
PACKAGE: APPS.CSD_HVR_BI_PVT
Source
1 PACKAGE CSD_HVR_BI_PVT AS
2 /* $Header: csdvhbis.pls 120.0 2005/07/14 17:45:21 vkjain 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_REPAIR_ORDERS_F CONSTANT VARCHAR2(30) := 'CSD_REPAIR_ORDERS_F';
10 C_CSD_MTL_CONSUMED_F CONSTANT VARCHAR2(30) := 'CSD_MTL_CONSUMED_F';
11 C_CSD_RES_CONSUMED_F CONSTANT VARCHAR2(30) := 'CSD_RES_CONSUMED_F';
12
13 -- The following constants represent inventory transaction types.
14 -- Of the many INV txn types only the following ones are used in the package.
15 lc_MTL_TXN_TYPE_COMP_ISSUE CONSTANT NUMBER := 35;
16 lc_MTL_TXN_TYPE_COMP_RETURN CONSTANT NUMBER := 43;
17
18
19 /*--------------------------------------------------*/
20 /* procedure name: get_last_run_date */
21 /* description : procedure used to get */
22 /* the last run date for the ETL */
23 /*--------------------------------------------------*/
24
25 FUNCTION get_last_run_date(p_fact_name VARCHAR2
26 ) RETURN DATE;
27
28 /*--------------------------------------------------*/
29 /* procedure name: initial_load_ro_etl */
30 /* description : procedure to load Repair Orders */
31 /* fact initially. */
32 /*--------------------------------------------------*/
33
34 PROCEDURE initial_load_ro_etl(errbuf IN OUT NOCOPY VARCHAR2,
35 retcode IN OUT NOCOPY VARCHAR2);
36
37 /*--------------------------------------------------*/
38 /* procedure name: incr_load_ro_etl */
39 /* description : procedure to load Repair Orders */
40 /* fact incrementally */
41 /*--------------------------------------------------*/
42 PROCEDURE incr_load_ro_etl(errbuf in out NOCOPY VARCHAR2,
43 retcode in out NOCOPY VARCHAR2);
44
45 /*--------------------------------------------------*/
46 /* procedure name: initial_load_mtl_etl */
47 /* description : procedure to load Materials */
48 /* Consumed fact initially. */
49 /*--------------------------------------------------*/
50
51 PROCEDURE initial_load_mtl_etl(errbuf IN OUT NOCOPY VARCHAR2,
52 retcode IN OUT NOCOPY VARCHAR2);
53
54 /*--------------------------------------------------*/
55 /* procedure name: incr_load_mtl_etl */
56 /* description : procedure to load Materials */
57 /* Consumed fact incrementally */
58 /*--------------------------------------------------*/
59 PROCEDURE incr_load_mtl_etl(errbuf in out NOCOPY VARCHAR2,
60 retcode in out NOCOPY VARCHAR2);
61
62 /*--------------------------------------------------*/
63 /* procedure name: initial_load_res_etl */
64 /* description : procedure to load Resources */
65 /* Consumed fact initially. */
66 /*--------------------------------------------------*/
67
68 PROCEDURE initial_load_res_etl(errbuf IN OUT NOCOPY VARCHAR2,
69 retcode IN OUT NOCOPY VARCHAR2);
70
71 /*--------------------------------------------------*/
72 /* procedure name: incr_load_res_etl */
73 /* description : procedure to load Resources */
74 /* Consumed fact incrementally */
75 /*--------------------------------------------------*/
76 PROCEDURE incr_load_res_etl(errbuf in out NOCOPY VARCHAR2,
77 retcode in out NOCOPY VARCHAR2);
78
79 /*--------------------------------------------------*/
80 /* procedure name: Initial_Load */
81 /* description : procedure to load Repair Orders */
82 /* Resource and Material facts */
83 /* initially. */
84 /*--------------------------------------------------*/
85 PROCEDURE Initial_Load(errbuf IN OUT NOCOPY VARCHAR2,
86 retcode IN OUT NOCOPY varchar2 );
87
88 /*--------------------------------------------------*/
89 /* procedure name: Incr_Load */
90 /* description : procedure to load */
91 /* fact tables incrementally */
92 /*--------------------------------------------------*/
93 PROCEDURE Incr_Load(errbuf in out NOCOPY VARCHAR2,
94 retcode in out NOCOPY VARCHAR2);
95
96 /*--------------------------------------------------*/
97 /* procedure name: Hvr_Bi_Driver_Main */
98 /* description : procedure to load */
99 /* fact tables incrementally */
100 /*--------------------------------------------------*/
101 PROCEDURE Hvr_Bi_Driver_Main (errbuf IN OUT NOCOPY VARCHAR2,
102 retcode IN OUT NOCOPY VARCHAR2,
103 p_refresh_type IN VARCHAR2 );
104
105 END CSD_HVR_BI_PVT;