APPS.OE_PROFILE SQL Statements

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

Line: 309

	    SELECT created_by, org_id
	    INTO l_cached_user_id, l_cached_org_id
	    FROM oe_order_headers_all
	    WHERE header_id = p_header_id;

Line: 316

	    SELECT created_by, org_id
	    INTO l_cached_user_id, l_cached_org_id
	    FROM oe_order_lines_all
	    WHERE line_id = p_line_id;

Line: 647

          Header_Context_Tbl.Delete(I);

Line: 649

            oe_debug_pub.add('deleted the record at position 1 with index: ' || I);

Line: 717

          Line_Context_Tbl.Delete(I);

Line: 719

            oe_debug_pub.add('deleted the record at position 1 with index: ' || I);

Line: 900

	  Prf_Tbl.Delete(I);

Line: 902

            oe_debug_pub.add('deleted the record at position 1 with index: ' || I);