APPS.IBE_SHOP_LIST_MGMT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

   p_last_update_date         IN  DATE     := FND_API.G_MISS_DATE,
   p_mode                     IN  VARCHAR2 := 'MERGE'            ,
   p_combine_same_item        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_sl_header_rec            IN  IBE_Shop_List_PVT.SL_Header_Rec_Type             ,
   x_sl_header_id             OUT NOCOPY NUMBER                               ,
   p_item_type_code           IN JTF_Varchar2_Table_100
) IS

l_sl_line_tbl                 IBE_Shop_List_PVT.SL_Line_Tbl_Type
                                    := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;

Line: 71

   p_last_update_date         IN  DATE     := FND_API.G_MISS_DATE,
   p_mode                     IN  VARCHAR2 := 'MERGE'            ,
   p_combine_same_item        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_party_id				  IN  NUMBER                         ,
   p_cust_account_id		  IN  NUMBER                         ,
   p_shopping_list_name	      IN  VARCHAR2                       ,
   p_list_description		  IN  VARCHAR2 := FND_API.G_MISS_CHAR,

   x_sl_header_id             OUT NOCOPY NUMBER            ,
   p_item_type_code        IN JTF_Varchar2_Table_100
) IS
p_sl_header_rec   IBE_Shop_List_PVT.SL_Header_Rec_Type := IBE_Shop_List_PVT.G_MISS_SL_HEADER_REC;

Line: 105

	     p_last_update_date         => p_last_update_date ,
	     p_mode                     => p_mode            ,
	     p_combine_same_item        => p_combine_same_item ,
	     p_sl_header_rec            => p_sl_header_rec     ,
	     x_sl_header_id             => x_sl_header_id     ,
       p_item_type_code           => p_item_type_code
      );

Line: 127

   p_last_update_date         IN  DATE     := FND_API.G_MISS_DATE,
   p_mode                     IN  VARCHAR2 := 'MERGE'            ,
   p_combine_same_item        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_party_id				  IN  NUMBER                         ,
   p_cust_account_id		  IN  NUMBER                         ,
   p_shopping_list_name	      IN  VARCHAR2                       ,
   p_list_description		  IN  VARCHAR2 := FND_API.G_MISS_CHAR,

   x_sl_header_id             OUT NOCOPY NUMBER,
   p_shp_list_id             IN  NUMBER         ,
   p_item_type_code        IN JTF_Varchar2_Table_100

) IS
p_sl_header_rec   IBE_Shop_List_PVT.SL_Header_Rec_Type := IBE_Shop_List_PVT.G_MISS_SL_HEADER_REC;

Line: 164

	     p_last_update_date         => p_last_update_date ,
	     p_mode                     => p_mode            ,
	     p_combine_same_item        => p_combine_same_item ,
	     p_sl_header_rec            => p_sl_header_rec     ,
	     x_sl_header_id             => x_sl_header_id      ,
       p_item_type_code           => p_item_type_code
       );