DBA Data[Home] [Help]

APPS.IBE_PRICE_PVT dependencies on FND_API

Line 13: ,p_price_list_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 14: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 15: ,p_cust_account_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:

Line 18: ,p_model_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:
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

Line 27: p_party_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 28: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 29: ,p_price_list_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:

Line 32: --,p_model_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:
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

Line 45: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 46: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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:

Line 68: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 69: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 94: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 95: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 118: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 119: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 149: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 150: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 182: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 183: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 214: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 215: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 242: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 243: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 272: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 273: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 300: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 301: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 334: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 335: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 368: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 369: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 395: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 396: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 397: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 415: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 416: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 417: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM

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