DBA Data[Home] [Help]

APPS.AS_FOUNDATION_PVT dependencies on AS_FOUNDATION_PUB

Line 551: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,

547: := FND_API.G_FALSE,
548: p_identity_salesforce_id IN NUMBER,
549: p_validation_level IN NUMBER
550: := FND_API.G_VALID_LEVEL_FULL,
551: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,
552: x_return_status OUT NOCOPY VARCHAR2,
553: x_msg_count OUT NOCOPY NUMBER,
554: x_msg_data OUT NOCOPY VARCHAR2,
555: x_inventory_item_tbl OUT NOCOPY AS_FOUNDATION_PUB.inventory_item_TBL_TYPE) IS

Line 555: x_inventory_item_tbl OUT NOCOPY AS_FOUNDATION_PUB.inventory_item_TBL_TYPE) IS

551: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,
552: x_return_status OUT NOCOPY VARCHAR2,
553: x_msg_count OUT NOCOPY NUMBER,
554: x_msg_data OUT NOCOPY VARCHAR2,
555: x_inventory_item_tbl OUT NOCOPY AS_FOUNDATION_PUB.inventory_item_TBL_TYPE) IS
556:
557:
558: Cursor C_Get_inv_items_W_inv_id(p_inventory_item_id Number,
559: p_organization_id Number,

Line 654: l_inventory_item_rec AS_FOUNDATION_PUB.inventory_item_Rec_Type;

650:
651: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
652:
653: -- Locat tmp Variables
654: l_inventory_item_rec AS_FOUNDATION_PUB.inventory_item_Rec_Type;
655:
656: -- Local record index
657: l_cur_index Number := 0;
658:

Line 927: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,

923: := FND_API.G_FALSE,
924: p_identity_salesforce_id IN NUMBER,
925: p_validation_level IN NUMBER
926: := FND_API.G_VALID_LEVEL_FULL,
927: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,
928: p_price_list_id IN NUMBER,
929: x_return_status OUT NOCOPY VARCHAR2,
930: x_msg_count OUT NOCOPY NUMBER,
931: x_msg_data OUT NOCOPY VARCHAR2,

Line 1316: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,

1312:
1313: PROCEDURE Get_Price_Info(p_api_version_number IN NUMBER,
1314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1315: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1316: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
1317: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1318: p_currency_code IN VARCHAR2,
1319: x_return_status OUT NOCOPY VARCHAR2,
1320: x_msg_count OUT NOCOPY NUMBER,

Line 1499: -- p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE

1495: -- p_init_msg_list IN VARCHAR2
1496: -- := FND_API.G_FALSE
1497: -- p_validation_level IN NUMBER
1498: -- := FND_API.G_VALID_LEVEL_FULL
1499: -- p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE
1500: -- DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC
1501: -- p_secondary_interest_code_id IN NUMBER
1502: -- DEFAULT FND_API.G_MISS_NUM
1503: -- p_currency_code IN VARCHAR2

Line 1500: -- DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC

1496: -- := FND_API.G_FALSE
1497: -- p_validation_level IN NUMBER
1498: -- := FND_API.G_VALID_LEVEL_FULL
1499: -- p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE
1500: -- DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC
1501: -- p_secondary_interest_code_id IN NUMBER
1502: -- DEFAULT FND_API.G_MISS_NUM
1503: -- p_currency_code IN VARCHAR2
1504: -- p_volume IN NUMBER

Line 1535: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,

1531: --End of Comments
1532: PROCEDURE Check_Volume_Amount(p_api_version_number IN NUMBER,
1533: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1534: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1535: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
1536: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1537: p_currency_code IN VARCHAR2,
1538: p_volume IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1539: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1554: l_inv_item_tbl AS_FOUNDATION_PUB.Inventory_Item_tbl_type;

1550: l_api_name CONSTANT VARCHAR2(30) := 'Check_Quantity_Revenue';
1551: l_api_version_number CONSTANT NUMBER := 2.0;
1552:
1553: l_volume_forecast_enable VARCHAR2(1);
1554: l_inv_item_tbl AS_FOUNDATION_PUB.Inventory_Item_tbl_type;
1555: l_return_status VARCHAR2(1);
1556: l_msg_count NUMBER;
1557: l_msg_data VARCHAR2(2000);
1558: l_price_list_id NUMBER;

Line 1593: AS_FOUNDATION_PUB.Get_Inventory_items(

1589: -- dbms_output.put_line('AS_Foundation_PVT - AS_VOLUME_FORECASTING_ENABLED:' || l_volume_forecast_enable);
1590: -- END IF;
1591: x_vol_tolerance_margin := l_vol_tolerance_margin;
1592: IF (p_inventory_item_rec.inventory_item_id IS NOT NULL) THEN
1593: AS_FOUNDATION_PUB.Get_Inventory_items(
1594: p_api_version_number => 2.0,
1595: p_init_msg_list => FND_API.G_TRUE,
1596: p_identity_salesforce_id => NULL,
1597: p_inventory_item_rec => p_inventory_item_rec,