204:
205: PROCEDURE Translate_OrderBy
206: ( p_api_version_number IN NUMBER,
207: p_init_msg_list IN VARCHAR2
208: := FND_API.G_FALSE,
209: p_validation_level IN NUMBER
210: := FND_API.G_VALID_LEVEL_FULL,
211: p_order_by_rec IN UTIL_ORDER_BY_REC_TYPE,
212: x_order_by_clause OUT NOCOPY VARCHAR2,
206: ( p_api_version_number IN NUMBER,
207: p_init_msg_list IN VARCHAR2
208: := FND_API.G_FALSE,
209: p_validation_level IN NUMBER
210: := FND_API.G_VALID_LEVEL_FULL,
211: p_order_by_rec IN UTIL_ORDER_BY_REC_TYPE,
212: x_order_by_clause OUT NOCOPY VARCHAR2,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
242:
243: PROCEDURE Get_PeriodNames
244: ( p_api_version_number IN NUMBER,
245: p_init_msg_list IN VARCHAR2
246: := FND_API.G_FALSE,
247: p_validation_level IN NUMBER
248: := FND_API.G_VALID_LEVEL_FULL,
249: p_period_rec IN UTIL_PERIOD_REC_TYPE,
250: x_period_tbl OUT NOCOPY UTIL_PERIOD_TBL_TYPE,
244: ( p_api_version_number IN NUMBER,
245: p_init_msg_list IN VARCHAR2
246: := FND_API.G_FALSE,
247: p_validation_level IN NUMBER
248: := FND_API.G_VALID_LEVEL_FULL,
249: p_period_rec IN UTIL_PERIOD_REC_TYPE,
250: x_period_tbl OUT NOCOPY UTIL_PERIOD_TBL_TYPE,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
361: -- p_api_version_number IN NUMBER Required
362: -- p_identity_salesforce_id IN NUMBER Optional
363: -- Default = NULL
364: -- p_init_msg_list IN VARCHAR2 Optional
365: -- Default = FND_API.G_FALSE
366: -- p_inventory_item_rec IN Inventory_Item_Rec Required
367: --
368: -- OUT :
369: -- x_return_status OUT VARCHAR2(1)
388: -- considered criteria. Other fields are for viewing purpose only.
389:
390: PROCEDURE Get_inventory_items( p_api_version_number IN NUMBER,
391: p_init_msg_list IN VARCHAR2
392: := FND_API.G_FALSE,
393: p_identity_salesforce_id IN NUMBER,
394: p_validation_level IN NUMBER
395: := FND_API.G_VALID_LEVEL_FULL,
396: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,
391: p_init_msg_list IN VARCHAR2
392: := FND_API.G_FALSE,
393: p_identity_salesforce_id IN NUMBER,
394: p_validation_level IN NUMBER
395: := FND_API.G_VALID_LEVEL_FULL,
396: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,
397: x_return_status OUT NOCOPY VARCHAR2,
398: x_msg_count OUT NOCOPY NUMBER,
399: x_msg_data OUT NOCOPY VARCHAR2,
431: -- p_api_version_number IN NUMBER Required
432: -- p_identity_salesforce_id IN NUMBER Optional
433: -- Default = NULL
434: -- p_init_msg_list IN VARCHAR2 Optional
435: -- Default = FND_API.G_FALSE
436: -- p_inventory_item_rec IN Inventory_Item_Rec Required
437: --
438: --
439: -- OUT :
455: -- 1. Secondary Price List is not considered.
456:
457: PROCEDURE Get_inventory_itemPrice( p_api_version_number IN NUMBER,
458: p_init_msg_list IN VARCHAR2
459: := FND_API.G_FALSE,
460: p_identity_salesforce_id IN NUMBER,
461: p_validation_level IN NUMBER
462: := FND_API.G_VALID_LEVEL_FULL,
463: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,
458: p_init_msg_list IN VARCHAR2
459: := FND_API.G_FALSE,
460: p_identity_salesforce_id IN NUMBER,
461: p_validation_level IN NUMBER
462: := FND_API.G_VALID_LEVEL_FULL,
463: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,
464: p_price_list_id IN NUMBER,
465: x_return_status OUT NOCOPY VARCHAR2,
466: x_msg_count OUT NOCOPY NUMBER,
477: -- Paramaeters :
478: -- IN :
479: -- p_api_version_number IN NUMBER Required
480: -- p_init_msg_list IN VARCHAR2 Optional
481: -- Default = FND_API.G_FALSE
482: -- p_validation_level IN NUMBER Optional
483: -- p_currency_code IN VARCHAR2 Required
484: --
485: -- OUT :
492: --
493: -- Note:
494: --
495: PROCEDURE Get_Price_List_Id(p_api_version_number IN NUMBER,
496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,
500: x_msg_data OUT NOCOPY VARCHAR2,
493: -- Note:
494: --
495: PROCEDURE Get_Price_List_Id(p_api_version_number IN NUMBER,
496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,
500: x_msg_data OUT NOCOPY VARCHAR2,
501: p_currency_code IN VARCHAR2,
510: -- Paramaeters :
511: -- IN :
512: -- p_api_version_number IN NUMBER Required
513: -- p_init_msg_list IN VARCHAR2 Optional
514: -- Default FND_API.G_FALSE
515: -- p_validation_level IN NUMBER Optional
516: -- Default FND_API.G_VALID_LEVEL_FULL
517: -- p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE Optional
518: -- Default AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
512: -- p_api_version_number IN NUMBER Required
513: -- p_init_msg_list IN VARCHAR2 Optional
514: -- Default FND_API.G_FALSE
515: -- p_validation_level IN NUMBER Optional
516: -- Default FND_API.G_VALID_LEVEL_FULL
517: -- p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE Optional
518: -- Default AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
519: -- p_secondary_interest_code_id IN NUMBER Optional
520: -- Default FND_API.G_MISS_NUM,
516: -- Default FND_API.G_VALID_LEVEL_FULL
517: -- p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE Optional
518: -- Default AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
519: -- p_secondary_interest_code_id IN NUMBER Optional
520: -- Default FND_API.G_MISS_NUM,
521: -- p_currency_code IN VARCHAR2 Required
522: --
523: -- OUT :
524: -- x_return_status OUT VARCHAR2(1)
531: --
532: -- Note:
533: --
534: PROCEDURE Get_Price_Info(p_api_version_number IN NUMBER,
535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
537: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
538: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
539: p_currency_code IN VARCHAR2,
532: -- Note:
533: --
534: PROCEDURE Get_Price_Info(p_api_version_number IN NUMBER,
535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
537: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
538: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
539: p_currency_code IN VARCHAR2,
540: x_return_status OUT NOCOPY VARCHAR2,
534: PROCEDURE Get_Price_Info(p_api_version_number IN NUMBER,
535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
537: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
538: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
539: p_currency_code IN VARCHAR2,
540: x_return_status OUT NOCOPY VARCHAR2,
541: x_msg_count OUT NOCOPY NUMBER,
542: x_msg_data OUT NOCOPY VARCHAR2,
556: -- Parameters :
557: -- IN :
558: -- p_api_version_number IN NUMBER,
559: -- p_init_msg_list IN VARCHAR2
560: -- := FND_API.G_FALSE
561: -- p_validation_level IN NUMBER
562: -- := FND_API.G_VALID_LEVEL_FULL
563: -- p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE
564: -- DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC
558: -- p_api_version_number IN NUMBER,
559: -- p_init_msg_list IN VARCHAR2
560: -- := FND_API.G_FALSE
561: -- p_validation_level IN NUMBER
562: -- := FND_API.G_VALID_LEVEL_FULL
563: -- p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE
564: -- DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC
565: -- p_secondary_interest_code_id IN NUMBER
566: -- DEFAULT FND_API.G_MISS_NUM
562: -- := FND_API.G_VALID_LEVEL_FULL
563: -- p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE
564: -- DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC
565: -- p_secondary_interest_code_id IN NUMBER
566: -- DEFAULT FND_API.G_MISS_NUM
567: -- p_currency_code IN VARCHAR2
568: -- p_volume IN NUMBER
569: -- DEFAULT FND_API.G_MISS_NUM
570: -- p_amount IN NUMBER
565: -- p_secondary_interest_code_id IN NUMBER
566: -- DEFAULT FND_API.G_MISS_NUM
567: -- p_currency_code IN VARCHAR2
568: -- p_volume IN NUMBER
569: -- DEFAULT FND_API.G_MISS_NUM
570: -- p_amount IN NUMBER
571: -- DEFAULT FND_API.G_MISS_NUM
572: -- x_return_status OUT VARCHAR2
573: -- x_msg_count OUT NUMBER
567: -- p_currency_code IN VARCHAR2
568: -- p_volume IN NUMBER
569: -- DEFAULT FND_API.G_MISS_NUM
570: -- p_amount IN NUMBER
571: -- DEFAULT FND_API.G_MISS_NUM
572: -- x_return_status OUT VARCHAR2
573: -- x_msg_count OUT NUMBER
574: -- x_msg_data OUT VARCHAR2
575: -- x_vol_tolerance_margin OUT NUMBER
591: -- 3. p_volume, p_amount and p_volume_1, p_amount_1 are two pairs of volume_amount to be checking.
592: -- But it only computs p_volume and p_amount if one of them is missed, not p_volume_1 and p_amount_1.
593: -- So, there is only one pair of volume_amount in the output parameters.
594: -- 4. If the profile value tells that the volume forecasting is disabled, all parameters from
595: -- x_vol_tolerance_margin to x_price will be NULL and x_return_status is FND_API.G_RET_STS_SUCCESS.
596: --End of Comments
597: PROCEDURE Check_Volume_Amount(p_api_version_number IN NUMBER,
598: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594: -- 4. If the profile value tells that the volume forecasting is disabled, all parameters from
595: -- x_vol_tolerance_margin to x_price will be NULL and x_return_status is FND_API.G_RET_STS_SUCCESS.
596: --End of Comments
597: PROCEDURE Check_Volume_Amount(p_api_version_number IN NUMBER,
598: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
601: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
602: p_currency_code IN VARCHAR2,
595: -- x_vol_tolerance_margin to x_price will be NULL and x_return_status is FND_API.G_RET_STS_SUCCESS.
596: --End of Comments
597: PROCEDURE Check_Volume_Amount(p_api_version_number IN NUMBER,
598: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
601: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
602: p_currency_code IN VARCHAR2,
603: p_volume IN NUMBER DEFAULT FND_API.G_MISS_NUM,
597: PROCEDURE Check_Volume_Amount(p_api_version_number IN NUMBER,
598: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
601: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
602: p_currency_code IN VARCHAR2,
603: p_volume IN NUMBER DEFAULT FND_API.G_MISS_NUM,
604: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
605: x_return_status OUT NOCOPY VARCHAR2,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
601: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
602: p_currency_code IN VARCHAR2,
603: p_volume IN NUMBER DEFAULT FND_API.G_MISS_NUM,
604: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
605: x_return_status OUT NOCOPY VARCHAR2,
606: x_msg_count OUT NOCOPY NUMBER,
607: x_msg_data OUT NOCOPY VARCHAR2,
600: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
601: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
602: p_currency_code IN VARCHAR2,
603: p_volume IN NUMBER DEFAULT FND_API.G_MISS_NUM,
604: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
605: x_return_status OUT NOCOPY VARCHAR2,
606: x_msg_count OUT NOCOPY NUMBER,
607: x_msg_data OUT NOCOPY VARCHAR2,
608: x_vol_tolerance_margin OUT NOCOPY NUMBER,