DBA Data[Home] [Help]

APPS.AS_FOUNDATION_PVT dependencies on FND_API

Line 208: := FND_API.G_FALSE,

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,

Line 210: := FND_API.G_VALID_LEVEL_FULL,

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,

Line 246: := FND_API.G_FALSE,

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,

Line 248: := FND_API.G_VALID_LEVEL_FULL,

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,

Line 365: -- Default = FND_API.G_FALSE

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)

Line 392: := FND_API.G_FALSE,

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,

Line 395: := FND_API.G_VALID_LEVEL_FULL,

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,

Line 435: -- Default = FND_API.G_FALSE

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 :

Line 459: := FND_API.G_FALSE,

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,

Line 462: := FND_API.G_VALID_LEVEL_FULL,

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,

Line 481: -- Default = FND_API.G_FALSE

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 :

Line 496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 514: -- Default FND_API.G_FALSE

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,

Line 516: -- Default FND_API.G_VALID_LEVEL_FULL

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,

Line 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)

Line 535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 538: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 560: -- := FND_API.G_FALSE

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

Line 562: -- := FND_API.G_VALID_LEVEL_FULL

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

Line 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

Line 569: -- DEFAULT FND_API.G_MISS_NUM

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

Line 571: -- 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
574: -- x_msg_data OUT VARCHAR2
575: -- x_vol_tolerance_margin OUT NUMBER

Line 595: -- x_vol_tolerance_margin to x_price will be NULL and x_return_status is FND_API.G_RET_STS_SUCCESS.

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,

Line 598: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 601: p_secondary_interest_code_id 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,

Line 603: p_volume IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 604: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,