DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_PVT dependencies on STANDARD

Line 411: * for same standard item. Don't add a new line and just update the quantity.

407: p_uom_code => l_uom_code);
408:
409: /*
410: * if l_list_line_tbl_index <> 0, there is already a line in x_qte_line_tbl
411: * for same standard item. Don't add a new line and just update the quantity.
412: */
413: IF l_list_line_tbl_index <> 0 THEN
414: x_list_line_tbl(l_list_line_tbl_index).quantity
415: := x_list_line_tbl(l_list_line_tbl_index).quantity + l_quantity;

Line 620: -- Standard Start of API savepoint

616: WHERE ISSR.shp_list_item_id = ISSLI.shp_list_item_id
617: AND ISSLI.shp_list_id = l_shp_list_id;
618:
619: BEGIN
620: -- Standard Start of API savepoint
621: SAVEPOINT Delete_PVT;
622:
623: -- Standard call to check for call compatibility.
624: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,

Line 623: -- Standard call to check for call compatibility.

619: BEGIN
620: -- Standard Start of API savepoint
621: SAVEPOINT Delete_PVT;
622:
623: -- Standard call to check for call compatibility.
624: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
625: p_api_version,
626: L_API_NAME,
627: G_PKG_NAME )

Line 701: -- Standard check of p_commit.

697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
698: IBE_Util.Debug('IBE_Shop_List_PVT.Delete(-)');
699: END IF;
700:
701: -- Standard check of p_commit.
702: IF FND_API.To_Boolean( p_commit ) THEN
703: COMMIT WORK;
704: END IF;
705:

Line 706: -- Standard call to get message count and IF count is 1, get message info.

702: IF FND_API.To_Boolean( p_commit ) THEN
703: COMMIT WORK;
704: END IF;
705:
706: -- Standard call to get message count and IF count is 1, get message info.
707: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
708: p_count => x_msg_count ,
709: p_data => x_msg_data );
710: EXCEPTION

Line 771: -- Standard Start of API savepoint

767: WHERE IBE_SH_SHLITEM_RELS.SHP_LIST_ITEM_ID = IBE_SH_SHP_LIST_ITEMS.SHP_LIST_ITEM_ID
768: AND IBE_SH_SHP_LIST_ITEMS.SHP_LIST_ID = l_Shp_List_Id;
769:
770: BEGIN
771: -- Standard Start of API savepoint
772: SAVEPOINT Delete_All_Lines_PVT;
773:
774: -- Standard call to check for call compatibility.
775: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,

Line 774: -- Standard call to check for call compatibility.

770: BEGIN
771: -- Standard Start of API savepoint
772: SAVEPOINT Delete_All_Lines_PVT;
773:
774: -- Standard call to check for call compatibility.
775: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
776: p_api_version,
777: L_API_NAME,
778: G_PKG_NAME )

Line 852: -- Standard check of p_commit.

848: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
849: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_All_Lines(-)');
850: END IF;
851:
852: -- Standard check of p_commit.
853: IF FND_API.To_Boolean( p_commit ) THEN
854: COMMIT WORK;
855: END IF;
856:

Line 857: -- Standard call to get message count and IF count is 1, get message info.

853: IF FND_API.To_Boolean( p_commit ) THEN
854: COMMIT WORK;
855: END IF;
856:
857: -- Standard call to get message count and IF count is 1, get message info.
858: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count ,
860: p_data => x_msg_data );
861:

Line 993: -- Standard Start of API savepoint

989: l_usage_exists NUMBER;
990: l_return_value NUMBER;
991:
992: BEGIN
993: -- Standard Start of API savepoint
994: SAVEPOINT Delete_Lines_PVT;
995:
996: -- Standard call to check for call compatibility.
997: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,

Line 996: -- Standard call to check for call compatibility.

992: BEGIN
993: -- Standard Start of API savepoint
994: SAVEPOINT Delete_Lines_PVT;
995:
996: -- Standard call to check for call compatibility.
997: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
998: p_api_version,
999: L_API_NAME,
1000: G_PKG_NAME )

Line 1089: -- Standard check of p_commit.

