APPS.IBE_SHOP_LIST_LINE_PKG dependencies on IBE_SHP_LIST_ITEMS_ALL

Line 60: INSERT INTO ibe_shp_list_items_all(

56: BEGIN
57: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
58: IBE_Util.Debug('start IBE_Shop_List_LINE_PKG.Insert row');
59: END IF;
60: INSERT INTO ibe_shp_list_items_all(
61: shp_list_item_id,
62: request_id,
63: program_application_id,
64: program_id,

Line 193: UPDATE ibe_shp_list_items_all

189: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
190: IBE_Util.Debug('Start IBE_Shop_List_line_PKG.update_row');
191: END IF;
192:
193: UPDATE ibe_shp_list_items_all
194: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
195: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
196: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
197: program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),

Line 252: FROM ibe_shp_list_items_all

248: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
249: IBE_Util.Debug('start IBE_Shop_List_line_PKG.delete row');
250: END IF;
251: DELETE
252: FROM ibe_shp_list_items_all
253: WHERE shp_list_item_id = p_shp_list_item_id
254: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);
255:
256: IF (SQL%NOTFOUND) THEN