PACKAGE: APPS.OZF_OFFER_ADJ_TIER_PKG

Source

1 PACKAGE OZF_Offer_Adj_Tier_PKG AS
2 /* $Header: ozftoats.pls 120.1 2005/08/03 01:52:16 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          OZF_Offer_Adj_Tier_PKG
7 -- Purpose
8 --
9 -- History
10 --     Tue Aug 02 2005:10/45 PM RSSHARMA R12 changes.Added new Field for offer_discount_line_id
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18 
19 
20 
21 
22 --  ========================================================
23 --
24 --  NAME
25 --  Insert_Row
26 --
27 --  PURPOSE
28 --
29 --  NOTES
30 --
31 --  HISTORY
32 --
33 --  ========================================================
34 PROCEDURE Insert_Row(
35           px_offer_adjst_tier_id   IN OUT NOCOPY NUMBER,
36           p_offer_adjustment_id    NUMBER,
37           p_volume_offer_tiers_id    NUMBER,
38           p_qp_list_header_id    NUMBER,
39           p_discount_type_code    VARCHAR2,
40           p_original_discount    NUMBER,
41           p_modified_discount    NUMBER,
42           p_offer_discount_line_id NUMBER,
43           p_last_update_date    DATE,
44           p_last_updated_by    NUMBER,
45           p_creation_date    DATE,
46           p_created_by    NUMBER,
47           p_last_update_login    NUMBER,
48           px_object_version_number   IN OUT NOCOPY NUMBER);
49 
50 
51 
52 
53 
54 --  ========================================================
55 --
56 --  NAME
57 --  Update_Row
58 --
59 --  PURPOSE
60 --
61 --  NOTES
62 --
63 --  HISTORY
64 --
65 --  ========================================================
66 PROCEDURE Update_Row(
67           p_offer_adjst_tier_id    NUMBER,
68           p_offer_adjustment_id    NUMBER,
69           p_volume_offer_tiers_id    NUMBER,
70           p_qp_list_header_id    NUMBER,
71           p_discount_type_code    VARCHAR2,
72           p_original_discount    NUMBER,
73           p_modified_discount    NUMBER,
74           p_offer_discount_line_id NUMBER,
75           p_last_update_date    DATE,
76           p_last_updated_by    NUMBER,
77           p_last_update_login    NUMBER,
78           px_object_version_number   IN OUT NOCOPY NUMBER);
79 
80 
81 
82 
83 
84 --  ========================================================
85 --
86 --  NAME
87 --  Delete_Row
88 --
89 --  PURPOSE
90 --
91 --  NOTES
92 --
93 --  HISTORY
94 --
95 --  ========================================================
96 PROCEDURE Delete_Row(
97     p_offer_adjst_tier_id  NUMBER,
98     p_object_version_number  NUMBER);
99 
100 
101 
102 
103 --  ========================================================
104 --
105 --  NAME
106 --  Lock_Row
107 --
108 --  PURPOSE
109 --
110 --  NOTES
111 --
112 --  HISTORY
113 --
114 --  ========================================================
115 PROCEDURE Lock_Row(
116     p_offer_adjst_tier_id  NUMBER,
117     p_object_version_number  NUMBER);
118 
119 
120 END OZF_Offer_Adj_Tier_PKG;