PACKAGE: APPS.OZF_OFFER_ADJ_PRODUCTS_PVT

Source

1 PACKAGE OZF_OFFER_ADJ_PRODUCTS_PVT AS
2 /* $Header: ozfvoadps.pls 120.5 2005/08/25 06:41 rssharma noship $ */
3 
4 TYPE offer_adj_prod_rec IS record
5 (
6  offer_adjustment_product_id     NUMBER
7  , offer_adjustment_id             NUMBER
8  , offer_discount_line_id          NUMBER
9  , off_discount_product_id         NUMBER
10  , product_context                 VARCHAR2(30)
11  , product_attribute               VARCHAR2(30)
12  , product_attr_value              VARCHAR2(240)
13  , excluder_flag                   VARCHAR2(1)
14  , apply_discount_flag             VARCHAR2(1)
15  , include_volume_flag             VARCHAR2(1)
16  , object_version_number           NUMBER
17  , last_update_date                DATE
18  , last_updated_by                 NUMBER
19  , creation_date                   DATE
20  , created_by                      NUMBER
21  , last_update_login               NUMBER
22 );
23 
24 PROCEDURE CREATE_OFFER_ADJ_PRODUCT
25 (
26     p_api_version_number         IN   NUMBER,
27     p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
28     p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
29     p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
30 
31     x_return_status              OUT NOCOPY  VARCHAR2,
32     x_msg_count                  OUT NOCOPY  NUMBER,
33     x_msg_data                   OUT NOCOPY  VARCHAR2,
34     p_adj_prod                   IN offer_adj_prod_rec,
35     px_offer_adjustment_product_id OUT NOCOPY NUMBER
36 );
37 
38 PROCEDURE UPDATE_OFFER_ADJ_PRODUCT
39 (
40     p_api_version_number         IN   NUMBER,
41     p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
42     p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
43     p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
44 
45     x_return_status              OUT NOCOPY  VARCHAR2,
46     x_msg_count                  OUT NOCOPY  NUMBER,
47     x_msg_data                   OUT NOCOPY  VARCHAR2,
48     p_adj_prod_rec               IN offer_adj_prod_rec
49 
50 );
51 PROCEDURE DELETE_OFFER_ADJ_PRODUCT
52 (
53     p_api_version_number         IN   NUMBER,
54     p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
55     p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
56     p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
57 
58     x_return_status              OUT NOCOPY  VARCHAR2,
59     x_msg_count                  OUT NOCOPY  NUMBER,
60     x_msg_data                   OUT NOCOPY  VARCHAR2,
61 
62     p_offer_adjustment_product_id IN NUMBER,
63     p_object_version_number       IN NUMBER
64 );
65 
66 END OZF_OFFER_ADJ_PRODUCTS_PVT;