1 PACKAGE OZF_ACTIVITY_DENORM_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvacds.pls 120.2 2006/03/30 13:38:05 gramanat noship $ */
3
4 TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5 TYPE char_tbl_type IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
6
7 PROCEDURE prepare_customer_full_load;
8
9 PROCEDURE prepare_product_full_load;
10
11 PROCEDURE create_customer_indexes;
12
13 PROCEDURE create_product_indexes;
14
15 PROCEDURE refresh_denorm(
16 ERRBUF OUT NOCOPY VARCHAR2,
17 RETCODE OUT NOCOPY VARCHAR2,
18 p_increment_flag IN VARCHAR2 := 'N',
19 p_offer_id IN NUMBER
20 );
21
22 END OZF_ACTIVITY_DENORM_PVT;