[Home] [Help]
PACKAGE: APPS.OZF_CREATE_OZF_PROD_LINE_PKG
Source
1 PACKAGE OZF_Create_Ozf_Prod_Line_PKG AUTHID CURRENT_USER AS
2 /* $Header: ozftodps.pls 120.0 2005/06/01 01:26:45 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Create_Ozf_Prod_Line_PKG
7 -- Purpose
8 --
9 -- History
10 -- Wed May 18 2005:11/52 AM RSSHARMA Added Insert_row and Update_row methods for Volume Offer
11
12 -- NOTE
13 --
14 -- This Api is generated with Latest version of
15 -- Rosetta, where g_miss indicates NULL and
16 -- NULL indicates missing value. Rosetta Version 1.55
17 -- End of Comments
18 -- ===============================================================
19
20
21
22
23 -- ========================================================
24 --
25 -- NAME
26 -- Insert_Row
27 --
28 -- PURPOSE
29 --
30 -- NOTES
31 --
32 -- HISTORY
33 --
34 -- ========================================================
35 PROCEDURE Insert_Row(
36 px_off_discount_product_id IN OUT NOCOPY NUMBER,
37 p_parent_off_disc_prod_id IN NUMBER,
38 p_product_level VARCHAR2,
39 p_product_id NUMBER,
40 p_excluder_flag VARCHAR2,
41 p_uom_code VARCHAR2,
42 p_start_date_active DATE,
43 p_end_date_active DATE,
44 p_offer_discount_line_id NUMBER,
45 p_offer_id NUMBER,
46 p_creation_date DATE,
47 p_created_by NUMBER,
48 p_last_update_date DATE,
49 p_last_updated_by NUMBER,
50 p_last_update_login NUMBER,
51 px_object_version_number IN OUT NOCOPY NUMBER);
52
53
54 -- ========================================================
55 --
56 -- NAME
57 -- Insert_Row for volume_offer
58 --
59 -- PURPOSE Insert Row for release 12 Volume Offers
60 --
61 -- NOTES
62 --
63 -- HISTORY
64 --
65 -- ========================================================
66 PROCEDURE Insert_Row(
67 px_off_discount_product_id IN OUT NOCOPY NUMBER,
68 p_parent_off_disc_prod_id IN NUMBER,
69 p_product_level VARCHAR2,
70 p_product_id NUMBER,
71 p_excluder_flag VARCHAR2,
72 p_uom_code VARCHAR2,
73 p_start_date_active DATE,
74 p_end_date_active DATE,
75 p_offer_discount_line_id NUMBER,
76 p_offer_id NUMBER,
77 p_creation_date DATE,
78 p_created_by NUMBER,
79 p_last_update_date DATE,
80 p_last_updated_by NUMBER,
81 p_last_update_login NUMBER,
82 p_product_context VARCHAR2,
83 p_product_attribute VARCHAR2,
84 p_product_attr_value VARCHAR2,
85 p_apply_discount_flag VARCHAR2,
86 p_include_volume_flag VARCHAR2,
87 px_object_version_number IN OUT NOCOPY NUMBER);
88
89
90
91
92 -- ========================================================
93 --
94 -- NAME
95 -- Update_Row
96 --
97 -- PURPOSE
98 --
99 -- NOTES
100 --
101 -- HISTORY
102 --
103 -- ========================================================
104 PROCEDURE Update_Row(
105 p_off_discount_product_id NUMBER,
106 p_parent_off_disc_prod_id NUMBER,
107 p_product_level VARCHAR2,
108 p_product_id NUMBER,
109 p_excluder_flag VARCHAR2,
110 p_uom_code VARCHAR2,
111 p_start_date_active DATE,
112 p_end_date_active DATE,
113 p_offer_discount_line_id NUMBER,
114 p_offer_id NUMBER,
115 p_last_update_date DATE,
116 p_last_updated_by NUMBER,
117 p_last_update_login NUMBER,
118 p_object_version_number IN NUMBER
119 );
120
121 -- ========================================================
122 --
123 -- NAME
124 -- Update_Row for volume_offer
125 --
126 -- PURPOSE Update Row for release 12 Volume Offers
127 --
128 -- NOTES
129 --
130 -- HISTORY
131 --
132 -- ========================================================
133 PROCEDURE Update_Row(
134 p_off_discount_product_id NUMBER,
135 p_parent_off_disc_prod_id NUMBER,
136 p_product_level VARCHAR2,
137 p_product_id NUMBER,
138 p_excluder_flag VARCHAR2,
139 p_uom_code VARCHAR2,
140 p_start_date_active DATE,
141 p_end_date_active DATE,
142 p_offer_discount_line_id NUMBER,
143 p_offer_id NUMBER,
144 p_last_update_date DATE,
145 p_last_updated_by NUMBER,
146 p_last_update_login NUMBER,
147 p_product_context VARCHAR2,
148 p_product_attribute VARCHAR2,
149 p_product_attr_value VARCHAR2,
150 p_apply_discount_flag VARCHAR2,
151 p_include_volume_flag VARCHAR2,
152 p_object_version_number IN NUMBER);
153
154
155 -- ========================================================
156 --
157 -- NAME
158 -- Delete_Row
159 --
160 -- PURPOSE
161 --
162 -- NOTES
163 --
164 -- HISTORY
165 --
166 -- ========================================================
167 PROCEDURE Delete_Row(
168 p_off_discount_product_id NUMBER,
169 p_object_version_number NUMBER);
170
171 PROCEDURE Delete_Product(
172 p_offer_discount_line_id NUMBER
173 );
174
175
176 -- ========================================================
177 --
178 -- NAME
179 -- Lock_Row
180 --
181 -- PURPOSE
182 --
183 -- NOTES
184 --
185 -- HISTORY
186 --
187 -- ========================================================
188 PROCEDURE Lock_Row(
189 p_off_discount_product_id NUMBER,
190 p_object_version_number NUMBER);
191
192
193 END OZF_Create_Ozf_Prod_Line_PKG;