APPS.IBE_SHOP_LIST_HEADER_PKG dependencies on IBE_SH_SHP_LISTS_ALL

Line 45: INSERT INTO ibe_sh_shp_lists_all(

41: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
42: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Insert row');
43: END IF;
44:
45: INSERT INTO ibe_sh_shp_lists_all(
46: shp_list_id,
47: request_id,
48: program_application_id,
49: program_id,

Line 159: UPDATE ibe_sh_shp_lists_all

155: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
156: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Update row');
157: END IF;
158:
159: UPDATE ibe_sh_shp_lists_all
160: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
161: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
162: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
163: program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),

Line 213: FROM ibe_sh_shp_lists_all

209: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.delete row');
210: END IF;
211:
212: DELETE
213: FROM ibe_sh_shp_lists_all
214: WHERE shp_list_id = p_shp_list_id
215: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);
216:
217: IF (SQL%NOTFOUND) THEN