1085: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1086: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_Lines(-)');
1087: END IF;
1088:
1089: -- Standard check of p_commit.
1090: IF FND_API.To_Boolean( p_commit ) THEN
1091: COMMIT WORK;
1092: END IF;
1093:

Line 1094: -- Standard call to get message count and IF count is 1, get message info.

1090: IF FND_API.To_Boolean( p_commit ) THEN
1091: COMMIT WORK;
1092: END IF;
1093:
1094: -- Standard call to get message count and IF count is 1, get message info.
1095: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1096: p_count => x_msg_count ,
1097: p_data => x_msg_data );
1098:

Line 1153: -- Standard Start of API savepoint

1149: l_sl_line_rel_id NUMBER;
1150: l_combine_same_item VARCHAR2(30);
1151: l_sl_line_rec SL_Line_Rec_Type;
1152: BEGIN
1153: -- Standard Start of API savepoint
1154: SAVEPOINT Save_PVT;
1155:
1156: -- Standard call to check for call compatibility.
1157: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,

Line 1156: -- Standard call to check for call compatibility.

1152: BEGIN
1153: -- Standard Start of API savepoint
1154: SAVEPOINT Save_PVT;
1155:
1156: -- Standard call to check for call compatibility.
1157: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
1158: p_api_version,
1159: L_API_NAME,
1160: G_PKG_NAME )

Line 1462: -- Standard check of p_commit.

1458: IBE_Util.Debug('IBE_Shop_List_PVT.Save(-)');
1459: END IF;
1460: --dbms_output.put_line('IBE_Shop_List_PVT.Save(-)');
1461:
1462: -- Standard check of p_commit.
1463: IF FND_API.To_Boolean( p_commit ) THEN
1464: COMMIT WORK;
1465: END IF;
1466:

Line 1467: -- Standard call to get message count and IF count is 1, get message info.

1463: IF FND_API.To_Boolean( p_commit ) THEN
1464: COMMIT WORK;
1465: END IF;
1466:
1467: -- Standard call to get message count and IF count is 1, get message info.
1468: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1469: p_count => x_msg_count ,
1470: p_data => x_msg_data );
1471:

Line 1584: -- Standard call to get message count and IF count is 1, get message info.

1580: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1581: IBE_Util.Debug('IBE_Shop_List_PVT.Update_Config_Item_Lines(-)');
1582: END IF;
1583:
1584: -- Standard call to get message count and IF count is 1, get message info.
1585: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1586: p_count => x_msg_count ,
1587: p_data => x_msg_data );
1588:

Line 1643: -- Standard Start of API savepoint

1639: l_sl_line_tbl SL_Line_Tbl_Type;
1640: l_sl_line_rel_tbl SL_Line_Rel_Tbl_Type;
1641: l_qte_line_relation_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
1642: BEGIN
1643: -- Standard Start of API savepoint
1644: SAVEPOINT Save_List_From_Items_PVT;
1645:
1646: -- Standard call to check for call compatibility.
1647: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,

Line 1646: -- Standard call to check for call compatibility.

1642: BEGIN
1643: -- Standard Start of API savepoint
1644: SAVEPOINT Save_List_From_Items_PVT;
1645:
1646: -- Standard call to check for call compatibility.
1647: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
1648: p_api_version,
1649: L_API_NAME,
1650: G_PKG_NAME)

Line 1808: -- Standard check of p_commit.

1804: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Items(-)');
1805: END IF;
1806: --dbms_output.put_line('IBE_Shop_List_PVT.Save_List_From_Items(-)');
1807:
1808: -- Standard check of p_commit.
1809: IF FND_API.To_Boolean( p_commit ) THEN
1810: COMMIT WORK;
1811: END IF;
1812:

Line 1813: -- Standard call to get message count and IF count is 1, get message info.

1809: IF FND_API.To_Boolean( p_commit ) THEN
1810: COMMIT WORK;
1811: END IF;
1812:
1813: -- Standard call to get message count and IF count is 1, get message info.
1814: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1815: p_count => x_msg_count ,
1816: p_data => x_msg_data );
1817: EXCEPTION

