DBA Data[Home] [Help]

PACKAGE: APPS.OZF_ACTIVITY_DENORM_PVT

Source


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;