DBA Data[Home] [Help]

PACKAGE: APPS.OZF_OFFER_ADJ_NEW_PRODUCTS_PKG

Source


1 PACKAGE OZF_OFFER_ADJ_NEW_PRODUCTS_PKG AS
2 /* $Header: ozftanps.pls 120.0 2006/03/30 13:46:55 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          OZF_OFFER_ADJ_NEW_PRODUCTS_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 PROCEDURE Insert_Row(
17           px_offer_adj_new_product_id   IN OUT NOCOPY  NUMBER,
18           p_offer_adj_new_line_id    NUMBER,
19           p_offer_adjustment_id      NUMBER,
20           p_product_context    VARCHAR2,
21           p_product_attribute    VARCHAR2,
22           p_product_attr_value    VARCHAR2,
23           p_excluder_flag    VARCHAR2,
24           p_uom_code    VARCHAR2,
25           p_creation_date    DATE,
26           p_created_by    NUMBER,
27           p_last_update_date    DATE,
28           p_last_updated_by    NUMBER,
29           p_last_update_login    NUMBER,
30           px_object_version_number   IN OUT NOCOPY  NUMBER);
31 
32 PROCEDURE Update_Row(
33           p_offer_adj_new_product_id    NUMBER,
34           p_offer_adj_new_line_id    NUMBER,
35           p_offer_adjustment_id      NUMBER,
36           p_product_context    VARCHAR2,
37           p_product_attribute    VARCHAR2,
38           p_product_attr_value    VARCHAR2,
39           p_excluder_flag    VARCHAR2,
40           p_uom_code    VARCHAR2,
41           p_creation_date    DATE,
42           p_created_by    NUMBER,
43           p_last_update_date    DATE,
44           p_last_updated_by    NUMBER,
45           p_last_update_login    NUMBER,
46           p_object_version_number    NUMBER);
47 
48 PROCEDURE Delete_Row(
49     p_OFFER_ADJ_NEW_PRODUCT_ID  NUMBER);
50 PROCEDURE Lock_Row(
51           p_offer_adj_new_product_id    NUMBER,
52           p_offer_adj_new_line_id    NUMBER,
53           p_offer_adjustment_id      NUMBER,
54           p_product_context    VARCHAR2,
55           p_product_attribute    VARCHAR2,
56           p_product_attr_value    VARCHAR2,
57           p_excluder_flag    VARCHAR2,
58           p_uom_code    VARCHAR2,
59           p_creation_date    DATE,
60           p_created_by    NUMBER,
61           p_last_update_date    DATE,
62           p_last_updated_by    NUMBER,
63           p_last_update_login    NUMBER,
64           p_object_version_number    NUMBER);
65 
66 END OZF_OFFER_ADJ_NEW_PRODUCTS_PKG;