9: -- test part--
10: Procedure getReqLineAttrAndQual(
11: p_inventory_item_id IN NUMBER
12: ,p_uom_code IN VARCHAR2
13: ,p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
14: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
15: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
16:
17: --gzhang 12/03/01 model bundle
10: Procedure getReqLineAttrAndQual(
11: p_inventory_item_id IN NUMBER
12: ,p_uom_code IN VARCHAR2
13: ,p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
14: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
15: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
16:
17: --gzhang 12/03/01 model bundle
18: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
11: p_inventory_item_id IN NUMBER
12: ,p_uom_code IN VARCHAR2
13: ,p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
14: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
15: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
16:
17: --gzhang 12/03/01 model bundle
18: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
19:
14: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
15: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
16:
17: --gzhang 12/03/01 model bundle
18: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
19:
20: ,p_line_index IN NUMBER
21: ,p_request_type_code IN VARCHAR2
22: ,px_req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
23: ,px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.qual_TBL_TYPE
24: );
25:
26: Procedure getReqHeaderAttrAndQual(
27: p_party_id IN NUMBER := FND_API.G_MISS_NUM
28: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
29: ,p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
30:
31: --gzhang 12/03/01 model bundle
24: );
25:
26: Procedure getReqHeaderAttrAndQual(
27: p_party_id IN NUMBER := FND_API.G_MISS_NUM
28: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
29: ,p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
30:
31: --gzhang 12/03/01 model bundle
32: --,p_model_id IN NUMBER := FND_API.G_MISS_NUM
25:
26: Procedure getReqHeaderAttrAndQual(
27: p_party_id IN NUMBER := FND_API.G_MISS_NUM
28: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
29: ,p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
30:
31: --gzhang 12/03/01 model bundle
32: --,p_model_id IN NUMBER := FND_API.G_MISS_NUM
33:
28: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
29: ,p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
30:
31: --gzhang 12/03/01 model bundle
32: --,p_model_id IN NUMBER := FND_API.G_MISS_NUM
33:
34: ,p_line_index IN NUMBER
35: ,p_request_type_code IN VARCHAR2
36: ,px_req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
41: PROCEDURE GetPrice(
42: p_price_list_id IN NUMBER
43:
44: --gzhang 12/03/01 model bundle
45: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
46: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
47: ,p_currency_code IN VARCHAR2
48: ,p_inventory_item_id IN NUMBER
49: ,p_uom_code IN VARCHAR2
42: p_price_list_id IN NUMBER
43:
44: --gzhang 12/03/01 model bundle
45: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
46: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
47: ,p_currency_code IN VARCHAR2
48: ,p_inventory_item_id IN NUMBER
49: ,p_uom_code IN VARCHAR2
50:
64: p_party_id IN NUMBER
65: ,p_cust_account_id IN NUMBER
66:
67: --gzhang 12/03/01 model bundle
68: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
69: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
70:
71: ,p_currency_code IN VARCHAR2
72: ,p_inventory_item_id IN NUMBER
65: ,p_cust_account_id IN NUMBER
66:
67: --gzhang 12/03/01 model bundle
68: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
69: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
70:
71: ,p_currency_code IN VARCHAR2
72: ,p_inventory_item_id IN NUMBER
73: ,p_uom_code IN VARCHAR2
90: ,p_party_id IN NUMBER
91: ,p_cust_account_id IN NUMBER
92:
93: --gzhang 12/03/01 model bundle
94: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
95: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
96:
97: ,p_currency_code IN VARCHAR2
98: ,p_inventory_item_id IN NUMBER
91: ,p_cust_account_id IN NUMBER
92:
93: --gzhang 12/03/01 model bundle
94: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
95: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
96:
97: ,p_currency_code IN VARCHAR2
98: ,p_inventory_item_id IN NUMBER
99: ,p_uom_code IN VARCHAR2
114: PROCEDURE GetPrice(
115: p_price_list_id IN NUMBER
116:
117: --gzhang 12/03/01 model bundle
118: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
119: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
120:
121: ,p_currency_code IN VARCHAR2
122: ,p_inventory_item_id IN NUMBER
115: p_price_list_id IN NUMBER
116:
117: --gzhang 12/03/01 model bundle
118: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
119: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
120:
121: ,p_currency_code IN VARCHAR2
122: ,p_inventory_item_id IN NUMBER
123: ,p_uom_code IN VARCHAR2
145: p_party_id IN NUMBER
146: ,p_cust_account_id IN NUMBER
147:
148: --gzhang 12/03/01 model bundle
149: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
150: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
151:
152: ,p_currency_code IN VARCHAR2
153: ,p_inventory_item_id IN NUMBER
146: ,p_cust_account_id IN NUMBER
147:
148: --gzhang 12/03/01 model bundle
149: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
150: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
151:
152: ,p_currency_code IN VARCHAR2
153: ,p_inventory_item_id IN NUMBER
154: ,p_uom_code IN VARCHAR2
178: ,p_party_id IN NUMBER
179: ,p_cust_account_id IN NUMBER
180:
181: --gzhang 12/03/01 model bundle
182: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
183: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
184:
185: ,p_currency_code IN VARCHAR2
186: ,p_inventory_item_id IN NUMBER
179: ,p_cust_account_id IN NUMBER
180:
181: --gzhang 12/03/01 model bundle
182: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
183: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
184:
185: ,p_currency_code IN VARCHAR2
186: ,p_inventory_item_id IN NUMBER
187: ,p_uom_code IN VARCHAR2
210: PROCEDURE GetPrices(
211: p_price_list_id IN NUMBER
212:
213: --gzhang 12/03/01 model bundle
214: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
215: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
216:
217: ,p_currency_code IN VARCHAR2
218: ,p_item_tbl IN JTF_NUMBER_TABLE
211: p_price_list_id IN NUMBER
212:
213: --gzhang 12/03/01 model bundle
214: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
215: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
216:
217: ,p_currency_code IN VARCHAR2
218: ,p_item_tbl IN JTF_NUMBER_TABLE
219: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
238: p_party_id IN NUMBER
239: ,p_cust_account_id IN NUMBER
240:
241: --gzhang 12/03/01 model bundle
242: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
243: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
244:
245: ,p_currency_code IN VARCHAR2
246: ,p_item_tbl IN JTF_NUMBER_TABLE
239: ,p_cust_account_id IN NUMBER
240:
241: --gzhang 12/03/01 model bundle
242: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
243: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
244:
245: ,p_currency_code IN VARCHAR2
246: ,p_item_tbl IN JTF_NUMBER_TABLE
247: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
268: ,p_party_id IN NUMBER
269: ,p_cust_account_id IN NUMBER
270:
271: --gzhang 12/03/01 model bundle
272: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
273: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
274:
275: ,p_currency_code IN VARCHAR2
276: ,p_item_tbl IN JTF_NUMBER_TABLE
269: ,p_cust_account_id IN NUMBER
270:
271: --gzhang 12/03/01 model bundle
272: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
273: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
274:
275: ,p_currency_code IN VARCHAR2
276: ,p_item_tbl IN JTF_NUMBER_TABLE
277: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
296: PROCEDURE GetPrices(
297: p_price_list_id IN NUMBER
298:
299: --gzhang 12/03/01 model bundle
300: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
301: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
302:
303: ,p_currency_code IN VARCHAR2
304: ,p_item_tbl IN JTF_NUMBER_TABLE
297: p_price_list_id IN NUMBER
298:
299: --gzhang 12/03/01 model bundle
300: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
301: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
302:
303: ,p_currency_code IN VARCHAR2
304: ,p_item_tbl IN JTF_NUMBER_TABLE
305: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
330: p_party_id IN NUMBER
331: ,p_cust_account_id IN number
332:
333: --gzhang 12/03/01 model bundle
334: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
335: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
336:
337: ,p_currency_code IN VARCHAR2
338: ,p_item_tbl IN JTF_NUMBER_TABLE
331: ,p_cust_account_id IN number
332:
333: --gzhang 12/03/01 model bundle
334: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
335: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
336:
337: ,p_currency_code IN VARCHAR2
338: ,p_item_tbl IN JTF_NUMBER_TABLE
339: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
364: ,p_party_id IN NUMBER
365: ,p_cust_account_id IN number
366:
367: --gzhang 12/03/01 model bundle
368: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
369: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
370:
371: ,p_currency_code IN VARCHAR2
372: ,p_item_tbl IN JTF_NUMBER_TABLE
365: ,p_cust_account_id IN number
366:
367: --gzhang 12/03/01 model bundle
368: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
369: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
370:
371: ,p_currency_code IN VARCHAR2
372: ,p_item_tbl IN JTF_NUMBER_TABLE
373: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
391:
392: );
393:
394: PROCEDURE PRICE_REQUEST(
395: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
396: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
397: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
398: ,p_currency_code IN VARCHAR2
399: ,p_minisite_id IN NUMBER := NULL
392: );
393:
394: PROCEDURE PRICE_REQUEST(
395: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
396: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
397: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
398: ,p_currency_code IN VARCHAR2
399: ,p_minisite_id IN NUMBER := NULL
400: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE
393:
394: PROCEDURE PRICE_REQUEST(
395: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
396: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
397: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
398: ,p_currency_code IN VARCHAR2
399: ,p_minisite_id IN NUMBER := NULL
400: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE
401: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
411: ,x_return_status_text OUT NOCOPY VARCHAR2
412: );
413:
414: PROCEDURE PRICE_REQUEST(
415: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
416: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
417: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
418: ,p_currency_code IN VARCHAR2
419: ,p_minisite_id IN NUMBER := NULL
412: );
413:
414: PROCEDURE PRICE_REQUEST(
415: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
416: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
417: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
418: ,p_currency_code IN VARCHAR2
419: ,p_minisite_id IN NUMBER := NULL
420: ,p_item_tbl IN JTF_NUMBER_TABLE
413:
414: PROCEDURE PRICE_REQUEST(
415: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
416: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
417: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
418: ,p_currency_code IN VARCHAR2
419: ,p_minisite_id IN NUMBER := NULL
420: ,p_item_tbl IN JTF_NUMBER_TABLE
421: ,p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100