Line 1922: -- Standard Start of API savepoint

1918: l_PRGchildren_lineId_tbl jtf_number_table := jtf_number_table();
1919: l_checkPRGChild NUMBER := 0;
1920:
1921: BEGIN
1922: -- Standard Start of API savepoint
1923: SAVEPOINT Save_List_From_Quote_PVT;
1924:
1925: -- Standard call to check for call compatibility.
1926: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,

Line 1925: -- Standard call to check for call compatibility.

1921: BEGIN
1922: -- Standard Start of API savepoint
1923: SAVEPOINT Save_List_From_Quote_PVT;
1924:
1925: -- Standard call to check for call compatibility.
1926: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
1927: p_api_version,
1928: L_API_NAME,
1929: G_PKG_NAME )

Line 2303: -- Standard check of p_commit.

2299: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2300: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Quote(-)');
2301: END IF;
2302:
2303: -- Standard check of p_commit.
2304: IF FND_API.To_Boolean( p_commit ) THEN
2305: COMMIT WORK;
2306: END IF;
2307:

Line 2308: -- Standard call to get message count and IF count is 1, get message info.

2304: IF FND_API.To_Boolean( p_commit ) THEN
2305: COMMIT WORK;
2306: END IF;
2307:
2308: -- Standard call to get message count and IF count is 1, get message info.
2309: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2310: p_count => x_msg_count ,
2311: p_data => x_msg_data );
2312:

Line 2472: * for same standard item. Don't add a new line and just update the quantity.

2468: p_uom_code => l_uom_code);
2469:
2470: /*
2471: * if l_qte_line_tbl_index <> 0, there is already a line in x_qte_line_tbl
2472: * for same standard item. Don't add a new line and just update the quantity.
2473: */
2474: IF l_qte_line_tbl_index <> 0 THEN
2475: x_qte_line_tbl(l_qte_line_tbl_index).quantity
2476: := x_qte_line_tbl(l_qte_line_tbl_index).quantity + l_quantity;

Line 2655: x_ql_line_codes(x_ql_line_codes.LAST) := IBE_QUOTE_SAVE_PVT.STANDARD_LINE_CODE;

2651: elsif (l_item_type_code = 'STD') then
2652: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2653: IBE_Util.Debug('l_item_type_code=STD!');
2654: END IF;
2655: x_ql_line_codes(x_ql_line_codes.LAST) := IBE_QUOTE_SAVE_PVT.STANDARD_LINE_CODE;
2656: end if;
2657:
2658: END IF; -- if (l_item_type_code <> 'SRV') then
2659: END LOOP;

Line 2738: -- Standard Start of API savepoint

2734: AND name = p_promocode;
2735:
2736: l_pricing_attribute1 varchar2(240);
2737: BEGIN
2738: -- Standard Start of API savepoint
2739: SAVEPOINT Save_Quote_From_List_Items_PVT;
2740:
2741: -- Standard call to check for call compatibility.
2742: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,

Line 2741: -- Standard call to check for call compatibility.

2737: BEGIN
2738: -- Standard Start of API savepoint
2739: SAVEPOINT Save_Quote_From_List_Items_PVT;
2740:
2741: -- Standard call to check for call compatibility.
2742: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
2743: p_api_version,
2744: L_API_NAME,
2745: G_PKG_NAME )

Line 3034: -- Standard check of p_commit.

3030: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3031: IBE_Util.Debug('IBE_Shop_List_PVT.Save_Quote_From_List_Items(-)');
3032: END IF;
3033:
3034: -- Standard check of p_commit.
3035: IF FND_API.To_Boolean( p_commit ) THEN
3036: COMMIT WORK;
3037: END IF;
3038:

Line 3039: -- Standard call to get message count and IF count is 1, get message info.

3035: IF FND_API.To_Boolean( p_commit ) THEN
3036: COMMIT WORK;
3037: END IF;
3038:
3039: -- Standard call to get message count and IF count is 1, get message info.
3040: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3041: p_count => x_msg_count ,
3042: p_data => x_msg_data );
3043: