[Home] [Help]
PACKAGE: APPS.OZF_PRICELIST_PVT
Source
1 PACKAGE OZF_PRICELIST_PVT AS
2 /* $Header: ozfvplts.pls 120.1 2005/08/17 17:56:39 appldev ship $ */
3
4 -- start of comment
5 -- History
6 -- 19-MAY-2001 julou modified added primary_uom_flag to Price_List_Line_Rec_Type
7 -- 22-Oct-2002 Added Currency_header_id for multi currency support
8 -- 09-SEP-2004 julou bug 3863693: expose flex field
9 -- end of comment
10
11 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_pricelist_PVT';
12
13 TYPE OZF_Price_List_Rec_Type IS RECORD
14 ( currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
15 , end_date_active DATE := FND_API.G_MISS_DATE
16 , list_header_id NUMBER := FND_API.G_MISS_NUM
17 , start_date_active DATE := FND_API.G_MISS_DATE
18 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
19 , name VARCHAR2(240) := FND_API.G_MISS_CHAR
20 , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
21 , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
22 , PRICE_LIST_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
23 , USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM
24 , CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
25 , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26 , OWNER_ID NUMBER := FND_API.G_MISS_NUM
27 , QP_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM
28 , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
29 , STATUS_DATE DATE := FND_API.G_MISS_DATE
30 , WF_ITEM_KEY VARCHAR2(100) := FND_API.G_MISS_CHAR
31 , currency_header_id NUMBER := FND_API.G_MISS_NUM
32 , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
33 , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
34 , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
35 , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
36 , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
37 , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
38 , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
39 , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
40 , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
41 , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
42 , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
43 , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
44 , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
45 , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
46 , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
47 , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
48 , global_flag VARCHAR2(1) := Fnd_Api.g_miss_char
49 , org_id NUMBER := FND_API.G_MISS_NUM
50 );
51
52 TYPE Qualifiers_Rec_Type IS RECORD
53 ( comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54 , created_by NUMBER := FND_API.G_MISS_NUM
55 , end_date_active DATE := FND_API.G_MISS_DATE
56 , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57 , list_header_id NUMBER := FND_API.G_MISS_NUM
58 , list_line_id NUMBER := FND_API.G_MISS_NUM
59 , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
60 , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
61 , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
62 , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
63 , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
64 , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
65 , qualifier_id NUMBER := FND_API.G_MISS_NUM
66 , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
67 , start_date_active DATE := FND_API.G_MISS_DATE
68 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
69 , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
70 , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
71 , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
72 , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
73 , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
74 , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
75 , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
76 , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
77 , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
78 , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
79 , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
80 , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
81 , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
82 , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
83 , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
84 , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
85 );
86
87 TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type
88 INDEX BY BINARY_INTEGER;
89
90 TYPE Price_List_Line_Rec_Type IS RECORD
91 ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
92 , end_date_active DATE := FND_API.G_MISS_DATE
93 , list_header_id NUMBER := FND_API.G_MISS_NUM
94 , list_line_id NUMBER := FND_API.G_MISS_NUM
95 , list_price NUMBER := FND_API.G_MISS_NUM
96 , operand NUMBER := FND_API.G_MISS_NUM
97 , start_date_active DATE := FND_API.G_MISS_DATE
98 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99 , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
100 , product_precedence NUMBER := FND_API.G_MISS_NUM
101 , static_formula_id NUMBER := FND_API.G_MISS_NUM
102 , dynamic_formula_id NUMBER := FND_API.G_MISS_NUM
103 , jtf_note_id NUMBER := FND_API.G_MISS_NUM
104 , comments VARCHAR2(2000) := fnd_api.g_miss_char
105 , object_version_number NUMBER := FND_API.G_MISS_NUM
106 , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
107 , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
108 , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
109 , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
110 , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
111 , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
112 , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
113 , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
114 , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
115 , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
116 , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
117 , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
118 , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
119 , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
120 , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
121 , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
122 );
123
124 TYPE Price_List_Line_Tbl_Type IS TABLE OF Price_List_Line_Rec_Type
125 INDEX BY BINARY_INTEGER;
126
127 TYPE Pricing_Attr_Rec_Type IS RECORD
128 ( list_line_id NUMBER := FND_API.G_MISS_NUM
129 , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
130 , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
131 , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
132 , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
133 , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
134 , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
135 , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
136 , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
137 , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
138 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
139 , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
140 , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141 , list_header_id NUMBER := FND_API.G_MISS_NUM
142 );
143
144 TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
145 INDEX BY BINARY_INTEGER;
146
147 PROCEDURE process_price_list(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
150 p_commit IN VARCHAR2 := FND_API.g_false,
151 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_price_list_rec IN ozf_price_list_rec_type,
156 p_price_list_line_tbl IN price_list_line_tbl_type,
157 p_pricing_attr_tbl IN pricing_attr_tbl_type,
158 p_qualifiers_tbl IN QUALIFIERS_TBL_TYPE,
159 x_list_header_id OUT NOCOPY NUMBER,
160 x_error_source OUT NOCOPY VARCHAR2,
161 x_error_location OUT NOCOPY NUMBER
162 );
163
164 PROCEDURE move_segments (
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
167 p_commit IN VARCHAR2 := FND_API.g_false,
168 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_price_list_id IN NUMBER
173 );
174
175 FUNCTION get_product_name
176 ( p_type IN VARCHAR2,
177 p_prod_value IN NUMBER
178 ) RETURN VARCHAR2;
179 FUNCTION get_currency_header_name
180 ( p_currency_header_id IN NUMBER
181 ) RETURN VARCHAR2;
182
183 TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
184
185 PROCEDURE add_inventory_item(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
188 p_commit IN VARCHAR2 := FND_API.g_false,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_org_inv_item_id IN NUMBER,
193 p_new_inv_item_id IN num_tbl_type
194 );
195 END OZF_PRICELIST_PVT;