PACKAGE: APPS.OZF_QP_DISCOUNTS_PVT

Source

1 PACKAGE OZF_QP_DISCOUNTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvoqpds.pls 120.2 2005/08/24 06:21 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 
13 -- End of Comments
14 -- ===============================================================
15 
16 
17 TYPE qp_discount_rec_type IS RECORD
18 (
19         OZF_QP_DISCOUNT_ID NUMBER
20         , LIST_LINE_ID NUMBER
21         , OFFER_DISCOUNT_LINE_ID NUMBER
22         , START_DATE DATE
23         , END_DATE DATE
24         , OBJECT_VERSION_NUMBER NUMBER
25         , CREATION_DATE DATE
26         , CREATED_BY NUMBER
27         , LAST_UPDATED_BY NUMBER
28         , LAST_UPDATE_DATE DATE
29         , LAST_UPDATE_LOGIN NUMBER
30         );
31 
32 g_miss_qp_disc_rec qp_discount_rec_type := NULL;
33 
34 TYPE qp_discount_tbl_type IS TABLE OF qp_discount_rec_type INDEX BY BINARY_INTEGER;
35 
36 g_miss_qp_prod_tbl qp_discount_tbl_type ;
37 
38 PROCEDURE Create_ozf_qp_discount
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 
49     p_qp_disc_rec               IN    qp_discount_rec_type,
50     x_qp_discount_id             OUT NOCOPY NUMBER
51 );
52 
53 
54 PROCEDURE Update_ozf_qp_discount
55 (
56     p_api_version_number         IN   NUMBER,
57     p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
58     p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
59     p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
60 
61     x_return_status              OUT NOCOPY  VARCHAR2,
62     x_msg_count                  OUT NOCOPY  NUMBER,
63     x_msg_data                   OUT NOCOPY  VARCHAR2,
64 
65     p_qp_disc_rec               IN    qp_discount_rec_type
66 );
67 
68 PROCEDURE Delete_ozf_qp_discount
69 (
70     p_api_version_number         IN   NUMBER,
71     p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
72     p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
73     p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
74 
75     x_return_status              OUT NOCOPY  VARCHAR2,
76     x_msg_count                  OUT NOCOPY  NUMBER,
77     x_msg_data                   OUT NOCOPY  VARCHAR2,
78 
79     p_qp_discount_id             IN NUMBER,
80     p_object_version_number      IN NUMBER
81 );
82 
83 END OZF_QP_DISCOUNTS_PVT;