DBA Data[Home] [Help]

APPS.AMS_PRICE_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 152: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

148: PROCEDURE GetPrices(
149: p_price_list_id IN NUMBER
150: ,p_currency_code IN VARCHAR2
151: ,p_item_tbl IN JTF_NUMBER_TABLE
152: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
153: -- ,p_calculate_flag IN CHAR(1) :='Y'
154: ,p_request_type_code IN VARCHAR2
155: ,p_pricing_event IN VARCHAR2
156: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE

Line 158: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

154: ,p_request_type_code IN VARCHAR2
155: ,p_pricing_event IN VARCHAR2
156: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
157: ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
158: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
159: ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
160: ,x_return_status out NOCOPY VARCHAR2
161: ,x_return_status_text out NOCOPY VARCHAR2
162:

Line 171: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

167: p_party_id IN NUMBER
168: ,p_cust_account_id IN NUMBER
169: ,p_currency_code IN VARCHAR2
170: ,p_item_tbl IN JTF_NUMBER_TABLE
171: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
172: -- ,p_calculate_flag IN CHAR(1) :='Y'
173: ,p_request_type_code IN VARCHAR2
174: ,p_pricing_event IN VARCHAR2
175: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE

Line 177: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

173: ,p_request_type_code IN VARCHAR2
174: ,p_pricing_event IN VARCHAR2
175: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
176: ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
177: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
178: ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
179: ,x_return_status OUT NOCOPY VARCHAR2
180: ,x_return_status_text OUT NOCOPY VARCHAR2
181:

Line 192: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

188: ,p_party_id IN NUMBER
189: ,p_cust_account_id IN NUMBER
190: ,p_currency_code IN VARCHAR2
191: ,p_item_tbl IN JTF_NUMBER_TABLE
192: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
193: -- ,p_calculate_flag IN CHAR(1) :='Y'
194: ,p_request_type_code IN VARCHAR2
195: ,p_pricing_event IN VARCHAR2
196: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE

Line 198: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

194: ,p_request_type_code IN VARCHAR2
195: ,p_pricing_event IN VARCHAR2
196: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
197: ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
198: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
199: ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
200: ,x_return_status out NOCOPY VARCHAR2
201: ,x_return_status_text out NOCOPY VARCHAR2
202:

Line 211: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

207: PROCEDURE GetPrices(
208: p_price_list_id IN NUMBER
209: ,p_currency_code IN VARCHAR2
210: ,p_item_tbl IN JTF_NUMBER_TABLE
211: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
212: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
213: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
214: -- ,p_calculate_flag IN CHAR(1) :='Y'
215: ,p_request_type_code IN VARCHAR2

Line 219: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

215: ,p_request_type_code IN VARCHAR2
216: ,p_pricing_event IN VARCHAR2
217: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
218: ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
219: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
220: ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
221: ,x_parentIndex_tbl out NOCOPY JTF_NUMBER_TABLE
222: ,x_childIndex_tbl out NOCOPY JTF_NUMBER_TABLE
223: ,x_return_status out NOCOPY VARCHAR2

Line 236: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

232: p_party_id IN NUMBER
233: ,p_cust_account_id IN number
234: ,p_currency_code IN VARCHAR2
235: ,p_item_tbl IN JTF_NUMBER_TABLE
236: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
237: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
238: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
239: -- ,p_calculate_flag IN CHAR(1) :='Y'
240: ,p_request_type_code IN VARCHAR2

Line 244: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

240: ,p_request_type_code IN VARCHAR2
241: ,p_pricing_event IN VARCHAR2
242: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
243: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
244: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
245: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
246: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
247: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
248: ,x_return_status out nocopy varchar2

Line 261: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

257: ,p_party_id IN NUMBER
258: ,p_cust_account_id IN number
259: ,p_currency_code IN VARCHAR2
260: ,p_item_tbl IN JTF_NUMBER_TABLE
261: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
262: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
263: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
264: -- ,p_calculate_flag IN CHAR(1) :='Y'
265: ,p_request_type_code IN VARCHAR2

Line 269: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

265: ,p_request_type_code IN VARCHAR2
266: ,p_pricing_event IN VARCHAR2
267: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
268: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
269: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
270: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
271: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
272: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
273: ,x_return_status out nocopy varchar2