[Home] [Help]
93: l_order_by_clause VARCHAR2(2000) := NULL;
94: l_api_name CONSTANT VARCHAR2(30) := 'Translate_OrderBy';
95: l_api_version_number CONSTANT NUMBER := 2.0;
96: begin
97: -- Standard call to check for call compatibility.
98: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
99: p_api_version_number,
100: l_api_name,
101: G_PKG_NAME)
317: l_end_date DATE;
318: i BINARY_INTEGER := 0;
319:
320: begin
321: -- Standard call to check for call compatibility.
322: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
323: p_api_version_number,
324: l_api_name,
325: G_PKG_NAME)
659: -- Local return statuses
660: l_return_status Varchar2(1);
661:
662: BEGIN
663: -- Standard call to check for call compatibility.
664: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
665: p_api_version_number,
666: l_api_name,
667: G_PKG_NAME)
827: -- THEN
828: -- dbms_output.put_line('AS_Foundation_PVT.Get_inventory_items: End');
829: -- END IF;
830:
831: -- Standard call to get message count and if count is 1, get message info.
832: FND_MSG_PUB.Count_And_Get
833: ( p_count => x_msg_count,
834: p_data => x_msg_data
835: );
979: l_list_price Number;
980: l_currency_code Varchar2(30);
981:
982: BEGIN
983: -- Standard call to check for call compatibility.
984: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
985: p_api_version_number,
986: l_api_name,
987: G_PKG_NAME)
1106: --THEN
1107: -- dbms_output.put_line('AS_Foundation_PVT.Get_inventory_itemPrice: End');
1108: -- END IF;
1109:
1110: -- Standard call to get message count and if count is 1, get message info.
1111: FND_MSG_PUB.Count_And_Get
1112: ( p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );
1193: l_return_status Varchar2(1);
1194: l_price_list_id Number;
1195:
1196: BEGIN
1197: -- Standard call to check for call compatibility.
1198: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1199: p_api_version_number,
1200: l_api_name,
1201: G_PKG_NAME)
1264: -- THEN
1265: -- dbms_output.put_line('AS_Foundation_PVT.Get_Price_List_Id: End');
1266: -- END IF;
1267:
1268: -- Standard call to get message count and if count is 1, get message info.
1269: FND_MSG_PUB.Count_And_Get
1270: ( p_count => x_msg_count,
1271: p_data => x_msg_data
1272: );
1338: l_price_list_id Number;
1339: l_price Number;
1340: l_currency_code VARCHAR2(15);
1341: BEGIN
1342: -- Standard call to check for call compatibility.
1343: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1344: p_api_version_number,
1345: l_api_name,
1346: G_PKG_NAME)
1435: -- THEN
1436: -- dbms_output.put_line('AS_Foundation_PVT.Get_Price_Info: End');
1437: -- END IF;
1438:
1439: -- Standard call to get message count and if count is 1, get message info.
1440: FND_MSG_PUB.Count_And_Get
1441: ( p_count => x_msg_count,
1442: p_data => x_msg_data
1443: );
1560: l_amount_floor NUMBER;
1561: l_amount_ceiling NUMBER;
1562: l_vol_tolerance_margin NUMBER := TO_NUMBER(NVL(FND_PROFILE.Value('AS_PRICE_VOLUME_TOLERANCE_MARGIN'),'100'));
1563: BEGIN
1564: -- Standard call to check for call compatibility.
1565: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1566: p_api_version_number,
1567: l_api_name,
1568: G_PKG_NAME) THEN
1719: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1720: -- dbms_output.put_line('AS_Foundation_PVT.Check_Volume_Amount: End');
1721: -- END IF;
1722:
1723: -- Standard call to get message count and if count is 1, get message info.
1724: FND_MSG_PUB.Count_And_Get
1725: ( p_count => x_msg_count,
1726: p_data => x_msg_data
1727: );