DBA Data[Home] [Help]

APPS.OE_PORTAL_UTIL SQL Statements

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

Line: 54

   elsif p_x_line_tbl(1).operation = OE_GLOBALS.G_OPR_UPDATE THEN
        oe_oe_form_line.Get_line
        (	p_db_record 		=> TRUE
	,       p_line_id 		=> p_x_line_tbl(1).line_id
	,       x_line_rec		=> l_old_line_tbl(1)
	);
Line: 106

  select default_inbound_line_type_id,
         default_outbound_line_type_id
  into   ONT_HEADER_Def_Util.g_cached_record.default_inbound_line_type_id,
         ONT_HEADER_Def_Util.g_cached_record.default_outbound_line_type_id
  from oe_order_types_v
  where order_type_id=p_header_rec.order_type_id;