PACKAGE: APPS.OZF_CHECK_DUP_PROD_PVT

Source

1 PACKAGE  OZF_CHECK_DUP_PROD_PVT AS
2 /* $Header: ozfvcdps.pls 120.1 2005/10/02 00:53 julou noship $ */
3 
4 --------------------------------------------------------------------
5 -- PROCEDURE
6 --    denorm_products
7 --
8 -- PURPOSE
9 --    Refreshes volume offerproduct denorm table ozf_vo_products_temp.
10 --
11 -- PARAMETERS
12 --    p_offer_d: identifier of the offer
13 --
14 -- DESCRIPTION
15 --  This procedure calls get_sql, builds SQL statment
16 ----------------------------------------------------------------------
17 PROCEDURE denorm_vo_products(
18   p_api_version      IN  NUMBER,
19   p_init_msg_list    IN  VARCHAR2,
20   p_commit           IN  VARCHAR2,
21   p_offer_id         IN  NUMBER,
22   x_return_status    OUT NOCOPY VARCHAR2,
23   x_msg_count        OUT NOCOPY NUMBER,
24   x_msg_data         OUT NOCOPY VARCHAR2,
25   x_product_stmt     OUT NOCOPY VARCHAR2
26 );
27 
28 --------------------------------------------------------------------
29 -- PROCEDURE
30 --   check_dup_prod
31 --
32 -- PURPOSE
33 --   check duplicate products upon volume offer activation.
34 --
35 -- PARAMETERS
36 --    p_offer_d: identifier of the offer
37 --
38 -- DESCRIPTION
39 --  This procedure calls denorm_products to builds SQL statment and denorm volume offer products
40 ----------------------------------------------------------------------
41 PROCEDURE check_dup_prod(
42   x_return_status OUT NOCOPY  VARCHAR2,
43   x_msg_count     OUT NOCOPY  NUMBER,
44   x_msg_data      OUT NOCOPY  VARCHAR2,
45   p_offer_id      IN  NUMBER
46 );
47 
48 END OZF_CHECK_DUP_PROD_PVT;